C_PT_SAFTIntegratedCustomer

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_PT_SAFTIntegratedCustomer.
-- 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: CPTSAFTINTCUST
-- Parameters: P_StartDate : dats, P_EndDate : dats

CREATE VIEW C_PT_SAFTIntegratedCustomer AS
SELECT
  CompanyCode,
  PortugueseCustomerWithVersion,
  ReconciliationAccount,
  cast(CustomerVATRegistration as stceg) AS CustomerVATRegistration,
  CompanyName,
  cast(StreetName as fieu_address ) AS StreetName,
  cast(CityName as ad_city1 ) AS CityName,
  PostalCode,
  Country,
  cast(coalesce(CompanyContactPersonFullName, '') as ad_namtext) AS CompanyContactPersonFullName,
  coalesce(PhoneNumber, '') AS PhoneNumber,
  cast(coalesce(FaxNumber, '') as telfx) AS FaxNumber,
  coalesce(EmailAddress, '') AS EmailAddress,
  ' ' as WebsiteURL AS P_StartDate,
  '' AS WebsiteURL
FROM C_PT_SAFTGenLedgerCustomer
-- UNION with additional select branch(es): C_PT_SAFTCustomer
;