What are the Table Names

[Former Member]

Hi All,

What are the table names which Stores the Shopping Cart Data i.e Cart No., created by, approved by, line item details.

What are the table names which Stores the Shopping Cart approver name.

What are the table names which Stores the Confirmation data i.e document no. , name of the approver of the confirmation, line item details.

Please also mention the common used table names in SRM EBP.

Thanks in advance.

Regards

Sridhar

[Former Member]

Thanks

Dinesh

[Former Member]

Hi,

Tables CRMD_ORDERADM_H and CRMD_ORDERADM_I store the header and item data respectively for all your object types i.e. Shopping cart,Invoice etc...In addition to that,you have some useful FM 's for the tasks mantioned by you.

To get the SC details -->BBP_PD_SC_GETDETAIL.

To get the SC approver-->BBP_PDH_WFL_APPROVER_GET

The most commonly used tables in SRM can be seen in tcode BBP_PD.

Here based on the Object Type(e.g. For SC ,object type is BUS2121),you get to see all the tables which store SC related data.

Generally,use Std FM (if available) to retrieve the Data instead of quering the tables.

HTH.

BR,

Disha.

Pls reward full points for useful answers.

[Former Member]

Hi Sridhar,

pl. explore the golden txn. BBP_PD in SRM.

Just Run the txn. choose yr object type i.e. for SC choose BUS2121

for confn. pl. chk out(i don't have sys)

put any sample SC or confn no

execute

it will give you that BUS object details

Doubleclick to open all details

on the relevant field just double click to get the respective table name

e.g. SC data click on SC no.

For ready ref following are some tables

PO no in the tables BBP_PDBEH/BBP_PDBEI from the SC guid

Tables updated related to Shopping Cart

Srno Tables Description H/I

1 CRMD_ORDERADM_H Header Table of the Shopping Cart H

2 BBP_PDHGP Business Transaction Purchasing Informatio H

3 BBP_PDHSB Bid Invitation H

4 BBP_PDBEH Backend Specific Header Data

6 BBP_PDPSET Further Procurement Information

7 BBP_PDHSC Header Extension for Customer Fields H

8 BBP_PDHSS Hdr Extension for SAP Internal Enhancement H

9 CRMD_ORDERADM_I Business Transaction Item I

10 BBP_PDIGP Business transaction item-Purchasing infor I

11 BBP_PDBEI Backend Specific Item Data I

12 BBP_PDISB Bid Invitation/Bid-Specific Item Data I

13 BBP_PDISC Item Extension for Customer Fields I

14 BBP_PDISS Item Ext. for SAP Internal Enhancements (IBUs and so on) I

15 CRM_JEST Individual Object Status

16 CRMD_PARTNER Partners

17 BBP_PDBGP Partner Extension Gen. Purchasing Data

18 BUT000 BP: General data I

19 ADDR3_DATA Address data

20 BBP_PDORG Purchasing Organizational Unit

21 BAPIEKKOL BAPI -s inofrmation H/I

22 BAPIEKPO_ECI BAPI -s inofrmation H/I

23 BBP_BAPIEKKN BAPI -s inofrmation H/I

24 BAPIEBAN BAPI -s inofrmation H/I

25 BAPIEBKN BAPI -s inofrmation

26 BBP_PDACC Account Assignment

27 BBP_PDATT Document Attachment

Additional Tables

28 BBP_CATEGORY_FAV User-Specific Favorites for Product Categories

29 STXH STXD SAPscript text file header

30 BBP_PDVIEW_IAP Item Data: General Purchasing and Purchasing Set

31 BBPC_PARTNERFUNC Definition of Partner Functions

32 HRP1001 Infotype 1001 DB Table

33 TSAD3T Titles (Texts) (Business Address Services)

34 comm_applcatgrpr Application Area of a Hierarchy

35 BBP_FUNCTION_MAP Function Map for BAPI Dispatcher

36 SWOTIP Index Parent Object Types

37 HRSOBJECT Index for Standard Objects

38 usr02 Logon Data (Kernel-Side Use)

39 usrefus Reference user for internet applications

40 spers_obj Personalization object repository

41 hrv1222a View of Attributes

42 bbpc_partnfunc_t Description of Partner Functions

43 CRM_JSTO Status Object Information

44 crmc_but_call_fu Determining FMs for Data Exchange BP

45 bbpc_actionmap Assign Method Actions

46 but000 BP: General data I

Pl. note I have not checked these all tables myself, you can explore.

BR

Dinesh

<b>Reward if helps</b>