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