P_RO_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_RO_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.
-- SQL view name: PROSAFTJRNENITM
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW P_RO_SAFTJournalEntryItem AS
SELECT
  Log.StatryRptCategory AS StatryRptCategory,
  Log.StatryRptgEntity AS StatryRptgEntity,
  Log.StatryRptRunID AS StatryRptRunID,
  Item.SourceLedger AS SourceLedger,
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.LedgerGLLineItem AS LedgerGLLineItem,
  Item.Ledger AS Ledger,
  Item.AccountingDocumentItem AS AccountingDocumentItem,
  Item.FinancialAccountType AS FinancialAccountType,
  Item.Customer AS Customer,
  Item.Supplier AS Supplier,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.Product AS Product,
  Item.Plant AS Plant,
  Item.TaxCode AS TaxCode,
  Item.TaxCountry AS TaxCountry,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.ActiveChartOfAccounts AS ActiveChartOfAccounts,
  Item.ActiveGLAccount AS ActiveGLAccount,
  Item.GLAccount AS GLAccount,
  Item.GLAccountType AS GLAccountType,
  Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item._JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Item._JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.ValueDate AS ValueDate,
  case Item.DocumentItemText when '' then 'N.A' else Item.DocumentItemText end as DocumentItemText AS DocumentItemTextendasDocumentItemText,
  Item.BaseUnit AS BaseUnit,
  Item.ControllingArea AS ControllingArea,
  Item.ProfitCenter AS ProfitCenter,
  Item._ProfitCenterTxt AS _ProfitCenterTxt,
  Item.Segment AS Segment,
  Item._SegmentText AS _SegmentText,
  Item.CostCenter AS CostCenter,
  Item._CostCenterTxt AS _CostCenterTxt,
  Item.OrderID AS OrderID,
  Item._Order AS _Order,
  cast(Item.WBSElement as fis_wbs_no_conv) AS WBSElement,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item._WBSElementBasicDataText AS _WBSElementBasicDataText,
  Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  case when Item.FinancialAccountType <> 'D' then '0' when Item.Customer <> '' and Bseg.VATRegistration <> '' and BsegStcegCountry.IsEuropeanUnionMember = 'X' then case when BsegStcegCountry.Country = 'RO' then replace(Bseg.VATRegistration, 'RO', '00') else cast(concat('01', Bseg.VATRegistration) as bptaxnumxl) end when Item.Customer = '' or CustomerTaxType.BPTaxLongNumber = 'EXCLUDE' then '0' when CustomerTaxType.BPTaxLongNumber <> '0' then CustomerTaxType.BPTaxLongNumber else OTC.VATRegistration end as CustomerTaxID5 AS VATRegistrationendasCustomerTaxID5,
  case when Item.FinancialAccountType <> 'K' then '0' when Item.Supplier <> '' and Bseg.VATRegistration <> '' and BsegStcegCountry.IsEuropeanUnionMember = 'X' then case when BsegStcegCountry.Country = 'RO' then replace(Bseg.VATRegistration, 'RO', '00') else cast(concat('01', Bseg.VATRegistration) as bptaxnumxl) end when Item.Supplier = '' or SupplierTaxType.BPTaxLongNumber = 'EXCLUDE' then '0' when SupplierTaxType.BPTaxLongNumber <> '0' then SupplierTaxType.BPTaxLongNumber else OTS.VATRegistration end as SupplierTaxID5 AS VATRegistrationendasSupplierTaxID5,
  case when Item.Customer <> '' and Item.FinancialAccountType = 'D' then Item._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner when Item.Supplier <> '' and Item.FinancialAccountType = 'K' then Item._Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner else '' end as BusinessPartner AS BusinessPartnerelseendasBusinessPartner,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.LogicalSystem AS LogicalSystem,
  ' ' AS VATRegistration,
  ' ' AS TaxType,
  '0' AS RO_SAFTCustomerTaxType,
  '0' AS RO_SAFTSupplierTaxType,
  Item._JournalEntry AS _JournalEntry,
  Item.RO_SAFTStandardAccount AS RO_SAFTStandardAccount
FROM I_StRpJournalEntryHeaderLog AS Log
INNER JOIN P_RO_SAFTJournalEntryItemExc ON /* join condition not captured in parsed metadata */
;