• No results found

SAP BW - FI Datasources.doc

N/A
N/A
Protected

Academic year: 2021

Share "SAP BW - FI Datasources.doc"

Copied!
9
0
0

Loading.... (view fulltext now)

Full text

(1)

Introduction

This document will provide a quick guide on the different SAP BW

standard datasources available for various FI module, their

functionality and their implementation issues.

Also a comparison between the datasources available in different

Reporting Financials (EhP1, EhP3, EhP4) and their use is listed

which will help in deciding the standard datasources to be

installed in a SAP BW implementation project based on the

requirements.

(2)

General Ledger Accounting

EhP1 datasources

0FI_GL_10 (General Ledger: Balances, Leading Ledger)

This DataSource extracts the totals records from the leading ledger in the new General Ledger Delta Capable: Yes

Delta Procedure: AIED Direct Access: Allowed

Note: SAP has provided 2 more datasources 0FI_GL_11, 0FI_GL_12 with different delta procedures for extracting the General Ledger balances if using the 0FI_GL_10 datasource leads to performance issues. Please refer SAP note 1392817 for additional information related to this.

0FI_GL_14 (General Ledger Accounting (New): Line Items of the Leading Ledger)

This DataSource extracts line items from the leading ledger in new General Ledger Accounting. Delta Capable: Yes

Delta Procedure: AIED Direct Access: Allowed

Note: In addition to these datasources, if the data needs to be extracted from any other ledger apart from the leading ledger then the datasources can be generated specifically for those ledgers to extract the balances as well as the line items data.

(3)

This DataSource extracts the general ledger transaction figures from table FAGLFLEXT for the leading as well as the non leading ledgers.

Delta Capable: Yes Delta Procedure: AIED Direct Access: Allowed

0FI_GL_40 (General Ledger Accounting: Line Items)

This DataSource extracts the line items in General Ledger accounting for the leading as well as the non leading ledgers.

Delta Capable: No Direct Access: Allowed

0FI_GL_21 (Cumulated balances)

This DataSource extracts cumulated balances for a reporting period for the leading as well as the non leading ledgers.

Delta Capable: No Direct Access: Allowed

0FI_GL_50 (General Ledger Accounting: Plan Line Items)

This datasource extracts the plan line items in General Ledger accounting from table FAGLFLEXP for the leading as well as the non leading ledgers

Delta Capable: No Direct Access: Allowed

(4)

Accounts Payable & Accounts Receivable

EhP1 datasource

0FI_AP_4 (Vendors: Line Items with Delta Extraction)

This DataSource extracts Accounts Payable Accounting line items from tables BSIK (open items) and BSAK (cleared items) in the R/3 source system.

Delta Capable: Yes Delta Procedure: AIE Direct Access: Not Allowed

0FI_AP_6 (Accounts Payable: Transaction Figures with Delta Extraction) This DataSource is used to load accounts payable transaction figures. Delta Capable: Yes

Delta Procedure: AIE Direct Access: Not Allowed

0FI_AR_04 (Accounts Receivable: Line Items)

This DataSource extracts Accounts Receivable Accounting line items from tables BSID (open items) and BSAD (cleared items) in the R/3 source system.

Delta Capable: Yes Delta Procedure: AIE Direct Access: Not Allowed

(5)

Delta Capable: Yes Delta Procedure: AIE Direct Access: Not Allowed

0FI_AR_10 (Accounts Receivable: Payment History with Delta Extraction)

This DataSource extracts the payment history from table KNB4 in the R/3 source system Delta Capable: Yes

Delta Procedure: AIE Direct Access: Not Allowed EhP3 datasource

0FI_AP_30 (Vendor Line Items)

This DataSource provides vendor line items (tables BSIK (open items) and BSAK (cleared items) of subledger accounting.

Delta Capable: Yes Delta Procedure: AIM Direct Access: Allowed

0FI_AP_20 (Vendor Balances)

This DataSource provides vendor balances Delta Capable: Yes

Delta Procedure: AIE Direct Access: Allowed

(6)

This DataSource provides customer line items (tables BSID (open items) and BSAD (cleared items) of subledger accounting

Delta Capable: Yes Delta Procedure: AIM Direct Access: Allowed

0FI_AR_20 (Customer Balances)

This DataSource provides customer balances. Delta Capable: Yes

Delta Procedure: AIE Direct Access: Allowed

Note: Please see the SAP notes 1429650, 1266262, 1390113 for possible delta issues with the AP & AR EhP3 datasources.

Asset Accounting

EhP1 datasource

0FI_AA_11 (FI-AA: Transactions)

This DataSource supplies the transaction data and annual plan values for fixed assets Delta Capable: Yes

(7)

Direct Access: Not Allowed

0FI_AA_12 (FI-AA: Posted Depreciation)

This DataSource supplies the values of depreciation postings by period. Delta Capable: Yes

Delta Procedure: AIE Direct Access: Not Allowed

EhP4 datasource

0FI_AA_20 (FI-AA: Transactions and Depreciation)

The EhP4 datasource 0FI_AA_20 (FI-AA: Transactions and Depreciation) does not support delta. Direct Access: Allowed

(8)

Cost Center Accounting

EhP1 datasources

0CO_OM_CCA_1 (Cost Centers: Costs and Allocations)

This DataSource supplies costs (primary and secondary) and quantities posted to cost centers (actual, plan, and commitments). These costs could have been posted to the cost centers as primary cost postings or internal allocations.

This datasource does not support delta loading. Direct Access: Not Allowed

0CO_OM_CCA_9 (Cost Centers: Actual Costs - Line Items (Delta) )

This DataSource contains information on the actual costs that were posted to cost centers. These costs could have been posted to the cost centers as primary cost postings or internal allocations.

Delta Capable: Yes Delta Procedure: ADD Direct Access: Not Allowed

EhP3 datasources

(9)

Direct Access: Allowed

0CO_OM_CCA_40 (Cost Centers: Actual Costs)

Delta Capable: Yes Delta Procedure: ADD Direct Access: Allowed

Prerequisites:

You can only use the EhP3 content if you use SAP Enhancement

Package 3 for SAP ERP 6.0 and have activated the Reporting

Financials business function.

You can only use the EhP4 content if you use SAP Enhancement

Package 4 for SAP ERP 6.0, and have activated the Reporting

Financials 2 business function

References

Related documents

However, TMT companies will need to align their strategies with each local government broadband policy in order to benefit from the incentives and resources made available,

Identifying the most critical IT equipment (assets), defining the required level of its availability; defining the operational procedures in case of IT system failure; preparation

The proponent aims to effectively use the Metropolitan Theater as the new office for the National Commission for Culture and the Arts that caters the special facility needs of a

The primary objectives of this study were to determine the availability of Cu, Ni, Pb and Zn from municipal sewage sludge to sunflower plants, in four soils with different

Among these models, the slip-line field model developed by Waldorf for the macroscale allows to separately evaluate shearing and ploughing force components in orthogonal

Options were rammed earth manual pdf prefer the training highly skilled foremen and ads, warsaw university of the house.. Nc building mansions of diy rammed pdf day, the design and

Neil Palmer, director of CIT Group, advisors to Curzon, said: “We are delighted to have quickly completed the rationalisation of the portfolio of 28 Thistle Hotels acquired earlier

Wear SIGVARIS graduated compression socks or stockings to improve circulation and help prevent travel-related DVT. Keep your