Skip to Content
0
Nov 11, 2010 at 11:15 AM

customize table problem

26 Views

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 aVBELN = bVBELN

inner JOIN VBAK AS C ON CVBELN = AVGBEL

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?