I_SpecAssignedMatlForKeyDate

DDL: I_SPECASSIGNEDMATLFORKEYDATE SQL: ISPECMATASSGMTKD Type: view COMPOSITE

Specification Material Assignment for Key Date

I_SpecAssignedMatlForKeyDate is a Composite CDS View that provides data about "Specification Material Assignment for Key Date" in SAP S/4HANA. It reads from 1 data source (I_SpecAssignedMaterial) and exposes 20 fields with key fields SpecMaterialAssgmtInternalID, SpecMaterialAssgmtChangeState. It has 1 association to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_SpecAssignedMaterial I_SpecAssignedMaterial from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPECMATASSGMTKD 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
EndUserText.label Specification Material Assignment for Key Date view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SpecMaterialAssgmtInternalID SpecMaterialAssgmtInternalID
KEY SpecMaterialAssgmtChangeState SpecMaterialAssgmtChangeState
SpecificationInternalID SpecificationInternalID
SpecMatlAssgmtValdtyStartDate SpecMatlAssgmtValdtyStartDate
SpecMatlAssgmtValdtyEndDate SpecMatlAssgmtValdtyEndDate
SpecMaterialAssgmtChangeNumber SpecMaterialAssgmtChangeNumber
SpecMaterialAssgmtIsDeleted SpecMaterialAssgmtIsDeleted
SpecMaterialAssgmtCreationDate SpecMaterialAssgmtCreationDate
SpecMaterialAssgmtCreatedByUsr SpecMaterialAssgmtCreatedByUsr
SpecMaterialAssgmtChangeDate SpecMaterialAssgmtChangeDate
SpecMatlAssgmtLastChangedByUsr SpecMatlAssgmtLastChangedByUsr
Plant Plant
Material Material
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_Product _Product
_Material _Material
_MaterialPlant _MaterialPlant
_SpecificationForKeyDate _SpecificationForKeyDate
_MaterialText _MaterialText 
@AbapCatalog.sqlViewName: 'ISPECMATASSGMTKD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@EndUserText.label: 'Specification Material Assignment for Key Date'

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

define view I_SpecAssignedMatlForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_SpecAssignedMaterial
  association [1..1] to I_SpecificationForKeyDate as _SpecificationForKeyDate on $projection.SpecificationInternalID = _SpecificationForKeyDate.SpecificationInternalID
{
      // I_SpecAssignedMaterial

  key SpecMaterialAssgmtInternalID,
  key SpecMaterialAssgmtChangeState,
      SpecificationInternalID,
      SpecMatlAssgmtValdtyStartDate,
      SpecMatlAssgmtValdtyEndDate,
      SpecMaterialAssgmtChangeNumber,
      SpecMaterialAssgmtIsDeleted,
      SpecMaterialAssgmtCreationDate,
      SpecMaterialAssgmtCreatedByUsr,
      SpecMaterialAssgmtChangeDate,
      SpecMatlAssgmtLastChangedByUsr,
      Plant,
      Material,

      /* Associations */
      _CreatedByUser,
      _LastChangedByUser,
      _Product,
      _Material,
      _MaterialPlant,
      _SpecificationForKeyDate,
      _MaterialText
}
where
      SpecMatlAssgmtValdtyStartDate <= $parameters.P_KeyDate
  and SpecMatlAssgmtValdtyEndDate   >= $parameters.P_KeyDate

Learn More