P_ARBankStatementItmUpload

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_ARBankStatementItmUpload.
-- 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: PBANKSTMNTITUP

CREATE VIEW P_ARBankStatementItmUpload AS
SELECT
  cast ( '' as far_vgman ) AS PaymentManualTransacType,
  cast ( '' as farp_vgext ) AS PaymentExternalTransacType,
  cast ( '' as farp_valut ) AS ValueDate,
  cast ( 00 as kwbtr_eb ) AS AmountInTransactionCurrency,
  cast ( '' as waers ) AS TransactionCurrency,
  cast ( '' as far_memo_line ) AS MemoLine,
  cast ( '' as farp_chect ) AS Cheque,
  cast ( '' as far_chect ) AS PaymentMediumReference,
  cast ( '' as far_chect_orig ) AS CustomerReferenceNumber,
  cast ( '' as farp_vgref ) AS BankReference,
  cast ( 00 as farp_fwbtr ) AS AmountInOriginalCurrency,
  cast ( '' as farp_fwaer ) AS OriginalCurrency,
  cast ( '' as farp_partn ) AS BusinessPartnerName,
  cast ( '' as farp_pablz ) AS PartnerBank,
  cast ( '' as farp_pabks ) AS PartnerBankCountry,
  cast( '' as piban_eb ) AS PartnerBankIBAN,
  cast ( '' as paswi_eb) AS PartnerBankSWIFTCode,
  cast ( '' as farp_pakto ) AS PartnerBankAccount,
  cast ( '' as kunnr ) AS Customer,
  cast ( '' as lifnr ) AS Supplier,
  cast ( '' as farp_hkont ) AS GLAccount,
  cast ( '' as far_sgtxt) AS DocumentItemText,
  cast ( '' as farp_zuonr) AS AssignmentReference,
  cast ( '' as farp_kidno) AS PaymentReference,
  cast ( '' as farp_kostl) AS CostCenter
FROM fins_bal_dummy
;