08-26-2008 7:29 PM
Hello all,
Which table stores the total order header price.
My order has 3 line items each with price $50. The total order price will be $150. I want to know which table stores $150 together for the order, not item wise.
Regards,
Salil
08-28-2008 11:44 AM
I believe the fields PREIS_AVM1 or PREIS_AVM2 (depends on your customization) stores the total value of all the items in the order at the header level.
Only table JHAGA holds these fields and this table is the item level table. Correct me if i am wrong.
But you can get these values in this structure "RJHAK".
I know this is not a helpful answer but still I'm putting this down.
08-28-2008 11:44 AM
I believe the fields PREIS_AVM1 or PREIS_AVM2 (depends on your customization) stores the total value of all the items in the order at the header level.
Only table JHAGA holds these fields and this table is the item level table. Correct me if i am wrong.
But you can get these values in this structure "RJHAK".
I know this is not a helpful answer but still I'm putting this down.
09-01-2008 3:46 PM
Hi,
Answer for your question is JHAGA - IS-M/AM: Order-Publishing-Media Billing
For your information:
Go to transaction SE16.
Enter the table name as JHAGA - IS-M/AM: Order-Publishing-Media Billing
Execute the transaction.
Click on "Settings" Select "Fields For Selection"
Activate the check box for the fieldname PREIS_AVM2( Price 2)
Enter the netvalue of the Order in this field PREIS_AVM2
Execute the transaction.
Then you get better clarity.
Best Regards,
Chandramohan
09-02-2008 6:13 AM
Here, the requirement is at the header level but not at the billing dataset level. Table JHAGA has only the billing dataset values of
PREIS_AVM1 and PREIS_AVM2 and not the values at the order header level.
12-11-2008 10:38 PM