P_RO_SAFTPaymnetItemNew

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_SAFTPaymnetItemNew.
-- 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: PROSAFTPAYITEMN
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW P_RO_SAFTPaymnetItemNew 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.Customer AS Customer,
  Item.Supplier AS Supplier,
  Item.DebitCreditCode AS DebitCreditCode,
  coalesce(PayMapNoGL.DebitCreditCodeIsChanged, PayMapGL.DebitCreditCodeIsChanged) AS DebitCreditCodeIsChanged,
  Item.TaxCode AS TaxCode,
  Item.TaxCountry AS TaxCountry,
  Item.ActiveChartOfAccounts AS ActiveChartOfAccounts,
  Item.ActiveGLAccount AS ActiveGLAccount,
  Item.GLAccount AS GLAccount,
  Item.ChartOfAccounts AS ChartOfAccounts,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.CountryChartOfAccounts AS CountryChartOfAccounts,
  Item.GLAccountType AS GLAccountType,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item.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.Segment AS Segment,
  Item.CostCenter AS CostCenter,
  Item.OrderID AS OrderID,
  Item._Order AS _Order,
  Item.WBSElement AS WBSElement,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  '' AS TaxType,
  Item.RO_SAFTStandardAccount AS RO_SAFTStandardAccount,
  Item.LogicalSystem AS LogicalSystem,
  case 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.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,
  PaymentMethod.RO_SAFTPaymentMethod AS RO_SAFTPaymentMethod,
  Item._JournalEntry.FiscalPeriod AS FiscalPeriod,
  Item._JournalEntry.TaxReportingDate AS TaxReportingDate
FROM I_StRpJournalEntryHeaderLog AS Log
INNER JOIN P_RO_SAFTJournalEntryItemExc ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationalAcctgDocItem AS Bseg ON /* join condition not captured in parsed metadata */
INNER JOIN I_RO_SAFTPaymentMethod AS PaymentMethod ON /* join condition not captured in parsed metadata */
;