C_PT_SAFTGeneralLedgerBPC

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_SAFTGeneralLedgerBPC.
-- 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.
-- Parameters: P_StartDate : dats, P_EndDate : dats

CREATE VIEW C_PT_SAFTGeneralLedgerBPC AS
SELECT
  Doc.CompanyCode AS CompanyCode,
  Doc.FiscalYear AS FiscalYear,
  cast(case when Doc.Customer is not initial then '0001' when Doc.Supplier is not initial then '0002' else '0000' end as abap.char(4)) as BusinessPartnerType AS char4asBusinessPartnerType,
  cast( case when Doc.Supplier is not initial then case when Doc.DelivOfGoodsDestCountry is not initial then case when Doc.DelivOfGoodsDestCountry != Doc.Country then concat(Doc.Supplier,concat('/',Doc.DelivOfGoodsDestCountry)) else Doc.Supplier end else Doc.Supplier end end as abap.char(32) ) as SupplierToPartner AS char32asSupplierToPartner,
  SupplierToPartner,
  Doc.BusinessPartnerCustomer AS BusinessPartnerCustomer
FROM I_PT_SAFTGenLedgerOneTimeBP AS Doc
INNER JOIN I_PT_SAFTGenericSettings AS GenSet ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_PT_SAFTGenLedgerOneTimeBP
;