Skip to Content
1
Former Member
Aug 08, 2007 at 11:13 AM

How to use operator cp in a query

1386 Views

Hi ,

Below i have decleared a query to get order number comparing maintenance plant and order type .

i need to use CP Operator .i this can any buddy help me out how to use cp operator .

select AFIHIWERK AUFKAUFNR AUFK~AUART INTO TABLE ITAB

from ( AFIH

inner join AUFK

on AUFKAUFNR = AFIHAUFNR )

where AFIH~IWERK BETWEEN PLANING_PLANT-LOW AND PLANING_PLANT-HIGH

AND AUFK~AUART BETWEEN ORDER_TYPE-LOW AND ORDER_TYPE-HIGH.

Thanks ,

vinay.