Skip to end of metadata
Go to start of metadata

Groups:


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

Administration: user, organizational assingment etc.

BUT000

Table for all kind of partners in SRM (Bidders, Vendors, contact 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

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 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_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

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       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 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_ORDERADM_HBusiness Transaction
CRMD_ORDERADM_IBusiness 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

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 administration 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

  1. Guest

    Good stuff venkat. It helps every one.

    Muthu

  2. Guest

    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)