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.