I_PT_SAFTGenLedgerEntry

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_SAFTGenLedgerEntry.
-- 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: ISAFTPTGENLDENT

CREATE VIEW I_PT_SAFTGenLedgerEntry AS
SELECT
  a.CompanyCode AS CompanyCode,
  a.FiscalYear AS FiscalYear,
  a.AccountingDocument AS AccountingDocument,
  a.Ledger AS Ledger,
  a.AccountingDocumentType AS JournalEntryType,
  a.FiscalPeriod AS FiscalPeriod,
  a.DocumentDate AS TransactionDate,
  a.AccountingDocCreatedByUser AS CreatedByUser,
  a.PostingDate AS PostingDate,
  case when MultVatCustomer.CustomerCountry is not initial and a.DelivOfGoodsDestCountry is not initial then a.DelivOfGoodsDestCountry else MultVatCustomer.CustomerCountry end as CustomerCountry AS CustomerCountryendasCustomerCountry,
  case when MultVatSupplier.SupplierCountry is not initial and a.DelivOfGoodsDestCountry is not initial then a.DelivOfGoodsDestCountry else MultVatSupplier.SupplierCountry end as SupplierCountry AS SupplierCountryendasSupplierCountry,
  a.Customer AS Customer,
  a.Supplier AS Supplier,
  a.IsOneTimeAccount AS IsOneTimeAccount,
  a.SpecialGLCode AS SpecialGLCode
LEFT OUTER JOIN I_PT_SAFTTransactionType AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PT_SAFTTAXLAND AS MultVatCustomer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PT_SAFTTAXLANDSUP AS MultVatSupplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_SAFTGenericSettings AS _b ON _b.CompanyCode = a.CompanyCode AND _b.FiscalYearFrom <= a.FiscalYear AND _b.FiscalYearTo >= a.FiscalYear AND _b.SourceLedger = a.Ledger  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTGenLedgerCustomer AS _Customer ON _Customer.Ledger = a.Ledger AND _Customer.AccountingDocument = a.AccountingDocument AND _Customer.CompanyCode = a.CompanyCode AND _Customer.FiscalYear = a.FiscalYear AND _Customer.Customer = a.Customer  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTGenLedgerOneTimeCust AS _OneTimeAccountCustomer ON _OneTimeAccountCustomer.Ledger = a.Ledger AND _OneTimeAccountCustomer.CompanyCode = a.CompanyCode AND _OneTimeAccountCustomer.AccountingDocument = a.AccountingDocument AND _OneTimeAccountCustomer.FiscalYear = a.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTGenLdgrOneTmeSupplier AS _OneTimeAccountSupplier ON _OneTimeAccountSupplier.Ledger = a.Ledger AND _OneTimeAccountSupplier.CompanyCode = a.CompanyCode AND _OneTimeAccountSupplier.AccountingDocument = a.AccountingDocument AND _OneTimeAccountSupplier.FiscalYear = a.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTGenLedgerSupplier AS _AccountSupplier ON _AccountSupplier.Ledger = a.Ledger AND _AccountSupplier.CompanyCode = a.CompanyCode AND _AccountSupplier.AccountingDocument = a.AccountingDocument AND _AccountSupplier.FiscalYear = a.FiscalYear  -- association [0..1]
;