02-11-2011 10:32 AM
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
02-11-2011 12:43 PM
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
02-11-2011 12:48 PM
You can use FM SGOS_NOTE_DISPLAY to obatin those notes.
I hope it helps!
Esteban
02-11-2011 1:02 PM
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
02-14-2011 10:10 AM
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
02-14-2011 12:24 PM
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
02-15-2011 7:00 AM
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