1. Home
  2. Resources
  3. SAP Tables
  4. DRE_DELIVERY_ITEM_STS - Delivery Item Status

SAP Table DRE_DELIVERY_ITEM_STS

Delivery Item Status

DRE_DELIVERY_ITEM_STS (Delivery Item Status) 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 DRE_DELIVERY_ITEM_STS to other SAP tables.

DRE_DELIVERY_ITEM_STS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR NUMC 6 0
RFSTA Reference status RFSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RFGSA Overall status of reference RFGSA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
BESTA Confirmation Status of Document Item BESTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LFSTA Delivery status LFSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LFGSA Overall delivery status of the item LFGSA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WBSTA Goods movement status WBSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSTA Billing status of delivery-related billing documents FKSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSAA Billing Status for Order-Related Billing Documents FKSAA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
ABSTA Rejection status for SD item ABSTA_VB CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
GBSTA Overall processing status of the SD document item GBSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOSTA Picking status/Putaway status KOSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LVSTA Status of warehouse management activities LVSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVALL General Incompletion Status of Item UVALL_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVVLK Incompletion status of the item with regard to delivery UVVLK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVFAK Item Incompletion Status with Respect to Billing UVFAK_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPRS Pricing for item is incomplete UVPRS_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKIVP Intercompany Billing Status FKIVP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP01 Customer reserves 1: Item status UVP01 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP02 Customer reserves 2: Item status UVP02 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP03 Item reserves 3: Item status UVP03 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP04 Item reserves 4: Item status UVP04 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVP05 Customer reserves 5: Item status UVP05 CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PKSTA Packing status of item PKSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOQUA Confirmation status of picking/putaway KOQUA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
COSTA Confirmation status for ALE COSTA_D CHAR 1 0
NULL Item not relevant for confirmation
A Item not yet confirmed by MM
B Item partially confirmed by MM
C All schedule lines by MM confirmed
CMPPI Status of credit check against financial document CMPSI CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPPJ Status of credit check against export credit insurance CMPSJ CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
UVPIK Incomplete status of item for picking/putaway UVPIP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVPAK Incomplete status of item for packaging UVPAP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
UVWAK Incomplete status of item regarding goods issue UVWAP_UP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
DCSTA Delay status DCSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
RRSTA Revenue determination status RR_STATUS CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
VLSTP Decentralized whse processing VLSTP CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FSSTA Billing block status for items FSSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LSSTA Delivery block status for item LSSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PDSTA POD status on item level PDSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
MANEK Manual Completion of Contract MANEK CHAR 1 0
HDALL Inbound Delivery Item Not Yet Complete (on Hold) /SPE/INB_HDALL_ITM CHAR 1 0
X Yes
NULL No