SAP ABAP Table SDEMO_SO_ALL (Sales order with all dependend data)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
     ⤷ S_NWDEMO_MODEL_SALES_ORDER (Package) SAP NetWeaver Demo Model - Sales Order

Basic Data

Table Category	INTTAB	Structure
Structure	SDEMO_SO_ALL	Table Relationship Diagram
Short Description	Sales order with all dependend data

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	SALESORDER	☐	SDEMO_SO_WITH_ST		STRU	0	0
2	.INCLUDE	☐				0	0	SAP NetWeaver Demo Model - Sales Order Header
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
4	SO_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
5	SO_ID	☐	SDEMO_SO_ID	CHAR35	CHAR	35	0	Sales Order ID
6	TYPE_CODE	☐	SDEMO_TYPE_CODE	CHAR4	CHAR	4	0	Order Type
7	POSTING_DATE	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
8	CREATED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
9	CREATED_AT	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
10	CHANGED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
11	CHANGED_AT	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
12	DESCRIPTION_GUID	☐	SDEMO_DESCRIPTION_GUID	SYSUUID	RAW	16	0	Description
13	SELLER_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
14	SELLER_PARTY_ID	☐	SDEMO_SELLER_PARTY_ID	CHAR10	CHAR	10	0	Seller ID
15	BUYER_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
16	BUYER_PARTY_ID	☐	SDEMO_BUYER_PARTY_ID	CHAR10	CHAR	10	0	Buyer ID
17	LIFE_CYCLE_STAT	☐	SDEMO_LIFE_CYCLE_STAT	CHAR8	CHAR	8	0	Life Cycle Status Code
18	BILLING_STATUS	☐	SDEMO_BILLING_STATUS	CHAR14	CHAR	14	0	Billing Status Code
19	RESPONSE_STATUS	☐	SDEMO_RESPONSE_STAT	CHAR8	CHAR	8	0	Response Status Code
20	CLASSIFICATION	☐	SDEMO_CLASSIFICATION	CHAR3	CHAR	3	0	Classification Code
21	TRNSFR_LOC_NAME	☐	SDEMO_TRANSFER_LOC_NAME	CHAR28	CHAR	28	0	Name of Transfer Location
22	TTL_GROSS_AMOUNT	☐	SDEMO_TTL_GROSS_AMOUNT		CURR	15	2	Total Gross Amount
23	TTL_NET_AMOUNT	☐	SDEMO_TTL_NET_AMOUNT		CURR	15	2	Total Net Amount
24	TTL_TAX_AMOUNT	☐	SDEMO_TTL_TAX_AMOUNT		CURR	15	2	Total Tax Amount
25	CURRENCY_CODE	☐	SDEMO_CURR_CODE		CUKY	5	0	Currency Code
26	PO_POSTING_DATE	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
27	PO_NOTE_GUID	☐	SDEMO_PO_NOTE_GUID	SYSUUID	RAW	16	0	Purchase Order Note
28	PO_REF_ID	☐	SDEMO_PO_REF_ID	CHAR35	CHAR	35	0	Purchase Order Reference ID
29	ATP_STATUS	☐	SDEMO_ATP_STATUS	CHAR13	CHAR	13	0	Available-to-Promise Status Code
30	STATUS	☐	SDEMO_SO_ST		STRU	0	0
31	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client
32	SO_GUID	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
33	LIFECYCLE_STATUS	☐	SDEMO_STATUS_VAL	CHAR2	CHAR	2	0	Value of Status Variable
34	BILLING_STATUS	☐	SDEMO_STATUS_VAL	CHAR2	CHAR	2	0	Value of Status Variable
35	ACCEPT_STATUS	☐	SDEMO_STATUS_VAL	CHAR2	CHAR	2	0	Value of Status Variable
36	ATP_STATUS	☐	SDEMO_STATUS_VAL	CHAR2	CHAR	2	0	Value of Status Variable
37	ARCHIV_STATUS	☐	SDEMO_STATUS_VAL	CHAR2	CHAR	2	0	Value of Status Variable
38	STATUS_SCHEMA	☐	PRX_R3NAME	PRX_R3NAME	CHAR	30	0	Proxy Generation: Name of an Object in R/3
39	T_ITEM	☐	SDEMO_SO_ITEM_ALL_TT		TTYP	0	0
40	T_TEXT	☐	SDEMO_TEXT_TT		TTYP	0	0

History

Last changed by/on	SAP	20130604
SAP Release Created in	710