C_MfgHumRsceQualifnBP

DDL: C_MFGHUMRSCEQUALIFNBP SQL: CMFGHUMRSQLBP Type: view CONSUMPTION Package: MPE_EXEC_COMMON
27 Fields 1 Data Sources 3 Associations

Qualifications assigned to User

C_MfgHumRsceQualifnBP is a Consumption CDS View that provides data about "Qualifications assigned to User" in SAP S/4HANA. It reads from 1 data source (I_MfgHumRsceQualifnBP) and exposes 27 fields with key fields MfgHumanResourceQualification, MfgBusinessPartner, ValidityStartDate, ValidityEndDate. It has 3 associations to related views. Part of development package MPE_EXEC_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_MfgHumRsceQualifnBP _MfgHumRsceQualifnBP from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MfgHumRsceQualifnRqdSkillLvl _SkillLvlTxt $projection.MfgHumanRsceQualifnGroupOrCtlg = _SkillLvlTxt.MfgHumanRsceQualifnGroupOrCtlg and $projection.MfgQualifnRqdSkillLevelRating = _SkillLvlTxt.MfgQualifnRqdSkillLevelRating
[0..*] I_MfgValidityStatusText _ValidityStatus $projection.MfgQualifnValidityStatus = _ValidityStatus.MfgValidityStatus
[1..1] C_MfgOperatorDetail _Detail $projection.MfgBusinessPartner = _Detail.MfgBusinessPartner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMFGHUMRSQLBP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Qualifications assigned to User view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MfgHumanResourceQualification I_MfgHumRsceQualifnBP MfgHumanResourceQualification Qualification
KEY MfgBusinessPartner I_MfgHumRsceQualifnBP MfgBusinessPartner Bus Part
KEY ValidityStartDate I_MfgHumRsceQualifnBP ValidityStartDate Validity
KEY ValidityEndDate I_MfgHumRsceQualifnBP ValidityEndDate ValidTo
MfgHumRsceQualificationDesc I_MfgHumRsceQualifnBP MfgHumRsceQualificationDesc Text
MfgHumRsceQualifnObjectType I_MfgHumRsceQualifnBP MfgHumRsceQualifnObjectType Rel.obj.type
FirstName I_MfgHumRsceQualifnBP FirstName First Name
LastName I_MfgHumRsceQualifnBP LastName Last Name
BusinessPartnerName I_MfgHumRsceQualifnBP BusinessPartnerName Extracted Customer Name
MfgQualifnRqdSkillLevelRating I_MfgHumRsceQualifnBP MfgQualifnRqdSkillLevelRating Proficiency
MfgQualifnRqdSkillLevelDesc _SkillLvlTxt MfgQualifnRqdSkillLevelDesc
MfgHumanRsceQualifnGroupOrCtlg I_MfgHumRsceQualifnBP MfgHumanRsceQualifnGroupOrCtlg Catalog
DataControllerSet I_MfgHumRsceQualifnBP DataControllerSet Data Ctrlr. Set
DataController1 I_MfgHumRsceQualifnBP DataController1 Data Controller
DataController2 I_MfgHumRsceQualifnBP DataController2 Data Controller
DataController3 I_MfgHumRsceQualifnBP DataController3 Data Controller
DataController4 I_MfgHumRsceQualifnBP DataController4 Data Controller
DataController5 I_MfgHumRsceQualifnBP DataController5 Data Controller
DataController6 I_MfgHumRsceQualifnBP DataController6 Data Controller
DataController7 I_MfgHumRsceQualifnBP DataController7 Data Controller
DataController8 I_MfgHumRsceQualifnBP DataController8 Data Controller
DataController9 I_MfgHumRsceQualifnBP DataController9 Data Controller
DataController10 I_MfgHumRsceQualifnBP DataController10 Data Controller
_ValidityStatus _ValidityStatus
IsBusinessPurposeCompleted I_MfgHumRsceQualifnBP IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup I_MfgHumRsceQualifnBP AuthorizationGroup AuthorizGroup
_Detail _Detail

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_MfgHumRsceQualifnBP.
-- 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.
-- SQL view name: CMFGHUMRSQLBP

CREATE VIEW C_MfgHumRsceQualifnBP AS
SELECT
  _MfgHumRsceQualifnBP.MfgHumanResourceQualification AS MfgHumanResourceQualification,
  _MfgHumRsceQualifnBP.MfgBusinessPartner AS MfgBusinessPartner,
  _MfgHumRsceQualifnBP.ValidityStartDate AS ValidityStartDate,
  _MfgHumRsceQualifnBP.ValidityEndDate AS ValidityEndDate,
  _MfgHumRsceQualifnBP.MfgHumRsceQualificationDesc AS MfgHumRsceQualificationDesc,
  _MfgHumRsceQualifnBP.MfgHumRsceQualifnObjectType AS MfgHumRsceQualifnObjectType,
  _MfgHumRsceQualifnBP.FirstName AS FirstName,
  _MfgHumRsceQualifnBP.LastName AS LastName,
  _MfgHumRsceQualifnBP.BusinessPartnerName AS BusinessPartnerName,
  _MfgHumRsceQualifnBP.MfgQualifnRqdSkillLevelRating AS MfgQualifnRqdSkillLevelRating,
  _SkillLvlTxt.MfgQualifnRqdSkillLevelDesc AS MfgQualifnRqdSkillLevelDesc,
  _MfgHumRsceQualifnBP.MfgHumanRsceQualifnGroupOrCtlg AS MfgHumanRsceQualifnGroupOrCtlg,
  _MfgHumRsceQualifnBP.DataControllerSet AS DataControllerSet,
  _MfgHumRsceQualifnBP.DataController1 AS DataController1,
  _MfgHumRsceQualifnBP.DataController2 AS DataController2,
  _MfgHumRsceQualifnBP.DataController3 AS DataController3,
  _MfgHumRsceQualifnBP.DataController4 AS DataController4,
  _MfgHumRsceQualifnBP.DataController5 AS DataController5,
  _MfgHumRsceQualifnBP.DataController6 AS DataController6,
  _MfgHumRsceQualifnBP.DataController7 AS DataController7,
  _MfgHumRsceQualifnBP.DataController8 AS DataController8,
  _MfgHumRsceQualifnBP.DataController9 AS DataController9,
  _MfgHumRsceQualifnBP.DataController10 AS DataController10,
  _MfgHumRsceQualifnBP.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _MfgHumRsceQualifnBP.AuthorizationGroup AS AuthorizationGroup
FROM I_MfgHumRsceQualifnBP AS _MfgHumRsceQualifnBP
LEFT OUTER JOIN I_MfgHumRsceQualifnRqdSkillLvl AS _SkillLvlTxt ON MfgHumanRsceQualifnGroupOrCtlg = _SkillLvlTxt.MfgHumanRsceQualifnGroupOrCtlg AND MfgQualifnRqdSkillLevelRating = _SkillLvlTxt.MfgQualifnRqdSkillLevelRating  -- association [0..1]
LEFT OUTER JOIN I_MfgValidityStatusText AS _ValidityStatus ON MfgQualifnValidityStatus = _ValidityStatus.MfgValidityStatus  -- association [0..*]
LEFT OUTER JOIN C_MfgOperatorDetail AS _Detail ON MfgBusinessPartner = _Detail.MfgBusinessPartner  -- association [1..1]
;

Learn More