I_GRIRProcInference

Projection of the ALP view | view: IGRIRINF | 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
GoodsReceiptGoodsAmtInCCCrcy Goods Receipt Amount in Company Code Currency (Goods)
InvoiceRcptGoodsAmtInCCCrcy Invoice Receipt Amount in Company Code Currency (Goods)
GdsRcptDelivCostAmtInCCCrcy Goods Receipt Amount in Company Code Currency (Delivery Cost
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
📏 Purchase Order Unit of Measure (PurgDocOrderQuantityUnit):
BalanceQuantity Balance Quantity in Reference Quantity Unit
GoodsReceiptGoodsQuantity Goods Receipt Quantity (Goods) in Reference Quantity Unit
InvoiceReceiptGoodsQuantity Invoice Receipt Quantity (Goods) in Reference Quantity Unit
GoodsReceiptDeliveryCostQty Goods Receipt Quantity (Delivery Costs) in Reference Quantit
InvoiceRcptDeliveryCostQty Invoice Quantity (Delivery Costs) in Reference Quantity Unit
GoodsBalanceQuantity Balance Quantity (Goods) in Reference Quantity Unit
DeliveryCostBalanceQuantity Balance Quantity (Delivery Costs) in Reference Quantity Unit
GoodsReceiptQty Quantity of Goods Received in Reference Quantity Unit
InvoiceReceiptQty Invoiced Quantity in Reference Quantity Unit
Column Name Description
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
PrevGRIRClrgProcPriority Priority of GR/IR Clearing Process Show values
HasNote Notes Included in GR/IR Clearing Process Show values
SystemMessageType Message Type Show values
IsFinallyInvoiced Final Invoice Indicator Show values
GRIRClrgProcPrpsdPriority Proposed Priority of GR/IR Clearing Process 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
LastChangeDateTime GR/IR Clearing Process Last Change Date Time TZNTSTMPS
LastChangedByUser User of Last Change in GR/IR Clearing Process XUBNAME
GRIRClearingProcessStatus GR/IR Clearing Process Status FIS_GRIR_CLEARING_STATUS
ResponsibleDepartment Processing Department of GR/IR Clearing Process FIS_GRIR_RESPONSIBLE_DPMNT
ResponsiblePerson Processor of GR/IR Clearing Process XUBNAME
GRIRClearingProcessRootCause Root Cause for GR/IR Clearing Process FIS_GRIR_CLRG_ROOT_CAUSE
PrevResponsibleDepartment Processing Department of GR/IR Clearing Process FIS_GRIR_RESPONSIBLE_DPMNT
PrevResponsiblePerson Processor of GR/IR Clearing Process XUBNAME
PrevGRIRClearingProcessStatus GR/IR Clearing Process Status FIS_GRIR_CLEARING_STATUS
SystemMessageIdentification Message identification ARBGB
SystemMessageNumber Message number MSGNR
NumberOfGoodsReceipts Number of Goods Receipts
NumberOfInvoiceReceipts Number of Invoice Receipts
DueDays Due Days INT4
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
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • I_GRIRPROCINFERENCE.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • I_GRIRPROCINFERENCE.MANDT == T163K.MANDT
Company Code
  • Client
  • Company Code
  • I_GRIRPROCINFERENCE.MANDT == T001.MANDT
  • I_GRIRPROCINFERENCE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_GRIRPROCINFERENCE.MANDT == TCURC.MANDT
  • I_GRIRPROCINFERENCE.COMPANYCODECURRENCY == TCURC.WAERS
Material Group
  • Client
  • Material Group
  • I_GRIRPROCINFERENCE.MANDT == T023.MANDT
  • I_GRIRPROCINFERENCE.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • I_GRIRPROCINFERENCE.PLANT == T001W.WERKS
  • I_GRIRPROCINFERENCE.MANDT == T001W.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_GRIRPROCINFERENCE.PURCHASINGGROUP == T024.EKGRP
  • I_GRIRPROCINFERENCE.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • I_GRIRPROCINFERENCE.PURCHASINGORGANIZATION == T024E.EKORG
  • I_GRIRPROCINFERENCE.MANDT == T024E.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_GRIRPROCINFERENCE.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
  • I_GRIRPROCINFERENCE.MANDT == T006.MANDT
Supplier
  • Supplier
  • Client
  • I_GRIRPROCINFERENCE.SUPPLIER == LFA1.LIFNR
  • I_GRIRPROCINFERENCE.MANDT == LFA1.MANDT