I_RecipeTextTP

DDL: I_RECIPETEXTTP SQL: IRECIPETEXTTP Type: view TRANSACTIONAL

Recipe Description (Transactional Processing)

I_RecipeTextTP is a Transactional CDS View that provides data about "Recipe Description (Transactional Processing)" in SAP S/4HANA. It reads from 1 data source (I_RecipeText) and exposes 7 fields with key fields RecipeUUID, Language.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_RecipeText I_RecipeText from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IRECIPETEXTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey RecipeUUID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Recipe Description (Transactional Processing) view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY RecipeUUID RecipeUUID
KEY Language Language
RecipeDescription RecipeDescription
RecipeLastChangeDateTime
Recipe
_RecipeForKeyDateTP _RecipeForKeyDateTP
_Language _Language 
@AbapCatalog.sqlViewName: 'IRECIPETEXTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'RecipeUUID'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER

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

@EndUserText.label: 'Recipe Description (Transactional Processing)'
define view I_RecipeTextTP
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    @Consumption.hidden: true
    P_KeyDate : sydate
  as select from I_RecipeText
  association to parent I_RecipeForKeyDateTP as _RecipeForKeyDateTP on $projection.RecipeUUID = _RecipeForKeyDateTP.RecipeUUID
{
      @ObjectModel.foreignKey.association: '_RecipeForKeyDateTP'
  key RecipeUUID,

      @ObjectModel.foreignKey.association: '_Language'
  key Language,

      RecipeDescription,

      // for ETag handling

      _RecipeForKeyDateTP(P_KeyDate : $parameters.P_KeyDate ).RecipeLastChangeDateTime,
      
      _RecipeForKeyDateTP(P_KeyDate : $parameters.P_KeyDate ).Recipe,

      _RecipeForKeyDateTP,

      /* Associations */
      _Language

}

Learn More