CIM_D_ITM_GL

Transparent Table Application Table
62 Fields 1 CDS Views

Invoice Item: GL Account Acct Assignment

CIM_D_ITM_GL is an SAP database table in S/4HANA. Invoice Item: GL Account Acct Assignment. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PrmtHbRpldSuplrInvcItmGLAcct view from BASIC Procurement Hub Supplier Invoice Item GL Account

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prmthbrpldsuplrinvcitemuuid CIM_UUID UUID
prmthbrpldsupplierinvoiceuuid CIM_UUID UUID
prmthbrpldsupplierinvoice RE_BELNR Inv. Doc. No.
prmthbrpldsuplrinvcfiscalyear GJAHR Fiscal Year
procmthubcompanycode BUKRS Company Code
prmthbrpldsupplierinvoiceitem COBL_NR Seq. Number
supplierinvoiceitemamount WRBTR Amount
supplierinvoiceitemtext SGTXT Text
quantity MENGE_D Quantity
prmthbbaseunit MEINS Base Unit
prmthbtaxjurisdiction TXJCD Tax Jur.
procmthubtaxcode MWSKZ Tax Code
prmthbsuplrinvcitemcompanycode BUKRS Company Code
debitcreditcode SHKZG Debit/Credit
isnegativeposting XNEGP Negative Postg
isnotcashdiscountliable XSKRL W/o CashDsc.
taxtype MWART Tax Type
taxbaseamountintranscrcy FWBAS Base Amount
taxbaseamountincocodecrcy HWBAS LC Base
procmthubdocumentcurrency CIM_WAERS Currency Key
prmthbcompanycodecurrency CIM_HWAER Local Currency
procmthubmasterfixedasset ANLN1 Asset
procmthubfixedasset ANLN2 Sub-number
procmthubnetworkactivityintid CO_AUFPL Plan No.f.Oper.
prmthbinternalorder AUFNR Order
settlementreferencedate DABRBEZ Reference date
prmthbcommitmentitem FIPOS Commitment item
procmthubfundscenter FISTL Funds Center
procmthubfunctionalarea FKBER Functional Area
procmthubfund BP_GEBER Fund
prmthbgrantid GM_GRANT_NBR Grant
prmthbbusinessarea GSBER Business Area
prmthbrealestateobject IMKEY Real Estate Key
procmthubcontrollingarea KOKRS CO Area
procmthubcostcenter KOSTL Cost Center
prmthbcostobject KSTRG Cost Object
prmthbprofitabilitysegment RKEOBJNR Profit. segment
prmthbprofitcenter PRCTR Profit Center
procmthubwbselementinternalid PS_PSP_PNR WBS Element
jointventurecostrecoverycode RECID Inv.issue rule
procmthubglaccount SAKNR G/L Account
procmthubsalesorder VBELN SD Document
procmthubsalesorderitem VBELP Sales doc. item
prmthbjointventurepartner JV_PART Partner
prmthbcostctractivitytype LSTAR Activity Type
prmthbbusinessprocess CO_PRZNR Business Process
procmthubprojectnetworkintid CO_AUFPL Plan No.f.Oper.
assetvaluedate BZDAT Asset Val. Date
emrkdfndsitmprdcssrcompleted REFSETERLK Set "Completed"
prmthbfinancialmanagementarea FIKRS FM Area
prmthbearmarkedfunds KBLNR_FI Earmarked funds
prmthbearmarkedfundsitem KBLPOS Document Item
prmthbpartnerbusinessarea PARGB Trdg Part.BA
prmthbpersonnelnumber PERNR_D Personnel No.
procmthubprojectnetwork NPLNR Network
prmthbnetworkactivity VORNR Activity
assignmentreference DZUONR Assignment
prmthbsettlementfiscalyrperiod ABPER_RF Settl.Period
deliverycreationdate LEDAT Delivery Date
prmthbbudgetperiod FM_BUDGET_PERIOD Budget Period
prmthbfundedprogram FM_MEASURE Funded Program

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.

-- Invoice Item: GL Account Acct Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CIM_D_ITM_GL (
    MANDT,                           -- Client [MANDT]
    PRMTHBRPLDSUPLRINVCITEMUUID,     -- UUID [CIM_UUID]
    PRMTHBRPLDSUPPLIERINVOICEUUID,   -- UUID [CIM_UUID]
    PRMTHBRPLDSUPPLIERINVOICE,       -- Inv. Doc. No. [RE_BELNR]
    PRMTHBRPLDSUPLRINVCFISCALYEAR,   -- Fiscal Year [GJAHR]
    PROCMTHUBCOMPANYCODE,            -- Company Code [BUKRS]
    PRMTHBRPLDSUPPLIERINVOICEITEM,   -- Seq. Number [COBL_NR]
    SUPPLIERINVOICEITEMAMOUNT,       -- Amount [WRBTR]
    SUPPLIERINVOICEITEMTEXT,         -- Text [SGTXT]
    QUANTITY,                        -- Quantity [MENGE_D]
    PRMTHBBASEUNIT,                  -- Base Unit [MEINS]
    PRMTHBTAXJURISDICTION,           -- Tax Jur. [TXJCD]
    PROCMTHUBTAXCODE,                -- Tax Code [MWSKZ]
    PRMTHBSUPLRINVCITEMCOMPANYCODE,  -- Company Code [BUKRS]
    DEBITCREDITCODE,                 -- Debit/Credit [SHKZG]
    ISNEGATIVEPOSTING,               -- Negative Postg [XNEGP]
    ISNOTCASHDISCOUNTLIABLE,         -- W/o CashDsc. [XSKRL]
    TAXTYPE,                         -- Tax Type [MWART]
    TAXBASEAMOUNTINTRANSCRCY,        -- Base Amount [FWBAS]
    TAXBASEAMOUNTINCOCODECRCY,       -- LC Base [HWBAS]
    PROCMTHUBDOCUMENTCURRENCY,       -- Currency Key [CIM_WAERS]
    PRMTHBCOMPANYCODECURRENCY,       -- Local Currency [CIM_HWAER]
    PROCMTHUBMASTERFIXEDASSET,       -- Asset [ANLN1]
    PROCMTHUBFIXEDASSET,             -- Sub-number [ANLN2]
    PROCMTHUBNETWORKACTIVITYINTID,   -- Plan No.f.Oper. [CO_AUFPL]
    PRMTHBINTERNALORDER,             -- Order [AUFNR]
    SETTLEMENTREFERENCEDATE,         -- Reference date [DABRBEZ]
    PRMTHBCOMMITMENTITEM,            -- Commitment item [FIPOS]
    PROCMTHUBFUNDSCENTER,            -- Funds Center [FISTL]
    PROCMTHUBFUNCTIONALAREA,         -- Functional Area [FKBER]
    PROCMTHUBFUND,                   -- Fund [BP_GEBER]
    PRMTHBGRANTID,                   -- Grant [GM_GRANT_NBR]
    PRMTHBBUSINESSAREA,              -- Business Area [GSBER]
    PRMTHBREALESTATEOBJECT,          -- Real Estate Key [IMKEY]
    PROCMTHUBCONTROLLINGAREA,        -- CO Area [KOKRS]
    PROCMTHUBCOSTCENTER,             -- Cost Center [KOSTL]
    PRMTHBCOSTOBJECT,                -- Cost Object [KSTRG]
    PRMTHBPROFITABILITYSEGMENT,      -- Profit. segment [RKEOBJNR]
    PRMTHBPROFITCENTER,              -- Profit Center [PRCTR]
    PROCMTHUBWBSELEMENTINTERNALID,   -- WBS Element [PS_PSP_PNR]
    JOINTVENTURECOSTRECOVERYCODE,    -- Inv.issue rule [RECID]
    PROCMTHUBGLACCOUNT,              -- G/L Account [SAKNR]
    PROCMTHUBSALESORDER,             -- SD Document [VBELN]
    PROCMTHUBSALESORDERITEM,         -- Sales doc. item [VBELP]
    PRMTHBJOINTVENTUREPARTNER,       -- Partner [JV_PART]
    PRMTHBCOSTCTRACTIVITYTYPE,       -- Activity Type [LSTAR]
    PRMTHBBUSINESSPROCESS,           -- Business Process [CO_PRZNR]
    PROCMTHUBPROJECTNETWORKINTID,    -- Plan No.f.Oper. [CO_AUFPL]
    ASSETVALUEDATE,                  -- Asset Val. Date [BZDAT]
    EMRKDFNDSITMPRDCSSRCOMPLETED,    -- Set "Completed" [REFSETERLK]
    PRMTHBFINANCIALMANAGEMENTAREA,   -- FM Area [FIKRS]
    PRMTHBEARMARKEDFUNDS,            -- Earmarked funds [KBLNR_FI]
    PRMTHBEARMARKEDFUNDSITEM,        -- Document Item [KBLPOS]
    PRMTHBPARTNERBUSINESSAREA,       -- Trdg Part.BA [PARGB]
    PRMTHBPERSONNELNUMBER,           -- Personnel No. [PERNR_D]
    PROCMTHUBPROJECTNETWORK,         -- Network [NPLNR]
    PRMTHBNETWORKACTIVITY,           -- Activity [VORNR]
    ASSIGNMENTREFERENCE,             -- Assignment [DZUONR]
    PRMTHBSETTLEMENTFISCALYRPERIOD,  -- Settl.Period [ABPER_RF]
    DELIVERYCREATIONDATE,            -- Delivery Date [LEDAT]
    PRMTHBBUDGETPERIOD,              -- Budget Period [FM_BUDGET_PERIOD]
    PRMTHBFUNDEDPROGRAM,             -- Funded Program [FM_MEASURE]
    PRIMARY KEY (MANDT, PRMTHBRPLDSUPLRINVCITEMUUID)
);

Learn More