on 10-28-2009 7:21 AM
Hi SAP Experts,
I want to list down all the Conditions types,their values,the effective date ranges for all materials.
I checked the table A801 ,it gives these information but does not have the VALUES for the Condition Types.
Can you please tell which is the Table that has the condition values also for all materials..
Apprieciating your quick reply.
Thanks and Regards,
Umesh Karane.
The Solutions given served the purpose
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As an alternative to your question, you can use "Condition Information" Button option in the VK11, VK12 & VK13 transactions.
But there you cannot see the value in the same screen. You have to double click and go in to see the value.
To give the exact solution, you have to create a Pricing report in SAP for your condition tables.
Follow these steps to create a Pricing report.
To create the Pricing Report
Tx: V/LA
u2022 Enter Name for the List (Starting from a letter) & a Title
u2022 Press "Forward Foot Print"
u2022 In the new screen you have to select all key fields that should be taken into consideration in the pricing report.
u2022 Highlight all relevant fields
u2022 Press AND or OR appropriately
If you select OR ; all condition tables are evaluated, that contain at least one of the selected key fields.
If you select AND; all condition tables are evaluated, that contain all selected key fields.
u2022 Now youu2019ll be directed to condition table list that are to be evaluated. Highlight relevant condition tables.
u2022 Select "Forward Foot Print" to define the screen structure for the pricing report.
u2022 You can configure the report layout here.
u2022 Once everything is done, save the report.
To run a pricing report
Transaction: V/LD
u2022 Enter pricing report number
u2022 Press EXECUTE
u2022 Execute it by giving relevant data.
You can get all values in one screen.
Best regards,
Anupa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Umesh,
To see the values for the condition type in the table,
a)you have to see what is the access sequence is maintained.
b) In that access sequence check the condition table which is given in the access.
The condition record has to be maintained for the access which is checked.
Assuming there are 2 access, in one you have maintained condition table 004 and in the other it is 801 and user has maintianed the condition record pertaining to the access(004) the search in the table A004 if it is 801 then check in A801.
Hence suffix A in the condition table for the values to be checked in the condition record.
Hope this answers your query.
Regards,
Nithin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you tried with Tcode:V/LD- Executing Pricing report.
Select the report as required from the list. & key in required fields on what base you want to extract the conditoin records.
If the std reports will not serve the purpose. You can create your own Pricing report to fetch the values.
( Search in forum reg: How to create New Pricing report _ V/LA, Many threads available for the same)
Hope it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
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.