Contract report query created but doesnt populate the data

[Former Member]

Hi,

i happen to create a Contract query for Business requirment ,The tables which i have joined are

EKKO -EKPO , EKPO_MARA , EKPO_MAKT

EKKO_LFA1

and done the selections like---

Fields for selection

EKKO-EKORG

EKKO-EKGRP

EKKO-LIFNR

EKKO-BSTYP

EKKO-EBELN

EKKO-LOEKZ

EKPO-LOEKZ

EKPO-MATKL

EKPO-MATNR

MARA-LVORM

MARA-BISMT

EKPO-IDNLF

EKPO-WERKS

MAKT-SPRAS

Fields to list

EKKO-EBELN

EKPO-LOEKZ

EKPO-EBELP

EKKO-EKGRP

EKKO-EKORG

EKKO-LIFNR

LFA1-NAME1

EKPO-MATNR

EKPO-TXZ01

EKPO-MATKL

EKPO-BPRME

EKPO-MEINS

EKPO-NETPR

EKPO-PEINH

MARA-LVORM

MARA-BISMT

MARA-MFRPN

MAKT-MAKTX

EKPO-WERKS

EKPO-IDNLF

Query has been created but when i input the data nothing is populated , am i missing something here ?

However i have tried for ME2n with contract as option but it misses some fields which could not be added in dynamiic selections so i could not have suggested ME2n to the Business

Please suggest if any one has worked on such scenrion earlier and had any idea to meet this Businesls requierment

Awarded suitable points for the correct answer

Thanks in advance

Adarsh

[Former Member]

Thanks and regards

[JL23]

joins are always created on table fields, and not just on tables.

What fields did you use for the join?

And instead of ME2N you should use ME3N

[Former Member]

Thanks for the updates ,we shall try with user requirment

Thanks once again .

[Former Member]

Thanks

Closed !!!

Thanks

Adarsh

[Former Member]

Closed