C_CAMasterDataDistribution

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_CAMasterDataDistribution.
-- 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: CCAMSTRDATADISTR

CREATE VIEW C_CAMasterDataDistribution AS
SELECT
  I_CAMasterDataDistrObject.CAMasterDataDistrObjectType AS CAMasterDataDistrObjectType,
  LTRIM(I_CAMasterDataDistrObject.CAMasterDataDistrObject,'0') AS CAMasterDataDistrObject,
  I_CAMasterDataDistrObject.CAMasterDataDistrObjectRef AS CAMasterDataDistrObjectRef,
  cast('' as abap.char(1) ) AS CAMasterDataDistrRecordType,
  I_CAMasterDataDistrObject.CAMasterDataDistrObjectStatus AS CAMasterDataDistrObjectStatus,
  I_CAMasterDataDistrObject.CAMasterDataDistrObjIsProcd AS CAMasterDataDistrObjIsProcd,
  I_CAMasterDataDistrObject.CAClrfctnIsCompleted AS CAClrfctnIsCompleted,
  cast(0 as int1 ) AS CAPrvdrContrDistrStatusCritlty,
  case when CAClrfctnIsCompleted = 'X' then cast ('C' as abap.char(100) ) when CAMasterDataDistrObjIsProcd = 'X' and CAMasterDataDistrObjectStatus = '' then cast ('S' as abap.char(100) ) when CAMasterDataDistrObjIsProcd = 'X' and CAMasterDataDistrObjectStatus = 'F' then cast ('F' as abap.char(100) ) when CAMasterDataDistrObjIsProcd = '' and CAMasterDataDistrObjectStatus = '' then cast ('I' as abap.char(100) ) else cast ('F' as abap.char(100) ) end as CAMasterDataDistrStatusText AS char100endasCAMasterDataDistrStatusText,
  I_CAMasterDataDistrObject.CARatingArea AS CARatingArea,
  I_CAMasterDataDistrObject._CARatingArea._Text[1:Language = $session.system_language].CARatingAreaDescription AS CARatingAreaDescription,
  I_CAMasterDataDistrObject.CreationDate AS CreationDate,
  I_CAMasterDataDistrObject.CreationTime AS CreationTime,
  I_CAMasterDataDistrObject.CAMasterDataDistrObject AS CAProviderContract,
  _ProviderContract.CAAuthorizationGroup AS CAAuthorizationGroup,
  _ProviderContract.CompanyCode AS CompanyCode
FROM I_CAMasterDataDistrObject
LEFT OUTER JOIN I_CAProviderContractHeader AS _ProviderContract ON /* join condition not captured in parsed metadata */
;