Skip to Content
avatar image
Former Member

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

Hi,

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

Thanks,

Monica

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 08, 2010 at 10:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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