@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
}
/*+[internal] {
"BASEINFO":
{
"FROM ":
[
"I_RECIPEPROCESSEQUIPRQMTTEXT",
"I_RECIPEPROCESSEQUIPRQMTTP"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_RECIPEFORKEYDATETP",
"I_RECIPEPROCESSEQUIPRQMTTP"
],
"BASE":
[
"I_RECIPEPROCESSEQUIPRQMTTEXT",
"I_RECIPEPROCESSEQUIPRQMTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Depth:
1
2
3
4
5
All
Reload
I_RecipeProcessEquipRqmtTextTP view