I_LABELSET

CDS View

Time-Independent Header Data of Label Set

I_LABELSET is a CDS View in S/4HANA. Time-Independent Header Data of Label Set. It contains 8 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 8 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LabelSetForKeyDate view inner COMPOSITE Label Set on a Key Date
I_LabelSetVH view from COMPOSITE Label Set Value Help

Fields (8)

KeyField CDS FieldsUsed in Views
KEY LabelSetInternalID LabelSetInternalID 1
LabelSetAlternativeNumber LabelSetAlternativeNumber 1
LabelSetCreatedByUser LabelSetCreatedByUser 1
LabelSetCreationDate LabelSetCreationDate 1
LabelSetLastChangeDate LabelSetLastChangeDate 1
LabelSetLastChangedByUser LabelSetLastChangedByUser 1
LabelSetSpecificationIntID LabelSetSpecificationIntID 1
LabelSetVersionNumber LabelSetVersionNumber 1 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RMSLA_HD"
],
"ASSOCIATED":
[
"I_LABELSETTEXT",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More