On the basis of DataSource General Ledger Accounting: Transaction Figures (0FI_GL_20), this DataSource extracts cumulated balances for a reporting period.
Application Component | Financial Accounting: General Ledger Accounting (FI-GL) |
|---|---|
Available as of Release | SAP enhancement package 3 for SAP ERP 6.0, business function Reporting Financials (FIN_REP_SIMPL_1) |
Shipment | SAP NetWeaver 7.0 BI Content Add-On 3 Support Package 08 |
Content Versions | 603 |
RemoteCube-Capable | Yes |
Delta-Capable | No |
Extraction from Archives | No |
Verifiable | No |
Specify the reporting period either in the form of a simple posting period (POPER) or with a range, which you define using the characteristics From Period (POPER_FROM) and To Period (POPER_TO).
To ensure that the credit/debit balances of the cumulated values are correct, the entire dataset requested is first read. To limit the amount of memory space required, you restrict the characteristics or the list of requested characteristics, or both.
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
RYEAR |
Fiscal year |
FAGLFLEXT |
|
RMVCT |
Flow type |
FAGLFLEXT |
|
RTCUR |
Currency key |
FAGLFLEXT |
|
RLDNR |
Ledgers in General Ledger Accounting |
FAGLFLEXT |
|
RRCTY |
Record type |
FAGLFLEXT |
|
RVERS |
Version |
FAGLFLEXT |
|
LOGSYS |
Logical system |
FAGLFLEXT |
|
RACCT |
Account number |
FAGLFLEXT |
|
COST_ELEM |
Cost element |
FAGLFLEXT |
|
RBUKRS |
Company code |
FAGLFLEXT |
|
RCNTR |
Cost center |
FAGLFLEXT |
|
PRCTR |
Profit center |
FAGLFLEXT |
|
RFAREA |
Functional area |
FAGLFLEXT |
|
RBUSA |
Business area |
FAGLFLEXT |
|
KOKRS |
Controlling area |
FAGLFLEXT |
|
SEGMENT |
Segment for segment reporting |
FAGLFLEXT |
|
SCNTR |
Sender cost center |
FAGLFLEXT |
|
PPRCTR |
Partner profit center |
FAGLFLEXT |
|
SFAREA |
Functional area of partner |
FAGLFLEXT |
|
SBUSA |
Business area of the business partner |
FAGLFLEXT |
|
RASSC |
Company ID of trading partner |
FAGLFLEXT |
|
PSEGMENT |
Partner segment for segment reporting |
FAGLFLEXT |
|
VALUETYPE |
Value type for Reporting |
FAGLFLEXT |
|
CURTYPE |
Currency type |
FAGLFLEXT |
|
FISCPER |
Fiscal year/period |
FAGLFLEXT |
|
FISCVAR |
Fiscal year variant |
||
UPMOD |
BW delta procedure: Record mode |
||
VALUTYP |
Valuation View |
||
CURRUNIT |
Currency key |
FAGLFLEXT |
|
BALANCE |
Cumulated balance |
FAGLFLEXT |
|
POPER |
Posting period |
FAGLFLEXT |
|
POPER_FROM |
From period |
||
POPER_TO |
To period |
||
BALANCE_PY |
Balance carryforward |
FAGLFLEXT |
|
BALANCE_CY_PP |
Balance until reporting period (current fiscal year) |
FAGLFLEXT |
|
BALANCE_PP |
Balance until reporting period |
FAGLFLEXT |
|
DEBIT_CY_SP |
Debit amount in reporting period |
FAGLFLEXT |
|
CREDIT_CY_SP |
Credit amount in reporting period |
FAGLFLEXT |
|
DEBIT_CP |
Debit balance |
FAGLFLEXT |
|
CREDIT_CP |
Credit Balance |
FAGLFLEXT |
|
BALANCE_CP |
Cumulated balance |
FAGLFLEXT |