Skip to Content
0
Former Member
Jun 10, 2009 at 03:22 PM

functional location realded problem

40 Views

Hi All,

I am getting proble in following case,

I am having one ztable having fields BELNR (accounting doc. number)

BUKRS (company code)

GJAHR (financial year)

ABELNR (accrual doc)

DBELNR (deferral doc)

RBELNR (reversal doc no)

RBUDAT(posting date in the doc)

now I have to display functional location TPLNR or BTPLN in the output list along with the above field of ztable. I don't know which table will be suitable to fetch the functional location.

I tried with

ztable-belnr join with bkpf-belnr and

BKPF-XBLNR JOIN WITH VIQMEL-QMNUM

to get BTPLN as functional location, but I didn't get any result

or simply when I am doing BKPF-XBLNR JOIN WITH VIQMEL-QMNUM, i am not getting any result

So any one please suggest some solution for the above case so that i can display functional location.

Thanks