sql query

[Former Member]

Hi,

I need to join two table, one itab and other database table with single field selection. its about FI table BSEG.And also be able to choose the entry from itab based on there company codes.

eg: structure for itab : product code,bsc market,nsc market.

along with the above query it should also select if BUKRS = 4000 then Nsc or Bsc. please tell me.

[Former Member]

Hi,

I need to join two table, one itab and other database table with single field selection. its about FI table BSEG.And also be able to choose the entry from itab based on there company codes.

eg: structure for itab : product code,bsc market,nsc market.

along with the above query it should also select if BUKRS = 4000 then Nsc or Bsc. please tell me.

[Former Member]

Hi,

Use the following tables instead of querying BSEG depends on your requirment,

Vendor info : BSIK ,BSAK

Customer info : BSID, BSAD

G/L account : BSIS, BSAS

Hope this helps,

Rgds,

[andreas_mann3]

hi,

i don't get your problem exactly.

try to select tables bsik,bsid,bsis

or bsak,bsad,bsas insted of bseg.

or try to use a logical database (DDF,KDF or SDF)

A.

Message was edited by: Andreas Mann

[Former Member]

thanks for ur prompt help at the right time.