What is C_MfgOrderObjPgContacts in SAP S/4HANA?

C_MfgOrderObjPgContacts is a consumption CDS view in SAP S/4HANA. Mfg Order Object Page Contacts It contains 28 fields.

Which tables does C_MfgOrderObjPgContacts read from?

C_MfgOrderObjPgContacts reads data from: I_PMContactCardUser, I_PMContactCardUser, I_IMfgOrderObjPgContacts, I_IMfgOrderObjPgContacts, I_IMfgOrderObjPgContacts and more.

What VDM layer is C_MfgOrderObjPgContacts?

C_MfgOrderObjPgContacts is classified as a Consumption view optimized for specific business scenarios and reporting.

C_MfgOrderObjPgContacts

DDL: C_MFGORDEROBJPGCONTACTS Type: view_entity CONSUMPTION

28 Fields 7 Data Sources 1 Associations

Mfg Order Object Page Contacts

C_MfgOrderObjPgContacts is a Consumption CDS View that provides data about "Mfg Order Object Page Contacts" in SAP S/4HANA. It reads from 7 data sources and exposes 28 fields with key fields InteractionContactType, ManufacturingOrder, UserID, ManufacturingOrder, UserID. It has 1 association to related views.

Data Sources (7)

Source	Alias	Join Type
I_PMContactCardUser	_ContactCardUser	from
I_PMContactCardUser	_ContactCardUser	union_all
I_IMfgOrderObjPgContacts	_ContactType	inner
I_IMfgOrderObjPgContacts	_ContactType	inner
I_IMfgOrderObjPgContacts	_ContactType	inner
I_MfgOrder	_Header	inner
I_MRPController	_MRPController	inner

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_MfgOrder	_Header	`$projection.UserID = _Header.CreatedByUser`

Annotations (10)

Name	Value	Level
EndUserText.label	Mfg Order Object Page Contacts	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
UI.headerInfo.typeName	ContactInfo	view
UI.headerInfo.typeNamePlural	Contact Infos	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (28)

Key	Field	Source Table	Source Field	Description
KEY	InteractionContactType	I_IMfgOrderObjPgContacts	InteractionContactType
KEY	ManufacturingOrder	I_MfgOrder	ManufacturingOrder	Order
KEY	UserID	I_PMContactCardUser	UserID	User Name
	ContactCard	I_IMfgOrderObjPgContacts	ContactCard	Role
	FullName	I_PMContactCardUser	FullName	Name
	EmailAddress	I_PMContactCardUser	EmailAddress	E-Mail Address
	InternationalPhoneNumber	I_PMContactCardUser	InternationalPhoneNumber	Telephone Number
	InternationalMobilePhoneNumber	I_PMContactCardUser	InternationalMobilePhoneNumber	Mobile Phone Number
	AuthorizationGroup	I_PMContactCardUser	AuthorizationGroup	AuthorizGroup
	InteractionContactType
KEY	ManufacturingOrder	I_MfgOrder	ManufacturingOrder	Order
KEY	UserID	I_PMContactCardUser	UserID	User Name
	ContactCard	I_IMfgOrderObjPgContacts	ContactCard
	FullName	I_PMContactCardUser	FullName	Name
	EmailAddress	I_PMContactCardUser	EmailAddress	E-Mail Address
	InternationalPhoneNumber	I_PMContactCardUser	InternationalPhoneNumber	Telephone no.
	InternationalMobilePhoneNumber	I_PMContactCardUser	InternationalMobilePhoneNumber	Telephone no.
	AuthorizationGroup	I_PMContactCardUser	AuthorizationGroup	AuthorizGroup
	InteractionContactType
KEY	ManufacturingOrder	I_MfgOrder	ManufacturingOrder	Order
KEY	UserID	I_PMContactCardUser	UserID	User Name
	ContactCard	I_IMfgOrderObjPgContacts	ContactCard
	FullName	I_PMContactCardUser	FullName	Name
	EmailAddress	I_PMContactCardUser	EmailAddress	E-Mail Address
	InternationalPhoneNumber	I_PMContactCardUser	InternationalPhoneNumber	Telephone no.
	InternationalMobilePhoneNumber	I_PMContactCardUser	InternationalMobilePhoneNumber	Telephone no.
	AuthorizationGroup	I_PMContactCardUser	AuthorizationGroup	AuthorizGroup
	IsBusinessPurposeCompleted	I_PMContactCardUser	IsBusinessPurposeCompleted	Purpose Completed

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_MfgOrderObjPgContacts.
-- 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_MfgOrderObjPgContacts AS
SELECT
  _ContactType.InteractionContactType AS InteractionContactType,
  _Header.ManufacturingOrder AS ManufacturingOrder,
  _ContactCardUser.UserID AS UserID,
  _ContactType.ContactCard AS ContactCard,
  _ContactCardUser.FullName AS FullName,
  _ContactCardUser.EmailAddress AS EmailAddress,
  _ContactCardUser.InternationalPhoneNumber AS InternationalPhoneNumber,
  _ContactCardUser.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  _ContactCardUser.AuthorizationGroup AS AuthorizationGroup,
  _ContactCardUser.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_PMContactCardUser AS _ContactCardUser
INNER JOIN I_IMfgOrderObjPgContacts AS _ContactType ON /* join condition not captured in parsed metadata */
INNER JOIN I_MRPController AS _MRPController ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrder AS _Header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MfgOrder AS _Header ON UserID = _Header.CreatedByUser  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PMContactCardUser
;

Depth:

C_MfgOrderObjPgContacts view_entity