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: 

i want to search the table according to these requirement

Former Member

‎10-22-2007 8:26 AM

0 Kudos

1. Fields on selection screen (input screen) : Plant Code From to , Distributional Channel from to , Division from to , Customer Code from to , Period From to , Material Code (can be used using *) .

2. Field in the output List : Exc. Invoice No, Customer Code , Customer Name , Material Code , Material Description , Invoice Qty, Pack/Forward , Basic Price

2 REPLIES 2

Former Member

‎10-22-2007 8:29 AM

0 Kudos

USE THESE TABLES

VBRK ( vbeln -invoice number kunnr/kunag cUSTOMER CODE,werks - plant)

VBRP ( FKIMG-QTY, matnr -material, netwr -base price)

KNA1 (NAME1 for Customer NAME)LINK vbrk-kunnr/kunag = kna1-KUNNR

MAKT (maktx - material description)link vbrp-matnr = makt-matnr

Message was edited by:

Amit Singla

Message was edited by:

Amit Singla

Message was edited by:

Amit Singla

Former Member

‎10-22-2007 8:29 AM

0 Kudos

u can get the plant details from t001w table or the marc table, and for the customer code i think that u can find this in KNA1 table. rest i had not that much idea. if i found anything i will help you