Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Relation between BSEG with Asset Tables

HI Guru's,

how to find relation between BSEG with Asset Tables like ANLA and ANEP..

regards

JK

Tags:
Former Member
replied

Foreign keys

- ANEP items are linked to ANLA via fields in common ANLN1 and ANLN2

- ANEK header is linked to ANEP items via fields in common ANLN1, ANLN2, GJAHR and LNRAN

- BKPF and BSEG are linked to ANEL ANEP via BUKRS, BELNR and GJAHR

Optimization (as BSEG is behind a cluster table RFBLG)

- Append BSIS (ZABSIS) and BSAS with ANLN1 and ANLN2, then create an index with these fields. As BSIS is filled via MOVE-CORRESPONDING statement, only a one-shot report to initially fill the new fields is to be developed. (look at old OSS [Note 62435 - F-03: Selection by purchasing documents|https://service.sap.com/sap/support/notes/62435] for optimization via purchase order)

Regards

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question