Difference between RECN and RECNROOT

[Former Member]

Hi,

I found two fields in many EST* tables named RECN and RECNROOT. I found that both fields has same entries. Could any one tell me the need of this fields in detail.

Regards,

Vignesh

[Former Member · Accepted solution]

Hi Vignesh,

This is rather easy. RECNROOT always refers to the RECN field of the uppermost table.

Two examples:

* ESTRH - ESTVH - ESTVA

ESTRH-RECN = ESTRH-RECNROOT

ESTVH-RECNROOT = ESTRH-RECN

ESTVA-RECNROOT = ESTRH-RECN

ESTVA-RECNTVH = ESTVH-RECN

Same logic goes further for tables ESTVP, ESTDU, .... which are all linked to table ESTVP

ESTVP-RECNROOT = ESTRH-RECN

ESTVP-RECNTVA     = ESTVA-RECN

ESTVP-RECNCOMP = estrh-recn of ingredient

ESTDU-RECNROOT = ESTRH-RECN

ESTDU-RECNMST    = ESTVA-RECN (in case you check the usage of a value assignment instance)

* ESTPH - ESTPP

ESTPH-RECN = ESTPH-RECNROOT

ESTPP-RECNROOT = ESTPH-RECN

... and so on.

I hope this helps you further in discovering the EHS tables.

Kind regards,

Luk