I_MfgQualificationGroup

DDL: I_MFGQUALIFICATIONGROUP SQL: IMFGQUALGRP Type: view BASIC

Display HR Qualification Group and its Catalog

I_MfgQualificationGroup is a Basic CDS View that provides data about "Display HR Qualification Group and its Catalog" in SAP S/4HANA. It reads from 3 data sources (hrp1000, hrp1001, t77s0) and exposes 3 fields with key field MfgHumRsceQualificationGroup.

3 data source(s) 3 fields

Data Sources (3)

SourceAliasJoin Type
hrp1000 CatalogDetail inner
hrp1001 QualificationGroup from
t77s0 SystemTable inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMFGQUALGRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Display HR Qualification Group and its Catalog view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY MfgHumRsceQualificationGroup hrp1001 objid
MfgHumRsceQualificationCatalog hrp1001 sobid
MfgHumRsceQualifnCatalogDesc hrp1000 stext 
@AbapCatalog.sqlViewName: 'IMFGQUALGRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Display HR Qualification Group and its Catalog'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_MfgQualificationGroup
  as select from hrp1001 as QualificationGroup
    inner join   t77s0   as SystemTable   on  SystemTable.grpid = 'PLOGI'
                                          and SystemTable.semid = 'PLOGI'
                                          and SystemTable.gsval = QualificationGroup.plvar
    inner join   hrp1000 as CatalogDetail on  CatalogDetail.plvar = QualificationGroup.plvar
                                          and CatalogDetail.objid = QualificationGroup.sobid
                                          and CatalogDetail.otype = 'QK'
                                          and CatalogDetail.langu = $session.system_language
{
  key QualificationGroup.objid as MfgHumRsceQualificationGroup,
      QualificationGroup.sobid as MfgHumRsceQualificationCatalog,
      CatalogDetail.stext      as MfgHumRsceQualifnCatalogDesc
}
where
      QualificationGroup.otype = 'QK'
  and QualificationGroup.sclas = 'QK'
  and QualificationGroup.rsign = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRP1000",
"HRP1001",
"T77S0"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More