can not get existing data from ztable

[Former Member]

hi all ,

i have create a z-table, and also the table maintenance. i maintenance my z-table via sm30.

but when i search one of the existing record in selection screen of se11 , i cannot get this record .

this record do exist in z-table.

did someone met this before ?

best regards

Kevin

[Former Member]

hi all ,

i have create a z-table, and also the table maintenance. i maintenance my z-table via sm30.

but when i search one of the existing record in selection screen of se11 , i cannot get this record .

this record do exist in z-table.

did someone met this before ?

best regards

Kevin

[Former Member]

Hi Kevin,

Are you sure that you have saved the record from SM30.

Check again in SM30 whether the record exists. If not , create a new one & ensure that you save the record.

Best regards,

Prashant

[Former Member]

Hi Kevin

Just make sure you save the entry after you have created them. Also check whether you are not creating an entry in one system and seeing it in another (Like creating an entry in development system and seeing it in quality, etc)

Hope this helps.

Regards

Harsh

[Former Member]

Hi,

Check Number of entries in that Ztable.

Regards

Md.MahaboobKhan

[Former Member]

Hi ,

The entries in the table maintenance generator is present in the database as well.

Probably you tried creating a new record through maintenance generator whcich is not saved so far.

That could be the reason why the entry is mssing in the SE11 view.

Regards,

Radhika

[Former Member]

Hi,

Try to search by putting * at the end of the value in selection screen of the ztable in se11

[Former Member]

Hi,

sometimes it depends on Case sensitive.

so better check domain of that perticular field (Lower case checkbox is clicked or not).

[Former Member]

hi all ,

first of all , i have to say that the record is definitly there . and one of the key is matnr.

i use a matnr which i found from the table on the selection screen , i cannot find the correspondence record .but if i specify all 2 key fields , the record shown.

so can anybody tell me why i cannot only use 1 key for selection ?

thank you all and regards

Kevin

[Former Member]

Hi Kevin,

I think there are multiple entries of the same key field and you are fetching the first record based on the key field matnr. Therefore it is fetching the first record from the multiple records.

If you use all the key fields then you can fetch the desired record.

Hope the answer of your question.

Regards,

Md Ziauddin.

[Former Member]

Issue solved!