Skip to Content
0
Former Member
Jul 07, 2016 at 05:55 AM

Can i use 2lis_11_vaitm and 2lis_13_vditm both datasource data in same 0sd_c03 cube and make report on it?

46 Views

Hi Experts,

I got a requirement to add sales document no and sales type(ZPOR) in product group wise sales across region.

Before i was using VBRP TABLE AND MARA TABLE , 2LIS_13_VDITM DATASOURCE ,0SD_C03 CUBE and got report on this.

Required field to be on report is

1) material no.

2)material group

3)material type

4)net value

5)quantity

6)Region delivery plant

7)sales document no.

8) sales type

Now they are creating sales order and its coming to VBAK TABLE ,I have to consider 2LIS_11_VAITM DATASOURCE..and get sales document no.and sales type on same report which is based on _0sd_c03 cube?

Can i do this?Please guide me ,How can i get all these fields on report.I am waiting for your reply.

Thanks and regards,

jyotsna singh