A_SpecAssignedMatlForKeyDate

DDL: A_SPECASSIGNEDMATLFORKEYDATE SQL: ASPECMATASSIGN Type: view COMPOSITE

Specification Assigned Material For Key Date

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

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_SpecAssignedMatlForKeyDate I_SpecAssignedMatlForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (4)

CardinalityTargetAliasCondition
[0..1] A_Product _Product $projection.Material = _Product.Product and $projection.Plant = ''
[0..1] A_ProductPlant _ProductPlant $projection.Material = _ProductPlant.Product and $projection.Plant = _ProductPlant.Plant
[0..*] A_ProductDescription _Description $projection.Material = _Description.Product
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ASPECMATASSIGN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
Consumption.filter.businessDate.at true view
EndUserText.label Specification Assigned Material For Key Date view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SpecMaterialAssgmtInternalID SpecMaterialAssgmtInternalID
KEY SpecMaterialAssgmtChangeState SpecMaterialAssgmtChangeState
Material Material
Plant Plant
PlantName _Plant PlantName
SpecMaterialAssgmtChangeDate SpecMaterialAssgmtChangeDate
SpecMaterialAssgmtChangeNumber SpecMaterialAssgmtChangeNumber
SpecMaterialAssgmtCreatedByUsr SpecMaterialAssgmtCreatedByUsr
SpecMaterialAssgmtCreationDate SpecMaterialAssgmtCreationDate
SpecMaterialAssgmtIsDeleted SpecMaterialAssgmtIsDeleted
SpecMatlAssgmtLastChangedByUsr SpecMatlAssgmtLastChangedByUsr
SpecMatlAssgmtValdtyEndDate SpecMatlAssgmtValdtyEndDate
SpecMatlAssgmtValdtyStartDate SpecMatlAssgmtValdtyStartDate
SpecificationInternalID SpecificationInternalID
SpecificationAuthznGroup
SpecificationType
_Product _Product
_ProductPlant _ProductPlant
_Description _Description 
@AbapCatalog.sqlViewName: 'ASPECMATASSIGN'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

@Metadata.ignorePropagatedAnnotations: true

@Consumption.filter.businessDate.at: true

@EndUserText.label: 'Specification Assigned Material For Key Date'
define view A_SpecAssignedMatlForKeyDate 
  with parameters
    @Semantics.businessDate.at: true
    @Consumption.hidden: true
    P_KeyDate: sydate

  as select from I_SpecAssignedMatlForKeyDate ( P_KeyDate : $parameters.P_KeyDate ) 

  association [0..1] to A_Product            as _Product      on  $projection.Material = _Product.Product
                                                              and $projection.Plant    = ''

  association [0..1] to A_ProductPlant       as _ProductPlant on  $projection.Material = _ProductPlant.Product
                                                              and $projection.Plant    = _ProductPlant.Plant

  association [0..*] to A_ProductDescription as _Description  on  $projection.Material = _Description.Product

  association [0..1] to I_Plant              as _Plant        on  $projection.Plant = _Plant.Plant
{

  key SpecMaterialAssgmtInternalID,
  key SpecMaterialAssgmtChangeState,

      Material,
      Plant,
      _Plant.PlantName                                                                      as PlantName,
      SpecMaterialAssgmtChangeDate,
      SpecMaterialAssgmtChangeNumber,

      SpecMaterialAssgmtCreatedByUsr,
      SpecMaterialAssgmtCreationDate,

      SpecMaterialAssgmtIsDeleted,
      SpecMatlAssgmtLastChangedByUsr,
      SpecMatlAssgmtValdtyEndDate,
      SpecMatlAssgmtValdtyStartDate,
      SpecificationInternalID,

      _SpecificationForKeyDate( P_KeyDate : $session.system_date ).SpecificationAuthznGroup as SpecificationAuthznGroup,
      _SpecificationForKeyDate( P_KeyDate : $session.system_date ).SpecificationType        as SpecificationType,

      /* Associations */
      _Product,
      _ProductPlant,
      _Description

}

Learn More