Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Extract Customer Master attachment service text

Former Member
0 Kudos

Hi All,

I have got a requirement wherein I have to extract the texts attached in the Customer Master "SERVICES FOR OBJECT ' tab.

When I go to XD03 & enter the customer number & then When We click on SERVICES FOR OBJECT tab we get an attachment list & when we click on any of the note in the list it will be having some text, this text I have to extract.

Experts any inputs as to How can Proceed.

Regards

*Abhii

6 REPLIES 6

raymond_giuseppi
Active Contributor
0 Kudos

Keys used in constructor of cl_gos_manager class when lauching transactions like KD03 are (put a break-point in it to check yourself)

- OBJKEY = kunnr

- OBJTYPE = 'KNA1'

With this data you can use FM and methods or database tables of packages SGOS*.

Regards,

Raymond

Former Member
0 Kudos

You can use FM SGOS_NOTE_DISPLAY to obatin those notes.

I hope it helps!

Esteban

0 Kudos

If you can't perform it yourself take a look at [Extract files attached to business process objects e.g. Sales Order, Service Order, and Accounting Documents etc.|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/16883] [original link is broken] [original link is broken] [original link is broken];

Regards,

Raymond

0 Kudos

Hi Raymond,

Thanks a lot. The link above helped me a lot. I have developed the code for Customer KUNNR. I am able to read all the notes in an Intenral table but I want to display the NOTE TITLE & CREATNOR NAME alongwith the NOTE.

Can you please guid how to fetch this information.

Thanks & Regards

Abhii

0 Kudos

In the LOOP on et_links after execution of FM SO_DOCUMENT_READ_API1, you should find the information that you requested in the DOCUMENT_DATA exported parameter .

Regards,

Raymond

0 Kudos

Hi Raymond,

DOCUMENT_DATA will not have the actual data, I mean the name of the NOTE altogether.

I have found a solution. The same is as follows :-

Based on the DOCUMENT_DATA, I am querying table SOOD for the information I needed by passing OBJTYP, OBJYR & OBJNO that I get from DOCUMENT_DATA, in the where clause & I am getting OBJDES ( Name of the Note ) , OWNNAM ( Name of the ceator ) & CRDAT ( Creation Date )


     SELECT OBJTP
            OBJYR
            OBJNO
            objdes
            ownnam
            crdat
            crtim
            FROM sood
            INTO TABLE it_sood
            FOR ALL ENTRIES IN it_temp
            WHERE objtp = it_temp-objtp
            AND   objyr = it_temp-objyr
            AND   objno = it_temp-objno.

Also thanks all for your valuable inputs.

Regards

Abhii