P_GRIRPurchasingDocItemDigest2

DDL: P_GRIRPURCHASINGDOCITEMDIGEST2 SQL: PFIGRIRPDOCIDIG2 Type: view CONSUMPTION
35 Fields 1 Data Sources

GR/IR Purchasing Document Item Digest2

P_GRIRPurchasingDocItemDigest2 is a Consumption CDS View that provides data about "GR/IR Purchasing Document Item Digest2" in SAP S/4HANA. It reads from 1 data source (P_GRIRPurchasingDocItemDigest1) and exposes 35 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
P_GRIRPurchasingDocItemDigest1 P_GRIRPurchasingDocItemDigest1 from

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PFIGRIRPDOCIDIG2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label GR/IR Purchasing Document Item Digest2 view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.representativeKey PurchasingDocumentItem view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_GRIRPurchasingDocItemDigest1 CompanyCode Receiver Company Code
KEY PurchasingDocument P_GRIRPurchasingDocItemDigest1 PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem P_GRIRPurchasingDocItemDigest1 PurchasingDocumentItem Purchasing Doc. Item
GlobalCurrency P_GRIRPurchasingDocItemDigest1 GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency
AmountInCompanyCodeCurrency
BalanceAbsoluteAmtInCoCodeCrcy
CompanyCodeCurrency P_GRIRPurchasingDocItemDigest1 CompanyCodeCurrency Local Currency
DocumentCurrency P_GRIRPurchasingDocItemDigest1 DocumentCurrency Document Currency
GRIRClearingProcessStatus P_GRIRPurchasingDocItemDigest1 GRIRClearingProcessStatus Status
GRIRClearingProcessPriority P_GRIRPurchasingDocItemDigest1 GRIRClearingProcessPriority Priority
GRIRClearingProcessRootCause P_GRIRPurchasingDocItemDigest1 GRIRClearingProcessRootCause Root Cause
ResponsibleDepartment P_GRIRPurchasingDocItemDigest1 ResponsibleDepartment Processing Department
ResponsiblePerson P_GRIRPurchasingDocItemDigest1 ResponsiblePerson Processor
LastChangeDate P_GRIRPurchasingDocItemDigest1 LastChangeDate Time Stamp
LastChangeDateTime P_GRIRPurchasingDocItemDigest1 LastChangeDateTime Timestamp
NetAmount
NumberOfPurchaseOrderItems P_GRIRPurchasingDocItemDigest1 NumberOfPurchaseOrderItems Number of PO Items
Plant P_GRIRPurchasingDocItemDigest1 Plant Valuation Area
PurchasingGroup P_GRIRPurchasingDocItemDigest1 PurchasingGroup Purchasing Group
PurchasingOrganization P_GRIRPurchasingDocItemDigest1 PurchasingOrganization Purchasing Organization
Supplier P_GRIRPurchasingDocItemDigest1 Supplier Supplier
SupplierName P_GRIRPurchasingDocItemDigest1 SupplierName Supplier Name
CreatedByUser P_GRIRPurchasingDocItemDigest1 CreatedByUser User Name
MaterialGroup P_GRIRPurchasingDocItemDigest1 MaterialGroup Product Group
ProposedResponsiblePerson P_GRIRPurchasingDocItemDigest1 ProposedResponsiblePerson Proposed Processor
GRIRClrgProcessPrpsdStatus P_GRIRPurchasingDocItemDigest1 GRIRClrgProcessPrpsdStatus Proposed Status
GRIRClrgProcPrpsdPriority P_GRIRPurchasingDocItemDigest1 GRIRClrgProcPrpsdPriority Proposed Priority
GRIRClrgProcessPrpsdRootCause P_GRIRPurchasingDocItemDigest1 GRIRClrgProcessPrpsdRootCause Proposed Root Cause
_GlobalCurrency P_GRIRPurchasingDocItemDigest1 _GlobalCurrency
_CompanyCode P_GRIRPurchasingDocItemDigest1 _CompanyCode
_CompanyCodeCurrency P_GRIRPurchasingDocItemDigest1 _CompanyCodeCurrency
_PurchasingDocument P_GRIRPurchasingDocItemDigest1 _PurchasingDocument
_PurchasingDocumentItem P_GRIRPurchasingDocItemDigest1 _PurchasingDocumentItem
_GRIRProcess P_GRIRPurchasingDocItemDigest1 _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_GRIRPurchasingDocItemDigest2.
-- 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: PFIGRIRPDOCIDIG2

CREATE VIEW P_GRIRPurchasingDocItemDigest2 AS
SELECT
  P_GRIRPurchasingDocItemDigest1.CompanyCode AS CompanyCode,
  P_GRIRPurchasingDocItemDigest1.PurchasingDocument AS PurchasingDocument,
  P_GRIRPurchasingDocItemDigest1.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GRIRPurchasingDocItemDigest1.GlobalCurrency AS GlobalCurrency,
  sum( P_GRIRPurchasingDocItemDigest1.AmountInGlobalCurrency ) AS AmountInGlobalCurrency,
  sum( P_GRIRPurchasingDocItemDigest1.AmountInCompanyCodeCurrency ) AS AmountInCompanyCodeCurrency,
  sum( P_GRIRPurchasingDocItemDigest1.BalanceAbsoluteAmtInCoCodeCrcy ) AS BalanceAbsoluteAmtInCoCodeCrcy,
  P_GRIRPurchasingDocItemDigest1.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_GRIRPurchasingDocItemDigest1.DocumentCurrency AS DocumentCurrency,
  P_GRIRPurchasingDocItemDigest1.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  P_GRIRPurchasingDocItemDigest1.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  P_GRIRPurchasingDocItemDigest1.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  P_GRIRPurchasingDocItemDigest1.ResponsibleDepartment AS ResponsibleDepartment,
  P_GRIRPurchasingDocItemDigest1.ResponsiblePerson AS ResponsiblePerson,
  P_GRIRPurchasingDocItemDigest1.LastChangeDate AS LastChangeDate,
  P_GRIRPurchasingDocItemDigest1.LastChangeDateTime AS LastChangeDateTime,
  sum( P_GRIRPurchasingDocItemDigest1.NetAmount ) AS NetAmount,
  P_GRIRPurchasingDocItemDigest1.NumberOfPurchaseOrderItems AS NumberOfPurchaseOrderItems,
  P_GRIRPurchasingDocItemDigest1.Plant AS Plant,
  P_GRIRPurchasingDocItemDigest1.PurchasingGroup AS PurchasingGroup,
  P_GRIRPurchasingDocItemDigest1.PurchasingOrganization AS PurchasingOrganization,
  P_GRIRPurchasingDocItemDigest1.Supplier AS Supplier,
  P_GRIRPurchasingDocItemDigest1.SupplierName AS SupplierName,
  P_GRIRPurchasingDocItemDigest1.CreatedByUser AS CreatedByUser,
  P_GRIRPurchasingDocItemDigest1.MaterialGroup AS MaterialGroup,
  P_GRIRPurchasingDocItemDigest1.ProposedResponsiblePerson AS ProposedResponsiblePerson,
  P_GRIRPurchasingDocItemDigest1.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  P_GRIRPurchasingDocItemDigest1.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  P_GRIRPurchasingDocItemDigest1.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  P_GRIRPurchasingDocItemDigest1._GlobalCurrency AS _GlobalCurrency,
  P_GRIRPurchasingDocItemDigest1._CompanyCode AS _CompanyCode,
  P_GRIRPurchasingDocItemDigest1._CompanyCodeCurrency AS _CompanyCodeCurrency,
  P_GRIRPurchasingDocItemDigest1._PurchasingDocument AS _PurchasingDocument,
  P_GRIRPurchasingDocItemDigest1._PurchasingDocumentItem AS _PurchasingDocumentItem,
  P_GRIRPurchasingDocItemDigest1._GRIRProcess AS _GRIRProcess
FROM P_GRIRPurchasingDocItemDigest1
;

Learn More