Skip to Content
0
Former Member
Feb 25, 2009 at 02:23 PM

Shall I use SELECT SINGLE??

35 Views

Iu2019ve retrieved MSEG-MATNR for the condition mseg-mblnr = material doc no. and mseg-mjahr = mat doc year and mseg-zeile = mat doc item.

And my retrieved data mseg data in i_mseg is like below:

Mblnru2026u2026u2026..mjahru2026..zeilen.u2026u2026.matnr

0049000242....1995......0003........YY-110

0049000242u2026.1995u2026u20260004u2026u2026.YY-120

0049000248....1995u2026u20260001u2026u2026..40-110C

0049000248u2026.1995u2026u20260002........40-200C

0049000248u2026.1995u2026u20260003........40-210

0049000248u2026.1995u2026u20260004........L-40C

Now Iu2019ll have to fetch:

MAKT-MAKTX for the condition MAKT-MATNR=MSEG-MATNR and MAKT-SPRAS = u2018ENu2019.

Shall I use select single or normal select queries for makt-maktx retrieval?

If select single, then why and if not, then why?

Can anyone please guide?

Regards.