topic Re: BDC Upload Software in Application Development and Automation Discussions

BDC Upload Software

Former Member — Tue, 11 Oct 2005 01:16:44 GMT

Hi,

We are tired of writing BDC ABAP programs everyday.Is any software from SAP or from other vendors ,where we can upload data from excel/notepad to any SAP transaction with minimum coding effort.

Please let us know, we love to buy that software.

Regards

Chandra

Re: BDC Upload Software

Former Member — Tue, 11 Oct 2005 09:13:31 GMT

Hello,

I have not used this software. but check out this site:

www.winshuttle.com

Hope this helps you.

Regards, Murugesh AS

Re: BDC Upload Software

Former Member — Tue, 11 Oct 2005 10:56:18 GMT

Hi Murugesh,

Thanks for your quick info.I looked into that software it is external software,that is outside R/3.Some one has to maintain this software.If any software within ABAP it will be helpful.Please find any software available.

Regards

Chandra

Re: BDC Upload Software

Vinod_Chandran — Tue, 11 Oct 2005 11:03:49 GMT

Hi Chandra,

Did you try LSMW?

Cheers

Vinod

Re: BDC Upload Software

Former Member — Tue, 11 Oct 2005 20:21:24 GMT

Hi Vinod,

For LSM workbench, most of the users dont have authorization.We need to create 'Z' or 'Y' BDC reports so that user can run the report using SA38.We need a smart tool to generate BDC programs.

Regards

Chandra

Re: BDC Upload Software

RichHeilman — Tue, 11 Oct 2005 20:24:12 GMT

I'll write your BDCs for ya for a good price.

Regards,

Rich Heilman

Re: BDC Upload Software

Former Member — Tue, 11 Oct 2005 20:41:55 GMT

> Hi Vinod,

> For LSM workbench, most of the users dont have

> authorization.We need to create 'Z' or 'Y' BDC

> reports so that user can run the report using SA38.We

> need a smart tool to generate BDC programs.

> Regards

> Chandra

Hi Chandra,

Even in LSMW, users can be restricted to limited access such as execute only. You don't have necessarily give them the whole world, but restrict them to just 'Execute'.

The authorization object you need to retrict them by is B_LSMW activity 16. Talk to your basis/administration people to create a role with this object and assign it to the profile of the users. That should be it.

Srinivas

Re: BDC Upload Software

Former Member — Tue, 11 Oct 2005 20:51:13 GMT

Alternatively, your users can execute the program <b>/SAPDMC/SAP_LSMW_INTERFACE</b> from SA38, enter the LSMW project, subproject, object and other details and execute it from there. You can create variants for each one of them and then users can use the variants instead typing all the LSMW project info.

But remember, it still does the same authorization check. So you still need to do as I told above. But compared to writing BDCs, I think this is a easier option. Bring them into LSMW and then follow these two steps, you should be good to go.

Srinivas

Not that I don't mind getting the consulting fee!!!

Re: BDC Upload Software

Former Member — Tue, 11 Oct 2005 20:53:24 GMT

C -

I share your pain ... here's a couple ideas:

1. Use a BAPI

2. After recording your BDC in transaction SHDB, click FunctionModule and modify to taste.

Best!

Re: BDC Upload Software

former_member709726 — Wed, 12 Oct 2005 19:29:49 GMT

Hi guys,

I found a website that claims to generate BDC upload programs from any transaction within R/3. The tool is written directly in R/3 and has a user interface package.

Here is the link:

http://www.erptronics.com/index_files/SAPEasyUpload.pdf

Does anyone know of or have experience with this package? It looks interesting.

Kind regards,

Stephanie

Re: BDC Upload Software

Former Member — Fri, 14 Oct 2005 00:56:52 GMT

Hi Stephanie,

I went through the document and it looks very interesting.One of advantages about this software is that it generates a BDC program for each transaction.This is what I was searching for.

Also I requested demo from erptronics,the software sounds very interesting.

Thanks for your help Stephanie.

Regards

Chandra