Cummulative Batch Qty in Billing

Reference:

1. http://wiki.sdn.sap.com/wiki/display/SD/Batch+items+in+billing+document

2. SAP Note: sapnote_77414 Billing During Batch Split

Requirement from user is materials are handled in batches, delivery using batch split but in billing the batch items are not desired to be appeared in the billing document.

Simulation is shown below:

Delivery Order:

Sales is using bill of material. In delivery the structure of items are displayed as below. Let assume that delivery is made for 1 SET of material MAT_XXA.

1 SET of MAT_XXA is consist of 2 PC of MAT_X and 1 PC of MAT_A. In delivery order also use batch split since the stocks are supplied from two different batches.

Line Material Qty UoM Batch
10 MAT_XXA 1 SET
11 MAT_X 2 PC
90001 MAT_X 1 PC 0000000001
90002 MAT_X 1 PC 0000000002
12 MAT_A 1 PC

Billing:

False Result

Line Material Qty UoM
10 MAT_XXA 1 SET
11 MAT_X 2 PC
12 MAT_X 1 PC
13 MAT_X 1 PC
14 MAT_A 1 PC

Correct Result

Line Material Qty UoM
10 MAT_XXA 1 SET
11 MAT_X 2 PC
12 MAT_A 1 PC

Based on sapnote 77414, the possibilities settings may applied as follow:

 Structure of Batch Split in Delivery Order
Structure of Batch Split in Delivery Order

Legend:

  • Item category,  PTYP (table TVAP)
  • Relevance for billing, FKREL (from the item category, table TVAP)
  • Billing quantity, FKMGK (from table TVCPF)
  • Invoiced quantity, FKIMG (from the invoice document (table VBRP)
  • Cost, VPRS

1). Billing of the batch main item. Display of the batch subitem.

img-2.3a

2). Display of the batch main item. Billing of the batch subitem.

img-2.3b

3). Billing of the batch main item (without displaying batch subitem).

img-2.3c

Thus, since the requirement is to accumulate or sum the total quantity of sub items in batch to main batch without displaying the batch sub items in billing document . The relevant customizing that have to be applied is solution 3.

The result will appear as screenshot below.

Batch Split in Delivery Order
Collapse Structure of Batch Split in Delivery Order (line item 20)
Structure of Batch Split
Structure of Batch Split from line item 20
Result Accumulated Batch in Billing Document
Result Accumulated Quantity of Batch in Billing Document

As seen on screenshot above, the line item 11 is calculated the total of sub items which is 2 PC and display it as billed quantity.

Customizing print screen.

1. Define Item Category (t-code: VOV7, IMG > Sales and Distribution > Sales > Sales Documents > Sales Documet Item > Define Item Categories )

Setting of billing relevance in ItCa "TAN"
Setting of billing relevance in ItCa “TAN”
Setting of billing relevance in ItCa "ZTAN"
Setting of billing relevance in ItCa “ZTAN”

2. Determination of Item Category in Delivery (IMG > Logistics Execution > Shipping > Deliveries > Define Item Category Determination in Deliveries)

Table: T184

Item Category Determination when Using Usage Batch Split
Item Category Determination when Using Usage Batch Split

3. Copy Control Delivery to Billing (t-code: VTFL, IMG > Sales and Distribution > Billing > Billing Documents > Maintain Copying Control for Billing Documents > Copying control: Delivery document to billing document).

Choose appropriate item category which is “TAN” and “ZTAN”.

Billing quantity/field FKMGK for ItCa "TAN" have to be set "G"
Billing quantity/field FKMGK for ItCa “TAN” have to be set “G”
Billing quantity/field FKMGK for ItCa "ZTAN" have to be set "G"
Billing quantity/field FKMGK for ItCa “ZTAN” have to be set “G”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s