topic Re: select statement help in Application Development and Automation Discussions

select statement help

Former Member — Thu, 31 May 2007 22:08:01 GMT

hello abapers,

i need to extract data frpm table bkpf for the entered as parameter

p_period

where p_period has format yyyymm( yearmonth)

this period entered must match the

GJAHR + MONAT fields in the BKPF table.

GJAHR is the fiscal year

MONAT is the fiscal period in the BKPF table.

how do i do this, am i clear.

it is just extracting data from dbtable where

two fields must be combined to match the input parameter.

thankyou.

suresh_datti — Thu, 31 May 2007 22:14:21 GMT

select * from bkpf into itab

where gjahr eq p_period+0(4)

and monat eq p_period+4(2).

~Suresh

Former Member — Thu, 31 May 2007 22:15:37 GMT

thank you so much