C_MfgQualifnWrkCtrAssgmtTP

Consumption View for Work Center Assignment | view: CQUALWCASSGMT | TRAN | Extraction: Not supported | Component: Certification

Tables used: T499S, HRP1033, T77TP, HRP1000, HRP1001, MPE_QUAL_E_WC, CRHD, HRP1000, HRP1001, T77S0, HRP1000, HRP1001

🔑 Keys (3)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical
Other (5)
🔗 Relations (8)

Column Name	Description
MfgHumanResourceQualification	HR Qualification
WorkCenterTypeCode FK	Object types of the CIM resource	Show values
WorkCenterInternalID FK	Object ID of the resource

Column Name	Description

Column Name	Description

Column Name	Description
CreationDate	Start Date
EndDate	End Date

Column Name	Description

Column Name	Description	Domain name
WorkCenter	Work Center	ARBPL
WorkCenterLocationName	Location Name	TEXT40
MfgQualifnRqdSkillLevelDesc	Qualification Required Skill Level	TEXT40
MfgQualifnRequiredSkillLevel	Proficiency of a Quality Scale	CHARA
MfgHumanRsceQualifnGroupOrCtlg	ID of Related Object	CHAR45

Master Data Relations	Join Conditions
Plant Client Plant Plant	`C_MFGQUALIFNWRKCTRASSGMTTP.MANDT == T001W.MANDT` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERPLANT == T001W.WERKS` `C_MFGQUALIFNWRKCTRASSGMTTP.PLANT == T001W.WERKS`
Production Supply Area Client Production Supply Area Plant Plant	`C_MFGQUALIFNWRKCTRASSGMTTP.MANDT == PVBE.MANDT` `C_MFGQUALIFNWRKCTRASSGMTTP.SUPPLYAREA == PVBE.PRVBE` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERPLANT == PVBE.WERKS` `C_MFGQUALIFNWRKCTRASSGMTTP.PLANT == PVBE.WERKS`
Work Center Category Client Work Center Category	`C_MFGQUALIFNWRKCTRASSGMTTP.MANDT == TC30.MANDT` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERCATEGORYCODE == TC30.VERWE`
Object ID of the resource Object ID of the resource Object types of the CIM resource Client	`C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERINTERNALID == CRHD.OBJID` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERTYPECODE == CRHD.OBJTY` `C_MFGQUALIFNWRKCTRASSGMTTP.MANDT == CRHD.MANDT`
Work center location Client Work center location Plant Plant	`C_MFGQUALIFNWRKCTRASSGMTTP.MANDT == T499S.MANDT` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERLOCATION == T499S.STAND` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERPLANT == T499S.WERKS` `C_MFGQUALIFNWRKCTRASSGMTTP.PLANT == T499S.WERKS`
Plant Client Plant Plant	`C_MFGQUALIFNWRKCTRASSGMTTP.MANDT == T001W.MANDT` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERPLANT == T001W.WERKS` `C_MFGQUALIFNWRKCTRASSGMTTP.PLANT == T001W.WERKS`
Object types of the CIM resource Object ID of the resource Object types of the CIM resource Client	`C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERINTERNALID == CRHD.OBJID` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERTYPECODE == CRHD.OBJTY` `C_MFGQUALIFNWRKCTRASSGMTTP.MANDT == CRHD.MANDT`
Work Center Usage in Bill of Operations Client Work Center Usage in Bill of Operations	`C_MFGQUALIFNWRKCTRASSGMTTP.MANDT == TC23.MANDT` `C_MFGQUALIFNWRKCTRASSGMTTP.WORKCENTERUSAGE == TC23.PLANV`