co pc act duv enterprise

SAP AG 2001, Title of Presentation, Speaker Name 1

Distribution of Usage Variances

New Development in R/3 Enterprise in the Area of Actual Costing


The Idea

1. Adjust confirmations to orders to „almost actual“ quantities without the inconvenience of manually entering actual confirmation quantities individually by order.

2. 1. Confirmation is completed using target quantities.

3. 2. Stock is counted regularly.

4. 3. Inventory differences are distributed to the orders relating to previously posted consumption quantities.


Entering Consumption Quantities

Efficiency

Backflushing is used. No manual interaction. Quantities according to planned data from Bill of Material (BoM) and routing.

Accuracy

Manual confirmations by order. Users enter quantities as taken from stock.

Compromise:

1. Backflushing.

2. Counting – daily, weekly, monthly.

3. Difference distribution.


Period 2Period 1

Goods Issues

Prod. Order 1

Yoghurt

Prod. Order 2

Yoghurt

Prod. Order 3

Milkshake

1000 KG 400 KG

50 KG 50 KG 200 KG 200 KG

100 KG

500 KG

Physical Inventory: Strawberries, storage location 1

1000 KG

1. ‘Traditional’ goods issues to the order during order production


Period 2Period 1

DUV for Material Consumption

1000 KG 400 KG

50 KG 50 KG 200 KG 200 KG

100 KG

500 KG

Physical Inventory: Strawberries, storage location 1

1000 KG

Yoghurt Yoghurt MilkshakeProd.

Order 1Prod.

Order 2Prod.

Order 3

20 KG40 KG 40 KG

2. Distribution of usage variances (DUV) after physical inventory

Usage variances posted

as additional goods issues

with special movement type


Period 2Period 1

Confirmation of Activities

Yoghurt Yoghurt Milkshake

2 Mvmts 3 Mvmts2 m3 4 m3

Prod. Order 1

Prod. Order 2

Prod. Order 3

1. ‘Traditional’ activity allocations and goods issues,

for example, using backflushing


DUV for Activity Allocation

Period 2Period 1

Actual activity quantities (for example, from time sheets or machine counters)

Prod. Order 1

YoghurtProd.

Order 2

YoghurtProd.

Order 3

Milkshake

2 Mvmts3 Mvmts2 m3 4 m3

2. DUV after entering actual activities (and physical inventory)


Entering Differences

Materials:

Uses existing physical inventory functions. Gets differences from posted physical inventory documents.

Create PI

Document

Record

Counting

Post PI

Difference

Distribute

to Orders

Activities:

New Transaction (CKMDUVREC) for entering actual output of an activity, determined from timesheet, machine hour counter, and so on.

Enter Actual

Quantities

Distribute

Differences

Mark checkbox ‚Relevant for

DUV‘


Possible Receivers for Differences

Materials: Production Orders Product Cost Collector Produced Material Consumed material None (leave in physical

inventory difference account)

Activities / Processes: Production Orders Product Cost Collector Produced Material None (leave on cost center)

FI, ML, Price Change,CO

CostsMaterial

MM, FI, ML, COQuantities & Costs Order & Cost Collector

Type of postingWhat is distributedReceiverSender

COQuantities & Costs Order & Cost Collector

Mat.

Act.

Mat./Act


Searching DUV Receiver Objects

Materials:

Receiving orders are searched by material documents (MSEG) by: Posting date in the period beween current and last PI counting. Relevant movement type (set up in Customizing). Material, plant, storage location, batch, valuation type, stock type the

same as the material to be distributed. BADI

Activities:

CO Documents of confirmations are searched by: Posting date in the period beween current and last PI counting. Cost center and activity type, the same as the activity to be distributed.


FI Postings for DUV Materials

Post physical inventory difference MM

BSXStock

GBB/INVPI Differences

x x

GBBOrder


x x

PRDPrice Difference


x x

BSXStock


x x

Post distribution to order

Post distribution to material (standard price)

Post distribution to material (moving average price)

1

2a

2b

2c

1

2

3


Activation in Customizing

Activation is completed per plant/storage location. Checkbox only appears when activation takes place during creation of PI documents.

PI documents (created in background by Warehouse Management and so on) can be used for DUV, if DUV is activated in the plant concerned and the distribution indicator 1 is binding.


Movement Types

Receiver Search Movement types recognized during receiver search:

Set up in Table TDUVN156 using transaction SM31, for example: 261, 262

Distribution Movement types used for getting quantities back from PI account to

stock Set up by copying movement types in MM Customizing. See DUV online

documentation

Movement types for posting PI differences to order By default: 261, 262. Can be set to new ones for example: Z61, Z62


Screenshot: Selection of Mvmt. Types


Customizing Follow-on Mvmt. Types – OMJJ

Z11 DUV Z62

Z12 DUV Z61

PI-Posting

Reversal of PI-Posting

Posting to Order


Creating Physical Inventory (PI) Documents


PI Document: Details

Checkbox as set up in

DUV Customizing


Entering Inventory Count


Entering Inventory Count: Details


Posting PI Differences


Distributing Inventory Differences (CKMDUVMAT)

Create distribution


Viewing/Editing Distribution Receivers

save edited distribution

post movements / debits

Change Type of Receiver

Proposed Distribution


Entering Activity Differences


Entering Activity Differences

1. Enter quantity.

2. Mark item as OK.

3. Save.


Distributing Activity Differences

Create Distribution


CKMDUVACT - Distributing Activity Differences

Proposed Distribution

Save Edited Distribution

Post Movements/Debits


Displaying Distributions


CKMDUVSHOW - Displaying Distributions

Selection options from last slide were entered here.


DUV and Actual Costing

DUV can be used with or without Actual Costing

DUV was developed by the actual costing development team in a joint project with a customer from process industry

DUV is assigned to the component CO-PC-ACT-DUV


Integration with Actual Costing

Original PI posting

DUV: Getting stock back

DUV: Difference to order

Price Determination Schema

No impact on procurement quantity and value-

Adjusted consumption quantity-

Actual Quantity Structure.

See Notes 510692, 510273


Setting up ML Update Structure

By default, positive PI quantities (701) are treated as „other Receipts“, and negative PI quantities are collected in (702) consumption.

Recommendation: Assign all PI movement types

to a movement type group and assign this to

process category VP

See Note 510692 for the procedure

701

701

702

Z11

Z12

711 etc

702

Beginning InventoryReceiptsOther Receipts/ConsumptionCumulative Inventory

Ending InventoryConsumption

Beginning InventoryReceiptsOther Receipts/ConsumptionCumulative Inventory

Ending InventoryConsumption


BADI for Receiver Determination

BADI CKMLDUVN_CHOOSE_RECV

The automatic search for receivers of material differences (orders that consumed the material) can be influenced by:

Method SET_PARAMETERS_RELEVANT: Implementation can decide which of the material parameters should be used for receiver determination:

Storage location Type of stock Batch Valuation type

Method SUBSTITUTE_PARAMETERS: Implementation can substitute parameters for the receiver search:

Material number Plant batch Valuation type Storage location Type of stock

Example: A difference for material 4711 in recorded at storage location 0001 (warehouse) shall be distributed to orders which consumed the material from storage location 0002 (production line)

Example: A difference for material 4711 with batch xy shall be distributed to all orders which used material 4711 from the same storage location and stock type, without respect to the batch number


Movement Types (Special Topics)

In order to find possible receiver objects, DUV relevant goods issue mvmnt types (for example: 261) must be maintained in table TDUVN156 (Transaction SM31).

During a DUV posting based on a physical inventory, the following goods movements occur:

The inventory goods movements (movement types 701/702) are reversed. There are no reversal goods movements for these movements in the standard. Therefore new reversal movement types for the reversal of positive and negative inventory postings must be created as copies of 711 and 712 (Z11 and Z12). You must not set the flag ‚inventory posting‘ for these movement types.

After the inventory goods movements have been reversed,material usage variances are posted to the receiving orders. In order not to take these goods movements into account during a second distribution, special goods movements types should be created for these DUV goods issues , e.g. Z61 and Z62 (as copies of 261 and 262).

The reference movement types for the copied movement types should be set to 999 so that Warehouse Management ignores them.

Z61 and Z62 can then be defined as follow-up movements for Z11 and Z12 respectively with function code ‚DUV‘.

The corresponding order should be entered as the follow on movement type for the function code ‚DUV‘ for the inventory reversal movement types Z11 and Z12.


Release

DUV is included as part of the SAP R/3 Enterprise Financials Extension 1.10 and will, therefore, be released to all customers

A downgrade to 4.6c is technically possible but would results in chargeable extra work


Distribution of Usage Variances (DUV) - Tables

DUV for Materials: CKMLDUVN - Information from inventory documents. CKMLDUVNCO- Line items from distribution. TDUV156 – DUV relevant movement types.

DUV for Activity Types CKMLDUVACT- Total activity quantities to be

distributed per DUV interval. CKMLDUVACTCO - Line items from distribution.