on 02-11-2008 4:42 PM
How to take a report of the data for the Sales Order Change history for a particular period of time. It is required to take a report of all the Sales Orders for which the basic price has been changed. Please let me know the procedure. I could not get the data from the table CDPOS and CDHDR
Helpful answer would be rewarded.
Regards
Praveen
Dear Praveen Kumar
Have you tried with VBAP where sale order details at item level would be stored.
Moreover, to my knowledge, there won't be any changes as for as pricing is concerned at sale order level but there is at billing level. Normally, any price increase / decrease would reflect in billing. So why dont you to table join through SQVI VBAP (for sale order details) and VBRP (for billing details) so that you can compare the selling price in sale order with billing.
Thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
there is no standard rep to check it.
ask abapers to write z-rep.
you can use CDHDR,CDPOS for the manual checking
just use CDHDR-OBJECTID is your sales order number (concatenate with 00)
the same for CDPOS-OBJECTID
you can try to check it by list
example for CDHDR:
select-options
T-CODE = VA02
U-DATE = 01.01.08-01.02.08
CHANGE IND = U
USERNAME = .....
and for CDPOS you can specify the level
example:
TABNAME = KONVC (to catch your price changing)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.