Description
For SKU F055502000 at US19 location, user has maintained APO Demand planner id in APO and its reflecting in UDH as well. However , it is coming as blank in SIQ.
On checking , we could see that APO Demand Planner value is Null in master data - dbo.imp_bobj_apo_master_data .
In SP - SP99_001_SR_imp_HANA_APO_Master_Data_Daily_UDH , we are mapping DemandplannerID from [RAW].[imp_UDH_APO_Master_Data_Location] to master data. Here, in this RAW table [RAW].[imp_UDH_APO_Master_Data_Location] , DemandplannerID is null so we are getting Null for APO Demand Planner in master data. However this RAW table has value APO Demand Planner field.
Kindly check if we can map APO Demand Planner instead of DemandplannerID to avoid this issue.