Extract data from custom KF in the planning book

[Former Member]

Greeting All,

I am creating custom KF in a custom planning book. What is the best way to extract the data from this  KF and send the data down to a R/3 system?

Is there a way that I can facilitate /sapapo/c5 transaction to collect all the changed data in this KF and send it to r3 system. " emulate what we have for planned order..."trasactional" KF?

Thanks

[Former Member]

Hi,

What application you want this in DP or SNP?

Can you help clarify what happens when you send the results of your custom KF to ECC? Will they be created as Planned orders or Planned independent requirements or something else?

If Planned independent requirements, it is simple, just create a transfer profile and create a background job and that should suffice along with some basic config.

If SNP you can try option 1 below, and also there are many ways you can do this and one of the way is what Sandeep mentioned.

I can think of couple of options and you can try option 1, honestly I haven't tried this, but worth giving a try:

Option 1:

Create a custom category type for example ZEE and include order category 'EE - SNP planned order' and assign it to the custom KF in your planning area. (from your above statement - emulate what we have for planned order..."trasactional" KF)

So when you compute the values for your custom KF, asssuming via a macro or a manual entry, the values saved would be of category 'EE'.

Do publication to ECC - /SAPAPO/C5 with 031 as category and should be creating Planned orders in ECC.

Note - Running Heuristics and sending to ECC might duplicate orders.

Option 2:

• Create a custom program in APO to extarct the custom KF values and place it on Unix server.
• Create a Custom program in ECC to extract the file placed on the Unix server and create what you want in ECC.

Thanks,

Murali

[Former Member]

Hi,

As u know the standard way of sending the transactional data is thru cif.

But, u can try to take the backup of the Planning are and from that backup cube u can pull out the records of that particular "KF" and with help of BW consultant u can discuss on the transfer procedures from SCM cube to R/3 table.

Well by the way, kindly share the solution u used to solve this problem

Regards,

Sandeep