I_LoadingPointText

DDL: I_LOADINGPOINTTEXT SQL: ILELOADINGPOINTT Type: view BASIC

Loading Point - Text

I_LoadingPointText is a Basic CDS View that provides data about "Loading Point - Text" in SAP S/4HANA. It reads from 1 data source (tvlat) and exposes 7 fields with key fields ShippingPoint, LoadingPoint, Language. It has 3 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
tvlat tvlat from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_LoadingPoint _LoadingPoint $projection.ShippingPoint = _LoadingPoint.ShippingPoint and $projection.LoadingPoint = _LoadingPoint.LoadingPoint
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] I_ShippingPoint _ShippingPoint $projection.ShippingPoint = _ShippingPoint.ShippingPoint

Annotations (12)

NameValueLevelField
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey LoadingPoint view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Loading Point - Text view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ILELOADINGPOINTT view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ShippingPoint vstel
KEY LoadingPoint lstel
KEY Language spras
LoadingPointName vtext
_LoadingPoint _LoadingPoint
_Language _Language
_ShippingPoint _ShippingPoint 
@Analytics.dataExtraction.enabled: true //Inserted by VDM CDS Suite Plugin

@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'LoadingPoint'
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #S
//Commented by VDM CDS Suite Plugin:@ObjectModel.representativeKey: 'LoadingPoint'

//Commented by VDM CDS Suite Plugin:@ObjectModel.dataCategory: #TEXT

@EndUserText.label: 'Loading Point - Text'
//Commented by VDM CDS Suite Plugin:@Analytics: { dataCategory: #TEXT, dataExtraction.enabled: true }

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#CHECK
@AbapCatalog.sqlViewName: 'ILELOADINGPOINTT'
@Metadata.ignorePropagatedAnnotations:true 
@ObjectModel.supportedCapabilities: [ #LANGUAGE_DEPENDENT_TEXT, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: [ #LANGUAGE_DEPENDENT_TEXT ]

define view I_LoadingPointText
as select from 
tvlat
association [0..1] to I_LoadingPoint as _LoadingPoint on $projection.ShippingPoint = _LoadingPoint.ShippingPoint and $projection.LoadingPoint = _LoadingPoint.LoadingPoint
association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
association [0..1] to I_ShippingPoint as _ShippingPoint on $projection.ShippingPoint = _ShippingPoint.ShippingPoint 
{
    @ObjectModel.foreignKey.association: '_ShippingPoint' 
    key vstel as ShippingPoint,
    @ObjectModel.foreignKey.association: '_LoadingPoint'
    key lstel as LoadingPoint,
        
    @Semantics.language
    @ObjectModel.foreignKey.association: '_Language'
    key spras as Language,

    @Semantics.text: true
    vtext as LoadingPointName,
    
    _LoadingPoint,
    _Language,
    
    _ShippingPoint
};      
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVLAT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_LOADINGPOINT",
"I_SHIPPINGPOINT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More