P_WORKASSIGNMENTALTERNATECOST

CDS View

Private View for Alternate Cost Assgmts

P_WORKASSIGNMENTALTERNATECOST is a CDS View in S/4HANA. Private View for Alternate Cost Assgmts. It contains 5 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 5 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_FunctionalAreaHrMaster view inner BASIC HR Master for Funtional Area
I_FundHrMaster view inner BASIC HR Master for Fund
I_GrantHrMaster view inner BASIC HR Master for Grant
I_WorkAssignmentAlternateCost view_entity from COMPOSITE Alternative cost for work assignment

Fields (5)

KeyField CDS FieldsUsed in Views
KEY FunctionalArea FunctionalArea 1
KEY Fund Fund 1
KEY GrantID GrantID 1
WorkforceAssgmtEndDate ValidityEndDate 3
WorkforceAssgmtStartDate ValidityStartDate 3 
@AbapCatalog.sqlViewName: 'PWRKASSMTALTCOST'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Private View for Alternate Cost Assgmts'
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED

@ObjectModel.usageType.sizeCategory         : #M
@ObjectModel.usageType.serviceQuality       : #A
define view P_WorkAssignmentAlternateCost
  as select from wfd_d_alter_cost
{

  key workforce_assgmt_id as WorkforceAssignment,
  key seq_no              as SequenceNumber,
  key start_date          as WorkforceAssgmtStartDate,
      end_date            as WorkforceAssgmtEndDate,
      isdefault           as IsDefaultValue,
      percentage          as AlternateCostPercent,
      costcenter          as CostCenter,
      budgetperiod        as BudgetPeriod,
      functionalarea      as FunctionalArea,
      fund                as Fund,
      fundscenter         as FundsCenter,
      grants              as GrantID,
      wbs                 as WBSElementExternalID

}
where
  block_ind = ' '

Learn More