select statement help

[Former Member]

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.

[Former Member]

select * from bkpf into itab

where gjahr eq p_period+0(4)

and monat eq p_period+4(2).

~Suresh

[suresh_datti]

select * from bkpf into itab

where gjahr eq p_period+0(4)

and monat eq p_period+4(2).

~Suresh

[Former Member]

thank you so much