Which tables does C_MfgOrderObjPgContacts use?

C_MfgOrderObjPgContacts reads from 7 data source(s): I_PMContactCardUser, I_PMContactCardUser, I_IMfgOrderObjPgContacts, I_IMfgOrderObjPgContacts, I_IMfgOrderObjPgContacts, I_MfgOrder, I_MRPController.

C_MfgOrderObjPgContacts

Q: How many fields does C_MfgOrderObjPgContacts have?

C_MfgOrderObjPgContacts has 28 fields. Key fields: InteractionContactType, ManufacturingOrder, UserID, ManufacturingOrder, UserID.

DDL: C_MFGORDEROBJPGCONTACTS Type: view_entity CONSUMPTION

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
KEY	UserID	I_PMContactCardUser	UserID
	ContactCard	I_IMfgOrderObjPgContacts	ContactCard	Role
	FullName	I_PMContactCardUser	FullName
	EmailAddress	I_PMContactCardUser	EmailAddress
	InternationalPhoneNumber	I_PMContactCardUser	InternationalPhoneNumber	Telephone Number
	InternationalMobilePhoneNumber	I_PMContactCardUser	InternationalMobilePhoneNumber	Mobile Phone Number
	AuthorizationGroup	I_PMContactCardUser	AuthorizationGroup
	InteractionContactType
KEY	ManufacturingOrder	I_MfgOrder	ManufacturingOrder
KEY	UserID	I_PMContactCardUser	UserID
	ContactCard	I_IMfgOrderObjPgContacts	ContactCard
	FullName	I_PMContactCardUser	FullName
	EmailAddress	I_PMContactCardUser	EmailAddress
	InternationalPhoneNumber	I_PMContactCardUser	InternationalPhoneNumber
	InternationalMobilePhoneNumber	I_PMContactCardUser	InternationalMobilePhoneNumber
	AuthorizationGroup	I_PMContactCardUser	AuthorizationGroup
	InteractionContactType
KEY	ManufacturingOrder	I_MfgOrder	ManufacturingOrder
KEY	UserID	I_PMContactCardUser	UserID
	ContactCard	I_IMfgOrderObjPgContacts	ContactCard
	FullName	I_PMContactCardUser	FullName
	EmailAddress	I_PMContactCardUser	EmailAddress
	InternationalPhoneNumber	I_PMContactCardUser	InternationalPhoneNumber
	InternationalMobilePhoneNumber	I_PMContactCardUser	InternationalMobilePhoneNumber
	AuthorizationGroup	I_PMContactCardUser	AuthorizationGroup
	IsBusinessPurposeCompleted	I_PMContactCardUser	IsBusinessPurposeCompleted

@EndUserText.label: 'Mfg Order Object Page Contacts'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #L, dataClass: #MIXED}
@UI.headerInfo.typeName: 'ContactInfo'
@UI.headerInfo.typeNamePlural: 'Contact Infos'
@Metadata.ignorePropagatedAnnotations: true

define view entity C_MfgOrderObjPgContacts
  as select from I_PMContactCardUser      as _ContactCardUser
    inner join   I_IMfgOrderObjPgContacts as _ContactType on  _ContactType.InteractionContactType = '01'
                                                          and _ContactType.Language               = $session.system_language

  association [0..1] to I_MfgOrder as _Header on $projection.UserID = _Header.CreatedByUser

{
  key   _ContactType.InteractionContactType,
  key   _Header.ManufacturingOrder, // ProductionOrder,

        @UI.lineItem: [{position:60}]
  key   _ContactCardUser.UserID, // UserId,

        @UI.lineItem: [{position:10}]
        @EndUserText.label: 'Role'
        _ContactType.ContactCard, // Role,

        @UI.lineItem: [{position:20}]
        _ContactCardUser.FullName,                 // ContactName,

        @UI.lineItem: [{position:30}]
        _ContactCardUser.EmailAddress,             // ContactEmail,

        @UI.lineItem: [{position:40}]
        @EndUserText.label: 'Telephone Number'
        _ContactCardUser.InternationalPhoneNumber, // ContactPhone,

        @UI.lineItem: [{position:50}]
        @EndUserText.label: 'Mobile Phone Number'
        _ContactCardUser.InternationalMobilePhoneNumber, // ContactMobilePhone,

        @UI.hidden: true
        _ContactCardUser.AuthorizationGroup,
        @UI.hidden: true
        @Semantics.booleanIndicator 
        _ContactCardUser.IsBusinessPurposeCompleted
}
where
  _ContactCardUser.UserID = _Header.CreatedByUser
union all select from I_PMContactCardUser      as _ContactCardUser
  inner join          I_IMfgOrderObjPgContacts as _ContactType on  _ContactType.InteractionContactType = '02'
                                                               and _ContactType.Language               = $session.system_language
association [0..1] to I_MfgOrder as _Header on $projection.UserID = _Header.LastChangedByUser
{
  key   _ContactType.InteractionContactType,
  key   _Header.ManufacturingOrder, // ProductionOrder,

//        @UI.lineItem: [{position:60}]

  key   _ContactCardUser.UserID, // UserId,

//        @UI.lineItem: [{position:10}]

//        @EndUserText.label: 'Role'

        _ContactType.ContactCard, // Role,

//        @UI.lineItem: [{position:20}]

        _ContactCardUser.FullName,                 // ContactName,

//        @UI.lineItem: [{position:30}]

//        @Semantics.eMail.address: true

        _ContactCardUser.EmailAddress,             // ContactEmail,

//        @UI.lineItem: [{position:40}]

//        @EndUserText.label: 'Telephone Number'

        _ContactCardUser.InternationalPhoneNumber, // ContactPhone,

//        @UI.lineItem: [{position:50}]

//        @EndUserText.label: 'Mobile Phone Number'

        _ContactCardUser.InternationalMobilePhoneNumber, // ContactMobilePhone

//        @UI.hidden: true

        _ContactCardUser.AuthorizationGroup,
//        @UI.hidden: true

        _ContactCardUser.IsBusinessPurposeCompleted
}
where
  _ContactCardUser.UserID = _Header.LastChangedByUser
union all select distinct from I_PMContactCardUser      as _ContactCardUser
  inner join                   I_MRPController          as _MRPController on _ContactCardUser.UserID = _MRPController.UserID
  inner join                   I_MfgOrder               as _Header        on _MRPController.MRPController = _Header.MRPController
  inner join                   I_IMfgOrderObjPgContacts as _ContactType   on  _ContactType.InteractionContactType = '03'
                                                                          and _ContactType.Language               = $session.system_language
{
  key   _ContactType.InteractionContactType,
  key   _Header.ManufacturingOrder, // ProductionOrder,,

//        @UI.lineItem: [{position:60}]

  key   _ContactCardUser.UserID, // UserId,

//        @UI.lineItem: [{position:10}]

//        @EndUserText.label: 'Role'

        _ContactType.ContactCard, // Role,

//        @UI.lineItem: [{position:20}]

        _ContactCardUser.FullName,                 // ContactName,

//        @UI.lineItem: [{position:30}]

        _ContactCardUser.EmailAddress,             // ContactEmail,

//        @UI.lineItem: [{position:40}]

//        @EndUserText.label: 'Telephone Number'

        _ContactCardUser.InternationalPhoneNumber, // ContactPhone,

//        @UI.lineItem: [{position:50}]

//        @EndUserText.label: 'Mobile Phone Number'

        _ContactCardUser.InternationalMobilePhoneNumber, // ContactMobilePhone

//        @UI.hidden: true

        _ContactCardUser.AuthorizationGroup,
//        @UI.hidden: true

        _ContactCardUser.IsBusinessPurposeCompleted
}
where
  _ContactCardUser.UserID = _MRPController.UserID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_IMFGORDEROBJPGCONTACTS",
"I_MFGORDER",
"I_MRPCONTROLLER",
"I_PMCONTACTCARDUSER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_MfgOrderObjPgContacts view_entity