SAP table SALES_ORDER_STATUS_EXT (Extended Status Information for Sales Orders)

Field Description Data Type Length Decimals Checktable Data Element
DOC_NUMBER Sales Document CHAR 10 0 * VBELN_VA
DOC_DATE Document Date (Date Received/Sent) DATS 8 0 AUDAT
PURCH_NO Customer Reference CHAR 20 0 BSTNK
PRC_STAT_H Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
DLV_STAT_H Overall Delivery Status (All Items) CHAR 1 0 LKGSK
REQ_DATE_H Requested Delivery Date DATS 8 0 EDATU_VBAK
DLV_BLOCK Delivery Block (Document Header) CHAR 2 0 TVLS LIFSK
ITM_NUMBER Sales Document Item NUMC 6 0 * POSNR_VA
MATERIAL Material Number (18 Characters) CHAR 18 0 * MATNR18
SHORT_TEXT Short text for sales order item CHAR 40 0 ARKTX
REQ_DATE Schedule line date DATS 8 0 EDATU
REQ_QTY Cumulative order quantity in sales units QUAN 15 3 KWMENG
CUM_CF_QTY Cumulative Confirmed Quantity in Sales Unit QUAN 15 3 KBMENG
SALES_UNIT Sales unit UNIT 3 0 T006 VRKME
NET_VALUE Net Value of the Order Item in Document Currency CURR 15 2 NETWR_AP
CURRENCY SD Document Currency CUKY 5 0 TCURC WAERK
NET_PRICE Net Price CURR 11 2 NETPR
COND_P_UNT Condition Pricing Unit DEC 5 0 KPEIN
COND_UNIT Condition Unit UNIT 3 0 T006 KMEIN
DLV_STAT_I Overall Delivery Status (Item) CHAR 1 0 LFGSA
DELIV_NUMB Delivery CHAR 10 0 * VBELN_VL
DELIV_ITEM Delivery Item NUMC 6 0 * POSNR_VL
DELIV_DATE Delivery date DATS 8 0 LFDAT
DLV_QTY Actual quantity delivered (in sales units) QUAN 13 3 LFIMG
REF_QTY Referenced quantity in base unit of measure QUAN 15 3 RFMNG
S_UNIT_ISO Sales unit in ISO code CHAR 3 0 T006I VRKME_ISO
CD_UNT_ISO Condition unit of measure in UoM CHAR 3 0 T006I KVMEI_ISO
CURR_ISO ISO code currency CHAR 3 0 WAERS_ISO
MATERIAL_EXTERNAL Long Material Number for MATERIAL Field CHAR 40 0 MGV_MATERIAL_EXTERNAL
MATERIAL_GUID External GUID for MATERIAL Field CHAR 32 0 MGV_MATERIAL_GUID
MATERIAL_VERSION Version Number for MATERIAL Field CHAR 10 0 MGV_MATERIAL_VERSION
PO_ITM_NO Item Number of the Underlying Purchase Order CHAR 6 0 POSEX
CREATION_DATE Date on which the record was created DATS 8 0 ERDAT
CREATION_TIME Entry time TIMS 6 0 ERZET
S_UNIT_DLV Delivery unit UNIT 3 0 * LIFME
DLV_UNIT_ISO Unit of measure for delivery unit in ISO code CHAR 3 0 * SCHME_ISO
REA_FOR_RE Reason for Rejection of Sales Documents CHAR 2 0 * ABGRU_VA
PURCH_NO_C Customer Reference CHAR 35 0 BSTKD
MATERIAL_LONG Material No. CHAR 40 0 * MATNR40
CUSTOMER Customer Number CHAR 10 0 KUNNR
NAME1 Name 1 of organization CHAR 40 0 BU_NAMEOR1
NAME2 Name 2 of organization CHAR 40 0 BU_NAMEOR2
NAME3 Name 3 of organization CHAR 40 0 BU_NAMEOR3
NAME4 Name 4 of organization CHAR 40 0 BU_NAMEOR4
LEGALFORM BP: Legal form of organization CHAR 2 0 BU_LEGENTY
INDUSTRYSECTOR Industry sector CHAR 10 0 BU_INDSECT
FOUNDATIONDATE Date organization founded DATS 8 0 BU_FOUND_DAT
LIQUIDATIONDATE Liquidation date of organization DATS 8 0 BU_LIQUID_DAT
LOC_NO_1 International location number (part 1) NUMC 7 0 BBBNR
LOC_NO_2 International location number (Part 2) NUMC 5 0 BBSNR
CHK_DIGIT Check digit for the international location number NUMC 1 0 BUBKZ
LEGALORG Legal Entity of Organization CHAR 2 0 BU_LEGAL_ORG

SALES_ORDER_STATUS_EXT foreign key relationships

Table Field Check Table Check Field
0 SALES_ORDER_STATUS_EXT CD_UNT_ISO T006I ISO codes for units of measurement CLIENT
1 SALES_ORDER_STATUS_EXT COND_UNIT T006 Units of Measurement MANDT
1 SALES_ORDER_STATUS_EXT COND_UNIT T006 Units of Measurement MSEHI
0 SALES_ORDER_STATUS_EXT CURRENCY TCURC Currency Codes MANDT
0 SALES_ORDER_STATUS_EXT CURRENCY TCURC Currency Codes WAERS
1 SALES_ORDER_STATUS_EXT DLV_BLOCK TVLS Deliveries: Blocking Reasons/Criteria MANDT
1 SALES_ORDER_STATUS_EXT DLV_BLOCK TVLS Deliveries: Blocking Reasons/Criteria LIFSP
0 SALES_ORDER_STATUS_EXT SALES_UNIT T006 Units of Measurement MANDT
0 SALES_ORDER_STATUS_EXT SALES_UNIT T006 Units of Measurement MSEHI
1 SALES_ORDER_STATUS_EXT S_UNIT_ISO T006I ISO codes for units of measurement CLIENT