SAP ABAP Table SPPSDSTAT (Salesorder status)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-A (Application Component) Industry Solution Automotive
     ⤷ DI_SPP (Package) Internet Spare Parts Project

Basic Data

Table Category	INTTAB	Structure
Structure	SPPSDSTAT	Table Relationship Diagram
Short Description	Salesorder status

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	PRC_STAT_H_SHORT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
41	DLV_STAT_H_SHORT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
42	DLV_STAT_I_SHORT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
43	DLV_BLOCK_SHORT	☐	BEZEI_LIFSP	TEXT20	CHAR	20	0	Description
44	DELETE_IND	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

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

History

Last changed by/on	SAP	20050411
SAP Release Created in	46C2