P_RSHWrkCtrPersonResponsibleVH

DDL: P_RSHWRKCTRPERSONRESPONSIBLEVH SQL: PRSHWRKCTRPERSVH Type: view CONSUMPTION Package: RSH_CDS_EAM_RES_ASG
10 Fields 4 Data Sources

Value help with work centers assigned to the users

P_RSHWrkCtrPersonResponsibleVH is a Consumption CDS View that provides data about "Value help with work centers assigned to the users" in SAP S/4HANA. It reads from 4 data sources (I_RSHAssignedWorkCenters, I_RespyMgmtTeamAttributeBasic, I_RespyMgmtTeamHeaderDetail, I_RespyMgmtTeamMemberBasic) and exposes 10 fields with key fields RespyMgmtTeamID, BusinessPartner, WorkCenterInternalID, RespyMgmtFunction. Part of development package RSH_CDS_EAM_RES_ASG.

Data Sources (4)

SourceAliasJoin Type
I_RSHAssignedWorkCenters AssignedWorkCenters inner
I_RespyMgmtTeamAttributeBasic TeamAttributes from
I_RespyMgmtTeamHeaderDetail TeamHeaderDetails inner
I_RespyMgmtTeamMemberBasic TeamMembers inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRSHWRKCTRPERSVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Value help with work centers assigned to the users view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtTeamID I_RespyMgmtTeamMemberBasic RespyMgmtTeamID Team ID
KEY BusinessPartner I_RespyMgmtTeamMemberBasic BusinessPartner Issuing Authority
KEY WorkCenterInternalID I_RSHAssignedWorkCenters WorkCenterInternalID Work Center
KEY RespyMgmtFunction
WorkCenter I_RSHAssignedWorkCenters WorkCenter Work Center
Plant I_RSHAssignedWorkCenters Plant Valuation Area
RespyMgmtTeamMemberType I_RespyMgmtTeamMemberBasic RespyMgmtTeamMemberType
RespyMgmtTeamType I_RespyMgmtTeamHeaderDetail RespyMgmtTeamType Team Type
RespyMgmtFunctionDescription
_TeamMemberFunction I_RespyMgmtTeamMemberBasic _TeamMemberFunction

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 P_RSHWrkCtrPersonResponsibleVH.
-- 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: PRSHWRKCTRPERSVH

CREATE VIEW P_RSHWrkCtrPersonResponsibleVH AS
SELECT
  TeamMembers.RespyMgmtTeamID AS RespyMgmtTeamID,
  TeamMembers.BusinessPartner AS BusinessPartner,
  AssignedWorkCenters.WorkCenterInternalID AS WorkCenterInternalID,
  TeamMembers._TeamMemberFunction.RespyMgmtFunction AS RespyMgmtFunction,
  AssignedWorkCenters.WorkCenter AS WorkCenter,
  AssignedWorkCenters.Plant AS Plant,
  TeamMembers.RespyMgmtTeamMemberType AS RespyMgmtTeamMemberType,
  TeamHeaderDetails.RespyMgmtTeamType AS RespyMgmtTeamType,
  TeamMembers._TeamMemberFunction._Function.RespyMgmtFunctionDescription AS RespyMgmtFunctionDescription,
  TeamMembers._TeamMemberFunction AS _TeamMemberFunction
FROM I_RespyMgmtTeamAttributeBasic AS TeamAttributes
INNER JOIN I_RespyMgmtTeamHeaderDetail AS TeamHeaderDetails ON /* join condition not captured in parsed metadata */
INNER JOIN I_RespyMgmtTeamMemberBasic AS TeamMembers ON /* join condition not captured in parsed metadata */
INNER JOIN I_RSHAssignedWorkCenters AS AssignedWorkCenters ON /* join condition not captured in parsed metadata */
;

Learn More