SNWD_SO_I

Transparent Table Temporary Data
13 Fields 23 CDS Views

EPM: Sales Order Item Table

SNWD_SO_I is an SAP database table in S/4HANA. EPM: Sales Order Item Table. It contains 13 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
CDS_TDAI_WITH_CALCULATIONS view_entity from Calculations in SELECT list
CdsFrwk_Sales_Order_Item view from Calculations in SELECT list
Child_Cds view from CDS for Test Environment
DEMO_CDS_EPM_SALESORDERITEM view_entity from EPM Demo: Sales Order Item
I_Sadl_Voc_Salesorder_Item view from BASIC Vocan Core View: Sales Order Item
SADL_GwVAunitV2Soi view from Sales Order Item for local unit tests
SADL_GwVAunitV2VH_hidden view from CDS View for Value Help hidden
SADL_R_SO_ITEM view_entity from Sales Order Item Test
SADL_R_SO_SCHED_LINE view_entity inner Sales Order Schedule Line Test
Sadl_V_Action_Exposure_Item view from Test View for Action Exposure
SADL_V_AUnit_SOI view from Sales Order Item for local unit tests
SADL_V_AUnit_SOI_Agg view from Sales Order Item for local unit tests
SADL_V_AUnit_SOI_ConsumHidden view from Sales Order Item for local unit tests
SADL_V_EXP_Anno view from Annotation test
SADL_V_EXP_SalesOrderItem view from Unit Test SADL CDS Exposure: Sales Order Item
Sadl_V_Exp_Vocan_SOI view from Sales Order Items
Sadl_V_Perf_Soi view from Sales Order Performance Item Test
Sadl_V_Perf_Sosl view inner Schedule Lines Performance Test
sepm_cds_sales_order_item view from EPM CDS: Sales Order Item Information
SEPM_E_SalesOrderItem view from EPM Demo: Sales Order Item Extension
SEPM_I_SalesOrderItem view from EPM Demo: Sales Order Item
SEPM_I_SlsOrdItemScheduleLine view left_outer EPM Demo: Sales Order Item Schedule Line
sepm_sddl_salesorder_item view from EPM: DDL view for sales order item table

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
parent_key snwd_node_key Node Key
so_item_pos snwd_so_item_pos Item Position
product_guid snwd_node_key Node Key
note_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
item_atp_status snwd_so_item_atp_status_code ATP Status
op_item_pos snwd_so_item_pos Item Position
_dataaging data_temperature Data Aging

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 Item Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_SO_I (
    CLIENT,           -- Client [mandt]
    NODE_KEY,         -- Node Key [snwd_node_key]
    PARENT_KEY,       -- Node Key [snwd_node_key]
    SO_ITEM_POS,      -- Item Position [snwd_so_item_pos]
    PRODUCT_GUID,     -- Node Key [snwd_node_key]
    NOTE_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]
    ITEM_ATP_STATUS,  -- ATP Status [snwd_so_item_atp_status_code]
    OP_ITEM_POS,      -- Item Position [snwd_so_item_pos]
    _DATAAGING,       -- Data Aging [data_temperature]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More