I_ShipmentBlockReasonText

DDL: I_SHIPMENTBLOCKREASONTEXT SQL: ILESHIPMBLKRSNT Type: view BASIC Package: VDM_LE_TRA

Shipment Block Reason Text

I_ShipmentBlockReasonText is a Basic CDS View that provides data about "Shipment Block Reason Text" in SAP S/4HANA. It reads from 1 data source (ttsgt) and exposes 5 fields with key fields ShipmentBlockReason, Language. Part of development package VDM_LE_TRA.

Data Sources (1)

SourceAliasJoin Type
ttsgt ttsgt from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ShipmentBlockReason view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Shipment Block Reason Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ILESHIPMBLKRSNT view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 2 view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ShipmentBlockReason trspg
KEY Language spras
ShipmentBlockReasonText bezei
_ShipmentBlockReason _ShipmentBlockReason
_Language _Language

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'ShipmentBlockReason'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #S 
@EndUserText.label: 'Shipment Block Reason Text'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ILESHIPMBLKRSNT'
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #GENERIC
@AbapCatalog.buffering.numberOfKeyFields: 2   

define view I_ShipmentBlockReasonText
as select from 
ttsgt
association[0..1] to I_ShipmentBlockReason as _ShipmentBlockReason on $projection.ShipmentBlockReason = _ShipmentBlockReason.ShipmentBlockReason
association[0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_ShipmentBlockReason'
    key trspg as ShipmentBlockReason,

    @Semantics.language
    @ObjectModel.foreignKey.association: '_Language'
    key spras as Language,

    @Semantics.text
    bezei as ShipmentBlockReasonText,
    
     _ShipmentBlockReason,
     _Language
};