I_RecipeProcessEquipRqmtTextTP

DDL: I_RECIPEPROCESSEQUIPRQMTTEXTTP SQL: IRPREQUIPRQMTTXT Type: view TRANSACTIONAL Package: VDM_PLMB_RPR

Rcp Proc Equipment Requirement Description (Transacl Proc)

I_RecipeProcessEquipRqmtTextTP is a Transactional CDS View that provides data about "Rcp Proc Equipment Requirement Description (Transacl Proc)" in SAP S/4HANA. It reads from 1 data source (I_RecipeProcessEquipRqmtText) and exposes 14 fields with key fields RecipeProcessEquipRqmtUUID, Language. Part of development package VDM_PLMB_RPR.

Data Sources (1)

SourceAliasJoin Type
I_RecipeProcessEquipRqmtText I_RecipeProcessEquipRqmtText from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IRPREQUIPRQMTTXT 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 RecipeProcessEquipRqmtUUID 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 Rcp Proc Equipment Requirement Description (Transacl Proc) view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessEquipRqmtUUID RecipeProcessEquipRqmtUUID
KEY Language Language
RecipeProcessUUID RecipeProcessUUID
RecipeProcessEquipRqmtDesc RecipeProcessEquipRqmtDesc
RecipeLastChangeDateTime
RecipeUUID
Recipe
RecipeProcessEquipRqmtPosNmbr
RecipeProcessStagePosNmbr
RecipeProcessOperationPosNmbr
RecipeProcessActionPosNmbr
_Language _Language
_RcpForKeyDateTP
_RecipeProcessEquipRqmtTP _RecipeProcessEquipRqmtTP
@AbapCatalog.sqlViewName: 'IRPREQUIPRQMTTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

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

@EndUserText.label: 'Rcp Proc Equipment Requirement Description (Transacl Proc)'
define view I_RecipeProcessEquipRqmtTextTP
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    @Consumption.hidden: true
    P_KeyDate : sydate
  as select from I_RecipeProcessEquipRqmtText
  association to parent I_RecipeProcessEquipRqmtTP as _RecipeProcessEquipRqmtTP on $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmtTP.RecipeProcessEquipRqmtUUID
{
      @ObjectModel.foreignKey.association: '_RecipeProcessEquipRqmtTP'
  key RecipeProcessEquipRqmtUUID,

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

      RecipeProcessUUID,
      RecipeProcessEquipRqmtDesc,

      // for ETag handling

      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate ).RecipeLastChangeDateTime,

      // for shadow locking

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

      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate ).RecipeUUID,

      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate ).Recipe,

      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessEquipRqmtPosNmbr,
      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessStagePosNmbr,
      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessOperationPosNmbr,
      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessActionPosNmbr,

      /* Associations */
      _Language,
      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate )._RecipeForKeyDateTP as _RcpForKeyDateTP, //max. 16 chars

      _RecipeProcessEquipRqmtTP

}