FNDEI_ADCP_BlockingInfo

DDL: FNDEI_ADCP_BLOCKINGINFO SQL: FNDEIBADCP Type: view Package: FNDEI_VIEW_PROVISIONING_FILTER

Blocking Info View for table ADCP

FNDEI_ADCP_BlockingInfo is a CDS View that provides data about "Blocking Info View for table ADCP" in SAP S/4HANA. It reads from 1 data source (adcp) and exposes 5 fields with key fields client, addrnumber, persnumber, date_from, nation. Part of development package FNDEI_VIEW_PROVISIONING_FILTER.

Data Sources (1)

SourceAliasJoin Type
adcp adcp from

Annotations (8)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY client client
KEY addrnumber addrnumber
KEY persnumber persnumber
KEY date_from date_from
KEY nation nation
@AbapCatalog.sqlViewName: 'FNDEIBADCP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #AUTOMATED
@EndUserText.label: 'Blocking Info View for table ADCP'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
define view FNDEI_ADCP_BlockingInfo as select from adcp {
    key client,
    key addrnumber,
    key persnumber,
    key date_from,
    key nation,
    case when xpcpt = '' or xpcpt is null
      then 'X'
    end as NotBlocked,
    case when xpcpt = '' or xpcpt is null
      then 'X'
    end as NotBlockedOnTarget
     
}