Question related to tables

[Former Member]

Hi friends,

I want to use BSIS for my report but I guess it contains only uncleared documents. Right?

OR it contains both cleared and uncleared documents with an indicator and not necessarily only uncleared documents? If so, what is the field indicator that can explain if it is cleared or uncleared?

Please clarify and give your input.

Thanks,

Krishen

P.S. Thanks in advance for your time. Points assured for helpful answers.

[Former Member]

Hi,

Go through the documentation,

http://help.sap.com/saphelp_47x200/helpdata/en/b5/7f6d20da1011d3a79400104b57ed65/frameset.htm

Regards,

Azaz Ali.

[Former Member]

Iam not sure check the below fields in BSIS

SHKZG - Debit/Credit Indicator

XOPVW - Indicator: Open item management?

XRAGL - Indicator: Clearing was Reversed

XSTOV - Indicator: Document is flagged for reversal

XARCH - Indicator: Document already archived ?

XNEGP - Indicator: Negative posting

Regards,

Prakash.

[ferry_lianto]

Hi Krishen,

BSIS table stores all open items (uncleared) and BSAS tables stores all closed items (cleared).

BSEG table stores all open and closed items.

Regards,

Ferry Lianto

[Former Member]

HI,

Look at the Filed <b>BSTAT</b> in the table ..

If it is not satisfied, then you can use another way, but it might not good.

You can get the Document no's and add the Debits and Credits for that Document no, if the Debits and credits are equal then it is Clear Document otherwisae it is uncleared Document

Regards

Sudheer

[Former Member]

Thanks for your quick reply guys. I am in the process of testing.

[Former Member]

I think Ferry is correct but not sure.

[Former Member]

only open items are there in BSIS and no closed items are there in BSIS.