Skip to Content
0
Former Member
Jan 30, 2007 at 07:01 PM

need your help

13 Views

HI ALL

CAN YOU GENARATED AN INTERACTIVE REPORT .

SELECTION CRITERIA:

DESCRIPTION [S] ELECT OPTION MANDATORY

PURCHASE S YES

ORDER

NUMBER

PURCHASING

ORGANIZATION S YES

PURCHASING

GROUP S NO

DISPLAY DATA

BASIC LIST SHOULD BELOW, WHICH IS AN EXAMPLE.

PUR.ORG PUR.GROUP TOTAL NET PRICE.

SECONDARY LIST:

WHEN DOUBLE CLICKED ON A PARTICULAR LINE ON THE LIST,

A SECONDARY LIST SHOULD BE DISPLAYED CONTAINING THE

FIELDS, PURCHASING GROUP NAD PURCHASING ORGANIZATION WISE.

1. P.O.NUMBER

2. ITEM NO.

3. MATERIAL NO.

4. MATERIAL DESCRIPTION.

5. ORDER QTY.

6. NET PRICE.

THE SECONDARY LIST SHOULD BE AS FOLLOWS (EXAMPLE):

P.O NUMBER. ITEM NO. MAT.NO. MATERIAL DES. ORDER QTY.

NET PRICE.

I GOT THE FIELD NAMES AND TABLES

TABLE FIELD NAMES

PUR.ORG - EKKO- EKORG

PUR.GROUP - EKKO- EKGRP

TOTAL NET PRICE. - EKPO- NETWR

P.O NUMBER. - EKKO- EBELN

ITEM NO. - EKPO- EBELP

MAT.NO. - EKPO- MATNR

MATERIAL DES. - MAKT- MAKTX

ORDER QTY. - EKPO- MENGE

NET PRICE. - EKPO- NETPR

THANKS AND REGARD

KUMAR