Database View Creation in ABAP Dictionary

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="font-size: medium;"><i><b>Views -</b> A view is a "virtual table" containing fields from one or more tables.</i></span> <br> Types of views <br> 1- Database View. <br> 2- Projection View <br> 3- Maintenance View <br> 4- Help View <br> <br> </div>

Database View Creation in ABAP Dictionary

Views - A view is a "virtual table" containing fields from one or more tables. Types of views 1- Database View. 2- Projecti...

Read more »

Structure in ABAP Dictionary

<div dir="ltr" style="text-align: left;" trbidi="on"> <b><span style="font-size: medium;">Structure in ABAP Dictionary</span></b> <br> <i><u><span style="font-size: medium;"><b><br></b></span></u></i> <i><u><span style="font-size: medium;"><b>Structure-</b> Structures contain data only during the runtime of a program.</span></u></i> <br> <br> A <b>structure </b>in the <i>ABAP Dictionary </i>is used to centrally describe structure variables that are to contain the <b>fields of various tables</b>. <br> The definition of a dictionary structure is almost identical to that of a transparent table. The only difference is that declaring key fields and specifying technical settings does not make sense for structures and is thus not required<br> <br> <br> </div>

Structure in ABAP Dictionary

Structure in ABAP Dictionary Structure- Structures contain data only during the runtime of a program. A structure in the ABAP Dictio...

Read more »

Transparent Table Creation in ABAP Dictionary

<p><b><font size="4"><em><u>Step by Step Transparent Table Creation in ABAP Dictionary</u></em></font></b> <p>1) Go to transaction SE11. Select the radio button database table. Enter the name of the table to be created. Click on the Create button. <p><a href="https://lh3.googleusercontent.com/-JkbfZJvvfb0/V-zJ0EEJ2XI/AAAAAAAADR8/gOY2-yN5k24/s1600-h/clip_image002%25255B10%25255D.jpg"><img alt="clip_image002" border="0" height="188" src="https://lh3.googleusercontent.com/-cI-oHGhRa3E/V-zJ1R01C6I/AAAAAAAADSA/cxo1YbJ7kDw/clip_image002_thumb%25255B7%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image002" width="388"></a> <p>2) Enter the short description, Select delivery class<strong> A</strong> and Data Browser <strong>Display/Maintenance allowed</strong>. <p><a href="https://lh3.googleusercontent.com/-teRMmool5KI/V-zJ1zEl1PI/AAAAAAAADSE/strOPEIGGHo/s1600-h/clip_image004%25255B7%25255D.jpg"><img alt="clip_image004" border="0" height="184" src="https://lh3.googleusercontent.com/-De00EoxgW6E/V-zJ23d7yqI/AAAAAAAADSI/y2YqrLAJGAk/clip_image004_thumb%25255B4%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image004" width="444"></a> <p>3) Click on Fields Tab. <p><a href="https://lh3.googleusercontent.com/-TTR9Bf7nJQQ/V-zJ3l3nBII/AAAAAAAADSM/AnzG3YdF2yI/s1600-h/clip_image006%25255B7%25255D.jpg"><img alt="clip_image006" border="0" height="193" src="https://lh3.googleusercontent.com/-cznSSMh7S4E/V-zJ4V9b2WI/AAAAAAAADSQ/MITa0wToeb8/clip_image006_thumb%25255B4%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image006" width="455"></a> <p>4) Enter Field Name & Data Elements <p><a href="https://lh3.googleusercontent.com/-REKs7xuN8Fs/V-zJ5B6z8CI/AAAAAAAADSU/8BTCervpsHA/s1600-h/clip_image008%25255B9%25255D.jpg"><img alt="clip_image008" border="0" height="233" src="https://lh3.googleusercontent.com/-ZYh4BFfwsP0/V-zJ63Ntd3I/AAAAAAAADSY/ZJsG57XdSsA/clip_image008_thumb%25255B6%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image008" width="459"></a> <p>5) Double click on data element field. It will ask for the creation of the new data element. Press Yes button. <p><a href="https://lh3.googleusercontent.com/-yB4xskEjZrc/V-zJ7UzccCI/AAAAAAAADSc/qC_Li--ea98/s1600-h/clip_image010%25255B6%25255D.jpg"><img alt="clip_image010" border="0" height="244" src="https://lh3.googleusercontent.com/-2y-XmOIiz0Y/V-zJ8JUQtyI/AAAAAAAADSg/jmAdQGjo6y8/clip_image010_thumb%25255B3%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image010" width="458"></a> <p>6) Enter Short description and domain name. <p><a href="https://lh3.googleusercontent.com/-NqvhNasQpbY/V-zJ9bb4WbI/AAAAAAAADSk/rClHNasOaGI/s1600-h/clip_image011%25255B6%25255D.png"><img alt="clip_image011" border="0" height="230" src="https://lh3.googleusercontent.com/-CN7eRw31PZ0/V-zJ-JejX6I/AAAAAAAADSo/dMd72GxoQxA/clip_image011_thumb%25255B3%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image011" width="460"></a> <p>7) Double click on domain field to create new domain.A pop window will open, it will ask your for save before going next screen. <p>Press Yes button.  <p><a href="https://lh3.googleusercontent.com/-uiyIJhLHNZg/V-zJ-yCDsZI/AAAAAAAADSs/6PsixMJc6Ro/s1600-h/clip_image012%25255B7%25255D.png"><img alt="clip_image012" border="0" height="302" src="https://lh3.googleusercontent.com/-PRvilJdOcdY/V-zJ_5MPyfI/AAAAAAAADSw/D99-GBgeckk/clip_image012_thumb%25255B4%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image012" width="454"></a> <p>8) Next It will ask for domain creation. Click on Yes button. <p><a href="https://lh3.googleusercontent.com/-SDVJ4HlHU2M/V-zKARx8_JI/AAAAAAAADS0/B7rJU_UJNB4/s1600-h/clip_image014%25255B7%25255D.jpg"><img alt="clip_image014" border="0" height="194" src="https://lh3.googleusercontent.com/-9w7i1iGvbMM/V-zKCBetIaI/AAAAAAAADS4/QP7IMNax8Uw/clip_image014_thumb%25255B4%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image014" width="461"></a> <p>9) Enter domain short description, data type & length etc. <p><a href="https://lh3.googleusercontent.com/--n36yYybNIo/V-zKC_LG7yI/AAAAAAAADS8/y7j-2srO22M/s1600-h/clip_image016%25255B9%25255D.jpg"><img alt="clip_image016" border="0" height="275" src="https://lh3.googleusercontent.com/-bo5cNLEa4Rk/V-zKDjrcBoI/AAAAAAAADTA/9FfTKPn1I-M/clip_image016_thumb%25255B6%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image016" width="468"></a> <p>10) Click on Save Button. A popup will open enter your package name click on save button. <p><a href="https://lh3.googleusercontent.com/-SohaxZ9xy2w/V-zKFDnDLTI/AAAAAAAADTE/AMN3qbU28vU/s1600-h/clip_image017%25255B8%25255D.png"><img alt="clip_image017" border="0" height="303" src="https://lh3.googleusercontent.com/-h_Td-UG1tvM/V-zKF9lLo0I/AAAAAAAADTI/Cl3KXSv8HX8/clip_image017_thumb%25255B5%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image017" width="478"></a> <p>11) Activate you domain .Click on <a href="https://lh3.googleusercontent.com/-Xl3Ao-93sgA/V-zKGtLpidI/AAAAAAAADTM/7tLOieQWTgM/s1600-h/clip_image018%25255B3%25255D.png"><img alt="clip_image018" border="0" height="34" src="https://lh3.googleusercontent.com/-bQB_X6HuMns/V-zKHYCqPaI/AAAAAAAADTQ/BEu4td9JptE/clip_image018_thumb.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image018" width="28"></a> button. <p><a href="https://lh3.googleusercontent.com/-qS2gl7Uy95U/V-zKIBCpktI/AAAAAAAADTU/G1VEpGjmY5I/s1600-h/clip_image019%25255B8%25255D.png"><img alt="clip_image019" border="0" height="329" src="https://lh3.googleusercontent.com/-BXkMIMsHW1M/V-zKI3kb1KI/AAAAAAAADTY/BP_b_chXtp4/clip_image019_thumb%25255B5%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image019" width="484"></a> <p>12) Click back button. Now you will come back on data element. <p><a href="https://lh3.googleusercontent.com/-prqJaS8-hDY/V-zKJr6qc6I/AAAAAAAADTc/NtxwU7wW7IU/s1600-h/clip_image021%25255B7%25255D.jpg"><img alt="clip_image021" border="0" height="258" src="https://lh3.googleusercontent.com/-pF7wrXh-_wM/V-zKKgj-RvI/AAAAAAAADTg/pSjCIqaa0rE/clip_image021_thumb%25255B4%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image021" width="489"></a> <p>13) Save ,Check and Activate. <p><a href="https://lh3.googleusercontent.com/-dTtOABTUWlo/V-zKLCfB_pI/AAAAAAAADTk/xtvw8FjhH8s/s1600-h/clip_image022%25255B7%25255D.png"><img alt="clip_image022" border="0" height="277" src="https://lh3.googleusercontent.com/-yABfaovIXaM/V-zKMKsHVYI/AAAAAAAADTo/Zng-mLk1GEM/clip_image022_thumb%25255B4%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image022" width="487"></a> <p>14) Again Press back button. You will get below screen. <p><a href="https://lh3.googleusercontent.com/-3nc4_Ng3aC0/V-zKM0i_ykI/AAAAAAAADTs/O6mBhtvLynQ/s1600-h/clip_image024%25255B7%25255D.jpg"><img alt="clip_image024" border="0" height="187" src="https://lh3.googleusercontent.com/-tGO2VYHpzTg/V-zKNup7j-I/AAAAAAAADTw/FFEvpICGjZg/clip_image024_thumb%25255B4%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image024" width="492"></a> <p>15) Now Press Save ,Check & Activate button. You will get following error without activating technical setting. <p><a href="https://lh3.googleusercontent.com/-5cJ4vzhzsjE/V-zKObMV9RI/AAAAAAAADT0/kv05fmJcuyA/s1600-h/clip_image026%25255B6%25255D.jpg"><img alt="clip_image026" border="0" height="131" src="https://lh3.googleusercontent.com/-h17hAPYHpzM/V-zKPM-kg-I/AAAAAAAADT4/jofwOiO9RPo/clip_image026_thumb%25255B3%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image026" width="503"></a> <p>16) Press on <a href="https://lh3.googleusercontent.com/-0Di4w_vz3sA/V-zKPiYU96I/AAAAAAAADT8/XqPv2mIaYYk/s1600-h/clip_image027%25255B3%25255D.png"><img alt="clip_image027" border="0" height="30" src="https://lh3.googleusercontent.com/-XUHcFqrX5MA/V-zKQSBPGaI/AAAAAAAADUA/HvNPPy_m02w/clip_image027_thumb.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image027" width="110"></a> button. </p> <p><a href="https://lh3.googleusercontent.com/-HO-3hjXm7oQ/V-zKRF0dE0I/AAAAAAAADUE/CsPcTWqHrSU/s1600-h/clip_image029%25255B7%25255D.jpg"><img alt="clip_image029" border="0" height="250" src="https://lh3.googleusercontent.com/-XalLFVZIHTE/V-zKR-DmuLI/AAAAAAAADUI/B9uKj3tOSu4/clip_image029_thumb%25255B4%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image029" width="508"></a></p> <p>17) Enter data class and size category of the table as per the requirement. <p><b>Data Class –</b> Data class determined the physical area of table inside database. <p><b>Size Category -</b> The size category describes the expected storage requirements for the table on the database. <p><a href="https://lh3.googleusercontent.com/-vMoELkmHvXo/V-zKSo3-bdI/AAAAAAAADUM/sSLJgoUhZsc/s1600-h/clip_image031%25255B6%25255D.jpg"><img alt="clip_image031" border="0" height="204" src="https://lh3.googleusercontent.com/-hnTi3nMBkbQ/V-zKTn5GXWI/AAAAAAAADUQ/39AAtTvpJIc/clip_image031_thumb%25255B3%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image031" width="521"></a> <p>18) Press save & back button. <p><a href="https://lh3.googleusercontent.com/-sDdCI2s00L0/V-zKUVWV-zI/AAAAAAAADUU/ty7KQpEM0HM/s1600-h/clip_image032%25255B7%25255D.png"><img alt="clip_image032" border="0" height="117" src="https://lh3.googleusercontent.com/-bRNB0iq00dk/V-zKVORJ4CI/AAAAAAAADUY/3RrcO5HNQ9w/clip_image032_thumb%25255B4%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image032" width="524"></a> <p>19) Now activate the table by pressing the activate button. <p><a href="https://lh3.googleusercontent.com/-j-e5jSyQApk/V-zKV3Ffp0I/AAAAAAAADUc/HUpRg-TDFNk/s1600-h/clip_image034%25255B12%25255D.jpg"><img alt="clip_image034" border="0" height="297" src="https://lh3.googleusercontent.com/-uqR8ez1fdHc/V-zKWzduxYI/AAAAAAAADUg/TqkXjab5UiY/clip_image034_thumb%25255B9%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image034" width="526"></a> <p>  <p><strong>Article By</strong> <p><strong>Mohammed Khalid Khan</strong> <p><strong>ABAP Consultant</strong>

Transparent Table Creation in ABAP Dictionary

Step by Step Transparent Table Creation in ABAP Dictionary 1) Go to transaction SE11. Select the radio button database table. Enter the nam...

Read more »

Collective Search Help Creation in ABAP Dictionary

<p><font size="4"><b>Collective Search Help- </b></font><font size="3">Data display from more than one table.</font> <p>Collective search helps combine several elementary search helps. Collective search help thus can offer several alternative search paths. <p><b><font size="4"><u><em>Step By Step Collective Search Help Creation</em></u></font></b> <p>1) Go to transaction SE11. Select the radio button for Search help. Enter the name of the search help to be created. Click on the Create button. <p><a href="https://lh3.googleusercontent.com/-SdQ_7bE4SY8/V-zLYMVR0HI/AAAAAAAADVw/Io55Se-tc48/s1600-h/clip_image002%25255B2%25255D.jpg"><img alt="clip_image002" border="0" height="95" src="https://lh3.googleusercontent.com/-KkodJtwe55I/V-zLZX2Q_DI/AAAAAAAADV0/ucmZbBaTAJw/clip_image002_thumb%25255B2%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image002" width="448"></a> <p>2) The system will prompt for the search help type to be created. Select the Collective search help. <p><a href="https://lh3.googleusercontent.com/-orsivv03zac/V-zLaOM4RDI/AAAAAAAADV4/uRltB9VGt50/s1600-h/clip_image003%25255B2%25255D.png"><img alt="clip_image003" border="0" height="162" src="https://lh3.googleusercontent.com/-YxYS3K3JJvA/V-zLbSeNrDI/AAAAAAAADV8/_jK09wI0CFM/clip_image003_thumb%25255B1%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image003" width="441"></a> <p>3) Enter Short description, Go to tab include search help. Enter Elementary Search Help. <p><a href="https://lh3.googleusercontent.com/-0VOMeHWcxTk/V-zLcaSjsmI/AAAAAAAADWA/niRicvAEuD4/s1600-h/clip_image005%25255B2%25255D.jpg"><img alt="clip_image005" border="0" height="108" src="https://lh3.googleusercontent.com/-YCAQOpGK97Y/V-zLdXaFCII/AAAAAAAADWE/ve0ciASNYi4/clip_image005_thumb%25255B1%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image005" width="450"></a> <p>4) Now select the first elementary search help and click on the Param. Assignment Button. <p><a href="https://lh3.googleusercontent.com/-IRMhbo22m10/V-zLeQqR92I/AAAAAAAADWI/UIm3oWPtFt8/s1600-h/clip_image007%25255B2%25255D.jpg"><img alt="clip_image007" border="0" height="109" src="https://lh3.googleusercontent.com/-ndO2jv8i0CM/V-zLfro1E4I/AAAAAAAADWM/--GffbKOtA4/clip_image007_thumb%25255B1%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image007" width="455"></a> <p>5) Now system automatically maps the elementary search help reference parameter to the Collective Search help parameter and at last click on Copy button. <p><a href="https://lh3.googleusercontent.com/-WmzEA89BJ2Y/V-zLgi1W_3I/AAAAAAAADWQ/UkX5HOsMVmE/s1600-h/clip_image008%25255B3%25255D.png"><img alt="clip_image008" border="0" height="90" src="https://lh3.googleusercontent.com/-2jI_bYDxcVc/V-zLhj2tLlI/AAAAAAAADWU/QE2whsO0sbg/clip_image008_thumb%25255B2%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image008" width="463"></a></p> <p><a href="https://lh3.googleusercontent.com/-R8WEMvHLddk/V-zA-9uPCJI/AAAAAAAADRM/5Z3fZByX6J0/s1600-h/clip_image0096.png"><img alt="clip_image009" border="0" height="30" src="https://lh3.googleusercontent.com/-u2GHf1xIxDA/V-zBAccp01I/AAAAAAAADRQ/DwbOClYkLPM/clip_image009_thumb3.png?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="clip_image009" width="465"></a></p> <p>6)<b> </b>Now save the Search help by pressing <a href="https://lh3.googleusercontent.com/-IjvX4EvUco8/V-zBBXPDdtI/AAAAAAAADRU/GWCB9k2_4dw/s1600-h/clip_image0103.jpg"><img alt="clip_image010" border="0" height="27" src="https://lh3.googleusercontent.com/-YK9PNSNXvqQ/V-zBCBb6apI/AAAAAAAADRY/aIXDuNhC4WI/clip_image010_thumb.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="clip_image010" width="28"></a> button present in standard tool bar. Then activate the view with <a href="https://lh3.googleusercontent.com/-qo7i7O0k76o/V-zBCjhtUbI/AAAAAAAADRc/AkoNO7tpBiE/s1600-h/clip_image0113.jpg"><img alt="clip_image011" border="0" height="26" src="https://lh3.googleusercontent.com/-36kXUwuBSL0/V-zBDyW6lII/AAAAAAAADRg/AWqb15jjLZE/clip_image011_thumb.jpg?imgmax=800" style="border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px; display: inline; padding-right: 0px; border-top-width: 0px" title="clip_image011" width="22"></a> present in application tool bar. <p><a href="https://lh3.googleusercontent.com/-GW9W-cTrMP8/V-zLihykd7I/AAAAAAAADWY/419f5B0lV4I/s1600-h/clip_image012%25255B2%25255D.png"><img alt="clip_image012" border="0" height="214" src="https://lh3.googleusercontent.com/-U6Qn90_k1DM/V-zLj7N5fuI/AAAAAAAADWc/rXjjXjZWVfA/clip_image012_thumb%25255B1%25255D.png?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image012" width="447"></a> <p><strong></strong>  <p><strong>Article By </strong> <p><strong>Mohammed Khalid Khan</strong> <p><strong>ABAP Consultant</strong>

Collective Search Help Creation in ABAP Dictionary

Collective Search Help- Data display from more than one table. Collective search helps combine several elementary search helps. Collective...

Read more »

Elementary Search Help Creation in ABAP Dictionary

<p><b><font size="4">SEARCH HELP IN ABAP DICTIONARY</font></b> <p><b>Search Help - </b>Search helps are objects that you can use to assign input help (F4 Help) to screen fields. You can do this by creating a search help in the ABAP Dictionary and attaching it to the corresponding screen field. <p><strong>Search help are two types.</strong> <p><b>Elementary Search Help -</b> Data coming from single table and display with in single screen. <p><strong>Collective Search Help- </strong>Data display from more than one table <p><em><b><u><font size="4">Step By Step Elementary Search Help Creation</font></u></b></em> <p>1) Go to transaction SE11. Select the radio button for Search help. Enter the name of the search help to be created. Click on the Create button. <p><a href="https://lh3.googleusercontent.com/-b5HsThEbsNo/V-zKsX33QWI/AAAAAAAADUo/5GOv3e3E5yc/s1600-h/9-29-2016%25252010-07-51%252520AM%25255B6%25255D.jpg"><img alt="9-29-2016 10-07-51 AM" border="0" height="296" src="https://lh3.googleusercontent.com/-o9WLFBveIhY/V-zKtnbNuaI/AAAAAAAADUs/ElUnRSkosH0/9-29-2016%25252010-07-51%252520AM_thumb%25255B6%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="9-29-2016 10-07-51 AM" width="367"></a></p> <p>2) The system will prompt for the search help type to be created. Select the Elementary search help, which is default. </p> <p><a href="https://lh3.googleusercontent.com/-ZoyIIWk6vFQ/V-zKuipvWJI/AAAAAAAADUw/FTf5ZgRJHQw/s1600-h/clip_image003%25255B2%25255D.jpg"><img alt="clip_image003" border="0" height="109" src="https://lh3.googleusercontent.com/-hUIQDkcUjn4/V-zKvzrCjBI/AAAAAAAADU0/C3AWmwYgsXg/clip_image003_thumb%25255B1%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image003" width="388"></a> <p>3) In the selection method, we need to indicate whether our source of data is a table or a view. In our case it happens to be a table. <p><a href="https://lh3.googleusercontent.com/-0wBRGcEiHnk/V-zKw7OglyI/AAAAAAAADU4/hm7iUDJqix8/s1600-h/clip_image005%25255B3%25255D.jpg"><img alt="clip_image005" border="0" height="115" src="https://lh3.googleusercontent.com/-Aq-M1pcRaWw/V-zKx0-_bcI/AAAAAAAADU8/PhD4RDrFIPM/clip_image005_thumb%25255B2%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image005" width="401"></a> <p>4) After the selection method is entered, In the Search Help parameter section, press F4 button and add required fields. <p><a href="https://lh3.googleusercontent.com/-CpyIrWU3b0Y/V-zKzFFLSBI/AAAAAAAADVA/MPLzL_4jbs4/s1600-h/clip_image007%25255B2%25255D.jpg"><img alt="clip_image007" border="0" height="159" src="https://lh3.googleusercontent.com/-u_gCO5gcDzM/V-zK06N3VOI/AAAAAAAADVE/GnFIDf5yCTA/clip_image007_thumb%25255B1%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image007" width="415"></a> <p>5) Select parameter details. <p><a href="https://lh3.googleusercontent.com/-RCgbZD_CVhg/V-zK1wtCj4I/AAAAAAAADVI/aKbW1rccgdQ/s1600-h/clip_image009%25255B3%25255D.jpg"><img alt="clip_image009" border="0" height="201" src="https://lh3.googleusercontent.com/-gJ8YRIO4VKU/V-zK3EzgBPI/AAAAAAAADVM/6Y17EBFsTVY/clip_image009_thumb%25255B2%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image009" width="401"></a> <p><b>Import -</b> Pass into the search help importing parameters to restrict the search help values. <p><a href="https://lh3.googleusercontent.com/-zh44m3GwdGI/V-zK4BtBSRI/AAAAAAAADVQ/HwFzalGj4FQ/s1600-h/clip_image011%25255B2%25255D.jpg"><img alt="clip_image011" border="0" height="146" src="https://lh3.googleusercontent.com/-nRMwxg6GMDs/V-zK5Baay1I/AAAAAAAADVU/4-O17IgWHnI/clip_image011_thumb%25255B1%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image011" width="478"></a> <p><b></b> <p><b>Export</b> - Indicates whether value is exported back to selection screen. <p><a href="https://lh3.googleusercontent.com/-GDRXTfZIin8/V-zK58KKq7I/AAAAAAAADVY/LZtcQTV21O8/s1600-h/clip_image013%25255B2%25255D.jpg"><img alt="clip_image013" border="0" height="107" src="https://lh3.googleusercontent.com/-Fvy6cRICzMs/V-zK7Apy9VI/AAAAAAAADVc/lEJalUlKSCg/clip_image013_thumb%25255B1%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image013" width="518"></a> <p><b>LPOS - </b>Position of field in search help results report/table. <p>When you data is displayed in the F4 help that time it will be based on the LPos   position. <p> <p><a href="https://lh3.googleusercontent.com/-Q1OnXoF4HDY/V-zK8IB7UuI/AAAAAAAADVg/q6JElxYmmMA/s1600-h/clip_image015%25255B2%25255D.jpg"><img alt="clip_image015" border="0" height="109" src="https://lh3.googleusercontent.com/-r1CS6UgbWbA/V-zK9K5SgzI/AAAAAAAADVk/Ole4WlnqAu4/clip_image015_thumb%25255B1%25255D.jpg?imgmax=800" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px" title="clip_image015" width="563"></a> <p><b></b> <p><b></b> <p><b>SPOS </b><b>-</b> Position on the selection screen if your search help to have select options which the user can enter to restrict further the search help value list by. <p><strong><em><font size="4"><u><a href="http://www.itstuffs.net/2016/09/collective-search-help-creation-in-abap.html" target="_blank">Step By Step Collective Search Help Creation in ABAP Dictionary</a></u></font></em></strong> <p><strong><em><u><font size="4"></font></u></em></strong>  <p><strong>Article By </strong> <p><strong>Mohammed Khalid Khan</strong> <p><strong>ABAP Consultant</strong></p>

Elementary Search Help Creation in ABAP Dictionary

SEARCH HELP IN ABAP DICTIONARY Search Help - Search helps are objects that you can use to assign input help (F4 Help) to screen fields. Yo...

Read more »