cancel
Showing results for 
Search instead for 
Did you mean: 

Header Condtion Records-Transactional Table Details

safeer_rahman2
Contributor
0 Kudos

Hi Folks,

My client is having a requirement to generate a report which fetches the condition value details like (freight, Tax etc) against a particular sales orders.

We have noted certain cases where the condition records at the header level can be manually entered by the user at the time of creating the sales order. My question is that where exactly is the transactional data pertaining to the condition records in a sales order are stored?

How can I advice my technical guy to fetch the above mentioned data? Can you advice please

Thanks,

Safeer Rahman

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Safeer Rahman,

According to your requirement please find the below solution.

First take the sales order number(VBELN), go to VBAK fetch the document condition (KNUMV) and go to KONV give the document condition and execute.

You can find the condition value (KWERT_K) which condition origin (KHERK) is D.

Just now i have tried in my system .

Hope it fix your issue, please let me know the status.

Thanks&Regards

Raghu.k

safeer_rahman2
Contributor
0 Kudos

Yes Raghu... You are right... Thanks for your help.

Cheers,

Safeer Rahman

Former Member
0 Kudos

Was it anything diff than what I suggested earlier?

Regards,

Raghu.

Answers (2)

Answers (2)

safeer_rahman2
Contributor
0 Kudos

KONV table possibly won't help me here as it doesn't hold the data which i am looking for. Am I right?

Thanks,

Safeer Rahman

Former Member
0 Kudos

KONV is the table.. pls create a sales doc and check in KONV..if it doesn't have the data..let us know.

Regards,

Raghu.

safeer_rahman2
Contributor
0 Kudos

Hi Raghu,

Let's take an example where the freight values are entered manually at the time of creation of sales order and not through the condition records.

Can you please point out where the values(which we entered during the creation of sales order) would be stored...?

Thanks,

Safeer Rahman

Former Member
0 Kudos

Hi this has been discussed many times..pls search the forum.

Regards,

Raghu.

safeer_rahman2
Contributor
0 Kudos

Thanks Raghu...

Can you please provide the links to those threads if you could find out...

Please note that KONV table holds only the condition record values.I want to know where the value which we would enter during the creation of sales order would be saved...

Pointers would be very much appreciated.

Thanks,

Safeer Rahman

Former Member
0 Kudos

Hi Safeer, I've checked myself in my system..I've entered manually while creating a sales order and system does store in KONV

Regards,

Raghu.

safeer_rahman2
Contributor
0 Kudos

Hi Raghu

Thanks for your efforts...

Let me check in my system and would revert back...

Meanwhile... If anyone could point out other possibility .... It's very much appreciated...

Thanks again,

Safeer Rahman