Excise invoice number from G/L account number

[Former Member]

Hi,

Can any help me in finding out Excise invoice data based on G/L account information

Regards,

Sowjanya

[Former Member]

hi,

consideringthat if u have gl account number then u also have accounting number. bkpf-xblnr.

if s

then

SELECT * FROM BKPF INTO TABLE GT_BKPF

WHERE AWTYP = 'VBRK' .

u will get gt_bkpf-AWKEY.

'0' + VBRK-VBELN = GT_BKPF-AWKEY.

IN THIS WAY U WILL GET VBRK-VBELN .

PASS THIS IN J_1IEXCHDR TABLE WHERE RDOC = VBRK-VBELN AND U WILL GET EXNUM.

HOPE THIS HELP.

[Former Member]

Hi Monika,

Thanks for ur reply.I have one more doubt which is extension to this

In FS10n (g/l acc balance display) transaction, after entering g/l acc,cocd, and fiscal year and excute, we get balances period wise, click on one of those, we get line items for that line,click on one line item, we get display document screen,

in that screen there is a field 'TEXT' at the bottom, i have to set the 'excise invoice no.' got above to this field.

I tried to search for customer exits for this program SAPMF05L but didn't find any.

Can you pls guide me if there is any other way like BTEs or anything else to solve this.

Regards,

Sowjanya

[Former Member]

for this u need to do bdc programming.

and then u can update ur excise invoice in that text field.