Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Purpose

This page was created the collect the main SRM tables.

Overview

The main SRM tables and their relations can be found in the figure below:

 

Identifying the database tables

To find the relevant table of an SRM Business Object quickly, display the document in transaction BBP_PD, which will give all tables related to that business object. Also you can click those table names to jump directly to the database record you are looking at.

Common SRM tables

Product category

TableDescription

COMM_PRODUCT

Product table

COMM_CATEGORY

Product category table

ROST_SEL_PRODCAT

Product Categories for Registration

Administration: Business Partner, User, Organizational assignment etc.

TableDescription

BUT000

BP: General data I

BUT001BP: General data II
BUT020BP: Addresses
BUT021BP: Address usages
BUT021_FSTime-Dependent Address Usages
BUT100BP: Roles

VENMAP

Vendors replicated from ERP backend using BBPGETVD Transaction.

Address

TableDescription

ADR10

Printer (Business Address Services)

ADR11

SSF (Business Address Services)

ADR12

FTP and URL (Business Address Services)

ADR13

Pager (Business Address Services)

ADR2

Telephone Numbers (Business Address Services)

ADR3

Fax Numbers (Business Address Services)

ADR4

Teletex Numbers (Business Address Services)

ADR5

Telex Numbers (Business Address Services)

ADR6

E-Mail Addresses (Business Address Services)

ADR7

Remote Mail Addresses (SAP - SAP - Communication; BAS)

ADR8

X. 400 Numbers (Business Address Services)

ADR9

RFC Destinations (Business Address Services)

ADRCOMC

Comm. Data Serial Number Counter (Business Address Services)

ADRCT

Address Texts (Business Address Services)

ADRG

Assignment of Addresses to Other Address Groups (BAS)

ADRGP

Assignment of Persons to Further Person Groups (BAS)

ADRT

Communication Data Text (Business Address Services)

ADRU

Table for Communication Usages

ADRV

Address Where-Used List (Business Address Services)

ADRVP

Person Where-Used List (Business Address Services)

BBP*

TableDescription

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_PDCON

Purchase Order Item Confirmation

BBP_PDHAD_V

Business Transaction Versions

BBP_PDHCF

Set for Tabular Customer and Solution Fields on Hdr

BBP_PDHGP

Business Transaction Purchasing Information

BBP_PDHSC

Header Extension for Customer Fields

BBP_PDHSS

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

BBP_PDIAD_V

Business transaction item

BBP_PDICF

Set for Tabular Customer and Solution Fields on Itm

BBP_PDIGP

Business Transaction Item-Purchasing Information

BBP_PDISC

Item Extension for Customer Fields

BBP_PDISS

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

BBP_PDLIM

Value Limit

BBP_PDLINK_V

Transaction - Set - Link

BBP_PDORG

Purchasing Organizational Unit

BBP_PDPSET

Further Procurement Information

BBP_PDTAX

Tax

BBP_PDTOL

Tolerances

BBP_LOCMAP

For location details

C* tables: change documents, linking, etc.

TableDescription

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

CRMD_LINK

Transaction - Set - Link

CRMD_ORDERADM_H

Business Transaction

CRMD_ORDERADM_I

Business Transaction Item

CRMD_PARTNER

Partners

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

SRRELROLES

Object Relationship Service: Roles

STXB

SAPscript: Texts in non-SAPscript format

STXH

STXD SAPscript text file header

STXL

STXD SAPscript text file lines

TOA01Link table 1
TOA02Link table 2
TOA03Link table 3

Survey

TableDescription

ROST_LANG_QSTN

Language Selection for Question

ROST_PCAT_QSTN

Assign Product Category and Questionnaire to Languages

ROST_SEL_PRODCAT

Product Categories for Regis

ROST_WS_QSTN

Web Survey Questionnaire

ROS_BP_PC_SURVEY

Assign Vendor, Product Category, Survey

CRMD_IC_SCRATTR

Script/Survey attributes (Interactive Script Editor)

ROST_WS_QSTN

Web Survey Questionnaire

ROS_BP_PC_SURVEY

Assign Vendor, Product Category, Survey

TUWS_SURVEY

Survey

TUWS_SURVEY_LOG

Survey Log

TUWS_SURVEY_PUB

Survey Publishing

TUWS_TAROBJ

Survey: Recipients

TUWS_TAROBJ_ATTR

Survey: Recipient Attributes

6 Comments

  1. Guest

    Good stuff venkat. It helps every one.

    Muthu

  2. Very usefull !!! 

    Stephane

  3. Thanks Venkat.. its really useful.

  4. Guest

    This overview just helped me a lot. Thanks!

  5. tks,it's very usefuly for me!

  6. Thanks a lot.. very useful (smile)