Help View Creation in ABAP Dictionary

<div dir="ltr" style="text-align: left;" trbidi="on"> <em><u><span style="font-size: medium;"><b>Step by Step</b><b> Help View Creation</b></span></u></em> <br> <b>Help View-</b> This view is used to displaying possible values of field from one or more than one table i.e. used to output additional information when the online help system is called or when F4 is pressed on the field.<br> </div>

Help View Creation in ABAP Dictionary

Step by Step Help View Creation Help View- This view is used to displaying possible values of field from one or more than one table i.e...

Read more »

Maintenance View Creation in ABAP Dictionary

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="font-size: medium;"><em><u><b>Step by Step Maintenance</b><b> View Creation</b></u></em></span> <br> <b>Maintenance View - </b>This view is used to for data manipulation like insert, update, delete, modify etc. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is the data is entered via the view and then distributed to the underlying tables by the system<br> </div>

Maintenance View Creation in ABAP Dictionary

Step by Step Maintenance View Creation Maintenance View - This view is used to for data manipulation like insert, update, delete, modify...

Read more »

Projection View Creation in ABAP dictionary

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="font-size: medium;"><i><u><b>Step by Step </b><b>Projection View Creation.</b></u></i></span> <br> <b><br></b> <b>Projection View – </b>This view is used to hide fields of a table<b>.</b> Selection conditions cannot be specified for projection views.<br> </div>

Projection View Creation in ABAP dictionary

Step by Step Projection View Creation. Projection View – This view is used to hide fields of a table . Selection conditions cannot be s...

Read more »

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 »

Reporting on Analysis for Microsoft Excel

<p>We have created the Analytic model to view the plantwise sales quantity.  Let see how to build the report using the view on Analysis for Microsoft Excel. </p> <ul> <li>Goto Start menu > Program > Businessobjects > Analysis for Microsoft Excel.</li></ul> <p><a href="https://lh3.googleusercontent.com/-1B0TUqXVsRU/VvCQ9wjPWJI/AAAAAAAAC7Y/kcv3qNI2DhY/s1600-h/3-22-2016%2525201-22-09%252520AM%25255B10%25255D.jpg"><img alt="3-22-2016 1-22-09 AM" border="0" height="173" src="https://lh3.googleusercontent.com/-tI2na8z_gls/VvCQ-kggqLI/AAAAAAAAC7c/1hcAs42iW38/3-22-2016%2525201-22-09%252520AM_thumb%25255B8%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="3-22-2016 1-22-09 AM" width="272"></a></p> <ul> <li>Goto Analysis tab and Select data source.</li></ul> <p><a href="https://lh3.googleusercontent.com/-QJdPMIIuk4I/VvCQ_n02W9I/AAAAAAAAC7g/CbAoFaAwR44/s1600-h/3-22-2016%2525201-22-36%252520AM%25255B7%25255D.jpg"><img alt="3-22-2016 1-22-36 AM" border="0" height="193" src="https://lh3.googleusercontent.com/-UfGpTn1hZCw/VvCRAqTiDNI/AAAAAAAAC7k/cewC_DMhnTI/3-22-2016%2525201-22-36%252520AM_thumb%25255B5%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="3-22-2016 1-22-36 AM" width="644"></a></p> <ul> <li>  Skip the logon screen to use the Local ODBC connection to HANA </li></ul> <p><a href="https://lh3.googleusercontent.com/-qJtZqZ-rQrA/VvCRBoezhuI/AAAAAAAAC7o/nGRoc6PCbXI/s1600-h/3-22-2016%2525201-24-57%252520AM%25255B9%25255D.jpg"><img alt="3-22-2016 1-24-57 AM" border="0" height="334" src="https://lh3.googleusercontent.com/-6qBaI0A-Evc/VvCRCmPjJnI/AAAAAAAAC7s/ZKEMnbWn3bo/3-22-2016%2525201-24-57%252520AM_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="3-22-2016 1-24-57 AM" width="644"></a></p> <ul> <li>Select the HANA ODBC connection. Press next.       </li></ul> <p><a href="https://lh3.googleusercontent.com/-LY8qbLk79t4/VvCRDGTliLI/AAAAAAAAC7w/geCB_quIR0s/s1600-h/3-22-2016%2525201-25-08%252520AM%25255B7%25255D.jpg"><img alt="3-22-2016 1-25-08 AM" border="0" height="385" src="https://lh3.googleusercontent.com/-_bItA8YYsg0/VvCRD35-w9I/AAAAAAAAC70/dnP-Uql1yxI/3-22-2016%2525201-25-08%252520AM_thumb%25255B5%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="3-22-2016 1-25-08 AM" width="478"></a></p> <ul> <li>Navigate to folder. Select the Analytic or Calculation views from the Package.</li></ul> <p><a href="https://lh3.googleusercontent.com/-z71bBA82mkQ/VvCREm59jyI/AAAAAAAAC74/CeRm9QPewSs/s1600-h/3-22-2016%2525201-27-09%252520AM%25255B12%25255D.jpg"><img alt="3-22-2016 1-27-09 AM" border="0" height="433" src="https://lh3.googleusercontent.com/-kw61AmywBMg/VvCRF-6kGPI/AAAAAAAAC78/xSQzfq_iv1Y/3-22-2016%2525201-27-09%252520AM_thumb%25255B8%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="3-22-2016 1-27-09 AM" width="542"></a></p> <ul> <li>Report will be generated based on the view.</li></ul> <p><a href="https://lh3.googleusercontent.com/-TznqyKy7FEs/VvCRHysQseI/AAAAAAAAC8A/uswBE-uqa6w/s1600-h/3-22-2016%2525202-18-44%252520AM%25255B12%25255D.jpg"><img alt="3-22-2016 2-18-44 AM" border="0" height="353" src="https://lh3.googleusercontent.com/-_sojRrb_Qko/VvCRIvsfbDI/AAAAAAAAC8E/etF4qS59zvE/3-22-2016%2525202-18-44%252520AM_thumb%25255B10%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="3-22-2016 2-18-44 AM" width="687"></a></p> <ul> <li>To Further build the report drag and drop the measures and dimensions in the columns and rows.</li></ul> <p><br><a href="https://lh3.googleusercontent.com/-zxE6KbvknDc/VvCRJpV_fqI/AAAAAAAAC8I/FivljKhM9p8/s1600-h/3-22-2016%2525202-23-29%252520AM%25255B8%25255D.jpg"><img alt="3-22-2016 2-23-29 AM" border="0" height="359" src="https://lh3.googleusercontent.com/-5R9mNhggOPQ/VvCRKcDxjkI/AAAAAAAAC8M/RITa-bk7rPY/3-22-2016%2525202-23-29%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="3-22-2016 2-23-29 AM" width="692"></a></p>

Reporting on Analysis for Microsoft Excel

We have created the Analytic model to view the plantwise sales quantity.  Let see how to build the report using the view on Analysis for Mic...

Read more »

Creating Delivery Unit In SAP HANA

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="font-size: medium;"><strong><em>Creating Delivery Unit In SAP HANA</em></strong></span><br> <span style="font-size: medium;"><strong><em></em></strong></span><br> </div>

Creating Delivery Unit In SAP HANA

Creating Delivery Unit In SAP HANA

Read more »

Creating Package in SAP HANA

<p><strong><em> <font size="4">Creating Package in SAP HANA </font></em></strong></p> <ul> <li>  In the system view, right click and  choose New > Package</li></ul> <p>    <a href="https://lh3.googleusercontent.com/-XhhWfZUpZ98/VubH0M9t0aI/AAAAAAAAC4Y/Erlst5dPJCM/s1600-h/3-14-2016%25252012-42-07%252520PM%25255B2%25255D.jpg"><img alt="3-14-2016 12-42-07 PM" border="0" height="267" src="https://lh3.googleusercontent.com/-zEIp9ZZHc6s/VubH1X6Id5I/AAAAAAAAC4c/zcfaaHiFFvI/3-14-2016%25252012-42-07%252520PM_thumb%25255B2%25255D.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="3-14-2016 12-42-07 PM" width="344"></a></p> <ul> <li>Enter the package name and Description <li>Specify the delivery unit details or leave it blank. <li>Press ok </li></ul> <p>     <a href="https://lh3.googleusercontent.com/-HkVinVTZps0/VubH2dRXBkI/AAAAAAAAC4g/rEK4r0lDYPU/s1600-h/3-14-2016%25252012-43-18%252520PM%25255B4%25255D.jpg"><img alt="3-14-2016 12-43-18 PM" border="0" height="288" src="https://lh3.googleusercontent.com/-VgVMI189X7I/VubH3uohw7I/AAAAAAAAC4k/ArUDxLn0bKc/3-14-2016%25252012-43-18%252520PM_thumb%25255B4%25255D.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="3-14-2016 12-43-18 PM" width="407"></a></p> <ul> <li>In the system view,  Check the content folder created package will be listed.</li></ul> <p>      <a href="https://lh3.googleusercontent.com/-X1tWPMbbdUE/VubH4tfLEjI/AAAAAAAAC4o/vawLP_F94FI/s1600-h/3-14-2016%25252012-44-10%252520PM%25255B2%25255D.jpg"><img alt="3-14-2016 12-44-10 PM" border="0" height="314" src="https://lh3.googleusercontent.com/-MFwiBpqcNu4/VubH5qC1a-I/AAAAAAAAC4s/19W7-xRRMsI/3-14-2016%25252012-44-10%252520PM_thumb%25255B2%25255D.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="3-14-2016 12-44-10 PM" width="420"></a><strong><font size="4"><em></em></font></strong></p> <p><strong><font size="4"><em><a href="http://www.itstuffs.net/2016/03/creating-delivery-unit-in-sap-hana.html" target="_blank">Creating Delivery Unit In SAP HANA</a></em><em> – <font color="#ff0000">Click here</font></em></font></strong></p>

Creating Package in SAP HANA

  Creating Package in SAP HANA   In the system view, right click and  choose New > Package     Enter the package name and Descriptio...

Read more »

Generate Gregorian Time Data in SAP HANA

<div dir="ltr" style="text-align: left;" trbidi="on"> <strong><em><u><span style="font-size: medium;">Generate Time Data in SAP HANA – PART 2 ( Gregorian)</span></u></em></strong><br> Generate time data option helps to generate time date either by gregorian or fiscal calendar type. The generated time data can be used for Creating Time based Attribute views.<br> </div>

Generate Gregorian Time Data in SAP HANA

Generate Time Data in SAP HANA – PART 2 ( Gregorian) Generate time data option helps to generate time date either by gregorian or fiscal c...

Read more »

Generate Fiscal Year Time Data in SAP HANA

<p><strong><em><u><font size="4">Generate Time Data in SAP HANA – PART 1 ( Fiscal )</font></u></em></strong></p> <p>Generate time data option helps to generate time date either by gregorian or fiscal calendar type. The generated time data can be used for Creating Time based Attribute views.</p> <p>1) Go to the Modeler quick view, then select <strong>Generate Time Data</strong></p> <p><a href="https://lh3.googleusercontent.com/-v8WYy3FJVMQ/VuZw4Aqbj1I/AAAAAAAAC2A/KKE9dXWx0Ek/s1600-h/3-13-2016%2525204-46-25%252520PM%25255B13%25255D.jpg"><img alt="3-13-2016 4-46-25 PM" border="0" height="303" src="https://lh3.googleusercontent.com/-RXJdrFemQxk/VuZw5ONwjaI/AAAAAAAAC2E/x1tARky5e_8/3-13-2016%2525204-46-25%252520PM_thumb%25255B13%25255D.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="3-13-2016 4-46-25 PM" width="235"></a></p> <p>2) Select the System. Press next.</p> <p><a href="https://lh3.googleusercontent.com/-CW290WFYXEQ/VuZw6QlTiQI/AAAAAAAAC2I/Ee9HpfPGz_8/s1600-h/3-13-2016%2525204-46-46%252520PM%25255B6%25255D.jpg"><img alt="3-13-2016 4-46-46 PM" border="0" height="287" src="https://lh3.googleusercontent.com/-9Sslt7CctOY/VuZw7Za0KfI/AAAAAAAAC2M/CQzmUasjRfo/3-13-2016%2525204-46-46%252520PM_thumb%25255B6%25255D.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="3-13-2016 4-46-46 PM" width="299"></a></p> <p>In generate time data screen two calendar type option will be available.</p> <p><strong><font size="3">Calendar type :  Gregorian, Fiscal</font></strong></p> <p><strong><em><u><font size="5">Fiscal year Time generation</font></u></em></strong></p> <ul> <li>Select Fiscal from the calendar type <li>Specify the From year and To year.  For ex: <strong>2009 to 2010 </strong>( which will generate every single date from 2009 to 2010 ) <li>Variant Schema Select the Schema. ( Table <strong>T009</strong> from SAP ECC should be replicated to the Schema) <li>In the Variant specify the fiscal year variant to be generated. For ex :  <strong>K4 : 800</strong>  (K4- Fiscal Variant, 800 – Client ) <li>Press Finish to generate.</li></ul> <p>      <a href="https://lh3.googleusercontent.com/-PelNmmSsnz0/VuZw8RR8e2I/AAAAAAAAC2Q/M94WR1dvh5E/s1600-h/3-13-2016%2525205-13-20%252520PM%25255B2%25255D.jpg"><img alt="3-13-2016 5-13-20 PM" border="0" height="389" src="https://lh3.googleusercontent.com/-6ZhX8x4Dyak/VuZw9kOCB_I/AAAAAAAAC2U/l743mD38AVo/3-13-2016%2525205-13-20%252520PM_thumb%25255B2%25255D.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="3-13-2016 5-13-20 PM" width="326"></a></p> <ul> <li>The generated time data can be verified in  Schema : <strong>_SYS _BI</strong>  Table:<strong> M_FISCAL_CALENDAR</strong></li></ul> <p>     <a href="https://lh3.googleusercontent.com/-GJzx3X2Ao44/VuZw_ZbRDWI/AAAAAAAAC2Y/5UVE1ExC1uk/s1600-h/3-14-2016%2525208-41-04%252520AM%25255B1%25255D.jpg"><img alt="3-14-2016 8-41-04 AM" border="0" height="347" src="https://lh3.googleusercontent.com/-vvI4u3uGcnc/VuZxAkaw1TI/AAAAAAAAC2c/TzhNFHM7DsY/3-14-2016%2525208-41-04%252520AM_thumb%25255B1%25255D.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="3-14-2016 8-41-04 AM" width="644"></a></p> <p><em> <strong>Fiscal year Variant reference :</strong></em></p> <p><strong> </strong>Fiscal year variant reference in SAP ECC (T-code : OB29 ) and replicated table in HANA.(Table : T009 )</p> <p><strong> <a href="https://lh3.googleusercontent.com/-Cq28Nlw-JzU/VuZxCI7DjHI/AAAAAAAAC2g/Vq6MWk9YE6A/s1600-h/3-14-2016%2525208-33-05%252520AM%25255B1%25255D.jpg"><img alt="3-14-2016 8-33-05 AM" border="0" height="240" src="https://lh3.googleusercontent.com/-qAEBHxb1q88/VuZxDPsSLYI/AAAAAAAAC2k/xil22GEvO2w/3-14-2016%2525208-33-05%252520AM_thumb%25255B1%25255D.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="3-14-2016 8-33-05 AM" width="358"></a><a href="https://lh3.googleusercontent.com/-Bf31UD-wU1U/VuZxEZgidcI/AAAAAAAAC2o/2QaszgUyPa0/s1600-h/3-14-2016%2525208-30-59%252520AM%25255B5%25255D.jpg"><img alt="3-14-2016 8-30-59 AM" border="0" height="238" src="https://lh3.googleusercontent.com/-63FfU_IXH_s/VuZxFYTM5YI/AAAAAAAAC2s/D0fHQDwAqFs/3-14-2016%2525208-30-59%252520AM_thumb%25255B5%25255D.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="3-14-2016 8-30-59 AM" width="277"></a></strong></p> <p><font size="5"><strong><em><u>Gregorian Time Generation</u></em></strong></font></p>

Generate Fiscal Year Time Data in SAP HANA

Generate Time Data in SAP HANA – PART 1 ( Fiscal ) Generate time data option helps to generate time date either by gregorian or fiscal cale...

Read more »