I_ARBankStmntItmClearing

DDL: I_ARBANKSTMNTITMCLEARING SQL: IBKSTMNTITMCLRG Type: view BASIC Package: FINS_FIS_APAR_APPS
4 Fields 1 Data Sources

Clearing Data of a Bank Statement Item

I_ARBankStmntItmClearing is a Basic CDS View that provides data about "Clearing Data of a Bank Statement Item" in SAP S/4HANA. It reads from 1 data source (febcl) and exposes 4 fields. Part of development package FINS_FIS_APAR_APPS.

Data Sources (1)

SourceAliasJoin Type
febcl febcl from

Annotations (8)

NameValueLevelField
EndUserText.label Clearing Data of a Bank Statement Item view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.sqlViewName IBKSTMNTITMCLRG view

Fields (4)

KeyFieldSource TableSource FieldDescription
BankStatementShortID kukey Statement Short Key
BankStatementItem esnum Memo Record No.
AccountingDocument
FiscalYear

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_ARBankStmntItmClearing.
-- 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: IBKSTMNTITMCLRG

CREATE VIEW I_ARBankStmntItmClearing AS
SELECT
  kukey AS BankStatementShortID,
  esnum AS BankStatementItem,
  substring(selvon, 1, 10) AS AccountingDocument,
  substring(selvon, 11, 4) AS FiscalYear
FROM febcl
;

Learn More