topic REPORTS in Application Development and Automation Discussions

REPORTS

Former Member — Wed, 04 Jul 2007 13:16:40 GMT

I WANT TO DESIGN A SMARTFORM WHICH WILL DISPLAY PURCHASE REQUISITION NO WITH ITEM DETAILS AND CORRESPONDING VENDOR.

PURCHASE REQUISITION AND ITEM DETAILS CAN BE TAKEN FROM EBAN TABLE.

BUT THERE IS NO COMMON FIELD BETW\EEN LFA1 AND EBAN.

SO HOW CAN I PROCEED?

Former Member — Wed, 04 Jul 2007 13:18:49 GMT

the common field is lifnr.

check eban table with this field.

Former Member — Wed, 04 Jul 2007 13:27:12 GMT

HI,

lifnr is the comman field.

rgds,

bharat.

Former Member — Wed, 04 Jul 2007 13:27:27 GMT

You have LIFNR as common field. Check it.

Regards,

Pavan P.

former_member198270 — Wed, 04 Jul 2007 13:38:01 GMT

hi Vennila ,

the two tables can be linked by

Lfa1-Lifnr and Eban-Lifnr .

Account Number of Vendor or Creditor for LFA1 table and

Desired vendor for EBAN table .

Regards,

Amber S