C_PT_SAFTGenLedgerBPContact

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_SAFTGenLedgerBPContact.
-- 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_PT_SAFTGenLedgerBPContact AS
SELECT
  Document.CompanyCode AS CompanyCode,
  Document.FiscalYear AS FiscalYear,
  Document.Customer AS Customer,
  cast(' ' as stceg) AS VATRegistration,
  BusinessPartnerCustomer,
  Document.Supplier AS Supplier,
  DelivOfGoodsDestCountry,
  IsOneTimeAccount,
  cast(case when Document.Supplier is not initial then case Document._Supplier.IsOneTimeAccount when 'X' then case when Document._Supplier._AddressDefaultRepresentation._FaxNumber.InternationalFaxNumber is not initial and Document._Supplier._AddressDefaultRepresentation._FaxNumber.InternationalFaxNumber is not null then Document._Supplier._AddressDefaultRepresentation._FaxNumber.InternationalFaxNumber when _Address._FaxNumber.InternationalFaxNumber is not initial and _Address._FaxNumber.InternationalFaxNumber is not null then _Address._FaxNumber.InternationalFaxNumber else 'Desconhecido' end else Document._Supplier._AddressDefaultRepresentation._FaxNumber.InternationalFaxNumber end else case Document._Customer.IsOneTimeAccount when 'X' then case when Document._Customer._AddressDefaultRepresentation._FaxNumber.InternationalFaxNumber is not initial and Document._Customer._AddressDefaultRepresentation._FaxNumber.InternationalFaxNumber is not null then Document._Customer._AddressDefaultRepresentation._FaxNumber.InternationalFaxNumber when _Address._FaxNumber.InternationalFaxNumber is not initial and _Address._FaxNumber.InternationalFaxNumber is not null then _Address._FaxNumber.InternationalFaxNumber else 'Desconhecido' end else case when _CustHist.FaxNumber is not initial then _CustHist.FaxNumber else Document._Customer._AddressDefaultRepresentation._FaxNumber.InternationalFaxNumber end end end as abap.char(31)) as FaxNumber AS char31asFaxNumber,
  case when Document.Supplier is not initial then case Document._Supplier.IsOneTimeAccount when 'X' then case when Document._Supplier._AddressDefaultRepresentation._EmailAddress.EmailAddress is not initial and Document._Supplier._AddressDefaultRepresentation._EmailAddress.EmailAddress is not null then Document._Supplier._AddressDefaultRepresentation._EmailAddress.EmailAddress when _Address._EmailAddress.EmailAddress is not initial and _Address._EmailAddress.EmailAddress is not null then _Address._EmailAddress.EmailAddress else 'Desconhecido' end else Document._Supplier._AddressDefaultRepresentation._EmailAddress.EmailAddress end else case Document._Customer.IsOneTimeAccount when 'X' then case when Document._Customer._AddressDefaultRepresentation._EmailAddress.EmailAddress is not initial and Document._Customer._AddressDefaultRepresentation._EmailAddress.EmailAddress is not null then Document._Customer._AddressDefaultRepresentation._EmailAddress.EmailAddress when _Address._EmailAddress.EmailAddress is not initial and _Address._EmailAddress.EmailAddress is not null then _Address._EmailAddress.EmailAddress else 'Desconhecido' end else case when _CustHist.EmailAddress is not initial then _CustHist.EmailAddress else Document._Customer._AddressDefaultRepresentation._EmailAddress.EmailAddress end end end as EmailAddress AS EmailAddressendendendasEmailAddress,
  case when Document.Supplier is not initial then '' else case Document._Customer.IsOneTimeAccount when 'X' then ' ' else case when _CustHist.SearchURLAddress is not initial then _CustHist.SearchURLAddress end end end as WebsiteURL AS SearchURLAddressendendendasWebsiteURL,
  Document._CompanyCode AS _CompanyCode,
  Document._FiscalYear AS _FiscalYear
LEFT OUTER JOIN I_Address_2 AS _Address ON Document.AddressID = _Address.AddressID  -- association [0..1]
;