on 12-23-2014 5:06 PM
Hi Expets,
I have Requirement for splitting the records into multiple records by using below condition (lookup tables).
DSO_11 (LOOKUP DSO 1)
Material | Sales Office | Fiscal year Period | Comp Code | Sales org | Ratio |
1000000 | 5000 | 2015003 | 1001 | 2100 | 0.168 |
2000000 | 5451 | 2015003 | 1001 | 2810 | 2.288 |
DSO_22 (LOOKUP DSO 2)
Cost Center | CC Type | AA1 | AA2 | AA3 | AA4 | AA5 | AA6 | Sales Organization | Sales Office |
CC001 | A | 10 | 20 | 10 | 30 | 20 | 10 | 5000 | 5000 |
CC002 | A | 20 | 10 | 30 | 10 | 10 | 20 | 5000 | 5571 |
CC003 | B | 5000 | 5451 | Blank | Blank | Blank | Blank | Blank | Blank |
CC004 | B | 5000 | 5453 | Blank | Blank | Blank | Blank | Blank | Blank |
CC005 | C | 20 | 20 | 10 | 10 | 20 | 20 | 5000 | 5280 |
CC006 | C | 15 | 15 | 15 | 5 | 25 | 25 | 5000 | 5221 |
For loading data on the basis of Cost center type (A OR B OR C) Target is Infocube.
For type A or C fixed %age defined in DSO_22 those CCTYPE belongs to type B need to take from DSO_11.
SOURCE DATA IS LIKE THIS
CostCenter | SalesOffice | Sales |
CC001 | 5000 | 2000 |
CC002 | 5571 | 3000 |
CC003 | 5451 | 4000 |
Output will be splitted as follows..
COSTCENTER SALESOFFICE SALES | ||
CC001 | 5000 | 200 (AA1 10%) |
CC001 | 5000 | 400 (AA2 20%) |
CC001 | 5000 | 200 (AA3 10%) |
CC001 | 5000 | 600 (AA4 30%) |
CC001 | 5000 | 400 (AA5 20%) |
CC001 | 5000 | 200 (AA6 10%) |
CC002 | 5571 | 600 |
CC002 | 5571 | 300 |
CC002 | 5571 | 900 |
CC002 | 5571 | 300 |
CC002 | 5571 | 300 |
CC002 | 5571 | 600 |
CC003 | 5451 | 4000*2.288( if TYPE B) |
Please share some inputs...
Regards,
Somesh.
Hi,
Sorry for inconvenience, Thanks to all for your reply.
Yes you are correct. material need to fetch by hard coded from material table which has category.
COSTCENTER SALESOFFICE SALES | |||
CC001 | 5000 | 1001 | 200 (AA1 10%) |
CC001 | 5000 | 1002 | 400 (AA2 20%) |
CC001 | 5000 | 1003 | 200 (AA3 10%) |
CC001 | 5000 | 1004 | 600 (AA4 30%) |
CC001 | 5000 | 1005 | 400 (AA5 20%) |
CC001 | 5000 | 1006 | 200 (AA6 10%) |
CC002 | 5571 | 1001 | 600 |
CC002 | 5571 | 1002 | 300 |
CC002 | 5571 | 1003 | 900 |
CC002 | 5571 | 1004 | 300 |
CC002 | 5571 | 1005 | 300 |
CC002 | 5571 | 1006 | 600 |
CC003 | 5451 | 4000*2.288( if TYPE B) |
MATERIAL MASTER TABLE | |
CATEGORY | MATERIAL |
AA1 | 1001 |
AA2 | 1002 |
AA3 | 1003 |
AA4 | 1004 |
AA5 | 1005 |
AA6 | 1006 |
Regards,
Somesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Somesh ji
when you load data as per your requirement using Lookup...
I must need Unique Charecteristic field to populate the values to load data as well as we can split the recods as per ur requrement.
better check with source data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
otherthan costcenter any other unique values is there please check the cube or PSA data.
about ABAP logic how you are writing the logic based on the document no, some date filed and material.
you will get out put not an easy you need to think different type. in report it will give total aggregated value.
Thanks,
Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you will need unique characteristic for which the values will be unique data records whether in cube or DSO thus you will be able to split on basis of certain characteristic.
Find that in source and load that as well in the BI data target
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Experts,
Please reply for this issue.
Regards,
Somesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.