SAP ABAP Table SALES_ORDER_STATUS_EXT (Extended Status Information for Sales Orders)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_PORTAL (Package) ERP Sales Portal Roles

Basic Data

Table Category	INTTAB	Structure
Structure	SALES_ORDER_STATUS_EXT	Table Relationship Diagram
Short Description	Extended Status Information for Sales Orders

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Status Information for Sales Orders
2	DOC_NUMBER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
3	DOC_DATE	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
4	PURCH_NO	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
5	PRC_STAT_H	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
6	DLV_STAT_H	☐	LKGSK	STATV	CHAR	1	0	Overall delivery status for all items
7	REQ_DATE_H	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
8	DLV_BLOCK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
9	ITM_NUMBER	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
10	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
12	REQ_DATE	☐	EDATU	DATUM	DATS	8	0	Schedule line date
13	REQ_QTY	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
14	CUM_CF_QTY	☐	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
15	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
16	NET_VALUE	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
17	CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
18	NET_PRICE	☐	NETPR	WERTV6	CURR	11	2	Net price
19	COND_P_UNT	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
20	COND_UNIT	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
21	DLV_STAT_I	☐	LFGSA	STATV	CHAR	1	0	Overall Delivery Status of the Item
22	DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
23	DELIV_ITEM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
24	DELIV_DATE	☐	LFDAT	DATUM	DATS	8	0	Delivery date
25	DLV_QTY	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
26	REF_QTY	☐	RFMNG	MENG15	QUAN	15	3	Referenced quantity in base unit of measure
27	S_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
28	CD_UNT_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
29	CURR_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
30	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
31	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
32	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
33	PO_ITM_NO	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
34	CREATION_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
35	CREATION_TIME	☐	ERZET	UZEIT	TIMS	6	0	Entry time
36	S_UNIT_DLV	☐	LIFME	MEINS	UNIT	3	0	Delivery unit	*
37	DLV_UNIT_ISO	☐	SCHME_ISO	ISOCD_UNIT	CHAR	3	0	Unit of measure for delivery unit in ISO code	*
38	REA_FOR_RE	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
39	PURCH_NO_C	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
40	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
41	NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
42	NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
43	NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
44	NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
45	LEGALFORM	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	*
46	INDUSTRYSECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	*
47	FOUNDATIONDATE	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
48	LIQUIDATIONDATE	☐	BU_LIQUID_DAT		DATS	8	0	Liquidation date of organization
49	LOC_NO_1	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
50	LOC_NO_2	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
51	CHK_DIGIT	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
52	LEGALORG	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SALES_ORDER_STATUS_EXT	CD_UNT_ISO	T006I	ISOCODE
2	SALES_ORDER_STATUS_EXT	COND_UNIT	T006	MSEHI
3	SALES_ORDER_STATUS_EXT	CURRENCY	TCURC	WAERS
4	SALES_ORDER_STATUS_EXT	DELIV_ITEM	VBUP	POSNR
5	SALES_ORDER_STATUS_EXT	DELIV_NUMB	VBUK	VBELN
6	SALES_ORDER_STATUS_EXT	DLV_BLOCK	TVLS	LIFSP
7	SALES_ORDER_STATUS_EXT	DOC_NUMBER	VBUK	VBELN
8	SALES_ORDER_STATUS_EXT	ITM_NUMBER	VBUP	POSNR
9	SALES_ORDER_STATUS_EXT	MATERIAL	MARA	MATNR
10	SALES_ORDER_STATUS_EXT	SALES_UNIT	T006	MSEHI
11	SALES_ORDER_STATUS_EXT	S_UNIT_ISO	T006I	ISOCODE

History

Last changed by/on	SAP	20110901
SAP Release Created in	600