How to link vendor invoice and customer invoice?

[Former Member]

Hello SAP Experts,

I got to create one smartform which should show Invoice of Customer (to whom Company sells the product) and also Invoice of Vendor ( to whom Company have purchased the raw material). Now I want to link both the Invoices of Customer and Vendor so I can get both the invoice on the same page. Can anybody suggest me from which table name and field name I have to fetch the data? Hope I am clear with the question. Also looking for which table all condition type I can found which is in Vendor Invoice? Thank you very much for your valuable information.

Regards,

Biraj Adeshara

[ajitkumar]

the table for excise invoice is J_1iexcdtl. For receipt the excise TT is GRPO while for delivery it is DLFC. pl check whether you have or can maintain a common key

[Former Member]

Hello Ajit,

I did not get you. please explain in detail.

The requirement is excise invoice, vendor invoice both should be printed in one form for the same Company. Means, Customer Invoice and Vendor INvoice both should a client can read in one smartfrom.

Kindly give some clues. Thank you for your guideline.

Regards,

Biraj Adeshara

[ajitkumar]

excise invoice details at the time of your purchase is available in table J_1iexcdtl with tt type GRPO. similarly the excise invoice you create while invoicing is also available in the same table with  excist transaction type dlfc.

if you look at the table you can see that for each batch you can derive the per unit duties paid.

i dont know your processes but if you can have a way of linking this receipt batch (s) to the delivery batch, you can output the receipt per unit values

[JL23]

The main tables are

RBKP and  RSEG for vendor invoices

VBRK and VBRP for invoices to the customers

What do you want to do with this smartform? do you want to tell your customer for how much you purchase that material to convince him that your margin is fair ?

[Former Member]

Hello Jurgen,

Thanx for your reply. Actually this is a excise invoice.

It's becoz while selling to customer they want to show the all the excise duties have been charged by vendors with the correct amount so they can charge the same on customers. How can I link excise invoice and vendor invoice in one page??? Thank you for your guideline.

Regards,

Biraj Adeshara