topic Electronic Bank Statement in Application Development and Automation Discussions

Electronic Bank Statement

Former Member — Tue, 03 Jun 2008 07:09:59 GMT

hi friends,

i want to retrive the data for Electronic Bank Statement

so i found the tables

header tabel------- febko

items table -

febep

management records---- febvw

i want to join these tables to retrive the data

how can i join these tables ?

and what is the relation among the tables?

thanks & regards

srinivas

Former Member — Tue, 03 Jun 2008 07:47:55 GMT

hi sri,

hope it helps.

these tables have fields in common.

in febrw: anwnd, absnd, azidt are primary key,

in febep : kukey and esnum are pkey,

in febko: anwnd, absnd, azidt,emky are pkey but it also has a field Kukey.......

so with these common fields between them you just join them with for all entries

reward if useful.

regards,

srishti