Which table to query for reversal document created using fb60.

[former_member224405]

hi i need to build a query to fetch the details for the document which i reveresed using fb60 .

i need to fetch the details of the document reversed i need lifnr also hence suggest me the table where i need to query.

thanks,

[Former Member]

Check the field XRAGL in tables BSAK & BSIK.

Regards

Vinod

[SuhaSaha]

If a reversal document is created you can query from BKPF itself. You can check the fields STBLG & STJAH for reversal doc details.

@Vinod: XRAGL is the clearing indicator & not reversal doc indicator. I hope you understand the difference between clearing & reversal of an a/c'ing doc.

Edited by: Suhas Saha on Apr 27, 2010 5:39 PM

[former_member224405]

Thanks vinodh,

i have the data required in BKPF i need to filter it by the condition containing lifnr.

SELECT lifnr

xblnr

bldat

FROM bkpf

INTO TABLE i_reversal2

FOR ALL ENTRIES IN i_an_ven

WHERE lifnr = i_an_ven-lifnr

AND cpudt >= date_in

AND cputm >= time_in

AND stblg <> ' '.

but bkpf doesnot contain stblg hence i m facing problem.

thanks.

[brad_bohn]

No, you have a syntax error in your SELECT statement. STBLG is the correct field.

[former_member224405]

it is acctually like this.

SELECT lifnr

xblnr

bldat

FROM bsik

INTO TABLE i_reversal2

FOR ALL ENTRIES IN i_an_ven

WHERE lifnr = i_an_ven-lifnr

AND cpudt >= date_in

AND cputm >= time_in

AND stblg <> ' '.

and no field called stblg.

thanks,

[Former Member]

From BSIK (and BSAK if needed), you use the SELECT you have to get all documents for your vendor number(s). Using the document numbers from BSIK, SELECT from BKPF where STBLG is not initial.

Rob

[Former Member]

hi,

Check the table BSEG.