C_GRIRPurgDocItemDigest

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 C_GRIRPurgDocItemDigest.
-- 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 C_GRIRPurgDocItemDigest AS
SELECT
  P_GRIRPurchasingDocItemDigest2.CompanyCode AS CompanyCode,
  P_GRIRPurchasingDocItemDigest2.PurchasingDocument AS PurchasingDocument,
  P_GRIRPurchasingDocItemDigest2.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GRIRPurchasingDocItemDigest2.GlobalCurrency AS GlobalCurrency,
  cast( P_GRIRPurchasingDocItemDigest2.AmountInGlobalCurrency as fis_ksl preserving type ) AS AmountInGlobalCurrency,
  P_GRIRPurchasingDocItemDigest2.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( P_GRIRPurchasingDocItemDigest2.AmountInCompanyCodeCurrency as fis_hsl preserving type) AS AmountInCompanyCodeCurrency,
  cast( P_GRIRPurchasingDocItemDigest2.BalanceAbsoluteAmtInCoCodeCrcy as fis_abs_bal_dmbtr preserving type) AS BalanceAbsoluteAmtInCoCodeCrcy,
  P_GRIRPurchasingDocItemDigest2.DocumentCurrency AS DocumentCurrency,
  cast( P_GRIRPurchasingDocItemDigest2.NetAmount as bwert preserving type) AS NetAmount,
  P_GRIRPurchasingDocItemDigest2.CreatedByUser AS CreatedByUser,
  P_GRIRPurchasingDocItemDigest2.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  P_GRIRPurchasingDocItemDigest2.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  P_GRIRPurchasingDocItemDigest2.ResponsibleDepartment AS ResponsibleDepartment,
  P_GRIRPurchasingDocItemDigest2.ResponsiblePerson AS ResponsiblePerson,
  P_GRIRPurchasingDocItemDigest2.LastChangeDateTime AS LastChangeDateTime,
  P_GRIRPurchasingDocItemDigest2.LastChangeDate AS LastChangeDate,
  cast ( dats_days_between( P_GRIRPurchasingDocItemDigest2.LastChangeDate, cast ( $session.system_date as abap.dats ) ) as fis_due_days preserving type ) AS LastChangeDays,
  P_GRIRPurchasingDocItemDigest2.GRIRClrgProcessPrpsdStatus AS GRIRClrgProcessPrpsdStatus,
  P_GRIRPurchasingDocItemDigest2.GRIRClrgProcPrpsdPriority AS GRIRClrgProcPrpsdPriority,
  P_GRIRPurchasingDocItemDigest2.GRIRClrgProcessPrpsdRootCause AS GRIRClrgProcessPrpsdRootCause,
  P_GRIRPurchasingDocItemDigest2.NumberOfPurchaseOrderItems AS NumberOfPurchaseOrderItems,
  P_GRIRPurchasingDocItemDigest2._CompanyCode.CompanyCodeName AS CompanyCodeName,
  P_GRIRPurchasingDocItemDigest2.Plant AS Plant,
  P_GRIRPurchasingDocItemDigest2._PurchasingDocumentItem._Plant.PlantName AS PlantName,
  P_GRIRPurchasingDocItemDigest2.PurchasingGroup AS PurchasingGroup,
  P_GRIRPurchasingDocItemDigest2._PurchasingDocument._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  P_GRIRPurchasingDocItemDigest2.PurchasingOrganization AS PurchasingOrganization,
  P_GRIRPurchasingDocItemDigest2._PurchasingDocument._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  P_GRIRPurchasingDocItemDigest2.Supplier AS Supplier,
  P_GRIRPurchasingDocItemDigest2.SupplierName AS SupplierName,
  P_GRIRPurchasingDocItemDigest2.MaterialGroup AS MaterialGroup,
  P_GRIRPurchasingDocItemDigest2._PurchasingDocumentItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  P_GRIRPurchasingDocItemDigest2._GlobalCurrency AS _GlobalCurrency,
  P_GRIRPurchasingDocItemDigest2._CompanyCode AS _CompanyCode,
  P_GRIRPurchasingDocItemDigest2._CompanyCodeCurrency AS _CompanyCodeCurrency,
  P_GRIRPurchasingDocItemDigest2._GRIRProcess AS _GRIRProcess,
  P_GRIRPurchasingDocItemDigest2._PurchasingDocument AS _PurchasingDocument,
  P_GRIRPurchasingDocItemDigest2._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM P_GRIRPurchasingDocItemDigest2
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ResponsiblePerson ON ResponsiblePerson = _ResponsiblePerson.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ProposedResponsiblePerson ON ProposedResponsiblePerson = _ProposedResponsiblePerson.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRProcessStatusText ON GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRClrgProcPrpsdStatusText ON GRIRClrgProcessPrpsdStatus = _GRIRClrgProcPrpsdStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRProcessPriorityText ON GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRClrgProcPrpsdPriorityText ON GRIRClrgProcPrpsdPriority = _GRIRClrgProcPrpsdPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessRootCauseText ON GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessPrpsdRootCauseText ON GRIRClrgProcessPrpsdRootCause = _GRIRProcessPrpsdRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
;