A_RecipeProcessEquipRqmtText

DDL: A_RECIPEPROCESSEQUIPRQMTTEXT SQL: ARPREQUIPRQMTTX Type: view_entity CONSUMPTION

Recipe Equipment Requirement Descriptions

A_RecipeProcessEquipRqmtText is a Consumption CDS View that provides data about "Recipe Equipment Requirement Descriptions" in SAP S/4HANA. It reads from 1 data source (I_RecipeProcessEquipRqmtTextTP) and exposes 14 fields with key fields RecipeProcessEquipRqmtUUID, Language. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_RecipeProcessEquipRqmtTextTP I_RecipeProcessEquipRqmtTextTP from

Parameters (1)

NameTypeDefault
P_KeyDate dats

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_Recipe _Recipe $projection.RecipeProcessUUID = _Recipe.RecipeProcessUUID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey RecipeProcessEquipRqmtUUID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
Consumption.filter.businessDate.at true view
EndUserText.label Recipe Equipment Requirement Descriptions view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessEquipRqmtUUID RecipeProcessEquipRqmtUUID
KEY Language Language
RecipeProcessUUID RecipeProcessUUID
RecipeProcessEquipRqmtDesc RecipeProcessEquipRqmtDesc
RecipeLastChangeDateTime RecipeLastChangeDateTime
RecipeUUID
Recipe Recipe
RecipeProcessEquipRqmtPosNmbr RecipeProcessEquipRqmtPosNmbr
RecipeProcessStagePosNmbr RecipeProcessStagePosNmbr
RecipeProcessOperationPosNmbr RecipeProcessOperationPosNmbr
RecipeProcessActionPosNmbr RecipeProcessActionPosNmbr
_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt
_RecipeLock
_Recipe _Recipe 
//@AbapCatalog.sqlViewName: 'ARPREQUIPRQMTTX'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true


@AccessControl.authorizationCheck: #CHECK

//@ClientHandling.algorithm: #SESSION_VARIABLE


@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

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

@Metadata.ignorePropagatedAnnotations: true

@Consumption.filter.businessDate.at: true

@EndUserText.label: 'Recipe Equipment Requirement Descriptions'
define view entity A_RecipeProcessEquipRqmtText
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate :dats
  as select from I_RecipeProcessEquipRqmtTextTP( P_KeyDate: $parameters.P_KeyDate )
  association        to parent A_RecipeProcessEquipRqmt as _RecipeProcessEquipRqmt on $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID
  association [1..1] to A_Recipe                        as _Recipe                 on $projection.RecipeProcessUUID = _Recipe.RecipeProcessUUID
{

  key RecipeProcessEquipRqmtUUID,

      @Semantics.language: true
  key Language,

      RecipeProcessUUID,

      @Semantics.text: true
      RecipeProcessEquipRqmtDesc,

      RecipeLastChangeDateTime,

      _RecipeProcessEquipRqmt( P_KeyDate: $parameters.P_KeyDate ).RecipeUUID,
      //RecipeUUID,


      Recipe,

      RecipeProcessEquipRqmtPosNmbr,
      RecipeProcessStagePosNmbr,
      RecipeProcessOperationPosNmbr,
      RecipeProcessActionPosNmbr,

      _RecipeProcessEquipRqmt,

      _RecipeProcessEquipRqmt( P_KeyDate: $parameters.P_KeyDate )._Recipe as _RecipeLock,
      _Recipe
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_RECIPEPROCESSEQUIPRQMT",
"I_RECIPEPROCESSEQUIPRQMTTEXTTP"
],
"ASSOCIATED":
[
"A_RECIPE",
"A_RECIPEPROCESSEQUIPRQMT"
],
"BASE":
[
"A_RECIPEPROCESSEQUIPRQMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More