C_CAMasterDataIDTP

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_CAMasterDataIDTP.
-- 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: CCAMDIDTP

CREATE VIEW C_CAMasterDataIDTP AS
SELECT
  CAMasterDataIDTP.CAMasterDataID AS CAMasterDataID,
  CAMasterDataIDTP.CAMasterDataIDTrim AS CAMasterDataIDTrim,
  CAMasterDataIDTP.BusinessPartner AS BusinessPartner,
  CAMasterDataIDTP._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CAInvcgBusinessPartnerAddress.StreetName AS StreetName,
  _CAInvcgBusinessPartnerAddress.AddressCityName AS AddressCityName,
  _CAInvcgBusinessPartnerAddress.CountryName AS CountryName,
  CAMasterDataIDTP.ContractAccount AS ContractAccount,
  CAMasterDataIDTP._ContractAccountHeader.ContractAccountName AS ContractAccountName,
  CAMasterDataIDTP.CAContract AS CAContract,
  cast ( '' as vtref_semobj_kk ) AS CAContractSemanticObject,
  CAMasterDataIDTP.CASubApplication AS CASubApplication,
  CAMasterDataIDTP.CAProviderContractItemNumber AS CAProviderContractItemNumber,
  CAMasterDataIDTP.CAProviderContractItemUUID AS CAProviderContractItemUUID,
  CAMasterDataIDTP.CAAccessUserID AS CAAccessUserID,
  CAMasterDataIDTP.CAAccessServiceID AS CAAccessServiceID,
  CAMasterDataIDTP.LastChangedByUser AS LastChangedByUser,
  CAMasterDataIDTP._LastChangedByUser.UserDescription AS UserDescription,
  CAMasterDataIDTP.LastChangeDate AS LastChangeDate,
  CAMasterDataIDTP.LastChangeTime AS LastChangeTime,
  cast(0 as changetimestamp_kk) AS LastChangeDateTime,
  CAMasterDataIDTP._BusinessPartner AS _BusinessPartner,
  CAMasterDataIDTP._ContractAccountHeader AS _ContractAccountHeader,
  CAMasterDataIDTP._CASubApplication AS _CASubApplication,
  CAMasterDataIDTP._CAProviderContractItem AS _CAProviderContractItem,
  CAMasterDataIDTP._LastChangedByUser AS _LastChangedByUser
FROM I_CAMasterDataIDTP AS CAMasterDataIDTP
LEFT OUTER JOIN C_CAMasterDataIDTextTP AS _CAMasterDataIDTextTP ON CAMasterDataID = _CAMasterDataIDTextTP.CAMasterDataID  -- association [0..*]
LEFT OUTER JOIN C_CAMasterDataIDTextTP AS _TextInSessionLanguage ON CAMasterDataID = _TextInSessionLanguage.CAMasterDataID AND _TextInSessionLanguage.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_CABillgReqBPAddress AS _CAInvcgBusinessPartnerAddress ON BusinessPartner = _CAInvcgBusinessPartnerAddress.BusinessPartner  -- association [0..1]
;