- Home
- Resources
- SAP Tables
- FAGL_BW_LOG_TOTL - FI-GL: Log for BW Extraction: Totals Records
SAP Table FAGL_BW_LOG_TOTL
FI-GL: Log for BW Extraction: Totals Records
FAGL_BW_LOG_TOTL (FI-GL: Log for BW Extraction: Totals Records) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link FAGL_BW_LOG_TOTL to other SAP tables.
Source: FAGL_BW_LOG_TOTL (FI-GL: Log for BW Extraction: Totals Records)
FAGL_BW_LOG_TOTL table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
|
CLNT |
|
3 |
0 |
|
| DATASOURCE |
InfoSource |
RSISOURCE |
|
CHAR |
|
30 |
0 |
|
| REQUNR |
Request number for the data transfer |
RSREQUNR |
|
CHAR |
|
30 |
0 |
|
| LOGTIMESTAMP |
UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
TIMESTAMP |
|
DEC |
|
15 |
0 |
|
| RECNR |
Record number of the line item record |
GU_RECID |
|
CHAR |
|
18 |
0 |
|
| RYEAR |
Fiscal year |
RYEAR |
|
NUMC |
|
4 |
0 |
|
| ACTIV |
FI-SL Business Transaction |
ACTI1 |
T022
|
CHAR |
|
4 |
0 |
|
| RMVCT |
Transaction Type |
RMVCT |
T856
|
CHAR |
|
3 |
0 |
|
| RTCUR |
Currency Key |
RTCUR |
|
CUKY |
|
5 |
0 |
|
| RUNIT |
Base Unit of Measure |
MEINS |
|
UNIT |
|
3 |
0 |
|
| AWTYP |
Reference Transaction |
AWTYP |
TTYP
|
CHAR |
|
5 |
0 |
|
| RLDNR |
Ledger in General Ledger Accounting |
FAGL_RLDNR |
V_FAGL_T881_DBAL
|
CHAR |
|
2 |
0 |
|
| RRCTY |
Record Type |
RRCTY |
|
CHAR |
|
1 |
0 |
Possible values
| 0 |
Actual |
| 1 |
Plan |
| 2 |
Actual assessment/distribution |
| 3 |
Planned assessment/distribution |
|
| RVERS |
Version |
RVERS |
|
CHAR |
|
3 |
0 |
|
| LOGSYS |
Logical system |
LOGSYS |
TBDLS
|
CHAR |
|
10 |
0 |
|
| RACCT |
Account Number |
RACCT |
SKB1
|
CHAR |
|
10 |
0 |
|
| COST_ELEM |
Cost Element |
KSTAR |
CSKB
|
CHAR |
|
10 |
0 |
|
| RBUKRS |
Company Code |
BUKRS |
T001
|
CHAR |
|
4 |
0 |
|
| RCNTR |
Cost Center |
KOSTL |
CSKS
|
CHAR |
|
10 |
0 |
|
| PRCTR |
Profit Center |
PRCTR |
CEPC
|
CHAR |
|
10 |
0 |
|
| RFAREA |
Functional Area |
FKBER |
TFKB
|
CHAR |
|
16 |
0 |
|
| RBUSA |
Business Area |
GSBER |
TGSB
|
CHAR |
|
4 |
0 |
|
| KOKRS |
Controlling Area |
KOKRS |
TKA01
|
CHAR |
|
4 |
0 |
|
| SEGMENT |
Segment for Segmental Reporting |
FB_SEGMENT |
FAGL_SEGM
|
CHAR |
|
10 |
0 |
|
| SCNTR |
Sender cost center |
SKOST |
CSKS
|
CHAR |
|
10 |
0 |
|
| PPRCTR |
Partner Profit Center |
PPRCTR |
CEPC
|
CHAR |
|
10 |
0 |
|
| SFAREA |
Partner Functional Area |
SFKBER |
TFKB
|
CHAR |
|
16 |
0 |
|
| SBUSA |
Trading partner's business area |
PARGB |
TGSB
|
CHAR |
|
4 |
0 |
|
| RASSC |
Company ID of trading partner |
RASSC |
T880
|
CHAR |
|
6 |
0 |
|
| PSEGMENT |
Partner Segment for Segmental Reporting |
FB_PSEGMENT |
FAGL_SEGM
|
CHAR |
|
10 |
0 |
|
| QUANUNIT |
Unit of Measure |
ROUNIT |
|
UNIT |
|
3 |
0 |
|
| VALUETYPE |
Value type for Reporting |
RSVTYPE |
|
NUMC |
|
3 |
0 |
|
| CURTYPE |
Currency type |
RSCURTYPE |
|
CHAR |
|
2 |
0 |
Possible values
| 00 |
Document currency |
| 10 |
Company code currency |
| 20 |
Controlling area currency |
| 30 |
Group currency |
| 40 |
Hard currency |
| 50 |
Index-based currency |
| 60 |
Global company currency |
| 70 |
Controlling object currency |
| 80 |
Ledger currency |
| 90 |
Profit center invoice currency |
|
| FISCPER |
Fiscal year / period |
RSFISCPER |
|
NUMC |
|
7 |
0 |
|
| FISCVAR |
Fiscal year variant |
RSFISCVAR |
|
CHAR |
|
2 |
0 |
|
| CHARTACCTS |
Chart of Accounts |
KTOPL |
|
CHAR |
|
4 |
0 |
|
| UPMOD |
BW Delta Process: Record Mode |
RODMUPDMOD |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
After-Image |
| X |
Before-Image |
| A |
Add |
| D |
Delete (Key Only) |
| N |
New Image |
| R |
Reverse-Image |
| Y |
Update Image (Value from Update) |
|
| VALUTYP |
Valuation View |
VALUTYP |
|
NUMC |
|
1 |
0 |
Possible values
| 0 |
Legal Valuation |
| 1 |
Group Valuation |
| 2 |
Profit Center Valuation |
| 5 |
Parallel Cost of Goods Manufactured 1 |
| 6 |
Parallel Cost of Goods Manufactured 2 |
| 7 |
Parallel Cost of Goods Manufactured 3 |
|
| CURRUNIT |
Currency Key |
RSCURRENCY |
|
CUKY |
|
5 |
0 |
|
| BALANCE |
Accumulated balance |
RR_KUMSL |
|
CURR |
|
17 |
2 |
|
| DEBIT |
Total debit postings |
RR_UMSOL |
|
CURR |
|
17 |
2 |
|
| CREDIT |
Total credit postings |
RR_UMHAB |
|
CURR |
|
17 |
2 |
|
| TURNOVER |
Sales of the period |
RR_SALES |
|
CURR |
|
17 |
2 |
|
| QUANTITY |
Consumption Quantity |
SMEGR9 |
|
QUAN |
|
17 |
3 |
|
| CPUDT |
Day On Which Accounting Document Was Entered |
CPUDT |
|
DATS |
|
8 |
0 |
|
| CPUTM |
Time of Entry |
CPUTM |
|
TIMS |
|
6 |
0 |
|
| RCOMP |
Company |
RCOMP_D |
|
CHAR |
|
6 |
0 |
|
| RPRCTR |
Receiver profit center |
RPRCTR |
|
CHAR |
|
10 |
0 |
|
| SPRCTR |
Sender Profit Center |
SPRCTR |
|
CHAR |
|
10 |
0 |
|
FAGL_BW_LOG_TOTL foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| FAGL_BW_LOG_TOTL |
ACTIV |
FAGL_BW_LOG_TOTL |
ACTIV |
T022 |
FI-SL Activity: Fixed Data |
ACTIVITY |
| FAGL_BW_LOG_TOTL |
AWTYP |
FAGL_BW_LOG_TOTL |
AWTYP |
TTYP |
Object Types for Accounting |
AWTYP |
| FAGL_BW_LOG_TOTL |
COST_ELEM |
FAGL_BW_LOG_TOTL |
COST_ELEM |
CSKB |
Cost Elements (Data Dependent on Controlling Area) |
KSTAR |
| FAGL_BW_LOG_TOTL |
COST_ELEM |
FAGLFLEX03_DATA |
KOKRS |
CSKB |
Cost Elements (Data Dependent on Controlling Area) |
KOKRS |
| FAGL_BW_LOG_TOTL |
COST_ELEM |
SYST |
MANDT |
CSKB |
Cost Elements (Data Dependent on Controlling Area) |
MANDT |
| FAGL_BW_LOG_TOTL |
COST_ELEM |
* |
|
CSKB |
Cost Elements (Data Dependent on Controlling Area) |
DATBI |
| FAGL_BW_LOG_TOTL |
KOKRS |
FAGL_BW_LOG_TOTL |
KOKRS |
TKA01 |
Controlling Areas |
KOKRS |
| FAGL_BW_LOG_TOTL |
KOKRS |
SYST |
MANDT |
TKA01 |
Controlling Areas |
MANDT |
| FAGL_BW_LOG_TOTL |
LOGSYS |
FAGL_BW_LOG_TOTL |
LOGSYS |
TBDLS |
Logical system |
LOGSYS |
| FAGL_BW_LOG_TOTL |
PPRCTR |
* |
|
CEPC |
Profit Center Master Data Table |
DATBI |
| FAGL_BW_LOG_TOTL |
PPRCTR |
FAGL_BW_LOG_TOTL |
PPRCTR |
CEPC |
Profit Center Master Data Table |
PRCTR |
| FAGL_BW_LOG_TOTL |
PPRCTR |
SYST |
MANDT |
CEPC |
Profit Center Master Data Table |
MANDT |
| FAGL_BW_LOG_TOTL |
PPRCTR |
* |
|
CEPC |
Profit Center Master Data Table |
KOKRS |
| FAGL_BW_LOG_TOTL |
PRCTR |
SYST |
MANDT |
CEPC |
Profit Center Master Data Table |
MANDT |
| FAGL_BW_LOG_TOTL |
PRCTR |
FAGL_BW_LOG_TOTL |
PRCTR |
CEPC |
Profit Center Master Data Table |
PRCTR |
| FAGL_BW_LOG_TOTL |
PRCTR |
* |
|
CEPC |
Profit Center Master Data Table |
DATBI |
| FAGL_BW_LOG_TOTL |
PRCTR |
FAGL_BW_LOG_TOTL |
KOKRS |
CEPC |
Profit Center Master Data Table |
KOKRS |
| FAGL_BW_LOG_TOTL |
PSEGMENT |
FAGL_BW_LOG_TOTL |
PSEGMENT |
FAGL_SEGM |
Master Data for Segments |
SEGMENT |
| FAGL_BW_LOG_TOTL |
PSEGMENT |
SYST |
MANDT |
FAGL_SEGM |
Master Data for Segments |
MANDT |
| FAGL_BW_LOG_TOTL |
RACCT |
SYST |
MANDT |
SKB1 |
G/L account master (company code) |
MANDT |
| FAGL_BW_LOG_TOTL |
RACCT |
FAGLFLEX03_KEY |
RBUKRS |
SKB1 |
G/L account master (company code) |
BUKRS |
| FAGL_BW_LOG_TOTL |
RACCT |
FAGL_BW_LOG_TOTL |
RACCT |
SKB1 |
G/L account master (company code) |
SAKNR |
| FAGL_BW_LOG_TOTL |
RASSC |
FAGL_BW_LOG_TOTL |
RASSC |
T880 |
Global Company Data (for KONS Ledger) |
RCOMP |
| FAGL_BW_LOG_TOTL |
RASSC |
SYST |
MANDT |
T880 |
Global Company Data (for KONS Ledger) |
MANDT |
| FAGL_BW_LOG_TOTL |
RBUKRS |
FAGL_BW_LOG_TOTL |
RBUKRS |
T001 |
Company Codes |
BUKRS |
| FAGL_BW_LOG_TOTL |
RBUKRS |
SYST |
MANDT |
T001 |
Company Codes |
MANDT |
| FAGL_BW_LOG_TOTL |
RBUSA |
SYST |
MANDT |
TGSB |
Business Areas |
MANDT |
| FAGL_BW_LOG_TOTL |
RBUSA |
FAGL_BW_LOG_TOTL |
RBUSA |
TGSB |
Business Areas |
GSBER |
| FAGL_BW_LOG_TOTL |
RCNTR |
SYST |
MANDT |
CSKS |
Cost Center Master Data |
MANDT |
| FAGL_BW_LOG_TOTL |
RCNTR |
FAGL_BW_LOG_TOTL |
KOKRS |
CSKS |
Cost Center Master Data |
KOKRS |
| FAGL_BW_LOG_TOTL |
RCNTR |
FAGL_BW_LOG_TOTL |
RCNTR |
CSKS |
Cost Center Master Data |
KOSTL |
| FAGL_BW_LOG_TOTL |
RCNTR |
* |
|
CSKS |
Cost Center Master Data |
DATBI |
| FAGL_BW_LOG_TOTL |
RFAREA |
SYST |
MANDT |
TFKB |
Functional areas |
MANDT |
| FAGL_BW_LOG_TOTL |
RFAREA |
FAGL_BW_LOG_TOTL |
RFAREA |
TFKB |
Functional areas |
FKBER |
| FAGL_BW_LOG_TOTL |
RLDNR |
FAGL_BW_LOG_TOTL |
RLDNR |
V_FAGL_T881_DBAL |
Generated Table for View |
RLDNR |
| FAGL_BW_LOG_TOTL |
RLDNR |
SYST |
MANDT |
V_FAGL_T881_DBAL |
Generated Table for View |
MANDT |
| FAGL_BW_LOG_TOTL |
RMVCT |
SYST |
MANDT |
T856 |
Transaction Types |
MANDT |
| FAGL_BW_LOG_TOTL |
RMVCT |
FAGL_BW_LOG_TOTL |
RMVCT |
T856 |
Transaction Types |
TRTYP |
| FAGL_BW_LOG_TOTL |
SBUSA |
FAGL_BW_LOG_TOTL |
SBUSA |
TGSB |
Business Areas |
GSBER |
| FAGL_BW_LOG_TOTL |
SBUSA |
SYST |
MANDT |
TGSB |
Business Areas |
MANDT |
| FAGL_BW_LOG_TOTL |
SCNTR |
* |
|
CSKS |
Cost Center Master Data |
KOKRS |
| FAGL_BW_LOG_TOTL |
SCNTR |
SYST |
MANDT |
CSKS |
Cost Center Master Data |
MANDT |
| FAGL_BW_LOG_TOTL |
SCNTR |
FAGL_BW_LOG_TOTL |
SCNTR |
CSKS |
Cost Center Master Data |
KOSTL |
| FAGL_BW_LOG_TOTL |
SCNTR |
* |
|
CSKS |
Cost Center Master Data |
DATBI |
| FAGL_BW_LOG_TOTL |
SEGMENT |
FAGL_BW_LOG_TOTL |
SEGMENT |
FAGL_SEGM |
Master Data for Segments |
SEGMENT |
| FAGL_BW_LOG_TOTL |
SEGMENT |
SYST |
MANDT |
FAGL_SEGM |
Master Data for Segments |
MANDT |
| FAGL_BW_LOG_TOTL |
SFAREA |
FAGL_BW_LOG_TOTL |
SFAREA |
TFKB |
Functional areas |
FKBER |
| FAGL_BW_LOG_TOTL |
SFAREA |
SYST |
MANDT |
TFKB |
Functional areas |
MANDT |
