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