SAP ABAP Data Dic onary Assignment
Objec ve:
Create and manage SAP ABAP Data Dic onary objects for an order management system with one header table and one
item table. This assignment includes defining tables, domains, data elements, foreign key rela onships, table
maintenance generators, views, and search helps. Addi onally, handle currency and unit of measure for fields.
Assignment Details:
1. Create Database Tables
Scenario:
You are tasked with crea ng two tables for managing orders and their line items, including currency and unit of measure.
Tables to Create:
1. ZORDER_HEADER
o Fields:
MANDT (CHAR, Length: 3, Key, Not Null)
Client
ORDER_NO (CHAR, Length: 10, Key, Not Null)
Order Number
ORDER_DATE (DATE, Not Null)
Date of the Order
CUSTOMER_ID (CHAR, Length: 10, Not Null)
Customer ID
TOTAL_AMOUNT (CURR, Length: 15)
Total Order Amount
CURRENCY (CURR, Length: 5, Not Null)
Currency Code
CREATED_BY (CHAR, Length: 12)
User who created the order
CREATED_ON (DATE)
Date when the order was created
2. ZORDER_ITEM
o Fields:
MANDT (CHAR, Length: 3, Key, Not Null)
Client
ORDER_NO (CHAR, Length: 10, Key, Not Null)
Order Number (Foreign Key)
ITEM_NO (NUMC, Length: 5, Key, Not Null)
Line Item Number
PRODUCT_ID (CHAR, Length: 10, Not Null)
Product ID
Zafar.karnalkar@gmail.com
SAP ABAP Data Dic onary Assignment
QUANTITY (QUAN, Length: 5, Not Null)
Quan ty Ordered
UNIT_OF_MEASURE (UNIT, Length: 3, Not Null)
Unit of Measure
UNIT_PRICE (CURR, Length: 10)
Price per Unit
TOTAL_PRICE (CURR, Length: 15)
Total Price for the Line Item
CURRENCY (CURR, Length: 5, Not Null)
Currency Code
Steps:
1. Create the Domain:
o Create domains for CHAR, NUMC, DATE, CURR, and QUAN types.
2. Create Data Elements:
o Create data elements for each field using the domains you created.
3. Create Database Tables:
o Define the ZORDER_HEADER and ZORDER_ITEM tables using the data elements.
4. Define Foreign Key Rela onships:
o ZORDER_ITEM: Create a foreign key rela onship for ORDER_NO referencing ORDER_NO in
ZORDER_HEADER.
5. Create Table Maintenance Generator:
o Generate the maintenance view for ZORDER_HEADER and ZORDER_ITEM tables.
o Implement events for create, update, and delete opera ons.
6. Create Views:
o Z_ORDER_DETAILS_VIEW: A view combining ZORDER_HEADER and ZORDER_ITEM to show order details
along with line items.
7. Create Search Helps:
o SEARCH_HELP_ORDER: For searching orders by ORDER_NO and CUSTOMER_ID.
o SEARCH_HELP_PRODUCT: For searching products by PRODUCT_ID.
Zafar.karnalkar@gmail.com
