SND_PL_FA_H

Transparent Table Application Table
45 Fields 1 CDS Views

SAF-T PL : FA Header

SND_PL_FA_H is an SAP database table in S/4HANA. SAF-T PL : FA Header. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PL_SAFTInvoiceHeader view from BASIC SAF-T Invoice Header

Fields (45)

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
inv_source saftn_pl_inv_source Invoice Source
inv_number saftn_pl_inv_number Inv.Number
inv_type saftn_pl_inv_type Invoice Type
bldat bldat Document Date
budat budat Posting Date
delivery_date saftn_pl_inv_deliv_date Delivery Date
lifnr lifnr Supplier
kunnr kunnr Customer
stceg stceg VAT Reg. No.
xcpdd xcpdd Individ. Set
buzei buzei Item
corr_reason saftn_pl_reason Correction Reason
corr_inv_ref saftn_pl_corr_inv_ref Corr.Inv.Ref
corr_inv_date saftn_pl_corr_inv_date Corr.Inv.Date
p_13_1 saftn_pl_p_13_1 P_13_1
p_14_1 saftn_pl_p_14_1 P_14_1
p_13_2 saftn_pl_p_13_2 P_13_2
p_14_2 saftn_pl_p_14_2 P_14_2
p_13_3 saftn_pl_p_13_3 P_13_3
p_14_3 saftn_pl_p_14_3 P_14_3
p_13_4 saftn_pl_p_13_4 P_13_4
p_14_4 saftn_pl_p_14_4 P_14_4
p_13_5 saftn_pl_p_13_4 P_13_4
p_14_5 saftn_pl_p_14_5 P_14_5
p_13_6 saftn_pl_p_13_6 P_13_6
p_13_7 saftn_pl_p_13_4 P_13_4
exempt_reason saftn_pl_exemption_reason Tax Exemp.Reason
p_15 saftn_pl_p_15 P_15
waers waers Currency
p_18 saftn_pl_p_18 Rev. Charge Flag
p_23 saftn_pl_p_23 Intra-C. T. T. Flag
p_14_1w saftn_pl_p_14_1w P_14_1W
p_14_2w saftn_pl_p_14_2w P_14_2W
p_14_3w saftn_pl_p_14_3w P_14_3W
p_14_4w saftn_pl_p_14_4w P_14_4W
comp_total_gross saftn_pl_comp_total_gross TotalGross
split_paym_ind saftn_pl_split_paym_ind Split Payment Ind.
dp_prev_inv saftn_pl_dp_prev_inv Prev. Invoices DP
dp_src_order_id saftn_pl_dp_src_order_id DP Sales Document
dp_src_order_amnt saftn_pl_dp_src_order_amnt DP Sales Doc. Amount

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 : FA Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SND_PL_FA_H (
    MANDT,              -- Client [mandt]
    EXTRACTION_ID,      -- Extraction ID [saftn_extraction_id]
    BELNR,              -- Document Number [belnr_d]
    GJAHR,              -- Fiscal Year [gjahr]
    BUKRS,              -- Company Code [bukrs]
    INV_SOURCE,         -- Invoice Source [saftn_pl_inv_source]
    INV_NUMBER,         -- Inv.Number [saftn_pl_inv_number]
    INV_TYPE,           -- Invoice Type [saftn_pl_inv_type]
    BLDAT,              -- Document Date [bldat]
    BUDAT,              -- Posting Date [budat]
    DELIVERY_DATE,      -- Delivery Date [saftn_pl_inv_deliv_date]
    LIFNR,              -- Supplier [lifnr]
    KUNNR,              -- Customer [kunnr]
    STCEG,              -- VAT Reg. No. [stceg]
    XCPDD,              -- Individ. Set [xcpdd]
    BUZEI,              -- Item [buzei]
    CORR_REASON,        -- Correction Reason [saftn_pl_reason]
    CORR_INV_REF,       -- Corr.Inv.Ref [saftn_pl_corr_inv_ref]
    CORR_INV_DATE,      -- Corr.Inv.Date [saftn_pl_corr_inv_date]
    P_13_1,             -- P_13_1 [saftn_pl_p_13_1]
    P_14_1,             -- P_14_1 [saftn_pl_p_14_1]
    P_13_2,             -- P_13_2 [saftn_pl_p_13_2]
    P_14_2,             -- P_14_2 [saftn_pl_p_14_2]
    P_13_3,             -- P_13_3 [saftn_pl_p_13_3]
    P_14_3,             -- P_14_3 [saftn_pl_p_14_3]
    P_13_4,             -- P_13_4 [saftn_pl_p_13_4]
    P_14_4,             -- P_14_4 [saftn_pl_p_14_4]
    P_13_5,             -- P_13_4 [saftn_pl_p_13_4]
    P_14_5,             -- P_14_5 [saftn_pl_p_14_5]
    P_13_6,             -- P_13_6 [saftn_pl_p_13_6]
    P_13_7,             -- P_13_4 [saftn_pl_p_13_4]
    EXEMPT_REASON,      -- Tax Exemp.Reason [saftn_pl_exemption_reason]
    P_15,               -- P_15 [saftn_pl_p_15]
    WAERS,              -- Currency [waers]
    P_18,               -- Rev. Charge Flag [saftn_pl_p_18]
    P_23,               -- Intra-C. T. T. Flag [saftn_pl_p_23]
    P_14_1W,            -- P_14_1W [saftn_pl_p_14_1w]
    P_14_2W,            -- P_14_2W [saftn_pl_p_14_2w]
    P_14_3W,            -- P_14_3W [saftn_pl_p_14_3w]
    P_14_4W,            -- P_14_4W [saftn_pl_p_14_4w]
    COMP_TOTAL_GROSS,   -- TotalGross [saftn_pl_comp_total_gross]
    SPLIT_PAYM_IND,     -- Split Payment Ind. [saftn_pl_split_paym_ind]
    DP_PREV_INV,        -- Prev. Invoices DP [saftn_pl_dp_prev_inv]
    DP_SRC_ORDER_ID,    -- DP Sales Document [saftn_pl_dp_src_order_id]
    DP_SRC_ORDER_AMNT,  -- DP Sales Doc. Amount [saftn_pl_dp_src_order_amnt]
    PRIMARY KEY (MANDT, EXTRACTION_ID, BELNR, GJAHR, BUKRS)
);

Learn More