I have created shopping cart with 2 line items and each line item is having 2 attachments.
Now I am having the attachment data in table bbp_pdatt .and we have item data also.
I could not get the line item number or data in table bbp_pdatt.In table bbp_pdatt only attachment data exist.
I want to know for which line item the attachment belongs to.
Please tell me if there is any table having the attachment data as well as item data.in single table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can establish the link as follows:
Read CRMD_LINK table with GUID_HI = 'Item Guid' AND
The above will give you the result set which contains set guids (GUID_SET) values for attachment. This value can be joined with the (SET_GUID) of the BBP_PDATT table.
This will give you the attachments for the Shopping cart at item level.
It is really helpful..