SAP ABAP Table SNWD_SO (EPM: Sales Order Header Table)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
⤷ S_NWDEMO_MODEL_DDIC (Package) Common Data Dictionary Objects (only) for EPM and NWDEMO
⤷ BC-SRV-NWD (Application Component) NetWeaver Demonstration
⤷ S_NWDEMO_MODEL_DDIC (Package) Common Data Dictionary Objects (only) for EPM and NWDEMO
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | SNWD_SO | Table Relationship Diagram |
Short Description | EPM: Sales Order Header Table |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | L | Table for storing temporary data, delivered empty |
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 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | NODE_KEY | SNWD_NODE_KEY | SYSUUID | RAW | 16 | 0 | EPM: Generic Node Key | ||
3 | SO_ID | SNWD_SO_ID | D_EPM_ID | CHAR | 10 | 0 | EPM: Sales Order Number | ||
4 | .INCLUDE | 0 | 0 | EPM: Include-Structure for various tables | |||||
5 | CREATED_BY | SNWD_NODE_KEY | SYSUUID | RAW | 16 | 0 | EPM: Generic Node Key | SNWD_EMPLOYEES | |
6 | CREATED_AT | TIMESTAMPL | TZNTSTMPL | DEC | 21 | 7 | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
7 | CHANGED_BY | SNWD_NODE_KEY | SYSUUID | RAW | 16 | 0 | EPM: Generic Node Key | SNWD_EMPLOYEES | |
8 | CHANGED_AT | TIMESTAMPL | TZNTSTMPL | DEC | 21 | 7 | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | ||
9 | CREATED_BY_BP | SNWD_BOOL | D_BOOL | CHAR | 1 | 0 | EPM: Boolean | ||
10 | CHANGED_BY_BP | SNWD_BOOL | D_BOOL | CHAR | 1 | 0 | EPM: Boolean | ||
11 | NOTE_GUID | SNWD_NODE_KEY | SYSUUID | RAW | 16 | 0 | EPM: Generic Node Key | SNWD_TEXT_KEY | |
12 | BUYER_GUID | SNWD_NODE_KEY | SYSUUID | RAW | 16 | 0 | EPM: Generic Node Key | SNWD_BPA | |
13 | CURRENCY_CODE | SNWD_CURR_CODE | CUKY | 5 | 0 | EPM: Currency Code | |||
14 | GROSS_AMOUNT | SNWD_TTL_GROSS_AMOUNT | CURR | 15 | 2 | EPM: Total Gross Amount | |||
15 | NET_AMOUNT | SNWD_TTL_NET_AMOUNT | CURR | 15 | 2 | EPM: Total Net Amount | |||
16 | TAX_AMOUNT | SNWD_TTL_TAX_AMOUNT | CURR | 15 | 2 | EPM: Total Tax Amount | |||
17 | LIFECYCLE_STATUS | SNWD_SO_LC_STATUS_CODE | D_SO_LC | CHAR | 1 | 0 | EPM: Sales Order Lifecycle Status | ||
18 | BILLING_STATUS | SNWD_SO_CF_STATUS_CODE | D_SO_CF | CHAR | 1 | 0 | EPM: Sales Order Confirmation Status | ||
19 | DELIVERY_STATUS | SNWD_SO_OR_STATUS_CODE | D_SO_OR | CHAR | 1 | 0 | EPM: Sales Order Ordering Status | ||
20 | OP_ID | SNWD_OP_ID | CHAR | 35 | 0 | EPM: Opportunity ID for SoD IDoc processing |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | SNWD_SO | BUYER_GUID | SNWD_BPA | NODE_KEY | 1 | CN | |
2 | SNWD_SO | CHANGED_BY | SNWD_EMPLOYEES | NODE_KEY | 1 | CN | |
3 | SNWD_SO | CLIENT | T000 | MANDT | 1 | CN | |
4 | SNWD_SO | CREATED_BY | SNWD_EMPLOYEES | NODE_KEY | 1 | CN | |
5 | SNWD_SO | NOTE_GUID | SNWD_TEXT_KEY | NODE_KEY | 1 | C |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 730 |