Pass Parameter to BAPI

[Former Member]

Hi Experts,

we have created a universe in information design tool using BAPI (abap function),

while i manually give the input columns to BAPI in IDT its throwing the result.But when i try to pass the parameter it is throwing me the error

"No input argument for: ABAPFunction.0012.

Can any one please tell how to pass values in BAPI input columns using parameters.

Any small information can also be helpful.

Error in detail:

<com.businessobjects.dsl.commons.exception.NestedException: Failed to execute:

SELECT

  Table__1.

---------------from----

Cause of Error

No input argument for: ABAPFunction.0012.

Thanks In Advance,

Sheetal Sharma

[Former Member · Accepted solution]

Hi All,

Thanks for reply.

The issue has been solved.

Resolution:

ERP Functional Module does not support Multiple Values when Calling ERP FM in Information Design Tool. On passing the Single Value through a Parameter we are able to get the desired results.

Uncheck-> “Allow Multiple Values”  in IDT while creating Parameters.

Regards:

Sheetal

[venkateswaran_k]

Hi

couple of check points

1.  Is this function RFC enabled ?  

2.  Check your import parameters -  a) pass by value?     b) Optional or Mandatory

Regards,

Venkat

[Former Member]

Hi Venkateswaram,

Yes the function is RFC Enabled.

and parmeters are mandatory.

Regards:

sheetal

[venkateswaran_k]

Okay,

1. Can you please let me know what are those parameters.

2. Can this be made as optional and inside the function you get it appropriately (if they are initial). 

3.  is there any date parameter.

It looks like, since they are mandatory parameter, the value you are passing to the RFC from outside is not being picked up appropriately.  (example in case of date field it behaves differently inside SAP)

Please update

Regards,

Venkat

[Former Member]

Hi Venkateswaram,

None of the parameter is passing value.

yes there is date parameter also but other parameters are also not work.

The error in sql is as under:

com.businessobjects.dsl.commons.exception.NestedException: Failed to execute: SELECT

Table__1."-id",

Table__1."-idref",

Table__1."-IMPORT_AUART.SIGN",

Table__1."-IMPORT_AUART.OPTION",

Table__1."-IMPORT_AUART.LOW",

Table__1."-IMPORT_AUART.HIGH",

Table__1."-IMPORT_DATE.SIGN",

Table__1."-IMPORT_DATE.OPTION",

Table__1."-IMPORT_DATE.LOW",

Table__1."-IMPORT_DATE.HIGH",

Table__1."-IMPORT_PLANT.SIGN",

Table__1."-IMPORT_PLANT.OPTION",

Table__1."-IMPORT_PLANT.LOW",

Table__1."-IMPORT_PLANT.HIGH",

Table__1."-IMPORT_SO.SIGN",

Table__1."-IMPORT_SO.OPTION",

Table__1."-IMPORT_SO.LOW",

Table__1."-IMPORT_SO.HIGH",

Table__1."MANDT",

Table__1."VBELN",

Table__1."POSNR",

Table__1."MATNR",

Table__1."KUNNR",

Table__1."NAME1",

Table__1."ERDAT",

Table__1."DESIGN",

Table__1."QUALITY",

Table__1."PSTYV",

Table__1."IHREZ",

Table__1."BNAME"

FROM

"ABAPFunction"."ZFMGRP_BOBJ"."ZFM_ZDSOC.-EXPORT_CH_IT_OUT" Table__1

WHERE

(

Table__1."-IMPORT_AUART.SIGN" = 'NULL'

AND

Table__1."-IMPORT_AUART.OPTION" = 'NULL'

AND

Table__1."-IMPORT_AUART.LOW" = 'XYZ'

AND

Table__1."-IMPORT_AUART.HIGH" = 'NULL'

AND

Table__1."-IMPORT_DATE.SIGN" = 'NULL'

AND

Table__1."-IMPORT_DATE.OPTION" = 'NULL'

AND

Table__1."-IMPORT_DATE.LOW" IN (DATE'2013-06-01')

AND

Table__1."-IMPORT_DATE.HIGH" = DATE'2013-06-30'

AND

Table__1."-IMPORT_PLANT.SIGN" = 'NULL'

AND

Table__1."-IMPORT_PLANT.OPTION" = 'NULL'

AND

Table__1."-IMPORT_PLANT.LOW" = '33210'

AND

Table__1."-IMPORT_PLANT.HIGH" = 'NULL'

AND

Table__1."-IMPORT_SO.SIGN" = 'NULL'

AND

Table__1."-IMPORT_SO.OPTION" = 'NULL'

AND

Table__1."-IMPORT_SO.LOW" = 'NULL'

AND

Table__1."-IMPORT_SO.HIGH" = 'NULL'

)

>

Cause of Error

No input argument for: ABAPFunction.ZFMGRP_BOBJ.ZFM_ZDSOC.-EXPORT_CH_IT_OUT.-IMPORT_DATE.LOW

I have passed other values manually and only date low as parameter, and it gives error whille polulating the import parameter through universe parameter seems like BAPI is not reading "IN".

Note: If i manually give parameters to all Query is running fine.

Thanks in Advance

Sheetal Sharma

[venkateswaran_k]

Hi Sheetal,

Inside SAP, the date is recognized as  'YYYYMMDD' .. 

I faced this problem earlier when I was accessing the BAPI from Dashboard. 

My solution was,  BAPI I changed the input date parameter as CHAR and inside the function I reconverted it into DATE.

Example :  From your query - the date is going as  '01.07.2013'.

But Import parameter of BAPI recognizes only when it is of like  '20130701'

Probably you may look into this angle.

Regards,

Venkat

[Former Member]

Hello Sheetal,

Have you seen corresponding SQL query generated on the BO side.

This is a useful link

http://events.asug.com/2012AC/0303_Best_Practices_for_Integrating_SAP_BusinessObjects_BI_40_with_SAP...

regards

Kaushik

[Henry_Banks]

Hi,

Please state:

• What is your version, support package, and Patch level?
• Is this an ERP universe?   What's the name of the driver as you see it in IDT?
• Is this a single source or multi source enabled foundation?

Here are the guides you need:

IDT : http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp6_info_design_tool_en.pdf

Data Access : http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp6_data_acs_en.pdf

You may want to read the sections on ERP parameters (see "Map Table Parameters into Input Columns" )  and limitations ("ERP restrictions") in the above docs.

Regards,

H

[Former Member]

Hi Henry,

Thanks for reply.

1. We are using BO 4.0 SP06

2. Yes it is ERP universe.Created on ABAP function(BAPI)

3. Its a single source universe.

Regards

sheetal.