Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Report not working in Production, but Working fine in Development & Quality.

Dear All,

One of the report is working fine in development and Quality system, But not in production.

Here in production system 1st select statement getting the data from Z table and 2nd select statement not getting any data from BKPF table as mention in  where conditions.

And we are getting 2 errors in code inspector like:

1. Large Table ziftr_reqlog_adp: No first field of a table index in where condition

2.Large Table bkpf: No first field of a table index in where condition

Here I attached my Ztable fields screen and below mention code is written in my report:

  SELECT     uniqid
          ldate
          legacy_id
          docnumber
FROM ziftr_reqlog_adp
         
INTO TABLE it_reqlog_adp
         
WHERE ldate IN s_ldate AND
                docnumber
NE ''.

 
IF NOT it_reqlog_adp[] IS INITIAL.
   SORT  it_reqlog_adp BY  ldatedocnumber.

*******Fetching data from BKPF with entries in ziftr_reqlog_adp

   
SELECT bukrs
           belnr
           gjahr
           blart
           bldat
           budat
           cpudt
           xblnr
           bktxt
           waers
           kursf
           hwaer
FROM bkpf INTO TABLE it_bkpf
          
FOR ALL ENTRIES IN it_reqlog_adp
          
WHERE ( belnr  = it_reqlog_adp-docnumber ) AND
                
( blart  = 'I4' OR  blart  = 'I5' ) AND
                
( cpudt  IN s_ldate ) .
   
SORT it_bkpf BY bukrs belnr cpudt.
 
ENDIF.

Please share your valuable suggestions.

Regards

Rajasekhar S

ZTable Fields.JPG (107181 B)
Former Member
Former Member replied

There is a conversion exit (ALPHA) on BKPF-BELNR. So you will have to manually pad the document number from your custom table with leading zeroes or better still, add the same conversion exit to that field.

Rob

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question