customize table problem

[former_member533538]

Hello,one of my report program can't select data from my customize

table 'ZLIKP',the related part of source code is as below:

SELECT b~LFDAT AS WADAT

b~VBELN

b~VGBEL

b~KUNRG AS KUNNR

a~POSNR

a~LFIMG

b~LIFSK

a~MATNR

a~PSPNR

INTO CORRESPONDING FIELDS OF TABLE detail_itab

FROM ZLIKP AS b inner JOIN ZLIPZ AS a ON a_{VBELN = b}VBELN

inner JOIN VBAK AS C ON C_{VBELN = A}VGBEL

WHERE

a~VGBEL IN S_VGBEL

AND b~VBELN IN S_VBELN

AND b~KUNRG IN S_KUNNR

AND b~LFDAT IN S_WADAT

AND C~AUART IN S_AUART.

*********************************************************

when i don't fill the selection variant S_KUNNR and run the program,it

can select data from table ZLIKP,if i fill,it can't ,but table ZLIKP

has some reords that meets the select criteria actually,if i use this way:AND b~KUNRG = '100001',it also can select data from ZLIKP.

And then,i found the customize table has some problem,i run tcode

SE11,browse the table zlikp,i also can't select data from this

table directly,i fill the KUNRG variant,click 'number of entries' ,it show up the entries is zero.someone can help me?

[Former Member]

Hi,

Possible options:

1) Go to SE14, Generate and Save the table. OR

2) Delete the table maintenance and recreate the same, then you enter the data into the table.

Regards

Shiva

[Former Member]

Someone has replaced standard SAP delivery tables with Z versions? Good way to end a budding SAP/IT career.

[Former Member]

ZLIKP-KUNRG likely has a conversion exit associated with it. You'll have to take that into account when doing your SELECT.

Rob

[Former Member]

Hi,

If the table configuration is ok,

Can yo try to create S_KUNNR for LIKP-KUNAG instead of KNA1-KUNNR or so.

Please update..

Thanks,

Anmol.

[former_member533538]

thank you guys,i find out the solution now,the customize table didn't add the leading zero to the KUNRG filed,and the S_KUNNR has the leading zero,so KUNRG didn't match S_KUNNR,therefor,it can't fetch data from table.