functional location realded problem

[Former Member]

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

[Former Member]

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

[former_member219399]

Hi,

The field for Functional Location is TPLNR. THis will be availale in IFLOT or ITOB.

You can use either of these tables. First identify based on whcih you would like to fetch the TPLNR.

With regards,

Vamsi