@AbapCatalog.sqlViewName: 'CMPESASA'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #M, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
define view C_SASAction
as select from P_SASActionAssignment as SASActionAssignment
inner join I_Plant as Plant on Plant.Plant <> SASActionAssignment.Plant
left outer join I_ManufacturingActionSetting as setting on setting.MfgObjectType = SASActionAssignment.StatusAndActionSchemaType
and setting.MfgProcgExecAction = SASActionAssignment.StatusAndActionSchemaAction
and setting.Plant = Plant.Plant
// association [1..1] to I_SASStatusCategoryAssignment as _SASStartStatusCategory on $projection.StatusAndActionSchemaType = _SASStartStatusCategory.StatusAndActionSchemaType
// and $projection.SASActionStartStatus = _SASStartStatusCategory.StatusAndActionSchemaStatus
// association [1..1] to I_SASStatusCategoryAssignment as _SASEndStatusCategory on $projection.StatusAndActionSchemaType = _SASEndStatusCategory.StatusAndActionSchemaType
// and $projection.SASActionEndStatus = _SASEndStatusCategory.StatusAndActionSchemaStatus
association [1..1] to I_SASStatus as _SASStartStatus on $projection.SASActionStartStatus = _SASStartStatus.StatusAndActionSchemaStatus
// association [1..1] to I_SASStatusAssignment as _SASStartStatus on $projection.StatusAndActionSchema = _SASStartStatus.StatusAndActionSchema
// and $projection.SASActionStartStatus = _SASStartStatus.StatusAndActionSchemaStatus
association [1..1] to I_SASStatus as _SASEndStatus on $projection.SASActionEndStatus = _SASEndStatus.StatusAndActionSchemaStatus
// association [1..1] to I_SASStatusAssignment as _SASEndStatus on $projection.StatusAndActionSchema = _SASEndStatus.StatusAndActionSchema
// and $projection.SASActionEndStatus = _SASEndStatus.StatusAndActionSchemaStatus
association [0..*] to I_SASSchemaText as _SASSchemaText on $projection.StatusAndActionSchema = _SASSchemaText.StatusAndActionSchema
association [0..*] to I_SASActionText as _SASActionText on $projection.StatusAndActionSchemaAction = _SASActionText.StatusAndActionSchemaAction
association [0..*] to I_SASStatusText as _SASStartStatusText on $projection.SASActionStartStatus = _SASStartStatusText.StatusAndActionSchemaStatus
association [0..*] to I_SASStatusText as _SASEndStatusText on $projection.SASActionEndStatus = _SASEndStatusText.StatusAndActionSchemaStatus
association [0..*] to C_MfgActionReasonCode as _MfgActionReasonCode on $projection.MfgActionReasonCodeGroup = _MfgActionReasonCode.MfgActionReasonCodeGroup
{
@UI.hidden: true
key SASActionAssignment.StatusAndActionSchema, --sas_name
@UI.identification.position: 10
@UI.statusInfo.position: 10
@UI.lineItem.position: 10
@UI.selectionField.position: 10
@UI.fieldGroup.position: 10
@ObjectModel.text.element: 'SASActionName'
key SASActionAssignment.StatusAndActionSchemaAction, --action_name
@UI.hidden: true
key Plant.Plant, --werks
@UI.hidden: true
SASActionAssignment.StatusAndActionSchemaType, --sas_type
@UI.hidden: true
_SASSchemaText[1: Language=$session.system_language].StatusAndActionSchemaName, --sas_description
@UI.hidden: true
SASActionAssignment.SASActionSequence, --action_icon_screen_sequence
@UI.hidden: true
SASActionAssignment.SASActionStartStatus, --start_status_name
@UI.hidden: true
SASActionAssignment.SASActionEndStatus, --end_status_name
@UI.hidden: true
_SASActionText[1: Language=$session.system_language].SASActionName, --action_description
@UI.hidden: true
_SASStartStatus.SASStatusCategory as SASActionStartStatusCategory, --start_status_category
@UI.hidden: true
_SASEndStatus.SASStatusCategory as SASActionEndStatusCategory, --end_status_category
@UI.hidden: true
_SASStartStatusText[1: Language=$session.system_language].SASStatusName as SASActionStartStatusName, --start_status_description
@UI.hidden: true
_SASEndStatusText[1: Language=$session.system_language].SASStatusName as SASActionEndStatusName, --end_status_description
@UI.hidden: true
_SASStartStatus.SASStatusCriticality as SASActionStrtStatusCriticality, --start_status_criticality
@UI.hidden: true
_SASEndStatus.SASStatusCriticality as SASActionEndStatusCriticality, --end_status_criticality
@ObjectModel.foreignKey.association: '_MfgActionReasonCodeRqmt'
setting.MfgActionReasonCodeRequirement, --reason_type
@ObjectModel.foreignKey.association: '_MfgActionNoteRequirement'
setting.MfgActionNoteRequirement,
setting.MfgActionReasonCodeGroupCtlg,
// @ObjectModel.foreignKey.association: '_MfgActionReasonCodeGroup' --note_type
setting.MfgActionReasonCodeGroup, --reason_code_group
_MfgActionReasonCode,
_MfgActionReasonCodeRqmt,
_MfgActionNoteRequirement,
_MfgActionReasonCodeGroup
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGACTIONSETTING",
"I_PLANT",
"I_SASACTIONTEXT",
"I_SASSCHEMATEXT",
"I_SASSTATUS",
"I_SASSTATUSTEXT",
"P_SASACTIONASSIGNMENT"
],
"ASSOCIATED":
[
"C_MFGACTIONREASONCODE",
"I_MFGACTIONNOTEREQUIREMENT",
"I_MFGACTIONREASONCODEGROUP",
"I_MFGACTIONREASONCODERQMT",
"I_SASACTIONTEXT",
"I_SASSCHEMATEXT",
"I_SASSTATUS",
"I_SASSTATUSTEXT"
],
"BASE":
[
"I_MANUFACTURINGACTIONSETTING"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/