SAP for Media Discussions
Spark conversations about content creation, audience engagement, and monetization strategies using SAP in the media industry. Join in the discussion!
cancel
Showing results for 
Search instead for 
Did you mean: 

Total Order Price

former_member188001
Active Participant
0 Kudos

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

  • SAP Managed Tags:
1 ACCEPTED SOLUTION

former_member1052317
Participant
0 Kudos

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.

View solution in original post

  • SAP Managed Tags:
4 REPLIES 4

former_member1052317
Participant
0 Kudos

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.

  • SAP Managed Tags:

Former Member
0 Kudos

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

  • SAP Managed Tags:

0 Kudos

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.

  • SAP Managed Tags:

0 Kudos

question ansered. thanks for all the help.

  • SAP Managed Tags: