Skip to Content
0
Former Member
May 13, 2008 at 07:16 PM

Issue with select query for secondary index

838 Views

Hi all,

I have created a secondary index A on mara table with fields Mandt and Packaging Material Type VHART.

Now i am trying to write a report

Tables : mara.

data : begin of itab occurs 0.

include structure mara.

data : end of itab.

*select * from mara into table itab*

CLIENT SPECIFIED where

MANDT = SY-MANDT and

VHART = 'WER'.

I'm getting an error

Unable to interpret "CLIENT". Possible causes of error: Incorrect spelling or comma error.

if i change to my select query to

*select * from mara into table itab*

where

MANDT = SY-MANDT and

VHART = 'WER'.

I'm getting an error

Without the addition "CLIENT SPECIFIED", you cannot specify the client field "MANDT" in the WHERE condition.

Let me know if iam wrong and we are at 4.6c

Thanks