SAP table LESHP_DELIVERY_REFDATA (Reference Data for the Delivery)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
HANDLE Worldwide unique key for LIPS-VBELN & LIPS_POSNR CHAR 22 0 TSEGGUID_LIPS
HANDLE_OBJ Worldwide unique key for LIKP-VBELN CHAR 22 0 TSEGGUID_LIKP
VBELN_VA Sales Document CHAR 10 0 VBELN_VA
POSNR_VA Sales Document Item NUMC 6 0 POSNR_VA
AUDAT Document Date (Date Received/Sent) DATS 8 0 AUDAT
BSTNR Customer Reference CHAR 35 0 BSTKD
BSTDT Customer Reference Date DATS 8 0 BSTDK
BSARK Customer Purchase Order Type CHAR 4 0 T176 BSARK
IHREZ Your Reference CHAR 12 0 IHREZ
POSEX Item Number of the Underlying Purchase Order CHAR 6 0 POSEX
BSTKD_E Ship-to Party's Customer Reference CHAR 35 0 BSTKD_E
BSTDK_E Ship-to Party's Customer Reference Date DATS 8 0 BSTDK_E
BSARK_E Ship-to Party Purchase Order Type CHAR 4 0 T176 BSARK_E
IHREZ_E Ship-to Party Character CHAR 12 0 IHREZ_E
POSEX_E Item Number of the Underlying Purchase Order CHAR 6 0 POSEX_E
VBRST Customer point of consumption CHAR 14 0 VBRST
USR01 Additional data field 1 for delivery schedules CHAR 35 0 USR01_D
USR02 Additional data field 2 for delivery schedules CHAR 35 0 USR02_D
USR03 Additional data field 3 for delivery schedules CHAR 35 0 USR03_D
USR04 Additional data field 4 for delivery schedules CHAR 10 0 USR04_D
USR05 Additional data field 5 for delivery schedules CHAR 10 0 USR05_D
LABNK Current key of delivery schedule CHAR 17 0 LABNK
ABRDT Delivery Schedule Date DATS 8 0 ABRDT
ABRVW Usage Indicator CHAR 3 0 * ABRVW
SUGRD Reason for material substitution CHAR 4 0 * SUGRD
SPE_ANZ_POS_STRU Number of Items in Item Structure INT4 10 0 /SPE/ANZ_POS_STRUC
PPRCTR Partner Profit Center CHAR 10 0 * PPRCTR
PARGB Trading partner's business area CHAR 4 0 * PARGB
AUART Sales Document Type CHAR 4 0 * AUART
ANZ_POS_GRKOR Number of Items in Delivery Group INT4 10 0 SHP_ANZ_POS_GRKOR
CHARG Batch Number CHAR 10 0 * CHARG_D
SPE_SHIP_COMP Ship Complete CHAR 1 0 /SPE/DE_SHIP_COMP
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
PONUM Purchasing Document Number CHAR 10 0 EBELN
ITMNO Item Number of Purchasing Document NUMC 5 0 EBELP
EKORG Purchasing organization CHAR 4 0 EKORG
EKGRP Purchasing Group CHAR 3 0 EKGRP
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
BSART Order Type (Purchasing) CHAR 4 0 BSART
BSAKZ Control indicator for purchasing document type CHAR 1 0 BSAKZ
C Subordinate Document
H Hierarchy
R Purchase requisition for outline agreement
T Transport
LOEKZ Asset class marked for deletion CHAR 1 0 LOEKZ
STATU Status field string CHAR 10 0 STATU_VL
BEDAT Purchase Order Date DATS 8 0 BEDAT
ELIKZ "Delivery Completed" Indicator CHAR 1 0 ELIKZ
PSTYP Item category in purchasing document CHAR 1 0 PSTYP
WEPOS Goods Receipt Indicator CHAR 1 0 WEPOS
WEUNB Goods Receipt, Non-Valuated CHAR 1 0 WEUNB
WEBRE Indicator: GR-Based Invoice Verification CHAR 1 0 WEBRE
EILDT Start Date for GR-Based Settlement DATS 8 0 EILDT
REF_LSMENG Target Del. Quantity in VRKME: Used in SCFG as Ref. f. Check QUAN 13 3 SHP_REF_LSMENG
REF_VRKME Unit of Measure for Reference Quantity REF_LSMENG UNIT 3 0 SHP_REF_VRKME
UPDKZ Update indicator CHAR 1 0 UPDKZ_D

LESHP_DELIVERY_REFDATA foreign key relationships

Table Field Check Table Check Field
0 LESHP_DELIVERY_REFDATA BSARK T176 Sales Documents: Customer Order Types MANDT
0 LESHP_DELIVERY_REFDATA BSARK T176 Sales Documents: Customer Order Types BSARK
1 LESHP_DELIVERY_REFDATA BSARK_E T176 Sales Documents: Customer Order Types MANDT
1 LESHP_DELIVERY_REFDATA BSARK_E T176 Sales Documents: Customer Order Types BSARK