SNWD_SO_I

Transparent Table Temporary Data
14 Fields 35 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 14 fields. 35 CDS views read from this table.

CDS Views using this table (35)

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_Complex_Core view union_all Core view with joins/unions/where-clause
I_SADL_Complex_Core view from Core view with joins/unions/where-clause
I_Sadl_DraftItem0Core view from BASIC Item core view
I_Sadl_DraftItem2Core view from BASIC Item core view
I_Sadl_DraftItemCore view from BASIC Item core view
I_Sadl_DraftLeafCore view inner BASIC Item core view
I_Sadl_Mk_Draft_Item_Core view from Test scenario: multiple key fields
I_Sadl_Mk_Draft_Item_IV_Core view from Test scenario: Invalid key fields
I_Sadl_Mk_Draft_Item_IW_Core view from Test scenario: Invalid key fields
I_Sadl_Mk_Draft_Item_IX_Core view from Test scenario: Invalid key fields
I_Sadl_Mk_Draft_Item_IY_Core view from Test scenario: Invalid key fields
I_Sadl_Mk_Draft_Item_IZ_Core view from Test scenario: Invalid key fields
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
SADL_V_EXP_SalesOrderItem view from
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
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

Fields (14)

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
dummy abap.char

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]
    DUMMY,            -- abap.char
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More