R_GRIRProcInference

DDL: R_GRIRPROCINFERENCE Type: view_entity COMPOSITE Package: FINS_FI_GRIR_ML
49 Fields 1 Data Sources

GRIR Account Reconciliation ISLM Infere

R_GRIRProcInference is a Composite CDS View that provides data about "GRIR Account Reconciliation ISLM Infere" in SAP S/4HANA. It reads from 1 data source (I_GRIRAccountReconciliation) and exposes 49 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem. Part of development package FINS_FI_GRIR_ML.

Data Sources (1)

SourceAliasJoin Type
I_GRIRAccountReconciliation I_GRIRAccountReconciliation from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label GRIR Account Reconciliation ISLM Infere view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GRIRAccountReconciliation CompanyCode Receiver Company Code
KEY PurchasingDocument I_GRIRAccountReconciliation PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_GRIRAccountReconciliation PurchasingDocumentItem Purchasing Doc. Item
LastChangedByUser I_GRIRAccountReconciliation LastChangedByUser User Name
PrevResponsibleDepartment I_GRIRAccountReconciliation ResponsibleDepartment Processing Department
PrevResponsiblePerson I_GRIRAccountReconciliation ResponsiblePerson Processor
PrevGRIRClearingProcessStatus I_GRIRAccountReconciliation GRIRClearingProcessStatus Status
PrevGRIRClrgProcPriority I_GRIRAccountReconciliation GRIRClearingProcessPriority Priority
SystemMessageIdentification I_GRIRAccountReconciliation SystemMessageIdentification Message ID
SystemMessageType I_GRIRAccountReconciliation SystemMessageType Message type
SystemMessageNumber I_GRIRAccountReconciliation SystemMessageNumber Message Number
AccountAssignmentCategory I_GRIRAccountReconciliation AccountAssignmentCategory Acct Assgmt Cat
BalAmtInCompanyCodeCrcy I_GRIRAccountReconciliation BalAmtInCompanyCodeCrcy Balance Amount
BalanceQuantity
IsFinallyInvoiced I_GRIRAccountReconciliation IsFinallyInvoiced Final Invoice
MaterialGroup I_GRIRAccountReconciliation MaterialGroup Product Group
NumberOfGoodsReceipts I_GRIRAccountReconciliation NumberOfGoodsReceipts Number of Goods Receipts
NumberOfInvoiceReceipts I_GRIRAccountReconciliation NumberOfInvoiceReceipts Number of Invoice Receipts
Plant I_GRIRAccountReconciliation Plant Valuation Area
PurchasingGroup I_GRIRAccountReconciliation PurchasingGroup Purchasing Group
PurchasingOrganization I_GRIRAccountReconciliation PurchasingOrganization Purchasing Organization
Supplier I_GRIRAccountReconciliation Supplier Supplier
DueDays
CompanyCodeCurrency I_GRIRAccountReconciliation CompanyCodeCurrency Local Currency
PurgDocOrderQuantityUnit I_GRIRAccountReconciliation PurgDocOrderQuantityUnit Purchasing Document Order Qty Unit
GoodsReceiptGoodsAmtInCCCrcy I_GRIRAccountReconciliation GoodsReceiptGoodsAmtInCCCrcy Goods Receipt Amount (Goods)
InvoiceRcptGoodsAmtInCCCrcy I_GRIRAccountReconciliation InvoiceRcptGoodsAmtInCCCrcy Invoice Receipt Amount (Goods)
GdsRcptDelivCostAmtInCCCrcy I_GRIRAccountReconciliation GdsRcptDelivCostAmtInCCCrcy Goods Receipt Amount (Delivery Costs)
InvcRcptDelivCostAmtInCCCrcy I_GRIRAccountReconciliation InvcRcptDelivCostAmtInCCCrcy Invoice Receipt Amount (Delivery Costs)
GoodsReceiptGoodsQuantity I_GRIRAccountReconciliation GoodsReceiptGdsQtyInRefQtyUnit
InvoiceReceiptGoodsQuantity I_GRIRAccountReconciliation InvoiceRcptGdsQtyInRefQtyUnit
GoodsReceiptDeliveryCostQty I_GRIRAccountReconciliation GRDelivCostQtyInRefQtyUnit
InvoiceRcptDeliveryCostQty I_GRIRAccountReconciliation InvcRcptDelivQtyInRefQtyUnit
GoodsBalanceAmountInCCCrcy I_GRIRAccountReconciliation GoodsBalanceAmountInCCCrcy
GoodsBalanceQuantity I_GRIRAccountReconciliation GdsBalanceQuantityInRefQtyUnit
DeliveryCostBalAmtInCCCrcy I_GRIRAccountReconciliation DeliveryCostBalAmtInCCCrcy
DeliveryCostBalanceQuantity I_GRIRAccountReconciliation DelivCostBalQtyInRefQtyUnit
GoodsReceiptAmountInCoCodeCrcy I_GRIRAccountReconciliation GoodsReceiptAmountInCoCodeCrcy
GoodsReceiptQty I_GRIRAccountReconciliation GoodsReceiptQtyInRefQtyUnit
InvoiceRcptAmtInCoCodeCrcy I_GRIRAccountReconciliation InvoiceRcptAmtInCoCodeCrcy
InvoiceReceiptQty I_GRIRAccountReconciliation InvoiceReceiptQtyInRefQtyUnit
IsGoodsRcptGoodsAmtSurplus I_GRIRAccountReconciliation IsGoodsRcptGoodsAmtSurplus
IsInvoiceGoodsAmountSurplus I_GRIRAccountReconciliation IsInvoiceGoodsAmountSurplus
IsGdsRcptDelivCostAmtSurplus I_GRIRAccountReconciliation IsGdsRcptDelivCostAmtSurplus
IsInvoiceDelivCostAmtSurplus I_GRIRAccountReconciliation IsInvoiceDelivCostAmtSurplus
IsGoodsRcptGoodsQtySurplus I_GRIRAccountReconciliation IsGoodsRcptGoodsQtySurplus
IsInvoiceGoodsQtySurplus I_GRIRAccountReconciliation IsInvoiceGoodsQtySurplus
IsGdsRcptDelivCostQtySurplus I_GRIRAccountReconciliation IsGdsRcptDelivCostQtySurplus
IsInvoiceDelivCostQtySurplus I_GRIRAccountReconciliation IsInvoiceDelivCostQtySurplus

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_GRIRProcInference.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_GRIRProcInference AS
SELECT
  I_GRIRAccountReconciliation.CompanyCode AS CompanyCode,
  I_GRIRAccountReconciliation.PurchasingDocument AS PurchasingDocument,
  I_GRIRAccountReconciliation.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_GRIRAccountReconciliation.LastChangedByUser AS LastChangedByUser,
  I_GRIRAccountReconciliation.ResponsibleDepartment AS PrevResponsibleDepartment,
  I_GRIRAccountReconciliation.ResponsiblePerson AS PrevResponsiblePerson,
  I_GRIRAccountReconciliation.GRIRClearingProcessStatus AS PrevGRIRClearingProcessStatus,
  I_GRIRAccountReconciliation.GRIRClearingProcessPriority AS PrevGRIRClrgProcPriority,
  I_GRIRAccountReconciliation.SystemMessageIdentification AS SystemMessageIdentification,
  I_GRIRAccountReconciliation.SystemMessageType AS SystemMessageType,
  I_GRIRAccountReconciliation.SystemMessageNumber AS SystemMessageNumber,
  I_GRIRAccountReconciliation.AccountAssignmentCategory AS AccountAssignmentCategory,
  I_GRIRAccountReconciliation.BalAmtInCompanyCodeCrcy AS BalAmtInCompanyCodeCrcy,
  cast( I_GRIRAccountReconciliation.BalanceQuantityInRefQtyUnit as fis_grir_bal_qty_rrunit preserving type) AS BalanceQuantity,
  I_GRIRAccountReconciliation.IsFinallyInvoiced AS IsFinallyInvoiced,
  I_GRIRAccountReconciliation.MaterialGroup AS MaterialGroup,
  I_GRIRAccountReconciliation.NumberOfGoodsReceipts AS NumberOfGoodsReceipts,
  I_GRIRAccountReconciliation.NumberOfInvoiceReceipts AS NumberOfInvoiceReceipts,
  I_GRIRAccountReconciliation.Plant AS Plant,
  I_GRIRAccountReconciliation.PurchasingGroup AS PurchasingGroup,
  I_GRIRAccountReconciliation.PurchasingOrganization AS PurchasingOrganization,
  I_GRIRAccountReconciliation.Supplier AS Supplier,
  cast ( dats_days_between( I_GRIRAccountReconciliation.LatestOpenItemPostingDate, cast ( $session.system_date as abap.dats ) ) as fis_due_days preserving type ) AS DueDays,
  I_GRIRAccountReconciliation.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GRIRAccountReconciliation.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
  I_GRIRAccountReconciliation.GoodsReceiptGoodsAmtInCCCrcy AS GoodsReceiptGoodsAmtInCCCrcy,
  I_GRIRAccountReconciliation.InvoiceRcptGoodsAmtInCCCrcy AS InvoiceRcptGoodsAmtInCCCrcy,
  I_GRIRAccountReconciliation.GdsRcptDelivCostAmtInCCCrcy AS GdsRcptDelivCostAmtInCCCrcy,
  I_GRIRAccountReconciliation.InvcRcptDelivCostAmtInCCCrcy AS InvcRcptDelivCostAmtInCCCrcy,
  I_GRIRAccountReconciliation.GoodsReceiptGdsQtyInRefQtyUnit AS GoodsReceiptGoodsQuantity,
  I_GRIRAccountReconciliation.InvoiceRcptGdsQtyInRefQtyUnit AS InvoiceReceiptGoodsQuantity,
  I_GRIRAccountReconciliation.GRDelivCostQtyInRefQtyUnit AS GoodsReceiptDeliveryCostQty,
  I_GRIRAccountReconciliation.InvcRcptDelivQtyInRefQtyUnit AS InvoiceRcptDeliveryCostQty,
  I_GRIRAccountReconciliation.GoodsBalanceAmountInCCCrcy AS GoodsBalanceAmountInCCCrcy,
  I_GRIRAccountReconciliation.GdsBalanceQuantityInRefQtyUnit AS GoodsBalanceQuantity,
  I_GRIRAccountReconciliation.DeliveryCostBalAmtInCCCrcy AS DeliveryCostBalAmtInCCCrcy,
  I_GRIRAccountReconciliation.DelivCostBalQtyInRefQtyUnit AS DeliveryCostBalanceQuantity,
  I_GRIRAccountReconciliation.GoodsReceiptAmountInCoCodeCrcy AS GoodsReceiptAmountInCoCodeCrcy,
  I_GRIRAccountReconciliation.GoodsReceiptQtyInRefQtyUnit AS GoodsReceiptQty,
  I_GRIRAccountReconciliation.InvoiceRcptAmtInCoCodeCrcy AS InvoiceRcptAmtInCoCodeCrcy,
  I_GRIRAccountReconciliation.InvoiceReceiptQtyInRefQtyUnit AS InvoiceReceiptQty,
  I_GRIRAccountReconciliation.IsGoodsRcptGoodsAmtSurplus AS IsGoodsRcptGoodsAmtSurplus,
  I_GRIRAccountReconciliation.IsInvoiceGoodsAmountSurplus AS IsInvoiceGoodsAmountSurplus,
  I_GRIRAccountReconciliation.IsGdsRcptDelivCostAmtSurplus AS IsGdsRcptDelivCostAmtSurplus,
  I_GRIRAccountReconciliation.IsInvoiceDelivCostAmtSurplus AS IsInvoiceDelivCostAmtSurplus,
  I_GRIRAccountReconciliation.IsGoodsRcptGoodsQtySurplus AS IsGoodsRcptGoodsQtySurplus,
  I_GRIRAccountReconciliation.IsInvoiceGoodsQtySurplus AS IsInvoiceGoodsQtySurplus,
  I_GRIRAccountReconciliation.IsGdsRcptDelivCostQtySurplus AS IsGdsRcptDelivCostQtySurplus,
  I_GRIRAccountReconciliation.IsInvoiceDelivCostQtySurplus AS IsInvoiceDelivCostQtySurplus
FROM I_GRIRAccountReconciliation
;

Learn More