Relation between REGUP and RSEG tables.
I want to find out the Purchasing Document number from RSEG table. How to proceed for that.
Initially i am having the values of LAUFD, LAUFI, ZBUKR, LIFNR, VBLNR, BELNR
fields which i am using to find out the values of BUKRS BELNR GJAHR BUZEI
from the REGUP table.
Now i am using BUKRS BELNR GJAHR to find out the value of AWKEY from the BKPF table.
Using the first 10 characters of the AWKEY field as BELNR and GJAHR, BUZEI from the REGUP table i am trying to find out the value of PO number(EBELN) but i am not getting the correct PO number because of the BUZEI field.
I am not getting the correct linkage between the two tables.
Please help me out.