Problem in Retrieving data from Z table

[Former Member]

Hi Expets

I created a Z table in this i made storage unit no as a primary key. while accessing(retrieving) the data from the Z table, passing storage unit no, I am n't able get the output. Please give me a solution for this.

Thanks

Mani.S

[kesavadas_thekkillath]

I am just guessing as you have not provided more details.

Change the data type of the key field from CHAR to NUMC.

[Former Member]

hI

Actually i created z table in which i have following fields matnr lgnum erdat when i pass matnr to z table i can retrive data but when i pass storage unit number with zeros and without zeros to the table . i cant able to fetch it shows error message no table entries found for specified key. i am just passing value to z table not in program

[Former Member]

Hi mani.s ,

first of all try and add mandt field and second suggestion sound to be a bit silly but check wheather u have entered zero or alphabet 'O' in ur lgnum enteries .

[Former Member]

Hi Ranjan,

i added mandt field and checked by passing zeros also still i am not getting

[kesavadas_thekkillath]

Actually i created z table in which i have following fields matnr lgnum erdat when i pass matnr to z table i can retrive data but when i pass storage unit number with zeros and without zeros to the table . i cant able to fetch it shows error message no table entries found for specified key. i am just passing value to z table not in program 

Provide the details(data type) of the particular field, 2 records from the table and your input, details if conversion exit used in domain.

Kesav

[Former Member]

Hi S.mani ,

Do u mind giving the enteries which u have entered in ur table lgnum field ??

regards

ranjan

[lijisusan_mathews]

try using CONVERSION_EXIT_ALPHA_INPUT .. before passing it to table

[Former Member]

Hi Keshav,

I used field name suno and data element as lgum and i passing suno value if i do with same in standard table in linv for lgnum field i am getting value but i am not getting in my z table.

[Former Member]

Hi,

ok I am trying to create entries for the z table by create entries it is not saving storage unit number in database

[deepak_dhamat]

Hi ,

@mani : Please check you might have created Table with field

MANDT -Client

storage unit no - Primary key .

a

b

c

But according to table creation you will be storing only Single value in Table .

check whether you are passing the same value which is present in Table entry .

Check table entry using SE16

regards

Deepak.

[Former Member]

Hi Mani.S ,

Can you elaborate ur problem in detail , means weather u fetching data on same client or not and if possible paste ur code .

Regards

Ranjan Tiwari

[RaymondGiuseppi]

Which domain/data element did you use for "storage unit number", if it is the standard "LENUM", there is a conversion exit "LENUM". Check that you respect this conversion unit when reading from database but also when inserting into database. Use CONVERSION_EXIT_LENUM_INPUT to convert external format (display) to internal (database)

Regards,

Raymond