Storage Location from VBRK instead of VBAP in COPA

[Former Member]

Hello,

In COPA, Charc. Storage Location if updated from VBAP table. In our scenario, the process is such that storage location is not updated in Sales Document as they prepare sales order in bulk and deliver material from different storage locations.

So COPA report KE24 does not contain storage location. Now I want to pick up storage location from either Delivery or Billing document.. Pls help how can I do it ?

Thanks...

[ajaycwa1981 · Accepted solution]

Hi

In my opinion, you will have to write a derivation step in KEDR using enhancement and use exit COPA0001 to write the logic in it

The Source Field in your exit can be Sales Order (KDAUF) and Target field will be Storage Location

br, Ajay M

[Former Member · Accepted solution]

Hello Ajay,

Thanks for your reply...

FYI..Sorry the table is VBAP from which I want to fetch storage location

I tried to write a derivation rule of Table Look up as below:

Source Field:

Origin     Field Name     =      Origin     Field Name

VBRP      VBELN          =       COPA     KAUFN

VBRP      POSNR         =       CO-PA     KDPOS

Note: Source Condition was provided by default by the system

Assignment of target fields:

Origin     Field Name     =      Origin     Field Name

VBRP     LGORT          =      CO-PA     LGORT

Is the above condition ok.. ? Here the system suggests the Billing doc = Sales doc.Is it possible to get CO-PA - VBELN by some way or is possible to change to VBRP-AUBEL

Also, I am not very sure on the impact it will have on the Live System when I will add this condition now.. what impact will it cause ? Is it advisable to add such conditions on Live system

Thanks

[Former Member · Accepted solution]

Hello Ajay,

Thanks... as per your suggestion I have used enhancement (exit COPA0001) to get storage location. It is working fine now