CFIN_TMP_IT

Transparent Table Application Table
32 Fields 2 CDS Views

changeable item data for temporary postings

CFIN_TMP_IT is an SAP database table in S/4HANA. changeable item data for temporary postings. It contains 32 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_CFinTemporaryPostingItem view_entity from EXTENSION Temporary Posting Item - Extn
I_CFinTemporaryPostingItem view_entity from BASIC CFIN Temporary Posting Item

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY msgguid GUID_32 GUID 16
KEY posnr POSNR_ACC Position
KEY logsystem_sender LOGSYSTEM_SENDER Sender Log Sys.
KEY bukrs_sender BUKRS_SENDER Sender CoCode
KEY belnr_sender BELNR_SENDER Sender Doc.No.
KEY gjahr_sender GJAHR_SENDER Sender FiscalYr
bukrs BUKRS Company Code
gjahr GJAHR Fiscal Year
buzei BUZEI Item
bschl BSCHL Posting Key
dmbtr DMBTR Amount in LC
currkey_10 FAGL_CURRKEY_10 CCode Currency
wrbtr WRBTR Amount
waers WAERS Currency
shkzg SHKZG Debit/Credit
mwskz MWSKZ Tax Code
umskz UMSKZ Special G/L Ind
kokrs KOKRS CO Area
kostl KOSTL Cost Center
prctr PRCTR Profit Center
hkont HKONT G/L Acct
koart KOART Account type
kunnr KUNNR Customer
lifnr LIFNR Supplier
vbund VBUND Company ID
matnr MATNR Material
rmvct RMVCT Transact. Type
currkey_30 FAGL_CURRKEY_30 Group Currency
dmbe2 DMBE2 LC2 Amount
last_changed_at ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
dummy_field abap.char

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.

-- changeable item data for temporary postings
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CFIN_TMP_IT (
    MANDT,             -- Client [MANDT]
    MSGGUID,           -- GUID 16 [GUID_32]
    POSNR,             -- Position [POSNR_ACC]
    LOGSYSTEM_SENDER,  -- Sender Log Sys. [LOGSYSTEM_SENDER]
    BUKRS_SENDER,      -- Sender CoCode [BUKRS_SENDER]
    BELNR_SENDER,      -- Sender Doc.No. [BELNR_SENDER]
    GJAHR_SENDER,      -- Sender FiscalYr [GJAHR_SENDER]
    BUKRS,             -- Company Code [BUKRS]
    GJAHR,             -- Fiscal Year [GJAHR]
    BUZEI,             -- Item [BUZEI]
    BSCHL,             -- Posting Key [BSCHL]
    DMBTR,             -- Amount in LC [DMBTR]
    CURRKEY_10,        -- CCode Currency [FAGL_CURRKEY_10]
    WRBTR,             -- Amount [WRBTR]
    WAERS,             -- Currency [WAERS]
    SHKZG,             -- Debit/Credit [SHKZG]
    MWSKZ,             -- Tax Code [MWSKZ]
    UMSKZ,             -- Special G/L Ind [UMSKZ]
    KOKRS,             -- CO Area [KOKRS]
    KOSTL,             -- Cost Center [KOSTL]
    PRCTR,             -- Profit Center [PRCTR]
    HKONT,             -- G/L Acct [HKONT]
    KOART,             -- Account type [KOART]
    KUNNR,             -- Customer [KUNNR]
    LIFNR,             -- Supplier [LIFNR]
    VBUND,             -- Company ID [VBUND]
    MATNR,             -- Material [MATNR]
    RMVCT,             -- Transact. Type [RMVCT]
    CURRKEY_30,        -- Group Currency [FAGL_CURRKEY_30]
    DMBE2,             -- LC2 Amount [DMBE2]
    LAST_CHANGED_AT,   -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    DUMMY_FIELD,       -- abap.char
    PRIMARY KEY (MANDT, MSGGUID, POSNR, LOGSYSTEM_SENDER, BUKRS_SENDER, BELNR_SENDER, GJAHR_SENDER)
);

Learn More