I_ServicePerformerToSuplr

DDL: I_SERVICEPERFORMERTOSUPLR SQL: ISERVPERFTOSUPP Type: view COMPOSITE Package: VDM_SHCM_EMPLOYEE_V2
8 Fields 2 Associations

Service Performer to Supplier

I_ServicePerformerToSuplr (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Human Resources

I_ServicePerformerToSuplr is a Composite CDS View that provides data about "Service Performer to Supplier" in SAP S/4HANA. It has 2 associations to related views. Part of development package VDM_SHCM_EMPLOYEE_V2.

SAP Help Documentation

CategoryCDS Views for Human Resources
Purpose
This CDS view helps to retrieve the supplier organization of service performer. This CDS view provides the data to answer the following business questions: Which is the supplier organization of service performer? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations To use this CDS view, the following business catalogs need to be assigned to a user: B_BUPR_BZT (Business Partner Relationship Category) BEGRU_BUPA_GRP (Authorization Group for Business Partners) B_BUP_DCPD (Business Partner Processing)

Structure
Important Fields Important fields in this view include the following: Field Name Description BusinessPartnerSupplier Business Partner Number RelationshipCategory Business Partner Relationship Category

Related Information
The following fields are created in the CDS view in accordance with BP data controller adoption: DataControllerSet, DataController1, DataController2, DataController3, DataController4, DataController5, DataController6, DataController7, DataController8, DataController9, DataController10. Note These fields may be visible in the interface of the CDS view. However, they are meant only for internal-SAP consumption and must not be consumed externally for any purposes. For more information about BP data controller authorization, refer to Assign Data Controller .

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessHuman Resources
Application ComponentCA-WFD
CapabilitiesAssociation Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageHuman Resources for SAP S/4HANA Cloud Public Edition
Description <p>This view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>Which is the supplier organization of service performer?</p> </li> </ul>

Documentation

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartnerSupplier _BusinessPartnerSupplier.BusinessPartner = $projection.BusinessPartnerSupplier
[1..1] I_BusinessPartner _ServicePerformer _ServicePerformer.BusinessPartner = $projection.Person

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISERVPERFTOSUPP view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Service Performer to Supplier view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.supportedCapabilities #CDS_MODELING_ASSOCIATION_TARGET view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerSupplier BusinessPartner1 Business Partner Number
KEY Person BusinessPartner2 Business Partner Number
KEY EndDate ValidityEndDate Validity Date (Valid To)
StartDate ValidityStartDate Validity Date (Valid From)
RelationshipCategory RelationshipCategory Business Partner Relationship Category
_ServicePerformer _ServicePerformer
_BusinessPartnerSupplier _BusinessPartnerSupplier
DataControllerSet _BusinessPartnerSupplier DataControllerSet BP: Data Controller Set Flag

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 I_ServicePerformerToSuplr.
-- 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.
-- SQL view name: ISERVPERFTOSUPP

CREATE VIEW I_ServicePerformerToSuplr AS
SELECT
  BusinessPartner1 AS BusinessPartnerSupplier,
  BusinessPartner2 AS Person,
  ValidityEndDate AS EndDate,
  ValidityStartDate AS StartDate,
  RelationshipCategory,
  _BusinessPartnerSupplier.DataControllerSet AS DataControllerSet
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartnerSupplier ON _BusinessPartnerSupplier.BusinessPartner = BusinessPartnerSupplier  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServicePerformer ON _ServicePerformer.BusinessPartner = Person  -- association [1..1]
;

Learn More