I_PT_SAFTOneTimeCustBillg

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_SAFTOneTimeCustBillg.
-- 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 I_PT_SAFTOneTimeCustBillg AS
SELECT
  SDDoc.BillingDocument AS BillingDocument,
  SDDoc.FiscalYear AS FiscalYear,
  SDDoc.CompanyCode AS CompanyCode,
  cast(Cust.PartnerFunction as parvw_unv) AS PartnerFunction,
  SDDoc.BillingDocumentDate AS DocumentDate,
  Sig.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  Cust.Customer AS Customer,
  Cust.PartnerIsOneTimeAccount AS IsOneTimeAccount,
  SDDoc.PayerParty AS PayerParty,
  SDDoc._PayerParty.AddressID AS AddressID,
  cast(case when SDDoc.VATRegistration is not initial or SDDoc.VATRegistration is not null then substring(SDDoc.VATRegistration,3,18) else case when Tax.TaxNumber1 is not initial then Tax.TaxNumber1 else case when Tax.TaxNumber2 is not initial then Tax.TaxNumber2 else case when Tax.TaxNumber3 is not initial then Tax.TaxNumber3 else case when Tax.TaxNumber5 is not initial then Tax.TaxNumber5 end end end end end as abap.char(20)) as CustomerVATRegistration AS char20asCustomerVATRegistration,
  case when SDDoc.VATRegistration is initial or SDDoc.VATRegistration is null then SDDoc.Country else substring(SDDoc.VATRegistration,1,2) end as Country AS VATRegistration12endasCountry,
  CustCompany.ReconciliationAccount AS ReconciliationAccount,
  SDDoc._PayerParty AS _PayerParty
FROM I_PT_BillgDocDgtlSgntr AS Sig
INNER JOIN I_BillingDocument AS SDDoc ON /* join condition not captured in parsed metadata */
INNER JOIN I_SDDocumentCompletePartners AS Cust ON /* join condition not captured in parsed metadata */
INNER JOIN I_CustomerCompany AS CustCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_SAFTIsAlternateAccount AS c ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountInCompanyCode AS f ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_BillgDocDgtlSgntr AS Sig ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_InvoiceList
;