topic Re: Extracting material classification data for given sales order in Application Development and Automation Discussions

Extracting material classification data for given sales order

Former Member — Fri, 14 Oct 2011 07:06:37 GMT

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

Re: Extracting material classification data for given sales order

kesavadas_thekkillath — Fri, 14 Oct 2011 07:56:59 GMT

Please donot dump your sepecifcation here. Search before posting

sale order has material and the material has it classifications.

Re: Extracting material classification data for given sales order

Former Member — Fri, 14 Oct 2011 08:40:55 GMT

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.

Re: Extracting material classification data for given sales order

Former Member — Fri, 14 Oct 2011 08:42:38 GMT


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.

Re: Extracting material classification data for given sales order

Former Member — Fri, 14 Oct 2011 09:05:51 GMT

I found the required tables. thanks a lot.

Thanks

Pavee