FI Data for Spend Analysis in SRM 

Technical Name: 0SR_FIDS1

Use

The ODS Object saves invoices, credit memos, and their cancellation documents from SAP Financial Accounting with a high level of detail. Gross and net amounts are saved separately.

There is one line for each currency type (transaction currency, company code currency, and group currency).

The vendor line contains the gross spend amount, the offsetting posting lines contain the net amounts.

The values in the vendor line may not be added to those of the offsetting posting lines, otherwise the spend volume would be counted twice.

Consolidated InfoObjects (0GN_VENDOR, 0GN_BUY_COM, 0MATERIAL, 0MATL_GROUP) are available for the creditor (vendor), the purchasing company, the material and the materials group.

G/L accounts (0GL_ACCOUNT) are linked with a chart of accounts (0CHRT_ACCTS).

Services are not shown separately, they are entered in the G/L accounts.

The characteristic 0DOC_NUM in the data fields of the ODS Object refers to the purchase order and serves to determine the indicator with or without purchase order reference.

0FISCPER, 0FISCVARNT, 0DOC_DATE and 0PSTNG_DATE are relevant for the selection of a timeframe.

The following characteristics are available for organizational units: 0CO_ARE, 0COSTCENTER, 0PROFIT_CTR, 0COORDER; 0WBS_ELEMT, 0PLANT, 0BUS_AREA, 0FUNC_AREA.

Master data is read when the data is updated to the ODS object. Ensure that the master data has already been loaded.

Note especially that the consolidated purchasing category 0GN_CAT_PUR and the contract (0BBP_CTC_ID, 0BBP_CTITEM) are read from the ODS Object 0BBP_INV. For this, the invoices must first have been loaded from SRM or from R/3 MM.

 

 

Key Fields

Key Field	Description
0SR_GSFISYS	FI Source System (Logsys)
0COMP_CODE	Company code
0AC_DOC_NO	Accounting document number
0AC_DOCLN	Document line
0CURTYPE	Currency type