How many fields does C_SASAction have?

C_SASAction has 19 fields. Key fields: StatusAndActionSchema.

C_SASAction

Q: Which tables does C_SASAction use?

C_SASAction reads from 3 data source(s): I_Plant, P_SASActionAssignment, I_ManufacturingActionSetting.

DDL: C_SASACTION SQL: CMPESASA Type: view CONSUMPTION Package: MPE_EXEC_COMMON

Shop Floor Item At Operation Activity

C_SASAction is a Consumption CDS View that provides data about "Shop Floor Item At Operation Activity" in SAP S/4HANA. It reads from 3 data sources (I_Plant, P_SASActionAssignment, I_ManufacturingActionSetting) and exposes 19 fields with key field StatusAndActionSchema. It has 7 associations to related views. It is exposed through 1 OData service (UI_OPACTYSFIGROUP_EXECUTE). Part of development package MPE_EXEC_COMMON.

Data Sources (3)

Source	Alias	Join Type
I_Plant	Plant	inner
P_SASActionAssignment	SASActionAssignment	from
I_ManufacturingActionSetting	setting	left_outer

Associations (7)

Cardinality	Target	Alias	Condition
[1..1]	I_SASStatus	_SASStartStatus	`$projection.SASActionStartStatus = _SASStartStatus.StatusAndActionSchemaStatus`
[1..1]	I_SASStatus	_SASEndStatus	`$projection.SASActionEndStatus = _SASEndStatus.StatusAndActionSchemaStatus`
[0..*]	I_SASSchemaText	_SASSchemaText	`$projection.StatusAndActionSchema = _SASSchemaText.StatusAndActionSchema`
[0..*]	I_SASActionText	_SASActionText	`$projection.StatusAndActionSchemaAction = _SASActionText.StatusAndActionSchemaAction`
[0..*]	I_SASStatusText	_SASStartStatusText	`$projection.SASActionStartStatus = _SASStartStatusText.StatusAndActionSchemaStatus`
[0..*]	I_SASStatusText	_SASEndStatusText	`$projection.SASActionEndStatus = _SASEndStatusText.StatusAndActionSchemaStatus`
[0..*]	C_MfgActionReasonCode	_MfgActionReasonCode	`$projection.MfgActionReasonCodeGroup = _MfgActionReasonCode.MfgActionReasonCodeGroup`

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	CMPESASA	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.compiler.compareFilter	true	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_OPACTYSFIGROUP_EXECUTE	UI_OPACTYSFIGROUP_EXECUTE	V2	C1	NOT_RELEASED

Fields (19)

Key	Field	Source Table	Source Field
KEY	StatusAndActionSchema	P_SASActionAssignment	StatusAndActionSchema
	StatusAndActionSchemaAction
	Plant
	StatusAndActionSchemaType
	StatusAndActionSchemaName
	SASActionSequence
	SASActionStartStatus
	SASActionEndStatus
	SASActionName
	SASStatusNameasSASActionStartStatusName
	SASStatusNameasSASActionEndStatusName
	MfgActionReasonCodeRequirement
	MfgActionNoteRequirement
	MfgActionReasonCodeGroupCtlg	I_ManufacturingActionSetting	MfgActionReasonCodeGroupCtlg
	MfgActionReasonCodeGroup	I_ManufacturingActionSetting	MfgActionReasonCodeGroup
	reason_code_group_MfgActionReasonCode
	_MfgActionReasonCodeRqmt		_MfgActionReasonCodeRqmt
	_MfgActionNoteRequirement		_MfgActionNoteRequirement
	_MfgActionReasonCodeGroup		_MfgActionReasonCodeGroup

@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
};

Depth:

C_SASAction view