I_SPECVALASSGMTITEMFORKEYDATE

CDS View

Specification Value Assignment Item for Key Date

I_SPECVALASSGMTITEMFORKEYDATE is a CDS View in S/4HANA. Specification Value Assignment Item for Key Date. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SpecValAssgmtInstanceWthComp view inner COMPOSITE Specification Value Assignment Instance with Composition 
@AbapCatalog.sqlViewName: 'ISPECVAITMKDATE'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

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


@EndUserText.label: 'Specification Value Assignment Item for Key Date'
define view I_SpecValAssgmtItemForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : /plmb/rcp_key_date
  as select from I_SpecValAssgmtItem
  association [0..1] to I_SpecificationForKeyDate as _SpecificationForKeyDate on $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID
  association [0..1] to I_SpecificationForKeyDate as _ComponentSpecForKeyDate on $projection.ComponentSpecificationIntID = _ComponentSpecForKeyDate.SpecificationInternalID
{
  key SpecValAssgmtItem,
  key SpecValAssgmtItemChangeState,
      SpecValAssgmtItemValdtyStrtDte,
      SpecValAssgmtItemValdtyEndDte,
      SpecValAssgmtItemIsDeleted,
      SpecificationInternalID,
      SpecValAssgmt,
      ComponentSpecificationIntID,
      CompSpecComponentType,
      CompSpecLowerLimitOperator,
      CompSpecLowerLimit,
      CompSpecUpperLimitOperator,
      CompSpecUpperLimit,
      CompSpecQuantity,
      CompSpecUnit,
      CompSpecSortSequence,
      CompSpecDecimalQuantity,
      CompSpecExceptionCode,

      // For auth. check

      //_SpecificationForKeyDate( P_KeyDate: $parameters.P_KeyDate ).SpecificationAuthznGroup                             as SpecificationAuthznGroup,

      //_SpecificationForKeyDate( P_KeyDate: $parameters.P_KeyDate ).SpecificationType                                    as SpecificationType,


      /* Associations */
      _SpecificationForKeyDate,
      _ComponentSpecForKeyDate

}
where
      SpecValAssgmtItemValdtyStrtDte <= $parameters.P_KeyDate
  and SpecValAssgmtItemValdtyEndDte  >= $parameters.P_KeyDate

Learn More