I_TranspOrdShprAddrID

@EndUserText:   {label:              'Transp Order Shipper 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_TranspOrdShprAddrID
  as select from I_TransportationOrder
{
  key TransportationOrderUUID                   as TransportationOrderUUID,
      _Shipper._CurrentDefaultAddress.AddressID as AddressID
}
where
      Shipper          is not initial
  and ShipperAddressID 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.ShipperAddressID, 7, 32
  )
{
  key I_TransportationOrder.TransportationOrderUUID as TransportationOrderUUID,
      AdrcUUID.AddressID                            as AddressID
}
where
      substring( I_TransportationOrder.ShipperAddressID, 3, 3) = 'GEN' // Deviating Address containing UUID

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


union all

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

  and substring( ShipperAddressID, 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":""
}
}*/