CIM_D_ITM_POREF

Transparent Table Application Table
62 Fields 1 CDS Views

Invoice Item: Purchase Order Reference

CIM_D_ITM_POREF is an SAP database table in S/4HANA. Invoice Item: Purchase Order Reference. It contains 62 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PrmtHbRpldSuplrInvcItmPORef view from BASIC Procurement Hub Supplier Invoice Item Purchase Order Ref.

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prmthbrpldsuplrinvcitemuuid CIM_UUID UUID
prmthbrpldsupplierinvoiceuuid CIM_UUID UUID
prmthbrpldpurchaseorder EBELN Purchasing Doc.
prmthbrpldpurchaseorderitem EBELP Item
inbounddeliverynote XBLNR1 Reference
prmthbsuplrinvcdelivcndnstp STUNR Step Number
prmthbsuplrinvcdeliverycndnct DZAEHK Counter
prmthbsuplrinvcdelivcndntype KSCHL Condition Type
prmthbreferencedocument LFBNR Reference Doc.
prmthbreferencedocumentfsclyr LFGJA Year Cur.Period
prmthbreferencedocumentitem LFPOS Ref. Doc. Item
griraccountisbalanced MMWEREC GR/IR Clearing
inboundbilloflading FRBNR1 Bill of Lading
prmthbrpldsupplierinvoice RE_BELNR Inv. Doc. No.
prmthbrpldsuplrinvcfiscalyear GJAHR Fiscal Year
procmthubcompanycode BUKRS Company Code
prmthbrpldsupplierinvoiceitem RBLGP Item
procmthubdocumentcurrency CIM_WAERS Currency Key
procmthubproduct MATNR Material
supplierinvoiceitemdescription TXZ01 Short Text
prmthbvaluationarea BWKEY Valuation Area
prmthbinventoryvaluationtype BWTAR_D Valuation Type
prmthbsuplrinvcitemcompanycode BUKRS Company Code
procmthubplant WERKS_D Plant
supplierinvoiceitemamount WRBTR Amount
debitcreditcode SHKZG Debit/Credit
procmthubtaxcode MWSKZ Tax Code
prmthbtaxjurisdiction TXJCD Tax Jur.
quantityinpurchaseorderunit MENGE_D Quantity
procmthuborderquantityunit BSTME Order Unit
qtyinpurchaseorderpriceunit BPMNG Qty in OPUn
procmthuborderpriceunit BPRME PO Price Unit
procmthubpurgdocitmcategory PSTYP Item Category
procmthubacctassgmtcategory KNTTP Acct Assgmt Cat
prmthbvaluationclass BKLAS Valuation Class
isfinallyinvoiced EREKZ Final Invoice
issubsequentdebitcredit TBTKZ Subseq. Dr/Cr
suplrinvcitemhaspricevariance SPGRP Block.Reas.:Prc
suplrinvcitemhasqtyvariance SPGRM Block.Reas.:Qty
suplrinvcitemhasdatevariance SPGRT Bl. Reason Date
suplrinvcitemhasordprcqtyvarc SPGRG Block.Reas: OPQ
suplrinvcitemhasprojbdgtvarc SPGRV Block.Reas:Proj
suplrinvcitemhasothervariance SPGRQ Man.Block.Reasn
suplrinvcitemhasamountoutsdtol SPGRS Blkg Reas. Amount
suplrinvcitmhasqualityvariance SPGRC Block: Quality
suplrinvcitemhasextdfndvarc SPGREXT Block Reason
quantityasperinvoicingparty RBMNG Inv. Doc. Qty
amountasperinvoicingparty CIM_RBWWR Invoice Amount
suplrinvcverificatsuplrerrtype LFEHL Supplier Error
procmthubmmservicepackage PACKNO_EKBE Package Number
procmthubmmservicepackageline INTROW_EKBE Service line
supplierinvoiceitemtext SGTXT Text
isnotcashdiscountliable XSKRL W/o CashDsc.
suplrinvcitemcorrectionind KZMEKORR Correction ID
procmthubsupplier LIFNR Supplier
prmthbsuplrinvccomplaintreason COMPLAINT_REASON Complaints Reason
retentionamountindoccurrency CIM_RET_AMT_FC Amount in Doc Curre.
retentionpercentage RETPZ Retention %
retentionduedate RET_DUE_DATE Due Date
retentionamountisnetamount RET_TAXNET Tax Reduction
prmthbcashledgeraccount FAGL_RE_ACCOUNT Ex/Rv A/c in CL

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: Purchase Order Reference
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CIM_D_ITM_POREF (
    MANDT,                           -- Client [MANDT]
    PRMTHBRPLDSUPLRINVCITEMUUID,     -- UUID [CIM_UUID]
    PRMTHBRPLDSUPPLIERINVOICEUUID,   -- UUID [CIM_UUID]
    PRMTHBRPLDPURCHASEORDER,         -- Purchasing Doc. [EBELN]
    PRMTHBRPLDPURCHASEORDERITEM,     -- Item [EBELP]
    INBOUNDDELIVERYNOTE,             -- Reference [XBLNR1]
    PRMTHBSUPLRINVCDELIVCNDNSTP,     -- Step Number [STUNR]
    PRMTHBSUPLRINVCDELIVERYCNDNCT,   -- Counter [DZAEHK]
    PRMTHBSUPLRINVCDELIVCNDNTYPE,    -- Condition Type [KSCHL]
    PRMTHBREFERENCEDOCUMENT,         -- Reference Doc. [LFBNR]
    PRMTHBREFERENCEDOCUMENTFSCLYR,   -- Year Cur.Period [LFGJA]
    PRMTHBREFERENCEDOCUMENTITEM,     -- Ref. Doc. Item [LFPOS]
    GRIRACCOUNTISBALANCED,           -- GR/IR Clearing [MMWEREC]
    INBOUNDBILLOFLADING,             -- Bill of Lading [FRBNR1]
    PRMTHBRPLDSUPPLIERINVOICE,       -- Inv. Doc. No. [RE_BELNR]
    PRMTHBRPLDSUPLRINVCFISCALYEAR,   -- Fiscal Year [GJAHR]
    PROCMTHUBCOMPANYCODE,            -- Company Code [BUKRS]
    PRMTHBRPLDSUPPLIERINVOICEITEM,   -- Item [RBLGP]
    PROCMTHUBDOCUMENTCURRENCY,       -- Currency Key [CIM_WAERS]
    PROCMTHUBPRODUCT,                -- Material [MATNR]
    SUPPLIERINVOICEITEMDESCRIPTION,  -- Short Text [TXZ01]
    PRMTHBVALUATIONAREA,             -- Valuation Area [BWKEY]
    PRMTHBINVENTORYVALUATIONTYPE,    -- Valuation Type [BWTAR_D]
    PRMTHBSUPLRINVCITEMCOMPANYCODE,  -- Company Code [BUKRS]
    PROCMTHUBPLANT,                  -- Plant [WERKS_D]
    SUPPLIERINVOICEITEMAMOUNT,       -- Amount [WRBTR]
    DEBITCREDITCODE,                 -- Debit/Credit [SHKZG]
    PROCMTHUBTAXCODE,                -- Tax Code [MWSKZ]
    PRMTHBTAXJURISDICTION,           -- Tax Jur. [TXJCD]
    QUANTITYINPURCHASEORDERUNIT,     -- Quantity [MENGE_D]
    PROCMTHUBORDERQUANTITYUNIT,      -- Order Unit [BSTME]
    QTYINPURCHASEORDERPRICEUNIT,     -- Qty in OPUn [BPMNG]
    PROCMTHUBORDERPRICEUNIT,         -- PO Price Unit [BPRME]
    PROCMTHUBPURGDOCITMCATEGORY,     -- Item Category [PSTYP]
    PROCMTHUBACCTASSGMTCATEGORY,     -- Acct Assgmt Cat [KNTTP]
    PRMTHBVALUATIONCLASS,            -- Valuation Class [BKLAS]
    ISFINALLYINVOICED,               -- Final Invoice [EREKZ]
    ISSUBSEQUENTDEBITCREDIT,         -- Subseq. Dr/Cr [TBTKZ]
    SUPLRINVCITEMHASPRICEVARIANCE,   -- Block.Reas.:Prc [SPGRP]
    SUPLRINVCITEMHASQTYVARIANCE,     -- Block.Reas.:Qty [SPGRM]
    SUPLRINVCITEMHASDATEVARIANCE,    -- Bl. Reason Date [SPGRT]
    SUPLRINVCITEMHASORDPRCQTYVARC,   -- Block.Reas: OPQ [SPGRG]
    SUPLRINVCITEMHASPROJBDGTVARC,    -- Block.Reas:Proj [SPGRV]
    SUPLRINVCITEMHASOTHERVARIANCE,   -- Man.Block.Reasn [SPGRQ]
    SUPLRINVCITEMHASAMOUNTOUTSDTOL,  -- Blkg Reas. Amount [SPGRS]
    SUPLRINVCITMHASQUALITYVARIANCE,  -- Block: Quality [SPGRC]
    SUPLRINVCITEMHASEXTDFNDVARC,     -- Block Reason [SPGREXT]
    QUANTITYASPERINVOICINGPARTY,     -- Inv. Doc. Qty [RBMNG]
    AMOUNTASPERINVOICINGPARTY,       -- Invoice Amount [CIM_RBWWR]
    SUPLRINVCVERIFICATSUPLRERRTYPE,  -- Supplier Error [LFEHL]
    PROCMTHUBMMSERVICEPACKAGE,       -- Package Number [PACKNO_EKBE]
    PROCMTHUBMMSERVICEPACKAGELINE,   -- Service line [INTROW_EKBE]
    SUPPLIERINVOICEITEMTEXT,         -- Text [SGTXT]
    ISNOTCASHDISCOUNTLIABLE,         -- W/o CashDsc. [XSKRL]
    SUPLRINVCITEMCORRECTIONIND,      -- Correction ID [KZMEKORR]
    PROCMTHUBSUPPLIER,               -- Supplier [LIFNR]
    PRMTHBSUPLRINVCCOMPLAINTREASON,  -- Complaints Reason [COMPLAINT_REASON]
    RETENTIONAMOUNTINDOCCURRENCY,    -- Amount in Doc Curre. [CIM_RET_AMT_FC]
    RETENTIONPERCENTAGE,             -- Retention % [RETPZ]
    RETENTIONDUEDATE,                -- Due Date [RET_DUE_DATE]
    RETENTIONAMOUNTISNETAMOUNT,      -- Tax Reduction [RET_TAXNET]
    PRMTHBCASHLEDGERACCOUNT,         -- Ex/Rv A/c in CL [FAGL_RE_ACCOUNT]
    PRIMARY KEY (MANDT, PRMTHBRPLDSUPLRINVCITEMUUID)
);

Learn More