smartform designe table

[Former Member]

Hi,

I have  created a smartform..also in that  I have designed a table..data are coming proper..but the new requirement came..that I need to add one new column in that exsiting designed table..now how will I add that column in designing??please share your knowledge..

Regards

Abhay Manna.

[sai_krishna24]

Hi abhay,

increase the window width and then add column in table design. Next include your logic

Thanks

SaiKrishna

[Former Member]

Thanks for ur replay..

but I need to add the column in between excisting column..

regards

Abhay Manna

[venkat_aileni]

Hi-

Draw a new cell by choosing Pencil symbol from Toolbar.

After above step a new cell will be inserted into your table.

If your table already consists of this field data you can display it by creating a text under Table->Main Area -> Line Type-> Newly created cell.

-Venkat

[Former Member]

Thanks for ur replay..

but I need to add the column in between excisting column..

regards

Abhay Manna

[Former Member]

Please find the attachment ..highlited area..in that place I have to add new column....how ???please share ur knowledge..   Thanks  Abhay manna

[venkat_aileni]

Hi Abhay-

Just select the Pencil mark(check my previous reply) and draw a line vertically, a new cell will be inserted in your table.

Say at first you are having 3 cells in your table and you want to insert new cell between 1st and 2nd cell then by using above option draw a vertical line and new cell will be inserted.

According to your requirement adjust those cells and for inserting data in to new cell if your internal table consists of that fields data then you can directly use it else create a program line to get the logic.

-Venkat

[Former Member]

Hi Venkat,  Thank you very much for sharing your knowledge, My problem solved..  Thanks Abhay Manna

[Former Member]

Hi Venkat,  I have solve with the problem. But now I want to design table as I draw in attachment...Please share your knowledge..   Thanks   Abhay Manna

[venkat_aileni]

Hi-

Choose Select pattern option:

Then select Display Framed Pattern and select below option.

-Venkat

[Former Member]

Hi venkat, Your answer is really helpful..but I want one line in table header also..but in display pattern there is no such pattern available..so how will I do that.. and also I want to move the header text in center how to do that...Please share your knowledge.. please find the attachment..  Thanks Abhay

[venkat_aileni]

Hi Abhay-

Follow below steps to Display Framed patterns:

-> Click on Select Pattern

-> Select Display Framed patterns

->Select below option.

Now for displaying Texts in center, you have to create a Smart Style where in your paragraph format you need to choose Center alignment option.

Then in your Text Cell where you have you have written your text: Goto Output Options and select the Smart Style which you have created.

Then in general attributes of the cell select the paragraph format from your Smart Style. Your text will get automatically aligned in center.

-Venkat

[Former Member]

Hi Venkat ,  Thank you very much for reply with correct answer..my problem solved now...now I have code one driver program..in that for input screen I have used parameter...so that I can not put range..but I want to show multiple value in output..now my requirement is how would I put range in input screen..if I put select-option it is showing error..please share you knowledge.. Thanks  Abhay Manna.

[venkat_aileni]

Hi-

Was your requirement is to pass a select option value from driver program to smart form? Or you want to process select option value in driver program? Could you please elaborate your requirement.

-Venkat

[Former Member]

My requirement is to pass a select option value from driver program to smart form...  Thanks  Abhay Manna

[venkat_aileni]

Hi-

You have to create a new structure in se11 as that of select-options with fields SIGN, OPTION, LOW and HIGH.

-> Create an entry in Form Interface by using above structure.

-> Pass your select-option value from driver program to smart form and use it like an select option.

Refer below link for more details:

Select Options in Smart Form

-Venkat

[Former Member]

Dear Venkat, As you said I have created structure...with reference to your given link...but still it is showing error..  please find attachment..  Thanks Abhay Manna.

[venkat_aileni]

Hi-

In your driver program you are not exporting your select options value.. That's the reason why you are getting dump.

I hope in your form interface you have added tables parameter for select options. So now in your driver program once again you import your smart form FM by using pattern option and export your select option field.

-Venkat

[Former Member]

Dear Venkat, Thank you very much...for your kindness..it was really supportive. And your answer was correct. Now my all problem solved. And smartform is working fine..  Thaks Abhay Manna

[Former Member]

hi, I need to delete one column from my table which is already created in tabale ....how would I delete that column??  Thanks Abhay

[venkat_aileni]

Hi-

Right click on the cell which you want to delete then select Delete -> Cell. This will delete cell in your table.

-Venkat

[Former Member]

Dear venkat, Thanks problem solved.. Thanks Abhay

[Former Member]

Dear Venkat, Now every thing is fine all data r coming proper...but..if u see the screen shot..there in 'Qnty ' column data is starting from second row(little bit down) though it is first row...still it is not coming in firstrow like other column dta r started..please find the attachment..   Thanks  Abhay Manna

[venkat_aileni]

Hi-

Can you paste a screenshot where you have defined your text cell for displaying quantity in your smart forms table.

-Venkat

[Former Member]

this are the screen shots

[Former Member]

One more screen shots ...please have a look..  Thanks  abhay

[venkat_aileni]

Hi Abhay-

I would like to see screen shot of your Table->Main Area ->Quantity text cell and not from Table header.

-Venkat

[Former Member]

Hi, sorry...now u please check the screen shot.. Thanks  Abhay

[venkat_aileni]

Hi-

Could not find anything needs to be changed, I have tried with the same field 'KWMENG' and got the desired output. Anyways try to adjust table borders and make sure you have given enough field length for the quantity field to be displayed. Increase length of the quantity cell and check.

Output:

-Venkat

[Former Member]

Dear Venkat, Thank you very much, Problem solved.. Thanks Abhay Manna.

[Former Member]

Dear venkat, now all things r fine...but user requirement is like..if you put multiple sales order number..then it shuld print each order no data in different page..but they want to put multiple order number together at a time in select option..how would I call form again and again in driver program..so that it could print different different order number detail in different defferent page.. Please share your knowledge..  Thanks  Abhay Manna

[Former Member]

and input screen shot

[venkat_aileni]

Hi-

I think you would like to consider multiple Sales Order's and want to print each sales order details in new page. No need to call Form again and again... Just pass that select option value to Form and fetch all the details of sales order's and sort your internal table by VBELN.

Now in your Main Window -> table -> Data tab -> Sort Criteria block give field name as VBELN select check box Event on Sort End.

Then an event block will be inserted in to your table main area there you need to create a command -> General Attributes Select check box Go to New Page and select your page 1 there.

-Venkat

[Former Member]

Hi Venkat Aileni, As you told ..I did the same thing. But still I am not getting the result.. Thanks Abhay Manna.

[venkat_aileni]

Hi-

Could you paste some screen shots relevant to above steps?

-Venkat

[Former Member]

Hi, In smartforms when I am retrieving a field "kwmeng " from vbap table that is quantity in output it is showing with decimal like 25.00 But user requirement is like they want it as with out decimal point they want to show quantity  in output as only number like 25 how would I convert it from 25.00 to 25 Please share your knowledge.. Thanks Abhay Manna.

[venkat_aileni]

Hi-

Please make use of this command &<your_variable(.0)>& this should work. Like &wa_vbap-kwmeng(.0)&

-Venkat

[Former Member]

Hi Venkat, Thank you very much your answer was completely right..it is coming now without decimal point..my problem solved..absolutely right answer..Thanks!! Regards Abhay Manna.

[Former Member]

Hi Venkat, 1)Please find the attachment..when I am cheking the driver program through code inspector then I am getting the  1 error,please advice me how to remove this error. 2)and please advice me how to get print for the multiple order number in one time.. Thanks Abhay Manna

[venkat_aileni]

In your code please un-comment Exceptions parameters of the FM.

  CALL FUNCTION fm_name "'/1BCDWB/SF00000031'

*   EXPORTING

*     ARCHIVE_INDEX              =

*     ARCHIVE_INDEX_TAB          =

*     ARCHIVE_PARAMETERS         =

*     CONTROL_PARAMETERS         =

*     MAIL_APPL_OBJ              =

*     MAIL_RECIPIENT             =

*     MAIL_SENDER                =

*     OUTPUT_OPTIONS             =

*     USER_SETTINGS              = 'X'

*   IMPORTING

*     DOCUMENT_OUTPUT_INFO       =

*     JOB_OUTPUT_INFO            =

*     JOB_OUTPUT_OPTIONS         =

    TABLES

      rorderno                   = RORDERNO

   EXCEPTIONS

     FORMATTING_ERROR           = 1

     INTERNAL_ERROR             = 2

     SEND_ERROR                 = 3

     USER_CANCELED              = 4

     OTHERS                     = 5.

To print multiple orders: You have to create a new structure in se11 as that of select-options with fields SIGN, OPTION, LOW and HIGH.

-> Create an entry in Form Interface Tables parameters by using above structure.

-> Pass your select-option value from driver program to smart form and use it like an select option.

Refer below link for more details:

Select Options in Smart Form

-Venkat