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

HI All

Former Member

‎2007 Mar 09 6:31 AM

0 Likes
298

Hi All,

can any body tell me from which tables we will get below fields

• Created a report by selecting a range of vendors as input, purchase order number should displayed on basic list, further by selecting one purchase number details will be displayed on second list.

• Created a Hierarchal sequential list using ALV that displays Purchase document header and item details.

• Created a report using ALV to display customer, material and sales doc details in individual lists. This report lists items like customer number, material number, and sales doc no, created by and created on etc.

• Created report in material master that outputs material valuated stock grouped by material type and plant.

• Created a report for particular vendor to get the purchase order details and goods received for specific purchase order and balance quantity.

• Created reports that display month wise sales details by comparing with previous month and yearly sales details with selection criteria based on date.

Regards,

gautami

Hi All,

can any body tell me from which tables we will get below fields

• Created a report by selecting a range of vendors as input, purchase order number should displayed on basic list, further by selecting one purchase number details will be displayed on second list.

• Created a Hierarchal sequential list using ALV that displays Purchase document header and item details.

• Created a report using ALV to display customer, material and sales doc details in individual lists. This report lists items like customer number, material number, and sales doc no, created by and created on etc.

• Created report in material master that outputs material valuated stock grouped by material type and plant.

• Created a report for particular vendor to get the purchase order details and goods received for specific purchase order and balance quantity.

• Created reports that display month wise sales details by comparing with previous month and yearly sales details with selection criteria based on date.

Regards,

gautami

Reply
1 REPLY 1
Read only

Former Member

‎2007 Mar 09 6:37 AM

0 Likes
273

Hi,

• Created a report by selecting a range of vendors as input, purchase order number should displayed on basic list, further by selecting one purchase number details will be displayed on second list.

<b>Data from EKKO as Basic List with the help of LIFNR field which is on selection screen. Data from EKPO table will be displayed as seconday list</b>•

Created a Hierarchal sequential list using ALV that displays Purchase document header and item details.

<b>Data from EKKO and EKPO tables is used.</b>•

Created a report using ALV to display customer, material and sales doc details in individual lists. This report lists items like customer number, material number, and sales doc no, created by and created on etc.

<b>Uses KNA1, VBAK and VBAP tables</b>

• Created report in material master that outputs material valuated stock grouped by material type and plant.

<b>Uses MARA and MARD tables</b>

• Created a report for particular vendor to get the purchase order details and goods received for specific purchase order and balance quantity.

<b>Uses MKPF and MSEG tables</b>

• Created reports that display month wise sales details by comparing with previous month and yearly sales details with selection criteria based on date.

<b>Uses sales Tables VBAK, VBAP and VBEP</b>

Reward if useful.

Regards,

Anji