SNWD_SO

Transparent Table Temporary Data
22 Fields 85 CDS Views

EPM: Sales Order Header Table

SNWD_SO is an SAP database table in S/4HANA. EPM: Sales Order Header Table. It contains 22 fields. 85 CDS views read from this table.

CDS Views using this table (85)

ViewTypeJoinVDMDescription
/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 (22)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
so_id snwd_so_id Sales Order ID
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
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_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]
    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