C_MngCharcCtlgCharcTP

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_MngCharcCtlgCharcTP.
-- 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: CMNGCCTLGCHTP

CREATE VIEW C_MngCharcCtlgCharcTP AS
SELECT
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathUUID AS ProdAllocCharcCtlgPathUUID,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgCharc AS ProdAllocCharcCtlgCharc,
  cast( _MngCharcCatalogPathDisplay.CharcCtlgPathOriglDescription as charccatalogcharacteristicdesc preserving type ) AS ProdAllocCharcCtlgPathDesc,
  cast( ' ' as charcctlgparentdescription ) AS CharcCtlgParentPathDescription,
  I_ProdAllocCharcCtlgPathTP.CharcValExistenceCheckType AS CharcValExistenceCheckType,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathIntID AS ProdAllocCharcCtlgPathIntID,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogType AS ProdAllocCharcCatalogType,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogUseType AS ProdAllocCharcCatalogUseType,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogUUID AS ProdAllocCharcCatalogUUID,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgParPathIntID AS ProdAllocCharcCtlgParPathIntID,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogCharcType AS ProdAllocCharcCatalogCharcType,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogPathType AS ProdAllocCharcCatalogPathType,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathSelName AS ProdAllocCharcCtlgPathSelName,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathSel AS ProdAllocCharcCtlgPathSel,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogPath AS ProdAllocCharcCatalogPath,
  I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathIsHidden AS ProdAllocCharcCtlgPathIsHidden,
  I_ProdAllocCharcCtlgPathTP.CharcCatalogCharacteristicName AS CharcCatalogCharacteristicName
FROM I_ProdAllocCharcCtlgPathTP
LEFT OUTER JOIN C_MngCharcCatalogPathDisplay AS _MngCharcCatalogPathDisplay ON ProdAllocCharcCtlgPathIntID = _MngCharcCatalogPathDisplay.ProdAllocCharcCtlgPathIntID  -- association [1..1]
LEFT OUTER JOIN C_MngCharcCtlgTP AS _ProdAllocCharcCatalogTP ON ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalogTP.ProdAllocCharcCatalogUUID  -- association [1..1]
LEFT OUTER JOIN C_MngCharcCtlgCharcTTP AS _AllocCharcCtlgPathTTP ON ProdAllocCharcCtlgPathUUID = _AllocCharcCtlgPathTTP.ProdAllocCharcCtlgPathUUID AND _AllocCharcCtlgPathTTP.Language = $session.system_language  -- association [0..1]
;