How to identify open and cleared in ACDOCA

[Former Member]

Dear All,

We are in the process of developing a report for which we need to get the cleared and open items as on key date in S/4 HANA (1709)

Earlier we use to refer BSIS,BSAS table for the same.

Now in S/4 hana, how to fetch the open items and cleared items for a key date in ACDOCA.

or is it still advisable to use the BSIS/BSAS and fetch the data?

Please advise.

Regards

Usha

[ajaycwa1981]

You can read from BSIs and BSAS views

Else look at the field Augbl (clearing doc). If that is blank, it means open

[Gustavo_Vazquez]

Hi Usha,

BSIS / BSAS tables are still available for reading, they are views of ACDOCA table.

I have found a FM for AR / AP but not GL - Check if exists FM BAPI_AR_ACC_GETOPENITEMS for customer.

Kind Regards

[charliee]

Hi Gustavo,
Following on Usha's question, we have the same dilemma.
Do you know how the custom append structures are handled where they had been defined in the old BSIS table? The new BSIS view does not have them any more. They are in the backup table BSIS_BCK.
Should these custom fields be read from BSIS_BCK or ACDOCA?

Thanks,

[Gustavo_Vazquez]

have you read sapnote

2403232 - Extending the Universal Journal with Customer fields ?

Kind Regards