1. Home
  2. Resources
  3. SAP Tables
  4. LESHP_DELIVERY_REFDATA - Reference Data for the Delivery

SAP Table LESHP_DELIVERY_REFDATA

Reference Data for the Delivery

LESHP_DELIVERY_REFDATA (Reference Data for the Delivery) 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 LESHP_DELIVERY_REFDATA to other SAP tables.

LESHP_DELIVERY_REFDATA 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
PONUM Purchasing Document Number EBELN CHAR 10 0
ITMNO Item Number of Purchasing Document EBELP NUMC 5 0
EKORG Purchasing Organization EKORG CHAR 4 0
EKGRP Purchasing Group EKGRP CHAR 3 0
BSTYP Purchasing Document Category BSTYP CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
BSART Order Type (Purchasing) BSART CHAR 4 0
BSAKZ Control indicator for purchasing document type BSAKZ CHAR 1 0
T Transport
R Purchase requisition for outline agreement
LOEKZ Asset class marked for deletion LOEKZ CHAR 1 0
X Yes
NULL No
STATU Status field string STATU_VL CHAR 10 0
BEDAT Purchase Order Date BEDAT DATS 8 0
ELIKZ "Delivery Completed" Indicator ELIKZ CHAR 1 0
X Yes
NULL No
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
WEPOS Goods Receipt Indicator WEPOS CHAR 1 0
X Yes
NULL No
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
WEBRE Indicator: GR-Based Invoice Verification WEBRE CHAR 1 0
X Yes
NULL No
EILDT Start Date for GR-Based Settlement EILDT DATS 8 0
REF_LSMENG Target Del. Quantity in VRKME: Used in SCFG as Ref. f. Check SHP_REF_LSMENG QUAN 13 3
REF_VRKME Unit of Measure for Reference Quantity REF_LSMENG SHP_REF_VRKME UNIT 3 0
UPDKZ Update indicator UPDKZ_D CHAR 1 0

LESHP_DELIVERY_REFDATA foreign key relationships

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