FINS_GRIRPROCHIS

Transparent Table Application Table
56 Fields 1 CDS Views

GR/IR Clearing Process History

FINS_GRIRPROCHIS is an SAP database table in S/4HANA. GR/IR Clearing Process History. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GRIRProcessHistory view from BASIC

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY companycode BUKRS Company Code
KEY purchasingdocument FIS_EBELN Purchasing Document
KEY purchasingdocumentitem FIS_EBELP Purchasing Doc. Item
KEY lastchangedatetime FIS_GRIR_LASTCHANGEDATETIME Last Changed On
lastchangedbyuser FIS_GRIR_LASTCHANGEDBYUSER Last Changed By
responsibledepartment FIS_GRIR_RESPONSIBLE_DPMNT Processing Department
responsibleperson FIS_GRIR_RESPONSIBLE_USER Processor
grirclearingprocessstatus FIS_GRIR_CLEARING_STATUS Status
grirclearingprocesspriority FIS_GRIR_PRIORITY Priority
hasnote FIS_GRIR_HAS_NOTE Notes
note FIS_NOTE Note
grirclearingprocessrootcause FIS_GRIR_CLRG_ROOT_CAUSE Root Cause
supplier LIFNR Supplier
oldestopenitempostingdate FIS_GRIR_OLDESTOPNITMPOSTGDATE Oldest Posting Date
latestopenitempostingdate FIS_LATEST_BUDAT Latest Posting Date
materialgroup MATKL Material Group
accountassignmentcategory FIS_GRIR_KNTTP Account Assignment Category
isfinallyinvoiced EREKZ Final Invoice
numberofgoodsreceipts FIS_NMBR_GDS_RECEIPTS Number of Goods Receipts
numberofinvoicereceipts FIS_NMBR_INVC_RECEIPTS Number of Invoice Receipts
purchasinggroup FIS_GRIR_EKGRP Purchasing Group
purchasingorganization FIS_GRIR_EKORG Purchasing Organization
plant WERKS_D Plant
duedays FIS_GRIR_DUEDAYS GR/IR Due Days
companycodecurrency FIS_HWAER Company Code Currency
balamtincompanycodecrcy FIS_GRIR_BAL_HSL Balance Amount
purgdocorderquantityunit FIS_GRIR_PURGDOCORDERQTYUNIT Purchasing Document Order Qty Unit
balancequantity FIS_GRIR_BAL_QTY_RRUNIT Balance Quantity
goodsreceiptgoodsamtincccrcy FIS_GRIR_GR_GOODS_HSL Goods Receipt Amount (Goods)
invoicercptgoodsamtincccrcy FIS_GRIR_IR_GOODS_HSL Invoice Receipt Amount (Goods)
gdsrcptdelivcostamtincccrcy FIS_GRIR_GR_FREIGHT_HSL Goods Receipt Amount (Delivery Costs)
invcrcptdelivcostamtincccrcy FIS_GRIR_IR_FREIGHT_HSL Invoice Receipt Amount (Delivery Costs)
goodsreceiptgoodsquantity FIS_GRIR_GR_GOODS_QTY_RRUNIT Goods Receipt Quantity (Goods)
invoicereceiptgoodsquantity FIS_GRIR_IR_GOODS_QTY_RRUNIT Invoice Receipt Quantity (Goods)
goodsreceiptdeliverycostqty FIS_GRIR_GR_FREIGHT_QTY_RRUNIT Goods Receipt Quantity (Delivery Costs)
invoicercptdeliverycostqty FIS_GRIR_IR_FREIGHT_QTY_RRUNIT Invoice Receipt Quantity (Deliv. Costs)
systemmessageidentification MSGID Message ID
systemmessagetype MSGTY Message Type
systemmessagenumber MSGNR Message
systemmessagevariable1 MSGV1 Message var.
systemmessagevariable2 MSGV2 Message var.
systemmessagevariable3 MSGV3 Message var.
systemmessagevariable4 MSGV4 Message var.
systemmessagetext NATXT Message Text
prpsdresponsibledepartment FIS_GRIR_P_RESPONSIBLE_DPMNT Proposed Processing Department
proposedresponsibleperson FIS_GRIR_P_RESPONSIBLE_USER Proposed Processor
grirclrgprocessprpsdstatus FIS_GRIR_P_CLEARING_STATUS Proposed Status
grirclrgprocprpsdpriority FIS_GRIR_P_PRIORITY Proposed Priority
grirclrgprocessprpsdrootcause FIS_GRIR_P_CLRG_ROOT_CAUSE Proposed Root Cause
prpsdrespdeptmaxclprobability FIS_GRIR_P_DEPARTMENT_CONF Processing Department Proposal Confidence
prpsdresppersonmaxclassproblty FIS_GRIR_P_RESPONSIBLE_CONF Processor Proposal Confidence
grirproposedstatusmaxclproblty FIS_GRIR_P_STATUS_CONF Status Proposal Confidence
grirproposedpriomaxclproblty FIS_GRIR_P_PRIORITY_CONF Priority Proposal Confidence
grirprpsdrootcausemaxclproblty FIS_GRIR_P_ROOTCAUSE_CONF Root Cause Proposal Confidence
grirprocprpsllastchangedtetime FIS_GRIR_P_LASTCHANGEDATETIME Proposals Last Updated 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.

-- GR/IR Clearing Process History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_GRIRPROCHIS (
    CLIENT,                          -- Client [MANDT]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PURCHASINGDOCUMENT,              -- Purchasing Document [FIS_EBELN]
    PURCHASINGDOCUMENTITEM,          -- Purchasing Doc. Item [FIS_EBELP]
    LASTCHANGEDATETIME,              -- Last Changed On [FIS_GRIR_LASTCHANGEDATETIME]
    LASTCHANGEDBYUSER,               -- Last Changed By [FIS_GRIR_LASTCHANGEDBYUSER]
    RESPONSIBLEDEPARTMENT,           -- Processing Department [FIS_GRIR_RESPONSIBLE_DPMNT]
    RESPONSIBLEPERSON,               -- Processor [FIS_GRIR_RESPONSIBLE_USER]
    GRIRCLEARINGPROCESSSTATUS,       -- Status [FIS_GRIR_CLEARING_STATUS]
    GRIRCLEARINGPROCESSPRIORITY,     -- Priority [FIS_GRIR_PRIORITY]
    HASNOTE,                         -- Notes [FIS_GRIR_HAS_NOTE]
    NOTE,                            -- Note [FIS_NOTE]
    GRIRCLEARINGPROCESSROOTCAUSE,    -- Root Cause [FIS_GRIR_CLRG_ROOT_CAUSE]
    SUPPLIER,                        -- Supplier [LIFNR]
    OLDESTOPENITEMPOSTINGDATE,       -- Oldest Posting Date [FIS_GRIR_OLDESTOPNITMPOSTGDATE]
    LATESTOPENITEMPOSTINGDATE,       -- Latest Posting Date [FIS_LATEST_BUDAT]
    MATERIALGROUP,                   -- Material Group [MATKL]
    ACCOUNTASSIGNMENTCATEGORY,       -- Account Assignment Category [FIS_GRIR_KNTTP]
    ISFINALLYINVOICED,               -- Final Invoice [EREKZ]
    NUMBEROFGOODSRECEIPTS,           -- Number of Goods Receipts [FIS_NMBR_GDS_RECEIPTS]
    NUMBEROFINVOICERECEIPTS,         -- Number of Invoice Receipts [FIS_NMBR_INVC_RECEIPTS]
    PURCHASINGGROUP,                 -- Purchasing Group [FIS_GRIR_EKGRP]
    PURCHASINGORGANIZATION,          -- Purchasing Organization [FIS_GRIR_EKORG]
    PLANT,                           -- Plant [WERKS_D]
    DUEDAYS,                         -- GR/IR Due Days [FIS_GRIR_DUEDAYS]
    COMPANYCODECURRENCY,             -- Company Code Currency [FIS_HWAER]
    BALAMTINCOMPANYCODECRCY,         -- Balance Amount [FIS_GRIR_BAL_HSL]
    PURGDOCORDERQUANTITYUNIT,        -- Purchasing Document Order Qty Unit [FIS_GRIR_PURGDOCORDERQTYUNIT]
    BALANCEQUANTITY,                 -- Balance Quantity [FIS_GRIR_BAL_QTY_RRUNIT]
    GOODSRECEIPTGOODSAMTINCCCRCY,    -- Goods Receipt Amount (Goods) [FIS_GRIR_GR_GOODS_HSL]
    INVOICERCPTGOODSAMTINCCCRCY,     -- Invoice Receipt Amount (Goods) [FIS_GRIR_IR_GOODS_HSL]
    GDSRCPTDELIVCOSTAMTINCCCRCY,     -- Goods Receipt Amount (Delivery Costs) [FIS_GRIR_GR_FREIGHT_HSL]
    INVCRCPTDELIVCOSTAMTINCCCRCY,    -- Invoice Receipt Amount (Delivery Costs) [FIS_GRIR_IR_FREIGHT_HSL]
    GOODSRECEIPTGOODSQUANTITY,       -- Goods Receipt Quantity (Goods) [FIS_GRIR_GR_GOODS_QTY_RRUNIT]
    INVOICERECEIPTGOODSQUANTITY,     -- Invoice Receipt Quantity (Goods) [FIS_GRIR_IR_GOODS_QTY_RRUNIT]
    GOODSRECEIPTDELIVERYCOSTQTY,     -- Goods Receipt Quantity (Delivery Costs) [FIS_GRIR_GR_FREIGHT_QTY_RRUNIT]
    INVOICERCPTDELIVERYCOSTQTY,      -- Invoice Receipt Quantity (Deliv. Costs) [FIS_GRIR_IR_FREIGHT_QTY_RRUNIT]
    SYSTEMMESSAGEIDENTIFICATION,     -- Message ID [MSGID]
    SYSTEMMESSAGETYPE,               -- Message Type [MSGTY]
    SYSTEMMESSAGENUMBER,             -- Message [MSGNR]
    SYSTEMMESSAGEVARIABLE1,          -- Message var. [MSGV1]
    SYSTEMMESSAGEVARIABLE2,          -- Message var. [MSGV2]
    SYSTEMMESSAGEVARIABLE3,          -- Message var. [MSGV3]
    SYSTEMMESSAGEVARIABLE4,          -- Message var. [MSGV4]
    SYSTEMMESSAGETEXT,               -- Message Text [NATXT]
    PRPSDRESPONSIBLEDEPARTMENT,      -- Proposed Processing Department [FIS_GRIR_P_RESPONSIBLE_DPMNT]
    PROPOSEDRESPONSIBLEPERSON,       -- Proposed Processor [FIS_GRIR_P_RESPONSIBLE_USER]
    GRIRCLRGPROCESSPRPSDSTATUS,      -- Proposed Status [FIS_GRIR_P_CLEARING_STATUS]
    GRIRCLRGPROCPRPSDPRIORITY,       -- Proposed Priority [FIS_GRIR_P_PRIORITY]
    GRIRCLRGPROCESSPRPSDROOTCAUSE,   -- Proposed Root Cause [FIS_GRIR_P_CLRG_ROOT_CAUSE]
    PRPSDRESPDEPTMAXCLPROBABILITY,   -- Processing Department Proposal Confidence [FIS_GRIR_P_DEPARTMENT_CONF]
    PRPSDRESPPERSONMAXCLASSPROBLTY,  -- Processor Proposal Confidence [FIS_GRIR_P_RESPONSIBLE_CONF]
    GRIRPROPOSEDSTATUSMAXCLPROBLTY,  -- Status Proposal Confidence [FIS_GRIR_P_STATUS_CONF]
    GRIRPROPOSEDPRIOMAXCLPROBLTY,    -- Priority Proposal Confidence [FIS_GRIR_P_PRIORITY_CONF]
    GRIRPRPSDROOTCAUSEMAXCLPROBLTY,  -- Root Cause Proposal Confidence [FIS_GRIR_P_ROOTCAUSE_CONF]
    GRIRPROCPRPSLLASTCHANGEDTETIME,  -- Proposals Last Updated On [FIS_GRIR_P_LASTCHANGEDATETIME]
    PRIMARY KEY (CLIENT, COMPANYCODE, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, LASTCHANGEDATETIME)
);

Learn More