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

[Former Member]

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.

😎 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

[Former Member · Accepted solution]

Hi,

if you activated cube 0sd_c03 from business content with data flow before, then you should be able to see it is fetching data from 11, 12 & 13 components ( with all mappings from BI content).

if you haven't done in that way, then yes you can map 2lis_11_vaitm to 0sd_c03 cube.

Required field to be on report is
1) material no.
2)material group
3)material type

The  first three are available in Material Master , if material group and material type are display attributes, then switch them to navigational attributes.

4)net value
5)quantity
6)Region delivery plant
7)sales document no.

you can get all these from 0sd_c03, sales document number is available in both 11_vaitm & 13_vaitm.

😎 sales type

Sales type (0doc_type), is avilable in 2lis_11_vaitm datasource (source filed is :AUART). In case, if you dont see 0dco_type in 0sd_c03, then you should add it and do the mapping.

[Former Member · Accepted solution]

Thanks alot jyothi for very clear concepts.

now,requirement is little changed so i made report on the basis of only 2LIS_11_VAITM DATASOURCE.

Thanks and regards,

jyotsna singh