Skip to Content
Author's profile photo Satish Babu

Integrating MM & SD Modules in Same Client to do Billing in Supplying Company Code & do LIV in Receiving Company Code By I-Doc Message Type INVOIC Part3

This document is in continuation of http://scn.sap.com/docs/DOC-45574 Part1 & http://scn.sap.com/docs/DOC-45777 Part2

In this document I’m going to explain about processing Billing in SD & Logistics Invoice Verification in MM Modules using EDI- IDocs.

Prerequisites:

1. A sales order created against the PO as explained in above link1.

2. A Delivery and Goods Receipt carried out against the above sales order & PO respectively as explained in Link2.

3. Knowledge of Billing & Logistics Invoice Verification.

Follow the below steps for processing Billing with IDocs.

Step1. Create Condition Record in transaction NACR for message type RD00 as shown below.


/wp-content/uploads/2013/08/9_269653.jpg

Enter the billing document type (F2) with Transmission Medium (6 EDI).

/wp-content/uploads/2013/08/10_269675.jpg

Note: The Partner function maintained here (BP) is to be used in step No. 2   as partner role.

Step2. In Transaction WE20 for partner profile customer (100211) maintain outbound parameters with partner role BP, message type INVOIC & Basic Type INVOIC02 as explained in the previous document Part1.

/wp-content/uploads/2013/08/5_269676.jpg

In Message control tab maintain message type RD00 with process code SD09 as shown below.

/wp-content/uploads/2013/08/6_269677.jpg

In EDI Standard Tab Maintain EDI Standard as E, Message type as INVOIC.

/wp-content/uploads/2013/08/7_269678.jpg

Step3. In Transaction WE20 for partner profile Logical System (RD2CLNT800) maintain inbound parameters with message type INVOIC and process code INVL (Logistics Invoice Verification)


/wp-content/uploads/2013/08/8_269679.jpg

Step4. In the below path Convert the External Tax codes (Tax code in Billing) used in to Internal tax codes to be used for Invoice verification. Table T076M

/wp-content/uploads/2013/08/1_269680.jpg

/wp-content/uploads/2013/08/2_269690.jpg

Note: You can use any one format shown in above. All the above formats will work. If system not possible to convert the external tax code then Error Msg. FD008 will come.

Ex. Assigning a new tax key for S1 and VAT 10.000 not possible. Message no. FD008,

          Where S1 is Output tax code which is used in billing,

          VAT is standard key used by EDI to convert tax by using Tax percentage Ex.10.000.

Note. Enter tax rate with decimal places 

Step5. Assign customer name (0000100211) to a company code (8888) in which the invoice is to be posted as shown below. Table T076B

/wp-content/uploads/2013/08/3_269691.jpg

Note: Use Prefix Zeros if required to the customer name. If System not possible to determine a company code in which the invoice to be posted, then Error Msg.FD006 will come.

Ex. A company code cannot be determined for & & & Message no. FD006.

Note. the below ABAP Code is used to determine the company code.

CHECK I_E1EDKA1-PARVW EQ ‘RE ‘.

SELECT SINGLE * FROM  T076B WHERE  PARART    = I_IDOC_CONTRL-SNDPRT

                              AND    KONTO     = I_IDOC_CONTRL-SNDPRN

                              AND    BUKRSNAME = I_E1EDKA1-PARTN.

Step7. Maintain EDI program parameters for partner Logical system (RD2CLNT800) & company code (8888). Here Maintain the Invoice document type to be used  & remaining as per requirement. Table. T076S

/wp-content/uploads/2013/08/1_269680.jpg

Note: IF the system Not possible to determine program parameters Error Msg. FD145 will come.

Ex. Program parameters for LS RD2CLNT800 8888 have not been set Message no. FD145.

Testing:

Step1. In Transaction VF01 create billing document against delivery document as shown below.

/wp-content/uploads/2013/08/11_269698.jpg

/wp-content/uploads/2013/08/12_269705.jpg

In Conditions observe the tax details (10.000 %) & Tax Code (S1) as shown below.

/wp-content/uploads/2013/08/13_269706.jpg

/wp-content/uploads/2013/08/14_269707.jpg

Save the billing document & make sure it is released (forwarded to accounting). Check the message RD00 was sent successfully. Check the accounting document created against the billing document

/wp-content/uploads/2013/08/15_269708.jpg

Step2. In Transaction WE02 check the status of Outbound & Inbound Idocs of message type INVOIC.

/wp-content/uploads/2013/08/16_269709.jpg

If they are processed successfully note the Invoice document number from the status of inbound IDoc.

/wp-content/uploads/2013/08/17_269710.jpg

Step4. In Transaction MIR4 Display the Invoice document as shown below.

/wp-content/uploads/2013/08/18_269711.jpg

Observe the below details, document type used for invoice & block status of the invoice document.

/wp-content/uploads/2013/08/19_269712.jpg

Check the accounting document by clicking on Follow-On Documents.

/wp-content/uploads/2013/08/20_269713.jpg

-End Of Document Part3

-End Of Document Series

Thanks For Reading & Please share your reviews & feedback….

Regards

Satish

Assigned Tags

      15 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Dear,

      I am very thankful to u for "Creating Wonderful Documents" to us.

      Thanks,

      Naren

      Author's profile photo Srinu S
      Srinu S

      Thank you  Satish nice effort.Very useful document. Keep on sharing this kind of documents.

      thanks,

      Srinu.

      Author's profile photo Former Member
      Former Member

      Thanks its helps alot

      Author's profile photo Jürgen Lins
      Jürgen Lins

      A real exceptional detailed documentation which certainly stands out against the mass

      Author's profile photo Satish Babu
      Satish Babu
      Blog Post Author

      HI Jurgen L,

      Thank you very much for appreciation. Actually I was waiting for Your feedback on this document part from the day it was posted as You said looking forward for second part. Now I'm really spell bound & happy to see this.

      Regards

      Satish

      Author's profile photo Former Member
      Former Member

      Hey Satish,

      Once again, thanks a lot..

      I configured the whole process 🙂 .

      Without your help it was not possible.

      I have one more doubt. In your last (this) document, there is no Acknowledgement sent from Customer for the Bill received from the Vendor. Isn't it necessary to conclude the whole process?

      Please reply,

      Nikhil Ghadge.

      Author's profile photo Satish Babu
      Satish Babu
      Blog Post Author

      Hi Nikhil,

      There are no standard message types for this requirement. I hope you can use some idoc receipt acknowledgement message types for this requirement.

      Regards

      Satish

      Author's profile photo Suman Sardar
      Suman Sardar

      Thanks again for the nice effort.

      Keep sharing.

      Author's profile photo Former Member
      Former Member

      Hi sathish,

      A lucid explanation of tough concepts...

      Thanks a ton for explaining.

      Thought to ask a question, how ur getting these ideas to getting this type concepts and processes ?

      Author's profile photo Satish Babu
      Satish Babu
      Blog Post Author

      Hi Shiva,

      Thanks for your feedback.

      Coming to your question, I have faced so many issues while learning & configuring these kind of business requirements in standard SAP. So somebody might look for the same just like me. So want to share My experiences & want to make their learning a cakewalk and they can spend that time in learning some other process which can be shared with others. That's how SCN has became as biggest professional Social networking or sharing site.

      Regards

      Satish

      Author's profile photo Chandan Behera
      Chandan Behera

      Thank u Satish for helping with beautifully all 3 SD_MM are though concept to learner also for experience  .

      Thanks a lot again...

      Author's profile photo Former Member
      Former Member

      Great Document

      Thank you Very very much

       

       

      Author's profile photo Former Member
      Former Member

      I became fan of yours.. good presentation and documentation..both will not come at a time.. but it feasible for your..great effort and time spent is more valuable and appreciated. We are expecting more good blogs from you..

      Regards,

      G.V.Shivakumar

      Author's profile photo Vinod Kumar
      Vinod Kumar

      Heartily Thanks Satish Sir for sharing such useful information.

      Author's profile photo Shandi Chen
      Shandi Chen

      Great article! thanks for sharing.