SELF IMPROVEMENT

business partner tables sap crm To understand database tables in SAP better, we have to first understand SAP's architecture. Here is a small glimpse into SAP's 3-tier architecture.
When you log into SAP using the SAP GUI, this GUI can be called the UI layer. Tier - II: This is the Application Server Layer. This is the core of SAP. This comprises of the runtime environment of SAP. SAP has been built in a database agnostic way. There are a list of databases supported by SAP ( For example, Oracle, Informix, DB2, Max DB, SQL Server etc ) and as long as you use one of those databases in tier-III SAP will work. The task of DBIF is to ensure that it converts SAP's Open SQL into native SQL understandable by the corresponding database. sap business partner tables naw
Without going much further into SAP's architecture, let's start by creating a database table in SAP. Let's try to create a database table "Customer" as follows.
Database Table:
Database Table Name
ZCUST
Database Table Description
Customer
Database Table Fields
CUSTNO
SAP Namespace:
1. SAP reserves the right to create new programs starting with the letter 'A' through 'X'
2. SAP gives its customers the right to create new programs starting with either the letter 'Y' OR 'Z'
3. SAP gives its partners special names spaces.
Now, J&J wants to upgrade SAP to ECC 6.0. As part of the upgrade SAP overwrites a lot of ABAP Objects. Before creating the database table itself, we have to ensure that the fields and the corresponding data types and domains are created.
DOMAIN A domain describes the technical characteristics of the field. Field Length Data Type
DATA ELEMENT
The Data element contains the "Field Labels" and Online documentation for the field. Let's go ahead and start to create the database table. We will follow a Top-Down Approach to creating the database table. Step 1:
Goto ABAP Dictionary and enter the name "ZCUST" and click on CREATE button
Step 2:
Enter the Database table Description.
Step 3:
Customer data falls under the category of Master Data and hence we have chosen the delivery class of "A"
Choose "Display/Maintenance Allowed" in the data browser field.
Step 4:
Save the Database Table. We will add Data Elements after we create them. Step 5:
Create Domains: Enter the domain name - ZCUSTNO and click on Create.
Enter a Short Description. Similarly, create the ZCUSTNAME domain as CHAR (100 ). Follow SAP Training to know more about getting trained in SAP and ABAP.
Step 6:
Data Elements: Data Elements link the database table field to the domains. Let's start by creating data elements for CUSTNO and CUSTNAME fields.
Goto [SE11] and enter the data element name ZCUSTNO in the Data Type field and click on Create.
Choose "Data Element" in the pop-up.
Goto the Field Label tab and enter a description.
Activate the Data Element. Similarly create data element called ZCUSTNAME.
Step 7:
Add the data elements to the table that we have created in Step 4. Goto [SE11], enter the database table ZCUST in the field database table and click on Change. Step 8: Technical Settings
Since we are creating master data, select APPL0. If the database table is huge and lots of "READ" operations happen on the table, enable buffering.