1. Home
  2. Resources
  3. SAP Tables
  4. SALES_ORDER_STATUS_EXT - Extended Status Information for Sales Orders

SAP Table SALES_ORDER_STATUS_EXT

Extended Status Information for Sales Orders

SALES_ORDER_STATUS_EXT (Extended Status Information for Sales Orders) 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 SALES_ORDER_STATUS_EXT to other SAP tables.

SALES_ORDER_STATUS_EXT table fields

Field Data element Checktable Datatype Length Decimals
DOC_NUMBER Sales Document VBELN_VA VBUK CHAR 10 0
DOC_DATE Document Date (Date Received/Sent) AUDAT DATS 8 0
PURCH_NO Customer purchase order number BSTNK CHAR 20 0
PRC_STAT_H Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
DLV_STAT_H Overall delivery status for all items LKGSK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
REQ_DATE_H Requested delivery date EDATU_VBAK DATS 8 0
DLV_BLOCK Delivery block (document header) LIFSK TVLS CHAR 2 0
ITM_NUMBER Sales Document Item POSNR_VA VBUP NUMC 6 0
MATERIAL Material Number MATNR MARA CHAR 18 0
SHORT_TEXT Short text for sales order item ARKTX CHAR 40 0
REQ_DATE Schedule line date EDATU DATS 8 0
REQ_QTY Cumulative Order Quantity in Sales Units KWMENG QUAN 15 3
CUM_CF_QTY Cumulative confirmed quantity in sales unit KBMENG QUAN 15 3
SALES_UNIT Sales unit VRKME T006 UNIT 3 0
NET_VALUE Net value of the order item in document currency NETWR_AP CURR 15 2
CURRENCY SD Document Currency WAERK TCURC CUKY 5 0
NET_PRICE Net price NETPR CURR 11 2
COND_P_UNT Condition pricing unit KPEIN DEC 5 0
COND_UNIT Condition unit KMEIN T006 UNIT 3 0
DLV_STAT_I Overall delivery status of the item LFGSA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
DELIV_NUMB Delivery VBELN_VL VBUK CHAR 10 0
DELIV_ITEM Delivery Item POSNR_VL VBUP NUMC 6 0
DELIV_DATE Delivery date LFDAT DATS 8 0
DLV_QTY Actual quantity delivered (in sales units) LFIMG QUAN 13 3
REF_QTY Referenced quantity in base unit of measure RFMNG QUAN 15 3
S_UNIT_ISO Sales unit in ISO code VRKME_ISO T006I CHAR 3 0
CD_UNT_ISO Condition unit of measure in UoM KVMEI_ISO T006I CHAR 3 0
CURR_ISO ISO code currency WAERS_ISO CHAR 3 0
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field MGV_MATERIAL_EXTERNAL CHAR 40 0
MATERIAL_GUID External GUID for MATERIAL Field MGV_MATERIAL_GUID CHAR 32 0
MATERIAL_VERSION Version Number for MATERIAL Field MGV_MATERIAL_VERSION CHAR 10 0
PO_ITM_NO Item Number of the Underlying Purchase Order POSEX CHAR 6 0
CREATION_DATE Date on Which Record Was Created ERDAT DATS 8 0
CREATION_TIME Entry time ERZET TIMS 6 0
S_UNIT_DLV Delivery unit LIFME UNIT 3 0
DLV_UNIT_ISO Unit of measure for delivery unit in ISO code SCHME_ISO CHAR 3 0
REA_FOR_RE Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
PURCH_NO_C Customer purchase order number BSTKD CHAR 35 0
CUSTOMER Customer Number KUNNR CHAR 10 0
NAME1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
NAME2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
NAME3 Name 3 of organization BU_NAMEOR3 CHAR 40 0
NAME4 Name 4 of organization BU_NAMEOR4 CHAR 40 0
LEGALFORM BP: Legal form of organization BU_LEGENTY CHAR 2 0
INDUSTRYSECTOR Industry sector BU_INDSECT CHAR 10 0
FOUNDATIONDATE Date organization founded BU_FOUND_DAT DATS 8 0
LIQUIDATIONDATE Liquidation date of organization BU_LIQUID_DAT DATS 8 0
LOC_NO_1 International location number (part 1) BBBNR NUMC 7 0
LOC_NO_2 International location number (Part 2) BBSNR NUMC 5 0
CHK_DIGIT Check digit for the international location number BUBKZ NUMC 1 0
LEGALORG Legal Entity of Organization BU_LEGAL_ORG CHAR 2 0

SALES_ORDER_STATUS_EXT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SALES_ORDER_STATUS_EXT CD_UNT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
SALES_ORDER_STATUS_EXT CD_UNT_ISO SALES_ORDER_STATUS_EXT CD_UNT_ISO T006I ISO codes for units of measurement ISOCODE
SALES_ORDER_STATUS_EXT COND_UNIT SALES_ORDER_STATUS_EXT COND_UNIT T006 Units of Measurement MSEHI
SALES_ORDER_STATUS_EXT COND_UNIT SYST MANDT T006 Units of Measurement MANDT
SALES_ORDER_STATUS_EXT CURRENCY SYST MANDT TCURC Currency Codes MANDT
SALES_ORDER_STATUS_EXT CURRENCY SALES_ORDER_STATUS_EXT CURRENCY TCURC Currency Codes WAERS
SALES_ORDER_STATUS_EXT DELIV_ITEM SALES_ORDER_STATUS_EXT DOC_NUMBER VBUP Sales Document: Item Status VBELN
SALES_ORDER_STATUS_EXT DELIV_ITEM SALES_ORDER_STATUS_EXT DELIV_ITEM VBUP Sales Document: Item Status POSNR
SALES_ORDER_STATUS_EXT DELIV_ITEM SYST MANDT VBUP Sales Document: Item Status MANDT
SALES_ORDER_STATUS_EXT DELIV_NUMB SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
SALES_ORDER_STATUS_EXT DELIV_NUMB SALES_ORDER_STATUS_EXT DELIV_NUMB VBUK Sales Document: Header Status and Administrative Data VBELN
SALES_ORDER_STATUS_EXT DLV_BLOCK SYST MANDT TVLS Deliveries: Blocking Reasons/Criteria MANDT
SALES_ORDER_STATUS_EXT DLV_BLOCK SALES_ORDER_STATUS_EXT DLV_BLOCK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
SALES_ORDER_STATUS_EXT DOC_NUMBER SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
SALES_ORDER_STATUS_EXT DOC_NUMBER SALES_ORDER_STATUS_EXT DOC_NUMBER VBUK Sales Document: Header Status and Administrative Data VBELN
SALES_ORDER_STATUS_EXT ITM_NUMBER SYST MANDT VBUP Sales Document: Item Status MANDT
SALES_ORDER_STATUS_EXT ITM_NUMBER SALES_ORDER_STATUS_EXT DOC_NUMBER VBUP Sales Document: Item Status VBELN
SALES_ORDER_STATUS_EXT ITM_NUMBER SALES_ORDER_STATUS_EXT ITM_NUMBER VBUP Sales Document: Item Status POSNR
SALES_ORDER_STATUS_EXT MATERIAL SYST MANDT MARA General Material Data MANDT
SALES_ORDER_STATUS_EXT MATERIAL SALES_ORDER_STATUS_EXT MATERIAL MARA General Material Data MATNR
SALES_ORDER_STATUS_EXT SALES_UNIT SYST MANDT T006 Units of Measurement MANDT
SALES_ORDER_STATUS_EXT SALES_UNIT SALES_ORDER_STATUS_EXT SALES_UNIT T006 Units of Measurement MSEHI
SALES_ORDER_STATUS_EXT S_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
SALES_ORDER_STATUS_EXT S_UNIT_ISO SALES_ORDER_STATUS_EXT S_UNIT_ISO T006I ISO codes for units of measurement ISOCODE