I_ARBankStatementItmUpload

DDL: I_ARBANKSTATEMENTITMUPLOAD Type: view_entity COMPOSITE Package: ODATA_BANKSTATEMENT
24 Fields 1 Data Sources

Interface CDS for Excel Upload Template Generation MBS

I_ARBankStatementItmUpload is a Composite CDS View that provides data about "Interface CDS for Excel Upload Template Generation MBS" in SAP S/4HANA. It reads from 1 data source (P_ARBankStatementItmUpload) and exposes 24 fields. Part of development package ODATA_BANKSTATEMENT.

Data Sources (1)

SourceAliasJoin Type
P_ARBankStatementItmUpload P_ARBankStatementItmUpload from

Annotations (5)

NameValueLevelField
EndUserText.label Interface 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 #COMPOSITE view

Fields (24)

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 Customer Sold-to Party
Supplier Supplier Supplier
GLAccount GLAccount General Ledger
DocumentItemText DocumentItemText Text
AssignmentReference AssignmentReference Assignment Reference
PaymentReference PaymentReference Payment Reference

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 I_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.

CREATE VIEW I_ARBankStatementItmUpload AS
SELECT
  PaymentManualTransacType,
  PaymentExternalTransacType,
  ValueDate,
  AmountInTransactionCurrency,
  TransactionCurrency,
  MemoLine,
  Cheque,
  PaymentMediumReference,
  CustomerReferenceNumber,
  BankReference,
  AmountInOriginalCurrency,
  OriginalCurrency,
  BusinessPartnerName,
  PartnerBank,
  PartnerBankCountry,
  PartnerBankIBAN,
  PartnerBankSWIFTCode,
  PartnerBankAccount,
  Customer,
  Supplier,
  GLAccount,
  DocumentItemText,
  AssignmentReference,
  PaymentReference
FROM P_ARBankStatementItmUpload
;

Learn More