I_GRIRAccountReconciliation

GR/IR Account Reconciliation Monitor | view: IFIGRIRMONITOR | Extraction: Not supported | Component: Information System
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
📏 Base Unit of Measure (BaseUnit):
BalanceQuantity Balance Quantity
GoodsReceiptQty Quantity of Goods Received
InvoiceReceiptQty Quantity invoiced
GoodsReceiptGoodsQuantity Goods Receipt Quantity (Goods)
GoodsReceiptDeliveryCostQty Goods Receipt Quantity (Delivery Costs)
InvoiceReceiptGoodsQuantity Invoice Receipt Quantity (Goods)
InvoiceRcptDeliveryCostQty Invoice Receipt Quantity (Delivery Costs)
GoodsBalanceQuantity Balance Quantity (Goods)
DeliveryCostBalanceQuantity Balance Quantity (Delivery Costs)
📏 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):
BalanceAbsoluteQuantity Balance Absolute Quantity
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
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
InvoicingPartyName Name of Supplier TEXT80
NumberOfPurchaseOrderItems Number of Purchasing Document Items
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • I_GRIRACCOUNTRECONCILIATION.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T163K.MANDT
Company Code
  • Client
  • Company Code
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T001.MANDT
  • I_GRIRACCOUNTRECONCILIATION.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_GRIRACCOUNTRECONCILIATION.MANDT == TCURC.MANDT
  • I_GRIRACCOUNTRECONCILIATION.COMPANYCODECURRENCY == TCURC.WAERS
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • I_GRIRACCOUNTRECONCILIATION.MANDT == LFA1.MANDT
  • I_GRIRACCOUNTRECONCILIATION.INVOICINGPARTY == LFA1.LIFNR
Material Number
  • Client
  • Material Number
  • I_GRIRACCOUNTRECONCILIATION.MANDT == MARA.MANDT
  • I_GRIRACCOUNTRECONCILIATION.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T023.MANDT
  • I_GRIRACCOUNTRECONCILIATION.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T001W.MANDT
  • I_GRIRACCOUNTRECONCILIATION.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T163.MANDT
  • I_GRIRACCOUNTRECONCILIATION.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T161.MANDT
  • I_GRIRACCOUNTRECONCILIATION.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_GRIRACCOUNTRECONCILIATION.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T024.MANDT
  • I_GRIRACCOUNTRECONCILIATION.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T024E.MANDT
  • I_GRIRACCOUNTRECONCILIATION.PURCHASINGORGANIZATION == T024E.EKORG
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T006.MANDT
  • I_GRIRACCOUNTRECONCILIATION.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
Supplier
  • Supplier
  • Client
  • I_GRIRACCOUNTRECONCILIATION.SUPPLIER == LFA1.LIFNR
  • I_GRIRACCOUNTRECONCILIATION.MANDT == LFA1.MANDT
Valuation area
  • Client
  • Valuation area
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T001K.MANDT
  • I_GRIRACCOUNTRECONCILIATION.VALUATIONAREA == T001K.BWKEY
Valuation Type
  • Client
  • Valuation Type
  • I_GRIRACCOUNTRECONCILIATION.MANDT == T149D.MANDT
  • I_GRIRACCOUNTRECONCILIATION.VALUATIONTYPE == T149D.BWTAR