Question Re: Copy Locations and Product x Locations in APO in Supply Chain Management Q&A

Copy Locations and Product x Locations in APO

Former Member — Wed, 27 Mar 2019 04:10:57 GMT

Dears,

I want to simply copy an existing location and create 25 new locations with same attributes except the description of the location and then extend about 1000 odd products to all these new locations. This is all local in APO. No ECC.

How do I do it quickly? I can't seem to find copy options on Location or product x location menu.

Thanks

Amit

Re: Copy Locations and Product x Locations in APO

I310607 — Wed, 27 Mar 2019 08:26:12 GMT

Hi Amit,

the LOCNO (Location Number) is unique as well, watch out for that.

The standard tools for location maintenance is available in the SCN Wiki: https://wiki.scn.sap.com/wiki/x/_A0MDg at chapter: ''Maintain Locations in APO:''

The BAPI_LOCSRVAPS_SAVEMULTI2 interface seems for me the best suit for your needs.

For location-products, following the same logic you can use BAPI_PRDSRVAPS_SAVEMULTI2 whereas the respective wiki is:

https://wiki.scn.sap.com/wiki/x/wg0MDg.

Theoretically, you can use LSMW as well.

Best Regards,

Gergely

Re: Copy Locations and Product x Locations in APO

rupesh_brahmankar — Wed, 27 Mar 2019 08:26:59 GMT

Hello,

There is no copy option for /SAPAPO/MAT1 and /SAPAPO/LOC3 transaction.

You can use the mass uploading tool like LSMW for it.

Or you can use these FM too

BAPI_LOCSRVAPS_SAVEMULTI2 Create or Change Location Data and

BAPI_PRDSRVAPS_SAVEMULTI2 Create or Change Location-Product level

Best Regards,

R.Brahmankar

Re: Copy Locations and Product x Locations in APO

Former Member — Wed, 27 Mar 2019 09:52:08 GMT

Thanks Greg and Rupesh once again,

This is torture.

The BAPI you mentioned pulls up 104 columns by just selecting the Product Location object. Secondly I am still no sure what other objects maintain. Then it asks me for GUIDs of everything. while I need to maintain only about 10 fields. Which means leaving the rest blank. I then need to copy paste so much rows and columns there... Lot of work. Wonder why can't they give such copy functions like they have in ECC?

Btw. does LSMW create product x locations too ? I thought it maintains if there are existing product x Locations..

Re: Copy Locations and Product x Locations in APO

Former Member — Wed, 27 Mar 2019 10:25:30 GMT

I can't give points to both? Both answers are the same so I applied FIFO rule 🙂

Re: Copy Locations and Product x Locations in APO

I310607 — Wed, 27 Mar 2019 10:58:55 GMT

Hi Amit,

APO was mostly designed to work with ECC hand in hand, thats why it does have only limited functions on copy product and location objects.

Regarding the usage: you can even write some logic on the top of the BAPI for uploading from an excel sheet or so - maybe there is a solution somewhere in the community.

About the GUIDs. As per my knowledge the program generates its own guids, if there isn't any provided, so generally the Numbers are enough to be defined. I recommend to test the BAPI first with some test data.

Best Regards

Gergely

Re: Copy Locations and Product x Locations in APO

Former Member — Fri, 29 Mar 2019 07:40:14 GMT

gergely.kocse,

"APO was mostly designed to work with ECC hand in hand"

There is tons of stuff I maintain locally in APO prod x loc master incl. locations that exist only in APO as part of logical supply chain model, There is a world beyond Plants and MRP Areas too. Like wise I need to main t-lanes. These things are not possible with mass creation and maintenance utilities that aren't dehumanizing. I can't test just about every small bit out there just to do something so basic. Anyway apparently some developers out there are selling such utilities for a small fee. It is all effort Vs reward 🙂 Testing is best done by original developers and document it in the program itself. First time users can only conjecture what needs to be done by looking at those weird looking animals on the screen.

Anyway thanks for your support

Amit

Re: Copy Locations and Product x Locations in APO

I310607 — Fri, 29 Mar 2019 09:18:49 GMT

Hi Amit,

for T-lanes, there are standard mass generation reports, please visit: https://wiki.scn.sap.com/wiki/x/Kph9Fw for a test case.

With Best Regards,

Gergely

Re: Copy Locations and Product x Locations in APO

Former Member — Thu, 04 Apr 2019 02:40:45 GMT

Thanks Gergely, meanwhile we developed a new report to upload 20 odd fields on Tlanes... straight from desktop. We have 500000+ product specific t lanes.. with multiple means of transport and costs at multiple locations. Such a pain to maintain this without a friendly utility! Animals like guids are so intimidating. The users even refused to maintain data on the SCC_TL1 screen that undoubtedly is seriously demotivating to bear. Likewise we have a utility to mass check and correct prod x loc master data and create new combinations by copying 'like' prod x locs too and then change it well with excel front end. Copy paste. check save.

We also developed a report to download all useful attributes of lanes by any selection criteria. Works like a charm now. Business users are so happy now..

Thanks

Amit