tag:blogger.com,1999:blog-18255935575197431252024-03-18T08:33:58.831+05:30SAP ONLINE TRAININGHi everyone..We along with friends started Online training and real-time support on SAP ABAP, WebDynpro, FICO, Treasury, FSCD(IS-Insurance), SAP SD, SAP BPC, SAP BO, SAP BI/BW, SAP HANA, SAP BASIS(also Upgrade, Migration, Unicode), SAP SECURITY and also UNIX, .NET, TESTING and other technologies.. If interested contact us at below given details
Kumar (+91-9014198132) weteachsap@gmail.comWETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.comBlogger32125tag:blogger.com,1999:blog-1825593557519743125.post-59996659827903612332020-06-03T18:44:00.000+05:302020-06-03T18:44:03.210+05:30SAP FI/CO ONLINE TRAINING<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="text-align: left;">
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal" style="text-align: left;">
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;"><u><span style="color: #274e13;">FI/CO ONLINE TRAINING :-</span></u><o:p></o:p></span></b></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<div style="text-align: left;">
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;"><u><br /></u></span></b></div>
<div style="text-align: left;">
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;"><u>Trainer : </u>M Sathyanarayana Raju</span></b></div>
<div style="text-align: left;">
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;"><br /></span></b></div>
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
<div style="text-align: left;">
<span style="font-family: "times new roman", serif; font-size: 14pt; line-height: 21.4667px;"><b><span style="color: red;">Course Content : </span></b><a href="https://drive.google.com/file/d/0B-M_RtSlCQr0SHBQOUFXN2FEcUk/view?usp=sharing" style="color: #274e13; font-weight: bold;" target="_blank">Click Here</a></span><span style="color: #274e13; font-family: "times new roman", serif; font-size: 14pt; line-height: 21.4667px;"><b><br /></b></span></div>
<div style="text-align: left;">
<span style="color: #274e13; font-family: "times new roman", serif; font-size: 14pt; line-height: 21.4667px;"><b><br /></b></span>
<span style="color: #274e13; font-family: "times new roman", serif; font-size: 14pt; line-height: 21.4667px;"><b>Duration : 100 Hours / 2 Months</b></span></div>
<div style="text-align: left;">
<span style="color: #274e13; font-family: "times new roman", serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><b>Batches : Evening & Weekend </b></span></span></div>
<div style="text-align: left;">
<span style="color: #274e13; font-family: "times new roman", serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><b>Contact : Kumar (+91-9014198132)</b></span></span></div>
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal">
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;">FI
(Topics)<o:p></o:p></span></b><br />
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;"><br /></span></b></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Organization
Stricture<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">General
Ledger Accounting<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Sample
Document<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Recurring
Document<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Accrual
Deferral <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Park of
General Ledger<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Hold
Document<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Cash Journal<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Interest
Calculation<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Accounts
Payable <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Accounts
Receivable<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Same Vendor
and Same Customer<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">House Bank<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Credit Memo
and Debit Memo<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Dunning<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Input and
Output tax<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Foreign
Currency<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">APP
(Automatic Payment Program)<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">DME<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">BRS (Bank
Reconciliation Statement)<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Manual Bank
Statement<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Electronic
Bank Statement<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Asset
Accounting<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">TDS (Tax
Deduction at Source)<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Validation <o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Substitutions<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Screen
Variant<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">LSMW (Legacy
System Migration Work Bench)<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Month end
Activities<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Year end
Activities<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;"><span style="font-family: inherit;">Functional
Specifications</span><o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="line-height: 115%;"><span style="font-family: inherit; font-size: large;">FSV(Financial
Statement Version)</span><span style="font-size: 14pt;"><o:p></o:p></span></span><br />
<span style="line-height: 115%;"><span style="font-family: inherit; font-size: large;"><br /></span></span>
<span style="line-height: 115%;"><span style="font-family: inherit; font-size: large;">SD & MM Integrations</span></span></div>
<div class="MsoNormal">
<br />
<br /></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<div style="text-align: left;">
<b><span style="font-family: "times new roman", serif; font-size: 18pt; line-height: 115%;">Controlling
(Topics)<o:p></o:p></span></b></div>
<div style="text-align: left;">
<b><span style="font-family: inherit; font-size: large; line-height: 115%;"><br /></span></b></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Controlling area<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Cost element<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Cost center<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Profit Center<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Internal Orders<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Non- Leading Ledgers<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Document Splitting<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Distribution Cycle<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<span style="font-family: inherit; font-size: large; line-height: 115%;">Assessment Cycle</span></div>
<div class="MsoNormal">
<div style="text-align: left;">
<span style="font-size: medium;"><span style="font-family: inherit; font-size: large; line-height: 115%;">Product Costing</span><span style="font-family: "times new roman", serif; font-size: large; line-height: 115%;"><o:p></o:p></span></span></div>
<span style="color: red; font-family: "times new roman", serif; font-size: 14pt; line-height: 115%;"><b><br /></b></span>
<span style="font-family: "times new roman", serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span>
<span style="font-family: "times new roman", serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><br /></span></span></div>
</div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-48322309302095378472017-02-23T23:54:00.000+05:302017-02-24T01:30:17.261+05:30SAP SUCCESS FACTORS ONLINE TRAINING<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<div class="MsoNormal" style="text-align: left;">
<b><span style="font-family: "times new roman" , "serif"; font-size: 18pt; line-height: 27.6px;"><u><span style="color: #274e13;">SAP SUCCESS FACTORS ONLINE TRAINI<span style="font-family: "times new roman" , "serif";"><u>NG</u></span> :-</span></u></span></b></div>
<div align="center" class="MsoNormal" style="text-align: center;">
<div style="text-align: left;">
<b><span style="font-family: "times new roman" , "serif"; font-size: 18pt; line-height: 27.6px;"><u><br /></u></span></b></div>
<div style="text-align: left;">
<b><span style="font-family: "times new roman" , "serif"; font-size: 18pt; line-height: 27.6px;"><u>Trainer : </u><span style="font-family: "times new roman" , "serif";">Vinay Kumar</span></span></b></div>
<div style="text-align: left;">
<b><span style="font-family: "times new roman" , "serif"; font-size: 18pt; line-height: 27.6px;"><br /></span></b></div>
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
<div style="text-align: left;">
<span style="font-family: "times new roman" , "serif"; font-size: 14pt; line-height: 21.4667px;"><b><span style="color: red;">Course Content : </span></b><a href="https://drive.google.com/file/d/0B-M_RtSlCQr0TEFEQ0h2Z01WQnM/view?usp=sharing" style="color: #274e13; font-weight: bold;" target="_blank">Click Here</a></span><span style="color: #274e13; font-family: "times new roman" , "serif"; font-size: 14pt; line-height: 21.4667px;"><b><br /></b></span></div>
<div style="text-align: left;">
<span style="color: #274e13; font-family: "times new roman" , "serif"; font-size: 14pt; line-height: 21.4667px;"><b><br /></b></span>
<span style="color: #274e13; font-family: "times new roman" , "serif"; font-size: 14pt; line-height: 21.4667px;"><b>Duration : <span style="font-family: "times new roman" , "serif";">2</span> Months</b></span><br />
<span style="color: #274e13; font-family: "times new roman" , "serif"; font-size: 14pt; line-height: 21.4667px;"><b>System Access : 2 Months</b></span></div>
<div style="text-align: left;">
<span style="color: #274e13; font-family: "times new roman" , serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><b>Batches : <span style="font-family: "times new roman" , serif;">Weekday / </span>Weekend </b></span></span><br />
<span style="color: #274e13; font-family: "times new roman" , serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><b><span style="font-family: "times new roman" , serif;">Training Fee : 30K</span> </b></span></span></div>
<div style="text-align: left;">
<span style="color: #274e13; font-family: "times new roman" , serif;"><span style="font-size: 18.6667px; line-height: 21.4667px;"><b>Contact : Kumar (+91-9014879068)</b></span></span></div>
<b><span style="font-family: "times new roman" , "serif"; font-size: 18pt; line-height: 27.6px;"><br /></span></b>
<br />
<div style="text-align: left;">
<br />
<span style="font-size: large;"><b>1. Module: Introduction to Mastery </b></span><br />
<br />
1. Introduction to Success factors Products.<br />
2. Instance, Provisioning Systems explanation<br />
3. Technical Architecture<br />
4. Integration Technology/Tools<br />
5. t Methodology – Implementation Methodology.<br />
6. Basic company settings in Provisioning System<br />
7. Creating administrators in Provisioning System<br />
8. Creating administrators in Instance<br />
9. Instance basic settings – Passwords, Home Page, Welcome Menu, Comp info.<br />
10. Administrator tools<br />
11. Managing To DO List.<br />
12. Manage V12 Home Page – Success factors Home Page customization.<br />
13. Theme Manager – Customization Organization Themes.<br />
14. Admin tools 2.0 and the Old Admin Overview.<br />
15. Success factors Revolution UI<br />
16. Commonly used terms<br />
17. Default User Permissions.<br />
18. Admin Privileges<br />
19. Proxy Management<br />
20. Setting up company Logos<br />
21. Manage Data User Records<br />
22. Employee Data File<br />
23. Permissions<br />
24. Password Policies<br />
25. Email Notifications Customization.<br />
26. Text Customization in Instance<br />
27. People Search<br />
28. Rating Scales<br />
29. Route Maps (Workflow)<br />
30. Launching forms<br />
31. Modifying Existing Form Route Map Steps by Administrator<br />
32. Employee Profile<br />
33. Customizing Employee Profile (Layout Configuration).<br />
34. XML and Data models<br />
35. Custom Fields Creation in the Data Models.<br />
36. Interfaces between SAP & Success factors (Data extraction)<br />
37. Pick list Management.<br />
38. Jobs Scheduling & Execution of Jobs in Success factors.<br />
39. Success factors Language Packs.<br />
40. Resetting user accounts or Passwords.<br />
41. User Groups Creation<br />
<br />
<span style="font-size: large;">2. Module:: Analytics & Reporting</span><br />
<br />
1. Introduction to Reporting<br />
2. Introduction to Dash Boards<br />
3. Set up process dashboards<br />
4. Rating Scale Dashboards<br />
5. Create Interactive Dashboards<br />
6. Report Centre.<br />
7. Manage Report Permissions<br />
8. List view reports<br />
9. Spotlight view reports<br />
10. Spread sheet reports<br />
11. Classic reports<br />
12. Adhoc report Builder<br />
13. Custom Reports Creation.<br />
14 . Sharing Reports.<br />
15. Single Domain Reports.<br />
16. Cross Domain Reports.<br />
17. Multi Dataset Reports.<br />
<span style="font-size: large;"><br /><b>3. Module: Employee Central Mastery – Core HCM</b></span><br />
<br />
1. Introduction to EC<br />
2. Basic provisioning Setup<br />
3. Recommended 14 – step Implementation sequence for EC Implementation.<br />
4. EC Navigation<br />
5. Setup Super Administrator Account and Managing authorizations.<br />
6. Data models and DTDs<br />
7. Employee Central Structure.<br />
8. Data model Management<br />
9. Setting up Corporate Data Model<br />
10. Setting up Succession Data Model<br />
11. Setting up Country specific Data Model<br />
12. Setting up Country specific Succession Data Model<br />
13. Enable Business Configuration UI (BCUI) in Provisioning<br />
14. Business Configuration UI to Maintain Succession Data model<br />
15. Enable employee central and RBP<br />
16. Update employee details<br />
17. ESS/MSS functionality<br />
18. Understanding security<br />
19. Managing security with Role Based Permission.<br />
20. EC as a system of record<br />
21. EC Customizing and Populating Basic Foundation data<br />
22. Customizing Country specific files in Foundation tables<br />
23. Creating and modifying associations<br />
24. Propagations (Creating Propagations Rules)<br />
25. Importing Users data into employee central system.<br />
26. Customization & Creation of Company, Department, division, Business Unit, Location etc..<br />
27. Mass Changes<br />
28. Customizing employee files.<br />
29. Customizing CSF for Employee Files.<br />
30. Position Management<br />
31. Employee Central Workflow Configuration and Approval Process.<br />
32. Employee Central Reporting<br />
33. Online Report Designer<br />
34. EC Payroll Integration<br />
35. MDF – Meta Data Frame Work<br />
36. MDF Objects creation<br />
37. Global Employment<br />
38. Generic Objects and Configuration of Generic Objects<br />
39. Customer Specific Foundation Objects.<br />
40. Business Rules setup.<br />
41. Search of Inactive Employees/users.<br />
42. Rehire Inactive Employee.<br />
43. Case Study/Exercise<br />
<span style="font-size: large;"><br /><b>4. INTEGRATION KNOWLEDGE </b></span><br />
<br />
1) Different integration system atmosphere<br />
2) Overview of Hybrid Implementations<br />
3) Atom Management<br />
4) Different connector involved in integrations<br />
· Disk connectors<br />
· Database Connectors<br />
· FTP Connectors<br />
· SFTP Connectors<br />
· HTTP Connectors<br />
· Web service SOAP Client connectors<br />
· Web service server connectors<br />
· JMS Connectors<br />
· Sales force Connectors<br />
<br />
<b><span style="font-size: large;">5) Source, Mapping & Target<br />6) Usage of atmosphere API<br />7) administrations</span></b><br />
<br /></div>
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
</div>
<div align="center" class="MsoNormal" style="text-align: center;">
<span lang="EN-US"><span style="mso-tab-count: 1;"> </span></span></div>
</div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-41705931066863231752016-05-28T12:12:00.000+05:302016-05-28T12:12:21.703+05:30SAP Admin Daily Monitoring Activities<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<br />
<b><span style="color: #274e13; font-size: large;"><u>SAP Admin Daily Monitoring Activities :-</u></span></b><br />
<br />
<br />
<br />
1.<span class="Apple-tab-span" style="white-space: pre;"> </span>Check that all the application servers are up:<br />
<br />
- SM51 for SAP Servers<br />
- SM04/AL08 Logon Users<br />
<br />
2.<span class="Apple-tab-span" style="white-space: pre;"> </span>Check that daily backup are executed without errors<br />
<br />
- DB12 Backup logs: overview<br />
<br />
3.<span class="Apple-tab-span" style="white-space: pre;"> </span>SAP standard background jobs are running successfully. Review for cancelled and critical jobs.<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>SM37 Background jobs--- Check for successful completion of jobs. Enter * in user-id<br />
field and verify that all critical successful jobs and review any cancelled jobs.<br />
<br />
4.<span class="Apple-tab-span" style="white-space: pre;"> </span>Operating system Monitoring<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>st06<br />
<br />
5.<span class="Apple-tab-span" style="white-space: pre;"> </span>Extents monitoring<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>DB02 Database monitoring--Check for max-extents reached<br />
<br />
6.<span class="Apple-tab-span" style="white-space: pre;"> </span>Check work-processes(started from sm51)<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>SM50 Process overview-- All work processes with a running or waiting status.<br />
<br />
7.<span class="Apple-tab-span" style="white-space: pre;"> </span>Check system log<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>SM21 System log-- Set date and time to before the last log review. Check for errors, warning, security, message-bends, and database events.<br />
<br />
8.<span class="Apple-tab-span" style="white-space: pre;"> </span>Review workload statistics<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>ST03 Workload analysis of <sid><br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>ST02 tune summary instance<br />
<br />
9.<span class="Apple-tab-span" style="white-space: pre;"> </span>Look for any failed updates<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>SM13 update records<br />
<br />
10.<span class="Apple-tab-span" style="white-space: pre;"> </span>Check for old locks<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>SM12 lock entry list<br />
<br />
11.<span class="Apple-tab-span" style="white-space: pre;"> </span>Check for spool problems<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>SP01 spool request screen-- check for spool that are in request for over an hour.<br />
<br />
12.<span class="Apple-tab-span" style="white-space: pre;"> </span>Review and resolve dumps<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>ST22 ABAP Dump analysis<br />
<br />
13.<span class="Apple-tab-span" style="white-space: pre;"> </span>Checking .trc file in SAP trace directory for block corruption on daily basis.<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>C:\Oracle\sid\saptrace<br />
<br />
14.<span class="Apple-tab-span" style="white-space: pre;"> </span>Archive backup<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>brarchive -f force -cds -c Insert the archive backup tape<br />
<br />
15.<span class="Apple-tab-span" style="white-space: pre;"> </span>Review NT system logs for problem<br />
<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>NT system log- look 4 errors or failures<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>NT security log- failed logon 2 sap servers<br />
-<span class="Apple-tab-span" style="white-space: pre;"> </span>NT Application log -look 4 errors or failures<br />
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-37920791139865797602016-05-28T11:08:00.000+05:302016-05-28T11:19:21.202+05:30SAP SD ONLINE TRAINING<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<span style="color: #274e13;"><span style="font-size: x-large;"><u><b>SAP SD ONLINE TRAINING</b></u></span></span><br />
<br />
<br />
<div class="MsoNormal" style="line-height: 15pt; margin: 3.35pt 0in 0in 155.55pt;">
<span style="height: 996px; left: 0px; margin-left: 31px; margin-top: 30px; mso-ignore: vglayout; position: absolute; width: 754px; z-index: -1;"></span><b><span style="font-family: "cambria" , "serif"; font-size: 14pt; letter-spacing: 0.05pt; position: relative; top: 0.5pt;">SA</span></b><b><span style="font-family: "cambria" , "serif"; font-size: 14pt; position: relative; top: 0.5pt;">P<span style="letter-spacing: -.15pt;"> </span><span style="letter-spacing: .05pt;">SA</span>L<span style="letter-spacing: .1pt;">E</span>S<span style="letter-spacing: -.35pt;"> </span><span style="letter-spacing: .05pt;">A</span><span style="letter-spacing: -.1pt;">N</span>D<span style="letter-spacing: -.25pt;"> </span>D<span style="letter-spacing: -.05pt;">I</span><span style="letter-spacing: .05pt;">S</span>T<span style="letter-spacing: -.1pt;">R</span><span style="letter-spacing: -.05pt;">I</span><span style="letter-spacing: .25pt;">B</span><span style="letter-spacing: -.05pt;">U</span>T<span style="letter-spacing: .15pt;">IO</span>N<span style="letter-spacing: -1.05pt;"> </span><span style="letter-spacing: .05pt;">(S</span>D)</span></b><span style="font-family: "cambria" , "serif"; font-size: 14pt;"><o:p></o:p></span></div>
<div class="MsoNormal" style="line-height: 12pt; margin-top: 0.65pt;">
<br /></div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: 10.95pt; mso-padding-alt: 0in 0in 0in 0in; mso-table-layout-alt: fixed; mso-yfti-tbllook: 480;"><tbody>
<tr style="height: 18.7pt; mso-height-rule: exactly; mso-yfti-firstrow: yes; mso-yfti-irow: 0;"><td style="border: 1pt solid black; height: 18.7pt; padding: 0in; width: 259.55pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.25pt 0in 0in 5.25pt;">
<b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.35pt;">T</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.2pt;">m</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">g</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">s</span></b><b><span style="color: #933634; font-size: 12pt;">:<span style="letter-spacing: -0.866667px;"> </span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">M</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">o</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">r</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">g</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">s</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">/</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">E</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.35pt;">v</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.25pt;">e</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">g</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">s</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">/</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.35pt;">W</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.25pt;">ee</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">k</span></b><b><span style="color: #933634; font-size: 12pt;">e<span style="letter-spacing: -.1pt;">n</span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">d</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.35pt;">s</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.3pt;">/</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">C</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">u</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.35pt;">s</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.4pt;">t</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">o</span></b><b><span style="color: #933634; font-size: 12pt;">m</span></b></div>
</td><td style="border: 1pt solid black; height: 18.7pt; padding: 0in; width: 259.3pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.25pt 0in 0in 5pt;">
<b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">M</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">o</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">d</span></b><b><span style="color: #933634; font-size: 12pt;">e</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.35pt;"> </span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.1pt;">o</span></b><b><span style="color: #933634; font-size: 12pt;">f<span style="letter-spacing: .15pt;"> </span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.35pt;">T</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">r</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.25pt;">a</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">g</span></b><b><span style="color: #933634; font-size: 12pt;">:</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.4pt;"> </span></b><b><span style="color: #933634; font-size: 12pt;">Re<span style="letter-spacing: .1pt;">g</span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">u</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">l</span></b><b><span style="color: #933634; font-size: 12pt;">a<span style="letter-spacing: .3pt;">r</span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">/</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">F</span></b><b><span style="color: #933634; font-size: 12pt;">a<span style="letter-spacing: .4pt;">s</span></span></b><b><span style="color: #933634; font-size: 12pt;">t</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.8pt;"> </span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.35pt;">T</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">r</span></b><b><span style="color: #933634; font-size: 12pt;">a<span style="letter-spacing: .25pt;">c</span></span></b><b><span style="color: #933634; font-size: 12pt;">k</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td></tr>
<tr style="height: 18.5pt; mso-height-rule: exactly; mso-yfti-irow: 1;"><td style="border: 1pt solid black; height: 18.5pt; padding: 0in; width: 259.55pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.25pt 0in 0in 5.25pt;">
<b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">C</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">o</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">u</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">r</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">s</span></b><b><span style="color: #933634; font-size: 12pt;">e</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.6pt;"> </span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">D</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">u</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">r</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.25pt;">a</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">t</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">o</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt;">:</span></b><b><span style="color: #933634; font-size: 12pt;"> <span style="letter-spacing: -1pt;"> </span><span style="letter-spacing: .05pt; mso-font-width: 89%;">5</span>0<span style="letter-spacing: .1pt;"> </span>–<span style="letter-spacing: -.35pt;"> </span>60 <span style="letter-spacing: .1pt; mso-font-width: 73%;">h</span><span style="letter-spacing: .15pt; mso-font-width: 81%;">o</span><span style="letter-spacing: -.1pt; mso-font-width: 73%;">u</span><span style="letter-spacing: .05pt; mso-font-width: 84%;">r</span>s</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td><td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; height: 18.5pt; padding: 0in; width: 259.3pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.25pt 0in 0in 5pt;">
<b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.25pt;">W</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">h</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">a</span></b><b><span style="color: #933634; font-size: 12pt;">t<span style="letter-spacing: .35pt;"> </span></span></b><b><span style="color: #933634; font-size: 12pt;">I<span style="letter-spacing: .95pt;"> </span></span></b><b><span style="color: #933634; font-size: 12pt;">O</span></b><b><span style="color: #933634; font-size: 12pt;">f<span style="letter-spacing: .05pt;">f</span></span></b><b><span style="color: #933634; font-size: 12pt;">er</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td></tr>
<tr style="height: 17.55pt; mso-height-rule: exactly; mso-yfti-irow: 2;"><td style="border: 1pt solid black; height: 17.55pt; padding: 0in; width: 259.55pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.3pt 0in 0in 5.25pt;">
<b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">C</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">l</span></b><b><span style="color: #933634; font-size: 12pt;">a<span style="letter-spacing: .15pt;">s</span></span></b><b><span style="color: #933634; font-size: 12pt;">s</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.45pt;"> </span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">D</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">u</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">r</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.25pt;">a</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">t</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">o</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt;">:</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.4pt;"> </span></b><b><span style="color: #933634; font-size: 12pt;">60<span style="letter-spacing: .1pt;"> </span>–<span style="letter-spacing: -.35pt;"> </span></span></b><b><span style="color: #933634; font-size: 12pt;">90<span style="letter-spacing: .75pt;"> </span><span style="letter-spacing: .3pt; mso-font-width: 58%;">M</span><span style="letter-spacing: .05pt; mso-font-width: 70%;">i</span><span style="letter-spacing: -.1pt; mso-font-width: 73%;">n</span><span style="letter-spacing: .1pt; mso-font-width: 73%;">u</span><span style="letter-spacing: -.2pt; mso-font-width: 82%;">t</span>es<span style="letter-spacing: -.45pt;"> </span><span style="letter-spacing: -.1pt; mso-font-width: 81%;">p</span>er<span style="letter-spacing: .1pt;"> </span><span style="letter-spacing: -.1pt; mso-font-width: 73%;">d</span><span style="letter-spacing: .25pt; mso-font-width: 79%;">a</span>y</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td><td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; height: 17.55pt; padding: 0in; width: 259.3pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.3pt 0in 0in 5pt;">
<b><span style="color: #933634; font-size: 12pt;">*<span style="letter-spacing: -.9pt;"> </span><span style="letter-spacing: -.1pt; mso-font-width: 72%;">Q</span><span style="letter-spacing: -.05pt; mso-font-width: 72%;">u</span><span style="letter-spacing: .2pt; mso-font-width: 72%;">a</span><span style="letter-spacing: .05pt; mso-font-width: 72%;">li</span><span style="letter-spacing: -.15pt; mso-font-width: 72%;">t</span>y<span style="letter-spacing: .35pt;"> </span><span style="letter-spacing: -.35pt; mso-font-width: 58%;">T</span><span style="letter-spacing: .3pt; mso-font-width: 84%;">r</span><span style="letter-spacing: .25pt; mso-font-width: 79%;">a</span><span style="letter-spacing: .05pt; mso-font-width: 70%;">i</span><span style="letter-spacing: -.1pt; mso-font-width: 73%;">n</span><span style="letter-spacing: .05pt; mso-font-width: 70%;">i</span><span style="letter-spacing: -.1pt; mso-font-width: 73%;">n</span>g<span style="letter-spacing: -.7pt;"> </span>*<span style="letter-spacing: -.9pt;"> </span><span style="letter-spacing: -.2pt; mso-font-width: 61%;">F</span><span style="letter-spacing: .05pt; mso-font-width: 70%;">l</span><span style="letter-spacing: .25pt; mso-font-width: 90%;">e</span><span style="letter-spacing: -.25pt; mso-font-width: 75%;">x</span><span style="letter-spacing: .05pt; mso-font-width: 70%;">i</span><span style="letter-spacing: .1pt; mso-font-width: 73%;">b</span><span style="letter-spacing: -.2pt; mso-font-width: 70%;">l</span>e<span style="letter-spacing: -.35pt;"> T</span><span style="letter-spacing: .05pt; mso-font-width: 70%;">i</span><span style="letter-spacing: .2pt; mso-font-width: 74%;">m</span><span style="letter-spacing: .05pt; mso-font-width: 70%;">i</span><span style="letter-spacing: .1pt; mso-font-width: 73%;">n</span><span style="letter-spacing: -.1pt; mso-font-width: 81%;">g</span>s</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td></tr>
<tr style="height: 19.45pt; mso-height-rule: exactly; mso-yfti-irow: 3;"><td style="border: 1pt solid black; height: 19.45pt; padding: 0in; width: 259.55pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.25pt 0in 0in 5.25pt;">
<b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.2pt;">S</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.45pt;">A</span></b><b><span style="color: #933634; font-size: 12pt;">P<span style="letter-spacing: -.15pt;"> </span>Se<span style="letter-spacing: .2pt;">r</span><span style="letter-spacing: -.25pt;">v</span>er <span style="letter-spacing: 1.7pt;"> </span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.55pt;">V</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.25pt;">e</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">r</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">s</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">i</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">o</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.1pt;">n</span></b><b><span style="color: #933634; font-size: 12pt;">:</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.4pt;"> </span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">E</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.05pt;">C</span></b><b><span style="color: #933634; font-size: 12pt;">C<span style="letter-spacing: .8pt;"> </span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.25pt;">6</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.2pt;">.</span></b><b><span style="color: #933634; font-size: 12pt;">0</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td><td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; height: 19.45pt; padding: 0in; width: 259.3pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.25pt 0in 0in 5pt;">
<b><span style="color: #933634; font-size: 12pt;">*<span style="letter-spacing: 1.25pt;"> </span><span style="letter-spacing: .2pt; mso-font-width: 88%;">2</span><span style="letter-spacing: .05pt; mso-font-width: 91%;">4</span><span style="letter-spacing: -.05pt; mso-font-width: 160%;">/</span>7<span style="letter-spacing: -.75pt;"> </span>Se<span style="letter-spacing: .25pt;">r</span><span style="letter-spacing: -.3pt;">v</span>er<span style="letter-spacing: .5pt;"> </span><span style="letter-spacing: -.6pt; mso-font-width: 62%;">A</span><span style="letter-spacing: .25pt; mso-font-width: 90%;">c</span>ce<span style="letter-spacing: .15pt;">s</span>s<span style="letter-spacing: -.7pt;"> </span>*<span style="letter-spacing: -.9pt;"> </span><span style="letter-spacing: -.2pt; mso-font-width: 61%;">H</span>a<span style="letter-spacing: .15pt;">n</span><span style="letter-spacing: -.1pt; mso-font-width: 73%;">d</span>s<span style="letter-spacing: -.25pt;"> </span>–<span style="letter-spacing: .15pt;"> </span><span style="letter-spacing: .1pt;">o</span>n<span style="letter-spacing: -.45pt;"> </span><span style="letter-spacing: -.35pt; mso-font-width: 58%;">T</span><span style="letter-spacing: .05pt; mso-font-width: 84%;">r</span><span style="letter-spacing: .25pt; mso-font-width: 79%;">a</span><span style="letter-spacing: -.2pt; mso-font-width: 70%;">i</span><span style="letter-spacing: .1pt; mso-font-width: 73%;">n</span><span style="letter-spacing: .05pt; mso-font-width: 70%;">i</span><span style="letter-spacing: -.1pt; mso-font-width: 73%;">n</span>g</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td></tr>
<tr style="height: 19.7pt; mso-height-rule: exactly; mso-yfti-irow: 4; mso-yfti-lastrow: yes;"><td style="border: 1pt solid black; height: 19.7pt; padding: 0in; width: 259.55pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.5pt 0in 0in 5.25pt;">
<b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.2pt;">F</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.3pt;">r</span></b><b><span style="color: #933634; font-size: 12pt;">ee</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.6pt;"> </span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.2pt;">S</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.45pt;">A</span></b><b><span style="color: #933634; font-size: 12pt;">P<span style="letter-spacing: -.15pt;"> </span>Se<span style="letter-spacing: .2pt;">r</span><span style="letter-spacing: -.25pt;">v</span>er <span style="letter-spacing: 1.95pt;"> </span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.6pt;">A</span></b><b><span style="color: #933634; font-size: 12pt;">cce<span style="letter-spacing: .15pt;">s</span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.15pt;">s</span></b><b><span style="color: #933634; font-size: 12pt;">:</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.4pt;"> </span></b><b><span style="color: #933634; font-size: 12pt;">60<span style="letter-spacing: -.45pt;"> </span></span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.05pt;">D</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: 0.25pt;">a</span></b><b><span style="color: #933634; font-size: 12pt; letter-spacing: -0.35pt;">y</span></b><b><span style="color: #933634; font-size: 12pt;">s</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td><td style="border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; height: 19.7pt; padding: 0in; width: 259.3pt;" valign="top" width="346"><div class="MsoNormal" style="margin: 0.5pt 0in 0in 5pt;">
<b><span style="color: #933634; font-size: 12pt;">*<span style="letter-spacing: 1.5pt;"> </span><span style="letter-spacing: -.1pt; mso-font-width: 64%;">D</span>e<span style="letter-spacing: -.05pt;">m</span><span style="letter-spacing: .15pt; mso-font-width: 81%;">o</span><span style="letter-spacing: -.1pt; mso-font-width: 73%;">n</span><span style="letter-spacing: .35pt; mso-font-width: 99%;">s</span><span style="letter-spacing: -.4pt; mso-font-width: 82%;">t</span><span style="letter-spacing: .05pt; mso-font-width: 84%;">r</span><span style="letter-spacing: .25pt; mso-font-width: 79%;">a</span><span style="letter-spacing: -.2pt; mso-font-width: 82%;">t</span><span style="letter-spacing: -.2pt; mso-font-width: 70%;">i</span><span style="letter-spacing: .15pt; mso-font-width: 81%;">o</span>n<span style="letter-spacing: -.4pt;"> </span><span style="letter-spacing: -.2pt; mso-font-width: 75%;">w</span><span style="letter-spacing: .05pt; mso-font-width: 75%;">i</span><span style="letter-spacing: -.15pt; mso-font-width: 75%;">t</span>h<span style="letter-spacing: .15pt;"> R</span>eal<span style="letter-spacing: .1pt;"> </span><span style="letter-spacing: -.15pt;">t</span><span style="letter-spacing: .05pt;">i</span><span style="letter-spacing: -.05pt;">m</span>e<span style="letter-spacing: .9pt;"> </span><span style="letter-spacing: .15pt; mso-font-width: 99%;">s</span>ce<span style="letter-spacing: -.1pt;">n</span>a<span style="letter-spacing: .3pt;">r</span><span style="letter-spacing: -.2pt; mso-font-width: 70%;">i</span><span style="letter-spacing: -.05pt; mso-font-width: 81%;">o</span>s</span></b><span style="font-size: 12pt;"><o:p></o:p></span></div>
</td></tr>
</tbody></table>
<div class="MsoNormal" style="line-height: 10pt;">
<br /></div>
<h4 style="text-align: left;">
<b><span style="color: blue;"><u>COURSE OUTLINE</u></span></b></h4>
SAP is the leading market player in the ERP world. SAP’s Sales and Distribution module is a key component in SAP’s Supply Chain Management that lists the processes and associated activities in typical sales/customer service and logistics departments.<br />
<br />
The SD Module comes with a set of configuration tasks, master data, transactions, reports and technical objects. SAP’s inherent strength is its ability to seamlessly integrate across modules FI, SD, CO, PP, MM, PS etc.<br />
<br />
Sales and Distribution activities are very basic to a corporate entity’s operations and given the complexity of these processes and the data needed to execute these processes, a good ERP like SAP is almost indispensible now.<br />
<br />
SAP SD is possibly the most implemented and a very highly successful module so far and is still leading in demand for well trained and experienced consultants.<br />
<br />
SAP SD training program would cover the standard SAP SD module and how it is implemented to automate and systemize the OTC business processes by providing easily accessible implementation guides, fantastic time-saving tips, as well as direct easily accessible information on the dos and don’ts of implementing and maintaining the sales and distribution module of SAP.<br />
<h4 style="text-align: left;">
<u><span style="color: blue;"><b><br /></b><b>HIGH LIGHTS</b></span></u></h4>
With training in this curriculum, you can gain the knowledge you need to optimize vital Sales and<br />
Distribution process.<br />
<br />
• Online live instructor led training.<br />
<br />
• Participants become familiar with functions and customizing settings in Sales and Distribution.<br />
<br />
• Provide an overview of SAP business solutions<br />
<br />
• Develop the baseline SAP Product knowledge necessary for participation in more detailed SAP<br />
courses.<br />
<br />
• Participants learn how to perform the most important functions in the process chain from presales to customer payments in the SAP system.<br />
<br />
• Participants become familiar with the functions and customizing delivery processing.<br />
<br />
• Participants become familiar with functions and customizing setting for billing process. They also learn the interface points between billing in Sales and Distribution and billing in financial accounting.<br />
<br />
• The course enables the participants to identify and explain the more complex customizing settings for SD.<br />
<br />
• Participants become familiar with the functions for processing selected cross application business process in sales and Distribution, Material management and Financial Accounting and identify the associated customizing settings.<br />
<h3 style="text-align: center;">
<span style="color: #274e13;"><u><br /></u><u>SAP SALES AND DISTRIBUTION (SD)</u></span></h3>
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Overview of ERP </span></b></h3>
<h3 style="text-align: left;">
<b><span style="color: blue;">Introduction to SAP</span></b></h3>
<h3 style="text-align: left;">
<span style="color: blue;">Section I: Enterprise Structure</span></h3>
• Enterprise structure in Sales and Distribution<br />
• Define organizational elements<br />
• Assign organizational elements<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section II: Master Data</span></h3>
• Accounts Groups<br />
• Creating Number ranges and Assignment<br />
• Partner Determination<br />
• Customer Master record<br />
• Material Master record<br />
• Customer material info records<br />
• Conditions Master data<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section III: Determinations</span></h3>
• Item category Determination<br />
• Schedule Line Category Determination<br />
• Shipping Point Determination<br />
• Picking Location Determination<br />
• Pricing Determination<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section IV: Sales process</span></h3>
• Forward Sales Cycle<br />
• Reversal Sales Cycle<br />
• Cash Sales & Rush Order<br />
• Sample Sales and Free of Charge (FOC)<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section V: Complaints</span></h3>
• Returns Sales Cycle<br />
• Credit Memo Request, Debit Memo Request<br />
• Subsequent Free of Charge<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section VI: Document Type Controls Processing</span></h3>
• Sales Document Types<br />
• Sales Document Structure<br />
• Delivery Document Types<br />
• Billing Document Types<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section VII: Copy Controls</span></h3>
• Sales to Sales<br />
• Sales to Delivery<br />
• Sales to Billing<br />
• Delivery to Billing<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section VIII: Basic Functions</span></h3>
• Tax Determination<br />
• Incomplete Procedure<br />
• Bill of Material (BOM)<br />
• Material determination<br />
• Listing / exclusion<br />
• Output determination<br />
• Pricing<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
1) Field Catalogue, Condition Tables, Access Sequence, Condition Types,<br />
Procedure and Condition Records<br />
2)<span class="Apple-tab-span" style="white-space: pre;"> </span> Price, Discounts, Taxes, Surcharges, Freight, Rebate<br />
3)<span class="Apple-tab-span" style="white-space: pre;"> </span> Pricing Determination<br />
4)<span class="Apple-tab-span" style="white-space: pre;"> </span> Condition Exclusion groups for Pricing<br />
5)<span class="Apple-tab-span" style="white-space: pre;"> </span> Condition Supplement<br />
6)<span class="Apple-tab-span" style="white-space: pre;"> </span> Configuring Pricing Reports<br />
• Free goods Determination<br />
• Order Blocks, Credit Block , Delivery Block & Billing Block<br />
• Availability Check & Transfer of Requirement (TOR)<br />
• Document Flow, Document Grouping and Splitting<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section IX: Agreements</span></h3>
• Contracts<br />
1) Value Contracts<br />
2) Quantity Contracts<br />
• Scheduling agreements<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section X: Finance Integration</span></h3>
• Revenue account determination<br />
• Credit Management<br />
• Rebates / Agreements<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section XI: Material Management Integration</span></h3>
• Stock Posting<br />
• Stock Transfers<br />
• Third Party Sales<br />
• Individual Purchase Order<br />
<h3 style="text-align: left;">
<span style="color: blue;">Section XII: Business Interaction with Domain Functionality for Special Process</span></h3>
• Inter Company Sales<br />
• Cash Sales & Rush Orders<br />
• Consignments<br />
<br />
<h3 style="text-align: left;">
<span style="color: blue;">Overview on real time functionality in SD department</span></h3>
<h3 style="text-align: left;">
<span style="color: blue;">Reports</span></h3>
<h3 style="text-align: left;">
<span style="color: blue;">Interview Tips</span></h3>
<div>
<a href="https://drive.google.com/file/d/0B-M_RtSlCQr0ekVMS1RQUkhYUWc/view?usp=sharing" target="_blank"><span style="font-size: large;">COURSE CONTENT PDF LINK</span></a></div>
<div>
<br /></div>
<div>
<h3 style="text-align: left;">
<span style="color: #274e13;">If interested contact us at.... Kumar (+91 9014879068) weteachsap@gmail.com</span></h3>
</div>
<div>
<span style="color: blue;"><br /></span></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-51868624473250887752014-08-23T01:10:00.000+05:302015-07-01T00:30:40.140+05:30SAP SD QUESTIONS & ANSWERS-1<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<h2 style="text-align: left;">
<span style="color: #274e13; font-size: large;"><b><u>SAP SD QUESTIONS & ANSWERS-1 :-</u></b></span></h2>
<br />
<b><span style="color: blue;">Q) What do you mean by drop shipment ?</span></b><br />
A drop shipment is based on an order from a customer to a Distributor. The distributor initiates the shipment by Informing the wholesaler.<br />
<br />
<b><span style="color: blue;">Q) Why do you need project IMG ?</span></b><br />
IMG is required for the purpose of customizing and Configuration. There is no role of functional consultant Without it.<br />
<br />
<b><span style="color: blue;">Q) Without delivery can you do billing ?</span></b><br />
Without delivery invoice is not possible.<br />
<br />
<b><span style="color: blue;">Q) How does the rule MALA decide the picking location ?</span></b><br />
1. SHIPPING POINT<br />
2. PLANT<br />
3. STORAGE CONDITION<br />
4. STORAGE LOCATION<br />
<br />
<b><span style="color: blue;">Q) Is it possible to do delivery without shipping point ?</span></b><br />
No. Shipping point is the destination of the goods, how we can ship the goods. It is like mailing letter without TO address.<br />
<br />
<b><span style="color: blue;">Q) Explain about smart forms ?</span></b><br />
Smart form - it is a form. Basically it is using in output.<br />
<br />
<b><span style="color: blue;">Q) How sales document is structured ?</span></b><br />
Header responsible for all the documents<br />
Item for materials<br />
Schedule line for quantity and delivery<br />
<br />
<b><span style="color: blue;">Q) What does A/C Group control customer ?</span></b><br />
Account Group is like a control Parameter for the customer master. Most of the fields in the customer master are controlled Using Field Selection, which is internal function of Account Group.<br />
<br />
<b><span style="color: blue;">Q) In sales order how system does picks up plant ?</span></b><br />
We assign particular material master to particular Plant it picks up from there.<br />
<br />
<b><span style="color: blue;">Q) What is the difference between customization and configuration ?</span></b><br />
Customization word used for Master Data maintenance. And Configuration word used for pricing Procedure Determination<br />
<br />
<b><span style="color: blue;">Q) Could you explain about sales deals ?</span></b><br />
Company Has Launched a new product, for a that material you Want to have a promotion for this you will creating a sales deal and assign it to sales promotion and you maintain condition groups<br />
<br />
<b><span style="color: blue;">Q) What is the use of pricing date in condition type ?</span></b><br />
It shows date of calculation of pricing procedure for that Particular document. So that in future you can see the date On which pricing calculated for that particular doc.<br />
<br />
<b><span style="color: blue;">Q) What is the use of sales area ?</span></b><br />
Sales area is the geographical aspect of that particular Company code, from there we can generate the reports.<br />
<br />
<b><span style="color: blue;">Q) Can you explain about Higher-level item category and item usage</span></b><br />
Sales Document Type (OR)<br />
+<br />
Item Category Group (NORM)<br />
+<br />
Item Usage (FREE)<br />
+<br />
Higher Level Item Category (TAN)<br />
+<br />
Item Category of Free Goods (TANN)<br />
<br />
<b><span style="color: blue;">Q) How to extend material and customer to other sales areas ?</span></b><br />
Sales area is a combination of s.org, dist channel & Division. Division is a logical grouping of products. So u Cannot extend material to other sales areas. But u can Extend customer to other sales areas through common Distribution channel & division.<br />
<br />
<b><span style="color: blue;">Q) How can we process out bound deliveries without shipping point ?</span></b><br />
Shipping point is a mandatory Organizational unit for outbound delivery process.<br />
<br />
<b><span style="color: blue;">Q) Product attributes means ?</span></b><br />
Product attributes is nothing but the features of product.<br />
<br />
<b><span style="color: blue;">Q) Why do I use condition indexes ? How do you activate them ?</span></b><br />
Condition Index is used to search all the conditions<br />
Records for a particular condition type (eg PR00). We Activate condition index in the customizing screen of the Condition type.<br />
Menu Path: SPRO>>Sales & Distribution>>Basic Functions>>Pricing>>Pricing Control>>Define Condition Types>> Maintain Condition Types>> Enter PR00<br />
<br />
<b><span style="color: blue;">Q) While I am creating a customer in ship to party account group you have shipping and billing partner function tab pages, client wants to shift all important fields in billing like payment terms, incoterms , and tax classification into shipping tab page. He wants only shipping partner function only, how does you customize ?</span></b><br />
Field Selection will help you maintain the fields relevant To Shipping, Ship to party function will be able to see only shipping related fields.<br />
<br />
<b><span style="color: blue;">Q) How we assigned sales organization to delivering plant ?</span></b><br />
Path: SPRO-IMG-Enterprise Structure-Assignment-SD-Assign Plant to Sales Organization/Dist.Channel<br />
T.Code: OVX6<br />
<b><span style="color: blue;"><br /></span></b>
<b><span style="color: blue;">Q) Is it possible to release change request, without releasing task.</span></b><br />
Once we can release the task, then only we can release the Change/customizing request.<br />
<br />
<b><span style="color: blue;">Q) What is the client specific data ? Give two examples of client specific data ?</span></b><br />
1-master data<br />
2-transction data.<br />
<br />
<b><span style="color: blue;">Q) Can one have multiple packing for delivery ?</span></b><br />
YES WE CAN HAVE MULTIPLE PACKING FOR A SINGLE DELIVERY<br />
<br />
<b><span style="color: blue;">Q) Explain EDI and its usage ?</span></b><br />
Edi - it helps for data transfer<br />
That means from sap or non sap to sap<br />
<br />
<b><span style="color: blue;">Q) To extend material one plants to another plant what are the configuration you done in your project ?</span></b><br />
<br />
We have to create in new plant as we have followed for First plant, where as in first plant system will give Internal number but for second plant we have to mention Material number.<br />
<br />
<br />
<br />
<b>Soon will update more...Check next post...</b><br />
<b><br /></b>
<b><br /></b>
<b><br /></b>
<br />
<div>
<br /></div>
</div>WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com9tag:blogger.com,1999:blog-1825593557519743125.post-82554386863357545252014-08-22T00:43:00.000+05:302014-08-22T00:44:10.464+05:30SAP SD TRANSACTION CODES<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<h2 style="text-align: left;">
<u><b><span style="color: #274e13; font-size: x-large;">SAP SD Transaction Codes :-</span></b></u></h2>
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Customer</span></b></h3>
<b>XD01 Create Customer (Centrally)</b><br />
<b><br /></b>
<b>XD02 Change Customer (Centrally)</b><br />
<b><br /></b>
<b>XD03 Display Customer (Centrally)</b><br />
<b><br /></b>
<b>XD05 Block customer (centrally)</b><br />
<b><br /></b>
<b>XD07 Change Customer Account Group</b><br />
<b><br /></b>
<b>XDN1 Maintain Number Ranges (Customer)</b><br />
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Sales Order</span></b></h3>
<b>VA01 Create Sales Order</b><br />
<b><br /></b>
<b>VA02 Change Sales Order</b><br />
<b><br /></b>
<b>VA03 Display Sales Order</b><br />
<b><br /></b>
<b>VA05 List of Sales Orders</b><br />
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Inquiry</span></b></h3>
<b>VA11 Create Inquiry</b><br />
<b><br /></b>
<b>VA12 Change Inquiry</b><br />
<b><br /></b>
<b>VA13 Display Inquiry</b><br />
<b><br /></b>
<b>VA15 Inquiries List</b><br />
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Quotation</span></b></h3>
<b>VA21 Create Quotation</b><br />
<b><br /></b>
<b>VA22 Change Quotation</b><br />
<b><br /></b>
<b>VA23 Display Quotation</b><br />
<b><br /></b>
<b>VA25 Quotations List</b><br />
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Contract</span></b></h3>
<b>VA41 Create Contract</b><br />
<b><br /></b>
<b>VA42 Change Contract</b><br />
<b><br /></b>
<b>VA43 Display Contract</b><br />
<b><br /></b>
<b>VA45 List of Contracts</b><br />
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Item Proposal</span></b></h3>
<b>VA51 Create Item Proposal</b><br />
<b><br /></b>
<b>VA52 Change Item Proposal</b><br />
<b><br /></b>
<b>VA53 Display Item Proposal</b><br />
<b><br /></b>
<b>VA55 List of Item Proposal</b><br />
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Delivery (Outbound)</span></b></h3>
<b>VL01 Create Delivery</b><br />
<b><br /></b>
<b>VL01N Create Outbound Dlv. with Order Ref.</b><br />
<b><br /></b>
<b>VL02N Change Outbound Delivery</b><br />
<b><br /></b>
<b>VL03 Display Outbound Delivery</b><br />
<b><br /></b>
<b>VL09 Cancel Goods Issue for Delivery Note</b><br />
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Customer management</span></b></h3>
<b>FD32 Change Customer Credit Management</b><br />
<b><br /></b>
<b>FD33 Display Customer Credit Management</b><br />
<br />
<h3 style="text-align: left;">
<b><span style="color: blue;">Pricing</span></b></h3>
<b>V/03 Create Condition Table (SD Price)</b><br />
<b><br /></b>
<b>V/04 Change Condition Table (Sales pr.)</b><br />
<b><br /></b>
<b>V/05 Display Condition Table (Sales Pr.)</b><br />
<b><br /></b>
<b>V/06 Condition Categories (SD Pricing)</b><br />
<b><br /></b>
<b>V/07 Maintain Access (Sales Price)</b><br />
<b><br /></b>
<b>V/08 Conditions (Procedure for A V)</b><br />
<b><br /></b>
<b>V/09 Condition Types (Account Determine)</b><br />
<b><br /></b>
<b>V/10 Account Determination (Access Seqnc)</b><br />
<b><br /></b>
<b>V/11 Conditions (Account Determin.Proced.)</b><br />
<b><br /></b>
<b>V/12 Account Determination (Create Table)</b><br />
<b><br /></b>
<b>V/13 Account Determination (Change Table)</b><br />
<b><br /></b>
<b>V/14 Account Determination (Display Table)</b><br />
<br />
<br />
<br />
<br />
<b>Will update soon... Check next post...</b><br />
<br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-12904580651155355282014-08-21T23:47:00.000+05:302014-08-22T00:43:17.988+05:30SAP SD CONFIGURATION STEPS<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<h2 style="text-align: left;">
<u><b><span style="color: #274e13; font-size: x-large;">SAP SD CONFIGURATION STEPS :-</span></b></u></h2>
<b><u><span style="font-size: large;"><br /></span></u></b>
<b><u><span style="font-size: large;">Enterprise Structure :-</span></u></b><br />
<br />
<br />
<b><span style="color: blue;">1) Edit, Copy, Delete, Check Company Code (T001)</span></b><br />
Company is created by FI Consultant.<br />
The company code is an organizational unit used in accounting. It is used to structure the business organization from a financial accounting perspective.<br />
IMG -> Enterprise Structure -> Definition -> Financial Accounting -> Define, copy, delete, check Company Code<br />
<br />
<b><span style="color: blue;">2) Define Credit Control Area (T014)</span></b><br />
Company is created by FI Consultant.<br />
The credit control area is an organizational unit that specifies and checks a credit limit for customers. A credit control area can include one or more company codes. It is not possible to assign a company code to more than one control area. Within a credit control area, the credit limits must be specified in the same currency.<br />
IMG -> Enterprise Structure -> Definition -> Financial Accounting-> Define Credit Control Area<br />
<br />
<b><span style="color: blue;">3) Maintaining Sales Organization (TVKO)</span></b><br />
Sales Organization is an organizational unit responsible for the sale of certain products or services.<br />
IMG -> Enterprise Structure -> Definition -> Sales and Distribution -> Define, copy, delete, check Sales organization<br />
<br />
<b><span style="color: blue;">4) Assigning Sales Organization to Company Code (TVKO~BUKRS)</span></b><br />
This assignment ensures all the sales made through this Sales Organization are accounted for in the assigned Company Code (Company Code is created by FI Consultant).<br />
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign Sales Organization to Company Code<br />
<br />
<b><span style="color: blue;">5) Maintaining Distribution Channel (TVTW)</span></b><br />
Distribution Channel is the way, in which Products or Services reach Customers.<br />
IMG -> Enterprise Structure -> Definition -> Sales and Distribution -> Define, copy, delete, check distribution channel<br />
<br />
<b><span style="color: blue;">6) Assigning Distribution Channel to Sales Organization (TVKOV)</span></b><br />
This assignment ensures, a Sales Organization can supply Materials to Customers through this Distribution Channel.<br />
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution > Assign distribution channel to sales organization<br />
<br />
<b><span style="color: blue;">7) Maintaining Division (TSPA)</span></b><br />
Division is a way of grouping materials, products, or services.<br />
IMG -> Enterprise Structure -> Definition -> Logistics - General -> Define, copy, delete, check division<br />
<br />
<b><span style="color: blue;">8) Assigning Division to Sales Organization (TVKOS)</span></b><br />
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign division to sales organization<br />
<br />
<b><span style="color: blue;">9) Setting up Sales Area (TVTA)</span></b><br />
All the sales are made from a particular sales Area. For creating a Sales Order Sales Area is compulsory.<br />
IMG ->Enterprise Structure -> Assignment -> Sales and Distribution -> Set up sales area<br />
<br />
<b><span style="color: blue;">10) Maintain sales office (TVBUR)</span></b><br />
you define the sales offices in your company. The definition of sales offices is optional.<br />
For each sales office, you can determine the printer for output based on the sales documents in different ways<br />
IMG -> Enterprise Structure -> Definition -> Sales and Distribution -> Maintain Sales Office<br />
<br />
<b><span style="color: blue;">11) Assign sales office to sales area (TVKBZ)</span></b><br />
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign sales Office to Sales Area<br />
<br />
<b><span style="color: blue;">12) Assign sales group to sales office (TVBVK)</span></b><br />
you can assign as many sales groups as desired to the sales offices. Any one sales group can belong to several sales offices.<br />
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign sales group to sales office<br />
<br />
<b><span style="color: blue;">13) Define Shipping Points (TVST)</span></b><br />
Shipping Point is the Organizational element, which is responsible for shipping the Materials to the Customers.<br />
IMG -> Enterprise Structure -> Definition -> Logistics Execution -> Define, copy, delete, check shipping point<br />
<br />
<b><span style="color: blue;">14) Define, copy, delete, check plant (T001W)</span></b><br />
Plant is created by MM Consultant.<br />
IMG -> Enterprise Structure -> Definition -> Logistics - General -> Define, copy, delete, check plant<br />
<br />
<b><span style="color: blue;">15) Assigning Shipping Point to Plant (TVSWZ)</span></b><br />
This assignment ensures that goods from different Plant can be dispatched from different Shipping Points.<br />
IMG -> Enterprise Structure -> Assignment -> Logistics Execution -> Assign shipping point to plant<br />
<br />
<b><span style="color: blue;">16) Assigning Sales Organization- Distribution Channel- Plant (TVKWZ)</span></b><br />
Plant is created by MM Consultant.<br />
IMG -> Enterprise Structure -> Assignment -> Sales and Distribution -> Assign sales organization - distribution channel - plant<br />
<br />
<br />
<br />
<br />
<b>Will update soon... Check next post...</b><br />
<br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-59777237285389638932014-01-23T20:05:00.002+05:302014-08-21T23:56:40.717+05:30SAP ABAP INTERVIEW QUESTIONS-5<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP INTERVIEW QUESTIONS-5 :-</b></span></u></span><br />
<span style="font-size: large;"><br /></span>
<span style="font-size: large;"><span style="color: blue;"><b>SAP Technical Interview questions </b></span></span><br />
<br />
<b>Q. What are the methods of interfacing to SAP ?<br /><br />Q. What is an IDOC ?<br /><br />Q.What is partner profile ?<br /><br />Q. When would you use a BAPI rather than an IDOC ?<br /><br />Q. How would you control changes to standard SAP objects ?<br /><br />Q. Explain Data and List methods in LIS ?<br /><br />Q. Select single vs select up to one rows ?<br /><br />Q. Explain V2 updates ?<br /><br />Q. Text on an output document. How do you find its source ?<br /><br />Q. Explain the 4 events in flow logic ?<br /><br />Q. What methods can you use to make a report interactive ?<br /><br />Q. Where do you find info on new developments in SAP ? <br /><br />Q. Are you a member of any professional organisations ? <br /><br />Q. How long do you struggle with a problem before you ask for help ?<br /><br />Q. What is the purpose of (a) unit testing (b) integration testing ?<br /><br />Q. What is the role of a functional analyst? How many Analysts on your project ? <br /><br />Q. What is the role of the Basis team? How many Basis people running your implementation ?<br /><br />Q. Who signs off that a program is performing as specified ?<br /><br />Q. What action do you take when a program is taking longer than expected to develop ?<br /><br />Q. Tell me a little bit about performance in ABAP. How do you ensure that your programs run efficiently ? <br /><br /><span style="color: blue;"><span style="font-size: large;">Project experience</span></span><br /><br />Q. Tell me about some of the projects you have worked on ?<br /><br />Q. What roles have you played on these different projects ?<br /><br />Q. Have you taken on any project management or project/team lead roles ?<br /><br />Q. What type of position are you looking for ?<br /><br />Q. What type of programs have you developed ?<br /><br />Q. What functional areas have you written programs for? Do you consider yourself an expert developer for any of the functional areas you have written programs for ?.<br /><br />Q. Have you done much of your own analysis work ? Written specs ?<br /><br />Q. What was the most complicated program you’ve developed and why ?<br /><br />Q. What is the most challenging thing you find when developing programs ?<br /><br />Q. Have you given any formal training in your SAP career ? Mentoring ?<br /><br />Q. Have you used any QA standards or been required to go through any QA evaluations for custom programs you have written ?<br /><br />Q. What, if any, project methodologies have you used ?<br /><br />Q. Who in the organization do you speak to most frequently on a day-to-day basis? i.e.: end users, analysts, team leads, managers. <br /><br /><span style="color: blue;"><span style="font-size: large;">Technical </span></span><br /><br />Q. In your opinion what is the most common problem encountered after transporting dictionary objects?<br /><br />Q. Discuss ‘development classes’.<br /><br />Q. How many they use in a project etc...<br /><br />Q. If only used $TMP, no go live experience<br /><br />Q. Discuss the differences between BDC and ‘Call transaction’.<br /><br />Q. Synch vs. Asynch<br /><br />Q. Error log vs. no error log<br /><br />Q. Discuss the pros and cons of secondary indices.<br /><br />Q. Processing overhead vs. disk space<br /><br />Q. Discuss a ‘logical unit of work’.<br /><br />Q. What are the differences between Open SQL and Native SQL ?<br /><br />Q. SAP only use Open SQL<br /><br />Q. Discuss indices and matchcodes.<br /><br />Q. What is difference between static and dynamic field symbols ?<br /><br /><span style="color: blue;"><span style="font-size: large;">EDI Related </span></span><br /><br />Q. Which EDI transactions have you done ? Inbound/Outbound ?<br /><br />Q. Which translator did you use ?<br /><br />Q. Were you involved with non-SAP mapping ?<br /><br />Q. Which versions of SAP did you implement EDI for ?<br /><br />Q. Were you involved with the analysis of the transactions ?<br /><br />Q. Were you the sole SAP EDI person on the project ?<br /><br />Q. Did you do the ABAP portion of the EDI implementation ?<br /><br />Q. Were you involved with the production support end of EDI once it was implemented ?<br /><br />Q. How did you train the users in EDI support both functionally and technically ?<br /><br />Q. Did you do any custom WF programming or setup (aside from error handling) ? <br /><br /><span style="font-size: large;"><span style="color: blue;">ALE Related </span></span><br /><br />Q. Which ALE transactions have you done ? Inbound/Outbound ?<br /><br />Q. Did you implement change pointers ?<br /><br />Q. Any custom ABAP work necessary ?<br /><br />Q. Any custom WF ?<br /><br />Q. SAP to SAP or external ?</b></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-11381505375661384712014-01-18T12:46:00.003+05:302014-08-23T01:04:27.711+05:30SAP ABAP TECHNICAL INTERVIEW QUESTIONS<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<u><span style="color: #274e13;"><span style="font-size: large;"><b>SAP ABAP TECHNICAL INTERVIEW QUESTIONS :-</b></span></span></u><br />
<br />
<br />
<b><span style="font-size: large;"><span style="color: blue;">1. General System Information</span></span><br /><br />• How many SAP instances are there (Development, QA, PRD, Training, etc) ? <br /><br />• What SAP versions are in use for each instance? (e.g. 3.1I etc.) <br /><br />• What release of SAP Kernel for each instance ? <br /><br />• What’s the SAP Hot Package level for each instance ? <br /><br />• What OS (type and version) is employed per instance ? <br /><br />• What RDBMS (type and version) is employed ? </b><br />
<b><br /><span style="color: blue;"><span style="font-size: large;"> </span></span></b><br />
<b><span style="color: blue;"><span style="font-size: large;">2. System Architecture</span></span><br />• What is the system landscape currently (including client strategy) ? Please provide a diagram of all systems and clients and transport routes between the different systems. <br /><br />• Is any hardware available for the upgrade? I.e. to copy the Dev and Production systems or just a copy of Production ? <br /><br />• Which Add-ons are employed (faxing, printing, ITS, barcoding, taxation, scheduling, etc.) ? <br /><br />• Responsibility and tools used for SAPGUI rollout ? How many users ? <br /><br /><span style="font-size: large;"><span style="color: blue;"> </span></span></b><br />
<b><span style="font-size: large;"><span style="color: blue;">3. System Administration</span></span><br /><br />• Who is responsible for maintaining Authorizations ? <br /><br />• Was the Profile Generator used to create and develop the Profiles ? <br /><br />• Is a Change Management Procedure in place to manage and test transports ? <br /><br />• Are any other tools other than SAP used to manage transports? If so, please provide details. <br /><br /><span style="font-size: large;"><span style="color: blue;"> </span></span></b><br />
<b><span style="font-size: large;"><span style="color: blue;">4. Backup and Recovery</span></span><br /><br />• Is a tested backup and recovery process in place ? <br /><br /><span style="font-size: large;"><span style="color: blue;"> </span></span></b><br />
<b><span style="font-size: large;"><span style="color: blue;">5. Availability Requirements and business cycles</span></span><br /><br />• What are the availability requirements per instance ? <br /><br />• What is the longest period of time that the business can operate without the SAP system ? <br /><br />• When are the peak processing times ? <br /><br />• When is financial closing ? <br /><span style="color: blue;"><br /><span style="font-size: large;"> </span></span></b><br />
<b><span style="color: blue;"><span style="font-size: large;">6. Application Infrastructure</span></span><br /><br />• How many interfaces are in use ? <br /><br />• How many modifications were made and complexity ? <br /><br />• How many user exits were used and complexity ? <br /><br />• Are any additional languages used ? List if Yes. <br /><br />• Which SAP modules are used (including Industry solutions) ? Please also provide version information. <br /><br />• Are any test scripts available ? How current are the test scripts ? </b><br />
<b></b><br />
<b></b><br />
<b></b><br />
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-36294221043437909472014-01-18T12:37:00.002+05:302014-01-23T20:00:23.528+05:30SAP ABAP INTERVIEW QUESTIONS-4<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP INTERVIEW QUESTIONS-4 :-</b></span></u></span><br />
<br />
<b><br /></b>
<b>51. What are the techniques involved in using SAP supplied programs ? Do you prefer to write your own programs to load master data ? Why ? <br /><br />52. What are logical databases ? What are the advantages/disadvantages of logical databases ? <br /><br />53. What specific statements do you using when writing a drill down report ? <br /><br />54. What are different tools to report data in SAP ? What all have you used ? <br /><br />55. What are the advantages and disadvantages of ABAP query tool ? <br /><br />56. What are the functional areas ? User groups ? and how does ABAP query work in relation to these ? <br /><br />57. Is a logical database a requirement/must to write an ABAP query ? <br /><br />58. What is the structure of a BDC sessions. <br /><br />59. What are Change header/detail tables ? Have you used them ? <br /><br />60. What do you do when the system crashes in the middle of a BDC batch session ? <br /><br />61. What do you do with errors in BDC batch sessions ? <br /><br />62. How do you set up background jobs in SAP ? What are the steps ? What are the event driven batch jobs ? <br /><br />63. Is it possible to run host command from SAP environment ? How do you run ? <br /><br />64. What kind of financial periods exist in SAP ? What is the relavent table for that ? <br /><br />65. Does SAP handle multiple currencies ? Multiple languages ? <br /><br />66. What is a currency factoring technique ? <br /><br />67. How do you document ABAP programs ? Do you use program documentation menu option ? <br /><br />68. What is SAP script and layout set ? <br /><br />69. What are the ABAP commands that link to a layout set ? <br /><br />70. What is output determination ? <br /><br />71. What are IDOCs ? <br /><br />72. What are screen painter? menu painter ? Gui status ? ..etc. <br /><br />73. What is screen flow logic ? What are the sections in it ? Explain PAI and PBO. <br /><br />74. Overall how do you write transaction programs in SAP ? <br /><br />75. Does SAP has a GUI screen painter or not ? If yes what operating systems is it available on ? What is the other type of screen painter called ? <br /><br />76. What are step loops ? How do you program page down pageup in step loops ? <br /><br />77. Is ABAP a GUI language ? <br /><br />78. Normally how many and what files get created when a transaction program is written ? What is the XXXXXTOP program ? <br /><br />79. What are the include programs ? <br /><br />80. Can you call a subroutine of one program from another program ? <br /><br />81. What are user exits ? What is involved in writing them ? What precations are needed ? <br /><br />82. What are RFCs ? How do you write RFCs on SAP side ? <br /><br />83. What are the general naming conventions of ABAP programs ? <br /><br />84. How do you find if a logical database exists for your program requrements ? <br /><br />85. How do you find the tables to report from when the user just tell you the transaction he uses ? And all the underlying data is from SAP structures ? <br /><br />86. How do you find the menu path for a given transaction in SAP ? <br /><br />87. What are the different modules of SAP ? <br /><br />88. What is IMG in SAP ? <br /><br />89. How do you get help in ABAP ? <br /><br />90. What are different ABAP editors? What are the differences ? <br /><br />91. What are the different elements in layout sets ? <br /><br />92. Can you use if then else, perform ..etc statements in sap script ? <br /><br />93. What type of variables normally used in sap script to output data ? <br /><br />94. How do you number pages in sapscript layout outputs ? <br /><br />95. What takes most time in SAP script programming ? <br /><br />96. How do you use tab sets in layout sets ? <br /><br />97. How do you backup Sap script layout sets ? Can you download and upload ? How ? <br /><br />98. What are presentation and application servers in SAP ? <br /><br />99. In an ABAP program how do you access data that exists on a presentation server vs on an application server ? <br /><br />100. What are different data types in ABAP ? </b><br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-56052974166539014382014-01-18T12:28:00.001+05:302014-01-18T12:32:38.080+05:30SAP ABAP INTERVIEW QUESTIONS-3<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP INTERVIEW QUESTIONS-3 :-</b></span></u></span><br />
<br />
<br />
<b>1. What is the typical structure of an ABAP program ? <br /><br />2. What are field symbols and field groups ? Have you used "component idx of structure" clause with field groups ? <br /><br />3. What should be the approach for writing a BDC program ? <br /><br />4. What is a batch input session ? <br /><br />5. What is the alternative to batch input session ? <br /><br />6. A situation: An ABAP program creates a batch input session. We need to submit the program and the batch session in background. How to do it ? <br /><br />7. What is the difference between a pool table and a transparent table and how they are stored at the database level. <br /><br />8. What are the problems in processing batch input sessions ? How is batch input process different from processing on line ? <br /><br />9. What do you define in the domain and data element. <br /><br />10. What are the different types of data dictionary objects ? <br /><br />11. How many types of tables exists and what are they in data dictionary ? <br /><br />12. What is the step by step process to create a table in data dictionary ? <br /><br />13. Can a transparent table exist in data dictionary but not in the data base physically ? <br /><br />14. What are the domains and data elements ? <br /><br />15. Can you create a table with fields not referring to data elements ? <br /><br />16. What is the advantage of structures ? How do you use them in the ABAP programs ? <br /><br />17. What does an extract statement do in the ABAP program ? <br /><br />18. What is a collect statement ? How is it different from append ? <br /><br />19. What is open sql vs native sql ? <br /><br />20. What does an EXEC SQL stmt do in ABAP ? What is the disadvantage of using it ? <br /><br />21. What is the meaning of ABAP editor integrated with ABAP data dictionary ? <br /><br />22. What are the events in ABAP language ? <br /><br />23. What is an interactive report ? What is the obvious diff of such report compared with classical type reports ? <br /><br />24. What is a drill down report ? <br /><br />25. How do you write a function module in SAP? describe. <br /><br />26. What are the exceptions in function module ? <br /><br />27. What is a function group ? <br /><br />28. How are the date abd time field values stored in SAP ? <br /><br />29. What are the fields in a BDC_Tab Table. <br /><br />30. Name a few data dictionary objects ? <br /><br />31. What happens when a table is activated in DD ? <br /><br />32. What is a check table and what is a value table ? <br /><br />33. What are match codes? describe ? <br /><br />34. What transactions do you use for data analysis ? <br /><br />35. What is table maintenance generator ? <br /><br />36. What are ranges ? What are number ranges ? <br /><br />37. What are select options and what is the diff from parameters ? <br /><br />38. How do you validate the selection criteria of a report ? And how do you display initial values in a selection screen ? <br /><br />39. What are selection texts ? <br /><br />40. What is CTS and what do you know about it ? <br /><br />41. When a program is created and need to be transported to prodn does selection texts always go with it ? if not how do you make sure ? Can you change the CTS entries ? How do you do it ? <br /><br />42. What is the client concept in SAP ? What is the meaning of client independent ? <br /><br />43. Are programs client dependent ? <br /><br />44. Name a few system global variables you can use in ABAP programs ? <br /><br />45. What are internal tables ? How do you get the number of lines in an internal table ? How to use a specific number occurs statement ? <br /><br />46. How do you take care of performance issues in your ABAP programs ? <br /><br />47. What are datasets ? <br /><br />48. How to find the return code of a stmt in ABAP programs ? <br /><br />49. What are interface/conversion programs in SAP ? <br /><br />50. Have you used SAP supplied programs to load master data ? </b><br />
<b><br /></b>
<b><br /></b>
</div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-52499975959431648042014-01-18T12:01:00.001+05:302014-01-18T12:28:04.622+05:30SAP ABAP INTERVIEW QUESTIONS-2<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP INTERVIEW QUESTIONS-2 :-</b></span></u></span> <br />
<br />
<br />
71. Brief about Testing of programs<br />
<br />
72. How do u move on to the next screen in interactive reporting ?<br />
<br />
73. Create any functions ? How to go about it.<br />
<br />
74. Advanced topics ?<br />
<br />
75. Function modules used in f4 help.<br />
<br />
76. Work most on which module : Name a few tables.<br />
<br />
77. System fields used , system table<br />
<br />
78. From a table how do u find whether a material is used in another material BOM? <br />
<br />
79. SAPscript layout used.<br />
<br />
80. How u used logical database ? How is data transferred to program ? Corresponding statement in LDB<br />
<br />
81. How do u suppress fields on selection screen generated by LDB ?<br />
<br />
82. Can there be more than 1 main window ? <br />
<br />
83. Global and local data in function modules. <br />
<br />
84. What are the differences between sap memory and abap memory<br />
<br />
85 What are differences between At selection-screen and at selection-screen output<br />
<br />
86. What are the events ?<br />
<br />
87. what are the interactive events<br />
<br />
88. What is Hide ? <br />
<br />
89. What is the difference between occurs 1 and occurs 2?<br />
<br />
90. What is the difference between Free and Refresh ?<br />
<br />
91. What are elements ?<br />
<br />
92. Can we have more than one selection-screen and how ?<br />
<br />
93. How to declare select-option as a parameter ?<br />
<br />
94. How can u write programmatically value help to a field without using search help and match codes ?<br />
<br />
95. What is RFC ?<br />
<br />
96. How to set destination ?<br />
<br />
97. What are the function module types ?<br />
<br />
98. What are tables ?<br />
<br />
99. what are client-dependant tables and independent tables ?<br />
<br />
100. how to distinguish them ?<br />
<br />
101. what is the use of Table maintanance allowed ?<br />
<br />
102. What are the domains ?<br />
<br />
103 What are the check tables and value tables ?<br />
<br />
104 What is the difference between table and structures ?<br />
<br />
105 How to declare one internal table with out header line without using structures ?<br />
<br />
106. what are lock objects ? <br />
<br />
107. What are datasets ? what are the different syntaxes ?<br />
<br />
108. What is the differences between we_upload and upload ?<br />
<br />
109. What is the difference between open_form and close_form<br />
<br />
110. What are the page windows ? How many main windows will be there in a page window ?<br />
<br />
111. How to include Logo in your layout ?<br />
<br />
112. How to debugg a script ?<br />
<br />
113. Tell me different standard layouts which we use ?<br />
<br />
114. sapscripts and abap programs are client dependent or not ? why ?<br />
<br />
115. what are the different internal tables ? explain them ?<br />
<br />
116. what is runtime analysis ?<br />
<br />
117. what is the transaction code for Table maintenance ?<br />
<br />
118. what is the difference between sum and collect ?<br />
<br />
119. what are session method and call transaction method and explain about them ?<br />
<br />
120. If you have 10000 records in your file, which method you use in BDC ?<br />
<br />
130. what are different modes and explain them ?<br />
<br />
131. what are control events in a loop ?<br />
<br />
132. what are the events we use in dialog programming? and explain them ?<br />
<br />
133. what are the differences between se01 , se09 and se10 ?<br />
<br />
134. what is the inside concept in select-options ?<br />
<br />
135. what is client ?<br />
<br />
136. what is get cursor field ?<br />
<br />
137. what is read line ?<br />
<br />
138. What is difference between BDC and Call Transaction ? <br />
<br />
139. Setting up a BDC program where you find information from ? <br />
<br />
140. What has to be done to the packed fields before submitting to a BDC session. <br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-9227811728493337002014-01-18T11:52:00.000+05:302014-01-18T12:07:07.044+05:30SAP ABAP INTERVIEW QUESTIONS-1<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP INTERVIEW QUESTIONS-1 :-</b></span></u></span><br />
<br />
<br />
<br />
1. What is sap R/3 ?<br />
<br />
2. What are the programming standards followed ?<br />
<br />
3. What are the contents in technical specifications ?<br />
<br />
4. What is an instance ?<br />
<br />
5. How to take care of performance in ABAP Development ?<br />
<br />
6. What is Function group ? Difference between function group and function module ?<br />
<br />
7. What is the difference between 'Select single * ' and 'Select upto 1 rows' ?<br />
<br />
8. What Function does data dictionary perform ?<br />
<br />
9. Difference between domain and data element ? what are aggregate object ?<br />
<br />
10. what is view ? Different types of view ? explain ?<br />
<br />
11. Can u print decimals in type n ? what is difference between float and packed data type ?<br />
<br />
12. What is step-loop ? explain all the steps ?<br />
<br />
13. What is the initial value and maximum length of all data type ?<br />
<br />
14. What are the ways to find out the tables used in the program ?<br />
<br />
15. Can you have two detail lists from the basic list at the same time ? if yes how and if no why ?<br />
<br />
16. What are the different functions used in sapscript ? What are the parameters used in function ? <br />
<br />
17. What is sequence of event triggered in report ?<br />
<br />
18. What are standard layout sets in the SAP Script ?<br />
<br />
19. What function module upload data from application server ? <br />
<br />
20. What are the various types of selection screen event ?<br />
<br />
21. What do you know about a client ?<br />
<br />
22. What are the system fields ? Explain ?<br />
<br />
23. What is sapscript ? what is the purpose of sapscript ? difference between sapscript and report ?<br />
<br />
24. what is the use of occurs in internal table ? can u change occurs value in program ?<br />
<br />
25. Difference between sy-tabix and sy-index.? where its used ? can u check sy-subrc after perform ?<br />
<br />
26. Difference between upload And ws_upload ? <br />
<br />
27. Why did u switch to SAP ?<br />
<br />
28. What is a Logical Database ?<br />
<br />
29. What are the events used for Logical Database ?<br />
<br />
30. What is the difference between Get and Get Late ?<br />
<br />
31. What are the Types Of Internal Tables ? <br />
<br />
32. What are the events used in ABAP in the order of execution ?<br />
<br />
33. What are Interactive Reports ?<br />
<br />
34. What are the commands used for interactive reports ?<br />
<br />
35. What are the system fields u have worked with ? Explain ?<br />
<br />
36. What is the difference between Primary key and Unique Key ?<br />
<br />
37. What are the types of Internal Tables ?<br />
<br />
38. If u are using Logical Databases how will u modify the selection-screen elements ?<br />
<br />
39. What is an RFC ?<br />
<br />
40. If u are using RFC and passing values to a remote system how does it work ?<br />
<br />
41. What are the events in Screen Programming ?<br />
<br />
42. What is the significance of HIDE ?<br />
<br />
43. Where do u code the HIDE statement ?<br />
<br />
44. Types of BDC's ?<br />
<br />
45. Advantages & Disadvantages of different types of BDC's ?<br />
<br />
46. What are the events used in Interactive Reports.<br />
<br />
47. What is an RDBMS ?<br />
<br />
48. What standards u use to follow while coding ABAP programs ?<br />
<br />
49. What will you code in START-OF-SELECTION & END-OF-SELECTON & why ?<br />
<br />
50. What are joins and different types joins ?<br />
<br />
51. Which is the default join ?<br />
<br />
52. How do u display a data in a Detail List ?<br />
<br />
53. What are the types of windows in SAPSCRIPT ?<br />
<br />
54. What are the function modules used in a SAPSCRIPT driver program ?<br />
<br />
55. What are Extracts ?<br />
<br />
56. How would u go about improving the performance of a Program which selects data from MSEG & MKPF ?<br />
<br />
57. How does System work in case of a Interactive Report ?<br />
<br />
58. what is LUW ?<br />
<br />
59. Different types of LUWs. What r they. <br />
<br />
60. What is First event triggered in program ?<br />
<br />
61. What are various Joins ? What is right outer join ?<br />
<br />
62. How do u find out whether a file exits on the presentation server ? - eps_get_directory_listing for directory<br />
<br />
<br />
63. what are the difference between call screen and leave screen ?<br />
<br />
64. Systems fields used - normal + interactive<br />
<br />
65. Logo in SAP script<br />
<br />
66. If internal table used in for all entries in empty then what happens<br />
<br />
67. If I forgot some command in sapscript eg: suppress zero display - How to do find it ?<br />
<br />
68. Have to write a BDC - how do u go about it ?<br />
<br />
69. What is Performance tuning<br />
<br />
70. Define Documentation<br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-32301885455206165552014-01-16T09:51:00.001+05:302014-01-18T12:07:34.197+05:30SAP ABAP QUESTIONS & ANSWERS-4<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP QUESTIONS & ANSWERS-4 :-</b></span></u></span><br />
<br />
<br />
<span style="color: blue;"><b>Q. Normally how many and what files get created when a transaction program is written ? What is the TOP program ? </b></span><br />
<b>ANS:- </b><br />
ABAP/4 program. <br />
DYNPRO <br />
<span style="color: blue;"><b><br />Q. What are the include programs ? </b></span><br />
<b>ANS:- </b><br />
When the same sequence of statements in several programs are to be written repeadly they are coded in include programs (External programs) and are included in ABAP/4 programs. <br />
<br />
<span style="color: blue;"><b>Q. Can you call a subroutine of one program from another program ? </b></span><br />
<b>ANS:-</b><br />
Yes- only external subroutines Using 'SUBMIT' statement. <br />
<br />
<span style="color: blue;"><b>Q. What are the general naming conventions of ABAP programs ? </b></span><br />
<b>ANS:- </b><br />
Should start with Y or Z. <br />
<br />
<span style="color: blue;"><b>Q. How do you find if a logical database exists for your program requrements ? </b></span><br />
<b>ANS:- </b><br />
SLDB-F4. <br />
<br />
<span style="color: blue;"><b>Q. How do you find the tables to report from when the user just tell you the transaction he uses ? And all the underlying data is from SAP structures ? </b></span><br />
<b>ANS:- </b><br />
Transcode is entered in command field to open the table.Utilities-Table contents-display. <br />
<br />
<span style="color: blue;"><b>Q. What are the different modules of SAP ? </b></span><br />
<b>ANS:- </b><br />
FI,CO,SD,MM,PP,HR. <br />
<br />
<span style="color: blue;"><b>Q. How do you get help in ABAP ? </b></span><br />
<b>ANS:- </b><br />
HELP-SAP LIBRARY,by pressing F1 on a keyword. <br />
<span style="color: blue;"><b><br />Q. What are the different elements in layout sets ?</b></span> <br />
<b>ANS:- </b><br />
PAGES,Page windows,Header,Paragraph,Character String,Windows. <br />
<br />
<span style="color: blue;"><b>Q. Can you use if then else, perform ..etc statements in sap script ? </b></span><br />
<b>ANS:- </b><br />
yes. <br />
<br />
<span style="color: blue;"><b>Q. What takes most time in SAP script programming ? </b></span><br />
<b>ANS:- </b><br />
Layout design and logo insertion. <br />
<br />
<span style="color: blue;"><b>Q. What are presentation and application servers in SAP ? </b></span><br />
<b>ANS:- </b><br />
The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. <br />
<br />
<span style="color: blue;"><b>Q. In an ABAP/4 program how do you access data that exists on a presentation server vs on an application server ? </b></span><br />
<b>ANS:- </b><br />
i)using loop statements. <br />
ii)flat <br />
<span style="color: blue;"><b><br />Q. What are different data types in ABAP/4 ? </b></span><br />
<b>ANS:- </b><br />
Elementary - <br />
predefined C,D,F,I,N,P,T,X. <br />
userdefined TYPES. <br />
ex: see in intel book page no 35/65 <br />
Structured - <br />
predefined TABLES. <br />
userdefined Field Strings and internal tables. <br />
<br />
<span style="color: blue;"><b>Q. What has to be done to the packed fields before submitting to a BDC session. </b></span><br />
<b>ANS:- </b><br />
Fields converted into character type. <br />
<br />
<span style="color: blue;"><b>Q. What is the structure of a BDC sessions. </b></span><br />
<b>ANS:- </b><br />
BDCDATA (standard structure). <br />
<br />
<span style="color: blue;"><b>Q. What are the fields in a BDC_Tab Table. </b></span><br />
<b>ANS:- </b><br />
program,dynpro,dynbegin,fnam,fval. <br />
<br />
<span style="color: blue;"><b>Q. What is the difference between a pool table and a transparent table and how they are stored at the database level. </b></span><br />
<b>ANS:- </b><br />
Pool tables is a logical representation of transparent tables .Hence no existence at database level. Where as transparent tables are physical tables and exist at database level. <br />
<span style="color: blue;"><b><br />Q. What is cardinality ? </b></span><br />
<b>ANS:-</b><br />
For cardinality one out of two (domain or data element) should be the same for Ztest1 and Ztest2 tables. M:N <br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-75628447438194005482014-01-16T09:40:00.002+05:302014-01-18T12:07:52.074+05:30SAP ABAP QUESTIONS & ANSWERS-3<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP QUESTIONS & ANSWERS-3 :-</b></span></u></span><br />
<br />
<br />
<span style="color: blue;"><b>Q. What are interface/conversion programs in SAP ? </b></span><br />
<b>ANS :-</b> <br />
CONVERSION : LEGACY SYSTEM TO FLAT FILE. <br />
INTERFACE : FLAT FILE TO SAP SYSTEM. <br />
<br />
<span style="color: blue;"><b>Q. What are logical databases ? What are the advantages/disadvantages of logical databases ? </b></span><br />
<b>ANS:- </b><br />
To read data from a database tables we use logical database. <br />
A logical database provides read-only access to a group of related tables to an ABAP/4 program. <br />
<b>Adv:- </b><br />
The programmer need not worry about the primary key for each table.Because Logical database knows how the different tables relate to each other,and can issue the SELECT command with proper where clause to retrieve the data. <br />
i)An easy-to-use standard user interface. <br />
ii)check functions which check that user input is complete,correct,and plausible. <br />
iii)meaningful data selection. <br />
iv)central authorization checks for database accesses. <br />
v)good read access performance while retaining the hierarchical data view determined by the application logic. <br />
<b>Disadv:- </b><br />
i)If you donot specify a logical database in the program attributes,the GET events never occur. <br />
ii)There is no ENDGET command,so the code block associated with an event ends with the next event statement (such as another GET or an END-OF-SELECTION). <br />
<br />
<span style="color: blue;"><b>Q. What specific statements do you using when writing a drill down report ? </b></span><br />
<b>ANS:- </b><br />
At line-selection,at user-command,at pf. <br />
<span style="color: blue;"><b><br />Q. What do you do when the system crashes in the middle of a BDC batch session ? </b></span><br />
<b>ANS:- </b><br />
We will look into the error log file (SM35). <br />
<br />
<span style="color: blue;"><b>Q. What do you do with errors in BDC batch sessions ? </b></span><br />
<b>ANS:- </b><br />
We look into the list of incorrect session and process it again. To correct incorrect session we analyize the session to determine which screen and value produced the error.For small errors in data we correct them interactively otherwise <br />
modify batch input program that has generated the session or many times even the datafile. <br />
<br />
<span style="color: blue;"><b>Q. How do you set up background jobs in SAP ? What are the steps ? What are the event driven batch jobs ? </b></span><br />
<b>ANS:- </b><br />
Go to SM36 and create background job by giving job name,job class and job steps(JOB SCHEDULING) <br />
<span style="color: blue;"><b><br />Q. Does SAP handle multiple currencies ? Multiple languages ? </b></span><br />
<b>ANS:- </b><br />
Yes. <br />
<span style="color: blue;"><b><br />Q. What is SAPscript and layout set ? </b></span><br />
<b>ANS:- </b><br />
The tool which is used to create layout set is called SAPscript. Layout set is a design document. <br />
<br />
<span style="color: blue;"><b>Q. What are the ABAP/4 commands that link to a layout set ? </b></span><br />
<b>ANS:- </b><br />
control commands,system commands, <br />
<br />
<span style="color: blue;"><b>Q. What are IDOCs ?</b></span> <br />
<b>ANS:-</b> <br />
IDOCs are intermediate documents to hold the messages as a container. <br />
<br />
<span style="color: blue;"><b>Q. What are screen painter ? menu painter ? Gui status ? ..etc. </b></span><br />
<b>ANS:- </b><br />
Dynpro - flow logic + screens. <br />
Menu painter - <br />
GUI Status - It is subset of the interface elements(title bar,menu bar,standard tool bar,push buttons) used for a certain screen. <br />
The status comprises those elements that are currently needed by the transaction. <br />
<br />
<span style="color: blue;"><b>Q. What is screen flow logic ? What are the sections in it ? Explain PAI and PBO. </b></span><br />
<b>ANS:- </b><br />
The control statements that control the screen flow. <br />
PBO - This event is triggered before the screen is displayed. <br />
PAI - This event is responsible for processing of screen after the user enters the data and clicks the pushbutton. <br />
<br />
<span style="color: blue;"><b>Q. Overall how do you write transaction programs in SAP ? </b></span><br />
<b>ANS:- </b> <br />
Create program-SE93-create transcode-Run it from command field. <br />
<span style="color: blue;"><b><br />Q. What are step loops ? How do you program pagedown pageup in step loops ? </b></span><br />
<b>ANS:- </b><br />
Step loops are repeated blocks of field in a screen. <br />
<span style="color: blue;"><b><br />Q. Is ABAP a GUI language ? </b></span><br />
<b>ANS:-</b> <br />
Yes. <br />
ABAP is an event driven language. <br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-31256592378143168762014-01-16T09:12:00.004+05:302014-01-18T12:08:21.382+05:30SAP ABAP QUESTIONS & ANSWERS-2<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP QUESTIONS & ANSWERS-2 :-</b></span></u></span><br />
<br />
<br />
<b><span style="color: blue;">Q. What is a function group ? </span><br />ANS:- </b><br />
Group of all related functions. <br />
<br />
<span style="color: blue;"><b>Q. How are the date and time field values stored in SAP ? </b></span><br />
<b>ANS:- </b><br />
DD.MM.YYYY. HH:MM:SS <br />
<br />
<span style="color: blue;"><b>Q. Name a few data dictionary objects ? </b></span><br />
<b>ANS:-</b> <br />
Tables,views,structures,lock objects,matchcode objects. <br />
<br />
<span style="color: blue;"><b>Q. What happens when a table is activated in DD ? </b></span><br />
<b>ANS:- </b><br />
It is available for any insertion,modification and updation of records by any user. <br />
<br />
<span style="color: blue;"><b>Q. What is a check table and what is a value table ? </b></span><br />
<b>ANS:-</b><br />
Check table will be at field level checking. <br />
Value table will be at domain level checking ex: scarr table is check table for carrid. <br />
<br />
<span style="color: blue;"><b>Q. What are match codes ? describe ? </b></span><br />
<b>ANS:- </b><br />
It is a similar to table index that gives list of possible values for either primary keys or non-primary keys. <br />
<br />
<b><span style="color: blue;">Q. What are ranges ? What are number ranges ? </span><br />ANS:- </b><br />
Max,min values provided in selection screens. <br />
<br />
<span style="color: blue;"><b>Q. What are select options and what is the diff from parameters ? </b></span><br />
<b>ANS:- </b><br />
select options provide ranges where as parameters do not. <br />
SELECT-OPTIONS declares an internal table which is automatically filled with values or ranges of values entered by the end user. For each SELECT-OPTIONS , the system creates a selection table. <br />
SELECT-OPTIONS <SEL> FOR <field>. <br />
A selection table is an internal table with fields SIGN, OPTION, LOW and HIGH. <br />
The type of LOW and HIGH is the same as that of <field>. <br />
The SIGN field can take the following values: I Inclusive (should apply) E Exclusive (should not apply) The OPTION field can take the following values: EQ Equal GT Greater than NE Not equal BT Between LE Less than or equal NB Not between LT Less than CP Contains pattern GE Greater than or equal NP No pattern.<br />
<b>Diff:- </b><br />
PARAMETERS allow users to enter a single value into an internal field within a report. <br />
SELECT-OPTIONS allow users to fill an internal table with a range of values. <br />
For each PARAMETERS or SELECT-OPTIONS statement you should define text elements by choosing <br />
Goto - Text elements - Selection texts - Change. <br />
<b>Eg:-</b> Parameters name(30). <br />
when the user executes the ABAP/4 program,an input field for 'name' will appear on the selection screen.You can change the comments on the left side of the input fields by using text elements as described in Selection Texts. <br />
<br />
<span style="color: blue;"><b>Q. How do you validate the selection criteria of a report ? And how do you display initial values in a selection screen ? </b></span><br />
<b>ANS:- </b><br />
validate :- by using match code objects. <br />
display :- Parameters <name> default 'xxx'. select-options <name> for spfli-carrid. <br />
<br />
<span style="color: blue;"><b>Q. What is CTS and what do you know about it ? </b></span><br />
<b>ANS:- </b><br />
The Change and Transport System (CTS) is a tool that helps you to organize development projects in the ABAP Workbench and in Customizing, and then transport the changes between the SAP Systems and clients in your system landscape. <br />
This documentation provides you with an overview of how to manage changes with the CTS and essential information on setting up your system and client landscape and deciding on a transport strategy. Read and follow this documentation when planning your development project. <br />
For practical information on working with the Change and Transport System, see Change and Transport Organizer and Transport Management System. <br />
<br />
<span style="color: blue;"><b>Q. Are programs client dependent ? </b></span><br />
<b>ANS:- </b><br />
Yes. Group of users can access these programs with a client no. <br />
<br />
<span style="color: blue;"><b>Q. Name a few system global variables you can use in ABAP programs ? </b></span><br />
<b>ANS:- </b><br />
sy-subrc,sy-dbcnt,sy-lilli,sy-datum,sy-uzeit,sy-ucomm,sy-tabix..... <br />
sy-lilli is absolute no of lines from which the event was triggered. <br />
<br />
<span style="color: blue;"><b>Q. What are internal tables ? How do you get the number of lines in an internal table ? How to use a specific number occurs statement ? </b></span><br />
<b>ANS:- </b><br />
i)It is a standard data type object which exists only during the runtime of the program. <br />
They are used to perform table calculations on subsets of database tables and for re-organising the contents of database tables according to users need. <br />
ii)using SY-DBCNT. <br />
iii)The number of memory allocations the system need to allocate for the next record population. <br />
<br />
<span style="color: blue;"><b>Q. How do you take care of performance issues in your ABAP programs ? </b></span><br />
<b>ANS:-</b><br />
Performance of ABAPs can be improved by minimizing the amount of data to be transferred. <br />
The data set must be transferred through the network to the applications, so reducing the amount OF time and also reduces the network traffic. <br />
Some measures that can be taken are: <br />
- Use views defined in the ABAP/4 DDIC (also has the advantage of better reusability). <br />
- Use field list (SELECT clause) rather than SELECT *. <br />
- Range tables should be avoided (IN operator) <br />
- Avoid nested SELECTS. <br />
<br />
<span style="color: blue;"><b>Q. What are datasets ? </b></span><br />
<b>ANS:- </b><br />
The sequential files(ON APPLICATION SERVER) are called datasets. They are used for file handling in SAP. <br />
<br />
<span style="color: blue;"><b>Q. How to find the return code of a statement in ABAP programs ? </b></span><br />
<b>ANS:- </b><br />
Using function modules. <br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-47459611392013921742014-01-16T00:33:00.001+05:302014-01-18T12:08:35.954+05:30SAP ABAP QUESTIONS & ANSWERS-1<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP ABAP QUESTIONS & ANSWERS-1 :-</b></span></u></span><br />
<span style="color: blue;"><b></b></span><br />
<span style="color: blue;"><b><br /></b></span>
<span style="color: blue;"><b> </b></span><br />
<span style="color: blue;"><b>Q. What is the typical structure of an ABAP/4 program ? </b></span><br />
<b>ANS:-</b> Header ,body,footer. <br />
<br />
<span style="color: blue;"><b>Q. What should be the approach for writing a BDC program ? </b></span><br />
<b>ANS:- </b><br />
step 1: converting the legacy system data to a flat file to internal table called "conversion". <br />
step 2: transfering the flat file into sap system called "sap data transfer". <br />
step 3: depending upon the bdc type <br />
i)call transaction(Write the program explicity) <br />
ii) create sessions (sessions are created and processed.if success data will transfer). <br />
<span style="color: blue;"><b><br />Q. What is a batch input session ? </b></span><br />
<b>ANS:- </b><br />
Batch input session is an intermediate step between internal table and database table. <br />
Data along with the action is stored in session ie data for screen fields, to which screen it is passed,program name behind it, and how next screen is processed. <br />
<span style="color: blue;"><b><br />Q. What is the alternative to batch input session ? </b></span><br />
<b>ANS:- </b><br />
Call transaction. <br />
<br />
<span style="color: blue;"><b>Q. A situation: An ABAP program creates a batch input session. We need to submit the program and the batch session in back ground. How to do it ? </b></span><br />
<b>ANS:</b>- <br />
Go to SM36 and create background job by giving job name,job class and job steps (JOB SCHEDULING) <br />
<br />
<span style="color: blue;"><b>Q. What are the problems in processing batch input sessions ? How is batch input process different from processing online ? </b></span><br />
<b>ANS:- </b><br />
PROBLEMS:- <br />
i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually. <br />
ii)if session processing fails data will not be transferred to SAP database table. <br />
<span style="color: blue;"><b><br />Q. What are the different types of data dictionary objects ?</b></span> <br />
<b>ANS:- </b><br />
Tables, structures, views, domains, data elements, lock objects, Matchcode objects. <br />
<span style="color: blue;"><b><br />Q. How many types of tables exists and what are they in data dictionary ? </b></span><br />
<b>ANS:- </b><br />
4 types of tables <br />
i)Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the same data and fields. Both Opensql and Nativesql can be used. <br />
ii)Pool tables <br />
iii)Cluster tables - These are logical tables that are arranged as records of transparent tables.one cannot use native sql on these tables(only opensql).They are not managable directly using database system tools. <br />
iv)Internal tables. <br />
<br />
<span style="color: blue;"><b>Q. What is the step by step process to create a table in data dictionary ? </b></span><br />
<b>ANS:- </b><br />
step 1: creating domains(data type,field length,range). <br />
step 2: creating data elements(properties and type for a table field). <br />
step 3: creating tables(SE11). <br />
<br />
<span style="color: blue;"><b>Q. Can a transparent table exist in data dictionary but not in the data base physically ? </b></span><br />
<b>ANS:-</b> NO. <br />
Transparent table do exist with the same structure both in the dictionary as well as in the database,exactly with the same data and fields. <br />
<br />
<span style="color: blue;"><b>Q. What are the domains and data elements ? </b></span><br />
<b>ANS:- </b><br />
DOMAINS : Formal definition of the data types.they set attributes such as data type,length,range. <br />
Data element : a field in r/3 system is a data element. <br />
<br />
<span style="color: blue;"><b>Q. Can you create a table with fields not referring to data elements ? </b></span><br />
<b>ANS:-</b> <br />
YES. <br />
eg:- ITAB LIKE SPFLI.here we are referening to a data object(SPFLI) not data element. <br />
<br />
<span style="color: blue;"><b>Q. What is the advantage of structures? How do you use them in the ABAP programs ? </b></span><br />
<b>ANS:-</b> <br />
Adv:- GLOBAL EXISTANCE(these could be used by any other program without creating it again). <br />
<br />
<span style="color: blue;"><b>Q. What does an extract statement do in the ABAP program ? </b></span><br />
<b>ANS:- </b><br />
Once you have declared the possible record types as field groups and defined their structure, you can fill the extract dataset using the following statements: <br />
EXTRACT <fg>. <br />
When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the first extract record to it. In each subsequent EXTRACT statement, the new extract record is added to the dataset <br />
EXTRACT HEADER. <br />
When you extract the data, the record is filled with the current values of the corresponding fields. <br />
As soon as the system has processed the first EXTRACT statement for a field group <fg>, the structure of the corresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups <fg> and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACT statement, a runtime error occurs. <br />
By processing EXTRACT statements several times using different field groups, you fill the extract dataset with records of different length and structure. Since you can modify field groups dynamically up to their first usage in an EXTRACT statement, extract datasets provide the advantage that you need not determine the structure at the beginning of the program. <br />
<br />
<span style="color: blue;"><b>Q. What is a collect statement? How is it different from append ? </b></span><br />
<b>ANS:- </b><br />
If an entry with the same key already exists, the COLLECT statement does not append a new line, but adds the contents of the numeric fields in the work area to the contents of the numeric fields in the existing entry. <br />
<br />
<span style="color: blue;"><b>Q. What are the events in ABAP/4 language ? </b></span><br />
<b>ANS:- </b><br />
Initialization, At selection-screen,Start-of-selection,end-of-selection,top-of-page,end-of-page, At line-selection,At user-command,At PF,Get,At New,At last,at end, at first. <br />
<br />
<span style="color: blue;"><b>Q. What is an interactive report ? What is the obvious diff of such report compared with classical type reports ? </b></span><br />
<b>ANS:- </b><br />
An Interactive report is a dynamic drill down report that produces the list on users choice. <br />
diff:- <br />
a) The list produced by classical report doesn't allow user to interact with the system. <br />
The list produced by interactive report allows the user to interact with the system. <br />
b) Once a classical report executed user looses control.ir user has control. <br />
c) In classical report drilling is not possible.in interactive drilling is possible. <br />
<br />
<span style="color: blue;"><b>Q. What is a drill down report ? </b></span><br />
<b>ANS:- </b><br />
Its an Interactive report where in the user can get more relavent data by selecting explicitly. <br />
<br />
<span style="color: blue;"><b>Q. How do you write a function module in SAP ? describe. </b></span><br />
<b>ANS:- </b><br />
Creating function module:- <br />
called program - se37-creating funcgrp,funcmodule by assigning attributes,importing,exporting,tables,exceptions. <br />
calling program - SE38-in pgm click pattern and write function name- provide export,import,tables,exception values. <br />
<br />
<b><span style="color: blue;">Q. What are the exceptions in function module ? </span><br />ANS:- </b><br />
COMMUNICATION_FAILURE <br />
SYSTEM_FAILURE <br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-55651192753024819732014-01-11T21:26:00.000+05:302014-01-11T21:29:26.632+05:30General Interview Questions<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #274e13;"><u><span style="font-size: large;"><b><br /></b></span></u></span>
<span style="color: #274e13;"><u><span style="font-size: large;"><b>General Interview Questions :-</b></span></u></span><br />
<br />
<br />
<br />
<span style="color: blue;"><b>Q) Tell me about yourself.</b></span><br />
<b>A)</b> Make a short, organized statement of your education and professional achievements and professional goals. Then, briefly describe your qualifications for the job and the contributions you could make to the organization.<br />
<br />
<br />
<span style="color: blue;"><b>Q) Why do you want to work here ? or What about our company interests you ?</b></span><br />
<b>A) </b>Few questions are more important than these, so it is important to answer them clearly and with enthusiasm. Show the interviewer your interest in the company. Share what you learned about the job, the company and the industry through your own research. Talk about how your professional skills will benefit the company. Unless you work in sales, your answer should never be simply: "money." The interviewer will wonder if you really care about the job.<br />
<br />
<br />
<span style="color: blue;"><b>Q) Why did you leave your last job ?</b></span><br />
<b>A)</b> The interviewer may want to know if you had any problems on your last job. If you did not have any problems, simply give a reason, such as: relocated away from job; company went out of business; laid off; temporary job; no possibility of advancement; wanted a job better suited to your skills.<br />
<br />
If you did have problems, be honest. Show that you can accept responsibility and learn from your mistakes. You should explain any problems you had (or still have) with an employer, but don't describe that employer in negative terms. Demonstrate that it was a learning experience that will not affect your future work.<br />
<br />
<br />
<span style="color: blue;"><b>Q) What are your best skills ?</b></span><br />
<b>A)</b> If you have sufficiently researched the organization, you should be able to imagine what skills the company values. List them, then give examples where you have demonstrated these skills.<br />
<br />
<br />
<span style="color: blue;"><b>Q) What is your major weakness ?</b></span><br />
<b>A) </b>Be positive; turn a weakness into strength. For example, you might say: "I often worry too much over my work. Sometimes I work late to make sure the job is done well."<br />
<br />
<br />
<span style="color: blue;"><b>Q) Do you prefer to work by yourself or with others ?</b></span><br />
<b>A) </b>The ideal answer is one of flexibility. However, be honest. Give examples describing how you have worked in both situations.<br />
<br />
<br />
<span style="color: blue;"><b>Q) What are your career goals ? or What are your future plans ?</b></span><br />
<b>A)</b> The interviewer wants to know if your plans and the company's goals are compatible. Let him know that you are ambitious enough to plan ahead. Talk about your desire to learn more and improve your performance, and be specific as possible about how you will meet the goals you have set for yourself.<br />
<br />
<br />
<span style="color: blue;"><b>Q) What are your hobbies ? and Do you play any sports ?</b></span><br />
<b>A)</b> The interviewer may be looking for evidence of your job skills outside of your professional experience. For example, hobbies such as chess or bridge demonstrate analytical skills. Reading, music, and painting are creative hobbies. Individual sports show determination and stamina, while group sport activities may indicate you are comfortable working as part of a team.<br />
<br />
Also, the interviewer might simply be curious as to whether you have a life outside of work. Employees who have creative or athletic outlets for their stress are often healthier, happier and more productive.<br />
<br />
<br />
<span style="color: blue;"><b>Q) What salary are you expecting ?</b></span><br />
<b>A) </b>You probably don't want to answer this one directly. Instead, deflect the question back to the interviewer by saying something like: "I don't know. What are you planning on paying the best candidate?" Let the employer make the first offer.<br />
<br />
However, it is still important to know what the current salary range is for the profession. Find salary surveys at the library or on the Internet, and check the classifieds to see what comparable jobs in your area are paying. This information can help you negotiate compensation once the employer makes an offer.<br />
<br />
<br />
<span style="color: blue;"><b>Q) What have I forgotten to ask ?</b></span><br />
<b>A) </b>Use this as a chance to summarize your good characteristics and attributes and how they may be used to benefit the organization. Convince the interviewer that you understand the job requirements and that you can succeed.<br />
<br />
<br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-44337498307137756142014-01-11T20:55:00.000+05:302014-01-18T12:16:16.599+05:30SAP BI QUESTIONS & ANSWERS-10<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP BI QUESTIONS & ANSWERS-10 :-</b></span></u></span><br />
<br />
<br />
<span style="color: blue;"><b>1) Transaction Code for the following ?</b></span><br />
<b>A)</b> 1) To delete setup tables -> LBWG<br />
2) To fill setup tables -> OLI*BW<br />
3) Currency exchange rates -> OB08<br />
4) BW Delta Queue Monitor -> RSA7<br />
5) DB connect -> RSDBC<br />
<br />
<span style="font-size: small;"><span style="color: blue;"><b>2) What is Real Time Data Acquisition ?</b></span></span><br />
<b>A) </b>Real-time data acquisition supports tactical decision-making. It also supports operational reporting by allowing you to send data to the delta queue or PSA table in real-time. You then use a daemon to transfer Data Store objects to the operational Data Store layer at frequent regular intervals. The data is stored persistently in BI.<br />
<br />
<span style="color: blue;"><b>3) Difference between display attributes and navigational attributes ? </b></span> <br />
<b>A)</b> Display attribute is one which is used only for display purpose in the report.Where as navigational attribute is used for drilling down in the report.We don't need to maintain Nav attribute in the cube as a characteristic(that is the advantage) to drill down.<br />
<br />
<span style="color: blue;"><b>4) What are the different variables used in BEX ?</b></span><br />
<b>A)</b> Variable with default entry <br />
Replacement path <br />
SAP exit <br />
Customer exit <br />
Authorization<br />
<br />
<span style="color: blue;"><b>5) What are Return Tables ?</b></span><br />
<b>A)</b> When we want to return multiple records, instead of single value, we use the return table in the Update Routine. Example: If we have total telephone expense for a Cost Center, using a return table we can get expense per employee<br />
<br />
<span style="color: blue;"><b>6) What are Start routines, Transfer routines and Update routines ?</b></span><br />
<b>A)</b> Start Routines: The start routine is run for each DataPackage after the data has been written to the PSA and before the transfer rules have been executed. It allows complex computations for a key figure or a characteristic. It has no return value. Its purpose is to execute preliminary calculations and to store them in global DataStructures. This structure or table can be accessed in the other routines. The entire DataPackage in the transfer structure format is used as a parameter for the routine. <br />
• Transfer / Update Routines: They are defined at the InfoObject level. It is like the Start Routine. It is independent of the DataSource. We can use this to define Global Data and Global Checks.<br />
<br />
<span style="color: blue;"><b>7) What is the difference between ODS and InfoCube and MultiProvider ?</b></span><br />
<b>A)</b> ODS: Provides granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI. <br />
• CUBE: Follows the star schema, we can only append data, ideal for primary reporting. <br />
• MultiProvider: Does not have physical data. It allows to access data from different InfoProviders (Cube, ODS, InfoObject). It is also preferred for reporting.<br />
<br />
<span style="color: blue;"><b>8) What are the steps involved in LO Extraction ?</b></span><br />
<b>A)</b> The steps are:<br />
• RSA5 Select the DataSources<br />
• LBWE Maintain DataSources and Activate Extract Structures<br />
• LBWG Delete Setup Tables<br />
• 0LI*BW Setup tables <br />
• RSA3 Check extraction and the data in Setup tables<br />
• LBWQ Check the extraction queue<br />
• LBWF Log for LO Extract Structures<br />
• RSA7 BW Delta Queue Monitor.<br />
<br />
<span style="color: blue;"><b>9) Can an InfoObject be an InfoProvider, how and why ?</b></span><br />
<b>A)</b> Yes, when we want to report on Characteristics or Master Data. We have to right click on the InfoArea and select "Insert characteristic as data target". For example, we can make 0CUSTOMER as an InfoProvider and report on it.<br />
<br />
<span style="color: blue;"><b>10) What are Process Types & Process variant ?</b></span><br />
<b>A)</b> Process types are General services, Load Process & subsequent processing, Data Target Administration, Reporting agent & Other BW services. <br />
Process variant (start variant) is the place the process type knows when & where to start.<br />
<br />
<span style="color: blue;"><b>11) Four types of Sid tables ?</b></span><br />
<b>A)</b> X time independent navigational attributes sid tables<br />
Y time dependent navigational attributes sid tables <br />
H hierarchy sid tables<br />
I hierarchy structure sid tables.<br />
<br />
X-table = A table to link material SIDs with SIDs for time-independent navigation attributes. <br />
Y-table = A table to link material SIDs with SIDS for time-dependent navigation attributes.<br />
<br />
<span style="color: blue;"><b>12) How can you improve the performance of a query ?</b></span><br />
<b>A) </b>Query Performance can be improved by making the Aggregates having all the Chars & KF used in Query.<br />
<br />
<br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-83573591535490503572014-01-11T20:36:00.001+05:302014-01-18T12:18:28.035+05:30SAP BI QUESTIONS & ANSWERS-9<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP BI QUESTIONS & ANSWERS-9 :-</b></span></u></span><br />
<br />
<br />
<br />
<span style="color: blue;"><b>1) what is the t-code to create INDEX in SAP BI(7.0) ? /How can we create the index in SAP BW/BI ?</b></span><br />
<b>A)</b> I am sorry as I am not aware of TCode for Index. But, I can roughly tell how to create Index. Creating Indexing is apart of Performance Issues on Query. As we know thatwhenever we load data to the data target, Primary indexesare created automatically and uses Linear search i.e, searchrecord by record, whereas when we can create SecondaryIndexes, it will follow Binary search and hence the queryperformance improves. <br />
To create a Secondary Index, <br />
<b>1.</b> Select your data target(Infocube or DSO)and select contextmenu and select Manage.<br />
<b>2</b>. Select the Performance tab and select 'Create Index' button.<br />
<b>3</b>. In the new dialog box, Select 'Selection' and then select'Immediate' and click Save.<br />
<b>4</b>. Select 'Start' and click 'Continue'.<br />
Once the Secondary Index is created, a check mark is createdin front of the data target.<br />
<b>B)</b> Index can be created by managing a cube. There are two types of indexes. They are primary index and secondary index.Primary index is automatically created by the system ie system generated index. Secondary index is created by us.<br />
Indexing is a process of storing data according to an index like in a phone book. Secondary indexes are of bit map andbinary tree.<br />
<br />
<b><span style="color: blue;">2) how can we enhance the data sources, explain me with example ?</span><br />A)</b><br />
<b>1</b>.find the structure of the data source and goto se11 using append structure add the require fileds to the structure and activate<br />
<b>2</b>.goto rsa6 select ur datasource and click on change icon and unhide the fileds and generate the datasoure.<br />
<b>3.</b> goto tcode cmod create a project and assign RSRA0001 <br />
write the require code in the standard Include.<br />
enhancement name is RSAP0001<br />
find the structure of the datasource i.e in rsa5 and goto se11 using append structure add the require fileds to the structure and activategoto rsa6 select ur datasource and click on change icon and unhide the fileds(important)and generate the datasoure.<br />
goto tcode cmod create a project and assign RSAP0001write the require code in the standard Include.<br />
<br />
<b><span style="color: blue;">3) Explain about monitering tcodes RSMO RSPC RSPCM and how to work with the DATA LOAD issues ?</span><br />A)</b><br />
RSMO: monitoring the data loads. <br />
RSPC: for creating process chains<br />
RSPCM: monitor daily process chains.<br />
RSPC: using RSPC we can create a process chain to schedule any data load.<br />
RSPCM: After creating the process chain at RSPC level, if u wants to monitor the data load(data failures)we should add that process chain to RSPCM which is used to monitor all the data loads.<br />
RSMO: used to monitor data loads which are scheduled by only process chains.<br />
<br />
<span style="color: blue;"><b>4) what are the errors in process chain, how can we solve them ?</b></span><br />
<b>A)</b> IN log overview we can check what all errors are there and Accordingly handle the errorsThis key figure (0TCTNPRSTER) specifies the number of Processes or process chains that finished with errors. The key figure has the data type DEC (number).<br />
<br />
<span style="color: blue;"><b>5) What is difference between BI and BO'S with BI ?</b></span><br />
<b>A)</b> In BI we are using BEx suite for different reporting requirements but in BO's we have so many components which solves various reporting requirements in terms of more visualization. <br />
<br />
Crystal report designer in BO similar to Report designer in BI<br />
Xcelsius similar to WAD,<br />
Bex analyzer similar to Voyager<br />
<br />
By using Universe designer we create a universe (similar to Multiprovider) in BO and we can use this universe to create reports. A BI connection is needed to create universe in BO (nothing but source system connection in BI.<br />
<br />
<span style="color: blue;"><b>6) I want to start a new project with NW BI 7.0. Which frontends do I use ?</b></span><br />
<b>A)</b><br />
• It is generally recommended to evaluate and use the Busines Object premium packages. <br />
• For selected areas, such as web- & Excel based OLAP analysis, it will still be beneficial to leverage BEx Analyzer & BEx Web Analyzer for new projects as they provide superior OLAP features compared to Busines Object Voyager. <br />
• Projects requiring an Excel OLAP Integration should be carried out with BEx Analyzer until Pioneer arrives. <br />
• If you are already experienced with the BEx Web Applications Designer, and want to build heavy weight BI Web applications, you can still do this using BEx Web Application Designer, but please evaluate Visual Composer in NW Composition Environment 7.1.1, as VC/CE tools will be the go-to solutions for design of web-based, composite applications in the future. <br />
<br />
<span style="color: blue;"><b>7) What is variable exit ? Give me its structure ?</b></span><br />
<b>A)</b> SAP provides a variable of type customer exit for BW queries which customer is able to manage its values depends on their business requirements. It is necessary some background in ABAP to start in this area, the proposal of this document is to help on those tasks. It is structured in the following sequence: <br />
Project management of SAP Enhancements <br />
Query BEX Query Designer and Variable Type Customer Exit <br />
Customer Exit and ABAP Code <br />
Test and Debug <br />
Additional Information <br />
<br />
<span style="color: blue;"><b>8) After starting an InfoPackage, I can't see any job running in SM37. How can this possibly be ?</b></span><br />
<b>A)</b> In the source system, the extraction job has the name BI*<request id>. If the DataSource is in SAP ERP, you can check for this job in your ERP system and see what's the status of the extraction. If you're moving data from BW to BW itself (e.g. you're loading data from a DSO to a datamart InfoCube), the extraction job will be running in BW itself.<br />
Once the extraction job has been completed, in the BW system the data update is done through a dialog process, which you can only monitor in SM50. You won't see any jobs in SM37 related to the update.<br />
<br />
In the Scheduling tab of an InfoPackage, you can choose between two options:<br />
• Start Data Load Immediately - The request will be created in foreground using dialog process;<br />
• Start Later in Batch - The request will be created using a backgroud job.<br />
However, this only refers to the request creation. Even if you choose the 2nd option, the completion of this job doesn't mean that the load has been completed as well. It just means that the request has been created successfully.<br />
Only when you check the option Request Batch Process Runs Until All Data Has Been Updated in BW this job will be running in SM37 till the upload is complete. Otherwise the only way to monitor your load is SM37 for the extractor job and SM50 for the ETL processing and the update into a data target.<br />
Notice also that the Start Later in Batch setting is hidden if the InfoPackage is used in a process chain. This is because the start of the request is determined by the process chain itself. Therefore, the request is created by the job associated to the process chain's process<br />
<br />
<span style="color: blue;"><b>9) What is the use of BI accelerator monitor ?</b></span><br />
<b>A)</b> The BI accelerator monitor is used for the technical administration and maintenance of the BI accelerator. It provides an overview of the current status of the BI accelerator.<br />
The BI accelerator monitor displays the results of the consistency checks. These checks run periodically on the BI accelerator. If problems occur, the system automatically proposes appropriate actions. These actions involve BI accelerator repair functions which can be used to fix problems.<br />
The detailed BI accelerator monitors offers a detailed, technical overview of the hardware, BI accelerator services, any trace files that exist and the BI accelerator indexes.<br />
<br />
<span style="color: blue;"><b>10) Why do you go for function module in generic extraction ?</b></span><br />
<b>A)</b> If you have to get data from more than 1 table and also incorporate some logic then you would use a fn module extractor. It is like a program where you would code using ABAP and have all your logic incorporated.<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-10743478475286854462014-01-10T14:53:00.003+05:302014-01-18T12:17:17.318+05:30SAP BI QUESTIONS & ANSWERS-8<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP BI QUESTIONS & ANSWERS-8 :-</b></span></u></span><br />
<br />
<br />
<span style="color: blue;"><b>Q) Different types in LO's ?</b></span><br />
<b>A)</b> Direct Delta, Queued Delta, Serialized V3 update, Unserialized V3 Update.<br />
Direct Delta: - With every document posted in R/3, the extraction data is transferred directly into the BW delta queue. Each document posting with delta extraction becomes exactly one LUW in the corresponding Delta queue. <br />
Queued Delta: - The extraction data from the application is collected in extraction queue instead of as update data and can be transferred to the BW delta queue by an update collection run, as in the V3 update.<br />
<br />
<span style="color: blue;"><b>Q) What does LO Cockpit contain ?</b></span><br />
<b>A) </b><br />
* Maintaining Extract structure.<br />
* Maintaining DataSources.<br />
* Activating Updates.<br />
* Controlling Updates. <br />
<br />
<span style="color: blue;"><b>Q) What are Process Chains ?</b></span><br />
<b>A)</b> TCode is RSPC, is a sequence of processes scheduled in the background & waiting to be triggered by a specific event. Process chains nothing but grouping processes. Process variant (start variant) is the place the process chain knows where to start.<br />
There should be min and max one start variant in each process chain, here we specify when should the process chain start by giving date and time or if you want to start immediately<br />
Some of theses processes trigger an event of their own that in-turn triggers other processes. <br />
Ex: - Start chain &#8594; Delete BCube indexes &#8594; Load data from the source system to PSA &#8594;<br />
Load data from PSA to DataTarget ODS &#8594; Load data from ODS <br />
to BCube &#8594; Create Indexes for BCube after loading data &#8594; Create database statistics &#8594; Roll-Up data into the aggregate &#8594; Restart chain from beginning. <br />
<br />
<span style="color: blue;"><b>Q) What are Process Types & Process variant ?</b></span><br />
<b>A)</b> Process types are General services, Load Process & subsequent processing, Data Target Administration, Reporting agent & Other BW services. <br />
Process variant (start variant) is the place the process type knows when & where to start. <br />
<br />
<span style="color: blue;"><b>Q) Difference between MasterData & Transaction InfoPackage ?</b></span><br />
<b>A)</b> 5 tabs in Masterdata & 6 tabs in Transaction data, the extra tab in Transaction data is DATA TARGETS. <br />
<br />
<span style="color: blue;"><b>Q) Types of Updates ?</b></span><br />
<b>A)</b> Full Update, Init Delta Update & Delta Update. <br />
<br />
<span style="color: blue;"><b>Q) For Full update possible while loading data from R/3 ?</b></span><br />
<b>A)</b> InfoPackage &#8594; Scheduler &#8594; Repair Request flag (check).<br />
This is only possible when we use MM & SD modules. <br />
<br />
<span style="color: blue;"><b>Q) Why it takes more time while loading the transaction data even to load the transaction without master data (we check the checkbox, Always Update data, even if no master data exits for the data) ?</b></span><br />
<b>A)</b> Because while loading the data it has to create SID keys for transaction data. <br />
<br />
<span style="color: blue;"><b>Q) For what we use HIDE fields, SELECT fields & CANCELLATION fields ?</b></span><br />
<b>A)</b> Selection fields-- The only purpose is when we check this column, the field will appear in InfoPackage Data selection tab.<br />
Hide fields -- These fields are not transferred to BW transfer structure.<br />
Cancellation - It will reverse the posted documents of keyfigures of customer defined by multiplying it with -1...and nullifying the value.<br />
I think this is reverse posting <br />
<br />
<span style="color: blue;"><b>Q) Transporting.</b></span><br />
<b>A) </b>When it comes to transporting for R/3 and BW, u should always transport all the R/3 Objects first………once you transport all the R/3 objects to the 2nd system, you have to replicate the datasources into the 2nd BW system…and then transport BW objects.<br />
First you will transport all the datasources from 1st R/3 system to 2nd R/3 System. Second, you will replicate the datasources from 2nd R/3 system into 2nd BW system. Third, you will transport all the BW Objects from 1st BW system to 2nd BW system. <br />
You have to send your extractors first to the corresponding R/3 Q Box and replicate that to BW. Then you have to do this transport in BW. Development, testing and then production <br />
<br />
<span style="color: blue;"><b>Q) When does a transfer structure contain more fields than the communication structure of an InfoSource ?</b></span><br />
<b>A) </b>If we use a routine to enhance a field in the communication from several fields in the transfer structure, the communication structure may contain more fields.<br />
<br />
<span style="color: blue;"><b>Q) What is the PSA, technical name of PSA, Uses ?</b></span><br />
<b>A) </b>When we want to delete the data in InfoProvider & again want to re-load the data, at this stage we can directly load from PSA not going to extract from R/3.<br />
<br />
<span style="color: blue;"><b>Q) Variables in Reporting ?</b></span><br />
<b>A) </b>Characteristics values, Text, Hierarchies, Hierarchy nodes & Formula elements, <br />
<br />
<span style="color: blue;"><b>Q) Variable processing types in Reporting ?</b></span><br />
<b>A)</b> Manual, Replacement path, SAP Exit, Authorizations, Customer Exit <br />
<br />
<span style="color: blue;"><b>Q) Why we use this RSRP0001 Enhancement ?</b></span><br />
<b>A)</b> For enhancing the Customer Exit in reporting. <br />
<br />
<span style="color: blue;"><b>Q) What is the use of Filters ?</b></span><br />
<b>A)</b> It Restricts Data. <br />
<br />
<span style="color: blue;"><b>Q) What is the use of Conditioning ?</b></span><br />
<b>A)</b> To retrieve data based on particular conditions like less than, greater than, less than or equal etc., <br />
<br />
<span style="color: blue;"><b>Q) What is NODIM ?</b></span><br />
<b>A)</b> For example it converts 5lts + 5kgs = 10. <br />
<br />
<span style="color: blue;"><b>Q) What for Exception's ? How can I get PINK color ?</b></span><br />
<b>A)</b> To differentiate values with colors, by adding relevant colors u can get pink. <br />
<br />
<span style="color: blue;"><b>Q) Why SAPLRSAP is used ?</b></span><br />
<b>A) </b>We use these function modules for enhancing in r/3. <br />
<br />
<span style="color: blue;"><b>Q) Where are workbooks saved ?</b></span><br />
<b>A)</b> Workbooks are saved in favorites. <br />
<br />
<span style="color: blue;"><b>Q) Can Favorites accessed by other users ?</b></span><br />
<b>A)</b> No, they need authorization. <br />
<br />
<span style="color: blue;"><b>Q) What is InfoSet ?</b></span><br />
<b>A)</b> An InfoSet is a special view of a dataset, such as logical database, table join, table, and sequential file, and is used by SAP Query as a source data. InfoSets determine the tables or fields in these tables that can be referenced by a report. In most cases, InfoSets are based on logical databases.<br />
SAP Query includes a component for maintaining InfoSets. When you create an InfoSet, a DataSource in an application system is selected. <br />
Navigating in a BW to an InfoSet Query, using one or more ODS objects or InfoObjects.<br />
You can also drill-through to BEx queries and InfoSet Queries from a second BW system, that isConnected as a data mart. <br />
The InfoSet Query functions allow you to report using flat data tables (master data reporting).<br />
Choose InfoObjects or ODS objects as data sources. These can be connected using joins.<br />
You define the data sources in an InfoSet. An InfoSet can contain data from one or more tables that are connected to one another by key fields.<br />
The data sources specified in the InfoSet form the basis of the InfoSet Query. <br />
<br />
<span style="color: blue;"><b>Q) LO's ?</b></span><br />
<b>A)</b><br />
Synchronous update (V1 update)<br />
Statistics update is carried out at the same time as the document update in the same task.<br />
• Asynchronous update (V2 update)<br />
Document update and the statistics update take place separately in different tasks.<br />
• Collective update (V3 update)<br />
Again, document update is separate from the statistics update. However, in contrast to the V2 update, the V3 collective statistics update must be scheduled as a job. <br />
Successfully scheduling the update will ensure that all the necessary information<br />
Structures are properly updated when new or existing documents are processed.<br />
Scheduling intervals should be based on the amount of activity on a particular OLTPsystem. For example, a development system with a relatively low or no volume of new documents may only need to run the V3 update on a weekly basis. A full production environment, with hundreds of transactions per hour may have to be updated every 15 to 30 minutes.<br />
SAP standard background job scheduling functionality may be used in order to schedule the V3 updates successfully. It is possible to verify that all V3 updates are successfully completed via transaction SM13. This transaction will take you to the “UPDATE RECORDS: MAIN MENU” screen. At this screen, enter asterisk as your user (for all users), flag the radio button 'All' and hit enter. Any outstanding V3 updates will be listed. While a non-executed V3 update will not hinder your OLTP system, by administering the V3 update jobs properly, your information structures will be current and overall performance will be improved.</div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-40289283147349124072014-01-10T14:43:00.000+05:302014-01-18T12:17:28.127+05:30SAP BI QUESTIONS & ANSWERS-7<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP BI QUESTIONS & ANSWERS-7 :-</b></span></u></span><br />
<br />
<b><br /><span style="color: blue;">Q) What does InfoCube contains ?</span></b><br />
<b>A)</b> Each InfoCube has one FactTable & a maximum of 16 (13+3 system defined, time, unit & data packet) dimensions. <br />
<br />
<span style="color: blue;"><b>Q) What does FACT Table contain ?</b></span><br />
<b>A)</b> FactTable consists of KeyFigures. <br />
Each Fact Table can contain a maximum of 233 key figures.<br />
Dimension can contain up to 248 freely available characteristics. <br />
<br />
<span style="color: blue;"><b>Q) How many dimensions are in a CUBE ?</b></span><br />
<b>A)</b> 16 dimensions. (13 user defined & 3 system pre-defined [time, unit & data packet]) <br />
<br />
<span style="color: blue;"><b>Q) What does SID Table contain ?</b></span><br />
<b>A)</b> SID keys linked with dimension table & master data tables (attributes, texts, hierarchies) <br />
<br />
<span style="color: blue;"><b>Q) What does ATTRIBUTE Table contain ?</b></span><br />
<b>A)</b> Master attribute data <br />
<br />
<span style="color: blue;"><b>Q) What does TEXT Table contain ?</b></span><br />
<b>A)</b> Master text data, short text, long text, medium text & language key if it is language dependent <br />
<br />
<span style="color: blue;"><b>Q) What does Hierarchy table contain ?</b></span><br />
<b>A) </b>Master hierarchy data <br />
<br />
<span style="color: blue;"><b>Q)Differences between STAR Schema & Extended Schema ?</b></span><br />
<b>A) </b>In STAR SCHEMA, A FACT Table in center, surrounded by dimensional tables and the dimension tables contains of master data. In Extended Schema the dimension tables does not contain master data, instead they are stored in Masterdata tables divided into attributes, text & hierarchy. These Masterdata & dimensional tables are linked with each other with SID keys. Masterdata tables are independent of Infocube & reusability in other InfoCubes. <br />
<br />
<span style="color: blue;"><b>Q) As to where in BW do you go to add a character like a \; # so that BW will accept it. This is transaction data which loads fine in the PSA but not the data target.</b></span><br />
<b>A)</b> Check transaction SPRO ---Then click the "Goggles"-Button => Business <br />
Information Warehouse => Global Settings => 2nd point in the list. I <br />
hope you can use my "Guide" (my BW is in german, so i don't know all the english descriptions). <br />
<br />
<span style="color: blue;"><b>Q) When are Dimension ID's created ?</b></span><br />
<b>A)</b> When Transaction data is loaded into InfoCube. <br />
<br />
<span style="color: blue;"><b>Q) When are SID's generated ?</b></span><br />
<b>A) </b>When Master data loaded into Master Tables (Attr, Text, Hierarchies). <br />
<br />
<span style="color: blue;"><b>Q) How would we delete the data in ODS ?</b></span><br />
<b>A) </b>By request IDs, Selective deletion & change log entry deletion.<br />
<br />
<span style="color: blue;"><b>Q) How would we delete the data in change log table of ODS ?</b></span><br />
<b>A)</b> Context menu of ODS &#8594; Manage &#8594; Environment &#8594; change log entries. <br />
<br />
<span style="color: blue;"><b>Q) What are the extra fields does PSA contain ?</b></span><br />
<b>A)</b> Record id, Data packet<br />
<br />
<span style="color: blue;"><b>Q) Partitioning possible for ODS ?</b></span><br />
<b>A)</b> No, It's possible only for Cube. <br />
<br />
<span style="color: blue;"><b>Q) Why partitioning ?</b></span><br />
<b>A)</b> For performance tuning. <br />
<br />
<span style="color: blue;"><b>Q) Have you ever tried to load data from 2 InfoPackages into one cube ? </b></span><br />
<b>A)</b> Yes. <br />
<br />
<span style="color: blue;"><b>Q) Different types of Attributes ?</b></span><br />
<b>A)</b> Navigational attribute, Display attributes, Time dependent attributes, Compounding attributes, Transitive attributes, Currency attributes. <br />
<br />
<span style="color: blue;"><b>Q) Transitive Attributes ?</b></span><br />
<b>A)</b> Navigational attributes having nav attr…these nav attrs are called transitive attrs <br />
<br />
<span style="color: blue;"><b>Q) Navigational attribute ?</b></span><br />
<b>A)</b> Are used for drill down reporting (RRI). <br />
<br />
<span style="color: blue;"><b>Q) Display attributes ?</b></span><br />
<b>A)</b> You can show DISPLAY attributes in a report, which are used only for displaying. <br />
<br />
<span style="color: blue;"><b>Q) How does u recognize an attribute whether it is a display attribute or not ?</b></span><br />
<b>A)</b> In Edit characteristics of char, on general tab checked as attribute only. <br />
<br />
<span style="color: blue;"><b>Q) How do we convert Master data InfoObject to a Data target ? </b></span><br />
<b>A)</b> InfoArea &#8594; Infoprovider (context menu) &#8594; Insert characteristic Data as DataTarget. <br />
<br />
<span style="color: blue;"><b>Q) How do we load the data if a FlatFile consists of both Master and Transaction data ?</b></span><br />
<b>A)</b> Using Flexible update method while creating InfoSource. <br />
<br />
<span style="color: blue;"><b>Q) Steps in LO are Extraction ?</b></span><br />
<b>A) </b><br />
* Maintain extract structures. (R/3)<br />
* Maintain DataSources. (R/3)<br />
* Replicate DataSource in BW.<br />
* Assign InfoSources.<br />
* Maintain communication structures/transfer rules.<br />
* Maintain InfoCubes & Update rules.<br />
* Activate extract structures. (R/3)<br />
* Delete setup tables/setup extraction. (R/3)<br />
* InfoPackage for the Delta initialization.<br />
* Set-up periodic V3 update. (R/3)<br />
* InfoPackage for Delta uploads. <br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-58886372931426526762014-01-09T14:00:00.001+05:302014-01-18T12:20:15.029+05:30SAP BI QUESTIONS & ANSWERS-6<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP BI QUESTIONS & ANSWERS-6 :-</b></span></u></span><br />
<br />
<br />
<span style="color: blue;"><b>Q) How can u analize the project at first ? </b></span><br />
<b>A)</b> Prepare Project Plan and Environment <br />
Define Project Management Standards and Procedures <br />
Define Implementation Standards and Procedures<br />
Testing & Go-live + supporting. <br />
<br />
<span style="color: blue;"><b>Q) There is one ods and 4 infocubes. we send data at time to all cubes if one cube got lock error. how can u rectify the error ? </b></span><br />
<b>A)</b> Go to TCode sm66 then see which one is locked select that pid from there and goto sm12 TCode then unlock it this is happened when lock errors are occurred when u scheduled. <br />
<br />
<span style="color: blue;"><b>Q) Can anybody tell me how to add a navigational attribute in the BEx report in the rows ?</b></span><br />
<b>A)</b> Expand dimension under left side panel (that is infocube panel) select than navigational attributes drag and drop under rows panel. <br />
<br />
<span style="color: blue;"><b>Q) if any trasaction code like smpt or stmt. </b></span><br />
<b>A)</b> In current systems (BW 3.0B and R/3 4.6B) these Tcodes don't exist <br />
<br />
<span style="color: blue;"><b>Q) what is transactional cube ?</b></span><br />
<b>A)</b> Transactional InfoCubes differ from standard InfoCubes in that the former have an improved write access performance level. Standard InfoCubes are technically optimized for read-only access and for a comparatively small number of simultaneous accesses. Instead, the transactional InfoCube was developed to meet the demands of SAP Strategic Enterprise Management (SEM), meaning that, data is written to the InfoCube (possibly by several users at the same time) and re-read as soon as possible. Standard Basic cubes are not suitable for this. <br />
<br />
<span style="color: blue;"><b>Q) Is there any way to delete cube contents within update rules from an ODS data source? The reason for this would be to delete (or zero out) a cube record in an "Open Order" cube if the open order quantity was 0. I've tried using the 0recordmode but that doesn't work. Also, would it be easier to write a program that would be run after the load and delete the records with a zero open qty ? </b></span><br />
A) START routine for update rules u can write ABAP code.<br />
B) Yap, you can do it. Create a start routine in Update rule. <br />
It is not "Deleting cube contents with update rules" It is only possible to avoid that some content is updated into the InfoCube using the start routine. Loop at all the records and delete the record that has the condition. "If the open order quantity was 0" You have to think also in before and after images in case of a delta upload. In that case you may delete the change record and keep the old and after the change the wrong information. <br />
<br />
<span style="color: blue;"><b>Q) I am not able to access a node in hierarchy directly using variables for reports. When I am using Tcode RSZV it is giving a message that it doesn't exist in BW 3.0 and it is embedded in BEx. Can any one tell me the other options to get the same functionality in BEx ?</b></span><br />
<b>A)</b> Tcode RSZV is used in the earlier version of 3.0B only. From 3.0B onwards, it's possible in the Query Designer (BEx) itself. Just right click on the InfoObject for which you want to use as variables and precede further selecting variable type and processing types. <br />
<br />
<span style="color: blue;"><b>Q) In BW we need to write abap routines. I wish to know when and what type of abap routines we got to write. Also, are these routines written in update rules? I will be glad, if this is clarified with real-time scenarios and few examples ?</b></span><br />
<b>A)</b> Over here we write our routines in the start routines in the update rules or in the transfer structure (you can choose between writing them in the start routines or directly behind the different characteristics. In the transfer structure you just click on the yellow triangle behind a characteristic and choose "routine". In the update rules you can choose "start routine" or click on the triangle with the green square behind an individual characteristic. Usually we only use start routine when it does not concern one single characteristic (for example when you have to read the same table for 4 characteristics). I hope this helps. <br />
<br />
We used ABAP Routines for example:<br />
To convert to Uppercase (transfer structure)<br />
To convert Values out of a third party tool with different keys into the same keys as our SAP System uses (transfer structure)<br />
To select only a part of the data for from an infosource updating the InfoCube (Start Routine) etc. <br />
<br />
<span style="color: blue;"><b>Q) What is ODS ?</b></span><br />
<b>A) </b>An ODS object acts as a storage location for consolidated and cleaned-up transaction data (transaction data or master data, for example) on the document (atomic) level.<br />
This data can be evaluated using a BEx query.<br />
Standard ODS Object<br />
Transactional ODS object: <br />
The data is immediately available here for reporting. For implementation, compare with the Transactional ODS Object.<br />
<br />
A transactional ODS object differs from a standard ODS object in the way it prepares data. In a standard ODS object, data is stored in different versions ((new) delta, active, (change log) modified), where as a transactional ODS object contains the data in a single version. Therefore, data is stored in precisely the same form in which it was written to the transactional ODS object by the application. In BW, you can use a transaction ODS object as a data target for an analysis process.<br />
<br />
The transactional ODS object is also required by diverse applications, such as SAP Strategic Enterprise Management (SEM) for example, as well as other external applications.<br />
<br />
Transactional ODS objects allow data to be available quickly. The data from this kind of ODS object is accessed transactionally, that is, data is written to the ODS object (possibly by several users at the same time) and reread as soon as possible. <br />
<br />
It offers no replacement for the standard ODS object. Instead, an additional function displays those that can be used for special applications.<br />
<br />
The transactional ODS object simply consists of a table for active data. It retrieves its data from external systems via fill- or delete- APIs. The loading process is not supported by the BW system. The advantage to the way it is structured is that data is easy to access. They are made available for reporting immediately after being loaded. <br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-15867761607596228902014-01-09T12:50:00.000+05:302014-01-18T12:20:12.614+05:30SAP BI QUESTIONS & ANSWERS-5<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP BI QUESTIONS & ANSWERS-5 :-</b></span></u></span><br />
<br />
<br />
<span style="color: blue;"><b>Q) Why does it take so long to delete from the delta queue (for example half a day) ? </b></span><br />
<b>A)</b> Import PlugIn 2000.2 patch 3. With this patch the performance during deletion is considerably improved. <br />
<br />
<span style="color: blue;"><b>Q) Why is the delta queue not updated when you start the V3 update in the logistics cockpit area ? </b></span><br />
<b>A)</b> It is most likely that a delta initialization had not yet run or that the delta initialization was not successful. A successful delta initialization (the corresponding request must have QM status 'green' in the BW System) is a prerequisite for the application data being written in the delta queue. <br />
<br />
<span style="color: blue;"><b>Q) What is the relationship between RSA7 and the qRFC monitor (Transaction SMQ1) ? </b></span><br />
<b>A)</b> The qRFC monitor basically displays the same data as RSA7. The internal queue name must be used for selection on the initial screen of the qRFC monitor. This is made up of the prefix 'BW, the client and the short name of the DataSource. For DataSources whose name are 19 characters long or shorter, the short name corresponds to the name of the DataSource. For DataSources whose name is longer than 19 characters (for delta-capable DataSources only possible as of PlugIn 2001.1) the short name is assigned in table ROOSSHORTN. <br />
In the qRFC monitor you cannot distinguish between repeatable and new LUWs. Moreover, the data of a LUW is displayed in an unstructured manner there. <br />
<br />
<span style="color: blue;"><b>Q) Why are the data in the delta queue although the V3 update was not started ? </b></span><br />
<b>A)</b> Data was posted in background. Then, the records are updated directly in the delta queue (RSA7). This happens in particular during automatic goods receipt posting (MRRS). There is no duplicate transfer of records to the BW system. See Note 417189. <br />
<br />
<span style="color: blue;"><b>Q) Why does button 'Repeatable' on the RSA7 data details screen not only show data loaded into BW during the last delta but also data that were newly added, i.e. 'pure' delta records ? </b></span><br />
<b>A)</b> Was programmed in a way that the request in repeat mode fetches both actually repeatable (old) data and new data from the source system. <br />
<br />
<span style="color: blue;"><b>Q) I loaded several delta inits with various selections. For which one is the delta loaded ? </b></span><br />
<b>A)</b> For delta, all selections made via delta inits are summed up. This means, a delta for the 'total' of all delta initializations is loaded. <br />
<span style="color: blue;"><b><br />Q) How many selections for delta inits are possible in the system ? </b></span><br />
<b>A) </b>With simple selections (intervals without complicated join conditions or single values), you can make up to about 100 delta inits. It should not be more. With complicated selection conditions, it should be only up to 10-20 delta inits. <br />
<b>Reason: </b>With many selection conditions that are joined in a complicated way, too many 'where' lines are generated in the generated ABAP source code that may exceed the memory limit. <br />
<br />
<span style="color: blue;"><b>Q) I intend to copy the source system, i.e. make a client copy. What will happen with may delta? Should I initialize again after that ? </b></span><br />
<b>A)</b> Before you copy a source client or source system, make sure that your deltas have been fetched from the DeltaQueue into BW and that no delta is pending. After the client copy, an inconsistency might occur between BW delta tables and the OLTP delta tables as described in Note 405943. After the client copy, Table ROOSPRMSC will probably be empty in the OLTP since this table is client-independent. After the system copy, the table will contain the entries with the old logical system name that are no longer useful for further delta loading from the new logical system. The delta must be initialized in any case since delta depends on both the BW system and the source system. Even if no dump 'MESSAGE_TYPE_X' occurs in BW when editing or creating an InfoPackage, you should expect that the delta have to be initialized after the copy. <br />
<br />
<span style="color: blue;"><b>Q) Is it allowed in Transaction SMQ1 to use the functions for manual control of processes ? </b></span><br />
<b>A)</b> Use SMQ1 as an instrument for diagnosis and control only. Make changes to BW queues only after informing the BW Support or only if this is explicitly requested in a note for component 'BC-BW' or 'BW-WHM-SAPI'. <br />
<br />
<span style="color: blue;"><b>Q) Despite of the delta request being started after completion of the collective run (V3 update), it does not contain all documents. Only another delta request loads the missing documents into BW. What is the cause for this "splitting"? </b></span><br />
<b>A)</b> The collective run submits the open V2 documents for processing to the task handler, which processes them in one or several parallel update processes in an asynchronous way. For this reason, plan a sufficiently large "safety time window" between the end of the collective run in the source system and the start of the delta request in BW. An alternative solution where this problem does not occur is described in Note 505700. <br />
<br />
<span style="color: blue;"><b>Q) Despite my deleting the delta init, LUWs are still written into the DeltaQueue ? </b></span><br />
<b>A)</b> In general, delta initializations and deletions of delta inits should always be carried out at a time when no posting takes place. Otherwise, buffer problems may occur: If a user started the internal mode at a time when the delta initialization was still active, he/she posts data into the queue even though the initialization had been deleted in the meantime. This is the case in your system. <br />
<br />
<span style="color: blue;"><b>Q) The extract structure was changed when the DeltaQueue was empty. Afterwards new delta records were written to the DeltaQueue. When loading the delta into the PSA, it shows that some fields were moved. The same result occurs when the contents of the DeltaQueue are listed via the detail display. Why are the data displayed differently ? What can be done ? </b></span><br />
<b>A)</b> Make sure that the change of the extract structure is also reflected in the database and that all servers are synchronized. We recommend to reset the buffers using Transaction $SYNC. If the extract structure change is not communicated synchronously to the server where delta records are being created, the records are written with the old structure until the new structure has been generated. This may have disastrous consequences for the delta. When the problem occurs, the delta needs to be re-initialized. <br />
<span style="color: blue;"><b><br />Q) How and where can I control whether a repeat delta is requested ? </b></span><br />
<b>A)</b> Via the status of the last delta in the BW Request Monitor. If the request is RED, the next load will be of type 'Repeat'. If you need to repeat the last load for certain reasons, set the request in the monitor to red manually. For the contents of the repeat see Question 14. Delta requests set to red despite of data being already updated lead to duplicate records in a subsequent repeat, if they have not been deleted from the data targets concerned before. <br />
<span style="color: blue;"><b><br />Q) As of PI 2003.1, the Logistic Cockpit offers various types of update methods. Which update method is recommended in logistics ? According to which criteria should the decision be made? How can I choose an update method in logistics ? </b></span><br />
<b>A)</b> See the recommendation in Note 505700. <br />
<br />
<span style="color: blue;"><b>Q) Are there particular recommendations regarding the data volume the DeltaQueue may grow to without facing the danger of a read failure due to memory problems ? </b></span><br />
<b>A)</b> There is no strict limit (except for the restricted number range of the 24-digit QCOUNT counter in the LUW management table - which is of no practical importance, however - or the restrictions regarding the volume and number of records in a database table). <br />
When estimating "smooth" limits, both the number of LUWs is important and the average data volume per LUW. As a rule, we recommend to bundle data (usually documents) already when writing to the DeltaQueue to keep number of LUWs small (partly this can be set in the applications, e.g. in the Logistics Cockpit). The data volume of a single LUW should not be considerably larger than 10% of the memory available to the work process for data extraction (in a 32-bit architecture with a memory volume of about 1GByte per work process, 100 Mbytes per LUW should not be exceeded). That limit is of rather small practical importance as well since a comparable limit already applies when writing to the DeltaQueue. If the limit is observed, correct reading is guaranteed in most cases. <br />
If the number of LUWs cannot be reduced by bundling application transactions, you should at least make sure that the data are fetched from all connected BWs as quickly as possible. But for other, BW-specific, reasons, the frequency should not be higher than one DeltaRequest per hour. <br />
To avoid memory problems, a program-internal limit ensures that never more than 1 million LUWs are read and fetched from the database per DeltaRequest. If this limit is reached within a request, the DeltaQueue must be emptied by several successive DeltaRequests. We recommend, however, to try not to reach that limit but trigger the fetching of data from the connected BWs already when the number of LUWs reaches a 5-digit value. <br />
<br />
<span style="color: blue;"><b>Q) I would like to display the date the data was uploaded on the report. Usually, we load the transactional data nightly. Is there any easy way to include this information on the report for users? So that they know the validity of the report. </b></span><br />
<b>A)</b> If I understand your requirement correctly, you want to display the date on which data was loaded into the data target from which the report is being executed. If it is so, configure your workbook to display the text elements in the report. This displays the relevance of data field, which is the date on which the data load has taken place. <br />
<span style="color: blue;"><b><br />Q) Can we load data directly into infoobject with out extraction is it possible. </b></span><br />
<b>A) </b>Yes. We can copy from other infoobject if it is same. We load data from PSA if it is already in PSA. <br />
<br />
<span style="color: blue;"><b>Q) How many days can we keep the data in psa, if we r sheduled daily, weekly and monthly</b></span><br />
<b>A) </b>We can set the time. <br />
<span style="color: blue;"><b><br />Q) How can u get the data from client if u r working on offshore projects. through which network.</b></span> <br />
<b>A)</b> VPN…………….Virtual Private Network, VPN is nothing but one sort of network where we can connect to the client systems sitting in offshore through RAS (Remote access server). <br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0tag:blogger.com,1999:blog-1825593557519743125.post-72773262809604142712014-01-09T00:01:00.004+05:302014-01-18T12:20:10.585+05:30SAP BI QUESTIONS & ANSWERS-4<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: #274e13;"><u><span style="font-size: large;"><b>SAP BI QUESTIONS & ANSWERS-4 :-</b></span></u></span><br />
<br />
<br />
<span style="color: blue;"><b>Q) Types of Transfer Rules ?</b></span><br />
<b>A)</b> Field to Field mapping, Constant, Variable & routine. <br />
<br />
<span style="color: blue;"><b>Q) Types of Update Rules ?</b></span><br />
<b>A) </b>(Check box), Return table <br />
<br />
<span style="color: blue;"><b>Q) Transfer Routine ?</b></span><br />
<b>A) </b>Routines, which we write in, transfer rules. <br />
<br />
<span style="color: blue;"><b>Q) Update Routine ?</b></span><br />
<b>A)</b> Routines, which we write in Update rules <br />
<span style="color: blue;"><b><br />Q) What is the difference between writing a routine in transfer rules and writing a routine in update rules ?</b></span><br />
<b>A)</b> If you are using the same InfoSource to update data in more than one data target its better u write in transfer rules because u can assign one InfoSource to more than one data target & and what ever logic u write in update rules it is specific to particular one data target. <br />
<br />
<span style="color: blue;"><b>Q) Routine with Return Table.</b></span><br />
A) Update rules generally only have one return value.However, you can create a routine in the tab strip key figure calculation, by choosing checkbox Return table. The corresponding key figure routine then no longer has a return value, but a return table. You can then generate as many key figure values, as you like from one data record. <br />
<br />
<span style="color: blue;"><b>Q) Start routines ?</b></span><br />
<b>A)</b> Start routines u can write in both updates rules and transfer rules, suppose you want to restrict (delete) some records based on conditions before getting loaded into data targets, then you can specify this in update rules-start routine. <br />
Ex: - Delete Data_Package ani ante it will delete a record based on the condition <br />
<br />
<span style="color: blue;"><b>Q) X & Y Tables ?</b></span><br />
X-table = A table to link material SIDs with SIDs for time-independent navigation attributes.<br />
Y-table = A table to link material SIDs with SIDS for time-dependent navigation attributes.<br />
There are four types of sid tables <br />
X time independent navigational attributes sid tables<br />
Y time dependent navigational attributes sid tables<br />
H hierarchy sid tables<br />
I hierarchy structure sid tables <br />
<br />
<span style="color: blue;"><b>Q) Filters & Restricted Key figures (real time example)</b></span><br />
<b>A)</b> Restricted KF's u can have for an SD cube: billed quantity, billing value, no: of billing documents as RKF's. <br />
<br />
<span style="color: blue;"><b>Q) Line-Item Dimension (give me an real time example)</b></span><br />
<b>A)</b> Line-Item Dimension: Invoice no: or Doc no: is a real time example <br />
<br />
<span style="color: blue;"><b>Q) What does the number in the 'Total' column in Transaction RSA7 mean ? </b></span><br />
<b>A)</b> The 'Total' column displays the number of LUWs that were written in the delta queue and that have not yet been confirmed. The number includes the LUWs of the last delta request (for repetition of a delta request) and the LUWs for the next delta request. A LUW only disappears from the RSA7 display when it has been transferred to the BW System and a new delta request has been received from the BW System. <br />
<br />
<span style="color: blue;"><b>Q) How to know in which table (SAP BW) contains Technical Name / Description and creation data of a particular Reports. Reports that are created using BEx Analyzer.</b></span><br />
<b>A)</b> There is no such table in BW if you want to know such details while you are opening a particular query press properties button you will come to know all the details that you wanted.You will find your information about technical names and description about queries in the following tables. Directory of all reports (Table RSRREPDIR) and Directory of the reporting component elements (Table RSZELTDIR) for workbooks and the connections to queries check Where- used list for reports in workbooks (Table RSRWORKBOOK) Titles of Excel Workbooks in InfoCatalog (Table RSRWBINDEXT) <br />
<span style="color: blue;"><b><br />Q) What is a LUW in the delta queue ?</b></span><br />
<b>A) </b>A LUW from the point of view of the delta queue can be an individual document, a group of documents from a collective run or a whole data packet of an application extractor. <br />
<br />
<span style="color: blue;"><b>Q) Why does the number in the 'Total' column in the overview screen of Transaction RSA7 differ from the number of data records that is displayed when you call the detail view ? </b></span><br />
<b>A)</b> The number on the overview screen corresponds to the total of LUWs (see also first question) that were written to the qRFC queue and that have not yet been confirmed. The detail screen displays the records contained in the LUWs. Both, the records belonging to the previous delta request and the records that do not meet the selection conditions of the preceding delta init requests are filtered out. <br />
Thus, only the records that are ready for the next delta request are displayed on the detail screen. In the detail screen of Transaction RSA7, a possibly existing customer exit is not taken into account. <br />
<br />
<span style="color: blue;"><b>Q) Why does Transaction RSA7 still display LUWs on the overview screen after successful delta loading ? </b></span><br />
<b>A)</b> Only when a new delta has been requested does the source system learn that the previous delta was successfully loaded to the BW System. Then, the LUWs of the previous delta may be confirmed (and also deleted). In the meantime, the LUWs must be kept for a possible delta request repetition. In particular, the number on the overview screen does not change when the first delta was loaded to the BW System. <br />
<br />
<span style="color: blue;"><b>Q) Why are selections not taken into account when the delta queue is filled ? </b></span><br />
<b>A)</b> Filtering according to selections takes place when the system reads from the delta queue. This is necessary for reasons of performance. <br />
<span style="color: blue;"><b><br />Q) Why is there a DataSource with '0' records in RSA7 if delta exists and has also been loaded successfully ? </b></span><br />
<b>A)</b> It is most likely that this is a DataSource that does not send delta data to the BW System via the delta queue but directly via the extractor (delta for master data using ALE change pointers). Such a DataSource should not be displayed in RSA7. This error is corrected with BW 2.0B Support Package 11. <br />
<br />
<span style="color: blue;"><b>Q) Do the entries in table ROIDOCPRMS have an impact on the performance of the loading procedure from the delta queue ? </b></span><br />
<b>A)</b> The impact is limited. If performance problems are related to the loading process from the delta queue, then refer to the application-specific notes (for example in the CO-PA area, in the logistics cockpit area and so on). <br />
<b>Caution: </b>As of Plug In 2000.2 patch 3 the entries in table ROIDOCPRMS are as effective for the delta queue as for a full update. Please note, however, that LUWs are not split during data loading for consistency reasons. This means that when very large LUWs are written to the DeltaQueue, the actual package size may differ considerably from the MAXSIZE and MAXLINES parameters. <br />
<span style="color: blue;"><b><br />Q) Why does it take so long to display the data in the delta queue (for example approximately 2 hours) ? </b></span><br />
<b>A)</b> With Plug In 2001.1 the display was changed: the user has the option of defining the amount of data to be displayed, to restrict it, to selectively choose the number of a data record, to make a distinction between the 'actual' delta data and the data intended for repetition and so on. <br />
<br />
<span style="color: blue;"><b>Q) What is the purpose of function 'Delete data and meta data in a queue' in RSA7? What exactly is deleted ? </b></span><br />
<b>A)</b> You should act with extreme caution when you use the deletion function in the delta queue. It is comparable to deleting an InitDelta in the BW System and should preferably be executed there. You do not only delete all data of this DataSource for the affected BW System, but also lose the entire information concerning the delta initialization. Then you can only request new deltas after another delta initialization. <br />
When you delete the data, the LUWs kept in the qRFC queue for the corresponding target system are confirmed. Physical deletion only takes place in the qRFC outbound queue if there are no more references to the LUWs. The deletion function is for example intended for a case where the BW System, from which the delta initialization was originally executed, no longer exists or can no longer be accessed. <br />
<br />
<br />
<br />
<br /></div>
WETEACHSAPhttp://www.blogger.com/profile/02789352015315668684noreply@blogger.com0