C_RO_SAFTPaymentItemC

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_RO_SAFTPaymentItemC.
-- 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: CROSAFTPAYITEMC
-- Parameters: P_VATRegistration : stceg, P_UserSystemIdentifier : sysid, P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

CREATE VIEW C_RO_SAFTPaymentItemC AS
SELECT
  Item.StatryRptCategory AS StatryRptCategory,
  Item.StatryRptgEntity AS StatryRptgEntity,
  Item.StatryRptRunID AS StatryRptRunID,
  Item.SourceLedger AS SourceLedger,
  Item.CompanyCode AS CompanyCode,
  Item.AccountingDocument AS AccountingDocument,
  Item.FiscalYear AS FiscalYear,
  Item.LedgerGLLineItem AS LedgerGLLineItem,
  Item.Ledger AS Ledger,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.PostingDate AS PostingDate,
  Item.FiscalPeriod AS FiscalPeriod,
  Item.DocumentDate AS DocumentDate,
  Item.TaxReportingDate AS TaxReportingDate,
  Item.RO_SAFTJournalTransDescription AS RO_SAFTJournalTransDescription,
  Item.Customer AS Customer,
  case when Item.Customer is initial and Item.Supplier is initial and Item.DebitCreditCode = 'S' then cast( :P_VATRegistration as stceg ) else case when Item.CustomerTaxID5 = '0' and Item.SupplierTaxID5 = '0' then cast( $parameters.P_VATRegistration as stcd5 ) else Item.CustomerTaxID5 end end as CustomerTaxID5 AS CustomerTaxID5endendasCustomerTaxID5,
  Item.Supplier AS Supplier,
  case when Item.Customer is initial and Item.Supplier is initial and Item.DebitCreditCode = 'H' then cast( :P_VATRegistration as stceg ) else case when Item.CustomerTaxID5 = '0' and Item.SupplierTaxID5 = '0' then cast( $parameters.P_VATRegistration as stcd5 ) else Item.SupplierTaxID5 end end as SupplierTaxID5 AS SupplierTaxID5endendasSupplierTaxID5,
  Item.GLAccount AS GLAccount,
  Item.AlternativeGLAccount AS AlternativeGLAccount,
  Item.RO_SAFTStandardAccount AS RO_SAFTStandardAccount,
  Item.RO_SAFTPaymentMethod AS RO_SAFTPaymentMethod,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.DebitAmountInCoCodeCrcy AS DebitAmountInCoCodeCrcy,
  Item.CreditAmountInCoCodeCrcy AS CreditAmountInCoCodeCrcy,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.DebitAmountInTransCrcy AS DebitAmountInTransCrcy,
  Item.CreditAmountInTransCrcy AS CreditAmountInTransCrcy,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.TaxCode AS TaxCode,
  cast(Item.TaxType as mwart) AS TaxType,
  Item.RO_SAFTJournalTransaction AS RO_SAFTJournalTransaction,
  Item.DocumentItemText AS DocumentItemText,
  Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  cast(concat( $parameters.P_UserSystemIdentifier, concat( concat( concat( '/', cast( $session.client as char3 )), '/' ) , Item.AccountingDocument ) ) as text18) AS RO_SAFTSystemID
FROM P_RO_SAFTPaymnetItemNew
INNER JOIN I_JournalEntry AS Bkpf ON /* join condition not captured in parsed metadata */
;