tag:blogger.com,1999:blog-48936614051443281742024-02-20T14:02:15.324-08:00SAP BI/BW NotesSap BI/BW and Business Objects Tips and TricksRajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-4893661405144328174.post-5189871296367609422010-09-13T05:01:00.000-07:002010-09-13T05:01:01.329-07:00TCODES for SAP BI/BW<col style="width: 48pt;" width="64"></col> <col style="mso-width-alt: 841; mso-width-source: userset; width: 17pt;" width="23"></col> <col style="mso-width-alt: 8667; mso-width-source: userset; width: 178pt;" width="237"></col><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl24" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87"><a href="" name="RANGE!A1:C127">Tcode</a></td> <td class="xl25" style="border-left: none; width: 178pt;" width="237">Description</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">DB02</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Tables and Indexes Monitor</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">DB14</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Display DBA Operation Logs</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">DB16</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Display DB Check Results</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">DB20</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Update DB Statistics</td> </tr><br />
<tr height="29" style="height: 21.75pt;"> <td class="xl26" colspan="2" height="29" style="border-right: 1.0pt solid silver; height: 21.75pt; width: 65pt;" width="87">KEB2</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">DISPLAY DETAILED INFO ON CO-PA DATA SOURCE R3</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">LISTCUBE</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">List viewer for InfoCubes</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">LISTSCHEMA</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Show InfoCube schema</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">LBWE</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">LO Data Extraction: Customizing Cockpit</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">LBWF</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BW Log</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">LBWG</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">To Delete Setup Tables</td> </tr><br />
<tr height="29" style="height: 21.75pt;"> <td class="xl26" colspan="2" height="29" style="border-right: 1.0pt solid silver; height: 21.75pt; width: 65pt;" width="87">OLI*BW</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">To fill Setup Tables (* Application Component) [ie 7 for SD Sales Orders]</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">OS06</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Local Operating System Activity</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">OB08</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Currency Exchange Rates</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA1</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Administrator Work Bench</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA2</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">OLTP Metadata Repository</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA3</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Extractor Checker</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA5</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Install Business Content</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA6</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintain DataSources</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA7</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BW Delta Queue Monitor</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA8</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">DataSource Repository</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA9</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Transfer Application Components</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA11</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Calling up AWB with the IC tree</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA12</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Calling up AWB with the IS tree</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA13</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Calling up AWB with the LG tree</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA14</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Calling up AWB with the IO tree</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSA15</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Calling up AWB with the ODS tree</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSBBS</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintain Query Jumps (RRI Interface)</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSBICA</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Modeling BI Integrated Planning</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSCUSTA</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintain BW Settings</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSCUSTA2</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">ODS Settings</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSCUSTV*</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237"> </td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSD1</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Characteristic maintenance</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSD2</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintenance of key figures</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSD3</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintenance of units</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSD4</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintenance of time characteristics</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSD5</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Edit InfoObjects</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDBC</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">DB connect</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDCUBE</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start: InfoCube editing</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDCUBED</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start: InfoCube editing</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDCUBEM</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start: InfoCube editing</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDDBIAMON</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BI Accelerator Monitor</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDDV</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintaining</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDIOBC</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start: InfoObject catalog editing</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDIOBCD</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start: InfoObject catalog editing</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDIOBCM</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start: InfoObject catalog editing</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDL</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">DB Connect - Test Program</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDMD</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Master Data Maintenance w.Prev. Sel.</td> </tr><br />
<tr height="18" style="height: 13.5pt; page-break-before: always;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDMD_TEST</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Master Data Test</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDMPRO</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Initial Screen: MultiProvider Proc.</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDMPROD</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Initial Screen: MultiProvider Proc.</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDMPROM</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Initial Screen: MultiProvider Proc.</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDMWB</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Customer Behavior Modeling</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDODS</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Initial Screen: ODS Object Processing</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSDS</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Data Source Repository</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSIMPCUR</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Load Exchange Rates from File</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSINPUT</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Manual Data Entry</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSIS1</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Create InfoSource</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSIS2</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Change InfoSource</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSIS3</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Display InfoSource</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSISET</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintain InfoSets</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSKC</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintaining the Permitted Extra Chars</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSLGMP</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Maintain RSLOGSYSMAP</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSMO</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Data Load Monitor Start</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSMON</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BW Administrator Workbench</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSOR</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BW Metadata Repository</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSORBCT</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BI Business Content Transfer</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSORMDR</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BW Metadata Repository</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSPC</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Process Chain Maintenance</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSPC1</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Process Chain Display</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSPCM</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Monitor daily process chains</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSPLAN</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Modeling BI Integrated Planning</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSPLSE</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BI Planning Lock Management</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSRCACHE</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">OLAP: Cache Monitor</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSRT</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start of the report monitor</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSRT1</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start of the Report Monitor</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSRT2</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Start of the Report Monitor</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSRTRACE</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Set trace configuration</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSRTRACETEST</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Trace tool configuration</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSRV</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Analysis and Repair of BW Objects</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RSSM</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Authorizations for Reporting</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">RZ20</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">To see log for Process Chains</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE03</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Transport Organizer Tools</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE06</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Set Up Transport Organizer</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE07</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">CTS Status Display</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE09</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Transport Organizer</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE10</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Transport Organizer</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE11</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">ABAP Dictionary</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE18</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Business Add-Ins: Definitions</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE18_OLD</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Business Add-Ins: Definitions (Old)</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE19</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Business Add-Ins: Implementations</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE19_OLD</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Business Add-Ins: Implementations</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE21</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Package Builder</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE24</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Class Builder</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE80</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Object Navigator</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SE93</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">to view Transaction Codes</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM04</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">User List</td> </tr><br />
<tr height="18" style="height: 13.5pt; page-break-before: always;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM12</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Display and Delete Locks</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM21</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Online System Log Analysis</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM37</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Overview of job selection</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM50</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Work Process Overview</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM51</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">List of SAP Systems</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM58</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Asynchronous RFC Error Log</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM59</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">RFC Destinations (Display/Maintain)</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SM66</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Global work process Monitor</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SMQ1</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">qRFC Monitor (Outbound Queue)</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">SMQ2</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">qRFC Monitor (Inbound Queue)</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">ST22</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">ABAP Runtime Error (Dumps)</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">ST14</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">BW Evaluation Application Analysis</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE02</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Display IDoc</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE05</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">IDoc Lists</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE06</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Active IDoc monitoring</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE07</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">IDoc statistics</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE08</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Status File Interface</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE09</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Search for IDoc in Database</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE10</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Search for IDoc in Archive</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE11</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Delete IDocs</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE12</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Test Modified Inbound File</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE14</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Test Outbound Processing</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE15</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Test Outbound Processing from MC</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE16</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Test Inbound File</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE17</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Test Status File</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE18</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Generate Status File</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE19</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Test tool</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE20</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Partner Profiles</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE21</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Port definition</td> </tr><br />
<tr height="18" style="height: 13.5pt;"> <td class="xl26" colspan="2" height="18" style="border-right: 1.0pt solid silver; height: 13.5pt; width: 65pt;" width="87">WE23</td> <td class="xl27" style="border-left: none; border-top: none; width: 178pt;" width="237">Verification of IDoc processing<!--
<rdf:RDF xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:dc="http://purl.org/dc/elements/1.1/"
xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/"> <rdf:Description
rdf:about="http://wiki.sdn.sap.com/wiki/display/BI/BI+FAQ+-+Important+Transaction+Codes+in+SAP+Business+Intelligence"
dc:identifier="http://wiki.sdn.sap.com/wiki/display/BI/BI+FAQ+-+Important+Transaction+Codes+in+SAP+Business+Intelligence"
dc:title="BI FAQ - Important Transaction Codes in SAP Business Intelligence"
trackback:ping="http://wiki.sdn.sap.com/wiki/rpc/trackback/52976"/> </rdf:RDF> --></td></tr>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comtag:blogger.com,1999:blog-4893661405144328174.post-81663368794027152912010-09-13T03:58:00.001-07:002010-09-13T04:20:35.951-07:00LO CockPit - How To<div class="MsoNormal">LO Cockpit provides single point to enhance, schedule, extract and transfer logistics data from SAP source system (SAP R/3 / SAP ECC) to SAP BW system.</div><div class="MsoNormal"><br />
</div><div class="MsoNormal">The cockpit displays various extract structures grouped by various application areas as shown in the figure below.</div><div class="MsoNormal"><br />
</div><table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/_iLJ2Uavmamk/TI4ICtWM18I/AAAAAAAADMs/UPO_ld6V92k/s1600/LBWE.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="232" src="http://3.bp.blogspot.com/_iLJ2Uavmamk/TI4ICtWM18I/AAAAAAAADMs/UPO_ld6V92k/s400/LBWE.png" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">LO Cockpit</td></tr>
</tbody></table><div class="MsoNormal"><br />
</div><div class="MsoNormal">The transaction code to access the LO Cockpit is LBWE.</div><div class="MsoNormal"><br />
</div><div class="MsoNormal">The following are the steps to extract LO data using the Cockpit.</div><div class="MsoNormal"><br />
</div><ol start="1" style="margin-top: 0in;" type="1"><li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Activate the relevant DataSource.</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Replicate DataSource in BW</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Hook up the DataSource to corresponding InfoSource in BW</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Maintain the Extract Structure</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Activate the Extract Structure</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Delete the contents of the setup tables by running Tcode LBWG</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Run the setup job for relevant extractor</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Schedule delta initial load from BW system</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Select desired update method (V3) for the DataSource.</li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; tab-stops: list .5in;">Start executing the delta loads.</li>
</ol>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comtag:blogger.com,1999:blog-4893661405144328174.post-50055250328471663982010-09-08T23:51:00.000-07:002010-09-09T03:58:36.440-07:00Important Tables for SAP MM<div style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;">Below are few important Common Tables used in Materials Management Modules:</div><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre>EINA Purchasing Info Record- General Data
EINE Purchasing Info Record- Purchasing Organization Data
MAKT Material Descriptions
MARA General Material Data
MARC Plant Data for Material
MARD Storage Location Data for Material
MAST Material to BOM Link
MBEW Material Valuation
MKPF Header- Material Document
MSEG Document Segment- Material
MVER Material Consumption
MVKE Sales Data for materials
RKPF Document Header- Reservation
T023 Mat. groups
T024 Purchasing Groups
T156 Movement Type
T157H Help Texts for Movement Types
MOFF Lists what views have not been created
A501 Plant/Material
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EKAB Release Documentation
EKBE History per Purchasing Document
EKET Scheduling Agreement Schedule Lines
EKKN Account Assignment in Purchasing Document
EKKO Purchasing Document Header
EKPO Purchasing Document Item
IKPF Header- Physical Inventory Document
ISEG Physical Inventory Document Items
LFA1 Vendor Master (General section)
LFB1 Vendor Master (Company Code)
NRIV Number range intervals
RESB Reservation/dependent requirements
T161T Texts for Purchasing Document Types </pre></span><span class="Apple-style-span" style="color: #990000;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><b><br />
</b></span></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre>Following are the list of Important MM tables.
Inventory Management:
|-------------------------+--------+-----------------------------------------|
| | Table | Description |
|-------------------------+--------+-----------------------------------------|
| Material | MSEG | Material document / transaction details |
| Document/Movements | MKPF | Material document header information |
|-------------------------+--------+-----------------------------------------|
| Material Stock Balances | MARD | Material stock |
| | MBEW | Material stock with valuation |
|-------------------------+--------+-----------------------------------------|
| Sales Order Stock | MSKA | Stock balance with associated sales |
| | | order data |
|-------------------------+--------+-----------------------------------------|
| Stock Transport | EKUB | Index for Stock Transport Orders for |
| | MDUB | Material |
| | | Reading View of Stock Transport Ord. for|
| | | Release Ord. |
|-------------------------+--------+-----------------------------------------|
| Special Stocks | MKOL | Consignment, material provided to |
| | | vendor, etc. |
|-------------------------+--------+-----------------------------------------|
Material Master Data:
|-------------------------+---------+--------------------------------------|
| |Table | Description |
|-------------------------+---------+--------------------------------------|
| Materials | MARA | General Data, material type, group, |
| | | configurable & batch ind. |
| | MAKT | Short Texts, descriptions |
| | MARM | Conversion Factors |
| | MVKE | Sales Org, distribution channel |
| | MLAN | Sales data, tax indicator, tax |
| | MARC | classification |
| | MBEW | Plant Planning Data |
| | MLGN | Valuation Data |
| | MLGT | Warehouse Management Inventory Data |
| | MVER | Warehouse Management Storage Type |
| | MAPR | Data |
| | MARD | Consumption Data |
| | MCHA | Pointer for Forecast Data |
| | MCHB | Storage location data with stock |
| | | balances |
| | | Batches |
| | | Batch Stocks |
|-------------------------+---------+--------------------------------------|</pre></span>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comtag:blogger.com,1999:blog-4893661405144328174.post-91150076980568799842010-09-08T23:47:00.000-07:002010-09-09T04:04:51.367-07:00Important Tables for SAP SD<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<pre><span style="color: black;"><b>Sales and Distribution:
</b> <b>Table Description
</b>Customers KNA1 General Data
KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)
KNB4 Customer Payment History
KNB5 Customer Master – Dunning info
KNBK Customer Master Bank Data
KNKA Customer Master Credit Mgmt.
KNKK Customer Master Credit Control Area Data (credit limits)
KNVV Sales Area Data (terms, order probability)
KNVI Customer Master Tax Indicator
KNVP Partner Function key
KNVD Output type
KNVS Customer Master Ship Data
KLPA Customer/Vendor Link
Sales Documents VBAKUK VBAK + VBUK
VBUK Header Status and Administrative Data
VBAK Sales Document - Header Data
VBKD Sales Document - Business Data
VBUP Item Status
VBAP Sales Document - Item Data
VBPA Partners
VBFA Document Flow
VBEP Sales Document Schedule Line
VBBE Sales Requirements: Individual Records
SD Delivery DocumeLIPS Delivery Document item data, includes referencing PO
LIKP Delivery Document Header data
Billing Document VBRK Billing Document Header
VBRP Billing Document Item
SD Shipping Unit VEKP Shipping Unit Item (Content)
VEPO Shipping Unit Header</span></pre><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><ins style="border-bottom-style: none; border-color: initial; border-left-style: none; border-right-style: none; border-top-style: none; border-width: initial; display: inline-table; height: 90px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; position: relative; visibility: visible; width: 728px;"></ins></span>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comtag:blogger.com,1999:blog-4893661405144328174.post-12439798436872468172010-09-08T23:45:00.000-07:002010-09-09T04:06:15.370-07:00Important Tables in SAP AA<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<pre><b><span style="color: black;"><span class="Apple-style-span" style="font-size: x-small;">I-AA-AA (AA) Asset Accounting: Basic Functions – Master Data
</span></span></b><span style="color: black;"><span class="Apple-style-span" style="font-size: x-small;">
ANKA Asset Classes: General Data ANLKL
ANKP Asset Classes: Fld Cont Dpndnt on Chart ANLKL / AFAPL
of Depreciation
ANKT Asset Classes: Description SPRAS / ANLKL
ANKV Asset Classes: Insurance Types ANLKL / VRSLFD
ANLA Asset Master Record Segment BUKRS / ANLN1 / ANLN2
ANLB Depreciation Terms BUKRS / ANLN1 / ANLN2 / AFABE
/ BDATU
ANLT Asset Texts SPRAS / BUKRS / ANLN1 / ANLN2
ANLU Asset Master Record User Fields .INCLUDE / BUKRS / ANLN1 / ANLN2
ANLW Insurable Values (Year Dependent) BUKRS / ANLN1 / ANLN2 / VRSLFD /
GJAHR
ANLX Asset Master Record Segment BUKRS / ANLN1 / ANLN2
ANLZ Time Dependent Asset Allocations BUKRS / ANLN1 / ANLN2 / BDATU</span></span></pre><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span style="color: black;"><span class="Apple-style-span" style="font-size: x-small;">FI-AA-AA (AA2) Asset Accounting: Basic Functions – Master Data 2.0
</span></span></b><span style="color: black;"><span class="Apple-style-span" style="font-size: x-small;">
ANAR Asset Types ANLAR
ANAT Asset Type Text SPRAS / ANLAR
FI-AA-AA (AB) Asset Accounting: Basic Functions –
Asset Accounting
ANEK Document Header Asset Posting BUKRS / ANLN1 / ANLN2 / GJAHR /
LNRAN
ANEP Asset Line Items BUKRS / ANLN1 / ANLN2 / GJAHR /
LNRAN / AFABE
ANEV Asset Downpymt Settlement BUKRS / ANLN1 / ANLN2 / GJAHR /
LNRANS
ANKB Asset Class: Depreciation Area ANLKL / AFAPL / AFABE / BDATU
ANLC Asset value Fields BUKRS / ANLN1 / ANLN2 / GJAHR /
AFABE
ANLH Main Asset Number BUKRS / ANLN1
ANLP Asset Periodic Values BUKRS / GJAHR / PERAF / AFBNR /
ANLN1 / ANLN2 / AFABER</span></span></pre></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span style="color: black;"><span class="Apple-style-span" style="font-size: x-small;">FI-SL-VSR (GVAL) Special Purpose Ledger: Validation, Substitution and Rules
</span></span></b><span style="color: black;"><span class="Apple-style-span" style="font-size: x-small;">
GB03 Validation / Substitution User VALUSER
GB92 Substitutions SUBSTID
GB93 Validation VALID</span></span></pre></span>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comtag:blogger.com,1999:blog-4893661405144328174.post-37322854443101882152010-09-08T23:43:00.000-07:002010-09-09T04:08:12.874-07:00Important Tables in SAP CO<div style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><b><span class="Apple-style-span" style="font-size: x-small;">Controlling</span></b></div><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">Table Name Description Important Fields</span></b></pre></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><span class="Apple-style-span" style="font-size: x-small;">AUSP Characteristic Values MANDT / OBJEK / ATINN / ATZHL</span></pre></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">CO-KBAS Overhead Cost Controlling
</span></b><span class="Apple-style-span" style="font-size: x-small;">A132 Price per Cost Center MANDT / KAPPL / KSCHL / KOKRS
A136 Price per Controlling Area MANDT / KAPPL / KSCHL / KOKRS
A137 Price per Country / Region MANDT / KAPPL / KSCHL / KOKRS
COSC CO Objects: Assignment of Origina MANDT / OBJNR / SCTYP / VERSN
CSSK Cost Center / Cost Element MANDT / VERSN / KOKRS / GJAHR
CSSL Cost Center / Activity Type MANDT / KOKRS / KOSTL / LSTAR
KAPS CO Period Locks MANDT / KOKRS / GJAHR / VERSN
</span><b><span class="Apple-style-span" style="font-size: x-small;">CO-KBASCORE Overhead Cost Controlling: General Services
</span></b><span class="Apple-style-span" style="font-size: x-small;">CSKA Cost Elements (Data Dependent on MANDT / KTOPL / KSTAR
CSKB Cost Elements (Data Dependent on MANDT / KOKRS / KSTAR / DATBI
CSKS Cost Center Master Data MANDT / KOKRS / KOSTL / DATBI
CSLA Activity Master MANDT / KOKRS / LSTAR / DATBI</span></pre></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">CO-OM (KACC) Overhead Cost Controlling
</span></b><span class="Apple-style-span" style="font-size: x-small;">COBK CO Object: Document Header MANDT / KOKRS / BELNR
COEJ CO Object: Line Items (by Fiscal MANDT / KOKRS / BELNR / BUZEI
COEJL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEJR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEJT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI
COEP CO Object: Line Items (by Period) MANDT / KOKRS / BELNR / BUZEI
COEPL CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEPR CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEPT CO Object: Line Items for Prices MANDT / KOKRS / BELNR / BUZEI
COKA CO Object: Control Data for Cost MANDT / OBJNR / GJAHR / KSTAR
COKL CO Object: Control Data for Activ MANDT / LEDNR / OBJNR / GJAHR
COKP CO Object: Control Data for Prima MANDT / LEDNR / OBJNR / GJAHR
COKR CO Object: Control Data for Stati MANDT / LEDNR / OBJNR / GJAHR
COKS CO Object: Control Data for Secon MANDT / LEDNR / OBJNR / GJAHR</span></pre></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">CO-OM-CEL (KKAL) Cost Element Accounting (Reconciliation Ledger)
</span></b><span class="Apple-style-span" style="font-size: x-small;">COFI01 Object Table for Reconciliation L MANDT / OBJNR
COFI02 Transaction Dependent Fields for MANDT / OBJNR
COFIP Single Plan Items for Reconciliat RCLNT / GL_SIRID
COFIS Actual Line Items for Reconciliat RCLNT / GL_SIRID
</span><b><span class="Apple-style-span" style="font-size: x-small;">CO-OM-CCA Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S
</span></b><span class="Apple-style-span" style="font-size: x-small;">A138 Price per Company Code MANDT / KAPPL / KSCHL / KOKRS
A139 Price per Profit Center MANDT / KAPPL / KSCHL / KOKRS</span></pre></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">CO-OM-OPA (KABR) Overhead Orders: Application Development R/3 Cost Accounting Settlement
</span></b><span class="Apple-style-span" style="font-size: x-small;">AUAA Settlement Document: Receiver Seg MANDT / BELNR / LFDNR
AUAB Settlement Document: Distribution MANDT / BELNR / BUREG / LFDNR
AUAI Settlement Rules per Depreciation MANDT / BELNR / LFDNR / AFABE
AUAK Document Header for Settlement MANDT / BELNR
AUAO Document Segment: CO Objects to b MANDT / BELNR / LFDNR
AUAV Document Segment: Transactions MANDT / BELNR / LFDNR
COBRA Settlement Rule for Order Settlem MANDT / OBJNR
COBRB Distribution Rules Settlement Rul MANDT / OBJNR / BUREG / LFDNR</span></pre></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">CO-OM-OPA (KAUF) Overhead Orders: Cost Accounting Orders
</span></b><span class="Apple-style-span" style="font-size: x-small;">AUFK Order Master Data MANDT / AUFNR
AUFLAY0 Enttity Table: Order Layouts MANDT / LAYOUT</span></pre></span><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">EC-PCA (KE1) Profit Center Accounting
</span></b><span class="Apple-style-span" style="font-size: x-small;">CEPC Profit Center Master Data Table MANDT / PRCTR / DATBI / KOKRS
CEPCT Texts for Profit Center Master Da MANDT / SPRAS / PRCTR / DATBI
CEPC_BUKRS Assignment of Profit Center to a MANDT / KOKRS / PRCTR / BUKRS
GLPCA EC-PCA: Actual Line Items RCLNT / GL_SIRID
GLPCC EC-PCA: Transaction Attributes MANDT / OBJNR
GLPCO EC-PCA: Object Table for Account MANDT / OBJNR
GLPCP EC-PCA: Plan Line Items RCLNT / GL_SIRID
</span><b><span class="Apple-style-span" style="font-size: x-small;">EC-PCA BS (KE1C) PCA Basic Settings: Customizing for Profit Center Accounting
</span></b><span class="Apple-style-span" style="font-size: x-small;">A141 Dependent on Material and Receive MANDT / KAPPL / KSCHL / KOKRS
A142 Dependent on Material MANDT / KAPPL / KSCHL / WERKS
A143 Dependent on Material Group MANDT / KAPPL / KSCHL / WERKS</span></pre></span>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comtag:blogger.com,1999:blog-4893661405144328174.post-3514992845664808812010-09-08T23:40:00.000-07:002010-09-09T04:09:27.593-07:00Important Tables in SAP FI<div style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><b><span class="Apple-style-span" style="font-size: x-small;">Financial Accounting</span></b></div><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">Table Name Description Important Fields</span></b></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">Financial Accounting</span></b></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><span class="Apple-style-span" style="font-size: x-small;">FBAS Financial Accounting “Basis”
BKPF Accounting Document Header BUKRS / BELNR / GJAHR
BSEG Accounting Document Segment BUKRS / BELNR / GJAHR / BUZEI
BSIP Index for Vendor Validation of Double BUKRS / LIFNR / WAERS / BLDAT /
Documents XBLNR / WRBTR / BELNR / GJAHR / BUZEI
BVOR Inter Company Posting Procedure BVORG / BUKRS / GJAHR / BELNR
EBKPF Accounting Document Header (docs from GLSBK / BELNR / GJHAR / GLEBK
External Systems)
FRUN Run Date of a Program PRGID
KLPA Customer / Vendor Linking NKULI / NBUKR / NKOAR / PNTYP
/ VKULI / VBUKR / VKOAR
KNB4 Customer Payment History KUNNR / BUKRS
KNB5 Customer Master Dunning Data KUNNR / BUKRS / MABER
KNBK Customer Master Bank Details KUNNR / BANKS / BANKL / BANKN
KNC1 Customer Master Transaction Figures KUNNR / BUKRS / GJHAR
KNC3 Customer Master Special GL Transactions KUNNR / BUKRS / GJAHR / SHBKZ
Figures
LFB5 Vendor Master Dunning Data LIFNR / BUKRS / MABER
LFBK Vendor Master Bank Details LIFNR / BANKS / BANKL / BANKN
LFC1 Vendor Master Transaction Figures LIFNR / BUKRS / GJHAR
LFC3 Vendor Master Special GL Transactions LIFNR / BUKRS / GJHAR / SHBKZ
Figures
VBKPF Document Header for Document Parking AUSBK / BUKRS / BELNR / GJHAR</span></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">FBASCORE Financial Accounting General Services “Basis”</span></b></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><span class="Apple-style-span" style="font-size: x-small;">KNB1 Customer Master (Company Code) KUNNR / BUKRS
LFA1 Vendor Master (General Section) LIFNR
LFB1 Vendor Master (company Code Section) LIFNR / BUKRS
SKA1 G/L Account Master (Chart of Accounts) KTOPL / SAKNR
SKAT G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR
Description)
MAHNS Accounts Blocked by Dunning Selection KOART / BUKRS / KONKO / MABER
MHNK Dunning Data (Account Entries) LAUFD / LAUFI / KOART / BUKRS /
KUNNR / LIFNR / CPDKY / SKNRZE /
SMABER / SMAHSK / BUSAB</span></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">FI-GL-GL (FBS) General Ledger Accounting: Basic Functions- G/L Accounts</span></b></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><span class="Apple-style-span" style="font-size: x-small;">SKAS G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR / SCHLW
Key Word list)
SKB1 G/L Account Master (Company Code) BUKRS / SAKNR
FI-GL-GL (FBSC) General Ledger Accounting: Basic
Functions - R/3 Customizing for G/L Accounts
FIGLREP Settings for G/L Posting Reports MANDT
TSAKR Create G/L account with reference BUKRS / SAKNR
FI-GL-GL (FFE) General Ledger Accounting: Basic
Functions - Fast Data Entry
KOMU Account Assignment Templates for G/L KMNAM / KMZEI
Account items</span></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">FI-AR-AR (FBD) Accounts Receivable: Basic Functions - Customers
</span></b><span class="Apple-style-span" style="font-size: x-small;">
KNKA Customer Master Credit Management : KUNNR
Central Data
KNKK Customer Master Credit Management : KUNNR / KKBER
Control Area Data
KNKKF1 Credit Management : FI Status data LOGSYS / KUNNR / KKBER / REGUL
RFRR Accounting Data – A/R and A/P RELID / SRTFD / SRTF2
Information System</span></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">FI-BL-PT Bank Accounting: Payment (BFIBL_CHECK_D) Transactions – General Sections</span></b></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><span class="Apple-style-span" style="font-size: x-small;">PAYR Payment Medium File ZBUKR / HBKID / HKTID / RZAWE /
CHECT
PCEC Pre-numbered Check ZBUKR / HBKID / HKTID / STAPL</span></pre></span><span class="Apple-style-span" style="font-size: x-small;"><span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"></span><br />
<span class="Apple-style-span" style="-webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><pre><b><span class="Apple-style-span" style="font-size: x-small;">FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments
</span></b><span class="Apple-style-span" style="font-size: x-small;">
F111G Global Settings for Payment Program for MANDT
Payment Requests
FDZA Cash Management Line Items in Payment KEYNO
Requests
PAYRQ Payment Requests KEYNO</span></pre></span>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comtag:blogger.com,1999:blog-4893661405144328174.post-19141421996956393262010-09-08T05:01:00.001-07:002010-09-09T04:10:23.603-07:00Common SAP BW Transactions<span class="Apple-style-span" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 12px; line-height: 16px;"></span><br />
<span class="Apple-style-span" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 12px; line-height: 16px;"><div class="blog-posts hfeed"><div class="date-outer"><div class="date-posts"><div class="post-outer"><div class="post hentry" style="margin-bottom: 25px; margin-left: 0px; margin-right: 0px; margin-top: 0px; min-height: 0px; position: relative;"><div class="post-body entry-content" style="font-size: 13px; line-height: 1.4; position: relative; width: 420px;"><span style="font-family: arial;"><br />
1) SBIW: Data Transfer to SAP BW<br />
2) RSA1: Admin Workbench Modelling<br />
3) RSZV: Maintain Variable for BEx Analyser<br />
4) RSSM: BW Authorization<br />
5) RSO2: Maintain Generic Data Sources<br />
6) RSA7: BW Delta Queue Maintenance<br />
7) RSA3: Data Extractor Check<br />
8) RSA5: Installation of Data Sources from Business Content<br />
9) LISTCUBE: To display content of Info Providers<br />
10) RSCUSTA: Set User ID for Source System Communication<br />
11) RSKC: Permitted Characters<br />
12) SNUM: Number ranges for Transfer Structure<br />
13) SM62: Define Event<br />
14) RSMO: Evaluation of Requests<br />
<br />
General SAP Transactions:<br />
<br />
1) SE11: ABAP Dictionary (Create, Change, Display Table, View, Data Elements, etc.)<br />
2) SE16: Data Browser for Table and View<br />
3) SU01: User Maintenance<br />
4) PFCG: Role Maintenance<br />
5) SPRO: Customizing<br />
6) SE80: Object Navigator<br />
7) SE93: To check transaction codes available<br />
8) STMS: Transport Management<br />
9) SE09: Transport Organiser</span><br />
<div style="clear: both;"></div></div><div class="post-footer" style="background-color: #fefefe; border-bottom-color: rgb(243, 243, 243); border-bottom-style: solid; border-bottom-width: 1px; color: #7f7f7f; font-size: 11px; line-height: 1.6; margin-bottom: 0px; margin-left: -2px; margin-right: -2px; margin-top: 20px; padding-bottom: 5px; padding-left: 10px; padding-right: 10px; padding-top: 5px;"><div class="post-footer-line post-footer-line-1"><span class="post-icons"></span></div><div class="post-footer-line post-footer-line-2"></div><div class="post-footer-line post-footer-line-3"></div></div></div><div class="comments" id="comments" style="min-height: 0px; position: relative;"><a href="" name="comments"></a><br />
<div id="backlinks-container"><div id="Blog1_backlinks-container"></div></div></div></div></div></div></div><div class="blog-pager" id="blog-pager" style="margin-bottom: 1em; margin-left: 0px; margin-right: 0px; margin-top: 1em; overflow-x: hidden; overflow-y: hidden; text-align: center;"></div></span>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.comtag:blogger.com,1999:blog-4893661405144328174.post-70897514125617624612010-09-08T04:58:00.000-07:002010-09-09T04:12:16.048-07:00Naming Convention in SAP BW<span class="Apple-style-span" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 12px; line-height: 16px;"></span><br />
<span class="Apple-style-span" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 12px; line-height: 16px;"></span><br />
<span class="Apple-style-span" style="font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 12px; line-height: 16px;"><div class="blog-posts hfeed"><div class="date-outer"><div class="date-posts"><div class="post-outer"><div class="post hentry" style="margin-bottom: 25px; margin-left: 0px; margin-right: 0px; margin-top: 0px; min-height: 0px; position: relative;"><div class="post-body entry-content" style="font-size: 13px; line-height: 1.4; position: relative; width: 420px;"><span style="font-family: arial;">AP BW has a naming convention related to its objects.<br />
<br />
SAP BW prefixes /BIO/ to the names of Business Content database objects. It prefixes /BIC/ to the database objects created by users.<br />
<br />
If a user creates characteristics type info object ZPRODUCT and activates it, information will be stored in following:<br />
<br />
Data element: /BIC/IOZPRODUCT<br />
SID table: /BIC/SZPRODUCT<br />
Master data table: /BIC/PZPRODUCT<br />
Text table: /BIC/TZPRODUCT<br />
View: /BIC/MZPRODUCT<br />
<br />
When an info cube ZSALES is created and activated, information will be stored in following:<br />
<br />
View Fact table: /BIC/VZSALESF<br />
Transparent Fact table: /BIC/FZSALES<br />
Dimension tables: /BIC/DZSALES1 to /BIC/DZSALESN where N being no. of dimensions<br />
/BIC/DZSALESP, /BIC/DZSALEST, /BICDZALESU for Data Packet, Unit & Time (maximum 16 dimensions possible, 3 reserved for P, T & U)<br />
<br />
If a hierarchy is used in an info object ZDATE, following tables will be created:<br />
<br />
Hierarchy table: /BI0/HZDATE<br />
Hierarchy SID table: /BI0/KZDATE<br />
SID hierarchy structure: /BI0/IZDATE<br />
HierInterval table: /BI0/JZDATE</span><br />
<div style="clear: both;"></div></div><div class="post-footer" style="background-color: #fefefe; border-bottom-color: rgb(243, 243, 243); border-bottom-style: solid; border-bottom-width: 1px; color: #7f7f7f; font-size: 11px; line-height: 1.6; margin-bottom: 0px; margin-left: -2px; margin-right: -2px; margin-top: 20px; padding-bottom: 5px; padding-left: 10px; padding-right: 10px; padding-top: 5px;"><div class="post-footer-line post-footer-line-1"><span class="post-icons"></span></div><div class="post-footer-line post-footer-line-2"></div><div class="post-footer-line post-footer-line-3"></div></div></div><div class="comments" id="comments" style="min-height: 0px; position: relative;"><a href="http://www.blogger.com/post-edit.g?blogID=4893661405144328174&postID=7089751412561762461" name="comments"></a><br />
<div id="backlinks-container"><div id="Blog1_backlinks-container"></div></div></div></div></div></div></div><div class="blog-pager" id="blog-pager" style="margin-bottom: 1em; margin-left: 0px; margin-right: 0px; margin-top: 1em; overflow-x: hidden; overflow-y: hidden; text-align: center;"></div></span>Rajhttp://www.blogger.com/profile/06811452421912258115noreply@blogger.com