Skip to Content
0
Former Member
Apr 14, 2014 at 11:00 AM

UNIQUE Problem in pulling DATA from DATA base table to internal table

28 Views

Dear Experts,

I am new to ABAP. I have a very basic question but looks a quite puzzling one to me. Hemnce I am posting it here.

I am facing an unique problem in pulling data from database table and populating that data into internal table for further use.

The data in the database table "Zlt_mita" with fields M1 (Employee Name, Type: Char20) and M2 (Employee Code, Type Char7) are:

Plz refer the screenshot in the attached file:

My Code:

1) When I try to pull data from Dbase table by taking M2 as parameter.

This code is succcessful and I am able to populate data in internal table it_dat.

TYPES: Begin Of ty_DAT,

M1 TYPE Zlt_mita-M1,

M2 TYPE ZLT_mita-M2,

END OF ty_DAT.


DATA: it_dat TYPE STANDARD TABLE OF ty_dat with header line,

wa_dat TYPE ty_dat.

PARAMETERS: p_mitar TYPE Zlt_Mita-M2.

SELECT M1

M2

FROM ZLt_mita

INTO TABLE it_dat

Where M2 = p_mitar.


Loop at it_dat into wa_dat.

WRITE:/2 wa_dat-M1,

10 wa_dat-M2.

ENDLOOP.

2) When I try to pull data from Dbase table by taking M1 as parameter.

This code is NOT succcessful and I am NOT able to populate data in internal table it_dat.

TYPES: Begin Of ty_DAT,

M1 TYPE Zlt_mita-M1,

M2 TYPE ZLT_mita-M2,

END OF ty_DAT.


DATA: it_dat TYPE STANDARD TABLE OF ty_dat with header line,

wa_dat TYPE ty_dat.

PARAMETERS: P_Mita TYPE ZLT_Mita-M1.

SELECT M1

M2

FROM ZLt_mita

INTO TABLE it_dat

Where M1 = P_Mita.

Loop at it_dat into wa_dat.

WRITE:/2 wa_dat-M1,

10 wa_dat-M2.

ENDLOOP.

Why is this happening when both M1 and M2 are Type Character fields.

Looking forward for your replies.

Regards

Chandan Kumar

Attachments