SND_PL_VAT

Transparent Table Application Table
57 Fields 1 CDS Views

SAF-T PL : VAT

SND_PL_VAT is an SAP database table in S/4HANA. SAF-T PL : VAT. It contains 57 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PL_SAFTTaxItem view from BASIC SAF-T Tax item

Fields (57)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY extraction_id saftn_extraction_id Extraction ID
KEY belnr belnr_d Document Number
KEY gjahr gjahr Fiscal Year
KEY bukrs bukrs Company Code
KEY source saftn_pl_source SAF-T PL : Source Data
doc_number_id saftn_pl_docn_id Document Number ID
bldat bldat Document Date
budat budat Posting Date
reindat reindat Inv. Recpt Date
vatdate vatdate Tax Reporting Date
delivery_date fbuda Serv. Rend. Dte
lifnr lifnr Supplier
kunnr kunnr Customer
stceg stceg VAT Reg. No.
xblnr xblnr Reference
xblnr_alt xblnr_alt Alt Refer
xcpdd xcpdd Individ. Set
waers waers Currency
blart blart Document Type
awtyp awtyp Ref. procedure
awkey awkey Reference Key
buzei buzei Item
k_10 saftn_pl_k_10 K_10
k_11 saftn_pl_k_11 K_11
k_12 saftn_pl_k_12 K_12
k_13 saftn_pl_k_13 K_13
k_14 saftn_pl_k_14 K_14
k_15 saftn_pl_k_15 K_15
k_16 saftn_pl_k_16 K_16
k_17 saftn_pl_k_17 K_17
k_18 saftn_pl_k_18 K_18
k_19 saftn_pl_k_19 K_19
k_20 saftn_pl_k_20 K_20
k_21 saftn_pl_k_21 K_21
k_22 saftn_pl_k_22 K_22
k_23 saftn_pl_k_23 K_23
k_24 saftn_pl_k_24 K_24
k_25 saftn_pl_k_25 K_25
k_26 saftn_pl_k_26 K_26
k_27 saftn_pl_k_27 K_27
k_28 saftn_pl_k_28 K_28
k_29 saftn_pl_k_29 K_29
k_30 saftn_pl_k_30 K_30
k_31 saftn_pl_k_31 K_31
k_32 saftn_pl_k_32 K_32
k_33 saftn_pl_k_33 K_33
k_34 saftn_pl_k_34 K_34
k_35 saftn_pl_k_35 K_35
k_36 saftn_pl_k_36 K_36
k_38 saftn_pl_k_38 K_38
k_39 saftn_pl_k_39 K_39
k_43 saftn_pl_k_43 K_43
k_44 saftn_pl_k_44 K_44
k_45 saftn_pl_k_45 K_45
k_46 saftn_pl_k_46 K_46
sgtxt sgtxt Text

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SND_PL_VAT (
    MANDT,          -- Client [mandt]
    EXTRACTION_ID,  -- Extraction ID [saftn_extraction_id]
    BELNR,          -- Document Number [belnr_d]
    GJAHR,          -- Fiscal Year [gjahr]
    BUKRS,          -- Company Code [bukrs]
    SOURCE,         -- SAF-T PL : Source Data [saftn_pl_source]
    DOC_NUMBER_ID,  -- Document Number ID [saftn_pl_docn_id]
    BLDAT,          -- Document Date [bldat]
    BUDAT,          -- Posting Date [budat]
    REINDAT,        -- Inv. Recpt Date [reindat]
    VATDATE,        -- Tax Reporting Date [vatdate]
    DELIVERY_DATE,  -- Serv. Rend. Dte [fbuda]
    LIFNR,          -- Supplier [lifnr]
    KUNNR,          -- Customer [kunnr]
    STCEG,          -- VAT Reg. No. [stceg]
    XBLNR,          -- Reference [xblnr]
    XBLNR_ALT,      -- Alt Refer [xblnr_alt]
    XCPDD,          -- Individ. Set [xcpdd]
    WAERS,          -- Currency [waers]
    BLART,          -- Document Type [blart]
    AWTYP,          -- Ref. procedure [awtyp]
    AWKEY,          -- Reference Key [awkey]
    BUZEI,          -- Item [buzei]
    K_10,           -- K_10 [saftn_pl_k_10]
    K_11,           -- K_11 [saftn_pl_k_11]
    K_12,           -- K_12 [saftn_pl_k_12]
    K_13,           -- K_13 [saftn_pl_k_13]
    K_14,           -- K_14 [saftn_pl_k_14]
    K_15,           -- K_15 [saftn_pl_k_15]
    K_16,           -- K_16 [saftn_pl_k_16]
    K_17,           -- K_17 [saftn_pl_k_17]
    K_18,           -- K_18 [saftn_pl_k_18]
    K_19,           -- K_19 [saftn_pl_k_19]
    K_20,           -- K_20 [saftn_pl_k_20]
    K_21,           -- K_21 [saftn_pl_k_21]
    K_22,           -- K_22 [saftn_pl_k_22]
    K_23,           -- K_23 [saftn_pl_k_23]
    K_24,           -- K_24 [saftn_pl_k_24]
    K_25,           -- K_25 [saftn_pl_k_25]
    K_26,           -- K_26 [saftn_pl_k_26]
    K_27,           -- K_27 [saftn_pl_k_27]
    K_28,           -- K_28 [saftn_pl_k_28]
    K_29,           -- K_29 [saftn_pl_k_29]
    K_30,           -- K_30 [saftn_pl_k_30]
    K_31,           -- K_31 [saftn_pl_k_31]
    K_32,           -- K_32 [saftn_pl_k_32]
    K_33,           -- K_33 [saftn_pl_k_33]
    K_34,           -- K_34 [saftn_pl_k_34]
    K_35,           -- K_35 [saftn_pl_k_35]
    K_36,           -- K_36 [saftn_pl_k_36]
    K_38,           -- K_38 [saftn_pl_k_38]
    K_39,           -- K_39 [saftn_pl_k_39]
    K_43,           -- K_43 [saftn_pl_k_43]
    K_44,           -- K_44 [saftn_pl_k_44]
    K_45,           -- K_45 [saftn_pl_k_45]
    K_46,           -- K_46 [saftn_pl_k_46]
    SGTXT,          -- Text [sgtxt]
    PRIMARY KEY (MANDT, EXTRACTION_ID, BELNR, GJAHR, BUKRS, SOURCE)
);

Learn More