therese
17th November 2003, 04:57
Is the integration reference table (tfgld418) has the same data with tfgld410 (integration transactions)?

Thanks.

nanuco
17th November 2003, 16:42
the tfgld418 is the table where the origin and the destiny data of the transaction stays recorded.
For example wich purchase order, purchase order line, wich transaction and document in Finance, wich user, etc. there is no information about value.
The tfgld410 is the table where is stored the debit lines of the finance integration, with value, dimension, ledger account, etc...

Moshe Almog
17th November 2003, 16:55
Hi,

For every 410 record there is a paralel 418 record.
They also have the same key.

Tfgld418 has 2 more keys that enable us to look at the integration transaction from 2 extra views:
1. From project/order/order line.
2. Fron the financial transaction in finance.

They also enable us to make efficient views and table joins.


Moshe

therese
18th November 2003, 04:19
Thanks guys.:D