P_MntrProdAllocCharcValCombn

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_MntrProdAllocCharcValCombn.
-- 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: PMPACVC

CREATE VIEW P_MntrProdAllocCharcValCombn AS
SELECT
  I_ProdAllocObjCharcValCombn.CharcValueCombinationUUID AS CharcValueCombinationUUID,
  cast( min(_MntrProdAllocPeriods.ProdAllocationPeriodStartDate) as erlstprodallocperiodstartdate preserving type ) AS ProdAllocationPeriodStartDate,
  cast( max(_MntrProdAllocPeriods.ProductAllocationPeriodEndDate) as ltstprodallocperiodenddate preserving type ) AS ProductAllocationPeriodEndDate,
  I_ProdAllocObjCharcValCombn.ProductAllocationObjectUUID AS ProductAllocationObjectUUID,
  I_ProdAllocObjCharcValCombn.ProductAllocationObject AS ProductAllocationObject,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc01 AS ProdAllocCharc01,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc02 AS ProdAllocCharc02,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc03 AS ProdAllocCharc03,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc04 AS ProdAllocCharc04,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc05 AS ProdAllocCharc05,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc06 AS ProdAllocCharc06,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc07 AS ProdAllocCharc07,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc08 AS ProdAllocCharc08,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc09 AS ProdAllocCharc09,
  I_ProdAllocObjCharcValCombn.ProdAllocCharc10 AS ProdAllocCharc10,
  I_ProdAllocObjCharcValCombn.CharcValAuthznGroup AS CharcValAuthznGroup,
  _MntrProdAllocPeriods.ProductAllocationQuantityUnit AS ProductAllocationQuantityUnit,
  sum(_MntrProdAllocPeriods.ProductAllocationQuantity) AS ProductAllocationQuantity,
  _MntrProdAllocPeriods.ProdAllocAssignedQuantityUnit AS ProdAllocAssignedQuantityUnit,
  sum(_MntrProdAllocPeriods.ProdAllocAssignedQuantity) AS ProdAllocAssignedQuantity,
  I_ProdAllocObjCharcValCombn.ProdAllocCharcConstraintStatus AS ProdAllocCharcConstraintStatus,
  I_ProdAllocObjCharcValCombn.ProdAllocationActivationStatus AS ProdAllocationActivationStatus,
  _ProductAllocationObject.ProductAllocationPeriodType AS ProductAllocationPeriodType,
  I_ProdAllocObjCharcValCombn._ProdAllocCharcCstrtStatus AS _ProdAllocCharcCstrtStatus,
  I_ProdAllocObjCharcValCombn._ProdAllocActivationStatus AS _ProdAllocActivationStatus,
  I_ProdAllocObjCharcValCombn.ProdAllocCharcValueCombnCmnt AS ProdAllocCharcValueCombnCmnt,
  _ProductAllocationObject._ProductAllocationPeriodType AS _ProductAllocationPeriodType
FROM I_ProdAllocObjCharcValCombn
LEFT OUTER JOIN P_MntrProdAllocPeriods AS _MntrProdAllocPeriods ON /* join condition not captured in parsed metadata */
;