I_SpecIdentifierForKeyDate

DDL: I_SPECIDENTIFIERFORKEYDATE SQL: ISPECIDFR_KD Type: view COMPOSITE Package: VDM_PLMB_SPC_BAS

Specification on a Key Date

I_SpecIdentifierForKeyDate is a Composite CDS View that provides data about "Specification on a Key Date" in SAP S/4HANA. It reads from 1 data source (I_SpecIdentifier) and exposes 30 fields with key fields SpecIdfgDescInternalID, SpecIdfgDescChangeState. It has 1 association to related views. Part of development package VDM_PLMB_SPC_BAS.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_SpecIdentifier I_SpecIdentifier from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

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

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ISPECIDFR_KD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Specification on a Key Date view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SpecIdfgDescInternalID SpecIdfgDescInternalID
KEY SpecIdfgDescChangeState SpecIdfgDescChangeState
SpecificationInternalID SpecificationInternalID
SpecIdfgDescValidityStartDate SpecIdfgDescValidityStartDate
SpecIdfgDescValidityEndDate SpecIdfgDescValidityEndDate
SpecIdfgDescChangeNumber SpecIdfgDescChangeNumber
SpecIdfgDescIsDeleted SpecIdfgDescIsDeleted
SpecIdfgDescCreatedByUser SpecIdfgDescCreatedByUser
SpecIdfgDescCreationDate SpecIdfgDescCreationDate
SpecIdfgDescLastChangedByUser SpecIdfgDescLastChangedByUser
SpecIdfgDescLastChangeDate SpecIdfgDescLastChangeDate
SpecIdfgDescSortSequence SpecIdfgDescSortSequence
SpecIdfgDescIsInheritanceSrce SpecIdfgDescIsInheritanceSrce
SpecIdfgDescInheritanceParent SpecIdfgDescInheritanceParent
SpecIdfgDescInheritanceRoot SpecIdfgDescInheritanceRoot
SpecIdfgDescRootSpecIntID SpecIdfgDescRootSpecIntID
InhtdSpecIdfgDescIsTmpChgd InhtdSpecIdfgDescIsTmpChgd
InhtdSpecIdfgDescIsPermChgd InhtdSpecIdfgDescIsPermChgd
SpecInheritanceTemplate SpecInheritanceTemplate
SpecInheritanceTmplSortSeq SpecInheritanceTmplSortSeq
SpecIdfgDescCategory SpecIdfgDescCategory
SpecIdfgDescType SpecIdfgDescType
SpecIdfgDescLanguage SpecIdfgDescLanguage
SpecIdfgDescText SpecIdfgDescText
_SpecIdfgDescLanguage _SpecIdfgDescLanguage
_SpecificationForKeyDate _SpecificationForKeyDate
_SpecIdentifierLongText _SpecIdentifierLongText
_SpecIdentifierUsageLocal _SpecIdentifierUsageLocal
_SpecIdentifierUsageOrigl _SpecIdentifierUsageOrigl
_SpecInheritanceTemplateHdr _SpecInheritanceTemplateHdr 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ISPECIDFR_KD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

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


@EndUserText.label: 'Specification on a Key Date'
define view I_SpecIdentifierForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_SpecIdentifier
  association [0..1] to I_SpecificationForKeyDate as _SpecificationForKeyDate on $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID
{
  key SpecIdfgDescInternalID,
  key SpecIdfgDescChangeState,
      SpecificationInternalID,
      SpecIdfgDescValidityStartDate,
      SpecIdfgDescValidityEndDate,
      SpecIdfgDescChangeNumber,
      SpecIdfgDescIsDeleted,
      SpecIdfgDescCreatedByUser,
      SpecIdfgDescCreationDate,
      SpecIdfgDescLastChangedByUser,
      SpecIdfgDescLastChangeDate,
      SpecIdfgDescSortSequence,
      SpecIdfgDescIsInheritanceSrce,
      SpecIdfgDescInheritanceParent,
      SpecIdfgDescInheritanceRoot,
      SpecIdfgDescRootSpecIntID,
      InhtdSpecIdfgDescIsTmpChgd,
      InhtdSpecIdfgDescIsPermChgd,
      SpecInheritanceTemplate,
      SpecInheritanceTmplSortSeq,
      SpecIdfgDescCategory,
      SpecIdfgDescType,
      SpecIdfgDescLanguage,
      SpecIdfgDescText,
      /* Associations */
      _SpecIdfgDescLanguage,
      _SpecificationForKeyDate,
      _SpecIdentifierLongText,

      _SpecIdentifierUsageLocal,
      _SpecIdentifierUsageOrigl,
      _SpecInheritanceTemplateHdr
}
where
      SpecIdfgDescValidityStartDate                <= $parameters.P_KeyDate
  and I_SpecIdentifier.SpecIdfgDescValidityEndDate >= $parameters.P_KeyDate
  and SpecIdfgDescIsDeleted                        is initial

Learn More