How to find Table names for PO & Invoices in SRM Standalnoe system SRM 7.0?

[Former Member]

Hi,

How to find Table names for PO & Invoices in SRM Standalnoe system SRM 7.0? Please let me know.

Thanks,

Monica

[former_member183819]

Hi

All SRM Business Object are stored in CRMD_ORDERADM_H AND CRMD_ORDERADM_I TABLES STORES ALL values

Object type as BUS2201 AND BUS2205

go to bbp_PD

clicj details . it takes you all related table.

br

Muthu

[Former Member]

Thanks for your Reply Muthu. My problem is this is new implementation. No data in the tables CRMD_ORDERADM_I and CRMD_ORDERADM_H. I am Writting Functional Specs for Pos and Invoices.I can see some test data in Portal UI, but its not moved to SRM GUI tables. Please advice.

Thanks,

Monica

[Former Member]

Hi Muthu,

I found some data in these tables. But When I try for BUS2201,BUS2121 and BUS2205 in BBP_PD, Its showing almost same table names for all of these Business objects ex: BBP_PDHGP and BBP_PDBEI. Are these are the table names I can use to get data for Invoices and I need to send Invoice data from SRM to legacy system. I am new to SRM. Please let me know.

I appreciate your help!

Thanks,

Monica

[Former Member]

Hi,

In SRM for all objects like SC ( BUS21210),BID,PO(BUS22010),Confirmation (BUS2203),invoice etc all the data stored

in BBP_PDHGP and BBP_PDBEI tables only, These is no separate tables..

for your reference below are the few SRM tables

BBP_PDACC Account Assignment

BBP_PDATT Document Attachment

BBP_PDBEH Backend Specific Header Data

BBP_PDBEI Backend Specific Item Data

BBP_PDBGP Partner Extension Gen. Purchasing Data

BBP_PDBINREL Transaction Object Linkage (EBP)

BBP_PDHCF Set for Tabular Customer and Solution Fields on Hdr

BBP_PDHGP Business Transaction Purchasing Information

BBP_PDHSB Bid Invitation

BBP_PDHSC Header Extension for Customer Fields

BBP_PDHSS Hdr Extension for SAP Internal Enhancements (IBUs and so on)

BBP_PDICF Set for Tabluar Customer and Solution Fields on Itm

BBP_PDIGP Business Transaction Item-Purchasing Information

BBP_PDISB Bid Invitation/Bid-Specific Item Data

BBP_PDISC Item Extension for Customer Fields

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

BBP_PDLIM Value Limit

BBP_PDORG Purchasing Organizational Unit

BBP_PDPSET Further Procurement Information

BBP_PDTAX Tax

CDCLS Cluster structure for change documents

CDHDR Change document header

CDPOS_STR Additional Change Document - Table for STRINGs

CDPOS_UID Additional Table for Inclusion of TABKEY>70 Characters

CRM_JCDO Change Documents for Status Object (Table JSTO)

CRM_JCDS Change Documents for System/User Statuses (Table JEST)

CRM_JEST Individual Object Status

CRM_JSTO Status Object Information

CRMD_LINK Transaction - Set - Link

CRMD_ORDERADM_H Business Transaction

CRMD_ORDERADM_I Business Transaction Item

CRMD_PARTNER Partners

SROBLROLB Persistent Roles of BOR Objects

SROBLROLC Persistent Roles of Business Classes

SRRELROLES Object Relationship Service: Roles

Thanks & Regards,

Prasad S