tech info fi

7/28/2019 Tech Info Fi

1/37


2/37

Financial Accounting Technical Information

Umar Faruq BI Consultant

Page : 2 Date of Issue: 16/06/2013


3/37


Table of Contents

Document Purpose......................................................................................................................................5

Technical Overview for Asset Accounting...............................................................................................5

Data Flows..................................................................................................................................................6

InfoCube Objects.......................................................................................................................................6

Dimensions..................................................................................................................................................9

InfoCube - schematic display....................................................................................................................9

Query Requirements................................................................................................................................10

Query Preview..........................................................................................................................................10

Other Queries...........................................................................................................................................10

2.1 Technical Overview for Accounts Receivable...................................................................................11

2.2 Data Flows...........................................................................................................................................12

2.3 InfoCube Objects................................................................................................................................12

2.4 Dimensions...........................................................................................................................................14

2.5 InfoCube - schematic display.............................................................................................................15

2.6 Query Requirements...........................................................................................................................15

2.7 Query Preview.....................................................................................................................................16

2.8Other Queries ......................................................................................................................................16

3.1 Technical Overview for Accounts Payable Line Items.....................................................................19

3.2 Data Flows...........................................................................................................................................19


3.4 Dimensions...........................................................................................................................................22



3.7 Query Preview.....................................................................................................................................24

3.8 Other Queries......................................................................................................................................24

4.1 Technical Overview for Accounts Payable Transaction info ..........................................................25

4.2 Data Flows...........................................................................................................................................25


4.4 Dimensions...........................................................................................................................................28



4.7 Query Preview.....................................................................................................................................29

4.8 Other Queries......................................................................................................................................29



4/37


5.1 Technical Overview for General Ledger Accounting ......................................................................30

5.2 Data Flows...........................................................................................................................................30


5.4 Dimensions...........................................................................................................................................32



5.7 Query Preview.....................................................................................................................................33

5.8 Other Queries......................................................................................................................................33

6.1 Technical Overview for AR Payment History ..................................................................................34

6.2 Data Flows...........................................................................................................................................34


6.4 Dimensions...........................................................................................................................................36



6.7 Query Preview.....................................................................................................................................37

6.8 Other Queries......................................................................................................................................37



5/37


Overview

Document PurposeThe purpose of this document is to provide a detailed description of the SAFRA BI Financial

Accounting Infoproviders Details.

Requirement Overview for Asset Accounting

The purpose of this Cube is to supply an InfoProvider for reporting purposes.

Technical Overview for Asset Accounting

InfoProvider

Technical Name

Description InfoArea

ZFIAA_C2 Asset Transactions and PostedDepreciations Data

Asset Accounting

Info Area Technical ID Description

ZFIAA Asset Accounting



6/37


Data Flows

InfoCube Objects

Characteristics



7/37


InfoCube Objects

Characteristics Technical name

Navigation

attribute

Asset capitalization date 0CAPIT_DATE

Asset class 0ASSET_CLAS

Asset Class 0ASSET__0ASSET_CLAS X

Asset Sub-number 0ASSET

Asset Transaction Type 0TRANSTYPE

Bal. Sheet Account: Acquisition

and Production Costs 0BALSHA_APC

Business area 0BUS_AREA

Business area 0ASSET__0BUS_AREA X

Chart of accounts 0CHRT_ACCTS

Company code 0COMP_CODE

Controlling area 0CO_AREA

Controlling Area 0ASSET__0CO_AREA X

Cost Center 0COSTCENTER

Cost Center 0ASSET__0COSTCENTER X

Depreciation area real or derived 0DEPRAREA

Depreciation Area Real orDerived 0ASSET_AFAB

Fiscal Year of the FirstAcquisition Posting 0ACQ_YEAR

Fiscal Year of the FirstAcquisition Posting 0ASSET__0ACQ_YEAR X

Main Asset Number 0ASSET_MAIN

Order number 0COORDER

Period in which first acquisitionwas posted 0ACQ_PER

Period in which first acquisitionwas posted 0ASSET__0ACQ_PER X

Sequence number of asset lineitems in fiscal year 0SEQ_NUMBER

Summariz. of trans. types forasset history sheet 0SHEET_GRP

Summariz. of trans. types forasset history sheet 0TRANSTYPE__0SHEET_GRP X

Key figures



8/37


Key figures

Accumulated ordinary depreciation 0COR_DEP_YR

Acquisition value for transactions 0ACQ_VAL_TR

Cumulative unplanned depreciation 0CUP_DEP_YR

Gain from asset retirement 0GAIN_ASSRT

Loss from asset retirement 0LOSS_ASSRT

Ordinary depreciation on transactions 0ORD_DEP_TR

Revaluation of cumulative ord.depreciation 0PREV_AODPE

Revenue from asset sale 0RETMT_REV

Trans.: Acc. dep. and appreciation onunplanned depreciation 0VAW_UDP_TR

Transaction: Acc. dep./app. onordinary depreciation 0VAW_ODP_TR

Unplanned depreciation for thetransaction 0UPL_DEP_TR

Value at period start: Cumulatedordinary depreciation 0COR_DEP_PE

Values at period start: Cum.

unplanned depreciation 0CUP_DEP_PE

Values for the period: Postedordinary depreciation 0PST_ODP_PE

Values for the period: Postedunplanned depreciation 0PUP_DEP_PE

Time characteristics

Time characteristics

Fiscal year 0FISCYEAR

Fiscal year / period 0FISCPER

Fiscal year variant 0FISCVARNT

Posting period 0FISCPER3

Units



9/37


Units

Currency Key 0CURRENCY

Dimensions

Description Technical Name Line Item Cardinality Flag

ZFIAA_C21 Organization

ZFIAA_C22 Depreciation areareal or derived

ZFIAA_C23 Asset

ZFIAA_C24 Order number

ZFIAA_C2T Time

ZFIAA_C2P Data Package

ZFIAA_C2U Unit

InfoCube - schematic display



10/37


Query Requirements

FunctionalArea

Technical ID Query Description

Finance SAFR_FI_AA_Q002 Asset Accounting Analysis

Query Preview

Other Queries



11/37


Requirement Overview for Accounts Receivable


2.1 Technical Overview for Accounts Receivable

InfoProviderTechnical Name


ZFIAR_C4 FIAR: Line Item Accounts Receivable

Accounting


ZFIAR Accounts Receivable Accounting



12/37


2.2 Data Flows

2.3 InfoCube Objects

2.3.1 Characteristics



13/37


InfoCube Objects


Navigation

attribute

Account type 0ACCT_TYPE

Accounting document number 0AC_DOC_NO

Baseline Date For Due DateCalculation 0BLINE_DATE


Clearing date 0CLEAR_DATE

Clearing Document Number 0CLR_DOC_NO


Country key 0COUNTRY

Country key to the debitor 0DEBITOR__0COUNTRY X

Credit Control Area 0C_CTR_AREA

Customer Industry 0DEBITOR__0CUST_CLASS X

Customer number 0DEBITOR

Date on which the record wascreated 0CREATEDON

Document Date 0DOC_DATE

Document type 0AC_DOC_TYP

Due date for cash discount 1 0DSCT_DATE1


Due date for net payment 0NETDUEDATE

G/L Account 0GL_ACCOUNT

Item Status 0FI_DOCSTAT

Number of line item withinaccounting document 0ITEM_NUM

Posting date in the document 0PSTNG_DATE

Posting key 0POST_KEY

Reconciliation Account 0RC_ACCOUNT

Reference document number 0REF_DOC_NO

Region 0DEBITOR__0REGION X

Special G/L indicator 0SP_GL_IND

Terms of Payment Key 0PMNTTRMS



14/37


2.3.2 Key figures

Key figures Accumulated ordinary depreciation 0COR_DEP_YR

Amount eligible for cash discount indocument currency 0DISC_BASE

Amount in Local Currency with +/-Signs 0DEB_CRE_LC

Credit amount in foreign currency 0CREDIT_DC

Credit amount in local currency 0CREDIT_LC

Debit amount in foreign currency 0DEBIT_DC

Debit amount in local currency 0DEBIT_LC

Foreign currency amount with signs(+/-) 0DEB_CRE_DC

2.3.3 Time characteristics

Time characteristics Fiscal year 0FISCYEAR

Calendar Day 0CALDAY

Calendar Year 0CALYEAR

Calendar Year/Month 0CALMONTH




2.3.4 Units

Units Document currency 0DOC_CURRCY

Local currency 0LOC_CURRCY

2.4 Dimensions



15/37



ZFIAR_C41 Company Code

ZFIAR_C42 Customer

ZFIAR_C43 Accounting DocData

ZFIAR_C44 Payment Data

ZFIAR_C45 Due Dates

ZFIAR_C46 G/L Account

ZFIAR_C47 Document Data

ZFIAR_C4T Time

ZFIAR_C4P Data Package

ZFIAR_C4U Unit

2.5 InfoCube - schematic display

2.6 Query Requirements

FunctionalArea




16/37


Finance SAFR_FI_AR_Q001 CUSTOMER AGINGANALYSIS ( TOTAL )

2.7 Query Preview

2.8 Other Queries

Functional

Area


Finance SAFR_FI_AR_Q002 Days Overdue analysis 0 -15 - 30 - 60 - 90 - Morethan 90 days

FunctionalArea




17/37


Finance SAFR_FI_AR_Q003 Customer Advances

Functional

Area


Finance SAFR_FI_AR_Q005 Customers : Overview

FunctionalArea


Finance SAFR_FI_AR_Q009 SPP CUSTOMER BALANCES

REPORT



18/37


FunctionalArea


Finance SAFR_FI_AR_Q010 SPP CUSTOMER BALANCES WITHYEAR WISE AGING

Requirement Overview for Accounts Payable




19/37


3.1 Technical Overview for Accounts Payable Line Items

InfoProvider

Technical Name


ZFIAP_C4 FIAP: Line Item Accounts PayableAccounting


ZFIAP Accounts Payable Accounting

3.2 Data Flows



20/37






21/37


InfoCube Objects


Navigation

attribute

Account number of supplier/vendor 0CREDITOR

Account Number of the Branch 0FI_SUBSID

Account type 0ACCT_TYPE

Accounting document number 0AC_DOC_NO

Baseline Date For Due DateCalculation 0BLINE_DATE


Clearing date 0CLEAR_DATE


Country key 0COUNTRY

Document Date 0DOC_DATE

Document type 0AC_DOC_TYP



Due date for net payment 0NETDUEDATEDue Date Item Number 0FI_DSBITEM


Item Status 0FI_DOCSTAT

Number of line item withinaccounting document 0ITEM_NUM

Payment block key 0PMNT_BLOCK

Payment method 0PYMT_METH

Posting date in the document 0PSTNG_DATE

Posting key 0POST_KEY

Reason code for payments 0REASON_CDE

Special G/L indicator 0SP_GL_IND

Terms of Payment Key 0PMNTTRMS



22/37


3.3.2 Key figures

Key figures

Amount eligible for cash discount indocument currency 0DISC_BASE

Amount in Local Currency with +/- Signs 0DEB_CRE_LC

Cash discount amount in documentcurrency 0DSC_AMT_DC

Cash discount amount in local currency 0DSC_AMT_LC

Credit amount in foreign currency 0CREDIT_DC

Credit amount in local currency 0CREDIT_LC

Debit amount in foreign currency 0DEBIT_DC

Debit amount in local currency 0DEBIT_LC

Foreign currency amount with signs (+/-) 0DEB_CRE_DC






3.3.4 Units

Units Document currency 0DOC_CURRCY

Local currency 0LOC_CURRCY

3.4 Dimensions



23/37



ZFIAP_C41 Company CodeZFIAP_C42 Vendor

ZFIAP_C43 Accounting document

ZFIAP_C44 Payment Data

ZFIAP_C45 Due Dates

ZFIAP_C46 G/L Account

ZFIAP_C47 Document Data

ZFIAP_C4T Time

ZFIAP_C4P Data PackageZFIAP_C4U Unit





24/37


Functional Area Technical ID Query Description

Finance SAFR_FI_AP_Q001 Vendor Aging Analysis

3.7 Query Preview

3.8 Other Queries

Functional Area Technical ID Query Description

Finance SAFR_FI_AP_Q003 Vendors : Overview Line item Data

FunctionalArea


Finance SAFR_FI_AP_Q004 Advances Analysis Report



25/37


4.1 Technical Overview for Accounts PayableTransaction info

InfoProvider

Technical Name


ZFIAP_C6 FIAP: Transaction Data Accounts PayableAccounting


ZFIAP Accounts Payable Accounting

4.2 Data Flows



26/37


27/37




InfoCube Objects

Characteristics Technical nameNavigationattribute

Account number of supplier/vendor 0CREDITOR


Currency Type 0CURTYPE

4.3.2 Key figures

Key figures Cumulative Balance 0BALANCE

Sales for the Period 0SALES

Total credit postings 0CREDIT

Total Debit Postings 0DEBIT






4.3.4 Units

Units Currency Key 0CURRENCY



28/37


4.4 Dimensions


ZFIAP_C61 Vendor

ZFIAP_C61 Company Code

ZFIAP_C61 Currency Type

ZFIAP_C6T Time

ZFIAP_C6P Data Package

ZFIAP_C6U Unit





29/37


4.7 Query Preview

4.8 Other Queries



30/37


5.1 Technical Overview for General Ledger Accounting

InfoProvider

Technical Name


ZFIGL_C6 General Ledger: TransactionFigures

General LedgerAccounting


ZFIGL General Ledger Accounting

5.2 Data Flows



31/37




InfoCube Objects


Business area 0BUS_AREA



Company for Company Code 0COMP_CODE__0COMPANY X


Debit/Credit Indicator 0FI_DBCRIND


Indicator: Balance Sheet Account 0GL_ACCOUNT__0BAL_FLAG X

Indicator: Balance Sheet Account 0GL_ACCOUNT__0INCST_FLAG X

Planning Item from Account 0GL_ACCOUNT__0SEM_POSIT X

Value Type for Reporting 0VTYPE

Version 0VERSION

5.3.2 Key figures

Key figures Cumulative Balance 0BALANCE

Total credit postings 0CREDIT

Total Debit Postings 0DEBIT




32/37






5.3.4 Units


5.4 Dimensions


ZFIGL_C61 OrganizationalUnits

ZFIGL_C62 Accounts

ZFIGL_C63 Types andVersions

ZFIAA_C2T Time


ZFIAA_C2U Unit



33/37




5.7 Query Preview

5.8 Other Queries



34/37


6.1 Technical Overview for AR Payment History

InfoProvider

Technical Name


ZFIAR_C5 FIAR: Payment History Accounts ReceivableAccounting


ZFIAR Accounts Receivable Accounting

6.2 Data Flows



35/37




InfoCube Objects


Business Partner 0DEBITOR__0BPARTNER X


Country key to the debitor 0DEBITOR__0COUNTRY X


Customer number 0DEBITOR

6.3.2 Key figures

Key figures FI-AR: Average Arrears for Paymentwith Cash Discount 0DELAY_1

FI-AR: Number of Incoming

Payments in the Period 0NUM_PAYMNT

FI-AR: Payment Volume with CashDiscount 0PAYMNT_1






6.3.4 Units




36/37


6.4 Dimensions


ZFIAR_C51 Customer

ZFIAR_C52 Company Code

ZFIAR_C53 Currency Type

ZFIAA_C2T Time


ZFIAA_C2U Unit





37/37


6.7 Query Preview

6.8 Other Queries

tech info fi

Documents