on 03-03-2008 12:59 PM
Hi there,
SRM 5.0.
Can anybody guide me for whats the standard table which holds the Product category and vendor info.
there are seperate table to hold product cat and Vendor (VENMAP,BUT001) but which is the table which holds both the data in one table of the vendor list.
My requirment is that while creating limit order i can key in any vendor which is not on vendor list but ideally it should check the vendor list and shows an error message if the vendor is not present there.
Regards
Hi Rupesh,
You can use FM BBP_PD_AVL_GETDETAIL.
Kind regards,
Yann
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rupesh,
You can make use of these tables...
1)Product category
COMM_PRODUCT (Product table)
COMM_CATEGORY (Product category table)
ROST_SEL_PRODCAT: Product Categories for Registration
2) BUT000 table for all kind of partners in SRM (Bidders, Vendors, contact persons, suppliers, goods recipients, etc..)
3) Table VENMAP for Vendors replicated from R/3 backend using BBPGETVD Transaction.
ROST_LANG_QSTN -> Language Selection for Question
ROST_PCAT_QSTN -> Assign Product Category and Questionnaire to Lan
ROST_SEL_PRODCAT -> Product Categories for Regis
ROST_WS_QSTN -> Web Survey Questionnaire
ROS_BP_PC_SURVEY -> Assign Vendor, Product Category, Survey
CRMD_IC_SCRATTR Script/Survey attributes (Interactive Script Editor)
ROST_WS_QSTN Web Survey Questionnaire
ROS_BP_PC_SURVEY Assign Vendor, Product Category, Survey
TUWS_SURVEY Survey
TUWS_SURVEY_LOG Survey Log
TUWS_SURVEY_PUB Survey Publishing
TUWS_TAROBJ Survey: Recipients
TUWS_TAROBJ_ATTR Survey: Recipient Attributes
Please reward for helpful answers.
Regards,
Ashwin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can also use function modules to fetch details and vendor lists created using transaction SE37.
BBP_PD_AVL_GETLIST
BBP_PD_AVL_GETDETAIL
Also see the foll tables
BUT000
BUT020
BUT021
You can also see BBP_PDVIEW_LIST table, which displays Vendor List number against Prod Category GUI Id.
BR,
Disha.
Do reward points for useful answers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.