R_WorkAssgmtAltCostAssgmt

DDL: R_WORKASSGMTALTCOSTASSGMT Type: view_entity BASIC
15 Fields 2 Data Sources

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.

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 WorkForce Assgmt ID
KEY SequenceNumber wfd_d_alter_cost seq_no Value Number
KEY WorkforceAssgmtStartDate wfd_d_alter_cost start_date Valn start date
WorkforceAssgmtEndDate wfd_d_alter_cost end_date Valn End date
IsDefaultValue wfd_d_alter_cost isdefault Default
AlternateCostPercent wfd_d_alter_cost percentage Well Contribution Percentage
costcenterendasCostCenter
BudgetPeriod wfd_d_alter_cost budgetperiod Budget Period
FunctionalArea wfd_d_alter_cost functionalarea Sendr Fctl Area
Fund wfd_d_alter_cost fund Sender Fund
FundsCenter wfd_d_alter_cost fundscenter Funds Center
GrantID wfd_d_alter_cost grants Grant
ControllingArea I_WorkAssignmentDetail_1 ControllingArea Controlling Area
CompanyCode I_WorkAssignmentDetail_1 CompanyCode Receiver Company Code
FinancialManagementArea

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_WorkAssgmtAltCostAssgmt.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_WorkAssgmtAltCostAssgmt AS
SELECT
  _AlternateCost.workforce_assgmt_id AS WorkforceAssignment,
  _AlternateCost.seq_no AS SequenceNumber,
  _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 AS costcenterendasCostCenter,
  _AlternateCost.budgetperiod AS BudgetPeriod,
  _AlternateCost.functionalarea AS FunctionalArea,
  _AlternateCost.fund AS Fund,
  _AlternateCost.fundscenter AS FundsCenter,
  _AlternateCost.grants AS GrantID,
  _AssignmentDetails.ControllingArea AS ControllingArea,
  _AssignmentDetails.CompanyCode AS CompanyCode,
  _AssignmentDetails._CompanyCode.FinancialManagementArea AS FinancialManagementArea
FROM wfd_d_alter_cost AS _AlternateCost
INNER JOIN I_WorkAssignmentDetail_1 AS _AssignmentDetails ON /* join condition not captured in parsed metadata */
;

Learn More