Question Re: How to retreive value of DATE field in SAP-CLM? in Spend Management Q&A

How to retreive value of DATE field in SAP-CLM?

Former Member — Fri, 07 Oct 2011 12:22:28 GMT

Hello,

I am trying to retrieve value of "Date of Publish" field, please let me know what syntax is used for the same.

Thanks,

Saloni

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Fri, 07 Oct 2011 15:17:42 GMT

Hi,

I am using below code to get values of DATE_TO_PUBLISH_DATE and CONTACT_EMAIL, but I am getting null output although there are values set in these fields. Here, publish date is date for publish to supplier and contact email is vendors mail id.

Can you suggest if anything is missing?

publish_date = doc.getExtensionField("DATE_TO_PUBLISH_DATE");

vendor_email = doc.getExtensionField("CONTACT_EMAIL");

Please suggest.

Thanks,

Saloni

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Fri, 07 Oct 2011 15:52:17 GMT

HI,

Only extension fields can be accesed by doc.getExtensionField(..).

Standard fields can be accessed by the respective getter methods (e.g. getPublishDate()). If you don't see a simillar method exposed you should ask SAP for this through an OSS message giving some background aroudn your requirement.

You can use a generic getter "get("Attribute_Name") "method to access standard fields ONLY if SAP confirms this field will be exposed as a fix . Plese note you have a risk of using generic getters for unexposed fields.

Thanks,

Baski

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Mon, 10 Oct 2011 08:33:46 GMT

Hi Baski,

I needed to get values of Vendor_Visible, Date_To_Publish_Date and Email.

As per your last reply, I checked in Setup--> Extension Definitions List. But these fields are not defined there. Although I am able to get value of Vendor_Visible using getExtensionField("Vendor_Visible") but not other two values.

Please confirm how we get to know whether a field is extension field or not.

Thanks,

Saloni

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Mon, 10 Oct 2011 08:45:20 GMT

Hi,

As long as you don't define extension fields explicitly during customization, you won't have any extension fields. All the fields that are delivered are standard fields.

Coming to the question,

In the scenario explained, not sure how you a standard field value(Vendor_Visible) could be accessed through "doc.getExtensionField()". . I seriously doubt that.. Please check. as this a boolean field, you may get FALSE all the time..

In the IAPI document if you see any specifc methods for these variables, you may have to request SAP through an OSS message.

Thanks, Baski

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Mon, 10 Oct 2011 08:53:13 GMT

Hi,

Ok, I will try doing by defining extension fields as well.

While going through IAPI, I found the below methods

getPublishDate()

getPublishToVendor()

getVendorContactEmail()

But when I tried

doc.getPublishDate(), the following error was displayed,

Sourced file: inline evaluation of: ``import com.sap.odp.api.util.; import java.util.; import javax.mail.; import j . . . '' : Error in method invocation: No args method getPublishDate() not found in class'com.frictionless.api.contracts.ContractIBeanImpl'*

Do you have any idea whether what is missing?

Thanks,

Saloni

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Mon, 10 Oct 2011 13:38:08 GMT

Hi Baski,

When I tried to retrieve vendor_visible and date_to_publish using getExtensionField(" ") method, its working fine. But I am still not able to get value for Primary Contact Email on Supplier Info tab.

I am doubtful what is the attribute name we pass for EMAIL address on supplier info tab?

From where can we check this attribute name, as using database column name is not working?

Thanks,

Saloni

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Tue, 11 Oct 2011 12:56:09 GMT

Hi Saloni,

In order to find the e-mail of the primary contact, do the following :

1)Locate the corresponding VendorIBeanIfc for your MA/SA. Use IBean Management for this.

2)Use the getBuyerContactEmail() method on the bean to get the e-mail.

Hope this helps

Devesh

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Tue, 11 Oct 2011 14:06:28 GMT

Hi Devesh,

I tried running the below script but it didnt work.

Can you please check if I am missing something?

linkDefnHome = IBeanHomeLocator.lookup(session,DocumentLinkDefinitionIBeanHomeIfc.sHOME_NAME);

linkDefn = linkDefnHome.findUnique("FCI_MAS_CONTACT");

vendorEmail=linkDefn.getEmail();

throw doc.createApplicationException("VENDOR_VISIBLE", "Supplier Emailis "+vendorEmail);

Also, tried below but not working.

vendorEmail=linkDefn.getBuyerContactEmail();

Please suggest.

Thanks,

Saloni

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Tue, 11 Oct 2011 14:19:34 GMT

Hi Devesh,

In IBean Management, we need to obtain the bean object using below code. But I am not sure what is Unique Document Identifier for VendorIbeanIFC or ContactIBeanIFC.

Can you help with the same.

linkDefnHome = IBeanHomeLocator.lookup(session, DocumentLinkDefinitionIBeanHomeIfc.sHOME_NAME);

// Find by Unique Document Identifier

linkDefn = linkDefnHome.findUnique("Unique document Identifier");

Thanks,

Saloni

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Wed, 12 Oct 2011 09:28:19 GMT

Hello,

You can use the code below to get the email :


vendorHome = IBeanHomeLocator.lookup(session,VendorIBeanHomeIfc.sHOME_NAME);
vendorBean = vendorHome.find(doc.getVendorRef());
email = vendorBean.getBuyerContactEmail();

Don't forget the necessary imports.

I hope this ends your confusion.

Thanks

Devesh

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Wed, 12 Oct 2011 10:59:57 GMT

Hi Devesh,

Thanks alot for your help. My problem is resolved now

Regards,

Saloni

Re: How to retreive value of DATE field in SAP-CLM?

Former Member — Wed, 12 Oct 2011 11:01:29 GMT

Hi,

By using getContactRef( ) issue was resolved. VendorRef( ) was not working.

Using Ibean management was helpful.

Thanks,

Saloni