New GL General Ledger with FAGLFLEXT
in the mysap erp new general ledger aggregate table FAGLFLEXT the key consistes of financial year together with 9 integer fields (OBJNR00 - OBJNR09).
Please give me an idea of where, how and why this key is built. I thought of some kind of hash key constructed from (what) characteristic fields.
The issue is that due to a wrong mapping table one customer-specific extension field carries wrong values (missing leading zeroes). We want to judge the consequences of a hard table update replacing the values with their correct internal representation.
And please don't tell me what I know: Never do any hard table update!
Christopher Laine replied
Look at the other FLEX tables on your system.
Tables FAGLFLEX00 - FAGLFLEX08
The key combinations of these tables create new OBJNR## entries.
For example: Look at the FLEXT table and record a value for one of the OBJNRs. For this case choose a value for field OBJNR01. Query table FAGLFLEX01, enter the number you recorded for OBJNR01 and you'll see that the results returned are the values you'd see in a line of FLEXT that has the OBJNR01 value you recorded.
That will at least give you the structure of these tables, you should be able to figure out from here if you want to do the hard update or not.