Question:
Hi
I´m trying to create two process chains. One would update the PSA tables extraction data from OLTP (all Infopackages with processing "only to PSA"). The other would update from the PSA to the Data Targets - in the example Infoobjects - texts and attributes.
First one works correctly.
The second one doesn´t work at all. The process that is being used is PSAPROCESS.In the process varaible I just specify the PSA table to be used; when required I also specify the target (when several are available, which is the only case in whcih you can specify it). The job log is always the same: "No request for posting found in the variant. Variant does not contain a valid combination request/data target".
Has anyone ever tried to do such a process? Which should be the approach to schedule periodic jobs from the PSA onwards without having to specify each time which request should be updated?
How can I specify the data target as well as the PSA table in the process variant for Infoobjects loaded from non flexible infosources, text loads,...the ones which the data target information is not contained in the infopackage?
any help appreciated
thanks
sebastian
Answer:
Hello Sebastian,
I am grappling with EXACTLY the same issue at this very moment (Hv been for the last week, & with SAP's blessings, will probably do so for another )
What I've discerned is this ...
The ProcessType PSAPROCESS ALWAYS gathers the value of the Request ID ONLY from the LOADING ProcessType before it ;(.
If you still want to over-ride the default (& in this case, incorrect) selection of the RNR, you may want to:
1. Copy FMOD RSSM_PROCESS_PREPARE_EXECUTE under FUGR RSSM_PROCESS into your own FMOD/ FUGR, say ZRSSM_PROCESS_PREPARE_EXECUTE under FUGR ZRSSM_PROCESS
2. Create your own ProcessType with ZCL_RSSM_PSAPROCESS that you can attach to a new ProcessType, say ZPSA_PRCSS
3. Under method IF_RSPC_EXECUTE~EXECUTE, call FMOD ZRSSM_PROCESS_PREPARE_EXECUTE from above (1)
4. In this FMOD, make changes to how RNR is selected from RSSELDONE ... for instance,
SELECT * FROM RSSELDONE INTO CORRESPONDING FIELDS OF TABLE I_TAB WHERE VARIANT_ID = (INFOPKG NAME) AND RSSELDONE-ZIEL = 1.
ENDSELECT.
SORT I_TAB DESCENDING SELDATE, SELTIME.
LOOP AT I_TAB WHERE SY-TABIX = 1.
ENDLOOP.
This code may not be syntactically apt, but the idea is to pick the latest successful request that goes ONLY into the PSA (fld ZIEL) and to then use that request in the PSAPROCESS.
Pls let me know if you've had any success , and what & how u achieved ...
Cheers & best rgds
/am
_________________
Certified SAP-BW 30B Analyst