P_SpecAssignedMatlForKeyDate

DDL: P_SPECASSIGNEDMATLFORKEYDATE SQL: PSPECMATASSGMTKD Type: view COMPOSITE

P_SpecAssignedMatlForKeyDate is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_SpecAssignedMatlForKeyDate, I_Product, I_MaterialPlant) and exposes 6 fields with key field Product.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_SpecAssignedMatlForKeyDate I_SpecAssignedMatlForKeyDate left_outer
I_Product Product from
I_MaterialPlant ProductPlant left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSPECMATASSGMTKD view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Product I_Product Product
ProductName
Plant I_MaterialPlant Plant
Specification
SpecificationAuthznGroup
SpecificationType 
@AbapCatalog.sqlViewName: 'PSPECMATASSGMTKD'
@AbapCatalog.compiler.compareFilter: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true

@VDM.lifecycle.contract.type: #NONE
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_SpecAssignedMatlForKeyDate
  as select from    I_Product                                                     as Product
    left outer join I_MaterialPlant                                               as ProductPlant         on Product.Product = ProductPlant.Material
    left outer join I_SpecAssignedMatlForKeyDate( P_KeyDate:$session.system_date) as SpecAssignedMaterial on  Product.Product            = SpecAssignedMaterial.Material
//                                                                                                          and SpecAssignedMaterial.Plant = ProductPlant.Plant

{
  key Product.Product,
      Product._Text[1: Language = $session.system_language ].ProductName,
      ProductPlant.Plant,
      SpecAssignedMaterial._SpecificationForKeyDate( P_KeyDate : $session.system_date).Specification,

      // Fields for Authorization

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

Learn More