WFD_PremU

DDL: WFD_PREMU SQL: WFDPREMU Type: view

Workforce Domain - Sel view for PREMU

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

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
I_BusinessUserBasic buus left_outer
P_WorkforceKeyMapping keymap inner
WFD_WorkForceAssignment wfa from

Annotations (9)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignmentID WFD_WorkForceAssignment WorkforceAssignmentID
UserID I_BusinessUserBasic UserID
WorkforceAssgmtStartDate WFD_WorkForceAssignment WorkforceAssgmtStartDate
WorkforceAssgmtEndDate WFD_WorkForceAssignment WorkforceAssgmtEndDate 
@AbapCatalog.sqlViewName: 'WFDPREMU'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workforce Domain - Sel view for PREMU'

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


define view WFD_PremU
  as select from    WFD_WorkForceAssignment as wfa
    inner join      P_WorkforceKeyMapping   as keymap on wfa.WorkforceAssignmentID = keymap.WorkforceAssignmentID
    left outer join I_BusinessUserBasic     as buus   on  keymap.BusinessPartner          = buus.BusinessPartner
                                                      and buus.IsBusinessPurposeCompleted = ''
{
  key wfa.WorkforceAssignmentID,
      buus.UserID,
      wfa.WorkforceAssgmtStartDate,
      wfa.WorkforceAssgmtEndDate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSUSERBASIC",
"P_WORKFORCEKEYMAPPING",
"WFD_WORKFORCEASSIGNMENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More