Skip to Content
0
Former Member
Apr 22, 2010 at 01:11 PM

how to restrict field of BSEG using for all entries in

58 Views

Hi All,

i want restrict field BSEG-UMSKZ by using for all entries in but facing some problem.can someone tell me how to use with example.If you want to see my Query is this.

SELECT: bkpf~belnr

with_item~buzei

bkpf~blart

with_item~wt_acco AS lifnr

lfa1~name1

lfa1~stras

lfa1~ort01

lfa1~stcd2 AS lifntn

lfa1~stcd1 AS lifnic

bkpf~budat

wt_qsshb AS dmbtr

qsatz

witht

wt_withcd

wt_qbshb

hkont

with_item~wt_wtexmn

INTO CORRESPONDING FIELDS

OF TABLE gi_accdocs

FROM bkpf

JOIN with_item

ON ( with_itembukrs = bkpfbukrs AND

with_itembelnr = bkpfbelnr AND

with_itemgjahr = bkpfgjahr )

JOIN lfa1

ON ( lfa1lifnr = with_itemwt_acco )

WHERE bkpf~bukrs EQ p_bukrs AND

bkpf~gjahr EQ p_gjahr AND

bkpf~budat IN s_budat AND

bkpf~stblg EQ space AND

wt_withcd IN s_withcd AND

with_item~wt_acco IN s_lifnr AND

with_item~hkont IN s_hkont AND

bkpf~belnr IN s_belnr.

Thanks & Regards,