I_ManufacturingAction

DDL: I_MANUFACTURINGACTION SQL: IMPEACTION Type: view BASIC

Manufacturing Action

I_ManufacturingAction is a Basic CDS View that provides data about "Manufacturing Action" in SAP S/4HANA. It reads from 1 data source (mpe_action) and exposes 13 fields with key field MfgProcgExecAction. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mpe_action act from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ManufacturingActionText _Text $projection.MfgProcgExecAction = _Text.MfgProcgExecAction
[1..1] I_SystemObjectType _ObjectType $projection.MfgObjectType = _ObjectType.MfgObjectType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPEACTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
ObjectModel.representativeKey MfgProcgExecAction view
EndUserText.label Manufacturing Action view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MfgProcgExecAction mpe_action action_name Action
MfgObjectType mpe_action object_type Type
MfgActnIsSuppdByActionHandler mpe_action supports_ahf Supports AHF
MfgActnIsQualifnCheckEnabled mpe_action supports_qualifn_chk Supports Qualification Check
MfgActionIsReasonCodeEnabled mpe_action supports_reason_code Supports Reason Code
MfgActnIsMltplRsnCodeEnabled mpe_action supports_rsn_grp_mltpl
MfgActionReasonCodeGroupCtlg mpe_action katalogart Catalog
MfgActionIsNoteEnabled mpe_action supports_note Supports Note
MfgActnAuthorizationIsChecked mpe_action supports_c_sfo_actn Supports C_SFO_ACTN
MfgActionIsConfigurable mpe_action is_configurable Is Configurable
MfgObjectLogEventType mpe_action reltd_log_event Log Event
_ObjectType _ObjectType
_Text _Text

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 I_ManufacturingAction.
-- 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: IMPEACTION

CREATE VIEW I_ManufacturingAction AS
SELECT
  act.action_name AS MfgProcgExecAction,
  act.object_type AS MfgObjectType,
  act.supports_ahf AS MfgActnIsSuppdByActionHandler,
  act.supports_qualifn_chk AS MfgActnIsQualifnCheckEnabled,
  act.supports_reason_code AS MfgActionIsReasonCodeEnabled,
  act.supports_rsn_grp_mltpl AS MfgActnIsMltplRsnCodeEnabled,
  act.katalogart AS MfgActionReasonCodeGroupCtlg,
  act.supports_note AS MfgActionIsNoteEnabled,
  act.supports_c_sfo_actn AS MfgActnAuthorizationIsChecked,
  act.is_configurable AS MfgActionIsConfigurable,
  act.reltd_log_event AS MfgObjectLogEventType
FROM mpe_action AS act
LEFT OUTER JOIN I_ManufacturingActionText AS _Text ON MfgProcgExecAction = _Text.MfgProcgExecAction  -- association [0..*]
LEFT OUTER JOIN I_SystemObjectType AS _ObjectType ON MfgObjectType = _ObjectType.MfgObjectType  -- association [1..1]
;