FNDEI_LFBK_FILTER

DDL: FNDEI_LFBK_FILTER SQL: FNDEIFLFBK Type: view
11 Fields 2 Data Sources

Filter View for table LFBK

FNDEI_LFBK_FILTER is a CDS View that provides data about "Filter View for table LFBK" in SAP S/4HANA. It reads from 2 data sources (FNDEI_LFBK_BLOCKINGINFO, lfbk) and exposes 11 fields with key fields mandt, lifnr, banks, bankl, bankn.

Data Sources (2)

SourceAliasJoin Type
FNDEI_LFBK_BLOCKINGINFO FNDEI_LFBK_BLOCKINGINFO inner
lfbk lfbk from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIFLFBK view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Filter View for table LFBK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY mandt lfbk mandt Editing Client
KEY lifnr lfbk lifnr Vendor no.
KEY banks lfbk banks Bank Ctry/Rgn. Key
KEY bankl lfbk bankl House Bank
KEY bankn lfbk bankn Bank acct
bkont lfbk bkont To Account
bvtyp lfbk bvtyp Part.bank type
xezer lfbk xezer Collection Auth.
bkref lfbk bkref Reference
koinh lfbk koinh Sold-To Party
ebpp_accname lfbk ebpp_accname Account Name

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 FNDEI_LFBK_FILTER.
-- 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: FNDEIFLFBK

CREATE VIEW FNDEI_LFBK_FILTER AS
SELECT
  lfbk.mandt AS mandt,
  lfbk.lifnr AS lifnr,
  lfbk.banks AS banks,
  lfbk.bankl AS bankl,
  lfbk.bankn AS bankn,
  lfbk.bkont AS bkont,
  lfbk.bvtyp AS bvtyp,
  lfbk.xezer AS xezer,
  lfbk.bkref AS bkref,
  lfbk.koinh AS koinh,
  lfbk.ebpp_accname AS ebpp_accname
FROM lfbk
INNER JOIN FNDEI_LFBK_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;

Learn More