Uploading long text as one long text for the same records.

[Former Member]

Hi,

i am uploading long text into one custom application.in that i had one issue,

I am uploading long text with the combination of material,palnt,division,sales organization and distribution channel.

Now my reqiurement is when ever two or more than two records are same for the material,palnt,division.The respected text shulod be created as a single text.

will any body suggest me with logic, how to handle it?

[Former Member]

Hi,

Lets say TEXT1 is having all the text concatenated with MATNR, VKORG, VTWEG and so on.

Lets say TEXT2 is having same key combination but different other fields.

Now lets say TEXT1(26), I.E. first 26 characters contain your key combination.

Now compare the strings of TEXT1(26) with the TEXT2(26), usng the COMARE STRING (CS) operation, if both are same just ignore the one which is not required.

[Former Member]

Hi,

i am having records like this...

MATNR VKORG VTWEG TEXT

865498 0012 00654 test1

865498 0012 00654 test2

865498 0012 00654 test3

865498 0012 00654 test4

865498 0012 00654 test5

865498 0012 00654 test6

865498 0012 00654 test7

in the above test data MATNR , VKORG, VTWEG records are same but TEXT is different.

Now my requirement is , i need to upload the data in to application as

MATNR VKORG VTWEG TEXT

865498 0012 00654 test1test2test3test4test5test6test7

how can i handle it?

[Former Member]

Hi Mythily,

First of all just try to find out the name of the internal table where these records are populated. & then use

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING material,palnt,division.

I hope this solves your problem.

Please set to resolved , if that helps you..

Regards

Abhii...