ZCharacterisitic - not populating values
Dear Eugene / Dan,
Pls refer to my earlier thread -
I gave the requirement as follows to my BI resource:
During the data load - if the 0GL_ACCOUNT is a reconciliation account (i.e. has the 0ACCT_TYPE as K) the relevant vendor numbers must me populated in the Z characteristic from the ODS 0FIAP_O03.
It was found later, after the initial test load that the logic does not work. It is only picking one vendor record for the reconciliation account.
I understood later from the BI developer that there needs to be an unique set of data for retrieval purpose.
Just giving the above logic of account type for a GL account - does not work to retrieve multiple vendor numbers for a reconciliation GL account.
Do you have any ideas on how to achieve this extraction of vendor numbers for a reconciliation GL during the data load?