Flattening Master Data Hierarchy in SAP BI
Background: This Expert-Routine is used to flatten the customer (0CUST_SALES) hierarchy and store the hierarchy levels as master data Navigational attributes of customer master (0CUST_SALES). The 0CUST_SALES hierarchy contains 7 levels of hierarchy. Each customer in the 0CUST_SALES master data, can represent any level within the 0CUST_SALES hierarchy. For example: Read More
SAP BI End-Routine – Update Key-Figs & Characteristics
Background: This End-Routine performs “Unit of Measure” conversion for some of the key-figures in the source structure by reading the “Unit of Measure” master data Info-Object (ZMAT_UNIT) & Material Master Data InfoObject (ZMATERIAL). The End-routine also reads another DSO (0SD_O01) to pick up “Sales Order Header” information and populates them Read More