10-22-2007 8:26 AM
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
10-22-2007 8:29 AM
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
10-22-2007 8:29 AM
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