Treasury Datasources and R/3 tables

[Former Member]

Hi all,

Does any one knows how can I get the correspondent R/3 tables for the following Treasury Datasources:

0CFM_INIT_POSITIONS

0CFM_DELTA_POSITIONS

0CFM_MARKET_VALUES

0CML_CASHFLOW

0CML_DELTA

0CML_DELTA_CAP

0CML_INIT_BUDAT

0CML_INIT_DDISPO

0CML_INIT_DFAELL

0TR_LP_1

0TR_CM_1

Thanks in Advance,

ET

[former_member184878]

Hello,

Use transaction: FTR_SHOW

System shows tables per business.

double click on table name and details will be shown.

hope it helps.

br erwin

[Former Member]

Hi ET,

I got an requirement to report treasary with BW but in my R/3 system (ECC 6.0), i could not find the above datasources (in RSA5).

is there any setting needs to done or any SAP Notes need to apply, please guide.

regards,

[Former Member]

Hi,

You can find some tables belolw related to Treasury module.

VWPANLA

VTBFHA

ATRAS

TRDT_FLOW

VTBFHAPO

VTBFHAZU

VTBFINKO

VTIDERI

VTIFHA

VTIFHAPO

VTIFHAZU

VTIOF

VTBFHAPO_UNFIXED

VTBAFINKO

VTBKORES

VTIFHAZU

VTIFINKO

VTIAFINKO

TRIAT

REFON

TRDT_TRDBUSTRANS

TRDT_FLOW

FDT1

Regards,

Muthu.

[Former Member]

for 0TRCM_C01:

The key figure Planned amount in planned currency is read from table FDSB or table FDSR.

The amount is read from table FDSB in the case of G/L accounts (bank accounts, and so on).

It is read from table FDSR in the case of subledger accounts (customer accounts/vendor accounts)

[Former Member]

refer this blog: /people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins

it shows how to identify tables for a datasource

[Former Member]

Hi Eduardo,

You can go to help.sap.com --> choose SAP Netweaver --> choose BI Content --> choose the last content and search for the extractor you want. Then you will be able to identify the source tables.

For example:

0CML_DELTA_CAP comes from function module and VDARL.

0CML_INIT_DDISPO comes from numerous function modules.

Hope this help.

Regards,

Modro