Skip to Content
0
Former Member
Aug 13, 2008 at 06:48 AM

Select query Problem

219 Views

Hi All ,

If not t_zcust[] not initial.

select BUKRS BELNR GJAHR XBLNR BLART DMBTR WRBTR from BSIS

into corresponding fields of table t_bsis

for all entries in t_zcust where

XBLNR EQ t_zcust-fileid and

BUKRS EQ '1010' and

BLART EQ 'KR'.

endif.

The above select query is correct as per syntax but here my problem is

In where condition i am checking XBLNR with T_ZCUST-FILEID.

XBLNR is length of Char 16 and FILEID is length of NUMC 10.

and we can not change the T_ZCUST-FILEID field technical attributes

How to Map the above condition in the above select query , is there any alternative way is there.

Thanks

Sathish.