I_TranspOrganizationalUnit

@AbapCatalog:              {compiler:                   {compareFilter: true},
                            sqlViewName:                'ITRANSPORGUNIT',
                            preserveKey:                true}
@AccessControl:            {authorizationCheck:         #CHECK,
                            personalData.blocking:      #REQUIRED}
@ClientHandling.algorithm:  #SESSION_VARIABLE
@Metadata.allowExtensions:  true
@ObjectModel:              {representativeKey:          'OrganizationalUnit',
                            usageType:                  {serviceQuality: #C,
                                                         sizeCategory:   #M,
                                                         dataClass:      #CUSTOMIZING}}
@VDM:                      {viewType:                   #BASIC,
                            lifecycle.contract.type:    #NONE }

@EndUserText.label:        'Core View for Transportation OrgUnit'

@Analytics:                 {dataCategory:       #DIMENSION,
//                          dataExtraction:     {enabled: true},

                            internalName:       #LOCAL}


define view I_TranspOrganizationalUnit
  as select from /scmb/hrp5561
    inner join   t77s0 as systemtable on  grpid = 'PLOGI'
                                      and semid = 'PLOGI'
                                      and gsval = /scmb/hrp5561.plvar
  association [0..*] to I_TranspOrganizationalUnitText as _OrganizationalUnitText on $projection.OrganizationalUnit = _OrganizationalUnitText.OrganizationalUnit
  association [0..1] to I_BusinessPartner              as _BusinessPartner        on $projection.BusinessPartner    = _BusinessPartner.BusinessPartner
{
      @ObjectModel.text.association: '_OrganizationalUnitText' 
  key objid       as OrganizationalUnit,
      begda       as OrgUnitValidityStartDate,
      endda       as OrgUnitValidityEndDate,
      aedtm       as LastChangeDate,
      uname       as LastChangedByUser,
      external_id as OrganizationalUnitExternalID,
      logqs       as BusinessSystemGroup,
      logqs_id    as OrganizationalUnitSpcfcExtID,
      function    as OrganizationalUnitFunction,
      role        as OrganizationalUnitRole,
      partner     as BusinessPartner,
      _OrganizationalUnitText,
      _BusinessPartner
}

where
      otype = 'O'
  and subty = ''
  and istat = '1'
  and varyf = ''
  and seqnr = '000'
  and begda <= $session.system_date
  and endda >= $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCMB/HRP5561",
"T77S0"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_TRANSPORGANIZATIONALUNITTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/