FNDEI_ADR2_BLOCKINGINFO

DDL: FNDEI_ADR2_BLOCKINGINFO SQL: FNDEIBADR2 Type: view
6 Fields 3 Data Sources

Filter View for table ADR2

FNDEI_ADR2_BLOCKINGINFO is a CDS View that provides data about "Filter View for table ADR2" in SAP S/4HANA. It reads from 3 data sources (adr2, FNDEI_ADCP_BlockingInfo, FNDEI_ADRC_BLOCKINGINFO) and exposes 6 fields with key fields client, addrnumber, persnumber, date_from, consnumber.

Data Sources (3)

SourceAliasJoin Type
adr2 adr2 from
FNDEI_ADCP_BlockingInfo FNDEI_ADCP_BlockingInfo left_outer
FNDEI_ADRC_BLOCKINGINFO FNDEI_ADRC_BLOCKINGINFO left_outer

Annotations (8)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY client adr2 client Workflow definition: Client
KEY addrnumber adr2 addrnumber Address Number
KEY persnumber adr2 persnumber Person Number
KEY date_from adr2 date_from Validity Start Date
KEY consnumber adr2 consnumber Sequence Number
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_ADR2_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: FNDEIBADR2

CREATE VIEW FNDEI_ADR2_BLOCKINGINFO AS
SELECT
  adr2.client AS client,
  adr2.addrnumber AS addrnumber,
  adr2.persnumber AS persnumber,
  adr2.date_from AS date_from,
  adr2.consnumber AS consnumber,
  case when FNDEI_ADCP_BlockingInfo.NotBlocked = 'X' or FNDEI_ADRC_BLOCKINGINFO.NotBlocked = 'X' then 'X' end as NotBlockedOnTarget AS NotBlockedXthenXendasNotBlockedOnTarget
FROM adr2
LEFT OUTER JOIN FNDEI_ADCP_BlockingInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FNDEI_ADRC_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;

Learn More