Show TOC

 Adding a New Table

Purpose

Using the Easy Enhancement Workbench (EEW) you can add new tables to the data model of the Business Partner and the Business Partner relationships.

For the Business Partner the fields Client and Business Partner are used as key fields of the new table. For the BP relationships, the relevant fields are Client, Relationship Type, Business Partners (for Partner 1 and Partner 2) and Valid To.

The following functions are supported:

Integration of the new tables into the SAP GUI.

Extension of the external interface of the Business Partner BUS_EI_MAIN and of the Business Partner Relationship BURS_EI_MAIN

Inclusion and update in DataSources for the Business Partner for the SAP Business Information Warehouse (SAP BW)

The system generates all the necessary objects and table entries for this function, as far as technically possible.

Process

Use the business object Business Partner (BUPA) or Business Partner relationships (BUPR), and create an extension of the type “add new attribute table” in order to add new tables to the Business Partner or to the BP relationships. A wizard helps you to define the new table and its fields and provides you with the necessary information for every step.

Define the Cardinality and Time Dependency for an extension of a business partner or a business partner relationship:

In case of a business partner, the cardinality of an extension can be of the type:

Single Instance , that is, has one record for a business partner. These extensions are always time dependent. You can, however, select the time dependency to be either With Gaps or No Gaps .

Multiple Instance , that is, has more than one record for a business partner. These extensions can be time dependent or time independent. If you select the extension to be time dependent, you also have to select the time dependency from the following options: With Gaps No Gaps or Time Validity

In case of a business partner relationship, the Cardinality of an extension can be of the type:

Single Instance , that is, has one record for a business partner relationship. The extension inherits the time dependency of the parent relationship.

Multiple Instance , that is, has more than one record for a business partner relationship. These extensions are always time dependent. You can, however, select the time dependency to be either With Gaps or No Gaps . The validity period of the extension can be only within the validity period of the parent.

Enter a Frame Title for your extension.

You can define the field in a Default Mode or an Expert Mode .

In the Default Mode , for each field of the new table, define the field description (visible on the screen), the data type and, if necessary, the field length and decimal length for each field.

For Amount and Quantity fields, field length and decimal length are predefined. The Quantity field has length 17 and decimal length 3 and the Amount field has length 17 and decimal length 2.

For Amount and Quantity fields, the Currency and Unit fields are automatically generated by the system.

In the Expert Mode , besides the above, you can also enter a Field Name (technical field name in the database table) and link an existing data element to the field. The system automatically assigns the characteristics of the data element to the field. The medium field label of the data element is assigned as the Field Label for the field.

Define a field in the Expert Mode only if you have experience in Data Dictionary and ABAP.

For multiple instance extension, the system automatically accepts the first field that you enter as the key field. The key field cannot be of the type Quantity , Amount or Decimal

For each field, define whether a check table should exist.

You also define for each field for the Business Partner whether it should be passed on to SAP BW.

In the last screen of the wizard the system shows you an overview of the tables that you defined along with the relevant fields and their attributes.

Choose Complete start the generation of the necessary repository objects and table entries.

Technical Realization

In the object overview, which is made available for each task in the EEW, you can find a detailed overview of all the objects created. There you can also find the technical names of the objects created, which you may need for follow-up activities.

Integration with the Business Partner Dialog

The Easy Enhancement Workbench creates the following repository objects and table entries:

A data element and a domain for each field

The fields Client and Partner in table BUT000, or the above-mentioned fields in table BUT050 for the relationships are transferred as key fields to the new table.

The necessary API and dynpro structures for each extension

Check tables and the relevant maintenance views for the selected fields, if necessary. The maintenance views make it possible to fill the check tables with values during subsequent processing.

A structure for each extension

A change document object for each extension

For each extension, function groups for Change Document, Mass Update, Archiving, Data Dictionary, API, BDT and Data Exchange

In each case a function module for the process events of the dynpro PBO, PAI and PBC for every extension

Function modules for the BDT events DLVE1, DLVE2, DCHK, CHGD1, CHGD4, DSAVC, DSAVE, DTAKE, FCODE, ISDAT, ISSTA and XCHNG. In addition, for Business Partner Relationship, function modules for BDT events CHGD3, RTAKE, RDELM and RPRDR are also created.

Function modules for data processing (APIs for reading, creating, changing and deleting data)

The necessary dynpro (table control) that is needed to display the table in the dialog of the SAP GUI.

Depending on the situation, a new tab page (BDT screen) in the SAP GUI

Integration with SAP BW

A new DataSource for the Business Partner is generated for each table.

Integration with External Data Transfer

The Easy Enhancement Workbench creates the following repository objects and table entries:

A new structure for the extension in the structure BUS_DI

Function module for the BDT event DINP2

Follow-Up Activities

Depending on the extensions defined in the EEW you have to carry out the following activities later.

Integration with the Business Partner Dialog

If check tables for fields have been generated, then you must fill them with values out of the EEW by means of the relevant maintenance views.

You must create a function module manually in order to define user-defined checks for the new fields in the dialog. See the BDT manual, section 4.1 “Additional Check for Existing View” for more information.

You can adapt the generated BDT views and BDT sections in the SAP GUI to your specific requirements using the Visual Configuration Tool (VCT). You should carry out this adaptation only after all the extensions have been completed.

The generated BDT view must be assigned to the required relationship categories for the BP relationships.

Integration with SAP BW

For data exchange with SAP BW you must manually define data targets (metadata) and transfer rules for the newly generated DataSource for the Business Partner.

Result

You have defined the new tables and fields, and the system has generated the necessary repository objects and table entries. The extension is not valid across different systems, which means that follow-up actions may be necessary.