Application Development 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: 

tables needed for report

Former Member

‎08-14-2006 11:28 PM

0 Kudos

Hi Experts,

I need to build a report for the following requirement.

Based on the input parameters: <b>MATERIAL NUMBER</b>,

<b>BATCH</b>.

I need to see in the output: <b>CUSTOMER SOLD-TO,

SHIP-TO,

QUANTITY,

INVOICE DATE,

PO,

ORDER NUMBER.</b>

Could you please let me know what are the tables i can used for this.

Thnx a ton.

1 REPLY 1

RichHeilman
Developer Advocate
Developer Advocate

‎08-14-2006 11:47 PM

0 Kudos

You can get material and batch from table MCH1.

Sales Document data comes from VBAK, and VBAP. You can get the ship-to partner from VBPA, and you can get the invoice date via document flow table VBFA, or VBUK, VBUP.

REgards,

Rich Heilman