I_WORKASSIGNMENTALTCOST
Alternate Cost Objects for Work Assignment
I_WORKASSIGNMENTALTCOST is a CDS View in S/4HANA. Alternate Cost Objects for Work Assignment. It contains 13 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_WorkAssignmentAltCost | view_entity | from | COMPOSITE | Alternate Cost Objects for Work Assignment |
Fields (13)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SequenceNumber | SequenceNumber | 1 |
| KEY | WorkforceAssgmtStartDate | WorkAssignmentStartDate,WorkforceAssgmtStartDate | 1 |
| AlternateCostPercent | AlternateCostPercent | 1 | |
| ControllingArea | ControllingArea | 1 | |
| FinancialManagementArea | FinancialManagementArea | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Fund | Fund | 1 | |
| GrantID | GrantID | 1 | |
| IsBlocked | IsBlocked | 1 | |
| IsDefaultValue | IsDefaultValue,OrganizationalAssignment | 1 | |
| WBSElementExternalID | WBSElementExternalID | 1 | |
| WorkforceAssgmtEndDate | WorkAssignmentEndDate,WorkforceAssgmtEndDate | 1 | |
| WorkforceAssignment | WorkAssignment | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Alternate Cost Objects for Work Assignment'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
define view entity I_WorkAssignmentAltCost
as select from P_WrkAssgmtAlternateCostCenter as _AlternateCost
inner join I_WorkAssignmentDetail_1 as _AssignmentDetails on _AlternateCost.WorkforceAssignment = _AssignmentDetails.WorkforceAssignment
and(
_AlternateCost.WorkforceAssgmtStartDate >= _AssignmentDetails.WorkforceAssgmtStartDate
and _AlternateCost.WorkforceAssgmtStartDate <= _AssignmentDetails.WorkforceAssgmtEndDate
){
key _AlternateCost.WorkforceAssignment,
key _AlternateCost.SequenceNumber,
key _AlternateCost.WorkforceAssgmtStartDate,
_AlternateCost.WorkforceAssgmtEndDate,
_AlternateCost.IsDefaultValue,
_AlternateCost.AlternateCostPercent,
_AlternateCost.CostCenter,
_AlternateCost.BudgetPeriod,
_AlternateCost.FunctionalArea,
_AlternateCost.Fund,
_AlternateCost.FundsCenter,
_AlternateCost.GrantID,
_AlternateCost.WBSElementExternalID,
_AlternateCost.IsBlocked as IsBlocked,
_AssignmentDetails.ControllingArea,
_AssignmentDetails.CompanyCode,
_AssignmentDetails._CompanyCode.FinancialManagementArea
}