cancel
Showing results for 
Search instead for 
Did you mean: 

Help needed please -Master data loading- error with text loading.

Former Member
0 Kudos

Hi,

Iam S.Sushma. Iam getting error while loading master data from flat file- attributes and texts.

I have loaded attribute data successfully. But when iam monitoring the text data then iam getting following error.

""SET THE LANGUAGE FIELD IN THE SOURCE SYSTEM-LONG TEXT.""

""RECORD1: SRPID_1:DATA RECORD 1(EN S):DUPLICATE DATA RECORD.

"ERROR 4 IN UPDATE"

I took 2flat files for attributes and texts.

SRPID is key field.(sales representative id)

attributes:- SRPID, NAME1, AGE1, ADD1,PHONE1.

text:- SRPID,LANG,SHTXT,MDTXT,LGTXT.

Iam just a begginer so need your guidence. Thank you in advance.

Message was edited by: sushma sandepogu

Message was edited by: sushma sandepogu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

In case of loading language dependent texts through a direct infosource you need to use this sequence of fields:

LANG, SRPID ...

Since your sequence is the opposite, the system cannot recognize the language.

Best regards,

Eugene

Former Member
0 Kudos

Hi Eugene,

Thank you for your guidence. I have changed the order in flat file and got the results successfully. But when iam viewing the Master data text the S10 in coming in 2nd position in maintain master data-list screen i mean :-

SRPID LANG NAME AGE ADD PHONE SHTXT MDTXT LGTXT

S1 EN ABC 34 GDS 1234 AS ASD ASDDF

S10

S2

S3

.

..

S9.

Iam not understading why. Hope yu can help me. I have assigned full points to you for your previous solution.

Thank you in advance.

S.Sushma.

Former Member
0 Kudos

Hi,

Do you mean the sorting sequence: S1, S10, S2...?

It's because you key field is alphanumeric.

If you want to have S1, S2, S3, ... S10, then change the key presentation: S001, S002,... S010 etc.

Best regards,

Eugene

PS. You wrote about points. But I see nothing.

Former Member
0 Kudos

Hi Eugene,

Iam sorry iam new to this forum. I got little confused while assigning points. I hope u got points now.

Thank you so much for your guidence. Its really very helpful.

Sushma

Answers (2)

Answers (2)

former_member188975
Active Contributor
0 Kudos

Hi Sushma,

If you are getting an error of duplicate records, then in yur InfoPackage, on the Processing tab choose option: PSA and Ignore Double Data Records, then try the load.

You can also see this link for more info:

http://help.sap.com/saphelp_nw04/helpdata/en/d0/538f3b294a7f2de10000000a11402f/content.htm

Hope this helps...

Former Member
0 Kudos

Hi Sushma,

Set the lanuage in the flatfile or assign a constant "EN" (in case of english) in the transfer rules.

Proceed with the load and let us know.

Bye

Dinesh

Former Member
0 Kudos

Hi Dinesh,

Thank you for your guidence. As said by the Mr.Eugene I have changed the order in flat file and got the results successfully. But when iam viewing the Master data text the S10 in coming in 2nd position in maintain master data-list screen i mean :-

SRPID LANG NAME AGE ADD PHONE SHTXT MDTXT LGTXT

S1 EN ABC 34 GDS 1234 AS ASD ASDDF

S10

S2

S3

.

..

S9.

Iam not understading why. Hope yu can help me.

Thank you in advance.

S.Sushma.