Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

FNDEI_EBAN_TECH_BLOCKINGINFO

DDL: FNDEI_EBAN_TECH_BLOCKINGINFO SQL: FNDEIBEBAN_TECH Type: view

Filter View for table EBAN_TECH

FNDEI_EBAN_TECH_BLOCKINGINFO 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_BLOCKINGINFO) and exposes 4 fields with key fields mandt, banfn, bnfpo.

Data Sources (2)

SourceAliasJoin Type
eban_tech eban_tech from
FNDEI_EBAN_BLOCKINGINFO FNDEI_EBAN_BLOCKINGINFO left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIBEBAN_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
VDM.lifecycle.status #DEPRECATED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY mandt eban_tech mandt Editing Client
KEY banfn eban_tech banfn Requisition
KEY bnfpo eban_tech bnfpo Requisn. item
NotBlockedXthenXendasNotBlockedOnTarget

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_BLOCKINGINFO.
-- 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: FNDEIBEBAN_TECH

CREATE VIEW FNDEI_EBAN_TECH_BLOCKINGINFO AS
SELECT
  eban_tech.mandt AS mandt,
  eban_tech.banfn AS banfn,
  eban_tech.bnfpo AS bnfpo,
  case when FNDEI_EBAN_BLOCKINGINFO.NotBlocked = 'X' then 'X' end as NotBlockedOnTarget AS NotBlockedXthenXendasNotBlockedOnTarget
FROM eban_tech
LEFT OUTER JOIN FNDEI_EBAN_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;