creating ztable

[Former Member]

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.

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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