Data Dictionary Activities

Disclaimer: This document is a draft, and provided as a reference. This document is not to be considered
final, and all information contained herein is subject to change. As such, this document is not to be
quoted, cited in any reference, or used by anyone for any purpose other than as a draft document

General Note:

Create below objects in the same order as mentioned in the document. Extend the tables and
structures listed in the document
____________________________________________________________________________________

Contents
Create Domain ........................................................................................................................................ 2
J_1IG_NUMGR..................................................................................................................................... 2
J_1IG_ODN_NUM ................................................................................................................................ 2
Create Data Element ............................................................................................................................... 2
J_1IG_NUMGR..................................................................................................................................... 2
Create Table Type.................................................................................................................................... 3
J_1IG_TT_VBRP ................................................................................................................................... 3
Create Function Groups ........................................................................................................................... 3
J_1IG_ODN .......................................................................................................................................... 3
J_1IG_VIEW_ODN................................................................................................................................ 3
Create Database tables............................................................................................................................ 3
J_1IG_T003_I ....................................................................................................................................... 3
J_1IG_NUMGRP................................................................................................................................... 6
J_1IG_NUMGRPT ................................................................................................................................. 7
J_1IG_OFNUM ................................................................................................................................... 10
Create Views ......................................................................................................................................... 14
J_1IG_V_T003_I ................................................................................................................................. 14
J_1IG_V_NUMGRP............................................................................................................................. 14
J_1IG_V_OFNUM ............................................................................................................................... 16
Change Domain ..................................................................................................................................... 17
Disclaimer ............................................................................................................................................. 18

1|Page
Create Domain
J_1IG_NUMGR
1. Execute the transaction code SE11.
2. Click on the radio button ‘Domain’.
3. Enter the following domain name - J_1IG_NUMGR.
4. Click on Create button.
5. Enter short description as ‘Numbering Group for Official Documents’.
6. Click on Definition tab, enter Date type as ‘CHAR’, No. of places as ‘6’, Decimal Places as ‘0’ and
Output Length as ‘6’.
7. Save the domain it in package ‘J1I_GST_LO’ and activate.

J_1IG_ODN_NUM
1. Execute the transaction code SE11.
2. Click on the radio button ‘Domain’.
3. Enter the following domain name - J_1IG_ODN_NUM.
4. Click on Create button.
5. Enter short description as ‘Official Document Number’.
6. Click on Definition tab, enter Date type as ‘NUMC’, No. of places as ‘10’, Decimal Places as ‘0’
and Output Length as ‘10’.
7. Save the domain it in package ‘J1I_GST_LO’ and activate.

Create Data Element

J_1IG_NUMGR
1. Execute the transaction code SE11.
2. Click on the radio button ‘Data type’.
3. Enter the following data element name - J_1IG_NUMGR.
4. Click on Create button.
5. Select ‘Data Element’ radio button.
6. Enter short description as ‘Number Group for Official Documents’.
7. Click on Data Type tab, enter Domain as ‘J_1IG_NUMGR’
8. Provide the following field labels

Short 10 Number gp
Medium 15 Number group
Long 20 Number group
Heading 6 No. gp
9. Save the data element within the package “J1I_GST_LO” and activate.

2|Page
Create Table Type
J_1IG_TT_VBRP
1. Execute the transaction code SE11.
2. Click on the radio button ‘Data type’.
3. Enter the following name - J_1IG_TT_VBRP.
4. Click on Create button.
5. Select ‘Table Type’ radio button and continue.
6. Enter short description as ‘Table Type for VBRP structure’.
7. Click on Row Type/Line Type tab, enter Row type/Line Type as ‘VBRPB’.
8. Save the table within the package “J1I_GST_LO” and activate it.

Create Function Groups

J_1IG_ODN
1. Execute the transaction SE80
2. Select the ‘Function Group’ from drop down box.
3. Provide the name as ‘J_1IG_ODN’ and press enter. System would prompt for creation, select
“Yes”.
4. Provide the short text as ‘Official Document Numbering Group’.
5. Save it under the package ‘J1I_GST_LO’ and activate the main program along with its include
programs.

J_1IG_VIEW_ODN
1. Execute the transaction SE80
2. Select the ‘Function Group’ from drop down box.
3. Provide the name as ‘J_1IG_VIEW_ODN’ and press enter. System would prompt for creation,
select “Yes”.
4. Enter the short text as ‘Extended Table Maintenance (Generated)’.
5. Save it under the package ‘J1I_GST_LO’ and activate the main program along with its include
programs.

Create Database tables

J_1IG_T003_I
1. Execute the transaction code SE11.
2. Click on the radio button ‘Database table’.
3. Enter the following table name – J_1IG_T003_I.
4. Click on Create button.
5. Enter short description as ‘Document Types’.
6. Click on ‘Delivery and Maintenance’ tab, select Delivery class as ‘C’ and select Data
Browser/Table View Editing as ‘Display/Maintenance Allowed with Restrictions’.

3|Page
7. Add the following fields in the fields tab.
Field Key Initial Data element Data Length Decimal
Values Type
MANDT YES YES MANDT CLNT 3 0
FKART YES YES FKART CHAR 4 0
BLART YES YES BLART CHAR 2 0
DOCCLS DOCCLS CHAR 3 0
XFORCE J_1AFORCENUM CHAR 1 0
OFFNREL J_1AOFFNREL CHAR 1 0

8. Click on ‘Entry Help/Check’ tab and Select the ‘MANDT’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

b. Click on copy button.

9. Click on ‘Entry Help/Check’ tab and Select the ‘FKART’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

4|Page
 b. Click on copy button.
10. Click on ‘Entry Help/Check’ tab and Select the ‘BLART’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

b. Click on copy button.

11. Click on ‘Entry Help/Check’ tab and Select the ‘DOCCLS’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

5|Page
 b. click on copy button.

12. In the menu, go to Extras->Enhancement Category. Select the radio button ‘Can be enhanced
(character-type or numeric)’.
13. Save the table with in the package ‘J1I_GST_LO’.
14. In the menu, go to Goto->Technical Settings. Select Data Class as ‘APPL2’ and Size category as
‘0’. select the radio button ‘Buffering switched on’ and check the ‘Fully buffered’ check box in
Buffering Type block and enter Number of Key Fields as ‘0’. Select the ‘Log data changes’ check
box.
15. Save and activate.

J_1IG_NUMGRP

1. Execute the transaction code SE11.

2. Click on the radio button ‘Database table’.
3. Enter the following table name – J_1IG_NUMGRP.
4. Click on Create button.
5. Enter short description as ‘Numbering Group for Official Documents’.
6. Click on ‘Delivery and Maintenance’ tab, select Delivery class as ‘C’ and Data Browser/Table
View Editing as ‘Display/Maintenance Allowed with Restrictions’.
7. Add the following fields in the fields tab.

Field Key Initial Data element Data Length Decimal

Values Type
MANDT YES YES MANDT CLNT 3 0

6|Page
 NUMGR YES YES J_1IG_NUMGR CHAR 6 0

8. Click on ‘Entry Help/Check’ tab and Select the ‘MANDT’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

b. Click on copy button.

16. In the menu, go to Extras->Enhancement Category. Select the radio button ‘Can be enhanced
(character-type or numeric)’.
17. Save the table with in the package ‘J1I_GST_LO’.
18. In the menu, go to Goto->Technical Settings. Select Data Class as ‘APPL2’, Size category as ‘0’.
select the radio button ‘Buffering switched on’ and check the ‘Fully buffered’ check box in
Buffering Type block and enter Number of Key Fields as ‘0’. Select the ‘Log data changes’ check
box.
9. Save and Activate the table.

J_1IG_NUMGRPT

1. Execute the transaction code SE11.

2. Click on the radio button ‘Database table’.
3. Enter the following table name – J_1IG_NUMGRPT.
4. Click on Create button.
5. Enter short description as ‘Texts for Numbering Group for Official Documents’.
6. Click on ‘Delivery and Maintenance’ tab, select Delivery class as ‘C’ and select Data
Browser/Table View Editing as ‘Display/Maintenance Allowed with Restrictions’.

7|Page
7. Add the following fields in the fields tab.

Field Key Initial Data element Data Length Decimal

Values Type
MANDT YES YES MANDT CLNT 3 0
SPRAS YES YES SPRAS LANG 1 0
NUMGR YES YES J_1IG_NUMGR CHAR 6 0
TEXT30 TEXT30 CHAR 30 0

8. Click on ‘Entry Help/Check’ tab and Select the ‘MANDT’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

c. Click on copy button.

9. Click on ‘Entry Help/Check’ tab and Select the ‘SPRAS’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

8|Page
 b. Click on copy button.
10. Click on ‘Entry Help/Check’ tab and Select the ‘J_1IG_NUMGR’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

b. Click on copy button.

11. In the menu, go to Extras->Enhancement Category. Select the radio button ‘Can be enhanced
(character-type or numeric)’.
12. Save the table with in the package ‘J1I_GST_LO’.

9|Page
 19. In the menu, go to Goto->Technical Settings. Select Data Class as ‘APPL2’, Size category as ‘0’.
select the radio button ‘Buffering switched on’ and check the ‘Fully buffered’ check box in
Buffering Type block and enter Number of Key Fields as ‘0’. Select the ‘Log data changes’ check
box.
13. Save and activate the table.

J_1IG_OFNUM

1. Execute the transaction code SE11.

2. Click on the radio button ‘Database table’.
3. Enter the following table name – J_1IG_OFNUM.
4. Click on Create button.
5. Enter short description as ‘Texts for Numbering Group for Official Documents’.
6. Click on ‘Delivery and Maintenance’ tab, select Delivery class as ‘C’ and Data Browser/Table
View Editing as ‘Display/Maintenance Allowed with Restrictions’.
7. Add the following fields in the fields tab.

Field Key Initial Data element Data Length Decimal

Values Type
MANDT YES YES MANDT CLNT 3 0
BUKRS YES YES BUKRS CHAR 4 0
BUPLA YES YES BUPLA CHAR 4 0
DOCCLASS YES YES DOCCLS CHAR 3 0
VALIDFROM YES YES DATE_FROM DATS 8 0
VALIDTO YES YES DATE_TCURE DATS 8 0
PREFIXCODE YES YES PREFIXCODE CHAR 2 0
SUBOBJECT YES YES J_1IG_NUMGR CHAR 6 0
GROUPNUMBER YES YES NRNR CHAR 2 0
LASTDATE J_1ADATETO DATS 8 0

8. Click on ‘Entry Help/Check’ tab and Select the ‘MANDT’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

10 | P a g e
 b. Click on copy button.
9. Click on ‘Entry Help/Check’ tab and Select the ‘BUKRS’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

b. Click on copy button.

10. Click on ‘Entry Help/Check’ tab and Select the ‘BUPLA’ field row and click on foreign key
button.

11 | P a g e
 a. Maintain the Foreign key relationship like below.

b. Click on copy button.

11. Click on ‘Entry Help/Check’ tab and Select the ‘DOCCLS’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

b. Click on copy button.

12. Click on ‘Entry Help/Check’ tab and Select the ‘J_1IG_NUMGR’ field row and click on foreign key
button.

12 | P a g e
 a. Maintain the Foreign key relationship like below.

b. Click on copy button.

13. Click on ‘Entry Help/Check’ tab and Select the ‘NRNR’ field row and click on foreign key
button.
a. Maintain the Foreign key relationship like below.

b. Click on copy button.

14. In the menu, go to Extras->Enhancement Category. Select the radio button ‘Can be enhanced
(character-type or numeric)’.
15. Save the table with in the package ‘J1I_GST_LO’.

13 | P a g e
 20. In the menu, go to Goto->Technical Settings. Select Data Class as ‘APPL2’, Size category as ‘0’.
select the radio button ‘Buffering switched on’ and check the ‘Fully buffered’ check box in
Buffering Type block and enter Number of Key Fields as ‘0’. Select the ‘Log data changes’ check
box.
16. Check and activate the table.

Create Views
J_1IG_V_T003_I
1. Execute the transaction code SE11.
2. Click on the radio button ‘View’.
3. Enter the following view name – J_1IG_V_T003_I.
4. Click on Create button.
5. Select the ‘Maintenance View’ radio button and click on ‘Copy’ button.
6. Enter short description as ‘Assign Document Types to Document Classes’.
7. Click on Table/Join Conditions tab, enter table name as ‘J_1IG_T003_I’.
8. Click on View Fields tab, click on ‘Table fields’ button and select the fields MANDT, FKART,
BLART, DOCCLS, XFORCE and OFFNREL then click on copy button.
9. Click on ‘Maint.status’ tab, select the radio button ‘read, change, delete and insert’. Select
Delivery class as ‘C’ and select Data Browser/Table View Editing as ‘Display/Maintenance
Allowed’.
10. Save the view in ‘J1I_GST_LO’ package and activate it.
11. Navigate on Menu bar. UtilitiesTable Maintenance Generator
12. Enter authorization group as ‘&NC&’, function group as ‘J_1IG_VIEW_ODN’, choose
Maintenance Step as “two step” and click on Find Screen Number(s). Choose Propose Screen
number(s). Click on enter and then click on Create button on application tool bar.
13. Save the maintenance screen.
14. Go back to previous screen and save.

J_1IG_V_NUMGRP

1. Go to t-code SE11.
2. Click on the radio button ‘View’.
3. Enter the following view name – J_1IG_V_NUMGRP.
4. Click on Create button.
5. Select the Maintenance View radio button and click on copy button.
6. Enter short description as ‘Number Groups for Official Document Numbering’.
7. Click on Table/Join Conditions tab, enter table name as ‘J_1IG_NUMGRP’.
8. Click on Relationships button, select table J_1IG_NUMGRP like below then click on copy button.

14 | P a g e
9. Click on View Fields tab, click on ‘Table fields’ button and system would prompt a popup select
J_1IG_NUMGRP table name then select fields MANDT and NUMGR then click on copy button.

10. Click on View Fields tab, click on ‘Table fields’ button and system would prompt popup select
J_1IG_NUMGRPT table name then select field TEXT30 then click on copy button.

15 | P a g e
 11. Click on ‘Maint.status’ tab, select the radio button ‘read, change, delete and insert’. Select
Delivery class as ‘C’ and select Data Browser/Table View Editing as ‘Display/Maintenance
Allowed’.
12. Save the view in ‘J1I_GST_LO’ package and activate it.
13. Navigate on Menu bar. UtilitiesTable Maintenance Generator
14. Enter authorization group as ‘&NC&’, function group as ‘J_1IG_VIEW_ODN’, choose
Maintenance Step as “one step” and click on Find Screen Number(s). Choose Propose Screen
number(s). Click on enter and then click on Create button on application tool bar.
15. Save the maintenance screen.
16. Go back to previous screen and save.

J_1IG_V_OFNUM

1. Go to t-code SE11.
2. Click on the radio button ‘View’.
3. Enter the following view name – J_1IG_V_OFNUM.
4. Click on Create button.
5. Select the ‘Maintenance View’ radio button and click on copy button.
6. Enter short description as ‘Assign Number Ranges to Business Places’.
7. Click on Table/Join Conditions tab, enter table name as ‘J_1IG_OFNUM’.
8. Click on View Fields tab, click on Table fields button and select the fields MANDT, BUKRS, BUPLA,
DOCCLASS, VALIDFROM, VALIDTO, PREFIXCODE, SUBOBJECT and GROUPNUMBER then click on
copy button.

16 | P a g e
 9. Click on ‘Maint.status’ tab, select the radio button ‘read, change, delete and insert’. Select
Delivery class as ‘C’ and select Data Browser/Table View Editing as ‘Display/Maintenance
Allowed’.
10. Save the view in ‘J1I_GST_LO’ package and activate it.
11. Navigate on Menu bar. UtilitiesTable Maintenance Generator
12. Enter authorization group as ‘&NC&’, function group as ‘J_1IG_VIEW_ODN’, choose
Maintenance Step as “one step” and click on Find Screen Number(s). Choose Propose Screen
number(s). Click on enter and then click on Create button on application tool bar.
13. Save the maintenance screen.
14. Go back to previous screen and save.

Change Domain
1. Execute SE11 and select the radio button for Domain.
2. Provide the domain as ‘J_1IG_NUMGR’ and select ‘Change’.
3. In the Value Range tab, provide the value table ‘J_1IG_NUMGRP‘.
4. Save and activate it.

17 | P a g e
Disclaimer
Disclaimer: © 2016 SAP SE or an SAP affiliate company. All rights reserved.i

No part of this publication may be reproduced or transmitted in any form or for any purpose without
the express permission of SAP SE or an SAP affiliate company.
SAP and other SAP products and services mentioned herein as well as their respective logos are
trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other
countries. Please see http://global12.sap.com/corporate-en/legal/copyright/index.epx for additional
trademark information and notices.

Some software products marketed by SAP SE and its distributors contain proprietary software
components of other software vendors.
National product specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for informational purposes only,
without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable
for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate
company products and
services are those that are set forth in the express warranty statements accompanying such products
and services, if any. Nothing herein should be construed as constituting an additional warranty.

In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business
outlined in this document or any related presentation, or to develop
or release any functionality mentioned therein. This document, or any related presentation, and SAP
SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform
directions and functionality are all subject to change and may be changed by SAP SE or its affiliated
companies at any time
for any reason without notice. The information in this document is not a commitment, promise, or legal
obligation to deliver any material, code, or functionality. All forward-looking statements are subject to
various risks and uncertainties that could cause actual results to differ materially from expectations.
Readers are cautioned not to place undue reliance on these forward-looking statements, which speak
only as of their dates, and they should not be relied upon in making purchasing decisions.

18 | P a g e