Relation between BSEG with Asset Tables

[Former Member]

HI Guru's,

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

regards

JK

[raymond_giuseppi · Accepted solution]

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

[Former Member · Accepted solution]

i want to make relationship between bseg and asset master tables when i compare

ANEK-ANLN1 and bseg-anln1 the value in bseg is * what it means

[former_member220286]

Hi Raymond ,

Please suggest me the tables sequence for extracting the data for the TCODE : ABUMN .

I have to capture the document number generated through ABUMN and display that document  number  in my smart form  .

Any ideas please suggest ......

[Former Member]

Hi,

Here is the way to find the relation.

1. Use SQVI transaction,

2. Create a View

3. Enter title,

4. Choose the Data source as Table Join

5. Now use Insert table option.

6.And insert the tables which you want. It will propose the relation between them.

Thanks

Nitesh

[Former Member]

Check for the Foreign key relation between these tables ..

BSEG-ANLN2 = ANLA-ANLN2.

ANLA-ANLN2 = ANEP-ANLN2.

[former_member220286]

Hi Avinash ,

Please suggest the flow of table to extract the data for the TCODE : ABUMN

so that I can capture the document no posted through asset transfer .

[GauthamV]

hi,

use this.

BSEG-ANLN1 = ANLA-ANLN1.

[Former Member]

HI,

I created Asset Acqusition with PO Details report with same way.if i take values from BSEG report performace is very slow even for one month also.. any alternative avaialable for accounting documents details for Assets..

regards

JK

[GauthamV]

hi,

then use these tables which also has the same.

BSAD

BSAK

BSID

BSIK.

[Former Member]

HI,

Some entries not available.. like intercompany transfers..

regards

JK

[GauthamV]

hi,

check this table.

T8J1J.

Note: 190 unresolved questions in 239 posts ?