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. 85 CDS views read from this table.
CDS Views using this table (85)
| 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_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 | 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 | |
| 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_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 |
|---|---|---|---|
| KEY | client | MANDT | |
| KEY | node_key | SNWD_NODE_KEY | |
| so_id | SNWD_SO_ID | ||
| created_by | SNWD_NODE_KEY | ||
| created_at | SNWD_CREATED_AT | ||
| changed_by | SNWD_NODE_KEY | ||
| changed_at | SNWD_CHANGED_AT | ||
| created_by_bp | SNWD_BOOL | ||
| changed_by_bp | SNWD_BOOL | ||
| note_guid | SNWD_NODE_KEY | ||
| buyer_guid | SNWD_NODE_KEY | ||
| currency_code | SNWD_CURR_CODE | ||
| gross_amount | SNWD_TTL_GROSS_AMOUNT | ||
| net_amount | SNWD_TTL_NET_AMOUNT | ||
| tax_amount | SNWD_TTL_TAX_AMOUNT | ||
| lifecycle_status | SNWD_SO_LC_STATUS_CODE | ||
| billing_status | SNWD_SO_CF_STATUS_CODE | ||
| delivery_status | SNWD_SO_OR_STATUS_CODE | ||
| op_id | SNWD_OP_ID | ||
| _dataaging | DATA_TEMPERATURE | ||
| dummy | abap.char | ||
| overall_status | SNWD_SO_OA_STATUS_CODE | ||
| buy_contact_guid | SNWD_NODE_KEY | ||
| ship_to_adr_guid | SNWD_NODE_KEY | ||
| bill_to_adr_guid | SNWD_NODE_KEY | ||
| payment_method | SNWD_SO_PAYMENT_METHOD | ||
| payment_terms | SNWD_SO_PAYMENT_TERM |