Reply: 5

Auto translated

Tables of open items BP in S/4 HANA

Hello All,
As far as I understand the table assignment for business partner would be as follows:

    Business partner general: BUT000
    Address data : ADRC
    Supplier data FI: Views from tables LFA1 and LFB1
    Supplier data PUR: View from table LFM1
    Bank data: BUT0BK

But what about the open items? Are they still stored in BSIK or is there a new table for this?
I read somewhere that the tables BSIK and BSAK are obsolete.
Furthermore, I wonder if it is possible to jump to the open items list from the business partner.
I would be very grateful for any information.
Thank you and best regards,
SAP Junior

You must be logged in to post a reply.

Login now

5 Answers

  • kerger66
    kerger66
    Hello,
    I have not found a jump in the standard, but with a standard extension this should certainly not be a problem. You have to ask a developer. The open items are in the ACDOCA and there is a view for the BSIK, which I think reads the data from the ACDOCA.
    Kessi
  • umfried
    umfried
    Hi Kessi,
    open items of financial accounting are managed in S/4 only in BSEG and ACDOCA and - in the simple case of non-ledger specific clearing - only read from BSEG. But note: if for some reason (inconsistencies from earlier time) there is still a record in parallel at the same time in the tables BSAS_BCK, BSAD_BCK or BSAK_BCK, which has filled the archive FLAG (XARCH = "X"). Then this has priority and you don't see the open item, but the cleared one. But as I said, this only applies to the case of a possible inconsistency from a previous time or migration. The BSxx_BCK would then have to be cleaned up first.
    Hope that helped.
    Umfried
  • SAP-Junior
    SAP-Junior (Author)
    Hello together,
    thank you very much for the helpful and interesting answers. For me it means the following:
    The ACDOCA table is considered the central table in S/4 HANA.
    Nevertheless, the tables BSIK, BSID, BSAD and BSAK still exist.
    The open items are shown in table ACDOCA and have a VIEW from tables BSIK, BSID, BSAD and BSAK.
    Thank you for your contributions and best regards,
    SAP Junior
  • djwavelab
    djwavelab
    Hello all,
    I have a question about this:
    I have developed a program for a customer, which among other things also reads open items from the BSIS. Since all line items are now in the ACDOCA: can the BSIS disappear from SAP at some point? What selection would have to be used for ACDOCA to find the same open items for a G/L account in a company code as from BSIS. For example, if I select ledger 0L, company code, G/L account and clearing document no. = '', I get more items from ACDOCA than from BSIS. Anyway, I don't see a special field for clearing status there. Does anyone have an idea what selection can be missing there?
    Best regards
    Rado
  • exberliner
    exberliner
    Hello Rado,
    there is a Compatibility View for the table BSIS in S/4HANA. I.e. in ABAP can be read further from the table BSIS (read-only!). Whether BSIS will disappear at some point - don't think so.
    Regards
    Exberliner