QUICK: 2]Material Valuation
Report: Material Valuation (Validation and Fixes.....) Issue 1: Material Decription [Naming issue: check the main source] [Impact: LOW] Issue 2: [Impact: MEDIUM] Joins=> Join name: A]Product to Sales Org [one line need to be added] "one product_id have multiple sales org" # Code: New_updated Code for Product to Sales Org : SALES_ORG_DISTINCT AS ( SELECT DISTINCT product_id, sales_org_code, # CT_XYLEM_19_03 Item_category_group_from_material_master, Delivering_Plant_Own_or_External FROM {gold_catalog_name}.master_data.product_sales_organization # Comment: New Line need to be added in the join. B] Product_Plant to Inventory [Impact: Low] # LOC: 27 # Code: CT_XYLEM=> ...
Comments
Post a Comment