FNDEI_EBAN_TECH_FILTER

DDL: FNDEI_EBAN_TECH_FILTER SQL: FNDEIFEBAN_TECH Type: view

Filter View for table EBAN_TECH

FNDEI_EBAN_TECH_FILTER is a CDS View that provides data about "Filter View for table EBAN_TECH" in SAP S/4HANA. It reads from 2 data sources (eban_tech, FNDEI_EBAN_TECH_BLOCKINGINFO) and exposes 13 fields with key fields mandt, banfn, bnfpo.

Data Sources (2)

SourceAliasJoin Type
eban_tech eban_tech from
FNDEI_EBAN_TECH_BLOCKINGINFO FNDEI_EBAN_TECH_BLOCKINGINFO inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIFEBAN_TECH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Filter View for table EBAN_TECH view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY mandt eban_tech mandt Editing Client
KEY banfn eban_tech banfn Requisition
KEY bnfpo eban_tech bnfpo Requisn. item
proc_status eban_tech proc_status Work Item ID
proc_date eban_tech proc_date Timestamp
activity eban_tech activity VAT Activity
ext_doc_item eban_tech ext_doc_item External Item
ext_doc_type eban_tech ext_doc_type External Doc. Type
create_ind eban_tech create_ind Creation ind.
state eban_tech state Vehicle Region
sc_object_id eban_tech sc_object_id Object ID
sc_itm_no eban_tech sc_itm_no Int. SC Itm No.
ext_rel_date eban_tech ext_rel_date Time Ext. Release

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_EBAN_TECH_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: FNDEIFEBAN_TECH

CREATE VIEW FNDEI_EBAN_TECH_FILTER AS
SELECT
  eban_tech.mandt AS mandt,
  eban_tech.banfn AS banfn,
  eban_tech.bnfpo AS bnfpo,
  eban_tech.proc_status AS proc_status,
  eban_tech.proc_date AS proc_date,
  eban_tech.activity AS activity,
  eban_tech.ext_doc_item AS ext_doc_item,
  eban_tech.ext_doc_type AS ext_doc_type,
  eban_tech.create_ind AS create_ind,
  eban_tech.state AS state,
  eban_tech.sc_object_id AS sc_object_id,
  eban_tech.sc_itm_no AS sc_itm_no,
  eban_tech.ext_rel_date AS ext_rel_date
FROM eban_tech
INNER JOIN FNDEI_EBAN_TECH_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;