I_SPECASSIGNEDMATLFORKEYDATE

CDS View

Specification Material Assignment for Key Date

I_SPECASSIGNEDMATLFORKEYDATE is a CDS View in S/4HANA. Specification Material Assignment for Key Date. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_SpecAssignedMatlForKeyDate view from COMPOSITE Specification Assigned Material For Key Date
P_SpecAssignedMatlForKeyDate view left_outer COMPOSITE 
@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SPECASSIGNEDMATERIAL"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MATERIALPLANT",
"I_PRODUCT",
"I_PRODUCTTEXT",
"I_SPECIFICATIONFORKEYDATE",
"I_USER"
],
"BASE":
[
"I_SPECASSIGNEDMATERIAL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More