on 04-16-2007 3:47 PM
Hi,
i am looking for the field where is stored vendor of item in shopping card(i am extendind the check functionality of sc). Is in structure BBPS_SC_APP_ITEM some id of the vendor? or how can i find him?
thanks
JJ
Hi
Which SRM version are you using ? What is your business requirement ?
<u>In the BADI - BBP_DOC_CHANGE_BADI</u> the table
ET_PARTNER [] Table contains the various Business Partner for every corresponding line item of the Shopping cart.
PARTNER_ID contains the value. Look for Partner_FCT = "00000019" using BBP_PD transaction for any particular shopping cart (Object Type - BUS2121).
Partner_FCT field in ET_PARTNER Table (Partner Function) can have multiple values for a single Shopping cart line item - typically 20 for-> goods Recepient, 19 for-> Vendor, 16 for-> storage location, 10 for -> plant, etc)..
Let me know if you need anything else.
Regards
- Atul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
As I told you earlier,
Every Shooping cart is identified by a Parent GUID (Say, like this - 451679F76C9E018A000000000ADCCB90 generated by system at run time).
A shopping cart can consist of multiple line items, having diffferent Item GUIDs, but referring to the Same Parent GUID.
For every Shopping cart line item, there is a unique GUID which is used as a Primary Key.
For every Single Shopping cart line item, there will be at least 3-4 partners (Vendor, Ship-To-Address, Location, Requester, etc.)
The ET_PARTNER [ ] Table will be referring to the same GUID. For Identification purpose. The Partner Type (PARTNER_FCT Field will determine, which type of partner we are refrring for a particular Shopping cart line item, in this case)
Sample ET_ITEM (SC Item Data) Table Data for your reference ->
CLIENT 120
GUID 3FCDE1B900AE00CDE10000000ADCCB4F
CREATED_AT 20031204162,838
CREATED_BY TESTEMPLOYEE
CHANGED_AT 20031204162,838
CHANGED_BY TESTBUYER
OBJECT_TYPE BUS2121001
DESCRIPTION_UC OKB9 120 ITEM 23820
HEADER 3FCDE16000AE00CDE10000000ADCCB4F
PARENT 3FCDE16000AE00CDE10000000ADCCB4F
ALTERNATIVE 00000000000000000000000000000000
PRODUCT 00000000000000000000000000000000
PRODUCT_SRC_SYS
ORDERED_PROD
PARTNER_PROD OKB9 120 item 23820
DESCRIPTION OKB9 120 item 23820
ITM_LANGUAGE
NUMBER_INT 0000000001
NUMBER_EXT 0000000000
ITM_TYPE
ORDER_DATE 0
SUBST_REASON
ITM_USAGE
ITM_TYPE_USAGE
PRODUCT_KIND
LOG_SYSTEM_EXT
ORDERADM_I_DUMMY
<u>Sample ET_PARTNER Table Data for your reference -></u>
Partner:
Partner_Fct Description Partner_No E
0000000001 00000027 Ship-To Address 3A8FEB53D80A4992E10000000ADCCB43
0000000001 00000020 Goods Recipient 3D2D521121F79B6EE10000000ADCCB4F
0000000001 00000016 Requester 3D2D521121F79B6EE10000000ADCCB4F
0000000001 00000075 Location 451679F76C9E018A000000000ADCCB69
Hope this will help.
Do let me know.
Regards
- Atul
You can find the item level vendor details using funcitonal module 'BBP_PD_SC_GETDETAIL' and 'BBP_PD_SC_ITEM_GETDETAIL'
You can find the vendor details in ET_PARTNER.
In this ET_PARTNER check for the partner_fct (partner function) equal to '00000019'. This partner function refers to vendor.
Use Tcode BBP_PD to find all the details which you need.
Reward points if the answer is useful
Regards,
Andy
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.