link b/w 0mat_sales and 0prod_hier?
Can anyone explain the relationship between, MD 0mat_sales and 0prod_hier?
In the MD table for 0mat_sales, i see 0prod_hier is an attrib, and for certain 0mat_sales values, corresponding 0prod_hier values are not loaded, these fields are blank.
Daily data loads are successful for the 0mat_sales_attr (delta load), 0mat_sales_text and for 0mat_sales_lphr_hier
for 0prod_hier (only attributes and texts are loaded)
Because of this issue, prod_hier is not displayed for some material numbers.
I am confused about why some prod_hier values are missing for the corresponding material numbers, i would really appreciate any help to debug this issue, it is really urgent as the user wanted to know the reason for missing values in the report.