Table for Demands and Supplies after CTM run

[Former Member]

Hi Gurus,

I want to get number of demands and supplies after CTM run .

I can see these details from opt11 . But i want to use these data points further for a custom developments .

So please let me know , in which table these entries sit ? There has to be a standard table for the same .

Regards

Bhupendra

[Former Member]

Planning data (demand & supply) sits in live cache after CTM run.You should be able to see planning data in planning book/data view (t-code -/SAPAPO/SDP94)for corresponding planning area.I am not sure about table.

[Former Member]

Log is pulling data from structure:BAL_S_SHOW.

You need to explore exact table from where it is pulling data some of them are

BALHDR , BALDAT or other Bal* table

Whats is the use of number of demand and supply order number ?

Manish

[Former Member]

Hi manish

Thanks for the reply . I tried debugging the CTM run after taking only one part in selection and having few demands .

I could able to figure out that function module /SAPAPO/CTM_DEM_AGGREGATION is providing the damand data . But still need to figure out the supply data and totol numbers of orders created .

Use for this data:

We had a situation where there was an immediate surge of data in the system . Like supplies have been increased drastically . Which caused a big issue in terms of the performance .

Hence we wanted to make a system in place , so that we can get count of critical datas , as well as we can get the deviations from past .

So for this purpose , finding the table or the source of these data points.

[Former Member]

Vikas,

You can also improve changing the data points in CTM global setting /SAPAPO/CTMCUST...

Enable check box : Asynchronous Update and Define appropriate Packet Size and also update

Package Size for Creating Orders

Package Size for Creating Pegging Rels

Package Size for Order Selection

Below example illustrates the improved performance by enabling check box : Asynchronous Update and Define appropriate Packet Size

"

If you set the indicator, CTM first plans the number of demands

specified in the Package size field. Then the system creates the

corresponding orders in the liveCache. At the same time, CTM continues

with the planning for the remaining demands.

If you do not set the indicator, the system first plans all demands and

then creates the orders in the liveCache.

Example

You want to use the asynchronous liveCache update for 20000 demands.

Enter 1000 as the package size. The system attempts to fulfill the first

1000 demands. The orders for these demands are created in the liveCache,

whilst CTM planning continues for the remaining 19000 demands."

We had similar issue and CTM performance improved significantly after updating the above setting.

Thukral

[Former Member]

Hi Vikas

You can try below FM:

For Demand :

/SAPAPO/CTM_DEM_READ

For supply :

/SAPAPO/CTM_SUP_READ

other :

/SAPAPO/CTM_SUP_AGGREGATION

Manish

[Former Member]

Hi Thukral

We already have these settings:

package size for creating orders

package size for creating pegging rels

Package size for order selection.

Now even after these settings , performance issue came up . Reason being excess of supply element , which drastically increased after upgrade.

As i have mentioned that supplies were increased because , intransit POs were not deleted by the mass deletion program .

So we wanted to have an utility in place , which can give count of such critical numbers .

Regards

[Former Member]

Hi Manish

I have figured out these function modules which you have mentioned .

For Demand :

/SAPAPO/CTM_DEM_READ

For supply :

/SAPAPO/CTM_SUP_READ

other :

/SAPAPO/CTM_SUP_AGGREGATION

But i am unable to figure out , in which table the required data (count of total supply and demand sit .

Regards

[Former Member]

Hi Vikas,

You can use this BAPI to get the record count from live cache of Intransit PO's by using ATP category of Key Figure representing Intransit PO's .......BAPI_POSRVAPS_GETLIST3 and BAPI to delete Procurement elements BAPI_POSRVAPS_DELMULTI

Thukral

[Former Member]

Hi Vikas,

Need to sum up based on ATP category you have defined for different objects in Planning area:

/SAPAPO/MSDP_ADMIN - Administration of Demand Planning and Supply Network Planning

you can see in table /SAPAPO/ATP03//SAPAPO/V_ATP03 whether this category is demand/supply .

Example :

ATP Category APO Order Type Details

CC 11 Stock (Unrestrcited)

BU 14 Inspection Lot

AC, AD 31 Production Order ( Supply ...)

AI, AJ, AK, AL 31 Planned Order ( Supply ...)

AG 21, 22 Purchase Requisition

BF 21 Purchase Order

BM 52, 53 Sales Order (Demand ..)

BR 41 Delivery

FA, FC Forecast

Manish