Skip to Content
0
Former Member
Dec 02, 2008 at 06:39 AM

Need o/p in following format

34 Views

Hi All,

Presently im getting an output of my Select statement like this:

0000000000279012,Service E777: please enter a price

0000000000279012,Purchase order still contains faulty items

0000000000279012,No instance of object type PurchaseOrder has been created. External re

0000000000279023,Purchase order still contains faulty items

0000000000279023,No instance of object type PurchaseOrder has been created. External re

0000000000279025,Service E221: please enter a price

0000000000279025,Purchase order still contains faulty items

0000000000279025,No instance of object type PurchaseOrder has been created. External re

0000000000279031,User NATARAK already processing Contract 4600000024 &

0000000000279031,Purchase order still contains faulty items

0000000000279031,No instance of object type PurchaseOrder has been created. External re

But i want it like this:

0000000000279012: Service E777: please enter a price

Purchase order still contains faulty items

No instance of object type PurchaseOrder has been created. External re

0000000000279023: Service E221: please enter a price

No instance of object type PurchaseOrder has been created. External re

...so on......

I tried usig distinct..but it is not solving the purpose.

SELECT distinct docnum FROM edidc

INTO CORRESPONDING FIELDS OF TABLE lt_edidc

WHERE credat BETWEEN s_credat-low AND s_credat-high AND

sndprn = p_sndprn AND

status = p_status AND

mestyp = p_mestyp AND

idoctp = p_idoctp.

IF lt_edidc[] IS NOT INITIAL.

SELECT * FROM edids

INTO TABLE lt_edids

FOR ALL ENTRIES IN lt_edidc

WHERE docnum = lt_edidc-docnum AND ( statyp = 'A' OR statyp = 'E' ).

ENDIF.

Please help.

Thanks and regards,

Meena.