AVL creation...

[Former Member]

Hi,

Have anyone used the function module,

BBP_PD_AVL_CREATE

to create vendor list..

i want to write a conversion program which creates vendor list from a flat file,

i am trying to test that function module but its not creating any list..

help needed..

thanks.

[Former Member]

Hi,

Please follow the steps.

-Call function module GUI_UPLOAD and pass local file to the export.

-Call function module BBP_PD_AVL_GETLIST and pass category_id and Pur_org to the exporting parameter.

In table parameters will get E_PDLIST data.

- If E_PDLIST is not initial. It means that vendor list exist for the combination of category id and pur orgn .move error message to error_message table.

-If E_PDLIST is initial build the function module data I_header, I_ORGDATA.

-Call function module BBP_PD_AVL_CREATE and pass the I_header, I_ORGDATA.

-The function module will return e_header, e_ORGDATA.

BBP_PD_AVL_CREATE functional module will generate GUID,

Use vendors from XL/CSV file and build I_PARTNER .I_ITEM.

- Call function module BBP_PD_AVL_update.

CALL FUNCTION 'BBP_PD_AVL_UPDATE'

EXPORTING

I_HEADER = I_HEADER_u

I_SAVE = 'X'

TABLES

I_ITEM = I_ITEM

I_PARTNER = I_PARTNER

I_ORGDATA = I_ORGDATA_u

E_MESSAGES = i_MESSAGES_u.

Delete I_MESSAGES_u WHERE MSGTY ne 'E'.

If I_MESSAGES_u is initial.

CALL FUNCTION 'BBP_PD_AVL_SAVE'

EXPORTING

iv_header_guid = I_HEADER_u-GUID.

COMMIT WORK AND WAIT.

endif.

regards

Rajesh

[Former Member]

Hi

<u>I am not sure, whether you have seen this BADI - BBP_AVL_DETERMINE in SE18 Transaction.</u>

I hope this will help.

BBP_AVL_DETERMINE
____________________________________________________
Short Text
Define Sourcing via Vendor List


Use
You can use the Business Add-In BBP_AVL_DETERMINE to determine if sourcing for shopping carts or limit shopping carts created by employees is to take place using the vendor list only. Otherwise, all available sources of supply are taken into consideration.

Activities
The following parameters are available in method DETERMINE_AVL:

Import
COMPANY  (Company in MarketSet Procurement)
CATEGORY_ID (Product category ID)
CATEGORY_GUID (Product category GUID)
PRODUCT_ID (Product ID)
PRODUCT_GUID (Product GUID) 
REQUESTER (Requester of a shopping cart) 
Changing
AVL_DET (Determination of source of supply using vendor list)

If sourcing is to take place using the vendor list only, then you set the value of attribute AVL_DET of the changing parameter AVL_DET to 'X'. Otherwise, the value must be initial.

Let me know the results, even if does not suits your requirement.

Please reward suitable points, incase it suits your requirements.

Regards

- Atul

[Former Member]

Hi,

Use all three function modules one after the other..

BBP_PD_AVL_CREATE

BBP_PD_AVL_update

'BBP_PD_AVL_SAVE'

[Ramki]

Hi Gerad

Are you trying to create Approved Vendor List or Vendor Master ?

Best regards

Ramki

[Former Member]

hey i am trying to create vendor list and not vendor master...

i want to migrate the sourcing list thats in r/3 to srm...

do we have any transactions that do it...

or do i need to write my own conversion program for that..

thanks.

[Ramki]

Hi Gerad

There is no standard program for this. Replicate the vendors first (BBPGETVD) and

use own conversion programs to create vendor lists. It is treated as

Best regards

Ramki

[Former Member]

Thanks for your reply.

i am trying to create a conversion program to create vendor list in srm using the function module,

BBP_PD_AVL_CREATE,

i tried testing the function module, i get couple of error mesages,

'Enter at least one partner of type Release-Authd Purchasing Org'

but i have entered a valid business partner.

Any help on this.

Thanks.

[Ramki]

Hi Geard

Best is to try the same data once on screen. Pl check this Purch.org on screen once.

Best regards

Ramki

[Former Member]

Hi

Which SRM version are you using ? Any specific need - to use this FM only ?

Why not use the standard program (tcode - BBPGETVD) to do the job ?

You can copy the standard progam and enhance the flat file upload functionality here in one of the screens and change few lines of code to fetch data from your file path specified in the report.

Let me know incase you need any pointers.

Hope this will help.

Regards

- Atul

[Former Member]

we are using srm 4.0,

thanks for your reply i will check on that and will let you know.