I_OrganizationalUnitText

DDL: I_ORGANIZATIONALUNITTEXT SQL: IORGUNITTXT Type: view BASIC

Table for Organizational Units with Text

I_OrganizationalUnitText is a Basic CDS View that provides data about "Table for Organizational Units with Text" in SAP S/4HANA. It reads from 1 data source (t77s0) and exposes 7 fields with key fields OrganizationalUnit, Language, StartDate, EndDate. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
t77s0 systemtable inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language hrp1000.langu = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IORGUNITTXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Table for Organizational Units with Text view
Analytics.dataExtraction.enabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey OrganizationalUnit view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalUnit hrp1000 objid
KEY Language hrp1000 langu
KEY StartDate begda
KEY EndDate endda
OrganizationalUnitShortName short
OrganizationalUnitName hrp1000 stext
_Language _Language 
@AbapCatalog.sqlViewName: 'IORGUNITTXT'
@VDM.viewType:  #BASIC
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Table for Organizational Units with Text'
@Analytics.dataExtraction.enabled: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'OrganizationalUnit'
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT,
                                     #SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                     #EXTRACTION_DATA_SOURCE]
define view I_OrganizationalUnitText
  as select distinct from hrp1000 as HRP1000
    inner join            t77s0   as systemtable on  grpid = 'PLOGI'
                                                 and semid = 'PLOGI'
                                                 and gsval = hrp1000.plvar
  association [0..1] to I_Language as _Language on hrp1000.langu = _Language.Language
{
  key hrp1000.objid as OrganizationalUnit,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key hrp1000.langu as Language,
 @Semantics.businessDate.from: true
  key begda         as StartDate,
   @Semantics.businessDate.to: true
  key endda         as EndDate,
      short         as OrganizationalUnitShortName,
      @Semantics.text: true
      hrp1000.stext as OrganizationalUnitName,
      _Language
}
where
      hrp1000.otype = 'O'
  and hrp1000.istat = '1'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRP1000",
"T77S0"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More