Online Tutorials & Training Materials | STechies.com
Register Login

Data Dictionary Activities

|| 0

Data Dictionary Activities
Stechies

Changes to Existing Domain

  • First execute transaction SE11 and give domain name as ‘J_1ICONDNAME1’ and click on ‘Change’
  • Now in value range tab add below values at the end
Fix Val Short Description
CGSTAR A/R CGST
SGSTAR A/R SGST
IGSTAR A/R IGST
CGSTSOFFAP A/P CGST SETOFF
SGSTSOFFAP A/P SGST SETOFF
IGSTSOFFAP A/P IGST SETOFF
CGSTINVAP A/P CGST Inventory
SGSTINVAP A/P SGST Inventory
IGSTINVAP A/P IGST Inventory
  • Atlast save and activate in package ‘J1ICIN40A’

Create New Domains

  • First, execute SE11 transaction.
  • Now choose the Domain radio button.
  • And the please create the domain as shown in the table below and save it in package J1I_GST_LO.
  • Atlast activate the domain

1.Create domain ‘J_1IG_HSN_SAC’

Domain name Short text Data Type Length Output Length Value Range
J_1IG_HSN_SAC HSN or SAC code CHAR 16 16  

 

2.Create domain ‘J_1IG_PARTNER’

Domain name Short text Data Type Length Output Length Value Range

J_1IG_PARTNER

GST Partner

CHAR 10 10  

Create New Structures

  • First navigate to t-code SE11.
  • Now click on the radio button ‘Data Type’.
  • Then create each of the Structure as listed below. Please always keep in mind that: Package for all objects is ‘J1I_GST_LO’.
  • Also enhancement category for all the structures must be “Can be Enhanced (character like or numeric).

1) Structure: J_1IG_EXT_ACCIT

Structure Name Description
J_1IG_EXT_ACCIT GST India - Extension for ACCIT

Structure Components

Component Typing Method Component Type
GST_PART Types J_1IG_PARTNER
PLC_SUP Types J_1IG_REGION
HSN_SAC Types J_1IG_HSN_SAC

 

2) Structure: J_1IG_EXT_ACGL_ITEM

Structure Name Description
J_1IG_EXT_ACGL_ITEM GST India - Extension for ACGL_ITEM

Structure Components

Component Typing Method Component Type
HSN_SAC Types J_1IG_HSN_SAC

 

3) Structure: J_1IG_EXT_ACMM

Structure Name Description
J_1IG_EXT_ACMM GST India - Extension for ACMM

Structure Components

Component Typing Method Component Type
GST_PART Types J_1IG_PARTNER
PLC_SUP Types J_1IG_REGION
HSN_SAC Types J_1IG_HSN_SAC

 

4) Structure: J_1IG_EXT_BSEG

Structure Name

Description

J_1IG_EXT_BSEG

GST India -  Extension for BSEG

Structure Components

Component Typing Method Component Type
GST_PART Types J_1IG_PARTNER
PLC_SUP Types J_1IG_REGION
HSN_SAC Types J_1IG_HSN_SAC

 

5) Structure: J_1IG_EXT_DRSEG

Structure Name Description
J_1IG_EXT_DRSEG GST India -  Extension for DRSEG

Structure Components

Component Typing Method Component Type
HSN_SAC Types J_1IG_HSN_SAC

 

6) Structure: J_1IG_EXT_RBKP

Structure Name Description
J_1IG_EXT_RBKP GST India - Extension for RBKP

Structure Components

Component Typing Method Component Type
GST_PART Types J_1IG_PARTNER
PLC_SUP Types J_1IG_REGION

 

7) Structure: J_1IG_EXT_RSEG

Structure Name Description
J_1IG_EXT_RSEG GST India - Extension for RSEG

Structure Components

Component Typing Method Component Type
HSN_SAC Types J_1IG_HSN_SAC

 

8) Structure: J_1IG_EXT_VBSEG

Structure Name Description
J_1IG_EXT_VBSEG GST India -  Extension for VBSEG

Structure Components

Component Typing Method Component Type
GST_PART Types GST_PARTNER
PLC_SUP Types J_1IG_REGION
HSN_SAC Types J_1IG_HSN_SAC

 

9) Structure: J_1IG_EXT_VBSEGD

Structure Name Description
J_1IG_EXT_VBSEGD GST India - Extension for VBSEGD

Structure Components

Component Typing Method Component Type
GST_PART Types GST_PARTNER
PLC_SUP Types J_1IG_REGION
HSN_SAC Types J_1IG_HSN_SAC

 

10) Structure: J_1IG_EXT_VBSEGK

Structure Name Description
J_1IG_EXT_VBSEGK GST India - Extension for VBSEGK

Structure Components

Component Typing Method Component Type
GST_PART Types GST_PARTNER
PLC_SUP Types J_1IG_REGION
HSN_SAC Types J_1IG_HSN_SAC

 

11) Structure: J_1IG_EXT_VBSEGS

Structure Name Description
J_1IG_EXT_VBSEGS GST India - Extension for VBSEGS

Structure Components

Component Typing Method Component Type
HSN_SAC Types J_1IG_HSN_SAC

 

12) Structure: J_1IG_GST_PARTREG

Structure Name Description
J_1IG_GST_PARTREG GST India – Region and Partner details

Structure Components

Component Typing Method Component Type
VBELN Types VBELN
POSNR Types POSNR
GST_PART Types J_1IG_PARTNER
PLC_SUP Types J_1IG_REGION

Create New Data Elements

  • First navigate to t-code SE11.
  • Then click on the radio button ‘Data Type’.
  • Now create each of the Data Elements as listed below. Please also keep in mind that the package for all objects is ‘J1I_GST_LO’.
Date Element Short Text Domain Field Label
J_1IG_HSN_SAC HSN or SAC Code J_1IG_HSN_SAC
  • Short :10  HSN/SAC 
  • Medium :15  HSN/SAC Code
  • Long :20  HSN/SAC Code
  • Heading :16 HSN/SAC Code
J_1IG_PARTNER GST Partner J_1IG_PARTNER
  • Short :10  GST Partnr
  • Medium :20  GST Partner
  • Long :40  GST Partner
  • Heading:15 GST Partner
J_1IG_REGION Place of Supply REGIO
  • Short: 10 Pl. of Sup
  • Medium:20 Place of Supply
  • Long:40  Place of Supply
  • Heading:15 Place of Supply

Structure Extensions

  • First create Append structure for each of the object as listed below in the table. Please note: Package for all Append structures is ‘J1I_GST_LO’.
  • Enhancement category for all the structures must be “Can be Enhanced (character like or numeric).

Structure: ACCIT

  • Execute SE11 and select the radio button “Data Type”.
  • Provide the structure name “ACCIT” and click on the “Change” button.
  • Click on the “Append Structure” button and select the create icon. Provide the following details.
Append Name Description
J_1IG_ACCIT GST India ACCIT Extension
  • From the Menu bar, navigate to Extras -> Enhancement Category and select the option “Can be Enhanced (character like or numeric). Save the structure under the package “J1I_GST_LO”.
  • From the Menu bar, navigate to Edit -> Include Objects -> Insert and provide the Structure name as “J_1IG_EXT_ACCIT”.
  • Save and activate the objects.

NOTE: Following are the above mentioned steps for extending the various structures listed below.

Main structure Append Structure Include structure
ACGL_ITEM J_1IG_ACGL_ITEM J_1IG_EXT_ACGL_ITEM
ACMM_VENDOR_COMP J_1IG_ACMM J_1IG_EXT_ACMM
DRSEG J_1IG_DRSEG J_1IG_EXT_DRSEG
ACGL_ITEM J_1IG_ACGL_ITEM J_1IG_EXT_ACGL_ITEM
VBSEG J_1IG_VBSEG J_1IG_EXT_VBSEG

Create New Table type

  • First execute SE11 and also select the radio button “Table Type”.
  • Now provide the following details as shown below

Table type: J_1IG_TT_GST_PART_REG
Short text: GST partner and region details

  • Also, provide the row type as “J_1IG_GST_PARTREG”.
  • Now save the object under the package “J1I_GST_LO”.
  • At last activate the object.

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