Srm Tables- Relationship 5u2t6m

SRM Tables Groups: Quick hint: Product category istration: , organizational assingment etc. Address BBP* C* tables: change documents, linkking, etc. Survey

Quick hint: Check transaction code BBP_PD and enter the business object which will give all tables related to that business object. This will have a lot of table names and how they are connected to each other. Also you can click on those table names to jump directly to the item you are looking at.

Product category COMM_PRODUCT

Product table

COMM_CATEGORY

Product category table

ROST_SEL_PRODCAT

Product Categories for Registration

istration: , organizational assingment etc. BUT000

Table for all kind of partners in SRM (Bidders, Vendors, persons, suppliers, goods recipients, etc..)

VENMAP

Vendors replicated from R/3 backend using BBPGETVD Transaction.

Address 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* BBP_PDACC

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 Tabluar 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, linkking, etc. 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_ORDER_H

Business Transaction

CRMD_ORDER_I

Business Transaction Item

CRMD_PARTNER

Partners

CRM_JCDO

Change Documents for Status Object (Table JSTO)

CRM_JCDS

Change Documents for System/ 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

Survey ROST_LANG_QSTN

Language Selection for Question

ROST_PCAT_QSTN

Assign Product Category and Questionnaire to Lan

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

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_PDACC 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 Tabluar 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 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_ORDER_HBusiness Transaction CRMD_ORDER_IBusiness Transaction Item CRMD_PARTNER Partners CRM_JCDO Change Documents for Status Object (Table JSTO)

CRM_JCDS Change Documents for System/ Statuses (Table JEST) CRM_JEST Individual Object Status CRM_JSTO Status Object Information SROBLROLB Persistent Roles of BOR Objects SROBLROLC Persistent Roles of Business Classes SRRELROLES Object Relationship Service: Roles STXB SAPscript: Texts in non-SAPscript format STXH STXD SAPscript text file header STXL STXD SAPscript text file lines TOA01 Link table 1 TOA02 Link table 2 TOA03 Link table 3 TOAHR Container table for HR istration level Check transaction code BBP_PD and enter the business object which will give all tables related to that business object This will have a lot of table names and how they are connected to each other. Also you can click on those table names to jump directly to the item you are looking at. The function modules for different business objects are : BBP_PD_SC_GETDETAIL - Shopping Cart BBP_PD_PO_GETDETAIL - Purchase Order BBP_PD_CONF_GETDETAIL - SRM Confirmations BBP_PD_INV_GETDETAIL - Invoice and Credit Memo