SAP Tables

Relationship between MM & FI

This field contains RBKP-BELNR + RBKP-GJAHR = BKPF-AWKEY.

e.g. BKPF-AWKEY = 51056059232009

                  5105605923         - RBKP-BELNR

                            2009  - RBKP-GJAHR

Edit SAP Tables

1. Go to SE16N.
2. Give the table name
3. Enter “&SAP_EDIT” in the command line.
4. See the message
5. Then execute (F8).
6. You can edit table entries now!!!

    or Go to UASE16N

Relationship between VBRP & KONV

    You will get konv document number from vbrk-knumv.
     KONV-POSNR = VBRP-POSNR
     The ref schedule lines in vbrp you will get from :
     VBRP-J_3AETENR
     VBRP-J_3AUSIZE
     VBRP-J_3AVGETE
     KONV-J_3AETENR = VBRP-J_3AETENR
     The higher level item of the split item will be described in the field vbrp -j_3ausize

Faster method to access MSEG    
When we have to access MSEG it will be a more inefficient search because most of the time we have to access
the table by MATNR, BWART, WERKS which are not key fields of the table.
Here is a faster method to get movement info from MSEG :
Use table S033 by giving MATNR or any other key out of 11 key fields and get material document number (MBLNR)
This MBLNR is the key field in MSEG, so you can do a direct access instead of a sequential search.
Hope this will help you to improve the efficiency of your search.