C_OpActyAllManufacturingUsers

DDL: C_OPACTYALLMANUFACTURINGUSERS Type: view CONSUMPTION
25 Fields 1 Data Sources 1 Associations

All existing manufacturing users who may perform an OA

C_OpActyAllManufacturingUsers is a Consumption 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 (I_OpActyAllManufacturingUsers) and exposes 25 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, UserID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_OpActyAllManufacturingUsers OpActyAllManufacturingUsers from

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_MfgHumRsceQualifnBP _MfgHumRsceQualifnBP $projection.MfgBusinessPartner = _MfgHumRsceQualifnBP.MfgBusinessPartner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMPEOAALLMFGUSRS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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 #CONSUMPTION view
EndUserText.label All existing manufacturing users who may perform an OA view
Metadata.allowExtensions true view

Fields (25)

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

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_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.

CREATE VIEW C_OpActyAllManufacturingUsers AS
SELECT
  OpActyAllManufacturingUsers.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyAllManufacturingUsers.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyAllManufacturingUsers.UserID AS UserID,
  OpActyAllManufacturingUsers.UserDescription AS UserDescription,
  OpActyAllManufacturingUsers.MfgBusinessPartner AS MfgBusinessPartner,
  OpActyAllManufacturingUsers.BusinessPartnerUUID AS BusinessPartnerUUID,
  OpActyAllManufacturingUsers.ManufacturingOrder AS ManufacturingOrder,
  OpActyAllManufacturingUsers.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyAllManufacturingUsers.WorkCenter AS WorkCenter,
  OpActyAllManufacturingUsers._WorkCenterBySemanticKey._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  OpActyAllManufacturingUsers.Plant AS Plant,
  OpActyAllManufacturingUsers.NrOfUsrOpnOpActyAssignments AS NrOfUsrOpnOpActyAssignments,
  OpActyAllManufacturingUsers.UserIsOpActyMainWrkCtrMfgUser AS UserIsOpActyMainWrkCtrMfgUser,
  cast('' as mpe_user_is_qualified preserving type) AS UserIsQualified,
  OpActyAllManufacturingUsers._MfgHumRsceQualifnBPAssgmt AS _MfgHumRsceQualifnBPAssgmt,
  OpActyAllManufacturingUsers._MfgOrder AS _MfgOrder,
  OpActyAllManufacturingUsers._OANSegmentType AS _OANSegmentType,
  OpActyAllManufacturingUsers._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyAllManufacturingUsers._OperationActivityWorklistTP AS _OperationActivityWorklistTP,
  OpActyAllManufacturingUsers._Plant AS _Plant,
  OpActyAllManufacturingUsers._User AS _User,
  OpActyAllManufacturingUsers._UserContactCard AS _UserContactCard,
  OpActyAllManufacturingUsers._UserOpenOpActyAssignment AS _UserOpenOpActyAssignment,
  OpActyAllManufacturingUsers._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey
FROM I_OpActyAllManufacturingUsers AS OpActyAllManufacturingUsers
LEFT OUTER JOIN C_MfgHumRsceQualifnBP AS _MfgHumRsceQualifnBP ON MfgBusinessPartner = _MfgHumRsceQualifnBP.MfgBusinessPartner  -- association [1..*]
;

Learn More