topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Tue, 28 Aug 2007 07:20:17 GMT

Can we create a table that will have relation with SAP available table fields?

Re: tables

Former Member — Tue, 28 Aug 2007 07:50:56 GMT

yes you can create table which you can use the SAP table as Check table , foerign key relation , Value table ,etc.

by having same fields in your z** table ... add foreign key relation ...and if you want some of the fields has value table and also Chech table .

'Foriegn key  :

example Company code, vendor , customer, personal number ,etc..

'Check table :

text table , company code table, etc...

'value table :

debit/credit , etc

reward points if it is usefull ....

Girish

Re: tables

Former Member — Tue, 28 Aug 2007 08:03:11 GMT

Hi,

yes you can create table by using SAP table as as Parent and child tales like Check table , foerign key relation , Value table ,etc.

At the time of create z-table you can create a table by using Foriegn key relations means before enter a value in that table it makes validations against values in check table,, ie suppose if you enter any comp code is 123 in that z-tabel it will check where that comp code is exits in check table (call as parent table) if it exit it allow other wise it couldnt.

Note : while creating foreign key relation ship in the field level, make sure that filed should be Primary key field in that check table.

at the time of create z-tables you can use the standard Domains, Data elements etc........

Reward with points if usefull.

Regards,

Vijay