SAP Table SHP_DELIVERY_COMPLETE

Status and Basic Information on Delivery

SHP_DELIVERY_COMPLETE (Status and Basic Information on 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 SHP_DELIVERY_COMPLETE to other SAP tables.

SHP_DELIVERY_COMPLETE table fields

Field Data element Checktable Datatype Length Decimals
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
VBELN Delivery VBELN_VL CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
LFART Delivery Type LFART CHAR 4 0
KUNNR Ship-to party KUNWE CHAR 10 0
LFDAT Delivery date LFDAT DATS 8 0
KOSTK Overall picking / putaway status KOSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KOQUK Status of pick confirmation KOQUK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
LVSTK Overall status of warehouse management activities LVSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WBSTK Total goods movement status WBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PKSTK Overall packing status of all items PKSTK CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
D There are only non-assigned shipping units
PDSTK POD status on header level PDSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKSTK Billing status FKSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
FKIVK Billing totals status for intercompany billing FKIVK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
GBSTK Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
TRSTA Transportation planning status TRSTA CHAR 1 0
NULL Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
COLOR Not More Closely Defined Area, Possibly Used for Patchlevels CHAR4 CHAR 4 0