Skip to Content

Material based invoice split


I have a requirement to split invoice based on a particular material.

In a sales order there are 3 materials say X, Y and Z. When i create a invoice followed by a delivery the invoice should be splitted into 2. 1 for materials X and Z and another 1 for material Y always that is always material Y should have seperate invoice with seperate invoice numbers.

Kindly help me to map this.


Rajkumar K

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 17, 2009 at 12:16 PM

    Hi ,

    Maintain one set of payment terms for "X" and "Z".

    Maintain another different payment terms for "Y".

    Goto VTFL screen.

    Select your valid combination of billing type and delivery type.

    Click on item.Select your item category.


    Maintain "Data VBRK/VBRP" as "001".


    If you try then definitely splitting will happen.

    Next goto VF01 T.Code.

    Enter your delivery number.Donot press Enter.

    Click on Selection list.

    Select your items.




    Note:Pls search the forum.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 17, 2009 at 02:28 PM

    In the material master, maintain the Division as 01 for Material X and Z and 02 for Material Y.

    Next go to VTFL, select your item category for the combination of your delivery type and billing type where you can see a field "Data: VBRK/VBRP". Assign routine 351 here and save.

    Now create sale order, delivery and billing. See how it works.


    G. Lakshmipathi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member K Rajkumar


      One more suggestion.

      You can define different "Material group" assign them to the material master in Sales org 2 for the respective material.

      You ask your Technical Consultant to develop a new routine where he must specify the "Material group" as one of the split critria.

      He can copy the standard one "001" and add "Material Group" as an additional criteria for splitting, save it.

      Assign the new routine in VBRK/VBRP field at Item level in Copy control table (Delivery doc to Billing doc).

  • Posted on Sep 18, 2009 at 12:38 PM

    Hi Rajkumar,

    in transaction VTFL, at item level, there is the routine 'Data VBRK/VBRP'. In this routine the field VBRK-ZUKRI is filled.

    This field is designed to set custom splitting criteria.

    So you should create your own routine setting VBRK-ZUKRI so that split occurs whenever you need.

    Best regards,


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.