How to create tables in SAP system-II

 Creation of Transaction data table with variable currencies and units of measure



Method: Top down approach

Structure:

PRID CHAR(4) key (Product ID)

PRQTY - QUAN (6) (Product Quantity)

UNITS - UNIT (3) (Units of measure)

H2BPRSALES - CURR (6) (H2B Product Sales)

H2BPROFIT - CURR (6) (H2B Profit)

CURRENCY - CUKY(5) (Currency key)

Procedure:

Step 1 Logon to SAP R/s ECC

Step 2 Create table

Enter tcode SE11

Select radio button 'Database table'. Give a table name 'ZH2BSALES'

Select 'Create'.

Give a description of the table -'How2BW Sales Transaction table'

Delivery class: 'A'

Data browser/Table view maintenance: Choose 'Display/Maintenance Allowed'

Select 'Save'

Give a  package and a TR

Step 2.1 Create table fields

Select 'Fields' tab

Give PRID as key field with initial value not allowed checked.

Give the data element as ZPRID_DE and double click on it.
Select 'Yes' and then select 'Continue'

Give a description of the data element. Select Domain radio button and give a domain name as 'ZPRID_DO'

Double click on the domain. Select 'yes'.

Give a description of the domain and give data type as 'CHAR' and length as 4. Activate the domain.

Activate the data element.

Similarly give other fields of the table, create and activate the data element and domains for them.

Field: PRQTY

Data element: ZPRQTY_DE

Domain: ZPRQTY_DO

For the domain, select data type as 'QUAN' and give number of characters as 6.

QUAN is quantity field, it points to a unit field with format UNIT

Activate the domain and the data element.

Field: Units

Data element: ZUNITS_DE
Domain: ZUNITS_DO

Choose 'UNIT' as the data type of the domain. Give number of characters as 3.

Activate the domain and the data element.

Field: H2BPRSALES

Data element: ZH2BPRSALES_DE

Domain: ZH2BPRSALES_DO

Select data type as 'CURR' stored as DEC. Give number of characters as 6.

Activate the domain and the data element.

Field: H2BPROFIT

Data element: ZH2BPROFIT_DE

Domain: ZH2BPRSALES_DO

Select fields label. Give medium description as 'Profit on sales'

Field: CURRENCY

Data element: ZCURRENCY_DE

Domain: ZCURRENCY_DO

Give data type of the domain as 'CUKY' and give number of characters as '5'.

Activate the domain and the data element.

Step 2.2 Maintain reference table and reference fields for the fields with data type QUAN and CURR

Select 'Currency/Quantity fields' tab

PRQTY: give reference table as 'ZH2BSALES' and reference field as 'UNITS'

H2BPRSALES: Reference table as 'ZH2BSALES' and reference field as 'CURRENCY'

PROFIT: Reference table as 'ZH2BSALES' and reference field as 'CURRENCY'

Select Save.

Step 2.3 Maintain technical settings

Select 'Technical Settings'

Data class: Select as 'APPL1' - Transaction data, transparent table

Size category: Choose '0'

Select 'Save'. Then press F3.

Check the table.

A warning is displayed saying that the 'Enhancement category for the table is missing'

Press F3.

Note: To resolve the warnings.

Go to the 'Extras' menu and select 'Enhancement Category'

Select the option 'Can be enhanced (Character type or numeric)'

Continue.

Save and check your table.

Message: 'No inconsistencies found'

Activate your table.

The table is now created along with the meta data.

Step 2.4 Enter data manually

Select 'Utilities' menu and select 'Create entries'

Give some sample entries and save them.

 

 

Comments

Post a Comment

Popular posts from this blog

Qlikview not able to fetch all data from Multiprovider

Image
 There is a scenario which I encountered recently in my project where Qlikview was not able to see complete data from the Multiprovider from SAP BW. The Multiprovider consisted of few standard DSOs with the setting : " SID generation during Activation " and " Set Quality Status to OK automatically " checkbox checked. Thus, even though all the settings are in place, the Qlik was not able to see all the data in the raw layer.
Read more

How to extract data using BI Content Datasource in SAP BW

 This video and post is about how to extract data from SAP ECC to BW system using Business content standard Datasources. The video outlines step by step approach on how to create the data model and schedule the delta loads in the BW system. https://www.youtube.com/watch?v=Iggsfa7_eho Aim Data extraction / Acquisition from SAP R/3 ECC (OLTP) to SAP Netweaver BI (OLAP) using Business Content Datasources Tcodes SBIW, RSA9, RSA5, RSA6, RSA3, RSA7, RSA1, RSA2, RSA13, RSA14, RSDS, RSD1, RSD5, RSDCUBE, RSORBCT, RSORMDR, SE11, SE16, RSPC, RSPC1, RSPCM, RSMO, RSMON, LISTCUBE... Part I - Data Modeling Step 1: Logon to SAP R/3 ECC Step 2 : Activate / transfer application component hierarchy (need to be performed once) (RSA9 or SBIW) Step 3: Install and activate the required Datasource
Read more

Using ABAP in combination with SAP HANA

Image
 A basic knowledge of open SQL is necessary to develop ABAP application in SAP HANA. ABAP programs can access SAP HANA database through available set of queries and operations that can be executed on existing data. This article will introduce you to classic ABAP programming and how it complements with Native HANA. Simple Database access via ABAP Open SQL Statement: DATA: wa TYPE scarr. SELECT-OPTIONS: carrier FOR wa-carrid. SELECT * FROM scarr INTO wa WHERE carrid IN carrier. WRITE: / wa-carrid. wa-carrname. ENDSELECT. This program will display Airline id and its name based on the user selection of Airline id. For example- LH           Lufthansa ABAP Schema The SAP Netweaver AS ABAP stores all data in exactly one specific schema within the database catalog. This schema is also referred to as system schema or ABAP schema. In traditional ABAP development, schema is irrelevant. For SAP HANA, schema is relevant because: When tables are ...
Read more