I_LabelSet

DDL: I_LABELSET SQL: ILBLSET Type: view BASIC Package: VDM_PLMB_LBL

Time-Independent Header Data of Label Set

I_LabelSet is a Basic CDS View that provides data about "Time-Independent Header Data of Label Set" in SAP S/4HANA. It reads from 1 data source (rmsla_hd) and exposes 11 fields with key field LabelSetInternalID. It has 3 associations to related views. Part of development package VDM_PLMB_LBL.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
rmsla_hd rmsla_hd from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_LabelSetText _LabelSetText $projection.LabelSetInternalID = _LabelSetText.LabelSetInternalID
[0..1] I_User _CreatedByUser $projection.LabelSetCreatedByUser = _CreatedByUser.UserID
[0..1] I_User _LastChangedByUser $projection.LabelSetLastChangedByUser = _LastChangedByUser.UserID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILBLSET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey LabelSetInternalID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
EndUserText.label Time-Independent Header Data of Label Set view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY LabelSetInternalID rmsla_hd labelid
LabelSetSpecificationIntID rmsla_hd specification
LabelSetAlternativeNumber rmsla_hd alt_no
LabelSetVersionNumber rmsla_hd vers_no
LabelSetCreatedByUser rmsla_hd creaby
LabelSetCreationDate rmsla_hd creadat
LabelSetLastChangedByUser rmsla_hd chngby
LabelSetLastChangeDate rmsla_hd chngdat
_LabelSetText _LabelSetText
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser 
@AbapCatalog.sqlViewName: 'ILBLSET'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'LabelSetInternalID'
@ObjectModel.semanticKey: [ 'LabelSetInternalID' ]
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC

@EndUserText.label: 'Time-Independent Header Data of Label Set'
define view I_LabelSet
  as select from rmsla_hd

  // Texts

  association [0..*] to I_LabelSetText as _LabelSetText      on $projection.LabelSetInternalID = _LabelSetText.LabelSetInternalID

  // Administrative data

  association [0..1] to I_User         as _CreatedByUser     on $projection.LabelSetCreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User         as _LastChangedByUser on $projection.LabelSetLastChangedByUser = _LastChangedByUser.UserID

{
      // Internal key

  key rmsla_hd.labelid       as LabelSetInternalID,

      rmsla_hd.specification as LabelSetSpecificationIntID,
      rmsla_hd.alt_no        as LabelSetAlternativeNumber,
      rmsla_hd.vers_no       as LabelSetVersionNumber,

      // Administrative data

      //@ObjectModel.foreignKey.association: '_CreatedByUser'

      rmsla_hd.creaby        as LabelSetCreatedByUser,

      rmsla_hd.creadat       as LabelSetCreationDate,

      //@ObjectModel.foreignKey.association: '_LastChangedByUser'

      rmsla_hd.chngby        as LabelSetLastChangedByUser,

      rmsla_hd.chngdat       as LabelSetLastChangeDate,

      /* Associations */
      _LabelSetText,
      _CreatedByUser,
      _LastChangedByUser
}
where
      alt_no  is not initial
  and vers_no is not initial

Learn More