@AbapCatalog.sqlViewName: 'CSTWHEREUSED'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'View for ST Where Used List'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #M,
dataClass: #TRANSACTIONAL
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@UI.headerInfo:{
typeName: 'Operation Activity',
typeNamePlural: 'Operation Activities'
}
@UI.presentationVariant.requestAtLeast: ['Language_Text','BillOfOperationsGroup', 'BillOfOperationsVersion','BillOfOperationsVariant','BillOfOperationsType']
define view C_MfgStdTextVersWhereUsedList
as select distinct from I_MfgWorkInstructionStdTextRef as STRef
inner join I_OpActyWorkInstructionAssgmt as OpActyWI on STRef.MfgWorkInstruction = OpActyWI.WorkInstruction
and STRef.MfgWorkInstructionVersCounter = OpActyWI.WorkInstructionVersionCounter
inner join I_OpActyNtwkElement as OAN on OpActyWI.OperationActivity = OAN.OpActyNtwkElementElement
and OpActyWI.OperationActyVersionCounter = OAN.OpActyNtwkElementElmntVersCntr
and OAN.OpActyNtwkElementType = 3
inner join I_BOOOperationChgStOANBasic as BillOfOperationChg on OAN.OperationActivityNetwork = BillOfOperationChg.ProduceOpActyNtwk
and OAN.OpActyNtwkVersionCounter = BillOfOperationChg.ProduceOpActyNtwkVersCounter
inner join I_BillOfOperationsOpBasic as BillOfOperationOpBasic on BillOfOperationChg.BillOfOperationsGroup = BillOfOperationOpBasic.BillOfOperationsGroup
and BillOfOperationChg.BillOfOperationsType = BillOfOperationOpBasic.BillOfOperationsType
and BillOfOperationChg.BOOOperationInternalID = BillOfOperationOpBasic.BOOOperationInternalID
and BillOfOperationChg.BOOOpInternalVersionCounter = BillOfOperationOpBasic.BOOOpInternalVersionCounter
inner join I_BOOSqncOperationAssgmtChgSt as BooSqncOpAssgmt on BillOfOperationOpBasic.BillOfOperationsGroup = BooSqncOpAssgmt.BillOfOperationsGroup
and BillOfOperationOpBasic.BillOfOperationsType = BooSqncOpAssgmt.BillOfOperationsType
and BillOfOperationOpBasic.BOOOperationInternalID = BooSqncOpAssgmt.BOOOperationInternalID
and BillOfOperationOpBasic.BillOfOperationsVersion = BooSqncOpAssgmt.BillOfOperationsVersion
and BillOfOperationOpBasic.BOOOpInternalVersionCounter = BooSqncOpAssgmt.BOOSqncOpAssgmtIntVersionCntr
inner join I_BillOfOperationsVersion as BillOfOperationsVersion on BillOfOperationOpBasic.BillOfOperationsGroup = BillOfOperationsVersion.BillOfOperationsGroup
and BooSqncOpAssgmt.BillOfOperationsVariant = BillOfOperationsVersion.BillOfOperationsVariant
and BillOfOperationOpBasic.BillOfOperationsType = BillOfOperationsVersion.BillOfOperationsType
and BillOfOperationOpBasic.BillOfOperationsVersion = BillOfOperationsVersion.BillOfOperationsVersion
// inner join I_BOOMaterialAssignment as BooMaterialAssgmt on BillOfOperationChg.BillOfOperationsGroup = BooMaterialAssgmt.BillOfOperationsGroup
// and BillOfOperationChg.BillOfOperationsType = BooMaterialAssgmt.BillOfOperationsType
// and BooSqncOpAssgmt.BillOfOperationsVariant = BooMaterialAssgmt.BillOfOperationsVariant
{
@UI.hidden: true
key MfgWorkInstruction,
@UI.hidden: true
key MfgWorkInstructionVersCounter,
@UI.hidden: true
key MfgStandardText,
@UI.hidden: true
key MfgStandardTextVersion,
@UI.hidden: true
key Language as Language,
@Search.defaultSearchElement: true
key BillOfOperationsVersion.BillOfOperationsGroup,
@UI.hidden: true
key BillOfOperationOpBasic.BOOOpInternalVersionCounter,
//@Consumption.hidden: true
// @UI: {
// lineItem:
// {
// position: 40,
// importance: #HIGH
// },
// identification : {position:40}
// }
@Search.defaultSearchElement: true
key BillOfOperationsVersion.BillOfOperationsVariant,
@UI: {
lineItem:
{
position: 20,
importance: #HIGH
},
identification : {position:20}
}
// @Search.defaultSearchElement: true
@Consumption.semanticObject:'ShopFloorRouting'
@EndUserText.label: 'Routing Group'
concat(concat(BillOfOperationsVersion.BillOfOperationsGroup, ('-')), concat(BillOfOperationsVersion.BillOfOperationsVariant, concat(('-'), BillOfOperationsVersion.BillOfOperationsVersion))) as BillOfOperationsDisplayKey,
@UI: {
lineItem:
{
position: 50,
importance: #HIGH
},
identification : {position:50}
}
@EndUserText.label: 'Status'
// @Search.defaultSearchElement: true
BillOfOperationsVersion._BOOVersionStatus._Text[1:Language = $session.system_language].BOOVersionStatusText,
@UI.hidden: true
OpActyWI.OperationActivity,
@UI: {
lineItem:
{
position: 60,
importance: #HIGH
},
identification : {position:60}
}
@ObjectModel.text.element: [ 'Operation' ]
@UI.textArrangement: #TEXT_LAST
@Search.defaultSearchElement: true
@EndUserText.label: 'Operation'
BillOfOperationOpBasic.OperationText,
@UI.hidden: true
cast(BillOfOperationOpBasic.Operation as pph_vornr preserving type) as Operation,
@UI: {
lineItem:
{
position: 70,
importance: #HIGH
},
identification : {position:70}
}
@ObjectModel.text.element: [ 'OpActyNtwkElementExternalID' ]
@UI.textArrangement: #TEXT_LAST
@Search.defaultSearchElement: true
@EndUserText.label: 'Operation Activity'
OAN._OperationActivityText[1:Language = $session.system_language].OperationActivityName,
@UI.hidden: true
OAN.OpActyNtwkElementExternalID,
@UI.hidden: true
BillOfOperationOpBasic.BillOfOperationsType,
//@UI.hidden: true
// @UI: {
// lineItem:
// {
// position: 30,
// importance: #HIGH
// },
// identification : {position:30}
// }
@Search.defaultSearchElement: true
BillOfOperationsVersion.BillOfOperationsVersion
}
union all select distinct from I_MfgWorkInstructionStdTextRef as STRef
inner join I_OpActyWorkInstructionAssgmt as OpActyWI on STRef.MfgWorkInstruction = OpActyWI.WorkInstruction
and STRef.MfgWorkInstructionVersCounter = OpActyWI.WorkInstructionVersionCounter
inner join I_OpActyNtwkElement as OAN on OpActyWI.OperationActivity = OAN.OpActyNtwkElementElement
and OpActyWI.OperationActyVersionCounter = OAN.OpActyNtwkElementElmntVersCntr
and OAN.OpActyNtwkElementType = 3
inner join I_BOOOperationChgStOANBasic as BillOfOperationChg on OAN.OperationActivityNetwork = BillOfOperationChg.SetupOpActyNtwk
and OAN.OpActyNtwkVersionCounter = BillOfOperationChg.SetupOpActyNtwkVersCounter
inner join I_BillOfOperationsOpBasic as BillOfOperationOpBasic on BillOfOperationChg.BillOfOperationsGroup = BillOfOperationOpBasic.BillOfOperationsGroup
and BillOfOperationChg.BillOfOperationsType = BillOfOperationOpBasic.BillOfOperationsType
and BillOfOperationChg.BOOOperationInternalID = BillOfOperationOpBasic.BOOOperationInternalID
and BillOfOperationChg.BOOOpInternalVersionCounter = BillOfOperationOpBasic.BOOOpInternalVersionCounter
inner join I_BOOSqncOperationAssgmtChgSt as BooSqncOpAssgmt on BillOfOperationOpBasic.BillOfOperationsGroup = BooSqncOpAssgmt.BillOfOperationsGroup
and BillOfOperationOpBasic.BillOfOperationsType = BooSqncOpAssgmt.BillOfOperationsType
and BillOfOperationOpBasic.BOOOperationInternalID = BooSqncOpAssgmt.BOOOperationInternalID
and BillOfOperationOpBasic.BillOfOperationsVersion = BooSqncOpAssgmt.BillOfOperationsVersion
and BillOfOperationOpBasic.BOOOpInternalVersionCounter = BooSqncOpAssgmt.BOOSqncOpAssgmtIntVersionCntr
inner join I_BillOfOperationsVersion as BillOfOperationsVersion on BillOfOperationOpBasic.BillOfOperationsGroup = BillOfOperationsVersion.BillOfOperationsGroup
and BooSqncOpAssgmt.BillOfOperationsVariant = BillOfOperationsVersion.BillOfOperationsVariant
and BillOfOperationOpBasic.BillOfOperationsType = BillOfOperationsVersion.BillOfOperationsType
and BillOfOperationOpBasic.BillOfOperationsVersion = BillOfOperationsVersion.BillOfOperationsVersion
// inner join I_BOOMaterialAssignment as BooMaterialAssgmt on BillOfOperationChg.BillOfOperationsGroup = BooMaterialAssgmt.BillOfOperationsGroup
// and BillOfOperationChg.BillOfOperationsType = BooMaterialAssgmt.BillOfOperationsType
// and BooSqncOpAssgmt.BillOfOperationsVariant = BooMaterialAssgmt.BillOfOperationsVariant
{
@UI.hidden: true
key MfgWorkInstruction,
@UI.hidden: true
key MfgWorkInstructionVersCounter,
@UI.hidden: true
key MfgStandardText,
@UI.hidden: true
key MfgStandardTextVersion,
@UI.hidden: true
key Language as Language,
@Search.defaultSearchElement: true
key BillOfOperationsVersion.BillOfOperationsGroup,
@UI.hidden: true
key BillOfOperationOpBasic.BOOOpInternalVersionCounter,
//@Consumption.hidden: true
// @UI: {
// lineItem:
// {
// position: 40,
// importance: #HIGH
// },
// identification : {position:40}
// }
@Search.defaultSearchElement: true
key BillOfOperationsVersion.BillOfOperationsVariant,
@UI: {
lineItem:
{
position: 20,
importance: #HIGH
},
identification : {position:20}
}
// @Search.defaultSearchElement: true
@Consumption.semanticObject:'ShopFloorRouting'
@EndUserText.label: 'Routing Group'
concat(concat(BillOfOperationsVersion.BillOfOperationsGroup, ('-')), concat(BillOfOperationsVersion.BillOfOperationsVariant, concat(('-'), BillOfOperationsVersion.BillOfOperationsVersion))) as BillOfOperationsDisplayKey,
@UI: {
lineItem:
{
position: 50,
importance: #HIGH
},
identification : {position:50}
}
@EndUserText.label: 'Status'
// @Search.defaultSearchElement: true
BillOfOperationsVersion._BOOVersionStatus._Text[1:Language = $session.system_language].BOOVersionStatusText,
@UI.hidden: true
OpActyWI.OperationActivity,
@UI: {
lineItem:
{
position: 60,
importance: #HIGH
},
identification : {position:60}
}
@ObjectModel.text.element: [ 'Operation' ]
@UI.textArrangement: #TEXT_LAST
@Search.defaultSearchElement: true
@EndUserText.label: 'Operation'
BillOfOperationOpBasic.OperationText,
@UI.hidden: true
cast(BillOfOperationOpBasic.Operation as pph_vornr preserving type) as Operation,
@UI: {
lineItem:
{
position: 70,
importance: #HIGH
},
identification : {position:70}
}
@ObjectModel.text.element: [ 'OpActyNtwkElementExternalID' ]
@UI.textArrangement: #TEXT_LAST
@Search.defaultSearchElement: true
@EndUserText.label: 'Operation Activity'
OAN._OperationActivityText[1:Language = $session.system_language].OperationActivityName,
@UI.hidden: true
OAN.OpActyNtwkElementExternalID,
@UI.hidden: true
BillOfOperationOpBasic.BillOfOperationsType,
//@UI.hidden: true
// @UI: {
// lineItem:
// {
// position: 30,
// importance: #HIGH
// },
// identification : {position:30}
// }
@Search.defaultSearchElement: true
BillOfOperationsVersion.BillOfOperationsVersion
}
union all select distinct from I_MfgWorkInstructionStdTextRef as STRef
inner join I_OpActyWorkInstructionAssgmt as OpActyWI on STRef.MfgWorkInstruction = OpActyWI.WorkInstruction
and STRef.MfgWorkInstructionVersCounter = OpActyWI.WorkInstructionVersionCounter
inner join I_OpActyNtwkElement as OAN on OpActyWI.OperationActivity = OAN.OpActyNtwkElementElement
and OpActyWI.OperationActyVersionCounter = OAN.OpActyNtwkElementElmntVersCntr
and OAN.OpActyNtwkElementType = 3
inner join I_BOOOperationChgStOANBasic as BillOfOperationChg on OAN.OperationActivityNetwork = BillOfOperationChg.TeardownOpActyNtwk
and OAN.OpActyNtwkVersionCounter = BillOfOperationChg.TeardownOpActyNtwkVersCounter
inner join I_BillOfOperationsOpBasic as BillOfOperationOpBasic on BillOfOperationChg.BillOfOperationsGroup = BillOfOperationOpBasic.BillOfOperationsGroup
and BillOfOperationChg.BillOfOperationsType = BillOfOperationOpBasic.BillOfOperationsType
and BillOfOperationChg.BOOOperationInternalID = BillOfOperationOpBasic.BOOOperationInternalID
and BillOfOperationChg.BOOOpInternalVersionCounter = BillOfOperationOpBasic.BOOOpInternalVersionCounter
inner join I_BOOSqncOperationAssgmtChgSt as BooSqncOpAssgmt on BillOfOperationOpBasic.BillOfOperationsGroup = BooSqncOpAssgmt.BillOfOperationsGroup
and BillOfOperationOpBasic.BillOfOperationsType = BooSqncOpAssgmt.BillOfOperationsType
and BillOfOperationOpBasic.BOOOperationInternalID = BooSqncOpAssgmt.BOOOperationInternalID
and BillOfOperationOpBasic.BillOfOperationsVersion = BooSqncOpAssgmt.BillOfOperationsVersion
and BillOfOperationOpBasic.BOOOpInternalVersionCounter = BooSqncOpAssgmt.BOOSqncOpAssgmtIntVersionCntr
inner join I_BillOfOperationsVersion as BillOfOperationsVersion on BillOfOperationOpBasic.BillOfOperationsGroup = BillOfOperationsVersion.BillOfOperationsGroup
and BooSqncOpAssgmt.BillOfOperationsVariant = BillOfOperationsVersion.BillOfOperationsVariant
and BillOfOperationOpBasic.BillOfOperationsType = BillOfOperationsVersion.BillOfOperationsType
and BillOfOperationOpBasic.BillOfOperationsVersion = BillOfOperationsVersion.BillOfOperationsVersion
// inner join I_BOOMaterialAssignment as BooMaterialAssgmt on BillOfOperationChg.BillOfOperationsGroup = BooMaterialAssgmt.BillOfOperationsGroup
// and BillOfOperationChg.BillOfOperationsType = BooMaterialAssgmt.BillOfOperationsType
// and BooSqncOpAssgmt.BillOfOperationsVariant = BooMaterialAssgmt.BillOfOperationsVariant
{
@UI.hidden: true
key MfgWorkInstruction,
@UI.hidden: true
key MfgWorkInstructionVersCounter,
@UI.hidden: true
key MfgStandardText,
@UI.hidden: true
key MfgStandardTextVersion,
@UI.hidden: true
key Language as Language,
@Search.defaultSearchElement: true
key BillOfOperationsVersion.BillOfOperationsGroup,
@UI.hidden: true
key BillOfOperationOpBasic.BOOOpInternalVersionCounter,
//@Consumption.hidden: true
// @UI: {
// lineItem:
// {
// position: 40,
// importance: #HIGH
// },
// identification : {position:40}
// }
@Search.defaultSearchElement: true
key BillOfOperationsVersion.BillOfOperationsVariant,
@UI: {
lineItem:
{
position: 20,
importance: #HIGH
},
identification : {position:20}
}
// @Search.defaultSearchElement: true
@Consumption.semanticObject:'ShopFloorRouting'
@EndUserText.label: 'Routing Group'
concat(concat(BillOfOperationsVersion.BillOfOperationsGroup, ('-')), concat(BillOfOperationsVersion.BillOfOperationsVariant, concat(('-'), BillOfOperationsVersion.BillOfOperationsVersion))) as BillOfOperationsDisplayKey,
@UI: {
lineItem:
{
position: 50,
importance: #HIGH
},
identification : {position:50}
}
@EndUserText.label: 'Status'
// @Search.defaultSearchElement: true
BillOfOperationsVersion._BOOVersionStatus._Text[1:Language = $session.system_language].BOOVersionStatusText,
@UI.hidden: true
OpActyWI.OperationActivity,
@UI: {
lineItem:
{
position: 60,
importance: #HIGH
},
identification : {position:60}
}
@ObjectModel.text.element: [ 'Operation' ]
@UI.textArrangement: #TEXT_LAST
@Search.defaultSearchElement: true
@EndUserText.label: 'Operation'
BillOfOperationOpBasic.OperationText,
@UI.hidden: true
cast(BillOfOperationOpBasic.Operation as pph_vornr preserving type) as Operation,
@UI: {
lineItem:
{
position: 70,
importance: #HIGH
},
identification : {position:70}
}
@ObjectModel.text.element: [ 'OpActyNtwkElementExternalID' ]
@UI.textArrangement: #TEXT_LAST
@Search.defaultSearchElement: true
@EndUserText.label: 'Operation Activity'
OAN._OperationActivityText[1:Language = $session.system_language].OperationActivityName,
@UI.hidden: true
OAN.OpActyNtwkElementExternalID,
@UI.hidden: true
BillOfOperationOpBasic.BillOfOperationsType,
//@UI.hidden: true
// @UI: {
// lineItem:
// {
// position: 30,
// importance: #HIGH
// },
// identification : {position:30}
// }
@Search.defaultSearchElement: true
BillOfOperationsVersion.BillOfOperationsVersion
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSOPBASIC",
"I_BILLOFOPERATIONSVERSION",
"I_BOOOPERATIONCHGSTOANBASIC",
"I_BOOSQNCOPERATIONASSGMTCHGST",
"I_BOOVERSIONSTATUS",
"I_BOOVERSIONSTATUSTEXT",
"I_MFGWORKINSTRUCTIONSTDTEXTREF",
"I_OPACTYNTWKELEMENT",
"I_OPACTYWORKINSTRUCTIONASSGMT",
"I_OPERATIONACTIVITYTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/