CIC_SEASONPRODUCT

DDL: CIC_SEASONPRODUCT Type: view_entity
9 Fields 3 Data Sources

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.

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 #X 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 Product Sold
KEY ProductSeasonYear Season ProductSeasonYear Season Year
KEY ProductSeason Season ProductSeason Season
KEY ProductCollection Season ProductCollection Collection
KEY matnrasProduct
KEY ProductSeasonYear Season ProductSeasonYear Season Year
KEY ProductSeason Season ProductSeason Season
KEY ProductCollection Season ProductCollection Collection
KEY ProductTheme Season ProductTheme Theme

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view CIC_SEASONPRODUCT.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW CIC_SEASONPRODUCT AS
SELECT
  Season.Product AS Product,
  Season.ProductSeasonYear AS ProductSeasonYear,
  Season.ProductSeason AS ProductSeason,
  Season.ProductCollection AS ProductCollection,
  Season.ProductTheme AS matnrasProduct,
  Season.ProductTheme AS ProductTheme
INNER JOIN mara ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS variant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SeasonProduct AS variant_season ON /* join condition not captured in parsed metadata */
;

Learn More