1. Home
  2. Resources
  3. SAP Tables
  4. LIPSRF - LIPS Reference Data

SAP Table LIPSRF

LIPS Reference Data

LIPSRF (LIPS Reference Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link LIPSRF to other SAP tables.

LIPSRF table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
HANDLE Worldwide unique key for LIPS-VBELN & LIPS_POSNR TSEGGUID_LIPS CHAR 22 0
HANDLE_OBJ Worldwide unique key for LIKP-VBELN TSEGGUID_LIKP CHAR 22 0
VBELN_VA Sales Document VBELN_VA CHAR 10 0
POSNR_VA Sales Document Item POSNR_VA NUMC 6 0
AUDAT Document Date (Date Received/Sent) AUDAT DATS 8 0
BSTNR Customer purchase order number BSTKD CHAR 35 0
BSTDT Customer purchase order date BSTDK DATS 8 0
BSARK Customer purchase order type BSARK T176 CHAR 4 0
IHREZ Your Reference IHREZ CHAR 12 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
BSTKD_E Ship-to Party's Purchase Order Number BSTKD_E CHAR 35 0
BSTDK_E Ship-to party's PO date BSTDK_E DATS 8 0
BSARK_E Ship-to party purchase order type BSARK_E T176 CHAR 4 0
IHREZ_E Ship-to party character IHREZ_E CHAR 12 0
POSEX_E Item Number of the Underlying Purchase Order POSEX_E CHAR 6 0
VBRST Customer point of consumption VBRST CHAR 14 0
USR01 Additional data field 1 for delivery schedules USR01_D CHAR 35 0
USR02 Additional data field 2 for delivery schedules USR02_D CHAR 35 0
USR03 Additional data field 3 for delivery schedules USR03_D CHAR 35 0
USR04 Additional data field 4 for delivery schedules USR04_D CHAR 10 0
USR05 Additional data field 5 for delivery schedules USR05_D CHAR 10 0
LABNK Customer number for forecast / JIT dlv. sched. LABNK CHAR 17 0
ABRDT Delivery Schedule Date ABRDT DATS 8 0
ABRVW Usage Indicator ABRVW CHAR 3 0
SUGRD Reason for material substitution SUGRD CHAR 4 0
SPE_ANZ_POS_STRU Number of Items in Item Structure /SPE/ANZ_POS_STRUC INT4 10 0
PPRCTR Partner Profit Center PPRCTR CHAR 10 0
PARGB Trading partner's business area PARGB CHAR 4 0
AUART Sales Document Type AUART CHAR 4 0
ANZ_POS_GRKOR Number of Items in Delivery Group SHP_ANZ_POS_GRKOR INT4 10 0
CHARG Batch Number CHARG_D CHAR 10 0
SPE_SHIP_COMP Ship Complete /SPE/DE_SHIP_COMP CHAR 1 0
X Yes
NULL No

LIPSRF foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LIPSRF BSARK LIPSRF MANDT T176 Sales Documents: Customer Order Types MANDT
LIPSRF BSARK LIPSRF BSARK T176 Sales Documents: Customer Order Types BSARK
LIPSRF BSARK_E LIPSRF MANDT T176 Sales Documents: Customer Order Types MANDT
LIPSRF BSARK_E LIPSRF BSARK_E T176 Sales Documents: Customer Order Types BSARK