on 09-27-2010 9:28 AM
Hello all,
we provide the sales price to customers based on the condition value in "VPRS" ,because I have thousands of goods need the price,so I 'd like to make a query to extract the condition value in "VPRS".
which table is refer to this?
Thanks,
helai
Hi
I might be wrong to understand your querry but if you are loking for the VPRS value for Perticuler line item in sales order then, select VBAK - Doc. Condition
Pass this Doc. Consition to KONV table
Select condition type as VPRS
Here you can get the Value / amount for the line item
If this dosn't solve your problem then kindle explain your requirment more clearly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
this condition value is not linked with any particular sales order in history ,even it just only has the condition value in SAP,later I will create a sales order for this good by adopting this condition value multiply the factor( like 2).
so this good no. never occurred in any sales order before.
BTW
the table "KONV' is also not allowed used for a joint query as prompted on screen."Table KONV cannot be used in a join"
so how to make a query with art.no. and plant input and get condition value out
Thanks,
Helai
hi,
For your Item category, if you check DETERMINE COST
Determine cost
Indicates whether, during pricing, the system determines the cost (stock value) of a sales document item.
Use
The system checks the cost determination indicator as a requirement before applying the condition type that calculates the cost (condition type VPRS in the standard version of R/3 1.1)
Mainatin VPRS as D then it will automatically pull the price from Material master if maintained
IF VPRS is getting determined, then in your pricing procedure, you can add markup (multiplier)
First: Get Order information
SELECT VBAK~vbeln
vbap~posnr
vbak~knumv
vbak~auart
INTO CORRESPONDING FIELDS OF wa_sum
FROM vbak
INNER JOIN vbap
ON vbakmandt = vbapmandt AND vbakvbeln = vbapvbeln
WHERE .
Second : Get VPRS
REFRESH lt_konv.
SELECT kschl kwert kinak INTO TABLE lt_konv
FROM konv
WHERE knumv = wa_sum-knumv AND kposn = wa_sum-posnr
AND kschl = 'VPRS'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.