SXDA..

[Former Member]

Hi friends,

<b> Can you please tell me pupore of SXDA t.code? how this will differ from BDC? is there any relationship between LSMW and SXDA?</b>

please help me out.

Regards,

Kannan.

[RichHeilman]

I think it is more like LSMW rather than BDC. But LSMW is not directly linked to SXDA. Please check out this link.

http://help.sap.com/saphelp_46c/helpdata/en/2e/9e4638a28b2763e10000009b38f8cf/frameset.htm

Regards,

Rich Heilman

[Former Member]

Both LSMW and SXDA are generic data transfer tools whereas BDC is one mechanism of transferring data. Both SXDA and LSMW offer you to choose between various data transfer protocols such as call transaction(BDC), IDOCs, BAPIs, Business Objects or existing standard SAP programs for various conversion wrapped under transaction SXDB.

[Former Member]

Hi ,

Thanks you for your response. kindly tell me the difference between SXDA & SXDB. I went to two t.codes. both are seems to be same. am i corect or not? if not kindly give me some example .

Regards,

Kannan.

[Former Member]

SXDA is where you create your own project and choose the appropriate tool to do the load(see the options under run definition). You can also create your own data transfer objects from here(menu 'Go to-->Register Programs' or transaction BDLR).

SXDB is used only to execute existing data transfer objects provided. Please go through the documentation link provided by Rich.

Srinivas

[Former Member]

Hi Kannan,

SXDA - Data transfer Workbench , Has no support for data conversion / mapping etc . It will expect data in a specified file format required by the load program. If the data is not in required format you will have to write another ABAP program to format it in the required format .

LSMW - Legacy System Migration Workbench . Tool provided

in the newer versions of SAP . Here you have the wonderful option of mapping / converting field values as well as structures . Input file can be totally different from the file required for standard load programs . You can convert / map the fields to get the desired file . So its kind of data mapping tool as well which was not there in SXDA.

Now in WAS release 610 or higher SXDA & SXDB are all the same and point to same program and screen. Check in SE93 . In older version SXDB was for individual objects whereas in SXDA was something on top of SXDB where you can create your project and assign more than one data objects to one project ( One sub project is one data object ). In older versions also in SXDA you have an option to goto SXDB ( Goto -> DX WB Realease 45 ) . But in newer releases this is disabled as SXDB also points to same program . The program for SXDB was SAPLSXDA , it exists in new version but the screen and transaction is gone.

Hope that helps.

Cheers

( Dont forget to reward if answers were helpful )

[Former Member]

Hi,

i want to developed data conversion routines for matrial master data using SXDA t.code . can you please tell me how can i start this scenario.

Thanks in advance,

Regards,

Kannan.

[Former Member]

Hi Kannan,

With SXDA no data conversion possible . You have to covert your data beforehand and then pass this file to SXDA. If you want to do data conversion you can try LSMW.

Cheers

[Former Member]

Hi,

Is there any soluction for doing this scenario.

Thanks in advance,

Regards,

Kannan.

[Former Member]

Can you please let us know what you meant by data conversion routines? A BDC recording or some BAPI call or just a subroutine pool?

Material master is a tough one to write conversion for. You can use SAP standard program that does DI or you can probably use a function module. I don't remember the name of the FM but you can search for 'MATERIALMAINTDARK

[Former Member]

Hi Kannan,

LSMW and SXDA are both tools for data Migration.

BDC is used for transfering data from legacy system to SAP or SAP to SAp system.Diffrence is that LSMW and SXDA is that it is providing you more flexibility.With these you have choice for data migration.In some practical senario BDC is not very much effective to use,in case of LSMW ,SXDA you have choice like IDoc ,Direct Input,BAPI.

In SXDA you can use Objects already existing or created by you for loading.You can use LSMW objects in SXDA.

Regards,

Albert