I_MfgQualificationTP

DDL: I_MFGQUALIFICATIONTP SQL: IMFGQUALIFN Type: view TRANSACTIONAL Package: MPE_QUALIFICATIONS
10 Fields 1 Data Sources 2 Associations

Display HR Qualifications data

I_MfgQualificationTP is a Transactional CDS View that provides data about "Display HR Qualifications data" in SAP S/4HANA. It reads from 1 data source (I_MfgHumRsceQualification) and exposes 10 fields with key field MfgHumanResourceQualification. It has 2 associations to related views. Part of development package MPE_QUALIFICATIONS.

Data Sources (1)

SourceAliasJoin Type
I_MfgHumRsceQualification Qualification from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MfgQualifnWrkCtrAssgmtTP _WorkCenterAssignment $projection.MfgHumanResourceQualification = _WorkCenterAssignment.MfgHumanResourceQualification
[0..*] I_MfgQualifnMaterialAssgmtTP _MaterialAssignment $projection.MfgHumanResourceQualification = _MaterialAssignment.MfgHumanResourceQualification

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMFGQUALIFN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Display HR Qualifications data view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.writeActivePersistence PMFGQUALIFN view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
AbapCatalog.preserveKey true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MfgHumanResourceQualification I_MfgHumRsceQualification MfgHumanResourceQualification Object ID
MfgHumRsceQualificationDesc I_MfgHumRsceQualification MfgHumRsceQualificationDesc
MfgHumRsceQualificationGroup I_MfgHumRsceQualification MfgHumRsceQualificationGroup
MfgHumRsceQualificationGrpDesc I_MfgHumRsceQualification MfgHumRsceQualificationGrpDesc
MfgHumRsceQualificationCatalog I_MfgHumRsceQualification MfgHumRsceQualificationCatalog
MfgHumRsceQualifnCatalogDesc I_MfgHumRsceQualification MfgHumRsceQualifnCatalogDesc
EndDate I_MfgHumRsceQualification EndDate Term to
MfgHumanRsceQualifnGroupOrCtlg I_MfgHumRsceQualification MfgHumanRsceQualifnGroupOrCtlg
_WorkCenterAssignment _WorkCenterAssignment
_MaterialAssignment _MaterialAssignment

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 I_MfgQualificationTP.
-- 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: IMFGQUALIFN

CREATE VIEW I_MfgQualificationTP AS
SELECT
  Qualification.MfgHumanResourceQualification AS MfgHumanResourceQualification,
  Qualification.MfgHumRsceQualificationDesc AS MfgHumRsceQualificationDesc,
  Qualification.MfgHumRsceQualificationGroup AS MfgHumRsceQualificationGroup,
  Qualification.MfgHumRsceQualificationGrpDesc AS MfgHumRsceQualificationGrpDesc,
  Qualification.MfgHumRsceQualificationCatalog AS MfgHumRsceQualificationCatalog,
  Qualification.MfgHumRsceQualifnCatalogDesc AS MfgHumRsceQualifnCatalogDesc,
  Qualification.EndDate AS EndDate,
  Qualification.MfgHumanRsceQualifnGroupOrCtlg AS MfgHumanRsceQualifnGroupOrCtlg
FROM I_MfgHumRsceQualification AS Qualification
LEFT OUTER JOIN I_MfgQualifnWrkCtrAssgmtTP AS _WorkCenterAssignment ON MfgHumanResourceQualification = _WorkCenterAssignment.MfgHumanResourceQualification  -- association [0..*]
LEFT OUTER JOIN I_MfgQualifnMaterialAssgmtTP AS _MaterialAssignment ON MfgHumanResourceQualification = _MaterialAssignment.MfgHumanResourceQualification  -- association [0..*]
;

Learn More