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.

CREATE VIEW C_CAMasterDataIDTP AS
SELECT
  CAMasterDataID,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CAInvcgBusinessPartnerAddress.StreetName AS StreetName,
  _CAInvcgBusinessPartnerAddress.AddressCityName AS AddressCityName,
  _CAInvcgBusinessPartnerAddress.CountryName AS CountryName,
  ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  CAContract,
  CASubApplication,
  CAProviderContractItemNumber,
  CAProviderContractItemUUID,
  CAAccessUserID,
  CAAccessServiceID,
  LastChangedByUser,
  _LastChangedByUser.UserDescription AS UserDescription,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  _CAMasterDataIDText.CAMasterDataIDText : localized AS CAMasterDataIDTextlocalized
FROM R_CAMasterDataIDTP
;