I_PT_SAFTSelfBillgCustAddrHist

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 I_PT_SAFTSelfBillgCustAddrHist.
-- 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: IPTSAFTSBADRHST

CREATE VIEW I_PT_SAFTSelfBillgCustAddrHist AS
SELECT
  Version.FiscalYear AS FiscalYear,
  Version.SupplierInvoice AS SupplierInvoice,
  Version.PlantCustomer AS PlantCustomer,
  Version.CompanyCode AS CompanyCode,
  Version.Supplier AS Supplier,
  Version.PortugueseCustomerVersion AS PortugueseCustomerVersion,
  min(Version._Customer._ContactPerson.FirstName) AS PartnerFirstName,
  min(Version._Customer._ContactPerson.LastName) AS PartnerLastName,
  cast( case when PlantCustomer is not initial then Version._Customer._AddressDefaultRepresentation.Country when SAFTHeader._CompanyCode._OrgAddressDefaultRprstn.Country is not initial then SAFTHeader._CompanyCode._OrgAddressDefaultRprstn.Country else 'PT' end as land1) as Country AS CountryelsePTendasland1asCountry,
  cast( case when Version._Customer._AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress is not initial then Version._Customer._AddressDefaultRepresentation._CurrentDfltEmailAddress.EmailAddress when SAFTHeader._CompanyCode._OrgAddressDefaultRprstn._EmailAddress.EmailAddress is not initial then SAFTHeader._CompanyCode._OrgAddressDefaultRprstn._EmailAddress.EmailAddress end as abap.char(241)) as EmailAddress AS char241asEmailAddress,
  Version._Customer AS _Customer,
  Version._Supplier AS _Supplier
FROM I_PT_SelfBillgCustAddrVers AS Version
INNER JOIN I_SAFTHeader AS SAFTHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON Version.ReconciliationAccount = _GLAccountInCompanyCode.GLAccount AND Version.CompanyCode = _GLAccountInCompanyCode.CompanyCode  -- association [0..1]
;