I_GRIRACCOUNTRECONCILIATION

CDS View
102 Fields 4 CDS Views

GR/IR Account Reconciliation Monitor

I_GRIRACCOUNTRECONCILIATION is a CDS View in S/4HANA. GR/IR Account Reconciliation Monitor. It contains 102 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_GRIRAccountReconciliation view from CONSUMPTION GR/IR Account Reconciliation Monitor
I_GRIRProcInference view from COMPOSITE Projection of the ALP view
P_ClrdInvcPurgDocWthoutGds view_entity from CONSUMPTION
P_GRIRAcctRecnclnSituation view from CONSUMPTION

Fields (102)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 3
KEY LastChangeDateTime LastChangeDateTime 3
KEY PurchasingDocument PurchasingDocument 3
KEY PurchasingDocumentItem PurchasingDocumentItem 3
_CompanyCode _CompanyCode 2
_CompanyCodeCurrency _CompanyCodeCurrency 1
_GRIRProcess _GRIRProcess 1
_Material _Material 1
_MaterialGroup _MaterialGroup 1
_Plant _Plant 1
_PurchasingDocument _PurchasingDocument 2
_PurchasingDocumentItem _PurchasingDocumentItem 2
_Supplier _Supplier 1
AccountAssignmentCategory AccountAssignmentCategory 3
BalAmtInCompanyCodeCrcy BalAmtInCompanyCodeCrcy 3
BalanceAbsoluteAmtInCoCodeCrcy BalanceAbsoluteAmtInCoCodeCrcy 2
BalanceAbsoluteQtyInRefQtyUnit BalanceAbsoluteQtyInRefQtyUnit 1
BalanceQuantityInRefQtyUnit BalanceQuantity,BalanceQuantityInRefQtyUnit 2
CompanyCodeCurrency CompanyCodeCurrency 2
CreatedByUser CreatedByUser 2
DelivCostBalQtyInRefQtyUnit DelivCostBalQtyInRefQtyUnit,DeliveryCostBalanceQuantity 3
DeliveryCostBalAmtInCCCrcy DeliveryCostBalAmtInCCCrcy 3
GdsBalanceQuantityInRefQtyUnit GdsBalanceQuantityInRefQtyUnit,GoodsBalanceQuantity 3
GdsRcptDelivCostAmtInCCCrcy GdsRcptDelivCostAmtInCCCrcy 3
GoodsBalanceAmountInCCCrcy GoodsBalanceAmountInCCCrcy 3
GoodsReceiptAmountInCoCodeCrcy GoodsReceiptAmountInCoCodeCrcy 3
GoodsReceiptGdsQtyInRefQtyUnit GoodsReceiptGdsQtyInRefQtyUnit,GoodsReceiptGoodsQuantity 3
GoodsReceiptGoodsAmtInCCCrcy GoodsReceiptGoodsAmtInCCCrcy 2
GoodsReceiptQtyInRefQtyUnit GoodsReceiptQty,GoodsReceiptQtyInRefQtyUnit 2
GRDelivCostQtyInRefQtyUnit GoodsReceiptDeliveryCostQty,GRDelivCostQtyInRefQtyUnit 3
GRIRClearingProcessPriority GRIRClearingProcessPriority,PrevGRIRClrgProcPriority 3
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 3
GRIRClearingProcessStatus GRIRClearingProcessStatus,PrevGRIRClearingProcessStatus 3
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 3
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 3
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 3
GRIRProcPrpslLastChangeDteTime GRIRProcPrpslLastChangeDteTime 2
GRIRProposedPrioMaxClProblty GRIRProposedPrioMaxClProblty 3
GRIRProposedStatusMaxClProblty GRIRProposedStatusMaxClProblty 3
GRIRPrpsdRootCauseMaxClProblty GRIRPrpsdRootCauseMaxClProblty 3
HasNoGoodsReceiptPosted HasNoGoodsReceiptPosted 1
HasNoInvoiceReceiptPosted HasNoInvoiceReceiptPosted 1
HasNote HasNote 3
InvcRcptDelivCostAmtInCCCrcy InvcRcptDelivCostAmtInCCCrcy 3
InvcRcptDelivQtyInRefQtyUnit InvcRcptDelivQtyInRefQtyUnit,InvoiceRcptDeliveryCostQty 3
InvoiceRcptAmtInCoCodeCrcy InvoiceRcptAmtInCoCodeCrcy 2
InvoiceRcptGdsQtyInRefQtyUnit InvoiceRcptGdsQtyInRefQtyUnit,InvoiceReceiptGoodsQuantity 3
InvoiceRcptGoodsAmtInCCCrcy InvoiceRcptGoodsAmtInCCCrcy 3
InvoiceReceiptQtyInRefQtyUnit InvoiceReceiptQty,InvoiceReceiptQtyInRefQtyUnit 2
InvoicingParty InvoicingParty 1
IsFinallyInvoiced IsFinallyInvoiced 3
IsGdsRcptDelivCostAmtSurplus IsGdsRcptDelivCostAmtSurplus 2
IsGdsRcptDelivCostQtySurplus IsGdsRcptDelivCostQtySurplus 2
IsGoodsRcptGoodsAmtSurplus IsGoodsRcptGoodsAmtSurplus 2
IsGoodsRcptGoodsQtySurplus IsGoodsRcptGoodsQtySurplus 2
IsInvoiceDelivCostAmtSurplus IsInvoiceDelivCostAmtSurplus 2
IsInvoiceDelivCostQtySurplus IsInvoiceDelivCostQtySurplus 2
IsInvoiceGoodsAmountSurplus IsInvoiceGoodsAmountSurplus 2
IsInvoiceGoodsQtySurplus IsInvoiceGoodsQtySurplus 2
LastChangeDate LastChangeDate 2
LastChangeDays LastChangeDays 2
LastChangedByUser LastChangedByUser 3
LatestOpenItemPostingDate LatestOpenItemPostingDate 3
LatestPostingIsAfterLastChange LatestPostingIsAfterLastChange 1
Material Material 2
MaterialGroup MaterialGroup 3
NumberOfGoodsReceipts NumberOfGoodsReceipts 2
NumberOfInvoiceReceipts NumberOfInvoiceReceipts 3
NumberOfOpenItems NumberOfOpenItems 2
NumberOfPurchaseOrderItems NumberOfPurchaseOrderItems 2
OldestOpenItemPostingDate OldestOpenItemPostingDate 3
Plant Plant 2
ProposedResponsiblePerson ProposedResponsiblePerson 3
PrpsdRespDeptMaxClProbability PrpsdRespDeptMaxClProbability 3
PrpsdResponsibleDepartment PrpsdResponsibleDepartment 3
PrpsdRespPersonMaxClassProblty PrpsdRespPersonMaxClassProblty 3
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 2
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 1
PurchasingDocumentItemText PurchasingDocumentItemText 2
PurchasingDocumentItemUniqueID PurchasingDocumentItemUniqueID 1
PurchasingDocumentOrderQty PurchasingDocumentOrderQty 1
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 2
ReferenceQuantityUnit ReferenceQuantityUnit 1
RequisitionerName RequisitionerName 2
ResponsibleDepartment PrevResponsibleDepartment,ResponsibleDepartment 2
ResponsiblePerson PrevResponsiblePerson,ResponsiblePerson 3
Supplier Supplier 3
SupplierName SupplierName 2
SystemMessageIdentification SystemMessageIdentification 3
SystemMessageNumber SystemMessageNumber 3
SystemMessageText SystemMessageText 2
SystemMessageType SystemMessageType 3
SystemMessageVariable1 SystemMessageVariable1 2
SystemMessageVariable2 SystemMessageVariable2 2
SystemMessageVariable3 SystemMessageVariable3 2
SystemMessageVariable4 SystemMessageVariable4 2
ValuationArea ValuationArea 2
ValuationType ValuationType 2

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 Account Reconciliation Monitor
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GRIRACCOUNTRECONCILIATION (
    COMPANYCODE,
    LASTCHANGEDATETIME,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _GRIRPROCESS,
    _MATERIAL,
    _MATERIALGROUP,
    _PLANT,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    _SUPPLIER,
    ACCOUNTASSIGNMENTCATEGORY,
    BALAMTINCOMPANYCODECRCY,
    BALANCEABSOLUTEAMTINCOCODECRCY,
    BALANCEABSOLUTEQTYINREFQTYUNIT,
    BALANCEQUANTITYINREFQTYUNIT,
    COMPANYCODECURRENCY,
    CREATEDBYUSER,
    DELIVCOSTBALQTYINREFQTYUNIT,
    DELIVERYCOSTBALAMTINCCCRCY,
    GDSBALANCEQUANTITYINREFQTYUNIT,
    GDSRCPTDELIVCOSTAMTINCCCRCY,
    GOODSBALANCEAMOUNTINCCCRCY,
    GOODSRECEIPTAMOUNTINCOCODECRCY,
    GOODSRECEIPTGDSQTYINREFQTYUNIT,
    GOODSRECEIPTGOODSAMTINCCCRCY,
    GOODSRECEIPTQTYINREFQTYUNIT,
    GRDELIVCOSTQTYINREFQTYUNIT,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    GRIRCLRGPROCESSPRPSDROOTCAUSE,
    GRIRCLRGPROCESSPRPSDSTATUS,
    GRIRCLRGPROCPRPSDPRIORITY,
    GRIRPROCPRPSLLASTCHANGEDTETIME,
    GRIRPROPOSEDPRIOMAXCLPROBLTY,
    GRIRPROPOSEDSTATUSMAXCLPROBLTY,
    GRIRPRPSDROOTCAUSEMAXCLPROBLTY,
    HASNOGOODSRECEIPTPOSTED,
    HASNOINVOICERECEIPTPOSTED,
    HASNOTE,
    INVCRCPTDELIVCOSTAMTINCCCRCY,
    INVCRCPTDELIVQTYINREFQTYUNIT,
    INVOICERCPTAMTINCOCODECRCY,
    INVOICERCPTGDSQTYINREFQTYUNIT,
    INVOICERCPTGOODSAMTINCCCRCY,
    INVOICERECEIPTQTYINREFQTYUNIT,
    INVOICINGPARTY,
    ISFINALLYINVOICED,
    ISGDSRCPTDELIVCOSTAMTSURPLUS,
    ISGDSRCPTDELIVCOSTQTYSURPLUS,
    ISGOODSRCPTGOODSAMTSURPLUS,
    ISGOODSRCPTGOODSQTYSURPLUS,
    ISINVOICEDELIVCOSTAMTSURPLUS,
    ISINVOICEDELIVCOSTQTYSURPLUS,
    ISINVOICEGOODSAMOUNTSURPLUS,
    ISINVOICEGOODSQTYSURPLUS,
    LASTCHANGEDATE,
    LASTCHANGEDAYS,
    LASTCHANGEDBYUSER,
    LATESTOPENITEMPOSTINGDATE,
    LATESTPOSTINGISAFTERLASTCHANGE,
    MATERIAL,
    MATERIALGROUP,
    NUMBEROFGOODSRECEIPTS,
    NUMBEROFINVOICERECEIPTS,
    NUMBEROFOPENITEMS,
    NUMBEROFPURCHASEORDERITEMS,
    OLDESTOPENITEMPOSTINGDATE,
    PLANT,
    PROPOSEDRESPONSIBLEPERSON,
    PRPSDRESPDEPTMAXCLPROBABILITY,
    PRPSDRESPONSIBLEDEPARTMENT,
    PRPSDRESPPERSONMAXCLASSPROBLTY,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGDOCUMENTITEMUNIQUEID,
    PURCHASINGDOCUMENTORDERQTY,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURGDOCORDERQUANTITYUNIT,
    REFERENCEQUANTITYUNIT,
    REQUISITIONERNAME,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SUPPLIER,
    SUPPLIERNAME,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    SYSTEMMESSAGETEXT,
    SYSTEMMESSAGETYPE,
    SYSTEMMESSAGEVARIABLE1,
    SYSTEMMESSAGEVARIABLE2,
    SYSTEMMESSAGEVARIABLE3,
    SYSTEMMESSAGEVARIABLE4,
    VALUATIONAREA,
    VALUATIONTYPE,
    PRIMARY KEY (COMPANYCODE, LASTCHANGEDATETIME, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More