02-15-2012 5:26 PM
If I know a line item type name how can i find how many Rate Categories currently receive this line item type?
02-15-2012 8:34 PM
Hi,
Other than writing a BI or other custom report, you could do it in multiple steps:
Run report REAVAR01 for the Line Item Type in question (as the only parameter)
This will list the Variant Program/s that use the line item type.
Then for each Variant you can do a "Where used" to see which Rates the Variant (hence the line item type) is used in.
I hope it helps.
Regards,
Ivor M.
02-15-2012 8:50 PM
--"Run report REAVAR01 for the Line Item Type in question (as the only parameter)"
How to set the line item type as the only parameter when run REAVAR01? Thanks.
02-15-2012 9:07 PM
Hi,
The field name is "Type of Document Line Item".
It should be the last field on the parameter screen.
Regards,
Ivor M.
02-15-2012 9:51 PM
02-15-2012 11:51 PM
Hi,
If you leave the Variant program parameter blank it lists all the variant programs that relate to the Line Item Type.
Then do a Where Used for each of the Variants that are listed.
Regards,
Ivor M
02-16-2012 9:30 AM
Hi,
you can try to build simple query in (SQVI) with following tables:
ETRFV - rate steps with LINE ITEM TYPE
ERTFND - rate determination with rate types and RATE CATEGORIES
Best regards
Vlado