cancel
Showing results for 
Search instead for 
Did you mean: 

Splitting records by using Start Routine based on condition..

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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
CC00150001001200 (AA1 10%)
CC00150001002400 (AA2 20%)
CC00150001003200 (AA3 10%)
CC00150001004600 (AA4 30%)
CC00150001005400 (AA5 20%)
CC00150001006200 (AA6 10%)
CC00255711001600
CC00255711002300
CC00255711003900
CC00255711004300
CC00255711005300
CC00255711006600
CC0035451 4000*2.288( if TYPE B)

MATERIAL MASTER TABLE
CATEGORYMATERIAL
AA11001
AA21002
AA31003
AA41004
AA51005
AA61006

Regards,

Somesh.

former_member183334
Active Participant
0 Kudos

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.

former_member976
Active Contributor
0 Kudos

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.

former_member182997
Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Experts,

Please reply for this issue.

Regards,

Somesh