topic Re: How to join CABN table with VBAk in Application Development and Automation Discussions

How to join CABN table with VBAk

Former Member — Fri, 27 Feb 2009 09:44:49 GMT

Dear Friends,

I have to fetch data from CABN, by joining CABN table with VBAK.Can any one suggest me how can i fetch data from CABN, by comparig which field of VBAK?

Regards,

Farook.

Re: How to join CABN table with VBAk

Former Member — Fri, 27 Feb 2009 10:40:17 GMT

hiii,

if u r using two tables means ,u can do inner joining.

regards,

sumanth reddy

Re: How to join CABN table with VBAk

Former Member — Fri, 27 Feb 2009 10:45:41 GMT

Hi Mr Sumant,

Plz read the question properly.I am asking based on which field i can combine this VBAK and CABN tables.means

Select * from CABN into it_cabn where (field) = vbak(field)

I am asking the perticular fields to combine this 2 tables.

Regards,

Farook.

Re: How to join CABN table with VBAk

Former Member — Fri, 27 Feb 2009 12:12:35 GMT

Good

You can join these two table using inner join comparing the field VDATU which is present in both the tables.

Thanks

mrutyun^

Re: How to join CABN table with VBAk

Former Member — Fri, 27 Feb 2009 12:15:56 GMT

Looks Like you forgot to Logoff and Login Back with your IDs!!

Re: How to join CABN table with VBAk

Former Member — Fri, 27 Feb 2009 12:17:30 GMT

u2026..But both VDATU for different purposes.

Can't we join with Mandt?

Cheers,

Amit.

Re: How to join CABN table with VBAk

Former Member — Fri, 27 Feb 2009 13:08:57 GMT

Chitty and Farook both are same.