SNWD_SO - EPM: Sales Order Header Table
EPM: Sales Order Header Table information is stored in SAP table SNWD_SO.
It is part of development package S_NWDEMO_MODEL_DDIC in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "Common Data Dictionary Objects (only) for EPM and NWDEMO".
It is part of development package S_NWDEMO_MODEL_DDIC in software component BC-SRV-NWD. This development package consists of objects that can be grouped under "Common Data Dictionary Objects (only) for EPM and NWDEMO".
Fields for table SNWD_SO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
CLIENT | Client | X | MANDT | CLNT | 6 | T000 |
NODE_KEY | EPM: Generic Node Key | X | SNWD_NODE_KEY | RAW | 16 | |
SO_ID | EPM: Sales Order Number | SNWD_SO_ID | CHAR | 20 | ||
.INCLUDE | SNWD_ADMIN_DATA | 0 | ||||
CREATED_BY | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_EMPLOYEES | |
CREATED_AT | EPM: Created At | SNWD_CREATED_AT | DEC | 11 | ||
CHANGED_BY | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_EMPLOYEES | |
CHANGED_AT | EPM: Changed At | SNWD_CHANGED_AT | DEC | 11 | ||
CREATED_BY_BP | EPM: Boolean | SNWD_BOOL | CHAR | 2 | ||
CHANGED_BY_BP | EPM: Boolean | SNWD_BOOL | CHAR | 2 | ||
NOTE_GUID | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_TEXT_KEY | |
BUYER_GUID | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_BPA | |
CURRENCY_CODE | EPM: Currency Code | SNWD_CURR_CODE | CUKY | 10 | ||
GROSS_AMOUNT | EPM: Total Gross Amount | SNWD_TTL_GROSS_AMOUNT | CURR | 8 | ||
NET_AMOUNT | EPM: Total Net Amount | SNWD_TTL_NET_AMOUNT | CURR | 8 | ||
TAX_AMOUNT | EPM: Total Tax Amount | SNWD_TTL_TAX_AMOUNT | CURR | 8 | ||
LIFECYCLE_STATUS | EPM: Sales Order Lifecycle Status | SNWD_SO_LC_STATUS_CODE | CHAR | 2 | ||
BILLING_STATUS | EPM: Sales Order Confirmation Status | SNWD_SO_CF_STATUS_CODE | CHAR | 2 | ||
DELIVERY_STATUS | EPM: Sales Order Ordering Status | SNWD_SO_OR_STATUS_CODE | CHAR | 2 | ||
OP_ID | EPM: Opportunity ID for SoD IDoc processing | SNWD_OP_ID | CHAR | 70 | ||
_DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 | ||
.INCLUDE | SNWD_SO_INCL_EEW_PS | 0 | ||||
DUMMY | CHAR | 2 | ||||
OVERALL_STATUS | EPM: Sales Order Overall Status | SNWD_SO_OA_STATUS_CODE | CHAR | 2 | ||
BUY_CONTACT_GUID | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_BPA_CONTACT | |
SHIP_TO_ADR_GUID | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_AD | |
BILL_TO_ADR_GUID | EPM: Generic Node Key | SNWD_NODE_KEY | RAW | 16 | SNWD_AD | |
PAYMENT_METHOD | EPM: Sales Order Payment Method | SNWD_SO_PAYMENT_METHOD | CHAR | 2 | ||
PAYMENT_TERMS | EPM: Sales Order Payment Terms | SNWD_SO_PAYMENT_TERM | CHAR | 2 |