RFC connection

[Former Member]

Hi all,

here i am using RFC connection for getting the values from WBS table PRPS for fields PSPNR POSID and USR11..whenever i m running the FM in R3 i m passing these values to some Ztable in SRM..one strange thing is that if a POSID field contains 'T-08245000.F002' in SRM i m getting as 'T08245000F002'..missing "-."..how to get those values also...

Thanks

[Former Member · Accepted solution]

Hi

*Which RFC Function module are you using in this case ?

META_READ_TABLE Or RFC_READ_TABLE

Which SRM / Backend system version are you using ?

Are you taking care of the Importing paramater - DELIMITER in this case.. ??*

See related links ->

Do let me know.

Regards

- Atul

[Former Member · Accepted solution]

RFC FM is ZFM..in which i m just using select statement from table PRPS with 3 fields..from SRM side just a report for calling this ZFM which RFC enabled...

[Former Member · Accepted solution]

Hi

Is this ZFM function module using any RFC FM in this case... ??

Anyway, You need to use what FM i have suggested, in order to get the data accordingly..

Do let me know.

Regards

- Atul

[Former Member · Accepted solution]

Thanks for ur reply..

i have created a zfm made it as RFC enabled..called in SRM and storing these values in some Ztable..pls tell me why it is not showing some character such as "- ."

[Ramki · Accepted solution]

Hi Ravi

SAP PS uses templates to show the WBS element etc in a configured template form but stores the data without these templates. The stored data is converted in the template form while showing on screen.

In SRM, in the standard fields it should work. But, if you have custom fields, then there shd be a 'conversion' FM which shd do the trick. Am not sure which FM in PS does the conversion job. Why don't you try Atul's FMs to get the data ?

Best regards

Ramki

[Former Member · Accepted solution]

Thanks for ur reply..

I tried using FM CONVERSION_EXIT_ALPHA_OUTPUT or CONVERSION_EXIT_ALPHA_INPUT..both r not working ..

what exactly does...atul's FM will do?? pls explain

[Ramki · Accepted solution]

Hi Ravi

I am not sure what happens in Atul's FMs.

I have no more ideas coming now.

Check, if you can do this through BBP_CUF_BADI_2 with your own logic, then.

Best regards

Ramki

[Former Member · Accepted solution]

Pls help..

Thanks

[Former Member · Accepted solution]

Hi

Please go through the sample code for RFC_READ_TABLE

Use paramater DELEIMITER as 'X' (say) to get the data separated by each column with 'X'

Note 758278 - RFC_READ_TABLE and row size

Note 1120483 - Handling STRING parameters in Remote Function Calls

Do let me know.

Regards

- Atul

[Former Member · Accepted solution]

Atul thanks for ur reply...

but i have already wrote some zfm...now i have all data from R3 to SRM..only problem is in R3 POSID field is having 'V-01654.60.06' in SRM it is showing as 'V016546006'...where to write the RFC_READ_TABLE ..

Pls help..

[Former Member · Accepted solution]

Hi

For better understanding of this problem, Please paste the detailed function module code in next reply

Code for the ZFM which is created as RFC enabled in the system

I guess, there we can find where the R/3 data is getting picked up from SRM system.

Regards

- Atul

[Former Member · Accepted solution]

In R3:In ZFM(RFC enabled)

SELECT PSPNR POSID USR11 FROM PRPS INTO CORRESPONDING FIELDS OF

TABLE LT_PRPS WHERE USR11 = 'X' .

In SRM:in Zreport:

CALL FUNCTION 'ZFM_WBS_TO_SRM' DESTINATION v_destination

TABLES

LT_PRPS = LT_ZTWBS_R3.

*Sending to ztable ZTWBS_R3

IF NOT LT_ZTWBS_R3[] IS INITIAL.

MODIFY ZTWBS_R3 FROM TABLE LT_ZTWBS_R3.

COMMIT WORK.

ENDIF.

[Former Member · Accepted solution]

Hi

I don't get the detailed code here..

How you declared the LTZTWBS_R3[] - Internal table ?? What is the data declaration... ?

Please ensure the SRM table uses the same data type(data elements) similar to PRPS table in R/3 table._

Please give detailed code in next reply...

Regards

- Atul

[Former Member · Accepted solution]

In R3 ZFM:

LT_PRPS LIKE PRPS

In SRM Zreport:

DATA: LT_ZTWBS_R3 type table of ZTWBS_R3.

DATA : GWA_ZTWBS_R3 TYPE ZTWBS_R3.

Fields in Ztable in SRM:

PSPNR ZZPS_POSNR NUMC 8

POSID ZZPS_POSID CHAR 24

USR11 ZZUSR11 CHAR 1

Pls help..

[Former Member · Accepted solution]

use Function module - conversion exit - CONVERSION_EXIT_ABPSN_OUTPUT for PRPS-POSID field

use Function module - conversion exit - CONVERSION_EXIT_ABPSP_OUTPUT for PRPS-PSPNR field..