SAP FINANCE & CONTROLS: A BRIEF INTRODUCTION & OUTLINE

Now, the new SAP GL – integrates many streamlined processes to be unified more closely to further alleviate any duplication of live-time tasks.

This New General Ledger Accounting in mySAP ERP has some dynamic advantages in comparison to the classic General Ledger Accounting (as used in SAP R/3 Enterprise Version) – such as the ability to run real-time reconciliation between Management Accounting (CO) and Financial Accounting (FI) – i.e. – there is a real-time integration with Controlling.

Previously time-consuming reconciliations are hence now rendered obsolete. The new SAP GL further allows the management of multiple ledgers within the General Ledger Accounting Module itself.

This creates the scope for portraying parallel accounting scenarios within the SAP System.
Controlling (CO) is the term by which SAP refers to “Managerial Accounting”.

The Organizational Elements in CO are Operating Concern, Controlling Area, and Cost Centers. Hence, the SAP CO Module helps management by providing reports on cost centers, profit centers, contribution margins, profitability, etc.
It focuses on internal users, in contrast to FI – which focuses on data drawn for
external reporting.

The transactions posted in FI are transferred to CO for cost accounting processing, analytical reporting, and audit-controlling spectrums.
There can be either a one-to-one relationship or there can be one-to-many relationship between
Controlling Areas Verses Company Codes. Hence, CO becomes the governing module that oversees the consolidation of costing data whereby management can derive their perspectives for analysis.

The SAP Controlling (CO) Module’s Components are:
Cost Element Accounting
Cost Controlling
Cost Center Accounting
Internal Orders
Activity-Based Costing
Product Cost Controlling
Profitability Analysis
Profit Center Accounting
Some methodologies that are unique in their structural concepts are – for example – CO PA & PCA. PA refers to Profitability Analysis that derives from how profitable your market-segments are on their external sides. EC-PCA refers to Profit Center Accounting that produces the analysis that portrays how your internal ‘profit centers’ are functioning in terms of their profitability. To further expand the
potential, we also have CO-PC in SAP – which streamlines Product Cost Controlling.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

SAP FINANCE & CONTROLS: A BRIEF INTRODUCTION & OUTLINE

SAP FINANCE & CONTROLS: A BRIEF INTRODUCTION & OUTLINE

In today’s world of innovation through Information Technology, SAP is truly a dynamic package by which one can integrate, diversify, and streamline their work-processes with multi-dimensional compatibility.

SAP – “Systems, Applications, and Products in Data Processing” – was founded in 1972 with its headquarters in Walldorf, Germany.For those who are in the Finance/Accounting Profession who wish to delve into a creative and
interactive scenario by which they can apply their hands-on experience & expertise to another level of fantastic intellectual stimulation, SAP FI/CO Implementation & Configuration is truly the ultimate. Their expertise will render them to very swiftly master its technical configuration – for the concepts are all
part of every Finance/Accounting Professional’s innate thought-process – and - the SAP modules follow a thorough schematic pattern by which all functionalities & technicalities are logically laid-out.

SAP Financial Accounting (FI) is an important core module where in live-time, the financial processing
transactions are all captured to provide the basis via which data is drawn for external reporting.

This SAP FI Module is integrated with many parallel modules that enable a company to unify processes that may have needed the utilization of many software packages.
Other Modules of SAP that commonly find a role of integration with FI are (but not limited to) Material Management (MM), Sales & Distribution (SD), Human Resources (HR), Product Planning (PP), Controlling (CO), etc.

Amongst these CO – Controlling is another major focus for those coming from the
Finance/Accounting/Auditing/Budgeting and Financial Reporting/Analysis Backgrounds/Professions.

SAP FI: There are many sub-modules that streamline and specialize in each aspect of the Financial
Accounting Processes:
AA – Asset Accounting
AP – Accounts Payable
AR – Accounts Receivable
BL – Bank Accounting
FM – Funds Management
GL – General Ledger Accounting
LC – Legal Consolidations
SL – Special Purpose Ledger
TM – Travel Management
Out of the above, FI-AR, FI-AP, & FI-AA are the three sub-modules that send simultaneous
postings to FI-GL.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

SAP Netweaver

What is SAP NetWeaver
SAP NetWeaver is SAP's integrated technology platform and is the technical foundation for all SAP applications since the SAP Business Suite. SAP NetWeaver is marketed as a service-oriented application and integration platform. SAP NetWeaver provides the development and runtime environment for SAP applications and can be used for custom development and integration with other applications and systems.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

SAP Easy Access

What is SAP EASY ACCESS

 It displays a user menu that displays the option to perform tasks like creating & modifying transaction reports & web addresses.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

Implement SAP

Why do you usually choose to implement SAP
There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

“Business Content” in SAP Business Information Warehouse SAP

Explain the concept of “Business Content” in SAP Business Information Warehouse


Business Content is a pre-configured set of role and task-relevant information models based on consistent Metadata in the SAP Business Information Warehouse. Business Content provides selected roles within a company with the information they need to carry out their tasks. These information models essentially contain roles, workbooks, queries, InfoSources, InfoCubes, key figures, characteristics, update rules and extractors for SAP R/3, mySAP.com Business Applications and other selected applications.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

SAP Basics feature

* Configuration of the SAP modules
o Transaction SPRO - this is the main tree for all the configuration.
* Function Key
o F1 - Help
o F4 - Possible entries or matchcode for the field you are accessing
o F5 - Selection screen
o F7 - Previous screen
o F8 - Next screen
o F9 - Technical info
o CTRL+X - Cut
o CTRL+C - Copy
o CTRL+V - Paste
* Navigation
o /n Skip to the next record if you are processing one batch input session
o /bend Cancel a batch input foreground process
o /nend Close all R/3 sessions and logoff
o /nxxx x Call the transaction xxxx in the same session
o /o Generate a session list
o /oxxx x Call the transaction xxxx in an additional session
o /i Delete the current session
o /h Turn the debug mode on
o /$tab Reset all buffers (for System Administrators)
o /$syn c Synchronize instances buffers (for System Administrators)

In 4.x, you can have long SAP transaction code up to a maximum of 20 character

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

SAP Basics feature

* Configuration of the SAP modules
o Transaction SPRO - this is the main tree for all the configuration.
* Function Key
o F1 - Help
o F4 - Possible entries or matchcode for the field you are accessing
o F5 - Selection screen
o F7 - Previous screen
o F8 - Next screen
o F9 - Technical info
o CTRL+X - Cut
o CTRL+C - Copy
o CTRL+V - Paste
* Navigation
o /n Skip to the next record if you are processing one batch input session
o /bend Cancel a batch input foreground process
o /nend Close all R/3 sessions and logoff
o /nxxx x Call the transaction xxxx in the same session
o /o Generate a session list
o /oxxx x Call the transaction xxxx in an additional session
o /i Delete the current session
o /h Turn the debug mode on
o /$tab Reset all buffers (for System Administrators)
o /$syn c Synchronize instances buffers (for System Administrators)

In 4.x, you can have long SAP transaction code up to a maximum of 20 character

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

SAP ERP

What is ERP

ERP is a package with the techniques and concepts for the integrated management of business as a whole, for effective use of management resources, to improve the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing core business like production and financial market. As the growth and merits of ERP package ERP software is designed for basic process of a company from manufacturing to small shops with a target of integrating information across the company.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

Substitution Rules FICO

What are FI substitution rules ?
A: Defined in configuration they are similar to the FI
validation rules above. Substitution rules allow field values
to be replaced when certain pre-requisites conditions are
met.



Defining Substitution Rules


Use

When you post a document, you do not have to enter the functional area. The system can determined the functional area using substitution rules. If you post the salary of a market researcher, this expense will appear under sales costs in the profit and loss statement. The reason for this is the configuration of a substitution rule that reads the cost element category and derived the functional area for this information.
Two substitution rules are defined in the IDES System: ID-COGS (for Europe) and NA-COGS (for North America).
The deriving of the functional area can be dependent on various parameters such as cost element category, order type, or project number.
You can find additional information about substitutions in the Substitutions process.

Procedure

1. Call up the transaction as follows:

Menu Path	Tools ® AcceleratedSAP ® Customizing ® Edit Project
Transaction Code	SPRO

2. Choose  SAP Reference IMG.
3. Choose Financial Accounting ® Financial Accounting ® Company Code ® Cost of Sales Accounting ® Set Up Substitution for Cost of Sales Accounting ® Activate Substitution.
The following substitutions are displayed: ID-COGS is assigned to company code 1000 (Europe) and NA-COGS to company code 3000 (North America). Both substitutions are active. This means that every accounting document that results from a business transaction is automatically read. The substitution rule assigned to the company code is then used to derive the functional area.
4. In the Change View "Substitution in Accounting Documents": Overview screen, select the following substitution with a double-click.

Field	Europe	North America
Substitution	ID-COGS	NA-COGS

5. In the Information dialog box, choose .
The Change Substitution: ID-COGS or NA-COGS (Header data) screen appears. You see information about the application area of the substitution (FI) and the callup point when the substitution is executed (cost of sales accounting).
6. Open the ID-COGS structure.
The system displays the steps of the substitution. Currently, the steps 01, 02, 03 and 04 are completely configured for substitution rule ID-COGS. Other steps are included for reserves and clearing accounts.
7. Select the first substitution step (001).
The system displays an overview of the substitution prerequisites. If you post a document, the system checks whether the prerequisites of the first step are met. If they are met, the functional area is derived. If the prerequisite is not met, the system reads the next substitution step.
8. Call up the following steps in order.
The substitution prerequisites for the European data of the IDES system appear as follows:

Step	Description	Prerequisite (Boolean statement)
001	Functional area 0100 Manufacturing	Functional area 0100 is derived if the following is true: · Cost center element 1 (manufacturing) or 2 (manufacturing services), the order number is statistical or not specified · The internal order is a manufacturing order. · The document is posted to account 893000 (WIP) or 239000 (WIP unrealized costs) · The expense is posted directly to a cost element or customer order (profitability segment)
002	Functional area 0300 Sales and Marketing	Functional area 0300 is derived if the following is true: · Cost center category is 3 (Sales), the order number is statistical or not specified. · The internal order is an internal order for sales
003	Functional area 0400 Administration	Functional area 0400 is derived if the following is true: · Cost center element 4 (administration) or 5 (management), the order number is statistical or not specified · The internal order is an internal order for administration or management
004	Functional area 0500 Research & Development	Functional area 0500 is derived if the following is true: · Cost center category is 6 (research and development), the order number is statistical or not specified. · The internal order is an internal order for research and development
005	Functional area 0600 reserves (only for Germany)	Functional area 0600 is derived if the following is true: The document is posted to an account contained in the interval 480000 to 489999

The following is an overview of the substitutions as defined for the North American data in the IDES System.

Step	Description	Prerequisite (Boolean statement)
006	Functional area 0100: Manufacturing	The G/L account is either 893000 or 239000
007	Functional area 0100: Manufacturing	The manufacturing category is 04, 05, 06, 10, 20, 30, 40, or 50
008	Functional area 0100: Manufacturing	Order type is 0200, 0300, 0801, 0850, or 0870
009	Functional area 0100: Manufacturing	The cost center category is 01 or 02 and the order field is empty or contains a statistical order
010	Functional area 0100: Manufacturing	The cost element field contains an entry
011	Functional area 0100: Manufacturing	The customer order field contains an entry
003	Functional area 0300: Sales and Marketing	The order type is 0400 or 0451
005	Functional area 0300: Sales and Marketing	The cost center category is 03 and the order field is empty or contains a statistical order
002	Functional area 0400 Administration	The cost center category is 04 or 05 and the order field is empty or contains a statistical order
013	Functional area 0400 Administration	Order type is 9A00
001	Functional area 0500: Research & Development	The cost center category is 06 and the order field is empty or contains a statistical order
004	Functional area 0500: Research & Development	The order type is 0101 or 0151
012	Various functional areas are derived from WBS elements	This step uses user exit U901 in ABAP program ZGGBS800 to determine which functional area is derived from the WBS elements

9. Choose  until the overview tree appears.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk

Document Currency FICO

Explain the document currency (WRBTR) and local currency fields (DMBTR) when posting a document in SAP FI.

A: On the document header, the currency key is entered.

If this is different from the entity currency (or local

currency), an equivalent amount in local currency is

calculated automatically by the system and stored in the

field “local currency”. It is possible however to overwrite

the system proposed value in this field manually.

If the local amount is manually overwritten, and the

difference between the implied exchange rate is sufficiently

different to the rate used by the system, a warning or error

message is displayed (depending on system configuration)

This DataSource extracts line items from the leading ledger in new General Ledger Accounting. For all other ledgers, you have to create separate DataSources.

Technical Data

Application Component	Financial Accounting: General Ledger Accounting (FI-GL)
Available as of Release	SAP Enhancement Package 3 for SAP ERP 6.0
Shipment	SAP NetWeaver 7.0 BI Content Add-On 3 Support Package 08
Content Versions	1.0; 703
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Prerequisites

In Customizing of the OLTP system, you have activated new General Ledger Accounting under  Financial Accounting  Financial Accounting Global Settings .

Data Modeling

Delta Update

After Images Marked for Deletion via Extractor (FI-GL/AP/AR)

The DataSource uses the delta method to transfer each new status of the changed line item. For this reason, it is not possible to update the InfoCube directly. The InfoCube can only be deleted via the DataStore object (update with MOVE).

The delta method works with a lower safety interval of an hour (standard setting). This means that the system transfers all postings that were made from an hour preceding the last delta load up to the current time. The overlapping of each first hour of a delta load when the after image method is used with the update MOVE causes any data records that were extracted twice to be overwritten. In this way, the method guarantees gap-free data consistency in BI.

Fields of Origin for the Extract Structure

Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
ANLN1	Main asset number	BSEG	ANLN1
ANLN2	Asset subnumber - new, four-digit	BSEG	ANLN2
AUFNR	Order number	BSEG	AUFNR
AUGBL	Clearing document number	BSEG	AUGBL
AUGDT	Clearing date	BSEG	AUGDT
BELNR	Accounting document number	FAGLFLEXA	BELNR
BLART	Document type	BKPF	BLART
BLDAT	Document date in document	BKPF	BLDAT
BSCHL	Posting key	FAGLFLEXA	BSCHL
BSTAT	Document status	FAGLFLEXA	BSTAT
BUDAT	Posting date in document	FAGLFLEXA	BUDAT
BUKRS	Company code	FAGLFLEXA	RBUKRS
BUZEI	Number of the line item within the accounting document	FAGLFLEXA	BUZEI
DMSHB	Amount in local currency with +/- sign	BSEG	DMBTR *¹
HWAER	Local currency		RBUKRS*¹
DMBE2	Amount in second local currency	BSEG	DMBE2
HWAE2	Currency key of the second local currency		RLDNR*¹
DMBE3	Amount in third local currency	BSEG	DMBE3
HWAE3	Currency key of the third local currency		RLDNR*¹
EBELN	Purchasing document number	BSEG	EBELN
EBELP	Item number of purchasing document	BSEG	EBELP
ETEN2	Schedule number	BSEG	ETEN2
FAEDT	Net due date	BSEG	ZFBDT
FILKD	Branch account number	BSEG	FILKD
GJAHR	Fiscal year	FAGLFLEXA	GJAHR
GSBER	Business area	FAGLFLEXA	RBUSA
JAMON	Fiscal year/posting period from posting date	BKPF	GJAHR*¹ / MONAT*¹
KOART	Account type	BSEG	KOART
KOSTL	Cost center	FAGLFLEXA	RCNTR
MABER	Dunning area	BSEG	MABER
MADAT	Date of last dunning notice	BSEG	MADAT
MANSP	Dunning lock	BSEG	MANSP
MANST	Dunning level	BSEG	MANST
MONAT	Fiscal period	BKPF	MONAT
MSCHL	Dunning key	BSEG	MSCHL
MWSKZ	Tax on sales/purchases code	BSEG	MWSKZ
POSN2	Sales document item	BSEG	POSN2
PRCTR	Profit center	FAGLFLEXA	PRCTR
QBSHB	Withholding tax amount in document currency	BSEG	QBSHB*¹ / WRBTR*¹
QSFBT	Withholding tax exempt amount in document currency	BSEG	QSFBT*¹ / WRBTR*¹
QSSHB	Withholding tax base amount in document currency	BSEG	QSSHB*¹ / WRBTR*¹
REBZG	Document number of the invoice to which the transaction belongs	BSEG	REBZG
SAMNR	Invoice list number	BSEG	SAMNR
SGTXT	Item text	BSEG	SGTXT
SHKZG	Debit/credit indicator	FAGLFLEXA / BSEG	DRCRK*¹ / XNEGP*¹
SKFBT	Amount eligible for cash discount in document currency	BSEG	SKFBT*¹ / WRBTR*¹
WSKTO	Cash discount amount in document currency	BSSEG	WSKTO*¹ / WRBTR*¹
SKNTO	Cash discount amount in local currency	BSEG	SKNTO*¹ / DMBTR*¹
UMSKS	Transaction class special general ledger	BSEG	UMSKS
UMSKZ	Special G/L indicator	BSEG	UMSKZ
UZAWE	Additional payment method	BSEG	UZAWE
VALUT	Value date	BSEG	VALUT
VBEL2	Sales document	BSEG	VBEL2
VBELN	Billing	BSEG	VBELN
VBEWA	Flow type	BSEG	VBEWA
VBUND	Company ID of trading partner	FAGLFLEXA	RASSC
VERTN	Contract Number	BSEG	VERTN
VERTT	Contract type	BSEG	VERTT
WERKS	Plant	BSEG	WERKS
WRSHB	Amount in document currency (foreign currency)	BSEG	WRBTR*¹
WAERS	Document currency (key)	FAGLFLEXA	RWCUR
WVERW	Type of bill of exchange usage	BSEG	WVERW
XBLNR	Reference document number	BKPF	XBLNR
XZAHL	Indicator: Is this is a payment transaction ?	BSEG	XZAHL
ZBD1P	Cash discount percentage 1	BSEG	ZBD1P
ZBD1T	Cash discount days 1	BSEG	ZBD1T
ZBD2P	Cash discount percentage 2	BSEG	ZBD2P
ZBD2T	Cash discount days 2	BSEG	ZBD2T
ZBD3T	Deadline for terms of payment net	BSEG	ZBD3T
ZFBDT	Baseline date for due date calculation	BSEG	ZFBDT
ZLSCH	Payment method	BSEG	ZLSCH
ZLSPR	Payment lock key	BSEG	ZLSPR
ZTERM	Terms of payment key	BSEG	ZTERM
ZUONR	Assignment number	BSEG	ZUONR
XREF1	Reference key of the business partner	BSEG	XREF1
XREF2	Reference key of the business partner	BSEG	XREF2
XARCH	Indicator: Amount already in archive?	BSEG	XARCH
RSTGR	Reason code for payments	BSEG	RSTGR
ASKTO	Current cash discount amount in document currency	BSEG	SKFBT*¹ / WRBTR*¹
KURSE	Effective exchange rate in line item	BKPF	KURSF
REBZT	Type of follow-on document	BSEG	REBZT
PSWSL	Update currency for general ledger transaction figures	BSEG	PSWSL
PSWBT	Amount for general ledger update (absolute)	BSEG	PSWBT
HKONT	G/L account in General Ledger Accounting	FAGLFLEXA	RACCT
XNEGP	Indicator: Negative posting	BSEG	XNEGP
ZBFIX	Fixed payment condition	BSEG	ZBFIX
RFZEI	Payment card item	BSEG	RFZEI
CCBTC	Payment cards: Settlement run	BSEG	CCBTC
KKBER	Credit control area	BSEG	KKBER
XREF3	Reference key for the document items	BSEG	XREF3
DTWS1	Instruction 1	BSEG	DTWS1
DTWS2	Instruction 2	BSEG	DTWS2
DTWS3	Instruction 3	BSEG	DTWS3
DTWS4	Instruction 4	BSEG	DTWS4
ABSBT	Credit Management: Guaranteed amount (absolute)	BSEG	ABSBT*¹ / WRBTR*¹
KKBWR	Currency of credit controlling area		KKBER*¹
PROJK	WBS element in external format	BSEG	PROJK
XPYPR	Indicator: Payment order exists for this item	BSEG	XPYPR
KIDNO	Payment reference	BSEG	KIDNO
BUPLA	Business place	BSEG	BUPLA
SECCO	Withholding tax section	BSEG	SECCO
PYCUR	Currency for automatic payment	BSEG	PYCUR
PYAMT	Amount in currency for automatic payment (absolute)	BSEG	PYAMT*¹ / WRBTR*¹
XRAGL	Indicator: Clearing was undone	BSEG	XRAGL
CESSION_KZ	Accounts receivable pledging indicator	BSEG	CESSION_KZ
BUZID	Identification of posting line	BSEG	BUZID
AUGGJ	Fiscal year of clearing document	BSEG	AUGGJ
AGZEI	Clearing item	BSEG	AGZEI
AWSYS	Logical system	FAGLFLEXA	LOGSYS
AWTYP	Reference transaction	FAGLFLEXA	AWTYP
BDIFF	Valuation difference	BSEG	BDIFF*¹ / DMBTR*¹
BDIF2	Valuation difference for the second local currency	BSEG	BDIF2*¹ / DMBE2*¹
BDIF3	Valuation difference for the third local currency	BSEG	BDIF3 /DMBE3
BEWAR	Flow type	FAGLFLEXA	RMVCT
DABRZ	Asset value date for billing	BSEG	DABRZ
DMBTR	Amount in local currency	BSEG	DMBTR
DOCNR	Document number of general ledger document	FAGLFLEXA	DOCNR
DOCLN	Six-digit line item for ledger	FAGLFLEXA	DOCLN
FKBER	Functional area	BSEG	FKBER
FKBER_LONG	Functional area	FAGLFLEXA	RFAREA
GLVOR	Business transaction	FAGLFLEXA	ACTIV
IMKEY	Internal key for Real Estate object	BSEG	IMKEY
KOKRS	Controlling area	FAGLFLEXA	KOKRS
KSTAR	Cost element	BSEG	COST_ELEM
KUNNR	Customer number 1	BSEG	KUNNR
LIFNR	Account number of vendor	BSEG	LIFNR
MEINS	Base unit of measure	FAGLFLEXA	RUNIT
MENGE	Quantity	BSEG	MENGE*¹ / WRBTR*¹
PARGB	Business area of the business partner	FAGLFLEXA	SBUSA
PERIO	Period/year	FAGLFLEXA	RYEAR*¹ / POPER*¹
PFKBER	Functional area of partner	FAGLFLEXA	SFAREA
PKOSTL	Partner cost center	FAGLFLEXA	SCNTR
POPER	Posting period	FAGLFLEXA	POPER
PPRCT	Partner profit center	FAGLFLEXA	PPRCTR
PSEGMENT	Partner segment for segment reporting	FAGLFLEXA	PSEGMENT
PS_PSP_PNR	WBS elements	BSEG	SAKNR
RLDNR	Ledger	FAGLFLEXA	RLDNR
RYEAR	Fiscal year of the general ledger	FAGLFLEXA	RYEAR
SAKNR	G/L account number	BSEG	SAKNR
SEGMENT	Segment for segment reporting	FAGLFLEXA	SEGMENT
WRBTR	Amount in document currency	BSEG	WRBTR
XOPVW	Indicator: Open Item Management?	BSEG	XOPVW
LDGRP	Ledger group	BKPF	LDGRP
XLGCLR	Clearing specific to ledger groups	BSEG	XLGCLR
CPUDT	Entry date of the accounting document	BKPF	CPUDT
TIMESTAMP	UTC time stamp in short form (YYYYMMDDhhmmss)	FAGLFLEXA	TIMESTAMP
.APPEND	Public Sector fields for reading data of General Ledger line items
MANDT	Client		*²
UPMOD	BW delta procedure: Record mode		*²
RRCTY	Record type		*²
RVERS	Version		*²
FISCVAR	Fiscal year variant		RBUKRS*¹
FISCPER	Fiscal year/period	BKPF	GJAHR*¹ / MONAT*¹
RFISCVAR	Fiscal year variant		RLDNR*¹
RFISCPER	Fiscal year/period	FAGLFLEXA	RYEAR*¹ / POPER*¹
KTOPL	Chart of accounts		RLDNR*¹
PS_POSID	WBS elements	BSEG	PROJK*¹
CURT2	Currency type of the second local currency		RLDNR*¹
CURT3	Currency type of the third local currency		RLDNR*¹
DMHAB	Credit amount in local currency	BSEG	DMBTR*¹
DMHA2	Credit amount in second local currency	BSEG	DMBE2*¹
DMHA3	Credit amount in third local currency	BSEG	DMBE3*¹
DMSOL	Debit amount in local currency	BSEG	DMBTR*¹
DMSO2	Debit amount in second local currency	BSEG	DMBE2*¹
DMSO3	Debit amount in third local currency	BSEG	DMBE3*¹
DMSH2	Amount in second local currency with +/- sign	BSEG	DMBE2*¹
DMSH3	Amount in third local currency with +/- sign	BSEG	DMBE3*¹
WRHAB	Credit amount in document currency	BSEG	WRBTR*¹
WRSOL	Debit amount in document currency	BSEG	WRBTR*¹

Extractor Logic

Information on the “Field in the Origin Table”:

*¹: The values are determined from the specified fields.

*²: The values are determined from different sources.

Extraction method: F1 (function module (complete interface))

Extractor: FAGL_GET_SI_DATA

The extractor considers all data from the tables FAGLFLEXA (or similar customer tables), BKPF, BSEG, and BSEG_ADD.

Extraction structure: FAGLPOSBW

The FAGLPOSBW structure has a specific append for Public Sector (FMGL_FIELDS). Append extractor 0FI_GL_14_APPE is used to provide the corresponding fields in BI. This extractor assigns specific field attributes to the append fields. If you use transaction RSA5 to activate the extractor of DataSource 0FI_GL_14, the field attributes of the append extractor are assigned to the actual extractor.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk