P_OPACTYALLMANUFACTURINGUSERS

CDS View
19 Fields 1 CDS Views

P_OPACTYALLMANUFACTURINGUSERS is a CDS View in S/4HANA. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OpActyAllManufacturingUsers view from COMPOSITE All existing manufacturing users who may perform an OA

Fields (19)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 1
KEY OpActyNtwkInstance OpActyNtwkInstance 1
KEY UserID UserID 1
_MfgHumRsceQualifnBPAssgmt _MfgHumRsceQualifnBPAssgmt 1
_MfgOrder _MfgOrder 1
_OANSegmentType _OANSegmentType 1
_OpActyNtwkInstance _OpActyNtwkInstance 1
_OperationActivityWorklistTP _OperationActivityWorklistTP 1
_Plant _Plant 1
_User _User 1
_UserOpenOpActyAssignment _UserOpenOpActyAssignment 1
_WorkCenterBySemanticKey _WorkCenterBySemanticKey 1
BusinessPartnerUUID BusinessPartnerUUID 1
ManufacturingOrder ManufacturingOrder 1
MfgBusinessPartner MfgBusinessPartner 1
OpActyNtwkSegmentType OpActyNtwkSegmentType 1
Plant Plant 1
UserIsOpActyMainWrkCtrMfgUser UserIsOpActyMainWrkCtrMfgUser 1
WorkCenter WorkCenter 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPACTYALLMANUFACTURINGUSERS (
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    USERID,
    _MFGHUMRSCEQUALIFNBPASSGMT,
    _MFGORDER,
    _OANSEGMENTTYPE,
    _OPACTYNTWKINSTANCE,
    _OPERATIONACTIVITYWORKLISTTP,
    _PLANT,
    _USER,
    _USEROPENOPACTYASSIGNMENT,
    _WORKCENTERBYSEMANTICKEY,
    BUSINESSPARTNERUUID,
    MANUFACTURINGORDER,
    MFGBUSINESSPARTNER,
    OPACTYNTWKSEGMENTTYPE,
    PLANT,
    USERISOPACTYMAINWRKCTRMFGUSER,
    WORKCENTER,
    PRIMARY KEY (OPACTYNTWKELEMENT, OPACTYNTWKINSTANCE, USERID)
);

Learn More