Regarding Pricing conditions Query
I am planning to extract the table wise information on the exiting pricing condtions available in the production environment.
Below is the plan
obtain the latest condition record number(valid as on date) from A*** ( access sequence tables for prices) with appropriate condition types.
pass these condition record numbers to KONP table & fetch the conditional value along with the currency.
the problem i now have is that am not able to do a table join for the tables A**, Table A** cannot be used in a Join.
what are the alternates available, Note i cant have SE16N or SE16 authorization in production environment & i prefer to have a query or using SQVi