C_ManufacturingActionSetting

DDL: C_MANUFACTURINGACTIONSETTING SQL: CMPEACTIONSET Type: view CONSUMPTION
17 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Manufacturing action setting

C_ManufacturingActionSetting is a Consumption CDS View that provides data about "Manufacturing action setting" in SAP S/4HANA. It reads from 1 data source (I_MfgActnSttgWthDummyRecd) and exposes 17 fields with key fields MfgProcgExecAction, MfgObjectType, Plant. It is exposed through 1 OData service (UI_OPACTYSFIGROUP_EXECUTE). It is used in 1 Fiori application: Process Serial Number Groups.

Data Sources (1)

SourceAliasJoin Type
I_MfgActnSttgWthDummyRecd MfgActnSttg from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMPEACTIONSET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view
EndUserText.label Manufacturing action setting view

OData Services (1)

ServiceBindingVersionContractRelease
UI_OPACTYSFIGROUP_EXECUTE UI_OPACTYSFIGROUP_EXECUTE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F6773 Process Serial Number Groups Transactional S/4HANA Manufacturing Production Engineering and Operations (PEO) 2022 FPS0 release offers a new functionality to collectively process any number of serial numbers as a group at an operation activity. The Process Serial Number Groups app allows production operators to create an maintain a group of serial numbers to be processed at an operation activity, execute SAS and some of the non-SAS actions (i.e. Start, Labor On, Complete, Pause, etc.) once for the complete group, view non-traceable components, PRTs and documents assigned to an operation activity as well as keep the activity log recorded for each serial number individually.

Process Serial Number Groups

Business Role: Production Operator - Discrete Manufacturing (Extended Production Operations)

With this app, you can collectively process any number of serial numbers as a group at an operation activity in the segment type Produce. This allows you, for example, to work on standardized serialized products that often need to undergo the same fabrication process. You perform the actions once for the serial number group and the system records the data individually for each serial number in that group. You access this app by executing a serial number group from the My Work Queue app.

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY MfgProcgExecAction I_MfgActnSttgWthDummyRecd MfgProcgExecAction
KEY MfgObjectType I_MfgActnSttgWthDummyRecd MfgObjectType
KEY Plant I_MfgActnSttgWthDummyRecd Plant Valuation Area
MfgActionNoteRequirement I_MfgActnSttgWthDummyRecd MfgActionNoteRequirement
MfgActionSettingNoteType I_MfgActnSttgWthDummyRecd MfgActionSettingNoteType
MfgActionReasonCodeRequirement I_MfgActnSttgWthDummyRecd MfgActionReasonCodeRequirement
MfgActionSettingReasonCodeType I_MfgActnSttgWthDummyRecd MfgActionSettingReasonCodeType
CertificationCheckIsRequired I_MfgActnSttgWthDummyRecd CertificationCheckIsRequired
MfgActionReasonCodeGroupCtlg I_MfgActnSttgWthDummyRecd MfgActionReasonCodeGroupCtlg
MfgActionReasonCodeGroup I_MfgActnSttgWthDummyRecd MfgActionReasonCodeGroup
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_MfgActionNoteRequirement _MfgActionNoteRequirement
_MfgActionReasonCodeGroup _MfgActionReasonCodeGroup
_MfgActionReasonCodeRqmt _MfgActionReasonCodeRqmt
_MfgActionSettingNoteType _MfgActionSettingNoteType
_MfgActionSettingReasonType _MfgActionSettingReasonType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ManufacturingActionSetting.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMPEACTIONSET

CREATE VIEW C_ManufacturingActionSetting AS
SELECT
  MfgActnSttg.MfgProcgExecAction AS MfgProcgExecAction,
  MfgActnSttg.MfgObjectType AS MfgObjectType,
  MfgActnSttg.Plant AS Plant,
  MfgActnSttg.MfgActionNoteRequirement AS MfgActionNoteRequirement,
  MfgActnSttg.MfgActionSettingNoteType AS MfgActionSettingNoteType,
  MfgActnSttg.MfgActionReasonCodeRequirement AS MfgActionReasonCodeRequirement,
  MfgActnSttg.MfgActionSettingReasonCodeType AS MfgActionSettingReasonCodeType,
  MfgActnSttg.CertificationCheckIsRequired AS CertificationCheckIsRequired,
  MfgActnSttg.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  MfgActnSttg.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  LastChangedByUser,
  LastChangeDateTime
FROM I_MfgActnSttgWthDummyRecd AS MfgActnSttg
;

Learn More