C_ControlClassCntntVersion

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_ControlClassCntntVersion.
-- 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: CCTRLCLVER

CREATE VIEW C_ControlClassCntntVersion AS
SELECT
  TrdClassfctnCntntVersUUID,
  TrdClassfctnNmbrSchmCntnt,
  _TrdClassfctnNmbrSchmCntntTxt[ 1: Language = $session.system_language ].TrdClassfctnNmbrSchmCntntName AS TrdClassfctnNmbrSchmCntntName,
  TrdClassfctnCntntVersion,
  TrdClassfctnCntntRevisionVers,
  TrdClassfctnCntntReceivedDate,
  TrdClassfctnCntntVersType,
  TrdClassfctnDataProvider,
  _TrdClassfctnDataPrvdr.TrdClassfctnDataProviderName AS TrdClassfctnDataProviderName,
  TrdClassfctnCntntConsistency,
  TrdClassfctnCntntActvtnStatus,
  TrdClassfctnCntntStatus,
  TrdClassfctnCntntActvtdDate,
  TrdClassfctnCntntActvtdByUser,
  _TrdClassfctnCntntActvtdByUser.UserDescription AS UserDescription,
  TrdClassfctnNmbrSchmType,
  TrdClassfctnCntntLogExternalID,
  TrdClassfctnCntntLogObject,
  TrdClassfctnCntntLogFromDate,
  TrdClassfctnCntntLogSubObj,
  TrdClassfctnCntntLogType
FROM I_ControlClassCntntVersion AS CommodityCodeCntntVersion
LEFT OUTER JOIN C_TrdClassfctnCntntVersionLang AS _TrdClassfctnCntntVersionLang ON TrdClassfctnCntntVersUUID = _TrdClassfctnCntntVersionLang.TrdClassfctnCntntVersUUID  -- association [0..*]
;