I_SPECIDFRBSCFORKEYDATE

CDS View

Specification Basic Identifier by Appl for Key Date

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

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ChgRecdSpecIdfrForCurDate view from CONSUMPTION Specification Identifier for Current Date 
@AbapCatalog.sqlViewName: 'ISPCIDFRBSC'
@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_SpecIdfrBscForKeyDate
  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        = 'SPC'        
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SPECIDFRBSCBYAPPFORKEYDATE"
],
"ASSOCIATED":
[
"I_SPECIFICATIONFORKEYDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More