WFD_PremK

DDL: WFD_PREMK SQL: WFDPREMK Type: view

Workforce Domain - Sel view for PREMK

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

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_BusinessPartner bupa left_outer
WFD_WorkForceAssignmentDetails details from
P_WorkforceKeyMapping keymap inner

Annotations (9)

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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignmentID WFD_WorkForceAssignmentDetails WorkforceAssignmentID
PersonFullName I_BusinessPartner PersonFullName
FirstName I_BusinessPartner FirstName
LastName I_BusinessPartner LastName
CompanyCode WFD_WorkForceAssignmentDetails CompanyCode
CostCenter WFD_WorkForceAssignmentDetails CostCenter
ControllingArea WFD_WorkForceAssignmentDetails ControllingArea 
@AbapCatalog.sqlViewName: 'WFDPREMK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workforce Domain - Sel view for PREMK'

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

define view WFD_PremK
  as select from    WFD_WorkForceAssignmentDetails as details
    inner join      P_WorkforceKeyMapping          as keymap on details.WorkforceAssignmentID = keymap.WorkforceAssignmentID
    left outer join I_BusinessPartner              as bupa   on  keymap.BusinessPartner          = bupa.BusinessPartner
                                                             and bupa.IsBusinessPurposeCompleted = ''
{
  key details.WorkforceAssignmentID,
      bupa.PersonFullName,
      bupa.FirstName,
      bupa.LastName,
      details.CompanyCode,
      details.CostCenter,
      details.ControllingArea
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"P_WORKFORCEKEYMAPPING",
"WFD_WORKFORCEASSIGNMENTDETAILS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More