I am trying to create a class which which will read a ztable (holds pricing tables) cosidering it a list or off list price. this table has the follwoing fields mandt,kappl,kschl,kotabnr and a custom field zprice_type which is numeric and of lenght 2. This custom field is for the price type flag which will be either 0, 1 or 2 (not applicable, list, off list).
This class will determine if condition is active or inactive. Only goes forward with active conditions.
For each item , reads KONV with the condition type , doccond and item number. determine if condition is active (konv-kinak). If active , get the access # (konv-kolnr) .
read table T685 with application = V, condition type from KONV(eg. ZPRL) to get the access sequence name(T685-kozgf). This can ve the same or different from the condition type.
Then Read Table T682I with Application = V, Access Sequence = T685_KOZGF and Access # (KONV-KOLNR) to return the Table # (T682I-KOTABNR). For example, 901.
Read the Z* table with Condition Type from KONV and Table # from T682I to determine if the table is 1 (List) or 2 (Off List). Set flag accordingly.
Loop through the same logic for all conditions for the same item to determine the List or Off List setting of each.
At end of loop, if any of the active records = 2 (Off List), the item is considered Off List. Else List.
I need to build a class out of it if someone can please help me out with this . This class I will be using in my report to cerate a pricing compare list.
Thanks
Aarav