R_WorkAssgmtsBPIdentification

DDL: R_WORKASSGMTSBPIDENTIFICATION Type: view_entity COMPOSITE Package: WFD_WORKER_FACTSHEET_BL

Business Partner for Work Assignment

R_WorkAssgmtsBPIdentification is a Composite CDS View that provides data about "Business Partner for Work Assignment" in SAP S/4HANA. It reads from 3 data sources (I_WorkforceAssignment_1, R_WorkAssignmentBP, R_WorkAssignmentBP) and exposes 9 fields with key field WorkforceAssignment. Part of development package WFD_WORKER_FACTSHEET_BL.

Data Sources (3)

SourceAliasJoin Type
I_WorkforceAssignment_1 _WrkAssignment inner
R_WorkAssignmentBP _WrkAssignmentBP from
R_WorkAssignmentBP _WrkAssignmentBP union_all

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Partner for Work Assignment 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 (9)

KeyFieldSource TableSource FieldDescription
KEY WorkforceAssignment R_WorkAssignmentBP WorkforceAssignment WorkForce Assgmt ID
WorkforcePersonExternalID R_WorkAssignmentBP WorkforcePersonExternalID External Person ID
BusinessPartner R_WorkAssignmentBP WorkAssignmentBusinessPartner Busn. Partner
BPRoleCategoryUsageCode R_WorkAssignmentBP BPRoleCategoryUsageCode
WorkforceAssignment WorkForce Assgmt ID
WorkforcePersonExternalID R_WorkAssignmentBP WorkforcePersonExternalID External Person ID
BusinessPartner R_WorkAssignmentBP WorkAssignmentBusinessPartner Busn. Partner
BPRoleCategoryUsageCode R_WorkAssignmentBP BPRoleCategoryUsageCode
BPIdentificationType

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_WorkAssgmtsBPIdentification.
-- 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_WorkAssgmtsBPIdentification AS
SELECT
  _WrkAssignmentBP.WorkforceAssignment AS WorkforceAssignment,
  _WrkAssignmentBP.WorkforcePersonExternalID AS WorkforcePersonExternalID,
  _WrkAssignmentBP.WorkAssignmentBusinessPartner AS BusinessPartner,
  _WrkAssignmentBP.BPRoleCategoryUsageCode AS BPRoleCategoryUsageCode,
  'HCM033' AS BPIdentificationType
FROM R_WorkAssignmentBP AS _WrkAssignmentBP
INNER JOIN I_WorkforceAssignment_1 AS _WrkAssignment ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): R_WorkAssignmentBP
;