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

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 Tags K_33, 34
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,              -- Tags K_33, 34 [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