Skip to Content
0
Former Member
Dec 07, 2011 at 08:41 AM

DTW - Business Partner Master Data

170 Views

Hello, i'am having some problem concern to import of marter data of BP, in OCPR - ContactEmployees and CRD1 - BPAddresses.

I'am using ODBC and using the query structure like in the .scv files.

I do the import and DTW don't give error message and do nothing... DTW run for a while and do nothing... I´m using 8.82 SBO.

Here is an example:

select

P.AdrNr as ParentKey,

null as LineNum,

P.AdrNr as CardCode,

P.Ansp as Name,

P.Abt as Position,

null as 'Address',

P.Tel1 as Phone1,

P.Tel1 as Phone2,

null as MobilePhone,

P.Fax as Fax,

P.EMail1 as E_Mail,

null as Pager,

null as Remarks1,

null as Remarks2,

null as 'Password',

null as PlaceOfBirth,

P.GebDat as DateOfBirth,

CASE WHEN (P.Anr='Herr') THEN 'M'

WHEN (P.Anr='Frau') THEN 'F'

ELSE 'E'

END as Gender,

P.Pos as Profession,

P.Tit as Title,

null as CityOfBirth,

null as Active

from M.M.Tablex P