Documents and Attachments

[Former Member]

hi all,

I'm working on SRM 5.0. In the shopping cart application i want to add one more text filed under the tab "Documents and Attachments". How can i achieve it? In which table does this information get saved?

Best Regards,

B.Siddhesh

[Former Member · Accepted solution]

Hi,

Use function BBP_PD_SC_GETDETAIL,pass the Text ID's and table E_LONGTEXT gives you the values for all the texts entered for the SC.

The text ID's for the texts used in SC screen are:

ITXT (Vendor Text)

NOTE (Internal Note)

NOTM (Approval Note)

To add one more text filed under the tab "Documents and Attachments".,see the foll thread for the steps:

BR,

Disha.

Do reward points for useful answers.

[former_member183819 · Accepted solution]

Hi Siddhesh

I found the table . STXH - It is sap text file table.

You can find the text in TDTITLE field

tdid -pass value as either ITXT or REMB (vendor text) in the field TDID.

as well you can check this table too STXL.

BR

Muthuraman

Edited by: muthuraman on Jul 20, 2008 11:51 AM

Edited by: muthuraman on Jul 21, 2008 10:08 AM

[Former Member]

Hi Siddesh

I think you mean that you would want to add a new note text type in the notes and attachment area. If so then you can go to the IMG-> SAP Supplier Relationship Management->SRM Server->Cross-Application Basic Settings->Text Schema and define your text type and assign it to the text schema for the business object type.

I hope this helps

Regards

Sumat

[Former Member]

hi Sumat,

Thanks a lot. Thats what i wanted to do.

Could you please tell me in which database table the data in the "Vendor Text" gets stored? I tried searching in BBP_PD where it shows the data under "Longtexts" but could not figure out the database table where it is being stored.

Best Regards,

B.Siddhesh

[former_member183819]

Plz search in these tables VBDATA and BBPCONT

BR

Raman

Edited by: muthuraman on Jul 17, 2008 8:02 AM

[Former Member]

hi,

I checked both the tables VBDATA and BBPCONT but couldn't find the data. Any other table?

best regards,

B.Siddhesh

[former_member183819]

VBDATA - VBKEY field

BBPCONT -PHIO_ID field

This might be reference document for attachment/text right.You need to explore how this PHIO_ID generated.

add one vendor text /attach in sc before and after compare these tables. You might come to know.

BBP_PDATT -Check this table too

BR

Raman

Edited by: muthuraman on Jul 17, 2008 9:12 AM

Edited by: muthuraman on Jul 17, 2008 9:17 AM

[Former Member]

Hi Siddhesh

you could try using the Function module BBP_PROCDOC_GETDETAIL to read all the data for a document. The parameter E_LONGTEXT would return you the texts and using the parameter TDID you can filter the right text type.

Cheers

Sumat

[Former Member]

pl check note 458591 for custom fields

BADI BBP_SC_MODIFY_UI can be starting point

(not sure about the syntax as i am not having sys)

SPRO PATH SRM IMG --> SRM-> srm server -> BADI -> shopping cart -> change dispaly

BR

Dinesh