C_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 C_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: CMPACVC

CREATE VIEW C_MntrProdAllocCharcValCombn AS
SELECT
  CharcValueCombinationUUID,
  ProdAllocationPeriodStartDate,
  ProductAllocationPeriodEndDate,
  ProductAllocationObjectUUID,
  cast( ' ' as prodallocobjcharacteristics ) AS ProdAllocObjCharacteristics,
  cast( ' ' as prodalloccharcvalcombn ) AS ProdAllocCharcValCombn,
  cast( ' ' as prodalloccharcvalcombdesc ) AS ProdAllocCharcValCombDesc,
  _ProductAllocationObjectText.ProdAllocObjectDescription AS ProdAllocObjectDescription,
  ProductAllocationObject,
  ProdAllocCharc01,
  ProdAllocCharc02,
  ProdAllocCharc03,
  ProdAllocCharc04,
  ProdAllocCharc05,
  ProdAllocCharc06,
  ProdAllocCharc07,
  ProdAllocCharc08,
  ProdAllocCharc09,
  ProdAllocCharc10,
  ProductAllocationQuantityUnit,
  cast(ProductAllocationQuantity as pal_aggrgdplndqty preserving type) AS ProductAllocationQuantity,
  ProdAllocAssignedQuantityUnit,
  cast(ProdAllocAssignedQuantity as pal_aggrgdcnsmdqty preserving type) AS ProdAllocAssignedQuantity,
  cast(ProductAllocationQuantity - ProdAllocAssignedQuantity as pal_aggrgdavailqty ) AS ProdAllocAvailableQuantity,
  ProductAllocationPeriodType,
  ProdAllocCharcConstraintStatus,
  ProdAllocationActivationStatus,
  ProdAllocCharcValueCombnCmnt,
  cast('%' as prodallocpercentunit) AS ProdAllocPercentUnit,
  CharcValAuthznGroup
FROM P_MntrProdAllocCharcValCombn
LEFT OUTER JOIN C_MntrProdAllocValCombnPerds AS _MntrProdAllocValCombnPerds ON CharcValueCombinationUUID = _MntrProdAllocValCombnPerds.CharcValueCombinationUUID  -- association [0..*]
LEFT OUTER JOIN I_ProductAllocationObjectText AS _ProductAllocationObjectText ON ProductAllocationObjectUUID = _ProductAllocationObjectText.ProductAllocationObjectUUID AND _ProductAllocationObjectText.Language = $session.system_language  -- association [0..1]
;