Data Migration from SOFTCONT tables

[Former Member]

Hi,

I'm working on a Data Migration project that includes migrating a subset of Customer Masters from SAP ECC6 to SAP Hana.  I need to also migrate any Electronic Document Attachments for the subset of Customers being migrated (There can be many attachments for each Customer Master).

Once the migration is complete, both systems will need to run in parallel for a period of time therfore the document attachments must exists in both SAP ECC6 and SAP Hana for the Customers Masters migrated.

As not all customers are being migrated, I need to be able to extract based on customer number or a range of customer numbers.

I would appreciate advice from anyone that has done this before;

1) How to extract the Electronic documents from Customer Master in SAP ECC6 system.

2) How to Specify the Customer Number as a selection criteria

3) How to attach the document onto the customer in the new SAP Hana system.

It is not possible to do any of this manually due to volumes.

Thanks in Advance,

Lee

[benedikt_wagner_mdt · Accepted solution]

Hi Lee,

see section "Generic Object Services" in http://wiki.scn.sap.com/wiki/x/GofwDg how documents are linked to objects. You can select documents assigned to customers using TYPEID_A = KNA1/KNB1 and specifying customer id in INSTID_A in table SRGBTBREL.

Access to documents can be done using function modules SCMS_DOC_INFO (metadata only), SCMS_AO_FILE_GET* or SCMS_AO_TABLE_GET.

I have no knowledge about HANA but I could imagine, there are also the generic object services. But you could also use DMS to store documents and attache them to customers.

Regards,

Benedikt

[Former Member · Accepted solution]

Thank you very much Benedikt. I haven't had a chance to look at your reply since I posted this thread but SRGBTBREL table allows me to identify the number of customers with attachments and number of attachments/Notes that each customers has. This is the starting point that I needed. I will check out the function modules you have mentioned to see if they can help with extraction and loading. Thanks again.

[Former Member]

Hi Lee,

I assume that the document is attached to customer master is in DMS.

1) How to extract the Electronic documents from Customer Master in SAP ECC6 system

2) How to Specify the Customer Number as a selection criteria

If you have attached document in DMS with respect to customer then you must have used object link in DIR. You can have linked the customer master and DIRfrom DRAD table and the attached document can get from the FM BAPI_DOCUMENT_CHECKOUTVIEWX.

3) How to attach the document onto the customer in the new SAP Hana system

Sorry,I have not worked with SAP HANA servers.

Rgds,

Nayeem.