R_WorkAssgmtAltCostAssgmt

DDL: R_WORKASSGMTALTCOSTASSGMT Type: view_entity BASIC

Alternate Cost Object for Wrk Assignment

R_WorkAssgmtAltCostAssgmt is a Basic CDS View that provides data about "Alternate Cost Object for Wrk Assignment" in SAP S/4HANA. It reads from 2 data sources (wfd_d_alter_cost, I_WorkAssignmentDetail_1) and exposes 15 fields with key fields WorkforceAssignment, SequenceNumber, WorkforceAssgmtStartDate.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
wfd_d_alter_cost _AlternateCost from
I_WorkAssignmentDetail_1 _AssignmentDetails inner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Alternate Cost Object for Wrk Assignment view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignment wfd_d_alter_cost workforce_assgmt_id
KEY SequenceNumber wfd_d_alter_cost seq_no
KEY WorkforceAssgmtStartDate wfd_d_alter_cost start_date
WorkforceAssgmtEndDate wfd_d_alter_cost end_date
IsDefaultValue wfd_d_alter_cost isdefault
AlternateCostPercent wfd_d_alter_cost percentage
costcenterendasCostCenter
BudgetPeriod wfd_d_alter_cost budgetperiod
FunctionalArea wfd_d_alter_cost functionalarea
Fund wfd_d_alter_cost fund
FundsCenter wfd_d_alter_cost fundscenter
GrantID wfd_d_alter_cost grants
ControllingArea I_WorkAssignmentDetail_1 ControllingArea
CompanyCode I_WorkAssignmentDetail_1 CompanyCode
FinancialManagementArea 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Alternate Cost Object for Wrk Assignment'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity R_WorkAssgmtAltCostAssgmt
  as select from wfd_d_alter_cost         as _AlternateCost
    inner join   I_WorkAssignmentDetail_1 as _AssignmentDetails on  _AlternateCost.workforce_assgmt_id = _AssignmentDetails.WorkforceAssignment
                                                                and _AlternateCost.start_date          = _AssignmentDetails.WorkforceAssgmtStartDate
{
  key _AlternateCost.workforce_assgmt_id as WorkforceAssignment,
  key _AlternateCost.seq_no              as SequenceNumber,
  key _AlternateCost.start_date          as WorkforceAssgmtStartDate,
      _AlternateCost.end_date            as WorkforceAssgmtEndDate,
      _AlternateCost.isdefault           as IsDefaultValue,
      _AlternateCost.percentage          as AlternateCostPercent,
      case when _AlternateCost.isdefault  is not initial
           then _AssignmentDetails.CostCenter
           else _AlternateCost.costcenter
           end                           as CostCenter,
      _AlternateCost.budgetperiod        as BudgetPeriod,
      _AlternateCost.functionalarea      as FunctionalArea,
      _AlternateCost.fund                as Fund,
      _AlternateCost.fundscenter         as FundsCenter,
      _AlternateCost.grants              as GrantID,
      _AssignmentDetails.ControllingArea,
      _AssignmentDetails.CompanyCode,
      _AssignmentDetails._CompanyCode.FinancialManagementArea
}
where
  _AlternateCost.block_ind = ' '
















//{

//  key _AlternateCost.workforce_assgmt_id as WorkforceAssignment,

//  key _AlternateCost.seq_no              as SequenceNumber,

//  key _AlternateCost.start_date          as WorkforceAssgmtStartDate,

//      _AlternateCost.end_date            as WorkforceAssgmtEndDate,

//      _AlternateCost.isdefault           as IsDefaultValue,

//      _AlternateCost.percentage          as AlternateCostPercent,

//      _AlternateCost.costcenter          as CostCenter,

//      _AlternateCost.budgetperiod        as BudgetPeriod,

//      _AlternateCost.functionalarea      as FunctionalArea,

//      _AlternateCost.fund                as Fund,

//      _AlternateCost.fundscenter         as FundsCenter,

//      _AlternateCost.grants              as GrantID,

//      _AssignmentDetails.ControllingArea,

//      _AssignmentDetails.CompanyCode,

//      _AssignmentDetails._CompanyCode.FinancialManagementArea

//}

//where

//  _AlternateCost.block_ind = ' '

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_WORKASSIGNMENTDETAIL_1",
"WFD_D_ALTER_COST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More