Operation TABLE in SAP Schema
I am using operation "TABLE" to query table 167. i have written a rule to query medical plan after function P0167. if have only one entry in table p0167(Only Medical), then my rule is working as required. if i have multiple entries (Medical, dental, vision coz IT0167 stores all the health plan), my rule fails because system has more than one entry in table P0167.
System always takes the last value (Vision plan) in Table P0167 and goes into the rule. sinces the last entry is not a medical plan, system comes out my rule.
Is there a way that i can have a pointer in schema which says upon finishing one record, query the second record in the same table. if so what operation is it and how to write a PCR?
Need your input.