Typically, accounting transactions for campus entities are recorded to revenue and expense accounts. These entries adjust balances on the Budget/Expense Summary reports. Every campus entity also has a Balance Sheet. The balance sheet lists assets (claim on cash, prepaids, receivables, inventory, etc.) and liabilities (accrued liabilities, payroll and taxes payable, notes payable, deferred revenue, etc). Many campus entities record transactions to balance sheet accounts and are therefore responsible to know what activity is occurring and to assure proper classification for those transactions. Even departments that do not make such entries should occasionally look at their balance sheet to make sure a miscoded entry has not hit their
accounts.

Read More about the Balance Sheet Reconciliation Guide in PDF.

Native SQL statements allow you to access the data directly from the Database. The developer can directly write database specific SQL statements in the ABAP program using the keyword EXEC SQL … ENDEXEC.

Here is how the actual syntax goes.

EXEC SQL [PERFORMING <form>].
Native SQL Statements
ENDEXEC.

Here is the actual example:

EXEC SQL PERFORMING loop_output.
SELECT connid, cityfrom, cityto
INTO :wa
FROM spfli
WHERE carrid = :c1
ENDEXEC.

FORM loop_output.
WRITE: / wa-connid, wa-cityfrom, wa-cityto.
ENDFORM.

Remember there is no period(.) in the end of the statements and you cannot use comments like (“) or (*) in inside the native SQL statements.

Logical Databases

A Logical database is an ABAP Program that reads the data from database tables and makes the data avaliable to the ABAP Programs. The Logical database provides a system generated selection screen. The ABAP program must specifically refer to the logical database name in the  program attributes. The Coder does not have to worry about the screen design or coding any SQL in order to get the required data. The logical database handles it automatically.

The logical database is hierarchical in structure composed of several nodes. A developer can control the depth of the data retrieval by using the GET <NODE> statement. It may not be a good idea to use a logical database if the only data your program requires is in the last node of a deep hierarchy. The more performance friendly approach would be to program the data retrieval.

The developer can call the logical database directly from the ABAP program using the function module LDB_PROCESS.

ASAP Business One Templates contains templates on BMPL, Business Blue Print, Change Management Communication guide, Cutover Checklist, Go-Live Checklist, Handover from sales checklist, Issue log, Meeting Agenda Template, Meeting minutes template, Post Go-Live Questionaire, Project Kick-off Presentation, Project Phase Sign-Off, Project Plan, Request for change, Risk assessment, Software Delivery Receipt, Test case template, Test Strategy Guide and Training Plan.

SAP Business One – ASAP Methodology

Accelerated SAP methodology is a proven, repeatable and successful approach to implementing SAP solutions across industries and customer environments. It provides content, tools, and expertise from numerous implementations. The “SAP Business One Accelerated Implementation Program” has been developed specifically to support the implementation of SAP Business One in small and midsize enterprises. This implementation guide will use the ASAP framework as a guideline for SAP Business One implementations and apply ASAP concepts and information were beneficial.