SNWD_SO_INV_ITEM

Transparent Table Temporary Data
13 Fields 6 CDS Views

EPM: Sales Order Invoice Items Table

SNWD_SO_INV_ITEM is an SAP database table in S/4HANA. EPM: Sales Order Invoice Items Table. It contains 13 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
DEMO_CDS_EPM_SO_INVOICE_ITEM view_entity from EPM Demo: Invoice Item
sepm_cds_so_invoice_item view from
SEPM_I_CustomerInvoiceItem view from EPM Demo: Customer Invoice Item
sepm_sddl_so_invoice_item view from
sepm_sum_all_invoices view from
sepm_sum_all_open_inv view from

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_guid SNWD_NODE_KEY Node Key
quantity SNWD_QUANTITY Quantity
quantity_unit SNWD_QUANTITY_UNIT Unit of Measure
gross_amount SNWD_TTL_GROSS_AMOUNT Gross Amount
net_amount SNWD_TTL_NET_AMOUNT Net Amount
tax_amount SNWD_TTL_TAX_AMOUNT Tax Amount
currency_code SNWD_CURR_CODE Currency Code
product_guid SNWD_NODE_KEY Node Key
inv_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 Invoice Items Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_SO_INV_ITEM (
    CLIENT,         -- Client [MANDT]
    NODE_KEY,       -- Node Key [SNWD_NODE_KEY]
    PARENT_KEY,     -- Node Key [SNWD_NODE_KEY]
    SO_ITEM_GUID,   -- Node Key [SNWD_NODE_KEY]
    QUANTITY,       -- Quantity [SNWD_QUANTITY]
    QUANTITY_UNIT,  -- Unit of Measure [SNWD_QUANTITY_UNIT]
    GROSS_AMOUNT,   -- Gross Amount [SNWD_TTL_GROSS_AMOUNT]
    NET_AMOUNT,     -- Net Amount [SNWD_TTL_NET_AMOUNT]
    TAX_AMOUNT,     -- Tax Amount [SNWD_TTL_TAX_AMOUNT]
    CURRENCY_CODE,  -- Currency Code [SNWD_CURR_CODE]
    PRODUCT_GUID,   -- Node Key [SNWD_NODE_KEY]
    INV_ITEM_POS,   -- Item Position [SNWD_SO_ITEM_POS]
    _DATAAGING,     -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More