UDFs during Data Transfer Workbench

[jiawen_wei]

Hi All,

I am currently trying to use Data Transfer Workbench to import some Good Receipt POs into the system.  The three templates that i use are Document, Document_Line and SerialNumber.

For each line item in a GR, i will need to assign a unique serial number to it.  Also, i will need to define a Length and Width to this serial number.

Therefore i have two UDFs set up in the serial number assignment window in the system -- Length and Width.  And i also have another two UDFs in the GR line item field.

However, during DTW -- mapping process, the UDFs i set up in the GR document shows up under the selection when i mapping the document_line template.  But the UDFs in my serial number assignment window did not show up in the serialNumber template.

Please advise how to make the UDFs available in the SerialNumber template in DTW mapping stage

Thanks

[kothandaraman_nagarajan]

Hi,

Please advice SAP version and PL.

Thanks & Regards,

Nagarajan

[jiawen_wei]

Hi Nagarajan,

This problem is already solved.  Thanks for your response.

[jiawen_wei]

Hi Nagarajan,

I am sorry but i take that back. 

Its B1 9.0 and PL05

I have been testing all day and there are three templates involved: Document, Document_Line and SerialNumber.

The strange thing is that if i only uploaded Document and Serial Number, the UDFs will appear under SerialNumber during Mapping process

However, if i add the Doc_Line template, the UDFs will be appear under Doc_Line, not SerialNumber.

[kothandaraman_nagarajan]

Hi,

Sorry i don't have 9.0 version to test DTW.

Thanks & Regards,

Nagarajan

[kedalenechong]

Hi Nagarajan

It is easy to install DTW from SAP 9 patch and packages Data Transfer Workbench.

Kedalene

[kothandaraman_nagarajan]

Hi,

It is not an installation of DTW.  I don't have 9.0 version in my company to check subject.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

Are these 2 UDF newly added? If yes, restart may be needed.

Thanks,

Gordon

[jiawen_wei]

Hey Gordon,

Actually those are not newly added.  I added four UDFs at the same time, two in the serial number assignment window, another two under the Document Row.

However, during the DTW mapping rules, only the two under the Doc Row shows up when i did the mapping for Doc_Line template.  The two for the serial number assignment did not show up when i did the mapping for SerialNumber template.

[Former Member]

Which table has you added the UDF? It may not be the one you want to DTW to.

[jiawen_wei]

The two UDFs in the serial number assignment window are added to OSRN table

[Former Member]

Check your DTW result without these UDF to see if OSRN was indeed updated.

[jiawen_wei]

I think i understood what you have said earlier, i believe in DTW, the Serial Number template is referring to the SRNT table, not OSRN.

Do you know how could i navigate to the corresponding window in the system for table SRNT?

[Former Member]

Not all tables can add UDF. I don't have the same db to find it out.

[jiawen_wei]

It is strange but i could not locate table SRNT.

The location where i added the UDFs are under Inventory -- Serial/Batch Number Object.  And it seems like these two fields appear under all the Serial Number related windows.

However, none of them are linked to SRNT table.

[Former Member]

In this case, you may only add UDF through SDK.

[jiawen_wei]

Hey Gordon,

I located my two UDFs in DTW, instead of using the SerialNumber template under Goods Receipt PO, i used the SerialNumber template under Inventory.

Thanks

[Former Member]

That is a good news.