SND_PL_FA_I

Transparent Table Application Table
15 Fields 1 CDS Views

SAF-T PL : FA Item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PL_SAFTInvoiceItem view from BASIC SAF-T Invoice Item

Fields (15)

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 posnr posnr Item
inv_number saftn_pl_inv_number Inv.Number
description sgtxt Text
unit_mesaure meins Base Unit
quantity menge_d Quantity
unit_price saftn_pl_unit_price Unit Price
discounts saftn_pl_discounts Discounts
tax_base saftn_pl_tax_base Tax Base
tax_percent saftn_pl_tax_perc Tax Rate Code
waers 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 : FA Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SND_PL_FA_I (
    MANDT,          -- Client [mandt]
    EXTRACTION_ID,  -- Extraction ID [saftn_extraction_id]
    BELNR,          -- Document Number [belnr_d]
    GJAHR,          -- Fiscal Year [gjahr]
    BUKRS,          -- Company Code [bukrs]
    POSNR,          -- Item [posnr]
    INV_NUMBER,     -- Inv.Number [saftn_pl_inv_number]
    DESCRIPTION,    -- Text [sgtxt]
    UNIT_MESAURE,   -- Base Unit [meins]
    QUANTITY,       -- Quantity [menge_d]
    UNIT_PRICE,     -- Unit Price [saftn_pl_unit_price]
    DISCOUNTS,      -- Discounts [saftn_pl_discounts]
    TAX_BASE,       -- Tax Base [saftn_pl_tax_base]
    TAX_PERCENT,    -- Tax Rate Code [saftn_pl_tax_perc]
    WAERS,          -- Currency [waers]
    PRIMARY KEY (MANDT, EXTRACTION_ID, BELNR, GJAHR, BUKRS, POSNR)
);

Learn More