I_RecipeProcessEquipRqmtTP

DDL: I_RECIPEPROCESSEQUIPRQMTTP SQL: IRPREQUIPRQMTTP Type: view TRANSACTIONAL Package: VDM_PLMB_RPR

Recipe Process Equipment Requirement (Transactional Proc)

I_RecipeProcessEquipRqmtTP is a Transactional CDS View that provides data about "Recipe Process Equipment Requirement (Transactional Proc)" in SAP S/4HANA. It reads from 1 data source (I_RecipeProcessEquipRqmt) and exposes 14 fields with key field RecipeProcessEquipRqmtUUID. It has 3 associations to related views. Part of development package VDM_PLMB_RPR.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_RecipeProcessEquipRqmt I_RecipeProcessEquipRqmt from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_RecipeProcessElementTP _RecipeProcessElementTP $projection.RecipeProcessElementUUID = _RecipeProcessElementTP.RecipeProcessElementUUID
[0..*] I_RecipeProcessParamValueTP _RecipeProcessEQRParamValueTP $projection.RecipeProcessUUID = _RecipeProcessEQRParamValueTP.RecipeProcessUUID
[0..*] I_RecipeProcessEquipRqmtTextTP _RecipeProcessEquipRqmtTextTP

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IRPREQUIPRQMTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey RecipeProcessEquipRqmtUUID view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Recipe Process Equipment Requirement (Transactional Proc) view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessEquipRqmtUUID RecipeProcessEquipRqmtUUID
RecipeProcessUUID RecipeProcessUUID
RecipeProcessElementUUID RecipeProcessElementUUID
RecipeProcessEquipRqmtPosNmbr RecipeProcessEquipRqmtPosNmbr
RecipeProcEquipRqmtIsPrimRsce RecipeProcEquipRqmtIsPrimRsce
RecipeLastChangeDateTime
RecipeUUID RecipeUUID
Recipe
RecipeProcessStagePosNmbr
RecipeProcessOperationPosNmbr
RecipeProcessActionPosNmbr
_RecipeForKeyDateTP _RecipeForKeyDateTP
_RecipeProcessEQRParamValueTP _RecipeProcessEQRParamValueTP
_RecipeProcessEquipRqmtTextTP _RecipeProcessEquipRqmtTextTP 
@AbapCatalog.sqlViewName: 'IRPREQUIPRQMTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER

@ObjectModel.representativeKey: 'RecipeProcessEquipRqmtUUID'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Recipe Process Equipment Requirement (Transactional Proc)'

define view I_RecipeProcessEquipRqmtTP
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    @Consumption.hidden: true
    P_KeyDate : sydate
  as select from I_RecipeProcessEquipRqmt
  association        to parent I_RecipeForKeyDateTP    as _RecipeForKeyDateTP           on $projection.RecipeUUID = _RecipeForKeyDateTP.RecipeUUID
  association [0..1] to I_RecipeProcessElementTP       as _RecipeProcessElementTP       on $projection.RecipeProcessElementUUID = _RecipeProcessElementTP.RecipeProcessElementUUID

  // Texts

  composition [0..*] of I_RecipeProcessEquipRqmtTextTP as _RecipeProcessEquipRqmtTextTP
  association [0..*] to I_RecipeProcessParamValueTP    as _RecipeProcessEQRParamValueTP on $projection.RecipeProcessUUID = _RecipeProcessEQRParamValueTP.RecipeProcessUUID
{
  key RecipeProcessEquipRqmtUUID,
      RecipeProcessUUID,
      RecipeProcessElementUUID,
      RecipeProcessEquipRqmtPosNmbr,
      RecipeProcEquipRqmtIsPrimRsce,

      // for ETag handling

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

      // for shadow locking

      RecipeUUID,

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

      _RecipeProcessElementTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessStagePosNmbr,
      _RecipeProcessElementTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessOperationPosNmbr,
      _RecipeProcessElementTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessActionPosNmbr,

      _RecipeForKeyDateTP,
      _RecipeProcessEQRParamValueTP,

      // Texts

      _RecipeProcessEquipRqmtTextTP
}
where
  _RecipeForKeyDateTP(P_KeyDate : $parameters.P_KeyDate ).RecipeLastChangeDateTime is not null

Learn More