cancel
Showing results for 
Search instead for 
Did you mean: 

Vendor Return Excise Invoice- VAT/CST

Former Member
0 Kudos

Dear All,

I want to return the material to vendor after invoice verification and before payment.

So entered the credit memo, Return material 122 mov type, Create Excise Invoice.

Now in my Excise Invoice print format i want CST and VAT to be printed.

Now my query is i want the table from which i can fetch the CST or VAT amount which i posted in credit memo.

Regards.......

Edited by: akshay sonurkar on May 19, 2010 11:15 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

the table name u want is BSET

hear u will have to give Accounting document number and year FOR THE CREDIT MEMO

BSET-KSCHL will give the condition type CST or VAt condition type

BSET-HWSTE u will get LC tax amount amount for cst or vat condition type

hope not things are clear

account document and MIRO document link u can get in BKPF

AWKEY will be ur MIROnumber + year

and BELNR is ur account document number for MIRO

hope now u got the answer and it helped u

Former Member
0 Kudos

Dear Umakant,

Thanks for the valuable reply.

Now i came to some conclusion.

But in table BKPF i am seeing two document for MIRO transaction. One is original invoice document and second is Credit memo.

Now want to know how do i differentiate between these two numbers?

I want to choose Credit Memo doc no.

Please suggest...........

Edited by: akshay sonurkar on May 19, 2010 1:41 PM

former_member192897
Active Contributor
0 Kudos

Document type for Credit Memo would be RC. Choose BKPF- BLART=RC

Check with technical team once

Former Member
0 Kudos

Thanks Umakant,

I have solved the queries. The solution is:

If Invoice

RBKP-XRECH - X

RSEG u2013TBTKZ - blank

If Credit Memo

RBKP-XRECH - blank

RSEG u2013TBTKZ - blank

If Subsequent Debit

RBKP-XRECH - X

RSEG u2013TBTKZ - X

If Subsequent Credit

RBKP-XRECH - Blank

RSEG u2013TBTKZ u2013 X.

Regards

Akshay

Edited by: akshay sonurkar on May 21, 2010 7:28 AM

Former Member
0 Kudos

Hi,

For the table fields and details u can get more details from your abaper , if you creating excise invoice , the billing document is generated and when the billing document is generated the table VBRK - For header details and VBRP for line item details are updated,

So as per your requirement From the Table VBRK select field KNUMV by given the billing document number in VBELN filed from VBRK u will get KNUMV number with that number from table KONV select the KBETR and WAERS fileds for tax amount and currency also give the Condition which is indicating the tax type while selecting data from KONV.

regards,

zafar

Answers (1)

Answers (1)

former_member187989
Active Contributor
0 Kudos

Check Table - RSEG

Check this answered link

Former Member
0 Kudos

Not answered.