SNWD_SO_INV_ITEM

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
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