Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

relation b/w the tables

NAeda
Contributor

‎02-12-2008 9:23 AM

0 Kudos

Hello ,

i need the GL account no from SKA1 related to

bwtar-valuation Type from MSEG.

Valuation type :INDIGENOUS GL account no,

Business Area, Material Code, Material Description, Valuation type, Quantity, Rate Value

Valuation type IMPORTED

Sl.No. Business Area Material Code Material Description Valuation type Quantity Rate Value

above fields are from MSEG MAKT MKPF with these i need GL account no from SKA1... how to relate these to gl account

if i take MSEG-SAKTO the data is not matching the user GL ACC is in SKA! and in a view gl_acct_cc...

so please help me out

thanks

regards

Narsimhlu

Edited by: Aeda N on Feb 12, 2008 10:30 AM

Edited by: Aeda N on Feb 12, 2008 2:11 PM

2 REPLIES 2

Former Member

‎02-12-2008 9:29 AM

0 Kudos

Check this field MSEG-SAKTO. it is G/L account Number.

Former Member

‎02-12-2008 11:04 AM

0 Kudos

Hi,

Define a view with the join conditioms.

Regards,

Rama.Pammi