SNWD_SO
EPM: Sales Order Header Table
SNWD_SO is an SAP database table in S/4HANA. EPM: Sales Order Header Table. It contains 27 fields. 91 CDS views read from this table.
CDS Views using this table (91)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /1bs/Sadl_V_Naming2 | view | from | ||
| ACMTEST_ASPECT_FOR_FILTERING | view_entity | from | A DCL to test aspect filters | |
| C_SADL_V_EXP_FI_PARAM | view | from | SADLGW: Test view for FI parameters | |
| C_SADL_V_EXP_TEST_VH_Def | view | from | Sadl Vocan Test View: UIHidden for Param | |
| CdsFrwk_Sales_Orders | view | from | Base View which is extended | |
| CdsFrwk_Sales_Orders_By_Cust | view | inner | Check GROUP BY and JOINs are unchanged | |
| DAAG00O2TII6W7814BCYOFVJ7382B | view | from | DAAG Obj-EPM_SO_AGING_RULES Residence Rule Source | |
| DAAGET091VTW8O1XN1VSN24128LOD | view | from | DAAG Obj-EPM_SO_AGING_RULES Residence Rule Source | |
| DEMO_CDS_EPM_SALESORDER | view_entity | from | EPM Demo: Sales Order | |
| DEMO_CDS_SALES_ORDER_V1 | view | from | ||
| demo_corp_sales_order | view | from | ||
| demo_corporation_sales_order | view | inner | ||
| DEMO_SALES_ORDER_OLD | view | from | ||
| DEMO_SALES_ORDER_OLD1 | view | inner | ||
| DEMO_SALES_ORDER_OLD2 | view | from | ||
| DEMO_SALES_ORDER_OLD3 | view | from | ||
| DEMO_SALES_ORDER_OLD4 | view | from | ||
| ESH_LIMITATIONS_AGGR | view | from | View with aggregates | |
| ESH_LIMITATIONS_CALCJOIN | view | from | View with join over a calc field | |
| ESH_LIMITATIONS_UNION | view | from | View with union | |
| ESH_LIMITATIONS_UNION | view | union | View with union | |
| ESH_LIMITATIONS_UNION | view | union_all | View with union | |
| Fdt_Test_Snwd_So_P1_Cds | view | from | Timestamp parameter | |
| Fdt_Test_Snwd_So_P2_Cds | view | from | Decimal parameter | |
| I_SADL_Complex_Core | view | inner | Core view with joins/unions/where-clause | |
| I_Sadl_DraftItem0Core | view | inner | BASIC | Item core view |
| I_Sadl_DraftItem2Core | view | inner | BASIC | Item core view |
| I_Sadl_DraftItemCore | view | inner | BASIC | Item core view |
| I_Sadl_DraftLeafCore | view | inner | BASIC | Item core view |
| I_SADL_DRAFTROOTCORE | view | from | ... | |
| I_Sadl_DraftRootCore | view | from | BASIC | Root core view |
| I_Sadl_Mk_Draft_Item_Core | view | inner | Test scenario: multiple key fields | |
| I_Sadl_Mk_Draft_Item_IV_Core | view | inner | Test scenario: Invalid key fields | |
| I_Sadl_Mk_Draft_Item_IW_Core | view | inner | Test scenario: Invalid key fields | |
| I_Sadl_Mk_Draft_Item_IX_Core | view | inner | Test scenario: Invalid key fields | |
| I_Sadl_Mk_Draft_Item_IY_Core | view | inner | Test scenario: Invalid key fields | |
| I_Sadl_Mk_Draft_Item_IZ_Core | view | inner | Test scenario: Invalid key fields | |
| I_Sadl_Mk_Draft_Root_Core | view | from | Test scenario: multiple key fields | |
| I_Sadl_Voc_Salesorder | view | from | BASIC | Vocan Core View: Sales Order |
| I_Sadl_Voc_Salesorder_Item | view | left_outer | BASIC | Vocan Core View: Sales Order Item |
| qlast_so_case | view | from | Example for case | |
| SACM_CDS_SNWD_SO_CS | view_entity | from | ||
| Sadl_Gw_Exp_V4_Sales_Order | view | from | Sales Order for V4 | |
| SADL_GwVAunitSo | view | from | CDS View for Unit Testing of SADL Bundle | |
| SADL_GwVAunitV2So | view | from | CDS View for Unit Testing of SADL Bundle | |
| SADL_GwVAunitV2VH | view | from | CDS View for Value Help on param | |
| SADL_GwVAunitV2VH_mixed_case | view | from | CDS View for Value Help in a mixed case | |
| SADL_GwVAunitV2VH_wrong_Anno | view | from | CDS View for Value help wrong annotation | |
| SADL_R_SO_HEADER | view_entity | from | Sales Order Header Test | |
| SADL_R_SO_SCHED_LINE | view_entity | inner | Sales Order Schedule Line Test | |
| SADL_R_SO_UNION | view | union | Sales Order Union Test | |
| Sadl_V_Action_Exposure | view | from | Test View for Action Exposure | |
| Sadl_V_Action_Exposure_Item | view | left_outer | Test View for Action Exposure | |
| SADL_V_AUNIT_INTERFACE | view | from | Unit Test CDS View Level: Interface | |
| SADL_V_AUNIT_INTERFACE_R | view_entity | from | ||
| SADL_V_AUnit_SO | view | from | SalesOrder for local unit tests | |
| SADL_V_AUNIT_SO_WhereSessionPa | view | from | SalesOrder to test sessionParameter | |
| Sadl_V_Conversion_Exit | view | from | Test View for Conversion Exits | |
| Sadl_V_Element_W_NS | view | from | Test View for Namespaces | |
| sadl_v_exp_draft | view | from | CDS view for draft | |
| Sadl_V_Exp_Field_Cntr | view | from | CDS View Testing Dynamic Field Control | |
| Sadl_V_Exp_Filter_Restriction | view | from | Filter Restriction | |
| SADL_V_EXP_Query | view | from | view_label | |
| SADL_V_EXP_SalesOrder | view | from | Sales Order Header | |
| SADL_V_EXP_SO_rootView | view | from | CDS View Testing UI Annotations | |
| Sadl_V_Exp_SO_UI | view | from | BASIC | CDS View Testing UI Annotations |
| SADL_V_EXP_Test_VH_Def | view | from | Test VH Definition with param | |
| Sadl_V_Exp_Vocan_SO | view | from | Sales Orders | |
| Sadl_V_Nam_Nspce | view | from | CDS View with Namespace | |
| Sadl_V_Naming | view | from | ||
| Sadl_V_Perf_So | view | from | Sales Order Performance Root | |
| Sadl_V_Perf_Soi | view | inner | Sales Order Performance Item Test | |
| Sadl_V_Perf_Sosl | view | inner | Schedule Lines Performance Test | |
| SADL_V_Ref_Constr_Left | view | from | Test view for referential constraints | |
| sepm_cds_sales_order | view | from | ||
| SEPM_E_SalesOrder | view | from | EPM Demo: Sales Order Extension | |
| SEPM_I_SalesOrder | view | from | EPM Demo: Sales Order | |
| sepm_sddl_salesorder_head | view | from | ||
| Sfpm_Ida_Test_Ass_Sales_O_It | view | from | FPM IDA Cartesian Product Sales Order x Sales Order Item | |
| Test_Cds_Astcheck_01 | view | from | test 1 | |
| Test_Cds_Astcheck_11 | view | from | test 11 | |
| Test_Cds_Astcheck_24 | view | from | ||
| Test_Cds_Astcheck_25 | view | from | ||
| Test_Cds_Astcheck_251 | view | from | ||
| Test_Cds_Astcheck_252 | view | from | ||
| Test_Cds_Astcheck_26 | view | from | ||
| Test_Cds_Astcheck_27 | view | from | ||
| TEST_CDS_ASTCHECK_CARD_EXT | view | from | ||
| TEST_CDS_ASTCHECK_CUBE_01 | view_entity | from | test cube view | |
| test_cds_versioning_01 | view | from | ||
| testCdsCi18 | view | from |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | node_key | SNWD_NODE_KEY | Node Key | |||
| so_id | SNWD_SO_ID | Sales Order ID | ||||
| created_by | SNWD_NODE_KEY | Node Key | ||||
| created_at | SNWD_CREATED_AT | Created At | ||||
| changed_by | SNWD_NODE_KEY | Node Key | ||||
| changed_at | SNWD_CHANGED_AT | Changed At | ||||
| created_by_bp | SNWD_BOOL | Value | ||||
| changed_by_bp | SNWD_BOOL | Value | ||||
| note_guid | SNWD_NODE_KEY | Node Key | ||||
| buyer_guid | SNWD_NODE_KEY | Node Key | ||||
| currency_code | SNWD_CURR_CODE | Currency Code | ||||
| gross_amount | SNWD_TTL_GROSS_AMOUNT | Gross Amount | ||||
| net_amount | SNWD_TTL_NET_AMOUNT | Net Amount | ||||
| tax_amount | SNWD_TTL_TAX_AMOUNT | Tax Amount | ||||
| lifecycle_status | SNWD_SO_LC_STATUS_CODE | Lifecycle Status | ||||
| billing_status | SNWD_SO_CF_STATUS_CODE | Confirmation Status | ||||
| delivery_status | SNWD_SO_OR_STATUS_CODE | Ordering Status | ||||
| op_id | SNWD_OP_ID | Opportunity ID | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| dummy | abap.char | |||||
| overall_status | SNWD_SO_OA_STATUS_CODE | Overall Status | ||||
| buy_contact_guid | SNWD_NODE_KEY | Node Key | ||||
| ship_to_adr_guid | SNWD_NODE_KEY | Node Key | ||||
| bill_to_adr_guid | SNWD_NODE_KEY | Node Key | ||||
| payment_method | SNWD_SO_PAYMENT_METHOD | Payment Method | ||||
| payment_terms | SNWD_SO_PAYMENT_TERM | Payment Terms |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- EPM: Sales Order Header Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_SO (
CLIENT, -- Client [MANDT]
NODE_KEY, -- Node Key [SNWD_NODE_KEY]
SO_ID, -- Sales Order ID [SNWD_SO_ID]
CREATED_BY, -- Node Key [SNWD_NODE_KEY]
CREATED_AT, -- Created At [SNWD_CREATED_AT]
CHANGED_BY, -- Node Key [SNWD_NODE_KEY]
CHANGED_AT, -- Changed At [SNWD_CHANGED_AT]
CREATED_BY_BP, -- Value [SNWD_BOOL]
CHANGED_BY_BP, -- Value [SNWD_BOOL]
NOTE_GUID, -- Node Key [SNWD_NODE_KEY]
BUYER_GUID, -- Node Key [SNWD_NODE_KEY]
CURRENCY_CODE, -- Currency Code [SNWD_CURR_CODE]
GROSS_AMOUNT, -- Gross Amount [SNWD_TTL_GROSS_AMOUNT]
NET_AMOUNT, -- Net Amount [SNWD_TTL_NET_AMOUNT]
TAX_AMOUNT, -- Tax Amount [SNWD_TTL_TAX_AMOUNT]
LIFECYCLE_STATUS, -- Lifecycle Status [SNWD_SO_LC_STATUS_CODE]
BILLING_STATUS, -- Confirmation Status [SNWD_SO_CF_STATUS_CODE]
DELIVERY_STATUS, -- Ordering Status [SNWD_SO_OR_STATUS_CODE]
OP_ID, -- Opportunity ID [SNWD_OP_ID]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
DUMMY, -- abap.char
OVERALL_STATUS, -- Overall Status [SNWD_SO_OA_STATUS_CODE]
BUY_CONTACT_GUID, -- Node Key [SNWD_NODE_KEY]
SHIP_TO_ADR_GUID, -- Node Key [SNWD_NODE_KEY]
BILL_TO_ADR_GUID, -- Node Key [SNWD_NODE_KEY]
PAYMENT_METHOD, -- Payment Method [SNWD_SO_PAYMENT_METHOD]
PAYMENT_TERMS, -- Payment Terms [SNWD_SO_PAYMENT_TERM]
PRIMARY KEY (CLIENT, NODE_KEY)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA