SND_PL_KR_I

Transparent Table Application Table
13 Fields 1 CDS Views

SAF-T PL : KR Items

SND_PL_KR_I is an SAP database table in S/4HANA. SAF-T PL : KR Items. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PL_SAFTJournalItem view from BASIC SAF-T Journal Item

Fields (13)

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 hkont hkont G/L Acct
KEY docln docln6 G/L Line Item
bukrs bukrs Company Code
sgtxt sgtxt Text
amount_d saftn_pl_debit_amount Db.Amt.Loc.Crcy
amount_c saftn_pl_credit_amount Cr.Amt.Loc.Crcy
doc_amount_d saftn_pl_doc_debit_amount Deb.Amt.Crcy.
doc_amount_c saftn_pl_doc_credit_amount Cred.Amt.Crcy.
doc_curr 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 : KR Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SND_PL_KR_I (
    MANDT,          -- Client [mandt]
    EXTRACTION_ID,  -- Extraction ID [saftn_extraction_id]
    BELNR,          -- Document Number [belnr_d]
    GJAHR,          -- Fiscal Year [gjahr]
    HKONT,          -- G/L Acct [hkont]
    DOCLN,          -- G/L Line Item [docln6]
    BUKRS,          -- Company Code [bukrs]
    SGTXT,          -- Text [sgtxt]
    AMOUNT_D,       -- Db.Amt.Loc.Crcy [saftn_pl_debit_amount]
    AMOUNT_C,       -- Cr.Amt.Loc.Crcy [saftn_pl_credit_amount]
    DOC_AMOUNT_D,   -- Deb.Amt.Crcy. [saftn_pl_doc_debit_amount]
    DOC_AMOUNT_C,   -- Cred.Amt.Crcy. [saftn_pl_doc_credit_amount]
    DOC_CURR,       -- Currency [waers]
    PRIMARY KEY (MANDT, EXTRACTION_ID, BELNR, GJAHR, HKONT, DOCLN)
);

Learn More