R_WorkAssgmtAltCostAssgmtUnion

DDL: R_WORKASSGMTALTCOSTASSGMTUNION Type: view_entity COMPOSITE Package: ODATA_CA_BUM_WF
17 Fields 2 Data Sources 1 Associations

Alt Cost Assgmnts at Wrk Assignmnt

R_WorkAssgmtAltCostAssgmtUnion is a Composite CDS View that provides data about "Alt Cost Assgmnts at Wrk Assignmnt" in SAP S/4HANA. It reads from 2 data sources (R_WorkAssgmtAltCostAssgmt, R_WorkAssignmentBP) and exposes 17 fields with key fields WorkAssignmentUUID, WorkAssignmentStartDate, SequenceNumber. It has 1 association to related views. Part of development package ODATA_CA_BUM_WF.

Data Sources (2)

SourceAliasJoin Type
R_WorkAssgmtAltCostAssgmt _AlternativeCostAssgmt from
R_WorkAssignmentBP _BuPaIdentification inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _WorkAssignmentBP _WorkAssignmentBP.BusinessPartner = _BuPaIdentification.WorkAssignmentBusinessPartner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Alt Cost Assgmnts at Wrk Assignmnt view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE 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 (17)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignmentUUID _WorkAssignmentBP BusinessPartnerUUID UUID
KEY WorkAssignmentStartDate R_WorkAssgmtAltCostAssgmt WorkforceAssgmtStartDate Valn start date
KEY SequenceNumber R_WorkAssgmtAltCostAssgmt SequenceNumber Sort sequence
WorkAssignment R_WorkAssgmtAltCostAssgmt WorkforceAssignment WorkForce Assgmt ID
WorkAssignmentEndDate R_WorkAssgmtAltCostAssgmt WorkforceAssgmtEndDate Valn End date
CostCenter R_WorkAssgmtAltCostAssgmt CostCenter Cost Center
IsDefaultValue R_WorkAssgmtAltCostAssgmt IsDefaultValue Default
FunctionalArea R_WorkAssgmtAltCostAssgmt FunctionalArea Sendr Fctl Area
Fund R_WorkAssgmtAltCostAssgmt Fund Sender Fund
GrantID R_WorkAssgmtAltCostAssgmt GrantID Sender Grant
AlternateCostPercent R_WorkAssgmtAltCostAssgmt AlternateCostPercent Percentage
ControllingArea R_WorkAssgmtAltCostAssgmt ControllingArea Controlling Area
FinancialManagementArea R_WorkAssgmtAltCostAssgmt FinancialManagementArea FM Area
CompanyCode R_WorkAssgmtAltCostAssgmt CompanyCode Receiver Company Code
WorkAssignmentBusinessPartner R_WorkAssignmentBP WorkAssignmentBusinessPartner Busn. Partner
BusinessPartner R_WorkAssignmentBP BusinessPartner Issuing Authority
WBSElementExternalID R_WorkAssgmtAltCostAssgmt WBSElementExternalID WBS Element External ID

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_WorkAssgmtAltCostAssgmtUnion.
-- 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_WorkAssgmtAltCostAssgmtUnion AS
SELECT
  _WorkAssignmentBP.BusinessPartnerUUID AS WorkAssignmentUUID,
  _AlternativeCostAssgmt.WorkforceAssgmtStartDate AS WorkAssignmentStartDate,
  _AlternativeCostAssgmt.SequenceNumber AS SequenceNumber,
  _AlternativeCostAssgmt.WorkforceAssignment AS WorkAssignment,
  _AlternativeCostAssgmt.WorkforceAssgmtEndDate AS WorkAssignmentEndDate,
  _AlternativeCostAssgmt.CostCenter AS CostCenter,
  _AlternativeCostAssgmt.IsDefaultValue AS IsDefaultValue,
  _AlternativeCostAssgmt.FunctionalArea AS FunctionalArea,
  _AlternativeCostAssgmt.Fund AS Fund,
  _AlternativeCostAssgmt.GrantID AS GrantID,
  _AlternativeCostAssgmt.AlternateCostPercent AS AlternateCostPercent,
  _AlternativeCostAssgmt.ControllingArea AS ControllingArea,
  _AlternativeCostAssgmt.FinancialManagementArea AS FinancialManagementArea,
  _AlternativeCostAssgmt.CompanyCode AS CompanyCode,
  _BuPaIdentification.WorkAssignmentBusinessPartner AS WorkAssignmentBusinessPartner,
  _BuPaIdentification.BusinessPartner AS BusinessPartner,
  _AlternativeCostAssgmt.WBSElementExternalID AS WBSElementExternalID
FROM R_WorkAssgmtAltCostAssgmt AS _AlternativeCostAssgmt
INNER JOIN R_WorkAssignmentBP AS _BuPaIdentification ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _WorkAssignmentBP ON _WorkAssignmentBP.BusinessPartner = _BuPaIdentification.WorkAssignmentBusinessPartner  -- association [1..1]
;

Learn More