Skip to end of metadata
Go to start of metadata

Display the top 10 customers for a material for a given period

Solution: Tables used: VBAK, VBAP, LIPS, KNA1, VBRP
 
KUNNR - VBAK

VBELN - VBAK

NETWR - VBAP

LFIMG - LIPS

NETPR - VBAP

MATNR - VBAP

NAME1 - KNA1

NETWR - VBRP
 
Selection options were:

VBAK - ERDAT

VBAK - VKORG

VBAK - VTWEG

VBAK - SPART

VBAP - MATNR
 
Get order price of item (NETWR, NETPR) from VBAP, delivery price from LIPS (LFIMG), invoice price of item from VBRP (NETWR).

Created the program in se38 (ABAP editor) and execute it.
 
The report showed the following columns:

Customer name, Customer no, Material no, Order price, Delivery price, Invoice price

  • No labels