SNC_PL_EXT_DOC

Transparent Table Application Table
10 Fields 2 CDS Views

SAF-T PL: VAT External Documents

SNC_PL_EXT_DOC is an SAP database table in S/4HANA. SAF-T PL: VAT External Documents. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PL_SAFTVatExternalDocument view_entity from BASIC SAF T PL VAT External Documents
P_PL_SNC_VAT_K_33_K_34 view_entity from BASIC SAF-T PL VAT External Documents

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY document_number saft_pl_acc_nr_comp Acc ID number comp.
KEY document_date dats Date
KEY tags saft_pl_vat_tags
KEY declaration_date saft_pl_vat_declaration_date Declaration Date
field_amount saft_pl_field_amount Amount
delivery_date dats Date
field_comment saft_pl_field_any_value Field Text
field_currency waers Currency

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.

-- SAF-T PL: VAT External Documents
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNC_PL_EXT_DOC (
    MANDT,             -- Client [mandt]
    BUKRS,             -- Company Code [bukrs]
    DOCUMENT_NUMBER,   -- Acc ID number comp. [saft_pl_acc_nr_comp]
    DOCUMENT_DATE,     -- Date [dats]
    TAGS,              -- saft_pl_vat_tags
    DECLARATION_DATE,  -- Declaration Date [saft_pl_vat_declaration_date]
    FIELD_AMOUNT,      -- Amount [saft_pl_field_amount]
    DELIVERY_DATE,     -- Date [dats]
    FIELD_COMMENT,     -- Field Text [saft_pl_field_any_value]
    FIELD_CURRENCY,    -- Currency [waers]
    PRIMARY KEY (MANDT, BUKRS, DOCUMENT_NUMBER, DOCUMENT_DATE, TAGS, DECLARATION_DATE)
);

Learn More