Combine several delivery items (same material), in one invoice position

[carlosalberto_martnezcorc]

Hello experts,

I have the following requirement.

We have several deliveries. Each delivery has some of the same materials. We need to combine these materials into one material on the billing document. I mean:

Ítem   Material     QTY

Delivery 1

01       MP-100      2       

02       MD-150      4

03       MR-900      5

Delivery 2

01      MP-100      3

02      MD-150      4

03      MR-900      5

final Invoice:

01     MP-100      5

02     MD-150      8

03     MR-900      10

Do you know if theres is a way to customize that? ¿Do I need to create a new ABAP routine in copy control (VBRK/VBRP) trx VTFL?

I really appreciate your help.

Carlos M

[joseantonio_martinez · Accepted solution]

Dear Carlos:

Have you checked the "split analisys" when you try to invoice the outbound delivery documents.

Then will be necessary to check the copy control routine for the field in VTFL

The most common fields that create different billing documents are:

Assignment number at header level (ORDNR_FI)

Billing quantity (item level) FKMGK

Please check it and revert.

Regards

Jose Antonio

[carlosalberto_martnezcorc · Accepted solution]

Thanks for your reply Jose Antonio.

I will check it, testing with field FKMGK...

Best regards

Carlos M

[maximiliano_isoba]

Hi,

Somebody could do it without breaking the standard functionality and tables?

[Jelena]

Similar questions have been asked before on SCN, please use search.

We tried to pursue this scenario in one of my old jobs, but considering the amount of custom code needed and impact on the system (loss of standard document flow), the idea was abandoned. It was almost 10 years ago, but I doubt it changed since then.

If it's just the customer's preference to see the lines "combined" then this may be easily resolved with a custom output. Although I wouldn't really recommend this option either, it's still better than breaking standard.

[carlosalberto_martnezcorc]

Hello Jalena,

In fact, consolidation in output format was the solution we offered to customer from the beginning, but customer was not very convinced. So, we have seraching other alternative. But based on your experience and comments that agrees with I've received from other colleagues; I think we will end doing it by an output format.

Thanks for your feedback

Carlos M