Upload of RFx - Workbook need to be defined

[Former Member]

Hi,

i woulk like to upload RFX docs in CLM by using import data - rfx workbook.

I need to define this workbook as genera workbook in esourcing don't contains rfx docs.

i created one rfx template based on the contract template, but i received error in the log files :

"Workbook error unable map datatype 'rfx.RFXDoc'| at com.frictionless.install.engine.xls.tasks.DeploymentXlsFile.buildError(DeploymentXlsFile.java:430)| "

what is the correct datatype to be used?

Have you any sample of rfx workbook (xls or csv format) to be uploaded in CLM ?

Thanks for your reply.

Adil

[Former Member]

any ideas?

you input will be appreciated.

Thanks & Regards,

Anacia

[Former Member]

Hi Anacia,

If you are trying to import a csv/excel workbook, there is no format defined for an RFx.

As part of the ECC to CLM integration, an XML import file format has been defined that will allow you to create an RFx stub. Check out the SAP Integration Adapter for more details.

-Howie

[Former Member]

Hi JPadhy,

thanks for your reply.

i seems to me you have defined fields mapping for contract and not RFX.

no EFFECTIVE DATE & EXPIRATIONDATE in RFX.

did you already upload rfx in esourcing?

how i can do rfx import in esourcing?

Thanks & Regards,

Anacia

[Former Member]

Any help? any idea ? anu proposal?

thanks beforehand.

[Former Member]

Hi Anacia,

It seems that u have not defined a proper data. and it is not mapped properly;

please check the bellow data is mapped or not;

Header fields:

DOCUMENT DATE

CURRENCY

EFFECTIVE DATE

EXPIRATIONDATE

PAYTERMS

VENDOR

LIMIT VALUE

COMPANYCODE

PURCH. ORG

PURCH. GROUP

DOC TYPE

Item fields:

LINE ITEM NUMBER

PART NUMBER

DOCUMENT DESCRIPTION

MATERIAL GROUP

PLANT

QUANTITY

UNIT

ITEM CAT

PRICEUNIT

ACCT ASGN CAT

Pricing fields:

MIN QUANTITY

MAX QUANTITY

UNIT PRICE

steps to proceed:

1) Define all the above fields

2) Create some data as per these fields.

3) Now do an import from the desired location through scheduled task.

4) Check in the Import Data (under system administration). (verification of activity)

Hope this helps.

Best Regards

Jagamohan