Current date in the query
I want to display current date in the query in one of the time characterstic which i am including in the data target but i don't want to load anything in the data target but still i want to display the current date in the query only.
how can i achieve this.
thanks and regards
joe _bi replied
1. Techical name for IO is ok.
2. I supposed ZCPR_START is a characteristic.
If it is a key figure replace
L_S_CHANM-CHANM = 'YOURIO'.
L_S_CHANM-MODE = RRKE_C_MODE-NO_SELECTION.
APPEND L_S_CHANM TO E_T_CHANM
append 'ZCPR_START' to e_t_kyfnm.
3. check update rules :
ZCPR_START should be mapped to initial value.
4. make sure that all relevant compnents are activated
If you run the query with virtual character/key figure, is there any error message?
Try to add another character to the query and run it..
Hope this helps