P_WFDKEYMAP

DDL: P_WFDKEYMAP SQL: PWFDKEYMAP Type: view BASIC

SDM View for WFD_D_KEYMAP

P_WFDKEYMAP is a Basic CDS View that provides data about "SDM View for WFD_D_KEYMAP" in SAP S/4HANA. It reads from 2 data sources (but000, wfd_d_keymap) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
but000 but000 inner
wfd_d_keymap wfd_d_keymap from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PWFDKEYMAP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.dataMaintenance #NOT_ALLOWED view
EndUserText.label SDM View for WFD_D_KEYMAP view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
worker_id wfd_d_keymap worker_id
create_user but000 crusr 
@AbapCatalog.sqlViewName: 'PWFDKEYMAP'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm : #SESSION_VARIABLE
@AbapCatalog.dataMaintenance: #NOT_ALLOWED
@EndUserText.label: 'SDM View for WFD_D_KEYMAP'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #BASIC
define  view P_WFDKEYMAP as select from wfd_d_keymap 
inner join but000 on but000.partner = wfd_d_keymap.business_partner_id
left outer to one join wfd_d_staging on wfd_d_staging.worker_id = wfd_d_keymap.worker_id
                                     and wfd_d_keymap.worker_id is not initial
{
 key 
     wfd_d_keymap.workforce_assgmt_id as workforce_assignment_id,
     wfd_d_keymap.worker_id as worker_id,
     wfd_d_keymap.business_partner_id as business_partner_id,
     wfd_d_keymap.person_id_external as person_id_external,
     wfd_d_keymap.data_source as data_source_keymap,
     wfd_d_keymap.bp_model_type as bp_model_type,
     wfd_d_staging.data_source as data_source_staging,
     but000.chusr as last_changed_user,
     but000.crusr as create_user,
      
 cast( case when wfd_d_keymap.data_source <> '' and wfd_d_keymap.bp_model_type <> '' then '01' 
        else         '00' 
       end as sdm_status_value_done )  as IsConversionDone
} where wfd_d_keymap.business_partner_id is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BUT000",
"WFD_D_KEYMAP",
"WFD_D_STAGING"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More