C_GRIRAccountReconciliation

GR/IR Account Reconciliation Monitor | view: CFIGRIRMONITOR | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: EKKO, EKPO, ACDOCA, FINS_GRIRPROC, FINSC_LEDGER, LFA1, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
Column Name Description
CompanyCode FK Company Code
PurchasingDocument FK Purchasing Document
PurchasingDocumentItem FK Purchasing Document Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
BalAmtInCompanyCodeCrcy Total Balance Amount in Company Code Currency
BalanceAbsoluteAmtInCoCodeCrcy Balance Absolute Amount In Company Code Currency
GoodsReceiptGoodsAmtInCCCrcy Goods Receipt Amount in Company Code Currency (Goods)
GdsRcptDelivCostAmtInCCCrcy Goods Receipt Amount in Company Code Currency (Delivery Cost
InvoiceRcptGoodsAmtInCCCrcy Invoice Receipt Amount in Company Code Currency (Goods)
InvcRcptDelivCostAmtInCCCrcy Invoice Receipt Amount in Company Code Crcy (Delivery Costs)
GoodsBalanceAmountInCCCrcy Balance Amount in Company Code Currency (Goods)
DeliveryCostBalAmtInCCCrcy Balance Amount in Company Code Currency (Delivery Costs)
GoodsReceiptAmountInCoCodeCrcy Goods Receipt Amount in Company Code Currency
InvoiceRcptAmtInCoCodeCrcy Invoice Receipt Amount in Company Code Currency
Column Name Description
📏 Unit of Measure for Reference Quantity (ReferenceQuantityUnit):
BalanceQuantityInRefQtyUnit Balance Quantity in Reference Quantity Unit
BalanceAbsoluteQtyInRefQtyUnit Absolute Balance Quantity in Reference Quantity Unit
GoodsReceiptQtyInRefQtyUnit Quantity of Goods Received in Reference Quantity Unit
InvoiceReceiptQtyInRefQtyUnit Invoiced Quantity in Reference Quantity Unit
GoodsReceiptGdsQtyInRefQtyUnit Goods Receipt Quantity (Goods) in Reference Quantity Unit
GRDelivCostQtyInRefQtyUnit Goods Receipt Quantity (Delivery Costs) in Reference Quantit
InvoiceRcptGdsQtyInRefQtyUnit Invoice Receipt Quantity (Goods) in Reference Quantity Unit
InvcRcptDelivQtyInRefQtyUnit Invoice Quantity (Delivery Costs) in Reference Quantity Unit
GdsBalanceQuantityInRefQtyUnit Balance Quantity (Goods) in Reference Quantity Unit
DelivCostBalQtyInRefQtyUnit Balance Quantity (Delivery Costs) in Reference Quantity Unit
📏 Purchase Order Unit of Measure (PurgDocOrderQuantityUnit):
PurchasingDocumentOrderQty Purchase Order Quantity
Column Name Description
LastChangeDate Changed On
LatestOpenItemPostingDate Posting Date of Latest Open Item
OldestOpenItemPostingDate Posting Date of Oldest Open Item
Column Name Description
GRIRClearingProcessPriority Priority of GR/IR Clearing Process Show values
HasNote Notes Included in GR/IR Clearing Process Show values
LatestPostingIsAfterLastChange Latest Posting Date is After Last Changed Date Show values
SystemMessageType Message Type Show values
GRIRClrgProcPrpsdPriority Proposed Priority of GR/IR Clearing Process Show values
IsFinallyInvoiced Final Invoice Indicator Show values
PurchasingDocumentCategory Purchasing Document Category Show values
HasNoGoodsReceiptPosted There is no goods receipt posted. Show values
HasNoInvoiceReceiptPosted There is no invoice receipt posted. Show values
GRIRHasNoAmountDifference There is no goods receipt posted. Show values
IsGoodsRcptGoodsAmtSurplus There is goods amount surplus in goods receipts. Show values
IsInvoiceGoodsAmountSurplus There is goods amount surplus in invoices. Show values
IsGdsRcptDelivCostAmtSurplus There is delivery cost amount surplus in goods receipts. Show values
IsInvoiceDelivCostAmtSurplus There is delivery cost amount surplus in invoices. Show values
IsGoodsRcptGoodsQtySurplus There is goods quantity surplus in goods receipts. Show values
IsInvoiceGoodsQtySurplus There is goods quantity surplus in invoices. Show values
IsGdsRcptDelivCostQtySurplus There is delivery cost quantity surplus in goods receipts. Show values
IsInvoiceDelivCostQtySurplus There is delivery cost quantity surplus in invoices. Show values
Column Name Description Domain name
PurchasingDocumentItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
NumberOfGoodsReceipts Number of Goods Receipts
NumberOfInvoiceReceipts Number of Invoice Receipts
LastChangeDateTime GR/IR Clearing Process Last Change Date Time TZNTSTMPS
LastChangedByUser User of Last Change in GR/IR Clearing Process XUBNAME
ResponsibleDepartment Processing Department of GR/IR Clearing Process FIS_GRIR_RESPONSIBLE_DPMNT
ResponsiblePerson Processor of GR/IR Clearing Process XUBNAME
GRIRClearingProcessStatus GR/IR Clearing Process Status FIS_GRIR_CLEARING_STATUS
GRIRClearingProcessRootCause Root Cause for GR/IR Clearing Process FIS_GRIR_CLRG_ROOT_CAUSE
SystemMessageIdentification Message identification ARBGB
SystemMessageNumber Message number MSGNR
SystemMessageVariable1 Message variable 01 CHAR50
SystemMessageVariable2 Message variable 02 CHAR50
SystemMessageVariable3 Message variable 03 CHAR50
SystemMessageVariable4 Message variable 04 CHAR50
SystemMessageText Message Text NATXT
PrpsdResponsibleDepartment Proposed Processing Department of GR/IR Clearing Process CHAR30
ProposedResponsiblePerson Proposed Processor of GR/IR Clearing Process XUBNAME
GRIRClrgProcessPrpsdStatus Proposed Status of GR/IR Clearing Process FIS_GRIR_CLEARING_STATUS
GRIRClrgProcessPrpsdRootCause Proposed Root Cause of GR/IR Clearing Process FIS_GRIR_CLRG_ROOT_CAUSE
PrpsdRespDeptMaxClProbability Processing Department Proposal Confidence FIS_GRIR_P_CONF
PrpsdRespPersonMaxClassProblty Processor Proposal Confidence FIS_GRIR_P_CONF
GRIRProposedStatusMaxClProblty Status Proposal Confidence FIS_GRIR_P_CONF
GRIRProposedPrioMaxClProblty Priority Proposal Confidence FIS_GRIR_P_CONF
GRIRPrpsdRootCauseMaxClProblty Root Cause Proposal Confidence FIS_GRIR_P_CONF
GRIRProcPrpslLastChangeDteTime GR/IR Clearing Process Last Change Date Time TZNTSTMPS
RequisitionerName Name of requisitioner/requester AFNAM
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
SupplierName Name of Supplier TEXT80
CreatedByUser User of person who created a purchasing document USNAM
LastChangeDays Number of days until the last change
NumberOfOpenItems Number of Open Items FIS_NR_OPEN_ITEM
PurchasingDocumentItemText Short Text TEXT40
NumberOfPurchaseOrderItems Number of Purchasing Document Items
InvoicingPartyName Name of Invoicing Party TEXT80
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T163K.MANDT
  • C_GRIRACCOUNTRECONCILIATION.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Company Code
  • Company Code
  • Client
  • C_GRIRACCOUNTRECONCILIATION.COMPANYCODE == T001.BUKRS
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_GRIRACCOUNTRECONCILIATION.COMPANYCODECURRENCY == TCURC.WAERS
  • C_GRIRACCOUNTRECONCILIATION.MANDT == TCURC.MANDT
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • C_GRIRACCOUNTRECONCILIATION.MANDT == LFA1.MANDT
  • C_GRIRACCOUNTRECONCILIATION.INVOICINGPARTY == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • C_GRIRACCOUNTRECONCILIATION.MANDT == MARA.MANDT
  • C_GRIRACCOUNTRECONCILIATION.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T023.MANDT
  • C_GRIRACCOUNTRECONCILIATION.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T001W.MANDT
  • C_GRIRACCOUNTRECONCILIATION.PLANT == T001W.WERKS
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_GRIRACCOUNTRECONCILIATION.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T163.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • C_GRIRACCOUNTRECONCILIATION.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_GRIRACCOUNTRECONCILIATION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T024.MANDT
  • C_GRIRACCOUNTRECONCILIATION.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T024E.MANDT
  • C_GRIRACCOUNTRECONCILIATION.PURCHASINGORGANIZATION == T024E.EKORG
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • C_GRIRACCOUNTRECONCILIATION.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T006.MANDT
Supplier
  • Client
  • Supplier
  • C_GRIRACCOUNTRECONCILIATION.MANDT == LFA1.MANDT
  • C_GRIRACCOUNTRECONCILIATION.SUPPLIER == LFA1.LIFNR
Valuation area
  • Valuation area
  • Client
  • C_GRIRACCOUNTRECONCILIATION.VALUATIONAREA == T001K.BWKEY
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T001K.MANDT
Valuation Type
  • Client
  • Valuation Type
  • C_GRIRACCOUNTRECONCILIATION.MANDT == T149D.MANDT
  • C_GRIRACCOUNTRECONCILIATION.VALUATIONTYPE == T149D.BWTAR