Skip to Content
avatar image
Former Member

Relation between BSEG with Asset Tables

HI Guru's,

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

regards

JK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Nov 20, 2008 at 07:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Nov 20, 2008 at 06:47 AM

    hi,

    use this.

    BSEG-ANLN1 = ANLA-ANLN1.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2008 at 06:49 AM

    Check for the Foreign key relation between these tables ..

    BSEG-ANLN2 = ANLA-ANLN2.

    ANLA-ANLN2 = ANEP-ANLN2.

    Add comment
    10|10000 characters needed characters exceeded

    • 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 .

  • avatar image
    Former Member
    Nov 20, 2008 at 06:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 30, 2015 at 07:31 AM

    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 ......

    Add comment
    10|10000 characters needed characters exceeded