I_RecipeType

DDL: I_RECIPETYPE SQL: IRECIPETYPE Type: view BASIC

Recipe Type

I_RecipeType is a Basic CDS View that provides data about "Recipe Type" in SAP S/4HANA. It reads from 1 data source (/plmb/rcp_ty_gen) and exposes 6 fields with key field RecipeType. It has 3 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
/plmb/rcp_ty_gen /plmb/rcp_ty_gen from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_RecipeTypeText _RecipeTypeText $projection.RecipeType = _RecipeTypeText.RecipeType
[0..*] I_Recipe _Recipe $projection.RecipeType = _Recipe.RecipeType
[0..1] I_RecipeCategory _RecipeCategory $projection.RecipeCategory = _RecipeCategory.RecipeCategory

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IRECIPETYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey RecipeType view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Recipe Type view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY RecipeType rcp_type_id
RecipeCategory category
RecipeStatusSchema status_schema
_Recipe _Recipe
_RecipeTypeText _RecipeTypeText
_RecipeCategory _RecipeCategory 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IRECIPETYPE'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'RecipeType'
@ObjectModel.semanticKey: [ 'RecipeType' ]

@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@EndUserText.label: 'Recipe Type'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #BASIC

define view I_RecipeType
  as select from /plmb/rcp_ty_gen
  association [0..*] to I_RecipeTypeText as _RecipeTypeText on $projection.RecipeType = _RecipeTypeText.RecipeType
  association [0..*] to I_Recipe         as _Recipe         on $projection.RecipeType = _Recipe.RecipeType
  association [0..1] to I_RecipeCategory as _RecipeCategory on $projection.RecipeCategory = _RecipeCategory.RecipeCategory
{
      @ObjectModel.text.association: '_RecipeTypeText'
  key rcp_type_id     as RecipeType,

      @ObjectModel.foreignKey.association: '_RecipeCategory'
      category        as RecipeCategory,

      status_schema   as RecipeStatusSchema,

      /* Associations */
      _Recipe,
      _RecipeTypeText,
      _RecipeCategory
}
where
  category = '' // Recipes only 


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMB/RCP_TY_GEN"
],
"ASSOCIATED":
[
"I_RECIPE",
"I_RECIPECATEGORY",
"I_RECIPETYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More