I_OpActyAllManufacturingUsers

DDL: I_OPACTYALLMANUFACTURINGUSERS SQL: IMPEOAALLMFGUSRS Type: view COMPOSITE Package: MPE_EXEC_COMMON
21 Fields 1 Data Sources 1 Associations

All existing manufacturing users who may perform an OA

I_OpActyAllManufacturingUsers is a Composite CDS View that provides data about "All existing manufacturing users who may perform an OA" in SAP S/4HANA. It reads from 1 data source (P_OpActyAllManufacturingUsers) and exposes 21 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, UserID. It has 1 association to related views. Part of development package MPE_EXEC_COMMON.

Data Sources (1)

SourceAliasJoin Type
P_OpActyAllManufacturingUsers OpActyAllManufacturingUsers from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _UserContactCard $projection.UserID = _UserContactCard.ContactCardID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPEOAALLMFGUSRS view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label All existing manufacturing users who may perform an OA view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_OpActyAllManufacturingUsers OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_OpActyAllManufacturingUsers OpActyNtwkElement Element Number
KEY UserID P_OpActyAllManufacturingUsers UserID User Name
UserDescription
MfgBusinessPartner P_OpActyAllManufacturingUsers MfgBusinessPartner Bus Part
BusinessPartnerUUID P_OpActyAllManufacturingUsers BusinessPartnerUUID UUID
ManufacturingOrder P_OpActyAllManufacturingUsers ManufacturingOrder Order
OpActyNtwkSegmentType P_OpActyAllManufacturingUsers OpActyNtwkSegmentType
WorkCenter P_OpActyAllManufacturingUsers WorkCenter Work Center
Plant P_OpActyAllManufacturingUsers Plant Valuation Area
UserIsOpActyMainWrkCtrMfgUser P_OpActyAllManufacturingUsers UserIsOpActyMainWrkCtrMfgUser
_OpActyNtwkInstance P_OpActyAllManufacturingUsers _OpActyNtwkInstance
_User P_OpActyAllManufacturingUsers _User
_OANSegmentType P_OpActyAllManufacturingUsers _OANSegmentType
_MfgOrder P_OpActyAllManufacturingUsers _MfgOrder
_WorkCenterBySemanticKey P_OpActyAllManufacturingUsers _WorkCenterBySemanticKey
_Plant P_OpActyAllManufacturingUsers _Plant
_OperationActivityWorklistTP P_OpActyAllManufacturingUsers _OperationActivityWorklistTP
_UserOpenOpActyAssignment P_OpActyAllManufacturingUsers _UserOpenOpActyAssignment
_MfgHumRsceQualifnBPAssgmt P_OpActyAllManufacturingUsers _MfgHumRsceQualifnBPAssgmt
_UserContactCard _UserContactCard

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_OpActyAllManufacturingUsers.
-- 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: IMPEOAALLMFGUSRS

CREATE VIEW I_OpActyAllManufacturingUsers AS
SELECT
  OpActyAllManufacturingUsers.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyAllManufacturingUsers.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyAllManufacturingUsers.UserID AS UserID,
  cast(OpActyAllManufacturingUsers._User.UserDescription as mpe_exec_operator_desc preserving type) AS UserDescription,
  OpActyAllManufacturingUsers.MfgBusinessPartner AS MfgBusinessPartner,
  OpActyAllManufacturingUsers.BusinessPartnerUUID AS BusinessPartnerUUID,
  OpActyAllManufacturingUsers.ManufacturingOrder AS ManufacturingOrder,
  OpActyAllManufacturingUsers.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyAllManufacturingUsers.WorkCenter AS WorkCenter,
  OpActyAllManufacturingUsers.Plant AS Plant,
  OpActyAllManufacturingUsers.UserIsOpActyMainWrkCtrMfgUser AS UserIsOpActyMainWrkCtrMfgUser,
  OpActyAllManufacturingUsers._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyAllManufacturingUsers._User AS _User,
  OpActyAllManufacturingUsers._OANSegmentType AS _OANSegmentType,
  OpActyAllManufacturingUsers._MfgOrder AS _MfgOrder,
  OpActyAllManufacturingUsers._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  OpActyAllManufacturingUsers._Plant AS _Plant,
  OpActyAllManufacturingUsers._OperationActivityWorklistTP AS _OperationActivityWorklistTP,
  OpActyAllManufacturingUsers._UserOpenOpActyAssignment AS _UserOpenOpActyAssignment,
  OpActyAllManufacturingUsers._MfgHumRsceQualifnBPAssgmt AS _MfgHumRsceQualifnBPAssgmt
FROM P_OpActyAllManufacturingUsers AS OpActyAllManufacturingUsers
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON UserID = _UserContactCard.ContactCardID  -- association [0..1]
;

Learn More