P_GRIRPurchasingDocItemDigest1
GR/IR Purchasing Document Item Digest1
P_GRIRPurchasingDocItemDigest1 is a Consumption CDS View that provides data about "GR/IR Purchasing Document Item Digest1" in SAP S/4HANA. It reads from 2 data sources (P_GRIRAnalysis, P_GRIRAnalysis) and exposes 87 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, FiscalYear.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_GRIRAnalysis | P_GRIRAnalysis | from |
| P_GRIRAnalysis | P_GRIRAnalysis | union_all |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.sqlViewName | PFIGRIRPDOCIDIG1 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | GR/IR Purchasing Document Item Digest1 | view | |
| VDM.viewType | #CONSUMPTION | view | |
| VDM.private | true | view | |
| ObjectModel.representativeKey | LedgerGLLineItem | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.buffering.status | #NOT_ALLOWED | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (87)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | P_GRIRAnalysis | CompanyCode | Receiver Company Code |
| KEY | FiscalYear | P_GRIRAnalysis | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | P_GRIRAnalysis | AccountingDocument | Journal Entry |
| KEY | LedgerGLLineItem | P_GRIRAnalysis | LedgerGLLineItem | Journal Entry Item |
| AccountingDocumentItem | P_GRIRAnalysis | AccountingDocumentItem | Posting View Item | |
| PurchasingDocument | P_GRIRAnalysis | PurchasingDocument | Purchasing Document | |
| PurchasingDocumentItem | P_GRIRAnalysis | PurchasingDocumentItem | Purchasing Doc. Item | |
| ResponsibleDepartment | ||||
| ResponsiblePerson | ||||
| GRIRClearingProcessStatus | ||||
| GRIRClearingProcessPriority | ||||
| GRIRClearingProcessRootCause | ||||
| LastChangeDate | ||||
| LastChangeDateTime | ||||
| ProposedResponsiblePerson | ||||
| GRIRClrgProcessPrpsdStatus | ||||
| GRIRClrgProcPrpsdPriority | ||||
| GRIRClrgProcessPrpsdRootCause | ||||
| Supplier | ||||
| SupplierName | ||||
| PurchasingGroup | ||||
| PurchasingOrganization | ||||
| Plant | ||||
| GlobalCurrency | P_GRIRAnalysis | GlobalCurrency | GM Billing Element: Global Currency | |
| AmountInGlobalCurrency | P_GRIRAnalysis | AmountInGlobalCurrency | Amount in Global Currency | |
| AmountInCompanyCodeCurrency | P_GRIRAnalysis | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| BalanceAbsoluteAmtInCoCodeCrcy | P_GRIRAnalysis | BalanceAbsoluteAmtInCoCodeCrcy | ||
| BalanceAbsoluteQuantity | P_GRIRAnalysis | BalanceAbsoluteQuantity | ||
| PurgDocOrderQuantityUnit | P_GRIRAnalysis | PurgDocOrderQuantityUnit | Purchasing Document Order Qty Unit | |
| CompanyCodeCurrency | P_GRIRAnalysis | CompanyCodeCurrency | Local Currency | |
| NetAmount | ||||
| DocumentCurrency | ||||
| NumberOfPurchaseOrderItems | ||||
| CreatedByUser | ||||
| MaterialGroup | ||||
| LastChangeDays | ||||
| _GlobalCurrency | P_GRIRAnalysis | _GlobalCurrency | ||
| _CompanyCode | P_GRIRAnalysis | _CompanyCode | ||
| _CompanyCodeCurrency | P_GRIRAnalysis | _CompanyCodeCurrency | ||
| _PurchasingDocument | P_GRIRAnalysis | _PurchasingDocument | ||
| _PurchasingDocumentItem | P_GRIRAnalysis | _PurchasingDocumentItem | ||
| _AccountingDocument | P_GRIRAnalysis | _AccountingDocument | ||
| _FiscalYear | P_GRIRAnalysis | _FiscalYear | ||
| CompanyCode | Receiver Company Code | |||
| KEY | FiscalYear | P_GRIRAnalysis | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | P_GRIRAnalysis | AccountingDocument | Journal Entry |
| KEY | LedgerGLLineItem | P_GRIRAnalysis | LedgerGLLineItem | Journal Entry Item |
| AccountingDocumentItem | P_GRIRAnalysis | AccountingDocumentItem | Posting View Item | |
| PurchasingDocument | P_GRIRAnalysis | PurchasingDocument | Purchasing Document | |
| PurchasingDocumentItem | P_GRIRAnalysis | PurchasingDocumentItem | Purchasing Doc. Item | |
| ResponsibleDepartment | ||||
| ResponsiblePerson | ||||
| GRIRClearingProcessStatus | ||||
| GRIRClearingProcessPriority | ||||
| GRIRClearingProcessRootCause | ||||
| LastChangeDate | ||||
| LastChangeDateTime | ||||
| ProposedResponsiblePerson | ||||
| GRIRClrgProcessPrpsdStatus | ||||
| GRIRClrgProcPrpsdPriority | ||||
| GRIRClrgProcessPrpsdRootCause | ||||
| Supplier | ||||
| SupplierName | ||||
| PurchasingGroup | ||||
| PurchasingOrganization | ||||
| Plant | ||||
| GlobalCurrency | P_GRIRAnalysis | GlobalCurrency | GM Billing Element: Global Currency | |
| AmountInGlobalCurrency | P_GRIRAnalysis | AmountInGlobalCurrency | Amount in Global Currency | |
| AmountInCompanyCodeCurrency | P_GRIRAnalysis | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| BalanceAbsoluteAmtInCoCodeCrcy | P_GRIRAnalysis | BalanceAbsoluteAmtInCoCodeCrcy | ||
| BalanceAbsoluteQuantity | P_GRIRAnalysis | BalanceAbsoluteQuantity | ||
| PurgDocOrderQuantityUnit | P_GRIRAnalysis | PurgDocOrderQuantityUnit | Purchasing Document Order Qty Unit | |
| CompanyCodeCurrency | P_GRIRAnalysis | CompanyCodeCurrency | Local Currency | |
| NetAmount | ||||
| DocumentCurrency | ||||
| NumberOfPurchaseOrderItems | ||||
| CreatedByUser | ||||
| MaterialGroup | ||||
| LastChangeDays | ||||
| _GlobalCurrency | P_GRIRAnalysis | _GlobalCurrency | ||
| _CompanyCode | P_GRIRAnalysis | _CompanyCode | ||
| _CompanyCodeCurrency | P_GRIRAnalysis | _CompanyCodeCurrency | ||
| _PurchasingDocument | P_GRIRAnalysis | _PurchasingDocument | ||
| _PurchasingDocumentItem | P_GRIRAnalysis | _PurchasingDocumentItem | ||
| _AccountingDocument | P_GRIRAnalysis | _AccountingDocument | ||
| _FiscalYear | P_GRIRAnalysis | _FiscalYear | ||
| _GRIRProcess | P_GRIRAnalysis | _GRIRProcess |
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 P_GRIRPurchasingDocItemDigest1.
-- 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.
-- SQL view name: PFIGRIRPDOCIDIG1
CREATE VIEW P_GRIRPurchasingDocItemDigest1 AS
SELECT
P_GRIRAnalysis.CompanyCode AS CompanyCode,
P_GRIRAnalysis.FiscalYear AS FiscalYear,
P_GRIRAnalysis.AccountingDocument AS AccountingDocument,
P_GRIRAnalysis.LedgerGLLineItem AS LedgerGLLineItem,
P_GRIRAnalysis.AccountingDocumentItem AS AccountingDocumentItem,
P_GRIRAnalysis.PurchasingDocument AS PurchasingDocument,
P_GRIRAnalysis.PurchasingDocumentItem AS PurchasingDocumentItem,
P_GRIRAnalysis._GRIRProcess.ResponsibleDepartment AS ResponsibleDepartment,
P_GRIRAnalysis._GRIRProcess.ResponsiblePerson AS ResponsiblePerson,
P_GRIRAnalysis._GRIRProcess.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
P_GRIRAnalysis._GRIRProcess.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
P_GRIRAnalysis._GRIRProcess.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
P_GRIRAnalysis._GRIRProcess.LastChangeDate AS LastChangeDate,
P_GRIRAnalysis._GRIRProcess.LastChangeDateTime AS LastChangeDateTime,
P_GRIRAnalysis._GRIRProcess.ProposedResponsiblePerson AS ProposedResponsiblePerson,
P_GRIRAnalysis._GRIRProcess.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
P_GRIRAnalysis._GRIRProcess.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
P_GRIRAnalysis._GRIRProcess.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
P_GRIRAnalysis._PurchasingDocument.Supplier AS Supplier,
P_GRIRAnalysis._PurchasingDocument._Supplier.SupplierName AS SupplierName,
P_GRIRAnalysis._PurchasingDocument.PurchasingGroup AS PurchasingGroup,
P_GRIRAnalysis._PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
P_GRIRAnalysis._PurchasingDocumentItem.Plant AS Plant,
P_GRIRAnalysis.GlobalCurrency AS GlobalCurrency,
P_GRIRAnalysis.AmountInGlobalCurrency AS AmountInGlobalCurrency,
P_GRIRAnalysis.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
P_GRIRAnalysis.BalanceAbsoluteAmtInCoCodeCrcy AS BalanceAbsoluteAmtInCoCodeCrcy,
P_GRIRAnalysis.BalanceAbsoluteQuantity AS BalanceAbsoluteQuantity,
P_GRIRAnalysis.PurgDocOrderQuantityUnit AS PurgDocOrderQuantityUnit,
P_GRIRAnalysis.CompanyCodeCurrency AS CompanyCodeCurrency,
P_GRIRAnalysis._PurchasingDocumentItem.NetAmount AS NetAmount,
P_GRIRAnalysis._PurchasingDocumentItem.DocumentCurrency AS DocumentCurrency,
cast( 1 as fis_grir_no_po_items ) AS NumberOfPurchaseOrderItems,
P_GRIRAnalysis._PurchasingDocument.CreatedByUser AS CreatedByUser,
P_GRIRAnalysis._PurchasingDocumentItem.MaterialGroup AS MaterialGroup,
cast( 0 as fis_last_change_days) AS LastChangeDays,
P_GRIRAnalysis._GlobalCurrency AS _GlobalCurrency,
P_GRIRAnalysis._CompanyCode AS _CompanyCode,
P_GRIRAnalysis._CompanyCodeCurrency AS _CompanyCodeCurrency,
P_GRIRAnalysis._PurchasingDocument AS _PurchasingDocument,
P_GRIRAnalysis._PurchasingDocumentItem AS _PurchasingDocumentItem,
P_GRIRAnalysis._AccountingDocument AS _AccountingDocument,
P_GRIRAnalysis._FiscalYear AS _FiscalYear,
P_GRIRAnalysis._GRIRProcess AS _GRIRProcess
FROM P_GRIRAnalysis
-- UNION ALL with additional select branch(es): P_GRIRAnalysis
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA