P_BG_SAFTJournalEntryItem

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 P_BG_SAFTJournalEntryItem.
-- 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_AlternativeGLAccountIsUsed : saft_bg_alt_gl_account_flag

CREATE VIEW P_BG_SAFTJournalEntryItem AS
SELECT
  Acdoca.SourceLedger AS SourceLedger,
  Acdoca.CompanyCode AS CompanyCode,
  Acdoca.FiscalYear AS FiscalYear,
  Acdoca.AccountingDocument AS AccountingDocument,
  Acdoca.LedgerGLLineItem AS LedgerGLLineItem,
  Acdoca.Ledger AS Ledger,
  Acdoca.AccountingDocumentItem AS AccountingDocumentItem,
  Acdoca.FinancialAccountType AS FinancialAccountType,
  Acdoca.Customer AS Customer,
  Acdoca.Supplier AS Supplier,
  Acdoca.DebitCreditCode AS DebitCreditCode,
  Acdoca.Product AS Product,
  Acdoca.Plant AS Plant,
  Acdoca.TaxCode AS TaxCode,
  Acdoca.TaxCountry AS TaxCountry,
  cast(case when $parameters.P_AlternativeGLAccountIsUsed = 'X' then Acdoca.AlternativeGLAccount else Acdoca.GLAccount end as saknr) as ActiveGLAccount AS GLAccountendassaknrasActiveGLAccount,
  Acdoca.PostingDate AS PostingDate,
  Acdoca.DocumentDate AS DocumentDate,
  Bkpf.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Bkpf.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  Acdoca.AccountingDocumentType AS AccountingDocumentType,
  Acdoca.ValueDate AS ValueDate,
  case Acdoca.DocumentItemText when '' then 'N.A' else Acdoca.DocumentItemText end as DocumentItemText AS DocumentItemTextendasDocumentItemText,
  Acdoca.BaseUnit AS BaseUnit,
  Acdoca.ControllingArea AS ControllingArea,
  Acdoca.ProfitCenter AS ProfitCenter,
  Acdoca._ProfitCenterTxt AS _ProfitCenterTxt,
  Acdoca.Segment AS Segment,
  Acdoca._SegmentText AS _SegmentText,
  Acdoca.CostCenter AS CostCenter,
  Acdoca._CostCenterTxt AS _CostCenterTxt,
  Acdoca.OrderID AS OrderID,
  Acdoca._Order AS _Order,
  cast(Acdoca.WBSElement as fis_wbs_no_conv) AS WBSElement,
  Acdoca.WBSElementInternalID AS WBSElementInternalID,
  Acdoca._WBSElementBasicDataText AS _WBSElementBasicDataText,
  Acdoca.TransactionTypeDetermination AS TransactionTypeDetermination,
  case when Acdoca.FinancialAccountType <> 'D' then '0' when Acdoca.Customer <> '' and Bseg.VATRegistration <> '' and BsegStcegCountry.IsEuropeanUnionMember = 'X' then case when BsegStcegCountry.Country = 'BG' then replace(Bseg.VATRegistration, 'BG', '10') else cast(concat('11', Bseg.VATRegistration) as bptaxnumxl) end when Acdoca.Customer = '' or CustomerTaxType.BPTaxLongNumber = 'EXCLUDE' then '0' when CustomerTaxType.BPTaxLongNumber <> '0' then CustomerTaxType.BPTaxLongNumber else OTC.VATRegistration end as CustomerTaxID5 AS VATRegistrationendasCustomerTaxID5,
  case when Acdoca.FinancialAccountType <> 'K' then '0' when Acdoca.Supplier <> '' and Bseg.VATRegistration <> '' and BsegStcegCountry.IsEuropeanUnionMember = 'X' then case when BsegStcegCountry.Country = 'BG' then replace(Bseg.VATRegistration, 'BG', '10') else cast(concat('11', Bseg.VATRegistration) as bptaxnumxl) end when Acdoca.Supplier = '' or SupplierTaxType.BPTaxLongNumber = 'EXCLUDE' then '0' when SupplierTaxType.BPTaxLongNumber <> '0' then SupplierTaxType.BPTaxLongNumber else OTS.VATRegistration end as SupplierTaxID5 AS VATRegistrationendasSupplierTaxID5,
  cast ('EUR' as fis_hwaer ) AS ReportingCurrency,
  currency_conversion(amount => Acdoca.AmountInCompanyCodeCurrency, source_currency => Acdoca.CompanyCodeCurrency, target_currency =>ReportingCurrency, exchange_rate_date => Acdoca.PostingDate) as AmountInReportingCurrency AS PostingDateasAmountInReportingCurrency,
  Acdoca.TransactionCurrency AS TransactionCurrency,
  Acdoca.LogicalSystem AS LogicalSystem,
  Bkpf.TransactionCode AS TransactionCode
FROM I_JournalEntryItem AS Acdoca
INNER JOIN I_JournalEntry AS Bkpf ON /* join condition not captured in parsed metadata */
;