I_LabelSetForKeyDate

DDL: I_LABELSETFORKEYDATE SQL: ILBLSETFKD Type: view COMPOSITE

Label Set on a Key Date

I_LabelSetForKeyDate is a Composite CDS View that provides data about "Label Set on a Key Date" in SAP S/4HANA. It reads from 2 data sources (I_LabelSet, I_LabelSetDetail) and exposes 26 fields with key field LabelSetInternalID. It has 2 associations to related views.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_LabelSet header inner
I_LabelSetDetail headerDetail from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SpecificationForKeyDate _SpecificationForKeyDate $projection.LabelSetSpecificationIntID = _SpecificationForKeyDate.SpecificationInternalID
[0..*] I_LabelSetText _LabelSetText $projection.LabelSetInternalID = _LabelSetText.LabelSetInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ILBLSETFKD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey LabelSetInternalID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Label Set on a Key Date view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY LabelSetInternalID I_LabelSetDetail LabelSetInternalID
LabelSetSpecificationIntID I_LabelSet LabelSetSpecificationIntID
LabelSetSpecification
LabelSetAlternativeNumber I_LabelSet LabelSetAlternativeNumber
LabelSetVersionNumber I_LabelSet LabelSetVersionNumber
LabelSetChangeNumber I_LabelSetDetail LabelSetChangeNumber
LabelSetCreatedByUser I_LabelSet LabelSetCreatedByUser
LabelSetCreationDate I_LabelSet LabelSetCreationDate
LabelSetLastChangedByUser I_LabelSet LabelSetLastChangedByUser
LabelSetLastChangeDate I_LabelSet LabelSetLastChangeDate
LabelSetLastChangeDateTime I_LabelSetDetail LabelSetLastChangeDateTime
LabelSetDfltUsageRating I_LabelSetDetail LabelSetDfltUsageRating
LabelSetDfltUsageValidityArea I_LabelSetDetail LabelSetDfltUsageValidityArea
LabelSetSourceInternalKey
LabelSetValidityStartDate I_LabelSetDetail LabelSetValidityStartDate
LabelSetValidityEndDate I_LabelSetDetail LabelSetValidityEndDate
LabelSetStatus I_LabelSetDetail LabelSetStatus
LabelSetAuthorizationGroup I_LabelSetDetail LabelSetAuthorizationGroup
_SpecificationForKeyDate _SpecificationForKeyDate
_LabelSetText _LabelSetText
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_LabelSetStatus _LabelSetStatus
_LabelSetAuthorizationGroup _LabelSetAuthorizationGroup
_LabelSetRating _LabelSetRating
_LabelSetValidityArea _LabelSetValidityArea 
@AbapCatalog.sqlViewName: 'ILBLSETFKD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

@EndUserText.label: 'Label Set on a Key Date'
define view I_LabelSetForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_LabelSetDetail as headerDetail
    inner join   I_LabelSet       as header on headerDetail.LabelSetInternalID = header.LabelSetInternalID

  association [1..1] to I_SpecificationForKeyDate as _SpecificationForKeyDate on $projection.LabelSetSpecificationIntID = _SpecificationForKeyDate.SpecificationInternalID
  association [0..*] to I_LabelSetText            as _LabelSetText            on $projection.LabelSetInternalID = _LabelSetText.LabelSetInternalID

{
  key headerDetail.LabelSetInternalID,

      header.LabelSetSpecificationIntID,

      _SpecificationForKeyDate(P_KeyDate:$parameters.P_KeyDate).Specification     as LabelSetSpecification,

      header.LabelSetAlternativeNumber,
      header.LabelSetVersionNumber,

      // External Key

      @ObjectModel.text.association: '_LabelSetText'
      cast ( concat( _SpecificationForKeyDate(P_KeyDate:$session.system_date).Specification,
        concat('/', concat(header.LabelSetAlternativeNumber,
            concat('/', header.LabelSetVersionNumber)))) as /plmb/lbl_id_ext)     as LabelSet,

      headerDetail.LabelSetChangeNumber,

      header.LabelSetCreatedByUser,
      header.LabelSetCreationDate,

      header.LabelSetLastChangedByUser,
      header.LabelSetLastChangeDate,

      headerDetail.LabelSetLastChangeDateTime,

      headerDetail.LabelSetDfltUsageRating,
      headerDetail.LabelSetDfltUsageValidityArea,

      --headerDetail.LabelSetSourceInternalKey,
      @Semantics.businessDate.from: true
      headerDetail.LabelSetValidityStartDate,
      @Semantics.businessDate.to: true
      headerDetail.LabelSetValidityEndDate,
      headerDetail.LabelSetStatus,
      headerDetail.LabelSetAuthorizationGroup,

      /* Associations */
      _SpecificationForKeyDate,

      //Texts

      _LabelSetText,

      // Administrative

      _CreatedByUser,
      _LastChangedByUser,

      // Header attributes

      _LabelSetStatus,
      _LabelSetAuthorizationGroup,
      _LabelSetRating,
      _LabelSetValidityArea
}   
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LABELSET",
"I_LABELSETDETAIL",
"I_SPECIFICATIONFORKEYDATE"
],
"ASSOCIATED":
[
"I_LABELSETSTATUS",
"I_LABELSETTEXT",
"I_SPECAUTHORIZATIONGROUP",
"I_SPECIFICATIONFORKEYDATE",
"I_SPECRATING",
"I_SPECVALIDITYAREA",
"I_USER"
],
"BASE":
[
"I_LABELSET",
"I_LABELSETDETAIL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More