Hi ,
Please can any one help me findout how I can flattened the approx 20 Hierarchies after directly reading from ECC (SAP R/3) like:
1- HR Responsibility Hierarchy
2- Site Responsibility Hierarchy
3- Pharmacy Responsibility Hierarchy.
I have to flatten approximately 20 hierarchies after reading from ECC using SAP Data Service Hierarchy Flattening Transformation & load into Oracle database.
Please can any one help me how to Get or generate one source table for each corresponding Hierarchy.
I would really appreciate your help.
Regards
qazi
qazi (BOB member since 2012-05-09)