I_SAFTBankStatementItemRef

DDL: I_SAFTBANKSTATEMENTITEMREF SQL: ISAFTBNKSTITMRF Type: view BASIC
3 Fields 4 Data Sources

SAF-T Bank Statement Item Reference

I_SAFTBankStatementItemRef is a Basic CDS View that provides data about "SAF-T Bank Statement Item Reference" in SAP S/4HANA. It reads from 4 data sources (febre, febre, febre, febre) and exposes 3 fields with key fields BankStatementShortID, BankStatementItem.

Data Sources (4)

SourceAliasJoin Type
febre a from
febre b left_outer
febre c left_outer
febre d left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTBNKSTITMRF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T Bank Statement Item Reference view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BankStatementShortID febre kukey Statement Short Key
KEY BankStatementItem febre esnum Memo Record No.
vwezwasMemoLine

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_SAFTBankStatementItemRef.
-- 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: ISAFTBNKSTITMRF

CREATE VIEW I_SAFTBankStatementItemRef AS
SELECT
  a.kukey AS BankStatementShortID,
  a.esnum AS BankStatementItem,
  concat(coalesce(a.vwezw,''), concat(coalesce(b.vwezw,''), concat(coalesce(c.vwezw,''), coalesce(d.vwezw,'')))) as MemoLine AS vwezwasMemoLine
FROM febre AS a
LEFT OUTER JOIN febre AS b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN febre AS c ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN febre AS d ON /* join condition not captured in parsed metadata */
;

Learn More