How to import text to note object?

[Former Member]

Hi Guru,

I upload mass employees' qualification by LSMW (using t-code: PP02). It works fine. But I also want to upload a remark text in to a Note object that related to assigned qualification. So when a user display or edit infotype 24-Qualification they can see a mark text (PD and PA is integrated, so the Skill infotype is replaced by Qualification from PD component).

Anyone have any idea to upload text into note object?

Thanks in advance.

[Former Member · Accepted solution]

Hi guy,

I guees you should use a LSMW for long text.

Check the link :

<a href="http://help.sap.com/saphelp_erp2005/helpdata/en/e1/c6d30210e6cf4eac7b054a73f8fb1d/frameset.htm">http://help.sap.com/saphelp_erp2005/helpdata/en/e1/c6d30210e6cf4eac7b054a73f8fb1d/frameset.htm</a>

Hope this helps,

Erwan

[Former Member · Accepted solution]

Hi Erwan,

I've tried following the instruction, but I encountered the problem at Read Data stage. The system popuplates message "Generation cancelled. Reason: No Fields Called the Same".

The structer of file has two-level hierarchy (Maint Source Fields)

TEXTHEADER Text Header

TXTOBJECT C(010) Text Object

TXTNAME C(030) Text name

TXTID C(004) Text ID

TXTLANG C(002) Text Language

TEXTBODY TextBody

TXTNOTE C(132) Note

Structure relationships between the legacy system and the SAP system:

/SAPDMC/LTXTH Long Texts: Header <<<< TEXTHEADER Text Header

Select Target Structure /SAPDMC/LTXTH .

/SAPDMC/LTXTL Long Texts: Row <<<< TEXTBODY TextBody

Select Target Structure /SAPDMC/LTXTL .

Generation conversion program at "Maintain Field Mapping and Conversion Rules" successfully. Specify files and Assign file are OK. But when system read data, it produce the above message.

Do you have any clue?

Thanks.

[suresh_datti · Accepted solution]

PL check this <a href="https://forums.sdn.sap.com/click.jspa?searchID=3752733&messageID=3310490">Thread</a>.

~Suresh

[Former Member · Accepted solution]

Hi Suresh,

I tried to import the long text (note) to employee's qualification (in infotype 0024) by LSMW. But it doesn't work. And I'm don't know on ABAP, so i can not adapt your code. Anyway, thank you for your help.

Best regards,

ECTSAKC

[Former Member · Accepted solution]

Hi,

Check your recording, you should select the Text field also during recording. Then maintain it in the legacy.

Good luck

Om

[Former Member · Accepted solution]

Dear ECTSAKC ,

If i am not wrong you are trying to read infotype text from PCL1.

You can use macro

RP-EXP-C1-TX

or

IMPORT TEXT-VERSION

PTEXT

TO DATABASE PCL1(TX)

ID TX-KEY

USING PCL1_EXP_IMP

For writing the text you can use Export or you can also use

HR_ECM_INSERT_INFOTYPE

Kindly correct me in case i have misunderstood the question itself.

Regards & Thanks,

Darshan Mulmule

[Former Member · Accepted solution]

Hi Om,

I used the standard program as Direct input (Object 0001, Method 0001) by using program name /SAPDMC/SAP_LSMW_IMP. So, no need to recording the screen, and the recording of maintian note in IT0024 (when integration with PD) cannot be done. Anyway, thanks for you input.

Cheers!..

ECTSAKC

[Former Member · Accepted solution]

Hi all,

After working for a while, I notice that the source file structure was wrong. The source file should look like this:

MYTEXT Qualification Note

TXTNAME C(030) --- it will be mapped with /SAPDMD/LTXTH

TXTNOTE C(072) --- it will be mapped with /SAPDMD/LTXTL

(other LTXTH objects, OBJECT, ID, SPAS are assign as constant value)

With this structure, the LSMW work successfully.

It would be helpful information for anyone who stuck with the same problem.

Cheers!...

ECTSAKC

[Former Member · Accepted solution]

Hi ECTSAKC,

Definetely, it will be useful for all in some situation. Thanks for sharing up the Solution.

Cheers !!

Om