I_OrgUnit

DDL: I_ORGUNIT SQL: IORGNUNIT Type: view BASIC

OrganizationalUnit

I_OrgUnit is a Basic CDS View that provides data about "OrganizationalUnit" in SAP S/4HANA. It has 2 associations to related views.

3 fields

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_OrgUnitText _OrgUnitText $projection.OrganizationalUnit = _OrgUnitText.OrganizationalUnit
[0..1] P_PDOBJECT _OrgUnitCode $projection.OrganizationalUnit = _OrgUnitCode.ObjectID and _OrgUnitCode.ObjectType = 'O' and _OrgUnitCode.EndDate >= $session.system_date and _OrgUnitCode.StartDate <= $session.system_date

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IORGNUNIT view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label OrganizationalUnit view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey OrganizationalUnit view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalUnit t527x orgeh
OrganizationalUnitCode _OrgUnitCode Name
_OrgUnitText _OrgUnitText 
@AbapCatalog.sqlViewName: 'IORGNUNIT'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'OrganizationalUnit'
@VDM.viewType:  #BASIC

@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #CUSTOMIZING 
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.sizeCategory: #M

@AccessControl.privilegedAssociations:  [ '_OrgUnitText'] 
@ObjectModel.representativeKey: 'OrganizationalUnit'
define view I_OrgUnit 

//as select distinct from /shcm/hrp5090 as details

//

//  association [0..1] to I_OrgUnitText as _OrgUnitText on $projection.OrganizationalUnit = _OrgUnitText.OrganizationalUnit

//

//{

//  @ObjectModel.text.association: '_OrgUnitText'

//  key   case

//    when details.department_id <> ''

//         then details.department_id

//         else case

//                when details.division_id <> ''

//                    then details.division_id

//                    else details.business_unit_id

//              end

//  end as OrganizationalUnit, 

//  _OrgUnitText

//  

//} where details.department_id <> '' or details.division_id <> '' or details.business_unit_id <> ''



//union all



as select distinct from t527x

  association [0..*] to I_OrgUnitText as _OrgUnitText on $projection.OrganizationalUnit = _OrgUnitText.OrganizationalUnit
  association [0..1] to P_PDOBJECT    as _OrgUnitCode on $projection.OrganizationalUnit = _OrgUnitCode.ObjectID
                                                      and _OrgUnitCode.ObjectType = 'O' 
                                                      and _OrgUnitCode.EndDate        >= $session.system_date
                                                      and _OrgUnitCode.StartDate      <= $session.system_date
{
  @ObjectModel.text.association: '_OrgUnitText'
  key t527x.orgeh as OrganizationalUnit,
      _OrgUnitCode.Name as OrganizationalUnitCode,
      _OrgUnitText
}             
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PDOBJECT",
"T527X"
],
"ASSOCIATED":
[
"I_ORGUNITTEXT",
"P_PDOBJECT"
],
"BASE":
[],
"VERSION":0
}
}*/

Learn More