Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Extracting material classification data for given sales order

Former Member

‎2011 Oct 14 8:06 AM

0 Likes
942

Hi Experts,

Requirement is I Need to display a report with material and its characteristics values for given sales order. Please let me know if there is any FM/standard tables involved to display the below fields.

Sales order number, Sales order line item number , Material number , Characteristic Name(ATNAM),Characteristic description(ATBEZ),Characteristic Value(ATWRT),Characteristic value description(ATWTB).

Thanks & Regards,

Pavee.

Moderator message: "spec dumping", please work yourself first on your requirement.

Edited by: Thomas Zloch on Oct 14, 2011 1:30 PM

Hi Experts,

Requirement is I Need to display a report with material and its characteristics values for given sales order. Please let me know if there is any FM/standard tables involved to display the below fields.

Sales order number, Sales order line item number , Material number , Characteristic Name(ATNAM),Characteristic description(ATBEZ),Characteristic Value(ATWRT),Characteristic value description(ATWTB).

Thanks & Regards,

Pavee.

Moderator message: "spec dumping", please work yourself first on your requirement.

Edited by: Thomas Zloch on Oct 14, 2011 1:30 PM

Reply
4 REPLIES 4
Read only

kesavadas_thekkillath
Active Contributor

‎2011 Oct 14 8:56 AM

0 Likes
766

Please donot dump your sepecifcation here. Search before posting

sale order has material and the material has it classifications.

Read only

Former Member
In response to kesavadas_thekkillath

‎2011 Oct 14 9:40 AM

0 Likes
766

Hi Keshav,

Thanks for spending your precious time in replying to my thread.

I did a search before posting, I got an FM which is we cannot use due to performance issue.

Thanks for letting me know that sales order has material and material has characteristics,

But For each characteristics that material has we will have several values, you will be selecting whichever is appropriate based on the requirement.

If you know the answer pleases post. I have enough patience to wait for answers from other experts.

Thanks

Pavee.

Read only

Former Member

‎2011 Oct 14 9:42 AM

0 Likes
766 
Hi Experts,
> 
> Requirement is I Need to display a report with material and its characteristics values for given sales order. Please let me know if there is any FM/standard tables involved to display the below fields.
> Sales order number, Sales order line item number , Material number , Characteristic Name(ATNAM),Characteristic description(ATBEZ),Characteristic Value(ATWRT),Characteristic value description(ATWTB).
> 
> Thanks & Regards,
> Pavee.

Yes there is.

Read only

Former Member
In response to Former Member

‎2011 Oct 14 10:05 AM

0 Likes
766

Hi

I found the required tables. thanks a lot.

Thanks

Pavee