WFD_PremG

DDL: WFD_PREMG SQL: WFDPREMG Type: view

Workforce Domain - Sel view for PREMG

WFD_PremG is a CDS View that provides data about "Workforce Domain - Sel view for PREMG" in SAP S/4HANA. It reads from 3 data sources (I_BusinessPartner, P_WorkforceKeyMapping, WFD_WorkForceAssignment) and exposes 6 fields with key field WorkforceAssignmentID.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_BusinessPartner bupa left_outer
P_WorkforceKeyMapping keymap inner
WFD_WorkForceAssignment wfa from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName WFDPREMG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workforce Domain - Sel view for PREMG view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignmentID WFD_WorkForceAssignment WorkforceAssignmentID
WorkforceAssgmtStartDate WFD_WorkForceAssignment WorkforceAssgmtStartDate
WorkforceAssgmtEndDate WFD_WorkForceAssignment WorkforceAssgmtEndDate
FirstName I_BusinessPartner FirstName
LastName I_BusinessPartner LastName
BirthDate I_BusinessPartner BirthDate 
@AbapCatalog.sqlViewName: 'WFDPREMG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workforce Domain - Sel view for PREMG'

@ObjectModel.usageType.serviceQuality       : #B
@ObjectModel.usageType.sizeCategory         : #L
@ObjectModel.usageType.dataClass            : #MIXED
@AccessControl.personalData.blocking        : #REQUIRED

define view WFD_PremG
  as select from    WFD_WorkForceAssignment as wfa
    inner join      P_WorkforceKeyMapping   as keymap on wfa.WorkforceAssignmentID = keymap.WorkforceAssignmentID
    left outer join I_BusinessPartner       as bupa   on  keymap.BusinessPartner          = bupa.BusinessPartner
                                                      and bupa.IsBusinessPurposeCompleted = ''
{
  key wfa.WorkforceAssignmentID,
      wfa.WorkforceAssgmtStartDate,
      wfa.WorkforceAssgmtEndDate,
      bupa.FirstName,
      bupa.LastName,
      bupa.BirthDate

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"P_WORKFORCEKEYMAPPING",
"WFD_WORKFORCEASSIGNMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More