topic Re: How to avoid duplicate entry while printing the smartform in Application Development and Automation Discussions

How to avoid duplicate entry while printing the smartform

Former Member — Tue, 02 Jul 2013 06:06:13 GMT

Hi Expert,

In my development i have to duplicate values while printing the smart form.

This is my layout,

My output should be,

Based on the line item it should avoid the duplicate values.But in some case different Bin & Pallet should come under same item no.

In that case o/p should come like below

Eg:

10 1..RAW......... S1 Raw A9BOT2 158 8000000136

A9BOT3 159 8000000137

Re: How to avoid duplicate entry while printing the smartform

Former Member — Tue, 02 Jul 2013 06:54:43 GMT

Hi,

Capture the value in a variable and check whether the previous value and the current value is same before entering into the text. Put a condition there that if both are different then enter into the text.

So like this it will not print the duplicates.

Re: How to avoid duplicate entry while printing the smartform

Former Member — Tue, 02 Jul 2013 06:56:19 GMT

Hi Prabu,

In your output internal table define two more fields of type C.

Before line item display node, create a code node and write logic to indentify the duplicate entries and set the flag on every new pattern.

Ex:

LOOP AT itab ASSIGNING <fs_line>.

AT NEW item_no.

<fs_line>-flag1.

ENDAT.

AT NEW bin.

<fs_line>-flag2.

ENDAT.

ENDLOOP.

While printing the output internal table rows just check these flags to control the duplicate values.

Regards

Praveen

Re: How to avoid duplicate entry while printing the smartform

Former Member — Tue, 02 Jul 2013 07:02:54 GMT

Hi ,

Try to sort out you internal table based on primary key or secondary key or based on a field which you want and then use DELETE ADJACENT for same internal table.

Re: How to avoid duplicate entry while printing the smartform

Former Member — Tue, 02 Jul 2013 07:11:23 GMT

HI,

Use can use delete adjacent dublicates from (Internal Table)

Re: How to avoid duplicate entry while printing the smartform

Former Member — Tue, 02 Jul 2013 07:21:29 GMT

Hi,

Use table events in smartform then you will get required output.