cancel
Showing results for 
Search instead for 
Did you mean: 

Define Shipping Point automatically?

Former Member
0 Kudos

Hello all,

Please, fellows, gime a tip!!!!

I have to create approximately 220 new Shipping Point. Each one has their own address.

1) Is there any way to define all those Shipping Points automatically?

2) After, is there a ways to assign all Shipping Points to Plant automatically?

Many thanks,

Barbara

Accepted Solutions (1)

Accepted Solutions (1)

Manoj_Mahajan78
Active Contributor
0 Kudos

Barbara,

You can do it with LSMW or BDC ..You need to upload records for shipping points.

Check with yout ABAP person..

Regds

MM

Former Member
0 Kudos

Hello all,

Thanks for your answers.

That is right, I mean the system creates each shipping point without I execute the transaction OVXD. In this sense, yes, I would need upload the records for shipping points.

My doubt is because I never saw or heard anyone doing that.

I was unsure if I can use LSMW or BDC program.

Anyway, I will check out.

Thanks and Regards,

Barbara

Former Member
0 Kudos

Sivanand & all,

Yes I mean definition (OVXD) y assigment (OVXC) to be done (or to be load) automatically.

No they do not have in other system.

But listen I have an excel file with:

Shipping Point code

Shipping Point description

Shipping Point address

Shipping Point correspondent Plant

as observation: all plants and all shipping point have the same data. I mean palnts & shipping points have the same-same code, description and address.

Is there a way to load this Excel File to:

- 1º to OVXD?

- 2º to OVXC?

Many thanks,

Nilza

Former Member
0 Kudos

Dear Barbara,

Through LSMW, you may upload your excel-data, in "Tab Delimited" format.

Even, BDC can be used.

An Example:

[Excel upload|]

Best Regards,

Amit

Former Member
0 Kudos

Hi there,

Yes data from the excel sheet can be loaded into SAP. But for that you need to code a BDC sothat system copies the excel data into the TVST table for shipping point. Here since addres details should also be mapped to relevant address fields in shipping point. For this the system has to 1st pick up the adddress num ADRNR field from TVST, then map the address fields to ADRC tables.

Also for shipping point determination details should be updated in TVSTZ table.

For this in the BDC you need to map the fields / columns in the excel to that of the SAP tables.

This is a very tedious process tough. But once the BDC is ready, then you can upload all the data at a single time. This requires high level ABAP expertise to map the excel sheet fields into the SAP table fields.

Check with your ABAPer on this.

Regards,

Sivanand

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello,

CLOSING this THREAD.

Thanks for all answers.

I got what I need to do.

Thanks & regards,

Barbara

Former Member
0 Kudos

Hi there,

What do you mean automatically?

Definition & assignment cannot be done automatically.

If they are already present in any external legacy systems then we can upload them usaing a BDC or LSMW.

But if they are not existing in other systems, you have to create all manually in OXVD, assign them to the plant in OVXC.

Then you have to maintain the determination in OVL2.

Regards,

Sivanand

Former Member
0 Kudos

Dear Barbara,

By stating "Automatically", what exactly do you mean?

Do you mean that System should create it for you, without eexecuting Transactions, i.e.

Define shipping point - T. Code: OVXD

Assign shipping point to plant - T. Code: OVXC

Then Sorry to say, it won't happen.

But yes, if you mean that MASS-upload for the data, i.e. Defining Shipping Points & Assign Shipping Point to Plants -

You may record and upload LSMW or may write BDC-program.

Best Regards,

Amit