topic Re: Vendor master data.... in Application Development and Automation Discussions

Vendor master data....

Former Member — Tue, 05 May 2009 05:31:24 GMT

I want upload vendor master data in backend. As per my requirement I have to use Functional module and BAPI. Not in online BPAI u2026ie BAPI_Vendor_Create.

Please help me on Function module or BAPI to use in back end for upload the vendor master data.

Re: Vendor master data....

Former Member — Tue, 05 May 2009 05:46:08 GMT

Hi Santosh,

You need to store your files to be uploaded in .txt format in application server, then you need to use OPEN DATASET, READ dataset and close data set statement accordingly to fetch the data from application server and then you can upoad the data using call transacton(recording).

I don't know whether the BAPI bapi_Vendor_Create can be used or not.

hope this code would surely help you.

DATA:

dsn(20) VALUE '/usr/test.dat',

rec(80).

OPEN DATASET dsn FOR INPUT IN TEXT MODE.

IF sy-subrc = 0.

DO.

READ DATASET dsn INTO rec.

IF sy-subrc <> 0.

EXIT.

ELSE.

WRITE / rec.

ENDIF.

ENDDO.

ENDIF.

CLOSE DATASET dsn.

Regards,

Suvendu

Edited by: Suvendu Swain on May 5, 2009 7:46 AM

Edited by: Suvendu Swain on May 5, 2009 7:52 AM

Re: Vendor master data....

Former Member — Tue, 05 May 2009 06:02:49 GMT

hello, bapi_vendor_create is used in dialog mode , i,e it opens a transaction for creating the vendor

u cannot use it , u have to write a BDC for doing the same

hope it solves ru problem.

afzal

Re: Vendor master data....

Former Member — Tue, 05 May 2009 06:03:33 GMT

Try with BDC.

Thanks and Regards,

Re: Vendor master data....

Former Member — Tue, 05 May 2009 06:05:54 GMT

Hi,

Check these below FM's

CACS_VENDOR_CREATE

PI_BP_BUPA_MAP_VENDOR_CREATE

VENDOR_TEXTS_CP_CREATE

FI_WT_CREATE_VENDOR

Regards,

Jyothi CH.

Edited by: Jyothi Chinnabathuni on May 5, 2009 11:36 AM

Re: Vendor master data....

Former Member — Tue, 05 May 2009 06:39:09 GMT

These are BAPI not able to solve the requirment.

Re: Vendor master data....

Former Member — Tue, 05 May 2009 06:44:43 GMT

I found one of the BDC program for vendor master data upload RFBIKR00.... But i want the input of the file structure for the program.

Please help me briefly about the program...i try to use in my code..... how to pass the structre to this program....and how it call the BDC.

Please help me....

Re: Vendor master data....

Former Member — Tue, 05 May 2009 06:52:31 GMT

Hi,

check these FM, if they solve your purpose,

OIUCM_VENDOR_UPDATE

EINE_SAVE_BACKGROUND

ISIDE_SM_VENDOR_DETAILS_UPDATE

FMFG_CCRUPLOAD

ML_CREATE_DOCUMENT

EINE_ASSORTMENT_UPDATE1

EINE_SAVE

EKKO_SAVE

EKKO_SAVE_BACKGROUND

OI0_MF02K_SET_CRED_DATA

Re: Vendor master data....

Former Member — Tue, 05 May 2009 06:59:21 GMT

You need to create a custom BDC, or copy the standard one.

You need to create a structure, fields are same as the flat file fields of the BDC.

If u want to upload single vendor, then define a work area with referance to above created structure in export parameters of RFC.

If u want to upload multiple vedors, then define a table with referance to above created structure.

Map the fields of the workarea or table into the BDCDATA as the field values.

Thanks and Regards

Re: Vendor master data....

Former Member — Tue, 05 May 2009 07:01:24 GMT

I found the FM Vendor_BDCDATA..... Here also same input structure need to pass on.... i want the input structure......what are the fields need to pass... how to convert the structure of PI_TAB_WA.

Please help me....

Thanks & Regards

Santhosh

Re: Vendor master data....

Former Member — Tue, 05 May 2009 07:06:32 GMT

Vendor_BDCDATA is useful while uploading the IDOC data not from flat file or input data.

Re: Vendor master data....

Former Member — Tue, 05 May 2009 07:08:40 GMT

Hi,

this FM will just convert the data from PI_TAB_WA to BDCDATA it will not create vendor master records...

the structure PI_TAB_WA has 8 character fields.... just pass in the values of those 8 character fields in the order how it requires to be created while giving inputs to create a vendor master...

pass that data to the FM and that will convert it into BDCDATA structure and using that BDCDATA you can use call transaction with the transaction code of creating vendor master

Regards,

Siddarth

Re: Vendor master data....

Former Member — Tue, 05 May 2009 07:17:34 GMT

Yes ur right.... how to pass the data to that FM....what is the structure of the pasing data....please help me...

Re: Vendor master data....

Former Member — Tue, 05 May 2009 07:26:15 GMT

hi,

create one internal table in your program with datatype BDIFIBIWA which has 8 character fields....

data : itab1 type table of BDIFIBIWA.

the field name are

CHAR1

CHAR2

CHAR3

CHAR4

CHAR5

CHAR6

CHAR7

CHAR8

create another internal table with data type BDCDATA

DATA : bdc_data type table of BDCDATA.

fill in these entries and then pass in the FM

and pass a single character for PI_VART

This FM will fill bdc_data and you can use it in call transaction

Regards,

Siddarth

Re: Vendor master data....

Former Member — Tue, 05 May 2009 07:52:13 GMT

The vendor releated fileds value how to pass the 8 charater fileds....any offset we need to use...any functional module to use for this.

Re: Vendor master data....

Former Member — Tue, 05 May 2009 08:10:01 GMT

How to write a program using FM Vendor_bdc data.....and also how to pass the below data to the FM using flat file.

S.no Fields Table Description

1. LIFNR LFA1 Vendor Account Number

2. BUKRS LFB1 Company Code

3. EKORG LFM1 Purchasing Organization

4. KTOKK LFA1 Vendor account group

5. ANRED LFA1 Title

6. NAME1 LFA1 Name1

7. SORTL LFA1 Sort field

8. NAME2 LFA1 Name2

9. STRAS LFA1 House number and street

10. PFACH LFA1 PO Box

11. ORT01 LFA1 City

12. PSTLZ LFA1 Postal Code

13. ORT02 LFA1 District

14. LAND1 LFA1 Country Key

15. SPRAS LFA1 Language Key

16. TELF1 LFA1 First telephone number

17. TELFX LFA1 Fax Number

18. AKONT LFB1 Reconciliation Account in General Ledger

19. ZTERM LFB1 Terms of Payment Key

20. REPRF LFB1 Check Flag for Double Invoices or Credit Memos

21. ZWELS LFB1 List of the Payment Methods to be Considered

22. WAERS LFM1 Purchase order currency

23. VERKF LFM1 Responsible Salesperson at Vendor's Office

24. WEBRE LFM1 Indicator: GR-Based Invoice Verification