SAP ABAP Table BAPISDSTAT (Status Information for Sales Orders)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF (Application Component) Basic Functions for Business Transactions
     ⤷ VAW (Package) Internet/Intranet - development in sales

Basic Data

Table Category	INTTAB	Structure
Structure	BAPISDSTAT	Table Relationship Diagram
Short Description	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	DOC_NUMBER	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document
2	DOC_DATE	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
3	PURCH_NO	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
4	PRC_STAT_H	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
5	DLV_STAT_H	☐	LKGSK	STATV	CHAR	1	0	Overall delivery status for all items
6	REQ_DATE_H	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
7	DLV_BLOCK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
8	ITM_NUMBER	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
9	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number
10	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
11	REQ_DATE	☐	EDATU	DATUM	DATS	8	0	Schedule line date
12	REQ_QTY	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
13	CUM_CF_QTY	☐	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
14	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
15	NET_VALUE	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
16	CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
17	NET_PRICE	☐	NETPR	WERTV6	CURR	11	2	Net price
18	COND_P_UNT	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
19	COND_UNIT	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
20	DLV_STAT_I	☐	LFGSA	STATV	CHAR	1	0	Overall Delivery Status of the Item
21	DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery
22	DELIV_ITEM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item
23	DELIV_DATE	☐	LFDAT	DATUM	DATS	8	0	Delivery date
24	DLV_QTY	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
25	REF_QTY	☐	RFMNG	MENG15	QUAN	15	3	Referenced quantity in base unit of measure
26	S_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
27	CD_UNT_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
28	CURR_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
29	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
30	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
31	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
32	PO_ITM_NO	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
33	CREATION_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
34	CREATION_TIME	☐	ERZET	UZEIT	TIMS	6	0	Entry time
35	S_UNIT_DLV	☐	LSMEH	MEINS	UNIT	3	0	Unit of Measure From Delivery Note	T006
36	DLV_UNIT_ISO	☐	DELIV_UNIT_ISO	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measure of delivery note	T006I
37	REA_FOR_RE	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
38	PURCH_NO_C	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPISDSTAT	CD_UNT_ISO	T006I	ISOCODE
2	BAPISDSTAT	COND_UNIT	T006	MSEHI
3	BAPISDSTAT	CURRENCY	TCURC	WAERS
4	BAPISDSTAT	DLV_UNIT_ISO	T006I	ISOCODE
5	BAPISDSTAT	SALES_UNIT	T006	MSEHI
6	BAPISDSTAT	S_UNIT_DLV	T006	MSEHI
7	BAPISDSTAT	S_UNIT_ISO	T006I	ISOCODE

History

Last changed by/on	SAP	20110908
SAP Release Created in