How do I split billing document?

[Former Member]

Hi,

I have a customer who only accept a certain lines per billing document. However, they want to place a sales order, regardless of its limitation in billing document.

For example, in sales order, there should be no limit of ltem lines (i.e. 20 lines). Yet, the billing document only accept 6 lines per billing document. In this case, 4 billing documents need to be created from 1 sales order.

Any help or suggestions are apprciated!

[Former Member]

Hi Tekako,

I was talking about the Data Structure ZUK which captures the additional split logics. The value for this gets stored in VBRK-ZUKRI field and is responsible for splitting of invoices. This data structure is available in the Copy Control Data Transfer Routines. It is 40 characters long and stores the value like Sales org, Receiving point etc, and that is the reason that by standard you get 2 different invoices for 2 different sales org. U can put your additional logic of moving the delivery line item no. in the ZUK field if the customer master contains that special field which u are going to maintain in the Sales Area Data.

I have another alternative for you which do not require any config or coding but requires a business process control. By standard SAP splits the billing docs if the header values of 2 billing docs does not match. Header value for billing doc (VBRK) is determined from the Sales order line item details (VBAP). I mean to say that if you have 1 sales order with 2 lines and they both have different values at the line item level that will trigger 2 different invoices. Best way to make the 2 lines look different is to make the PO# in the line items for both the lines different.. So if you have PO# at SO header as ABCD then make the same appear as ABCD1 & ABCD2 at the 2 lines items level and SAP will split the invoices into 2 parts.... You can make this happen manually by ensuring that somebody changes the line item po# manually in a controlled manner or you can make it automated with the help of your ABAPER by writing a piece of code in MV45AFZZ...

This will be the far better option for you to go for....

Let me know if you need anything else. My emailid is kapilksharma@gmail.com

Thanks

Kapil Sharma

[Former Member]

Hi Takako,

Go to Img

Sales and Distribution

U come across

Maximum number of linesfor billing document.

U can enter the required number of lines against the required sales organisation.

I do not exactly have the path.

Hope this will be helpful.

Mohan

[Former Member]

Mohan,

This modification in IMG only works per sales organization??

Can I customize it per customer??

Regards,

[Former Member]

Hi Takako,

Let me recap your scenario and then i will provide the solution.

You want to split the billing document for a particular customer only with the restriction on the no. of lines.

Solution

Go to the customer master and choose 1 field which can be used enter the maximum no. of lines which a billing document can have for this customer. Whether the field has to appear in Sales Area Data or General Data will depend upon whether you want all the invoices for that customer to split on the special logic or you want only the invoices related to a specific Sales Area to split on this special logic. If the field is not availble then kindly create a new field and attach that to the Customer Master. The new field can be created in the Additional Data Tab of the customer master.

If you split the invoices for a Delivery relevant Sales cycle it is a possibility that you will end up having 1 delivery and multiple invoice and you might stuck up into the problem of Net Weights & Gross Weights & HU splitting in the logistics process.... Therefore, it makes more sense to split the delivery also on that special logic. You can check this requirement with respect to your SAP instance and let me know if you need this splitting also. Currently i am only explaining the requirement of splitting the invoices only.

In a delivery related Sales Cycle, Billing Picks the Qty & Lines delivered details from Delivery Document & Pricing details from the Sales Order Document (except for shipping services related prices). Therefore the split for invoices has to be placed in the Delivery to Billing Copy Control. Pick up the routine you are using between Delivery to Billing and make necessary modifications in the ZUKRI field. ZUKRI field is a 25 character unique field which is responsible for additional splits. You can take a look at the ABAP code in the SAP Note No. 192558 which is specific to china for Splitting the invoices for a maximum value and max no. of line items per Sales Org. In your case it is not sales org based but customer based so you need to make necessary modifications in the code to bring in split data from Customer master instead of sales org. This will provide you an idea about the split in your case.

I hope details provide by me helps for your case.

Thanks

Kapil Sharma

[Former Member]

Kapil,

Thanks for your advise.

Here is my situation.

I found one open field in sales area data in customer master because I want all the invoices to be split per customer.

Then, it seems that my billing setting is 'split the invoices for a Delivery relevant Sales cycle'. But you saying is that if I split the invoices, I will have trouble handling net weight, gross weight, HU... etc, right?

If so, you best advise would be to split the invoices at delivery level??

I am also not sure about this phrase.

'Pick up the routine you are using between Delivery to Billing and make necessary modifications in the ZUKRI field. ZUKRI field is a 25 character unique field which is responsible for additional splits. '

Thanks,

[Former Member]

I believe in customizing there was a setting to limit max. number of line items in invoice per sales org... of course if you need to limit it per customer - invoice split would be more appropriate solution since you can use your own logic in data transfer routine to split invoice.

[rmazzali]

have a look to the routine 006 "individual invoice limited" that works with table (view) J_1B_TVKOV to limit the invoice items.

You may customize this copy routine with your own table...

regards

Roberto Mazzali

[rmazzali]

the split routine works on the field VBRK-ZUKRI.

You can add to field ZUKRI a flag field that splits the invoice (eg. with a counter based on a global field) every 6 items.

Regards

Roberto Mazzali

[Former Member]

Hi,

Have a look at t-codes "VTFL" (if you are doing delivery related billing) and "VTFA" (for order related billing) .In these transactions at item level there is a field "Data VBRK/VBRP".

Here you can put your routine.Generally its 001.

But you can also write your own routines based onj your requirements.

Reward points if it helps.

Regards

Karan