P_SA_CompanyCode_Address

@AbapCatalog.sqlViewName: 'PSACOMPCODEADDRS'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck:#NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#CUSTOMIZING
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_SA_CompanyCode_Address as select from I_CompanyCode 
inner join I_OrganizationAddress on I_OrganizationAddress.AddressID = I_CompanyCode.AddressID 
                                    and I_OrganizationAddress.AddressPersonID is initial
                                    and I_OrganizationAddress.AddressRepresentationCode is initial
inner join I_CountryText on I_CountryText.Country = 'SA'
                         and I_CountryText.Language =  $session.system_language
{ 
 @ObjectModel.text.element: 'CompanyCodeName'
 key CompanyCode,
 @Semantics.text
    CompanyCodeName, 
    VATRegistration,
    I_OrganizationAddress.HouseNumber,
    I_OrganizationAddress.StreetName,
    I_OrganizationAddress.CityName,
    I_OrganizationAddress.POBox,
    I_OrganizationAddress.Country,
    I_OrganizationAddress._EmailAddress[EmailAddressIsCurrentDefault = 'X'].EmailAddress,
    I_OrganizationAddress._PhoneNumber[PhoneNumberType = '1'].PhoneAreaCodeSubscriberNumber as PhoneNumber,
    concat_with_space(concat(CompanyCode,'-'), CompanyCodeName , 1) as CompanyName,    
    concat_with_space(concat_with_space( (concat_with_space(concat(I_OrganizationAddress.HouseNumber, ','),concat(I_OrganizationAddress.StreetName, ','),1)),
                                         (concat_with_space(concat(I_OrganizationAddress.CityName, ','), concat(I_OrganizationAddress.POBox, ','),1)), 1),
                                         I_CountryText.CountryName,1) as CompanyCodeAddress
                                         
   
       
}

where I_OrganizationAddress.CorrespondenceLanguage = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESSEMAILADDRESS_2",
"I_ADDRESSPHONENUMBER_2",
"I_COMPANYCODE",
"I_COUNTRYTEXT",
"I_ORGANIZATIONADDRESS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/