topic Re: creating ztable in Application Development and Automation Discussions

creating ztable

Former Member — Tue, 07 Aug 2007 08:50:46 GMT

hi all,

can any one help me on this issue. i have created a ztable with vbeln,erdat, and some extra fields like inner and outer box no. how can i link it to sales order vbeln.i want to add box number for that particular sales order number number what i have to do for this.

Re: creating ztable

Former Member — Tue, 07 Aug 2007 08:52:53 GMT

In the table against the field VBELN give the check table as VBAK

so that the value of vbeln field in your tables referes to the vbeln field of VBAK(sales Order)

<b>Reward points for useful Answers</b>

Regards

Anji

Re: creating ztable

Former Member — Tue, 07 Aug 2007 08:55:19 GMT

Hi,

give VBELN in your Ztable as primary key and clikc the Foreign key relation and take VBAK as check table..

Now what ever entries you create in Ztable links to the VBAK table against the field VBELN..

rewards if useful.

regards,

nazeer

Re: creating ztable

Former Member — Tue, 07 Aug 2007 08:57:20 GMT

Hi Abinash,

As per my understanding of your Q , you need to add box for only the sales order number that already exists in the SAP system. For that purpose you need to use the concept of check table. link the field VBELN of your Ztable to the SAP table -VBELN . So that it wont allow any entries of sales order which are not present in the SAP system.

Reward points if useful.

Harmeet Singh.

Re: creating ztable

Former Member — Tue, 07 Aug 2007 08:59:17 GMT

Hi Verma,

in ztable for vbeln field give the check table as vbak and you should maintain foreign key relationship for thoese fields by selecting the fields in ztable

Reward points for helpful answers,

kiran.M