topic Re: Two questions in Application Development and Automation Discussions

Two questions

Former Member — Sun, 23 Mar 2008 14:45:56 GMT

Hi,

I have following 2 questions:

1) I want to extract sales document using sold-to and material from VBAK, but don't have primary key document number and also there is no ondex on sold-to. Looking at the enormous data in VBAK,

Can I do

select vbeln from vbak

where vbeln <> ' ' and

sold-to in range.

and then go to VBAP. Will it help performance by putting VBELN BLANK.

2) Can we draw a line in smartform. I see only box creation. Boxes in smartforms don't provide border lines. It has to come thru windows. If the table ends before touching the MAIN window, it has no bottom border line. I want that line. How to acomplish??

Thanks,

Amol..

Re: Two questions

Former Member — Mon, 24 Mar 2008 00:53:11 GMT

Any suggestions please.

Thanks

Re: Two questions

Former Member — Mon, 24 Mar 2008 01:20:26 GMT

Hi AP,

1.U can use the Inner join of two tables VBAP and VBAP based on ur requirment Sold-to party. so that u can retreive ur sales doc belongs to that sold-to party.

select ur fields from tables ( Ex: a_{kunnr a}vbeln b_{posnr b}matnr)

INTO CORRESPONDING FIELDS OF TABLE (ur internal table)

FROM VBAK AS A

JOIN VBAP AS B ON A_{VBELN = B}VBELN

WHERE A~KUNNR IN P_KUNNR.

2.IN smartforms the WINDOWS u can see the output options there click the checkboxes DRAW BOXES AND SHADING...

or u can create a window and draw a line in that window where ever u want.

Re: Two questions

Former Member — Mon, 24 Mar 2008 04:02:29 GMT

Hi,

For your first query go to table VAPMA(Sales Index: Order Items by Ma) and you will get your required data with out any joining and MATNR,KUNNR & VBELN all are primary key fields.

So this will give good performance.

Thanks and regards,

shyla