Start of Content Area

Background documentation DataSources in Global Spend Analysis Based on FI Data Locate the document in its SAP Library structure

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.

Fields of Origin in the 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

 

Delta Update

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.

 

 

 

End of Content Area