DP Planning Book allocation updation

[former_member566355]

Hi,

When a sales order is created and queue is processed, at what point and using which object (e.g. BAPI) the planning book is updated ?

Also, and from where does the allocation data is fetched ? Is it stored somewhere with reference to sales order line item once the sales order is created ?

Regards,

RS

[frank_horlacher]

it is done like this:

Transfer Product Allocation Data from Product Allocation Group to Planning Area

Use

In this activity, the product allocation data is transferred from product allocation group to the planning area. According to the system settings, the system saves the incoming order quantities in the product allocation group during the availability check. In this transaction, the incoming order quantity is copied to the planning area for planning purposes.

Procedure

1. Access the transaction using one of the following navigation options:

SAP SCM Menu Advanced Planning and Optimization  Global ATP  Environment  Product Allocations  Connection  Transfer Data to Planning Area

Transaction Code /SAPAPO/ATPQ_PAREA_W

This activity can also be planned as a background job. The allocation data is then transferred regularly and manual copies are not necessary.

Displaying Product Allocations

Use

You can display the current product allocation situation in different variations using the explanation function:

u2022 Product allocation display or product allocation overview for each characteristics combination (display of time series for a characteristic values combination)

u2022 Product allocation display for each period (display of time series of a period for several characteristic values combinations)

You must specify a product allocation group and a characteristics combination for the variants.

Irrespective of product allocation, the product allocation display shows the product allocation situation in the product allocation group.

Procedure

1. Access the transaction choosing one of the following navigation options:

SAP SCM Menu Advanced Planning and Optimization  Global ATP ® Reporting ® Product Allocations

Transaction Code /SAPAPO/AC42

Checking Free Allocation Quantities in the Planning Area

Use

The purpose of this activity is to check free allocation quantity as a customer service.

Procedure

1. Access the transaction choosing one of the following navigation options:

SAP SCM Menu Advanced Planning and Optimization  Demand Planning  Planning  Interactive Demand Planning

Transaction Code /SAPAPO/SDP94

[former_member566355]

Hi Frank,

Thanks for your reply. My query is specifically to from technical information point of view. Let me elaorate it.

Following steps are followed.

1. A new sales order is created.

2. Once ATP is triggered the control goes in APO. Allocation is checked. System gives delivery proposals and accepted.

3. Sales order is saved.

The query is the DP allocation planning book is updated only when the sales order is saved.

So in order to update the planning book, from which tables does the system fetches the allocation related data for the given sales order which is just created ?

Does it keep the reference data (incoming order quantities) in APO before saving sales order ? so that it can be referred again once the sales order queue is processed ?

Hope I am able to clarify it now,

Regards,

RS

[Former Member]

RS,

All allocation relevant data is collected and stored in APO. R/3 has no visibility of the mechanism of the Allocation process. The major data item that SCM returns to R/3 is a modification of the confirmation date/qty.

SCM usually does not usually perpetually maintain allocation information in the Planning Area (which is what you are displaying when you view a Planning book).. It is usually managed in a data entity called a Product allocation Group. As outlined by Frank, the data in this entity can then be copied into the Planning Area so that users can view it, and modify it, as necessary. This is an activity that is not done perpetually, it is done only when a user executes the program manually, or via scheduled job.

The table within the Product Allocation Group entity (in SCM) that perpetually (e.g., immediately upon saving the Sales order) stores 'Incoming Order Quantity' is /SAPAPO/QTTAB. I believe this is the table you are asking about.

Best Regards,

DB49

[former_member209769]

Hi RS,

As already explained by DB and Frank, the planning book is NOT "normally" updated during the GATP process.

"Product Allocation group" data would get updated during GATP, and then we would later copy the relevant information to the planning book for ease of viewing, reporting or for planning purpose.

EXCEPTION - if you specified the product allocation check to happen in the planning area while defining the product allocation group. In this case, changes in the product allocation group and the Product Allocation Planning Area happen at the same time.

After you would confirm the proposal of the Sales Order (or when it happens automatically), the product allocation group situation would get updated. If you had checked "check planning area" while defining your product allocation group, at this same time, the Product Allocation planning area also would get updated.

Thanks - Pawan