CIC_SEASONPRODUCT

DDL: CIC_SEASONPRODUCT Type: view_entity

Proj. on Prod. Assgmt to Season (Industry Cloud Solutions)

CIC_SEASONPRODUCT is a CDS View that provides data about "Proj. on Prod. Assgmt to Season (Industry Cloud Solutions)" in SAP S/4HANA. It reads from 3 data sources (mara, mara, I_SeasonProduct) and exposes 9 fields with key fields Product, ProductSeasonYear, ProductSeason, ProductCollection, matnrasProduct.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
mara mara inner
mara variant inner
I_SeasonProduct variant_season left_outer

Annotations (6)

NameValueLevelField
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Proj. on Prod. Assgmt to Season (Industry Cloud Solutions) view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Product Season Product
KEY ProductSeasonYear Season ProductSeasonYear
KEY ProductSeason Season ProductSeason
KEY ProductCollection Season ProductCollection
KEY matnrasProduct
KEY ProductSeasonYear Season ProductSeasonYear
KEY ProductSeason Season ProductSeason
KEY ProductCollection Season ProductCollection
KEY ProductTheme Season ProductTheme 
@ObjectModel: {
   usageType: {
     dataClass:      #MASTER,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Proj. on Prod. Assgmt to Season (Industry Cloud Solutions)'
define view entity CIC_SEASONPRODUCT
  as select distinct from I_SeasonProduct as Season
    inner join            mara on Season.Product = mara.matnr

{
  key Season.Product,
  key Season.ProductSeasonYear,
  key Season.ProductSeason,
  key Season.ProductCollection,
  key Season.ProductTheme
}
union all select distinct from I_SeasonProduct as Season
  inner join                   mara            as variant        on  Season.Product    = variant.satnr
                                                                 and variant.fsh_sealv is not initial
  left outer join              I_SeasonProduct as variant_season on variant.matnr = variant_season.Product
{
  key variant.matnr as Product,
  key Season.ProductSeasonYear,
  key Season.ProductSeason,
  key Season.ProductCollection,
  key Season.ProductTheme
}
where
  variant_season.Product is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SEASONPRODUCT",
"MARA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More