C_RSHOrgUnit

DDL: C_RSHORGUNIT SQL: CRSHORGUNIT Type: view CONSUMPTION Package: RSH_CDS_RES

Organizational Unit

C_RSHOrgUnit is a Consumption CDS View that provides data about "Organizational Unit" in SAP S/4HANA. It reads from 2 data sources (I_OrgUnitText, P_RSHResource) and exposes 8 fields with key fields Language, OrganizationalUnit. Part of development package RSH_CDS_RES.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_OrgUnitText OrgUnit from
P_RSHResource P_RSHResource inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRSHORGUNIT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Organizational Unit view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Language I_OrgUnitText Language
KEY OrganizationalUnit I_OrgUnitText OrganizationalUnit
OrganizationalUnitName I_OrgUnitText OrganizationalUnitName
_Language I_OrgUnitText _Language
CompanyCode CompanyCode
CostCenter CostCenter
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
AuthorizationGroup AuthorizationGroup 
@AbapCatalog.sqlViewName: 'CRSHORGUNIT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Organizational Unit'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED

/*
CONTRACT**********************************************************************************************************************

Name:                       RSH own view for Org Unit
Specification:              This View returns the Organizational Units
Ensures:                    Org Units are returned
Owners:                     TR
Contributors:               TR
Unit Test required Y/N:     No
Additional comments         Required because of DCL0 in I_ORGUNIT

END OF CONTRACT***************************************************************************************************************
*/


define view C_RSHOrgUnit
  as select from I_OrgUnitText                                                                        as OrgUnit
    inner join   P_RSHResource ( P_StartDate: $session.system_date, P_EndDate: $session.system_date ) as _ResDetail on _ResDetail.OrganizationalUnit = OrgUnit.OrganizationalUnit

{
      //I_OrgUnitText

  key OrgUnit.Language,
  key OrgUnit.OrganizationalUnit,
      OrgUnit.OrganizationalUnitName,
      OrgUnit._Language,
      @Consumption.hidden: true
      CompanyCode,
      @Consumption.hidden: true
      CostCenter,
      @Consumption.hidden: true
      IsBusinessPurposeCompleted,
      @Consumption.hidden: true
      AuthorizationGroup

      /* Associations */
      //I_OrgUnitText


}

Learn More