Pages

Thursday, February 25, 2010

Information:Tables for CO-PA Transaction Data

The following link explains the concept of CO-PA data tables, which the system creates when an Operating Concern is generated.

Database Tables for CO-PA Transaction Data (SAP Library - Profitability Analysis (COPA))

Costing Based COPA

CE4XXXX - Profiability Segment Definition Table
(Assigns segment number to each characteristic combination)
CE3XXXX - Segment Level Totals table
(Provides Period Based Segment level Totals)
CE2XXXX - Plan Line Items
CE1XXXX - Actual Line Items

Account Based COPA

CE4XXXX - Profiability Segment Definition Table
(Assigns segment number to each characteristic combination)
COSS/COSP - Segment level Totals
COEP - Plan Line Items
COEJ - Actual Line Items

Friday, February 19, 2010

Information: Report to compare GL transactions and totals

The report program transaction FAGLF03 (Program:TFC_COMPARE_VZ) can be used to compare and reconcile the transaction amounts in documents to the GL totals.

When New General Ledger is not activated, the report compares data in table BSEG with totals in table GLT0
While, when New GL is activated, the report compares data between New GL Totals table FAGLFLEXT with transactions table FAGLFLEXA

Program: TFC_ADJUST_VZ can be used to rectify some of the error identified with the above report.

Wednesday, February 3, 2010

Information: Workflow settings to release Parked documents

The following document provides details on various standard workflows which can be used for release of Parked documents.

The document also provides details on standard sub-workflow models which can be used for amount based release or account assignment based approval and release process

http://help.sap.com/printdocu/core/print46b/en/data/en/pdf/FIBP/FI-AP-AP-PRK.pdf

Here are some key excerpts from the document...

Workflow Model for Completing Documents

"There is a workflow model in the system (WS00400004) for completing parked documents. In
order to use this in your active clients, you must copy it there using the tools in the workflow
workbench."

Standard Task for Completing a Document

"Users who want to complete parked documents must be allocated the task “Complete parked
document” (TS00407848). To do this, create the organizational object in Personnel Planning and
Development using the workflow workbench. You then allocate the relevant users and the abovementioned standard task to this object."

Workflow Models for Document Parking and Release

"Several Workflow models are provided in the system for document parking; a Workflow
framework (WS10000051) and five sub-workflows. In the Financial Accounting Configuration
menu, you can set which sub-workflow model should be used by the workflow framework at the
time of the program run. You can also define your own sub-workflows while in this menu,
providing that they send and receive the same data from the workflow framework as the subworkflow
models do.
If you want to use the standard sub-workflow models for multi-level amount release
(WS10000052, WS10000053, WS10000054), you can define between one and three levels for
amount release in your system. Should you want more than three release levels, copy the
workflow models for amount release and then expand them. If are not working with amount
release, you can use a dummy sub-workflow model (WS20000006). The fourth standard subworkflow (WS10000055) can be used for account assignment approval."

(c) SAP AG