!--a11y-->
DataSources in Global Spend Analysis Based on
FI Data 
No DataSources are delivered with Global Spend Analysis based on data from Financial Accounting. The DataSources are generated after the special ledger is created in SAP Financial Accounting (SAP FI). In the standard, however, you can use the following extract structure.
Extract Structure
Field in Extract Structure |
Description of Field in the Extract Structure |
Ledger Table |
Accounting Interface Table |
FI Table |
BLART |
Document type |
<Ledger Table>- BLART |
ACCIT_GLX- BLART |
BKPF-BLART |
BUDAT |
Posting date in the document |
<Ledger Table>- BUDAT |
ACCIT_GLX- BUDAT |
BSEG/BKPF-BUDAT |
CHARTACCTS |
Chart of accounts |
Ledger routine (master data of the ledger and organizational unit) |
|
|
CPUDT |
Day on which accounting document was created |
Ledger routine |
|
|
CPUTM |
Time of entry |
Ledger routine |
|
|
CREDIT |
Total of credit postings |
Ledger routine |
|
|
CURRUNIT |
Currency key |
Ledger routine |
|
|
CURTYPE |
Currency type
|
Ledger routine |
|
|
DEBIT |
Total of debit postings |
Ledger routine |
|
|
EBELN |
Purchasing document number |
<Ledger Table>-EBELN |
ACCIT_GLX- EBELN |
BSEG-EBELN |
EBELP |
Purchasing document item number |
<Ledger Table>-EBELP |
ACCIT_GLX- EBELP |
BSEG-EBELP |
FISCPER |
Fiscal year / period |
Ledger routine using POPER and RYEAR |
|
|
FISCVAR |
Fiscal year variant |
Ledger routine (master data of the ledger and organizational unit) |
|
|
MATNR |
Material number |
<Ledger Table>-MATNR |
ACCIT_GLX- MATNR |
BSEG-MATNR |
POPER |
Posting period |
<Ledger Table>-POPER (determined in ledger routine?) used indirectly |
|
|
RACCT |
Account number |
<Ledger Table>-RACCT |
ACCIT_GLX-HKONT |
BSEG-HKONT (or SAKNR?) |
RBUKRS |
Company code |
<Ledger Table>- BUKRS |
ACCIT_GLX- BUKRS |
BSEG-BUKRS |
RBUSA |
Business area |
<Ledger Table>- RBUSA |
ACCIT_GLX-GSBER |
BSEG-GSBER |
RCNTR |
Cost center |
<Ledger Table>- |
ACCIT_GLX-KOSTL |
BSEG-KOSTL |
REFDOCLN |
Six-digit number of reference posting line |
<Ledger Table>- REFDOCLN |
ACCIT_GLX-BUZEI |
BSEG-BUZEI |
REFDOCNR |
Accounting document reference number |
<Ledger Table>- REFDOCNR |
ACCIT_GLX- BELNR |
BSEG/BKPF-BELNR |
RFAREA |
Functional area |
<Ledger Table>- RFAREA |
ACCIT_GLX-FKBER |
BSEG-FKBER |
RYEAR |
Fiscal year |
<Ledger Table>- RYEAR |
ACCIT_GLX- GJAHR |
BSEG/BKPF-GJAHR |
ZZBSCHL |
Posting key |
<Ledger Table>- ZZBSCHL |
ACCIT_GLX- BSCHL |
BSEG-BSCHL |
ZZKKTO |
Account number in the group |
<Ledger Table>- ZZKKTO |
ACCIT_GLX- ALTKT |
BSEG-ALTKT |
ZZKOART |
Account type |
<Ledger Table>- ZZKOART |
ACCIT_GLX- KOART |
BSEG-KOART |
ZZLIFNR |
Account number of the vendor or creditor |
<Ledger Table>-ZZLIFNR |
ACCIT_GLX-LIFNR |
BSEG-LIFNR |
ZZSPENDRELEVANT |
Character field of length 1 |
Set in field exit of ledger |
|
|
ZZCO_WERK |
Plant |
<Ledger Table>- CO_ WERK |
ACCIT_GLX- WERKS |
BSEG- WERKS |
KOKRS |
Controlling area |
<Ledger Table>- KOKRS |
ACCIT_GLX- KOKRS |
BSEG- KOKRS |
ZZCOMP_DRCRK |
Credit/debit indicators |
<Ledger Table>- ZZCOMP_DRCRK |
ACCIT_GLX-SHKZG |
BSEG-SHKZG |
BLART |
Document type |
<Ledger Table>- BLART |
ACCIT_GLX- BLART |
BKPF-BLART |
AUFNR |
Order number |
<Ledger Table>- PROJK |
ACCIT_GLX- |
BSEG-PROJK |
ZZPROJK |
Work breakdown structure element |
<Ledger Table>- AUFNR |
ACCIT_GLX- |
BKPF- AUFNR |
BELNR |
Accounting document number |
<Ledger Table>- BELNR |
ACCIT_GLX- BELNR |
BSEG- BELNR |
BUZEI |
Number of line item within accounting document |
<Ledger Table>- BUZEI |
ACCIT_GLX- BUZEI |
BSEG- BUZEI |
Deltas are based on a time stamp procedure.
The DataSource must be consolidated in an ODS object before the data is updated to other data targets.
