I_LabelSetIdfrBscForKeyDate

DDL: I_LABELSETIDFRBSCFORKEYDATE SQL: ILBLSPCIDFRBSC Type: view COMPOSITE

Label Set Spec Basic Identifier by Appl for Key Date

I_LabelSetIdfrBscForKeyDate is a Composite CDS View that provides data about "Label Set Spec Basic Identifier by Appl for Key Date" in SAP S/4HANA. It reads from 1 data source (I_SpecIdfrBscByAppForKeyDate) and exposes 3 fields with key field SpecificationInternalID. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_SpecIdfrBscByAppForKeyDate I_SpecIdfrBscByAppForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SpecificationForKeyDate _SpecificationForKeyDate $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ILBLSPCIDFRBSC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE 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 Spec Basic Identifier by Appl for Key Date view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SpecificationInternalID idfr SpecificationInternalID
SpecIdfgDescText idfr SpecIdfgDescText
_SpecificationForKeyDate _SpecificationForKeyDate 
@AbapCatalog.sqlViewName: 'ILBLSPCIDFRBSC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@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 Spec Basic Identifier by Appl for Key Date'
define view I_LabelSetIdfrBscForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_SpecIdfrBscByAppForKeyDate(P_KeyDate : $parameters.P_KeyDate) as idfr
  association [0..1] to I_SpecificationForKeyDate as _SpecificationForKeyDate on $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID

{
  key idfr.SpecificationInternalID,
      idfr.SpecIdfgDescText,
      _SpecificationForKeyDate
}
where
      idfr.SpecificationIdnListingScreen = ''
  and SpecificationIdnListingAppl        = 'LBL'        
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SPECIDFRBSCBYAPPFORKEYDATE"
],
"ASSOCIATED":
[
"I_SPECIFICATIONFORKEYDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More