Creditor details

[Former Member]

Hi,

We would like to use the Creditor details from SAP, in non SAP environment, Is it possible? Is there a web service available from SAP?

Inputs / Suggestions are appreciated.

Many thanks,

Dharmi

[kesavadas_thekkillath]

you can use the bapi BAPI_CREDITOR_GETDETAIL

[Former Member]

Hi Kesav,

Thank you for your reply. I check this FM out, is there a FM where creditors name or bank details be given to search for creditor details?

Here you have to give in creditor number .... but if that is not known, it is diffcult to execute this FM!

Best regards,

Dharmi

Edited by: Dharmi Tanna on Sep 6, 2010 11:41 AM

[kesavadas_thekkillath]

The other fms which matches your requirement are

BAPI_VENDOR_FIND

BAPI_VENDOR_GETDETAIL.

You can check these.

[Former Member]

Dear Keshav,

Thank you for your reply.

Can you kindly let me know what is de difference between the FM BAPI_VENDOR_GETDETAIL and BAPI_CREDITOR_GETDETAIL?

Also, BAPI_VENDOR_FIND would help to solve the problem but it has to be then in combination with the above mentioned FM's!

Regards,

Dharmi

Edited by: Dharmi Tanna on Sep 6, 2010 2:59 PM

[kesavadas_thekkillath]

Hi Dharmi,

What you can do is use these fm's wrap it in a custom created RFC which encapsulates your required functionalities.

Then use your custom RFC fm for your purpose.

[Former Member]

Hi,

The FM BAPI_CREDITOR_GETDETAIL uses select * from lfa1 , lfb1 & lfbk tables to fetch vendor data , company code relevant

data and bank details.

If you have proper index for the field you want to select with, You can use the same in the program.

SELECT * FROM LFA1 WHERE NAME1 = p_name1 if you don't have the vendor number.

Based on the vendor number obtained in the above select, you can get the remaining tables from LFB1 and LFBK.

Hope it helps.

Sujay

[Former Member]

Hi Suya,

Thank you too for your reply.

Do you suggest to create the FM?

Regards,

Dharmi

[Former Member]

Hi,

Yes.

In the remote function module have the vendor number and the name both as optional parameter. If vendor number is available, use the function module BAPI_CREDITOR_GETDETAIL. If not, select from the tables. Have a return table, if the both the details are not passed, then throw error & capture error details from the function module.

Hope it helps,

Sujay

[Former Member]

Hi,

Create a Remote Function module in se37 and add the Pass the Vendor Number and Bank details in Import parameters.

and

SELECT SINGLE * FROM LFB1 WHERE LIFNR = vendor

AND BUKRS = COMPANYCODE.

MOVE-CORRESPONDING LFB1 TO LM_COMPANY_DETAIL.

SELECT * FROM LFBK

INTO CORRESPONDING FIELDS OF LM_BANK_DETAIL

WHERE LIFNR = vendor.

APPEND LM_BANK_DETAIL.

ENDSELECT.

and Release the Function module then PI team will import the Function module and they do mapping..

And the ensd user will pass the data on that basis the bank details will be sent to them..

ABAPer will create the function module and then they will release rest will take care By PI.

Prabhudas

[Former Member]

Hi ,

Us e the Below function module using XI or FTP connection to get connected with non sap systems

• read the company code level date for the customer number at vendor

CALL FUNCTION 'BAPI_CREDITOR_GETDETAIL'

EXPORTING

CREDITORID = SEL_VENDOR

COMPANYCODE = GLOBAL-CO_CODE

IMPORTING

CREDITOR_COMPANY_DETAIL = BAPI1008_5

RETURN = BAPIRETURN

EXCEPTIONS

OTHERS = 0.

Prabhudas

[Former Member]

Prabhudas,

Thank you for your reply. I am looking for FM which searches based on name / bank details... Yes I want to use it via PI but before the interface is made using PI.. this details needs to be available on the sender system. The sender system is non SAP.

I had an idea of using FM, since it is exposed as Web Service. If you had any other idea, can you kindly elaborate?

Regards,

Dharmi