Internal Tables and SMARTFORMS: Inputs Required !

[Former Member]

Hello Experts,

1. I have been working on a customization of commercial invoice. I have not copied the standard programs.

I have joined VBRK, VBRP VBPA and ADRC tables using inner join.

Now I need to join KNOV table, which is a cluster table.

How can proceed with this ?

2. I need to fetch the customized header text and item text in VF01 (SD) T- code into my SMARTFORM. How should I approach this and What are the inputs required from Functional consultants end ?

Please help !

Thanks in advance.

[Former Member]

Hello Experts,

1. I have been working on a customization of commercial invoice. I have not copied the standard programs.

I have joined VBRK, VBRP VBPA and ADRC tables using inner join.

Now I need to join KNOV table, which is a cluster table.

How can proceed with this ?

2. I need to fetch the customized header text and item text in VF01 (SD) T- code into my SMARTFORM. How should I approach this and What are the inputs required from Functional consultants end ?

Please help !

Thanks in advance.

[leonardo_schmidt]

Hello Harish,

1. In my experience, and also by looking at many different resources, you'll find that INNER JOINs are seldom the best option for obtaining data from related tables, and this applies specially to the case of cluster tables (BSEG, KONV, etc.). You should always consider making the selections using the FOR ALL ENTRIES IN addition, I'm sure you can easily find many examples here in the forums or around the web.

Still, these tables you mentioned relate to the conditions table by the condition number (KNUMV).

2. You can use the READ_TEXT FM. To find the parameters to execute it, do the following:

- Start VF02 transaction and open a billing document;

- Navigate in the menu Goto > Header > Header texts (or choose any other text you want);

- Choose the text you want and double click on the text input area;

- On the text editor screen, choose Goto > Header...

In the popup that appears, the first four fields are the parameters needed to run the FM. When executed, it returns a table with the text lines in the parameter LINES.