I_PT_SAFTAcctgSupTaxRegnNmbr

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_SAFTAcctgSupTaxRegnNmbr.
-- 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: IPTSAFTASUPREGN

CREATE VIEW I_PT_SAFTAcctgSupTaxRegnNmbr AS
SELECT
  a.SourceLedger AS SourceLedger,
  a.CompanyCode AS CompanyCode,
  a.FiscalYear AS FiscalYear,
  a.AccountingDocument AS AccountingDocument,
  concat(a.Supplier,concat('/', b.Country)) AS Supplier,
  a.Ledger AS Ledger,
  a.PostingDate AS DocumentDate,
  a._SourceLedger AS _SourceLedger,
  a._CompanyCode AS _CompanyCode,
  a._FiscalYear AS _FiscalYear,
  a._JournalEntry AS _JournalEntry,
  a._Ledger AS _Ledger,
  case when a.VATRegistration is initial or a.VATRegistration is null then 'Desconhecido' else a.VATRegistration end as VATRegistration AS VATRegistrationendasVATRegistration,
  a.CompanyName AS CompanyName,
  case when a.CityName is initial or a.CityName is null then 'Desconhecido' else a.CityName end as CityName AS CityNameendasCityName,
  case when a.PostalCode is initial or a.PostalCode is null then 'Desconhecido' else a.PostalCode end as PostalCode AS PostalCodeendasPostalCode,
  case when a.Country is initial or a.Country is null then 'Desconhecido' else a.Country end as Country AS CountryendasCountry,
  a._AddressRepresentation._PhoneNumber[ 1: PhNmbrIsCurrentOverallDefault = 'X' ].InternationalPhoneNumber AS PhoneNumber,
  a._AddressRepresentation._FaxNumber[ 1: FaxNumberIsCurrentDefault = 'X' ].InternationalFaxNumber AS FaxNumber,
  a._AddressRepresentation._EmailAddress[ 1: EmailAddressIsCurrentDefault = 'X' ].EmailAddress AS EmailAddress,
  ' ' AS WebsiteURL
FROM I_SAFTGeneralLedgerSupplier AS a
INNER JOIN I_SAFTSupTaxRegnNmbr AS b ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTGenericSettings AS c ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTIsAlternateAccount AS e ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountInCompanyCode AS d ON /* join condition not captured in parsed metadata */
;