I_TranspOrdCarrAddrID

@EndUserText:   {label:              'Transp Order Carrier Address ID'}
@ObjectModel:   {representativeKey:  'TransportationOrderUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #COMPOSITE}
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY }
@Metadata.ignorePropagatedAnnotations: true

define view entity I_TranspOrdCarrAddrID
  as select from I_TransportationOrder
{
  key TransportationOrderUUID                   as TransportationOrderUUID,
      _Carrier._CurrentDefaultAddress.AddressID as AddressID
}
where
      Carrier          is not initial
  and CarrierAddressID is initial // No Deviating Address


union all

select from              I_TransportationOrder
  left outer to one join I_BOPFAddrUUID2AddrIDMap as AdrcUUID on AdrcUUID.AddressUUID = substring(
    I_TransportationOrder.CarrierAddressID, 7, 32
  )
{
  key I_TransportationOrder.TransportationOrderUUID as TransportationOrderUUID,
      AdrcUUID.AddressID                            as AddressID
}
where
      substring( I_TransportationOrder.CarrierAddressID, 3, 3) = 'GEN' // Deviating Address containing UUID

  and substring( I_TransportationOrder.CarrierAddressID, 6, 1) = '1' // Organizational Address


union all

select from I_TransportationOrder
{
  key TransportationOrderUUID             as TransportationOrderUUID,
      substring( CarrierAddressID, 7, 10) as AddressID
}
where
      substring( CarrierAddressID, 3, 3) = 'ACP' // Deviating Address containing ID

  and substring( CarrierAddressID, 6, 1) = '1' // Organizational Address

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BOPFADDRUUID2ADDRIDMAP",
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNER",
"I_TRANSPORTATIONORDER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/