P_GRIRAcctRecnclnSituation

GR/IR Account Reconciliation Situation | view: PFIRECNCLNSITN | TRAN | Extraction: Not supported | Component: Information System
Tables used: EKKO, EKPO, ACDOCA, FINS_GRIRPROC, FINS_GRIRPROCHIS, 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
LastChangeDateTime GR/IR Clearing Process Last Change Date Time
Column Name Description
BalAmtInCoCodeCrcyIsChanged null
💲 Company Code Currency (CompanyCodeCurrency):
BalanceAbsoluteAmtInCoCodeCrcy Balance Absolute Amount In Company Code Currency
BalAmtInCompanyCodeCrcy Total Balance 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
BalanceQuantityIsChanged null
GoodsReceiptQtyIsChanged null
InvoiceReceiptQtyIsChanged null
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
SystemMessageType Message Type Show values
GRIRClrgProcPrpsdPriority Proposed Priority of GR/IR Clearing Process Show values
IsFinallyInvoiced Final Invoice Indicator Show values
HasNoGoodsReceiptPosted There is no goods receipt posted. Show values
HasNoInvoiceReceiptPosted There is no invoice 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
NumberOfGoodsRcptsIsChanged null
PrevNumberOfInvoiceReceipts Number of Invoice Receipts
NumberOfInvoiceReceipts Number of Invoice Receipts
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
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
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T163K.MANDT
  • P_GRIRACCTRECNCLNSITUATION.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Company Code
  • Company Code
  • Client
  • P_GRIRACCTRECNCLNSITUATION.COMPANYCODE == T001.BUKRS
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_GRIRACCTRECNCLNSITUATION.MANDT == TCURC.MANDT
  • P_GRIRACCTRECNCLNSITUATION.COMPANYCODECURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_GRIRACCTRECNCLNSITUATION.MANDT == MARA.MANDT
  • P_GRIRACCTRECNCLNSITUATION.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T023.MANDT
  • P_GRIRACCTRECNCLNSITUATION.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T001W.MANDT
  • P_GRIRACCTRECNCLNSITUATION.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T024.MANDT
  • P_GRIRACCTRECNCLNSITUATION.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Purchasing Organization
  • Client
  • P_GRIRACCTRECNCLNSITUATION.PURCHASINGORGANIZATION == T024E.EKORG
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T024E.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T006.MANDT
  • P_GRIRACCTRECNCLNSITUATION.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
Supplier
  • Client
  • Supplier
  • P_GRIRACCTRECNCLNSITUATION.MANDT == LFA1.MANDT
  • P_GRIRACCTRECNCLNSITUATION.SUPPLIER == LFA1.LIFNR
Valuation area
  • Client
  • Valuation area
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T001K.MANDT
  • P_GRIRACCTRECNCLNSITUATION.VALUATIONAREA == T001K.BWKEY
Valuation Type
  • Valuation Type
  • Client
  • P_GRIRACCTRECNCLNSITUATION.VALUATIONTYPE == T149D.BWTAR
  • P_GRIRACCTRECNCLNSITUATION.MANDT == T149D.MANDT