I_RSHResourceServiceOrg

DDL: I_RSHRESOURCESERVICEORG SQL: IRSHRESSERORG Type: view COMPOSITE Package: RSH_CDS_RES
6 Fields 1 Data Sources

Service organization for a cost center

I_RSHResourceServiceOrg is a Composite CDS View that provides data about "Service organization for a cost center" in SAP S/4HANA. It reads from 1 data source (I_EngagementProjectSrvcOrgDets) and exposes 6 fields with key fields AssignedOrganisation, CompanyCode. Part of development package RSH_CDS_RES.

Data Sources (1)

SourceAliasJoin Type
I_EngagementProjectSrvcOrgDets orgdet from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRSHRESSERORG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.private false view
EndUserText.label Service organization for a cost center view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AssignedOrganisation I_EngagementProjectSrvcOrgDets AssignedOrganisation Org. Unit Key
KEY CompanyCode
EngagementProjectServiceOrg I_EngagementProjectSrvcOrgDets EngagementProjectServiceOrg Service Org.
EngmtProjectServiceOrgName
AssignedOrganisationType I_EngagementProjectSrvcOrgDets AssignedOrganisationType Org. Unit Type
ControllingArea

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_RSHResourceServiceOrg.
-- 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: IRSHRESSERORG

CREATE VIEW I_RSHResourceServiceOrg AS
SELECT
  orgdet.AssignedOrganisation AS AssignedOrganisation,
  orgdet._EngagementProjectServiceOrg._CompanyCode.AssignedOrganisation AS CompanyCode,
  orgdet.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  orgdet._EngagementProjectServiceOrg._Text[1: Language = $session.system_language ].EngmtProjectServiceOrgName AS EngmtProjectServiceOrgName,
  orgdet.AssignedOrganisationType AS AssignedOrganisationType,
  orgdet._EngagementProjectServiceOrg._ControllingArea.AssignedOrganisation AS ControllingArea
FROM I_EngagementProjectSrvcOrgDets AS orgdet
;

Learn More