SNWD_SO_INV_HEAD

Transparent Table Temporary Data
16 Fields 10 CDS Views

EPM: Sales Order Invoice Header Table

SNWD_SO_INV_HEAD is an SAP database table in S/4HANA. EPM: Sales Order Invoice Header Table. It contains 16 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
DEMO_CDS_EPM_SO_INVOICE_HEADER view_entity from EPM Demo: Invoice Header
sepm_bupa_count_inv view from
sepm_bupa_dist_count view from
sepm_bupa_so_inv_num view from
sepm_bupa_total_amount view from
sepm_bupa_total_amount_alv view from
sepm_cds_so_invoice view from
SEPM_I_CustomerInvoice view from EPM Demo: Customer Invoice
sepm_sddl_so_invoice_header view from
sepm_sum_amount_view view from

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY node_key SNWD_NODE_KEY Node Key
so_guid SNWD_NODE_KEY Node Key
dly_note_number SNWD_DELIVERY_NOTE_NUMBER Delivery Note No.
created_by SNWD_NODE_KEY Node Key
created_at SNWD_CREATED_AT Created At
changed_by SNWD_NODE_KEY Node Key
changed_at SNWD_CHANGED_AT Changed At
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
buyer_guid SNWD_NODE_KEY Node Key
dunning_level SNWD_DUNNING_LEVEL Dunning Level
payment_status SNWD_SOI_PAYMENT_STATUS_CODE Payment Status
_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 Header Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_SO_INV_HEAD (
    CLIENT,           -- Client [MANDT]
    NODE_KEY,         -- Node Key [SNWD_NODE_KEY]
    SO_GUID,          -- Node Key [SNWD_NODE_KEY]
    DLY_NOTE_NUMBER,  -- Delivery Note No. [SNWD_DELIVERY_NOTE_NUMBER]
    CREATED_BY,       -- Node Key [SNWD_NODE_KEY]
    CREATED_AT,       -- Created At [SNWD_CREATED_AT]
    CHANGED_BY,       -- Node Key [SNWD_NODE_KEY]
    CHANGED_AT,       -- Changed At [SNWD_CHANGED_AT]
    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]
    BUYER_GUID,       -- Node Key [SNWD_NODE_KEY]
    DUNNING_LEVEL,    -- Dunning Level [SNWD_DUNNING_LEVEL]
    PAYMENT_STATUS,   -- Payment Status [SNWD_SOI_PAYMENT_STATUS_CODE]
    _DATAAGING,       -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More