C_MfgExecutionUserVH

DDL: C_MFGEXECUTIONUSERVH Type: view_entity CONSUMPTION
18 Fields 1 Data Sources

Manufacturing execution user

C_MfgExecutionUserVH is a Consumption CDS View that provides data about "Manufacturing execution user" in SAP S/4HANA. It reads from 1 data source (I_MfgBusinessPartner) and exposes 18 fields with key field MfgBusinessPartner.

Data Sources (1)

SourceAliasJoin Type
I_MfgBusinessPartner I_MfgBusinessPartner from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Manufacturing execution user view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey MfgBusinessPartner view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MfgBusinessPartner MfgBusinessPartner Bus Part
UserDescription _User UserDescription Full Name
WorkCenter WorkCenter Work Center
Plant Plant Valuation Area
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
UserID _User UserID User Name
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup AuthorizationGroup AuthorizGroup
BusinessPartnerRole BusinessPartnerRole BP Role
BusinessPartnerUUID BusinessPartnerUUID UUID
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
FirstName FirstName First Name
LastName LastName Last Name
_BusinessPartner _BusinessPartner

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_MfgExecutionUserVH.
-- 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_MfgExecutionUserVH AS
SELECT
  MfgBusinessPartner,
  _User.UserDescription AS UserDescription,
  WorkCenter,
  Plant,
  CreatedByUser,
  CreationDateTime,
  LastChangeDateTime,
  LastChangedByUser,
  _User.UserID AS UserID,
  IsBusinessPurposeCompleted,
  AuthorizationGroup,
  BusinessPartnerRole,
  BusinessPartnerUUID,
  BusinessPartner,
  BusinessPartnerName,
  FirstName,
  LastName
FROM I_MfgBusinessPartner
;

Learn More