I_SPECIDFRBSCBYAPPFORKEYDATE

CDS View

Specification Basic Identifier by Appl. for Key Date

I_SPECIDFRBSCBYAPPFORKEYDATE is a CDS View in S/4HANA. Specification Basic Identifier by Appl. for Key Date. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LabelSetIdfrBscForKeyDate view from COMPOSITE Label Set Spec Basic Identifier by Appl for Key Date
I_SpecIdfrBscForKeyDate view from COMPOSITE Specification Basic Identifier by Appl for Key Date 
@AbapCatalog.sqlViewName: 'IFRCPIDFRSCR'
@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: 'Specification Basic Identifier by Appl. for Key Date'
define view I_SpecIdfrBscByAppForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from P_SpecIdfrBscByAppScore2( P_KeyDate : $parameters.P_KeyDate )   as idfr
    inner join   P_SpecIdfrBscByAppScoreMax( P_KeyDate : $parameters.P_KeyDate ) as maxx on  idfr.SpecificationInternalID       = maxx.SpecificationInternalID
                                                                                         and idfr.Score                         = maxx.MaxScore
                                                                                         and idfr.SpecificationIdnListingAppl   = maxx.SpecificationIdnListingAppl
                                                                                         and idfr.SpecificationIdnListingScreen = maxx.SpecificationIdnListingScreen
  association [0..1] to I_SpecificationForKeyDate as _SpecificationForKeyDate on $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID

{
  key idfr.SpecificationInternalID,
  key idfr.SpecificationIdnListingAppl,
  key idfr.SpecificationIdnListingScreen,
      idfr.SpecIdfgDescInternalID,

      SpecIdfgDescValidityStartDate,
      SpecIdfgDescValidityEndDate,

      idfr.SpecIdfgDescCategory,
      idfr.SpecIdfgDescType,
      SpecIdfgDescText,

      /* Associations */
      _SpecificationForKeyDate
}
where
      SpecIdfgDescValidityStartDate <= $parameters.P_KeyDate
  and SpecIdfgDescValidityEndDate   >= $parameters.P_KeyDate

Learn More