Skip to Content
avatar image
Former Member

AVL creation...

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Mar 13, 2007 at 08:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 13, 2007 at 08:37 PM

    Hi Gerad

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

    Best regards

    Ramki

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2007 at 07:28 AM

    Hi,

    Use all three function modules one after the other..

    BBP_PD_AVL_CREATE

    BBP_PD_AVL_update

    'BBP_PD_AVL_SAVE'

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2007 at 07:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14, 2007 at 08:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded