C_ARBankStatementItmUpload

DDL: C_ARBANKSTATEMENTITMUPLOAD SQL: CBANKSTMNTITUP Type: view CONSUMPTION

Consumption CDS for Excel Upload Template Generation MBS

C_ARBankStatementItmUpload is a Consumption CDS View that provides data about "Consumption CDS for Excel Upload Template Generation MBS" in SAP S/4HANA. It reads from 1 data source (I_ARBankStatementItemTP) and exposes 26 fields.

Data Sources (1)

SourceAliasJoin Type
I_ARBankStatementItemTP I_ARBankStatementItemTP from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CBANKSTMNTITUP view
EndUserText.label Consumption CDS for Excel Upload Template Generation MBS view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (26)

KeyFieldSource TableSource FieldDescription
PaymentManualTransacType PaymentManualTransacType
PaymentExternalTransacType PaymentExternalTransacType
ValueDate ValueDate Value Date
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
MemoLine MemoLine Memo Line
Cheque Cheque Cheque No
PaymentMediumReference PaymentMediumReference
CustomerReferenceNumber CustomerReferenceNumber
BankReference BankReference Payment Reference
AmountInOriginalCurrency AmountInOriginalCurrency
OriginalCurrency OriginalCurrency
BusinessPartnerName BusinessPartnerName Extracted Customer Name
PartnerBank PartnerBank
PartnerBankCountry PartnerBankCountry Part. Ctry/Rgn
PartnerBankIBAN PartnerBankIBAN
PartnerBankSWIFTCode PartnerBankSWIFTCode Partner SWIFT
PartnerBankAccount PartnerBankAccount
Customer
Supplier
GLAccount
DocumentItemText DocumentItemText Text
AssignmentReference AssignmentReference Assignment Reference
PaymentReference PaymentReference Payment Reference
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center

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_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: CBANKSTMNTITUP

CREATE VIEW C_ARBankStatementItmUpload AS
SELECT
  PaymentManualTransacType,
  PaymentExternalTransacType,
  ValueDate,
  AmountInTransactionCurrency,
  TransactionCurrency,
  MemoLine,
  Cheque,
  PaymentMediumReference,
  CustomerReferenceNumber,
  BankReference,
  AmountInOriginalCurrency,
  OriginalCurrency,
  BusinessPartnerName,
  PartnerBank,
  PartnerBankCountry,
  PartnerBankIBAN,
  PartnerBankSWIFTCode,
  PartnerBankAccount,
  cast ( '' as kunnr ) AS Customer,
  cast ( '' as lifnr ) AS Supplier,
  cast ( '' as farp_hkont ) AS GLAccount,
  DocumentItemText,
  AssignmentReference,
  PaymentReference,
  ProfitCenter,
  CostCenter
FROM I_ARBankStatementItemTP
;