C_BG_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_BG_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.
-- Parameters: P_VATRegistration : stceg, P_UserSystemIdentifier : sysid, P_AlternativeGLAccountIsUsed : saft_bg_alt_gl_account_flag

CREATE VIEW C_BG_SAFTPaymentItemC AS
SELECT
  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.DocumentDate AS DocumentDate,
  Item.TaxReportingDate AS TaxReportingDate,
  Item.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  Item.Customer AS Customer,
  case when Item.Customer is initial and Item.Supplier is initial and Item.DebitCreditCode = 'S' then cast( $parameters.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( $parameters.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,
  coalesce(PayMapNoGL.DebitCreditCodeIsChanged, PayMapGL.DebitCreditCodeIsChanged) AS DebitCreditCodeIsChanged,
  accmap.BG_SAFTStandardAccount AS BG_SAFTStandardAccount,
  Item.BG_SAFTPaymentMethod AS BG_SAFTPaymentMethod,
  Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  Item.ReportingCurrency AS ReportingCurrency,
  Item.AmountInReportingCurrency AS AmountInReportingCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.DocumentId AS DocumentId,
  Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  cast(concat( $parameters.P_UserSystemIdentifier, concat( concat( concat( '/', cast( $session.client as char3 )), '/' ) , Item.AccountingDocument ) ) as text30) AS UserSystemIdentifier
FROM P_BG_SAFTPAYMENTITEM
INNER JOIN I_BG_SAFTAccountMapping AS accmap ON /* join condition not captured in parsed metadata */
;