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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
DLV_STAT_H
Overall delivery status for all items
|
LKGSK |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| SALES_ORDER_STATUS_EXT | COND_UNIT | SALES_ORDER_STATUS_EXT | COND_UNIT |
T006
Units of Measurement
|
MSEHI |
| SALES_ORDER_STATUS_EXT | CURRENCY | SALES_ORDER_STATUS_EXT | CURRENCY |
TCURC
Currency Codes
|
WAERS |
| SALES_ORDER_STATUS_EXT | CURRENCY | SYST | MANDT |
TCURC
Currency Codes
|
MANDT |
| SALES_ORDER_STATUS_EXT | DELIV_ITEM | SYST | MANDT |
VBUP
Sales Document: Item Status
|
MANDT |
| 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_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 | 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 | ITM_NUMBER | SYST | MANDT |
VBUP
Sales Document: Item Status
|
MANDT |
| 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 |