C_MngCharcCtlgClfnCharc

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_MngCharcCtlgClfnCharc.
-- 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_MngCharcCtlgClfnCharc AS
SELECT
  ValueHelp.ProdAllocCharcCatalogType AS ProdAllocCharcCatalogType,
  ValueHelp.ProdAllocCharcCatalogUseType AS ProdAllocCharcCatalogUseType,
  ValueHelp.ClfnCharacteristicUseType AS ClfnCharacteristicUseType,
  cast(ValueHelp.Characteristic as clfncharacteristic preserving type ) AS Characteristic,
  but they are included as key fields as they can influence the cardinality key _ClassAssgmt.Class AS Class,
  _ClassAssgmt.ClassType AS ClassType,
  _MatAssgmt.Material AS Material,
  ValueHelp.CharcInternalID AS CharcInternalID,
  ValueHelp.CharcDescription AS CharcDescription,
  ValueHelp.CharcDataType AS CharcDataType,
  ValueHelp.CharcGroup AS CharcGroup,
  _ClassAssgmt.ClfnOrganizationalArea AS ClfnOrganizationalArea,
  ValueHelp.CharcMaintAuthGrp AS CharcMaintAuthGrp,
  cast(ValueHelp.CharcValueUnit as clfncharacteristicunit preserving type) AS CharcValueUnit
LEFT OUTER JOIN P_CharcCtlgClfnCharcClAssgmt AS _ClassAssgmt ON CharcInternalID = _ClassAssgmt.CharcInternalID  -- association [0..*]
LEFT OUTER JOIN P_CharcCtlgClfnCharcMatlAssgmt AS _MatAssgmt ON ClfnCharacteristicUseType = _MatAssgmt.ClfnCharacteristicUseType AND CharcInternalID = _MatAssgmt.CharcInternalID  -- association [0..*]
LEFT OUTER JOIN I_CharcCtlgClfnCharcDataTypeVH AS _ClfnCharcDataType ON _ClfnCharcDataType.CharcDataType = CharcDataType  -- association [0..1]
;