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.