@AbapCatalog.sqlViewName : 'CCPPASKLISTVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label : 'Cut Planning Profile task List'
@ObjectModel.representativeKey : 'BillOfOperationsGroup'
@ObjectModel.usageType: {serviceQuality: #C,
dataClass: #MIXED,
sizeCategory: #S}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@Search.searchable: true
@ObjectModel.dataCategory: #VALUE_HELP
define view C_ChgRecdRefCutPlngPrflVH
as select from I_BillOfOperations as _BillOfOperations
{
@EndUserText.label : 'Group '
@Search.defaultSearchElement: true
@Search.fuzzinessThreshold : 1.0
@Search.ranking: #HIGH
key cast ( BillOfOperationsGroup as r_plnnr preserving type) as BillOfOperationsGroup,
@UI.hidden: true
key BillOfOperationsType,
@Search.defaultSearchElement: true
@EndUserText.label : 'Group Counter'
key BillOfOperationsVariant,
@Search.defaultSearchElement: true
_BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].ResponsiblePlannerGroup,
@Search.defaultSearchElement: true
_BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].Plant,
@Search.defaultSearchElement: true
@EndUserText.label : 'Description'
_BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].BillOfOperationsDesc,
_BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].BillOfOperationsUsage,
@EndUserText.label : 'Status'
_BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].BillOfOperationsStatus
}
where
BillOfOperationsType = '3'
/*+[internal] {
"BASEINFO":
{
"FROM ":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSCHANGESTATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Depth:
1
2
3
4
5
All
Reload
C_ChgRecdRefCutPlngPrflVH view