I_GRIRACCOUNTRECONCILIATION

CDS View
104 Fields 5 CDS Views

GR/IR Account Reconciliation Monitor

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_GRIRAccountReconciliation view_entity from CONSUMPTION GR/IR Account Reconciliation Monitor
I_GRIRProcInference view from COMPOSITE Projection of the ALP view
P_ClrdInvcPurgDocWthoutGds view_entity from CONSUMPTION PO with cleared invoices without a GR
P_GRIRAcctRecnclnSituation view_entity from CONSUMPTION GR/IR Account Reconciliation Situation
R_GRIRProcInference view_entity from COMPOSITE GRIR Account Reconciliation ISLM Infere

Fields (104)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY LastChangeDateTime LastChangeDateTime 3
KEY PurchasingDocument PurchasingDocument 4
KEY PurchasingDocumentItem PurchasingDocumentItem 4
_CompanyCode _CompanyCode 3
_CompanyCodeCurrency _CompanyCodeCurrency 2
_GRIRProcess _GRIRProcess 2
_InvoicingParty _InvoicingParty 1
_Material _Material 2
_MaterialGroup _MaterialGroup 2
_Plant _Plant 2
_PurchasingDocument _PurchasingDocument 3
_PurchasingDocumentItem _PurchasingDocumentItem 3
_Supplier _Supplier 2
AccountAssignmentCategory AccountAssignmentCategory 4
BalAmtInCompanyCodeCrcy BalAmtInCompanyCodeCrcy 4
BalanceAbsoluteAmtInCoCodeCrcy BalanceAbsoluteAmtInCoCodeCrcy 2
BalanceAbsoluteQtyInRefQtyUnit BalanceAbsoluteQtyInRefQtyUnit 1
BalanceQuantityInRefQtyUnit BalanceQuantity,BalanceQuantityInRefQtyUnit 2
CompanyCodeCurrency CompanyCodeCurrency 3
CreatedByUser CreatedByUser 2
DelivCostBalQtyInRefQtyUnit DelivCostBalQtyInRefQtyUnit,DeliveryCostBalanceQuantity 4
DeliveryCostBalAmtInCCCrcy DeliveryCostBalAmtInCCCrcy 4
GdsBalanceQuantityInRefQtyUnit GdsBalanceQuantityInRefQtyUnit,GoodsBalanceQuantity 4
GdsRcptDelivCostAmtInCCCrcy GdsRcptDelivCostAmtInCCCrcy 4
GoodsBalanceAmountInCCCrcy GoodsBalanceAmountInCCCrcy 4
GoodsReceiptAmountInCoCodeCrcy GoodsReceiptAmountInCoCodeCrcy 4
GoodsReceiptGdsQtyInRefQtyUnit GoodsReceiptGdsQtyInRefQtyUnit,GoodsReceiptGoodsQuantity 4
GoodsReceiptGoodsAmtInCCCrcy GoodsReceiptGoodsAmtInCCCrcy 3
GoodsReceiptQtyInRefQtyUnit GoodsReceiptQty,GoodsReceiptQtyInRefQtyUnit 3
GRDelivCostQtyInRefQtyUnit GoodsReceiptDeliveryCostQty,GRDelivCostQtyInRefQtyUnit 4
GRIRClearingProcessPriority GRIRClearingProcessPriority,PrevGRIRClrgProcPriority 4
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 3
GRIRClearingProcessStatus GRIRClearingProcessStatus,PrevGRIRClearingProcessStatus 4
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 3
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 3
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 3
GRIRHasNoAmountDifference GRIRHasNoAmountDifference 1
GRIRProcPrpslLastChangeDteTime GRIRProcPrpslLastChangeDteTime 2
GRIRProposedPrioMaxClProblty GRIRProposedPrioMaxClProblty 3
GRIRProposedStatusMaxClProblty GRIRProposedStatusMaxClProblty 3
GRIRPrpsdRootCauseMaxClProblty GRIRPrpsdRootCauseMaxClProblty 3
HasNoGoodsReceiptPosted HasNoGoodsReceiptPosted 2
HasNoInvoiceReceiptPosted HasNoInvoiceReceiptPosted 2
HasNote HasNote 3
InvcRcptDelivCostAmtInCCCrcy InvcRcptDelivCostAmtInCCCrcy 4
InvcRcptDelivQtyInRefQtyUnit InvcRcptDelivQtyInRefQtyUnit,InvoiceRcptDeliveryCostQty 4
InvoiceRcptAmtInCoCodeCrcy InvoiceRcptAmtInCoCodeCrcy 4
InvoiceRcptGdsQtyInRefQtyUnit InvoiceRcptGdsQtyInRefQtyUnit,InvoiceReceiptGoodsQuantity 4
InvoiceRcptGoodsAmtInCCCrcy InvoiceRcptGoodsAmtInCCCrcy 4
InvoiceReceiptQtyInRefQtyUnit InvoiceReceiptQty,InvoiceReceiptQtyInRefQtyUnit 3
InvoicingParty InvoicingParty 1
IsFinallyInvoiced IsFinallyInvoiced 4
IsGdsRcptDelivCostAmtSurplus IsGdsRcptDelivCostAmtSurplus 4
IsGdsRcptDelivCostQtySurplus IsGdsRcptDelivCostQtySurplus 4
IsGoodsRcptGoodsAmtSurplus IsGoodsRcptGoodsAmtSurplus 4
IsGoodsRcptGoodsQtySurplus IsGoodsRcptGoodsQtySurplus 4
IsInvoiceDelivCostAmtSurplus IsInvoiceDelivCostAmtSurplus 4
IsInvoiceDelivCostQtySurplus IsInvoiceDelivCostQtySurplus 4
IsInvoiceGoodsAmountSurplus IsInvoiceGoodsAmountSurplus 4
IsInvoiceGoodsQtySurplus IsInvoiceGoodsQtySurplus 4
LastChangeDate LastChangeDate 2
LastChangeDays LastChangeDays 2
LastChangedByUser LastChangedByUser 4
LatestOpenItemPostingDate LatestOpenItemPostingDate 3
LatestPostingIsAfterLastChange LatestPostingIsAfterLastChange 1
Material Material 2
MaterialGroup MaterialGroup 4
NumberOfGoodsReceipts NumberOfGoodsReceipts 3
NumberOfInvoiceReceipts NumberOfInvoiceReceipts 4
NumberOfOpenItems NumberOfOpenItems 2
NumberOfPurchaseOrderItems NumberOfPurchaseOrderItems 2
OldestOpenItemPostingDate OldestOpenItemPostingDate 3
Plant Plant 3
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 2
PurchasingDocumentType PurchasingDocumentType 1
PurchasingGroup PurchasingGroup 4
PurchasingOrganization PurchasingOrganization 4
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 3
ReferenceQuantityUnit ReferenceQuantityUnit 1
RequisitionerName RequisitionerName 2
ResponsibleDepartment PrevResponsibleDepartment,ResponsibleDepartment 3
ResponsiblePerson PrevResponsiblePerson,ResponsiblePerson 4
Supplier Supplier 4
SupplierName SupplierName 2
SystemMessageIdentification SystemMessageIdentification 4
SystemMessageNumber SystemMessageNumber 4
SystemMessageText SystemMessageText 2
SystemMessageType SystemMessageType 4
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,
    _INVOICINGPARTY,
    _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,
    GRIRHASNOAMOUNTDIFFERENCE,
    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