Skip to Content
avatar image
Former Member

Splitting records by using Start Routine based on condition..

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Dec 24, 2014 at 05:14 PM

    Hi Experts,

    Please reply for this issue.

    Regards,

    Somesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 25, 2014 at 02:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2014 at 03:30 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2014 at 04:37 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2014 at 09:24 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded