C_PT_SAFTGenLedgerVATRegBP

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_SAFTGenLedgerVATRegBP.
-- 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_SAFTGenLedgerVATRegBP AS
SELECT
  Document.CompanyCode AS CompanyCode,
  Document.FiscalYear AS FiscalYear,
  Document.Customer AS Customer,
  Document.BusinessPartnerCustomer AS BusinessPartnerCustomer,
  Document.Supplier AS Supplier,
  Document.DelivOfGoodsDestCountry AS DelivOfGoodsDestCountry,
  Document.IsOneTimeAccount AS IsOneTimeAccount,
  Account.GLAccount AS ReconciliationAccount,
  cast(case when Document.Supplier is not initial then case Document._Supplier.IsOneTimeAccount when 'X' then VATReg.VATRegistration else case when Document._Supplier.VATRegistration is not initial then substring(Document._Supplier.VATRegistration ,3,18) else 'Desconhecido' end end else case Document._Customer.IsOneTimeAccount when 'X' then VATReg.VATRegistration else case when Document._Customer.VATRegistration is not initial then substring(Document._Customer.VATRegistration ,3,18) else 'Desconhecido' end end end as abap.char(20)) as VATRegistration AS char20asVATRegistration,
  Document._CompanyCode AS _CompanyCode,
  Document._FiscalYear AS _FiscalYear
INNER JOIN C_PT_SAFTAccountGenLedgerC AS Account ON /* join condition not captured in parsed metadata */
;