Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

BlankBlankBlankBlankBlankBlank

CC004

B

5000

5453

BlankBlankBlankBlankBlankBlank

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.

Former Member
Not what you were looking for? View more on this topic or Ask a question