C_MngCharcCtlgAuthznValueTP

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_MngCharcCtlgAuthznValueTP.
-- 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: CMNGCCTLGAVALTP

CREATE VIEW C_MngCharcCtlgAuthznValueTP AS
SELECT
  CharcValAuthznGroupValueUUID,
  ProdAllocCharcCatalogUUID,
  CharcValAuthznGroupUUID,
  AuthznCharcUUID,
  _AllocCharcCtlgAuthznCharcDsp.CharcValAuthznGrpPriorityValue AS CharcValAuthznGrpPriorityValue,
  cast(_MngCharcCatalogPathDisplay.ProdAllocCharcCtlgPathDesc as authzncharcdesc) AS AuthznCharcDesc,
  AuthznCharcValueID,
  cast( ' ' as authzncharcvaluedesc ) AS AuthznCharcValueDesc,
  ProdAllocCharcCtlgPathIntID,
  AuthznCharcValueIsChanged,
  ProdAllocationActivationStatus,
  IsDeleted
FROM I_AllocCharcCtlgAuthznValueTP
LEFT OUTER JOIN C_MngCharcCtlgTP AS _ProdAllocCharcCatalogTP ON ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalogTP.ProdAllocCharcCatalogUUID  -- association [1..1]
LEFT OUTER JOIN C_MngCharcCtlgAuthznGroupTP AS _AllocCharcCtlgAuthznGroupTP ON CharcValAuthznGroupUUID = _AllocCharcCtlgAuthznGroupTP.CharcValAuthznGroupUUID  -- association [1..1]
LEFT OUTER JOIN I_AllocCharcCtlgAuthznCharcDsp AS _AllocCharcCtlgAuthznCharcDsp ON AuthznCharcUUID = _AllocCharcCtlgAuthznCharcDsp.AuthznCharcUUID  -- association [1..1]
LEFT OUTER JOIN C_MngCharcCatalogPathDisplay AS _MngCharcCatalogPathDisplay ON ProdAllocCharcCtlgPathIntID = _MngCharcCatalogPathDisplay.ProdAllocCharcCtlgPathIntID  -- association [1..1]
;