CIM_D_HEADER

Transparent Table Application Table
93 Fields 1 CDS Views

Invoice Header

CIM_D_HEADER is an SAP database table in S/4HANA. Invoice Header. It contains 93 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PrmtHbRpldSupplierInvoice view from BASIC Procurement Hub Supplier Invoice

Fields (93)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prmthbrpldsupplierinvoiceuuid CIM_UUID UUID
procurementhubsourcesystem MMPUR_D_SOURCE_SYS Connected System ID
procmthubsupplierinvoicestatus CIM_INVOICE_STATUS Invoice Status
procmthubsupplierinvoicesource CIM_INVOICE_SOURCE Source
procmthubsupplierinvoiceorigin CIM_INVOICE_ORIGIN Invoice Origin
procmthublastxtrctndtetme TIMESTAMPL Time Stamp
prmthbrpldsupplierinvoice RE_BELNR Inv. Doc. No.
prmthbrpldsuplrinvcfiscalyear GJAHR Fiscal Year
prmthbaccountingdocumenttype BLART Document Type
documentdate BLDAT Document Date
postingdate BUDAT Posting Date
prmthblastchangedbyuser USNAM User Name
supplierinvoiceidbyinvcgparty XBLNR1 Reference
procmthubcompanycode BUKRS Company Code
invoicingparty LIFRE Invoicing Party
procmthubdocumentcurrency CIM_WAERS Currency Key
prmthbcompanycodecurrency CIM_HWAER Local Currency
exchangerate KURSF Exchange rate
invoicegrossamount CIM_RMWWR Gross Invoice Amount
unplanneddeliverycost CIM_BEZNK Unpl. Delivery Costs
taxdeterminationdate TXDAT Tax Date
taxcodevalidfrom FOT_TXDAT_FROM Tax Rate Valid-From
procmthubpaymentterms DZTERM Pyt Terms
cashdiscount1percent DZBD1P CD Percentage 1
cashdiscount1days DZBD1T Days 1
cashdiscount2percent DZBD2P CD Percentage 2
cashdiscount2days DZBD2T Days 2
netpaymentdays DZBD3T Days Net
cashdiscount1duedate SK1DT Cash Discount 1
cashdiscount2duedate SK2DT Cash Discount 2
netduedate NETDT Due On
manualcashdiscount WSKTO CD Amount
isinvoice XRECH Invoice
documentheadertext BKTXT Doc.Header Text
taxiscalculatedautomatically XMWST Calculate Tax
prmthbreversedocument RE_STBLG Reversed by
prmthbreversedocumentfiscalyr RE_STJAH Year
prmthbunplnddelivcosttaxcode MWSKZ_MRM Tax Code
prmthbunplnddelivcosttaxjx TXJCD Tax Jur.
supplierinvoiceorigin IVTYP IV category
supplierinvoicestatus RBSTAT Inv. status
prmthbsuplrinvcpricingdocument KNUMVE Doc. condition
prmthbsuplrinvcsuplrprcgdoc KNUMVL Supplier Cond.
suplrinvcautomreductionnetamt CIM_ARKUEN Reduced Amount
suplrinvcautomreductiontaxamt CIM_ARKUEMW Tax Inv. Reduction
suplrinvcautomreducedamount CIM_ARKUE_GROSS Reduced Amount
suplrinvcmnlaccepteddiffnetamt CIM_MAKZN NetAmount
suplrinvcmnlaccepteddifftaxamt CIM_MAKZMW Tax Accptd Manually
suplrinvcmanualaccepteddiffamt CIM_MAKZ_GROSS Gross Amount
suplrinvcmanualreductionnetamt CIM_LIEFFN Supplier Error
suplrinvcmanualreductiontaxamt CIM_LIEFFMW Tax in Suppl. Error
suplrinvcmanuallyreducedamount CIM_LIEFF_GROSS Supplier Error
suplrinvchassmalldifferences XAUTAKZ Auto. accepted
prmthbpaytslipwthrefsubscriber ESRNR ISR Number
paytslipwthrefcheckdigit ESRPZ Check digit
paytslipwthrefreference ESRRE ISR/QR Ref.
withholdingtaxbaseamount QSSHB WTax Base
withholdingtaxexemptionamt QSFBT WTax-Exempt
prmthbwithholdingtaxcode QSSKZ WTax Code
isservice DIEKZ Service Ind.
prmthbsupplyingcountry LANDL Supply C/R
prmthbstatecentralbankpaytrsn LZBKZ SCB Ind.
taxexchangerate TXKRS_BKPF Rate for Taxes
prmthbpayee EMPFB Payer
prmthbsupplierbanktype BVTYP Part.bank type
prmthbhousebank HBKID House Bank
assignmentreference DZUONR Assignment
prmthbpaymentblockingreason DZLSPR Pmnt block
prmthbpaymentmethod DZLSCH Pymt Meth.
duecalculationbasedate DZFBDT Baseline Date
paymentreference KIDNO Payment Ref.
prmthbinvoicereference AWREF_REB InR.Ref.no.
prmthbinvoicereferencefiscalyr REBZJ Fiscal Year
suplrinvciscapitalgoodsrelated XINVE Invest.ID
prmthbdeliveryofgoodsrptgcntry EGMLD_BSEZ Reporting C/R
iseutriangulardeal XEGDR EU Triang. Deal
taxreportingdate VATDATE Tax Reporting Date
prmthbpostingfiscalperiod MONAT Period
isendofpurposeblocked EOPBLOCKED Busin. Purp. Cmpltd.
suplrinvcextcreatedbyuser ERNAME Created by
invoicereceiptdate REINDAT Inv. Recpt Date
paymentmethodsupplement UZAWE Pmnt Meth. Sup.
prmthbplanninglevel FDLEV Planning Level
planningdate FDTAG Planning Date
fixedcashdiscount DZBFIX Fixed
procmthubcreatedbyuser ERFNAM Entered By
prmthbbusinessplace BUPLA Business place
prmthbbranchaccount FILKD Branch
prmthbbusinessarea GSBER Business Area
supplierpostinglineitemtext SGTXT Text
supplierinvoiceamountissplit CIM_INV_AMOUNT_IS_SPLITTED Amount Split
creationdate CPUDT Entered On

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CIM_D_HEADER (
    MANDT,                           -- Client [MANDT]
    PRMTHBRPLDSUPPLIERINVOICEUUID,   -- UUID [CIM_UUID]
    PROCUREMENTHUBSOURCESYSTEM,      -- Connected System ID [MMPUR_D_SOURCE_SYS]
    PROCMTHUBSUPPLIERINVOICESTATUS,  -- Invoice Status [CIM_INVOICE_STATUS]
    PROCMTHUBSUPPLIERINVOICESOURCE,  -- Source [CIM_INVOICE_SOURCE]
    PROCMTHUBSUPPLIERINVOICEORIGIN,  -- Invoice Origin [CIM_INVOICE_ORIGIN]
    PROCMTHUBLASTXTRCTNDTETME,       -- Time Stamp [TIMESTAMPL]
    PRMTHBRPLDSUPPLIERINVOICE,       -- Inv. Doc. No. [RE_BELNR]
    PRMTHBRPLDSUPLRINVCFISCALYEAR,   -- Fiscal Year [GJAHR]
    PRMTHBACCOUNTINGDOCUMENTTYPE,    -- Document Type [BLART]
    DOCUMENTDATE,                    -- Document Date [BLDAT]
    POSTINGDATE,                     -- Posting Date [BUDAT]
    PRMTHBLASTCHANGEDBYUSER,         -- User Name [USNAM]
    SUPPLIERINVOICEIDBYINVCGPARTY,   -- Reference [XBLNR1]
    PROCMTHUBCOMPANYCODE,            -- Company Code [BUKRS]
    INVOICINGPARTY,                  -- Invoicing Party [LIFRE]
    PROCMTHUBDOCUMENTCURRENCY,       -- Currency Key [CIM_WAERS]
    PRMTHBCOMPANYCODECURRENCY,       -- Local Currency [CIM_HWAER]
    EXCHANGERATE,                    -- Exchange rate [KURSF]
    INVOICEGROSSAMOUNT,              -- Gross Invoice Amount [CIM_RMWWR]
    UNPLANNEDDELIVERYCOST,           -- Unpl. Delivery Costs [CIM_BEZNK]
    TAXDETERMINATIONDATE,            -- Tax Date [TXDAT]
    TAXCODEVALIDFROM,                -- Tax Rate Valid-From [FOT_TXDAT_FROM]
    PROCMTHUBPAYMENTTERMS,           -- Pyt Terms [DZTERM]
    CASHDISCOUNT1PERCENT,            -- CD Percentage 1 [DZBD1P]
    CASHDISCOUNT1DAYS,               -- Days 1 [DZBD1T]
    CASHDISCOUNT2PERCENT,            -- CD Percentage 2 [DZBD2P]
    CASHDISCOUNT2DAYS,               -- Days 2 [DZBD2T]
    NETPAYMENTDAYS,                  -- Days Net [DZBD3T]
    CASHDISCOUNT1DUEDATE,            -- Cash Discount 1 [SK1DT]
    CASHDISCOUNT2DUEDATE,            -- Cash Discount 2 [SK2DT]
    NETDUEDATE,                      -- Due On [NETDT]
    MANUALCASHDISCOUNT,              -- CD Amount [WSKTO]
    ISINVOICE,                       -- Invoice [XRECH]
    DOCUMENTHEADERTEXT,              -- Doc.Header Text [BKTXT]
    TAXISCALCULATEDAUTOMATICALLY,    -- Calculate Tax [XMWST]
    PRMTHBREVERSEDOCUMENT,           -- Reversed by [RE_STBLG]
    PRMTHBREVERSEDOCUMENTFISCALYR,   -- Year [RE_STJAH]
    PRMTHBUNPLNDDELIVCOSTTAXCODE,    -- Tax Code [MWSKZ_MRM]
    PRMTHBUNPLNDDELIVCOSTTAXJX,      -- Tax Jur. [TXJCD]
    SUPPLIERINVOICEORIGIN,           -- IV category [IVTYP]
    SUPPLIERINVOICESTATUS,           -- Inv. status [RBSTAT]
    PRMTHBSUPLRINVCPRICINGDOCUMENT,  -- Doc. condition [KNUMVE]
    PRMTHBSUPLRINVCSUPLRPRCGDOC,     -- Supplier Cond. [KNUMVL]
    SUPLRINVCAUTOMREDUCTIONNETAMT,   -- Reduced Amount [CIM_ARKUEN]
    SUPLRINVCAUTOMREDUCTIONTAXAMT,   -- Tax Inv. Reduction [CIM_ARKUEMW]
    SUPLRINVCAUTOMREDUCEDAMOUNT,     -- Reduced Amount [CIM_ARKUE_GROSS]
    SUPLRINVCMNLACCEPTEDDIFFNETAMT,  -- NetAmount [CIM_MAKZN]
    SUPLRINVCMNLACCEPTEDDIFFTAXAMT,  -- Tax Accptd Manually [CIM_MAKZMW]
    SUPLRINVCMANUALACCEPTEDDIFFAMT,  -- Gross Amount [CIM_MAKZ_GROSS]
    SUPLRINVCMANUALREDUCTIONNETAMT,  -- Supplier Error [CIM_LIEFFN]
    SUPLRINVCMANUALREDUCTIONTAXAMT,  -- Tax in Suppl. Error [CIM_LIEFFMW]
    SUPLRINVCMANUALLYREDUCEDAMOUNT,  -- Supplier Error [CIM_LIEFF_GROSS]
    SUPLRINVCHASSMALLDIFFERENCES,    -- Auto. accepted [XAUTAKZ]
    PRMTHBPAYTSLIPWTHREFSUBSCRIBER,  -- ISR Number [ESRNR]
    PAYTSLIPWTHREFCHECKDIGIT,        -- Check digit [ESRPZ]
    PAYTSLIPWTHREFREFERENCE,         -- ISR/QR Ref. [ESRRE]
    WITHHOLDINGTAXBASEAMOUNT,        -- WTax Base [QSSHB]
    WITHHOLDINGTAXEXEMPTIONAMT,      -- WTax-Exempt [QSFBT]
    PRMTHBWITHHOLDINGTAXCODE,        -- WTax Code [QSSKZ]
    ISSERVICE,                       -- Service Ind. [DIEKZ]
    PRMTHBSUPPLYINGCOUNTRY,          -- Supply C/R [LANDL]
    PRMTHBSTATECENTRALBANKPAYTRSN,   -- SCB Ind. [LZBKZ]
    TAXEXCHANGERATE,                 -- Rate for Taxes [TXKRS_BKPF]
    PRMTHBPAYEE,                     -- Payer [EMPFB]
    PRMTHBSUPPLIERBANKTYPE,          -- Part.bank type [BVTYP]
    PRMTHBHOUSEBANK,                 -- House Bank [HBKID]
    ASSIGNMENTREFERENCE,             -- Assignment [DZUONR]
    PRMTHBPAYMENTBLOCKINGREASON,     -- Pmnt block [DZLSPR]
    PRMTHBPAYMENTMETHOD,             -- Pymt Meth. [DZLSCH]
    DUECALCULATIONBASEDATE,          -- Baseline Date [DZFBDT]
    PAYMENTREFERENCE,                -- Payment Ref. [KIDNO]
    PRMTHBINVOICEREFERENCE,          -- InR.Ref.no. [AWREF_REB]
    PRMTHBINVOICEREFERENCEFISCALYR,  -- Fiscal Year [REBZJ]
    SUPLRINVCISCAPITALGOODSRELATED,  -- Invest.ID [XINVE]
    PRMTHBDELIVERYOFGOODSRPTGCNTRY,  -- Reporting C/R [EGMLD_BSEZ]
    ISEUTRIANGULARDEAL,              -- EU Triang. Deal [XEGDR]
    TAXREPORTINGDATE,                -- Tax Reporting Date [VATDATE]
    PRMTHBPOSTINGFISCALPERIOD,       -- Period [MONAT]
    ISENDOFPURPOSEBLOCKED,           -- Busin. Purp. Cmpltd. [EOPBLOCKED]
    SUPLRINVCEXTCREATEDBYUSER,       -- Created by [ERNAME]
    INVOICERECEIPTDATE,              -- Inv. Recpt Date [REINDAT]
    PAYMENTMETHODSUPPLEMENT,         -- Pmnt Meth. Sup. [UZAWE]
    PRMTHBPLANNINGLEVEL,             -- Planning Level [FDLEV]
    PLANNINGDATE,                    -- Planning Date [FDTAG]
    FIXEDCASHDISCOUNT,               -- Fixed [DZBFIX]
    PROCMTHUBCREATEDBYUSER,          -- Entered By [ERFNAM]
    PRMTHBBUSINESSPLACE,             -- Business place [BUPLA]
    PRMTHBBRANCHACCOUNT,             -- Branch [FILKD]
    PRMTHBBUSINESSAREA,              -- Business Area [GSBER]
    SUPPLIERPOSTINGLINEITEMTEXT,     -- Text [SGTXT]
    SUPPLIERINVOICEAMOUNTISSPLIT,    -- Amount Split [CIM_INV_AMOUNT_IS_SPLITTED]
    CREATIONDATE,                    -- Entered On [CPUDT]
    PRIMARY KEY (MANDT, PRMTHBRPLDSUPPLIERINVOICEUUID)
);

Learn More