Getting facility code in ALV

[Former Member]

I would like to get the facility code in my ALV repot for a customer statment report .

Its been asked to populate that field using the logic as follows.

The logic for the customer facility code should be something like this.

Find the business location partner of the ship-to. If the business location has a partner u2018ZFACu2019 use the ZFAC if there is no partner ZFAC display u2018AMBCu2019. If there is no business location partnered to the u2018ship tou2019 leave blank.

Could anyone please guide me how to go through to get the facility code and fill with ABMC when its partnered and facility code is blank and to leave blank if its not partnered.

Thanks

[Former Member]

.