Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Cross Appplication data need to displayed.

Go to solution
Former Member

‎2008 Aug 27 2:39 PM

0 Likes
547

Hi Friends,

I have to create Info set through below details.

I need to get the data from the table BSAD like Belnr, Vbeln,....etc. And also i need the data of materials matnr and its discription. So i tried to join BSAD and VBRP, but here the problem is in vbrp table there is no data for posnr. First i need to pick belnr say 100000, vbeln say 2000 and posnr say 10.

Affer getting this i need pick matnr and its description.

I need the tables to get data of posnr and the matnr.

Thanks in advance.

Regards,

Vishal.

Edited by: vishal g v on Aug 27, 2008 3:40 PM

1 ACCEPTED SOLUTION
Read only

Go to solution
Firoz_Ashraf
Contributor

‎2008 Aug 27 2:47 PM

0 Likes
524

Hi Vishal,

To get the material text you have to take one more table i,e MAKT

You can join this on VBRP-MATNR and MAKT-MATNR

Hi Friends,

I have to create Info set through below details.

I need to get the data from the table BSAD like Belnr, Vbeln,....etc. And also i need the data of materials matnr and its discription. So i tried to join BSAD and VBRP, but here the problem is in vbrp table there is no data for posnr. First i need to pick belnr say 100000, vbeln say 2000 and posnr say 10.

Affer getting this i need pick matnr and its description.

I need the tables to get data of posnr and the matnr.

Thanks in advance.

Regards,

Vishal.

Edited by: vishal g v on Aug 27, 2008 3:40 PM

Reply
2 REPLIES 2
Read only

Go to solution
Firoz_Ashraf
Contributor

‎2008 Aug 27 2:47 PM

0 Likes
525

Hi Vishal,

To get the material text you have to take one more table i,e MAKT

You can join this on VBRP-MATNR and MAKT-MATNR

Read only

Go to solution
Former Member

‎2008 Aug 27 3:06 PM

0 Likes
524

Hi

thanks for reply.

I have taken the MAKT table.

BSAD is joined with VBRP BSAD-VBELN, BSAD-POSN2.

I have to create Info set through below details.

I need to get the data from the table BSAD like Belnr, Vbeln,....etc. And also i need the data of materials matnr and its discription. So i tried to join BSAD and VBRP, but here the problem is in BSAD table there is no data for posnr. First i need to pick belnr say 100000, vbeln say 2000 and posnr say 10.

Affer getting this i need pick matnr and its description.

I need the tables to get data of posnr and the matnr.

So posn2 doesnot contain data. i need to compare with posnr because vbeln is mutiple.so posnr will be third key. i need the tables for to get this data.

I am BI Consultant, After creating info set i need to get the data in BW. Any one can help me out in this .

Regards,

Vishal.

Edited by: vishal g v on Aug 27, 2008 5:07 PM

Edited by: vishal g v on Aug 28, 2008 1:32 PM