I_OverallDeliveryBlockStatusT

DDL: I_OVERALLDELIVERYBLOCKSTATUST SQL: ISDOVRLDVBLKSTST Type: view BASIC Package: VDM_SD_SLS_GF

Overall Delivery Block Status - Text

I_OverallDeliveryBlockStatusT is a Basic CDS View that provides data about "Overall Delivery Block Status - Text" in SAP S/4HANA. It reads from 1 data source (tvbst) and exposes 5 fields with key fields OverallDeliveryBlockStatus, Language. It has 2 associations to related views. Part of development package VDM_SD_SLS_GF.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
tvbst tvbst from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_OverallDeliveryBlockStatus _OverallDeliveryBlockStatus $projection.OverallDeliveryBlockStatus = _OverallDeliveryBlockStatus.OverallDeliveryBlockStatus
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey OverallDeliveryBlockStatus view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Overall Delivery Block Status - Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDOVRLDVBLKSTST view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Analytics.dataExtraction.enabled true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY OverallDeliveryBlockStatus statu
KEY Language spras
OverallDelivBlockStatusDesc bezei
_OverallDeliveryBlockStatus _OverallDeliveryBlockStatus
_Language _Language 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'OverallDeliveryBlockStatus'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.supportedCapabilities: [ #LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #SEARCHABLE_ENTITY, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #LANGUAGE_DEPENDENT_TEXT ]
@EndUserText.label: 'Overall Delivery Block Status - Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ISDOVRLDVBLKSTST'
@Metadata.ignorePropagatedAnnotations:true
@Search.searchable: true
@Analytics.dataExtraction.enabled: true

define view I_OverallDeliveryBlockStatusT
as select from tvbst

association [0..1] to I_OverallDeliveryBlockStatus as _OverallDeliveryBlockStatus on $projection.OverallDeliveryBlockStatus = _OverallDeliveryBlockStatus.OverallDeliveryBlockStatus
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_OverallDeliveryBlockStatus'
    key statu as OverallDeliveryBlockStatus,
    @Semantics.language: true
    @ObjectModel.foreignKey.association: '_Language'
    key spras as Language,
    
    @Semantics.text: true
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.9
    @Search.ranking: #LOW      
    bezei as OverallDelivBlockStatusDesc,
    
    _OverallDeliveryBlockStatus,
    _Language
}
where (tvbst.tbnam = 'VBAK') and (tvbst.fdnam = 'LSSTK')
  and ((tvbst.statu = '') or (tvbst.statu = 'B') or (tvbst.statu = 'C'));

Learn More