topic sql query in Application Development and Automation Discussions

sql query

Former Member — Wed, 16 Aug 2006 13:20:03 GMT

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.

Re: sql query

Former Member — Wed, 16 Aug 2006 13:24:39 GMT

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,

Re: sql query

andreas_mann3 — Wed, 16 Aug 2006 13:25:27 GMT

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)

Message was edited by: Andreas Mann

Re: sql query

Former Member — Mon, 18 Dec 2006 11:40:15 GMT

thanks for ur prompt help at the right time.