FAGL_BW_LOG_TOTL SAP (FI-GL: Log for BW Extraction: Totals Records) Table details
Description: FI-GL: Log for BW Extraction: Totals Records
Related tables to FAGL_BW_LOG_TOTL
Access table FAGL_BW_LOG_TOTL
Table field list including key, data, relationships and ABAP select examples
FAGL_BW_LOG_TOTL is a standard SAP Table which is used to store FI-GL: Log for BW Extraction: Totals Records data and is available within R/3 SAP systems depending on the version and release level.
The FAGL_BW_LOG_TOTL table consists of various fields, each holding specific information or linking keys about FI-GL: Log for BW Extraction: Totals Records data available in SAP. These include DATASOURCE (InfoSource), REQUNR (Request number for the data transfer), LOGTIMESTAMP (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)), RECNR (Record number of the line item record).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FAGL_BW_LOG_TOTL table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
DATASOURCE | InfoSource | RSISOURCE | CHAR | 30 | RSISOURCE | RSS | |||
REQUNR | Request number for the data transfer | RSREQUNR | CHAR | 30 | RSREQUNR | ||||
LOGTIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
RECNR | Record number of the line item record | GU_RECID | CHAR | 18 | OBJNR | OBN | |||
RYEAR | Fiscal year | RYEAR | NUMC | 4 | GJAHR | GJAHR | GFY | ||
ACTIV | FI-SL Business Transaction | ACTI1 | CHAR | 4 | T022 | ACTIVITY | |||
RMVCT | Transaction Type | RMVCT | CHAR | 3 | T856 | RMVCT | |||
RTCUR | Currency Key | RTCUR | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
RUNIT | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | TTYP | AWTYP | |||
RLDNR | Ledger in General Ledger Accounting | FAGL_RLDNR | CHAR | 2 | V_FAGL_T881_DBAL | ALPHA | RLDNR | GLN_FLEX | FAGL_RLDNR |
RRCTY | Record Type | RRCTY | CHAR | 1 | RRCTY | ||||
RVERS | Version | RVERS | CHAR | 3 | Assigned to domain | ALPHA | RVERS | GVS | |
LOGSYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
RACCT | Account Number | RACCT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ACC | |
COST_ELEM | Cost Element | KSTAR | CHAR | 10 | CSKB | ALPHA | KSTAR | KAT | |
RBUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RCNTR | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
RFAREA | Functional Area | FKBER | CHAR | 16 | TFKB | FKBER | FBE | ||
RBUSA | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
SCNTR | Sender cost center | SKOST | CHAR | 10 | CSKS | ALPHA | KOSTL | KSK | |
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PPC | |
SFAREA | Partner Functional Area | SFKBER | CHAR | 16 | TFKB | FKBER | |||
SBUSA | Trading partner's business area | PARGB | CHAR | 4 | TGSB | GSBER | GSB | ||
RASSC | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
QUANUNIT | Unit of Measure | ROUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
VALUETYPE | Value type for Reporting | RSVTYPE | NUMC | 3 | Assigned to domain | RSVTYPE | |||
CURTYPE | Currency type | RSCURTYPE | CHAR | 2 | RSCURTYPE | ||||
FISCPER | Fiscal year / period | RSFISCPER | NUMC | 7 | PERI7 | RSFISCPER | |||
FISCVAR | Fiscal year variant | RSFISCVAR | CHAR | 2 | RSFISCVAR | ||||
CHARTACCTS | Chart of Accounts | KTOPL | CHAR | 4 | Assigned to domain | KTOPL | KPL | C_KTOPL | |
UPMOD | BW Delta Process: Record Mode | RODMUPDMOD | CHAR | 1 | RODMUPDMOD | ||||
VALUTYP | Valuation View | VALUTYP | NUMC | 1 | VALUTYP | VTP | |||
CURRUNIT | Currency Key | RSCURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
BALANCE | Accumulated balance | RR_KUMSL | CURR | 17(2) | WERTV9 | ||||
DEBIT | Total debit postings | RR_UMSOL | CURR | 17(2) | WERTV9 | ||||
CREDIT | Total credit postings | RR_UMHAB | CURR | 17(2) | WERTV9 | ||||
TURNOVER | Sales of the period | RR_SALES | CURR | 17(2) | WERTV9 | ||||
QUANTITY | Consumption Quantity | SMEGR9 | QUAN | 17(3) | MENGV9 | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
RCOMP | Company | RCOMP_D | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | GCC | |
RPRCTR | Receiver profit center | RPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | |
SPRCTR | Sender Profit Center | SPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR |
Key field | Non-key field |
How do I retrieve data from SAP table FAGL_BW_LOG_TOTL using ABAP code
The following ABAP code Example will allow you to do a basic selection on FAGL_BW_LOG_TOTL to SELECT all data from the tableDATA: WA_FAGL_BW_LOG_TOTL TYPE FAGL_BW_LOG_TOTL.
SELECT SINGLE *
FROM FAGL_BW_LOG_TOTL
INTO CORRESPONDING FIELDS OF WA_FAGL_BW_LOG_TOTL
WHERE...
How to access SAP table FAGL_BW_LOG_TOTL
Within an ECC or HANA version of SAP you can also view further information about FAGL_BW_LOG_TOTL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects