topic Re: UNIQUE Problem in pulling DATA from DATA base table to internal table in Application Development and Automation Discussions

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

Former Member — Mon, 14 Apr 2014 11:00:43 GMT

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

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

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

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

Former Member — Mon, 14 Apr 2014 11:08:22 GMT

Hi,

as this is character format, while passing m1 use exact characters as there are in ztable. ie. for example m1 = 'Alexander Schmitz'. Try to put exactly this in your selection screen and it should work.

Regards-

Makarand

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

former_member206650 — Mon, 14 Apr 2014 11:15:43 GMT

Hi,

check if the domain of M1 is having the lower case tick or not and enter the name with space as in Database.

hope it helps...

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

Former Member — Mon, 14 Apr 2014 11:45:11 GMT

Hi Chandan ,

Database fetch is case sensitive ,So u need to give exact format in where condition.

Make your parameter and database in same case so that you need not worry about case sensitivity .

Check the lowecase check box in the domain .

Then declare your parameter

PARAMETERS:

P_Mita

TYPE ZLT_Mita-M1 LOWER CASE .

You can do the vice versa also by unchecking lowercase and giving Upper case instead of lower in parameter declartion .

Regards ,

Juneed Manha

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

Former Member — Mon, 14 Apr 2014 12:31:27 GMT

Hi Chandan Kumar,

I got curious, why you where not getting the answer and so I decided to try the same in my system and found no errors.

Hope you have tried it again and it's solved.

PS: If not, please share your error in the code.

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

Former Member — Tue, 15 Apr 2014 08:57:53 GMT

Hi all,

Thanks a lot help a biginer like me. Sometimes such small things heat up ur brain.

Thanks, the above suggestions helped me to solve my problem.

Regards

Chandan Kumar