Report not working in Production, but Working fine in Development & Quality.
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:
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
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.
Please share your valuable suggestions.
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.