on 12-11-2014 3:36 PM
Hi gurus,
I have a situation where I am supposed to identify the routing characteristics which are basically displayed in CA03.
I am supposed to do that by:
so far so good. The issue rises in step 4:
Can someone assist with explaining the logic of counters in table PLMK and whether there is another table where by counter, PLNNR, Node and characteristic one could fine whether this particular characteristic is blocked? I was looking for a relationship similar to the one with table PLKO and PLAS unfortunately I couldn't find one.
Thank you in advance,
Raly
Hi Ralista,
Attempting to explain you the logic I can think of starting form Material master check.
1) Table - MAPL ==> Input MATNR, WERKS, PLNTY ("Q") ==> PLNNR (inspection Plan), PLNAL (GrC)
2) For every unique MAPL-PLNNR & MAPL-PLNAL combination get the below details -
ZKRIZ = Additional Critical Counter ==> Collect all these values
a) If only one record exist for MAPL-ZKRIZ, then consider the single result for ZAEHL.
* MAPL-PLNNR + PLNAL + ZKRIZ + ZAEHL => Check if LOKEZ = "X" [YES] or "BLANK" [NO]
YES => Means, this record is deleted and hence no active MIC calculation can happen for this record.
NO => This is a valid record, against which the MIC calculation can happen.
b) If for the same MAPL-PLNNR + PLNAL + ZKRIZ combination, there are more than one similar records for ZKRIZ, then check the latest value for LOKEZ and check if this is "X" [YES] or "BLANK" [NO]. Follow the above logic.
c) If more than one non-similar records available for ZKRIZ for the same MAPL-PLNNR + PLNAL, the check the latest value for ZKRIZ mapped with latest value of LOKEZ = "X" [YES], or "Blank" [NO]. Follow the above logic.
From the above three searches, you will be able to get all the active inspection plans and group counters, against which you need to check the MIC assignment via tables PLKO => PLAS => PLPO => QPMK.
3. PLKO ==> PLNNR (MAPL-PLNNR), PLNTY = "Q", PLNAL (MAPL-PLNAL) ==> ZAEHL.
4. PLAS ==> Consider the influence of sequence PLNFL. We need to consider the order in the below format -
PLNNR + PLNAL + PLNFL (consider the highest value like 0, 1..) + ZAEHL ==> PLNKN (node#). Check if LOEKZ = "BLANK". means non-deleted.
Note: Normally it's "0" in my data so I take this as the final record during calculation.
5. Pass this value for node form PLAS through PLPO, to check if LOEKZ = BLANK. Means MIC assignment was deleted or not. Get the operation number VORNR, which is active.
6. Now in PLMK, provide PLNTY = "Q", PLNNR = the active record which is not deleted in above checks, PLNKN = received form PLAS, MERKNR = received form VORNR, get the non-deleted records for LOKEZ = "BLANK".
=> In the output, you will get VERWMERKM = MIC available in the operation, which is non-deleted.
NOTE: Please remember not to delete the LOKEZ = "X" records before the comparison so that you can find the latest value for Counter, crit. counter. Only after that you can remove the deleted records for subsequent calculations.
Hope this gives you a boarder picture on the relationship to find out the correct NODE against which your check will be performed.
Please double check the above explained logic and feedback.
Thanks,
Arijit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Great one neatly explained helped a lot... Thanks..
Hi Ralista,
Please confirm if you got the answer you are looking for.
Thanks,
Arijit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi - try to use function CP_EX_PLAN_READ instead, if possible.
Regards,
John
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John,
Thank you for your answer.
The idea is not only to read using the function but to be able to identify by some combination of fields whether this particular line from PLMK should be displayed or not. I understand that the counter have a logic and this is unclear at this point.
Could you help out with this?
Hi, I also had faced the similar issue in the past where I had to correlate group counters within tables POKO, PLPO and PLMK to fetch some information. Later I could fix this up using function module CP_EX_PLAN_READ!
What conditional filters you want to apply on data from PLMK table? I believe the similar data is reflected in PLMK_EXP table of this FM as that in PLMK table. You mentioned about characteristic blocking. Is is so that, you have maintained 5 MICs in certain operation and want to print only 4 out of them?
Anand
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.