topic Re: BSEG fields for BSIS table in Application Development and Automation Discussions

BSEG fields for BSIS table

pawadee_k — Fri, 20 May 2022 15:53:10 GMT

Hi Experts,

I am working on a report to list all accouting documents for given GL Accounts.
The individual documents can be display via FB03.
When I look at technical infomation from fields in FB03 most of them are pointing towards BSEG table.

BSEG is a cluster table which I can't use but it made up of BSAD, BSID, BSIK, BSAK, BSIS and BSAS.
So I found the corresponding records I looked for in BSIS and BSAS but some fields that I need for the report are missing.

- ZUONR
- VBEL2
- POSN2
- MATNR
- MENGE

For MATNR and MENGE seems to in table BSIM.
Please advice on which other table to do need to get all the fields above.

Thanks & Regards,

Pawadee

Re: BSEG fields for BSIS table

RaymondGiuseppi — Fri, 20 May 2022 16:04:26 GMT

Usually, in a non-Hana/non-New-Ledger system, an initial selection is made on BSIS and BSAS, then the extracted table is enhanced with data from BSEG (FOR ALL ENTRIES with full primary key) and BKPF (could also be JOIN to BSIS/BSAS).

NB: In case of frequent requests and performance concern, it is possible to add some BSEG/BKPF fields in a BSIS/BSAS append. As those tables are filled by move-corresponding, it is only necessary to initialize these fields once during the enhancement.

Re: BSEG fields for BSIS table

pawadee_k — Fri, 20 May 2022 16:14:33 GMT

Hi Raymond,

I am planning to expose the record to a bi tools but since BSEG is a cluster table, it couldn't be access from outside.
Is there any other way around it?