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

FNDEI_LFM1_BLOCKINGINFO

DDL: FNDEI_LFM1_BLOCKINGINFO SQL: FNDEIBLFM1 Type: view
4 Fields 2 Data Sources

Blocking View for table LFM1

FNDEI_LFM1_BLOCKINGINFO is a CDS View that provides data about "Blocking View for table LFM1" in SAP S/4HANA. It reads from 2 data sources (FNDEI_LFA1_BLOCKINGINFO, lfm1) and exposes 4 fields with key fields mandt, lifnr, ekorg.

Data Sources (2)

SourceAliasJoin Type
FNDEI_LFA1_BLOCKINGINFO FNDEI_LFA1_BLOCKINGINFO left_outer
lfm1 lfm1 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIBLFM1 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Blocking View for table LFM1 view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #B view
VDM.lifecycle.status #DEPRECATED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY mandt lfm1 mandt Editing Client
KEY lifnr lfm1 lifnr Vendor no.
KEY ekorg lfm1 ekorg Purchasing Org.
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_LFM1_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: FNDEIBLFM1

CREATE VIEW FNDEI_LFM1_BLOCKINGINFO AS
SELECT
  lfm1.mandt AS mandt,
  lfm1.lifnr AS lifnr,
  lfm1.ekorg AS ekorg,
  case when FNDEI_LFA1_BLOCKINGINFO.NotBlocked = 'X' then 'X' end as NotBlockedOnTarget AS NotBlockedXthenXendasNotBlockedOnTarget
FROM lfm1
LEFT OUTER JOIN FNDEI_LFA1_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;

Learn More