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