topic Re: Delete entries from custom table in Application Development and Automation Discussions

Delete entries from custom table

PS_1978 — Tue, 04 Nov 2008 08:10:50 GMT

Hi,

I have created two custom tables. One table is having one field (assortment key), which is used as check table for assortment keys and other table is having two fields (sales org & assortment key) which is used to maintain combination of sales organization and assortment keys.

I have also created table maintenance genrator for both the tables. Entries in second table can be maintained based on entries in first table.

Now, if i try to delete entries from table 1 (assortment key master table) and if this assortment key is still used in second table in combination with sales organization, program should through a message 'Dependt Entries also will be deleted' and based on user input it should either delete or keep the entries as it is.

I have tried debugging the code in table maintenance generator but i could not find the proper way to achive this. Please help me in solving this problem.

Best Regards,

Phani Kumar. S

Re: Delete entries from custom table

Former Member — Tue, 04 Nov 2008 08:38:04 GMT

Hello,

For this u need to change the cardinality.

Below are the list of cardinalities and their functionality.Chack it and use the proper one.

The left side (n) of the cardinality is defined as follows:

n=1: There is exactly one record assigned to the check table for each record of the foreign key table.

n=C: The foreign key table may contain records which do not correspond to any record of the check table because the foreign key field is empty. This can occur for example if the field of the foreign key table is optional, in which case it does not have to be filled.

The right side (m) of the cardinality is defined as follows:

m=1: There is exactly one dependent record for each record of the check table.

m=C: There is at most one dependent record for each record of the check table.

m=N: There is at least one dependent record for each record of the check table.

m=CN: There may be any number of dependent records for each record of the check table.

But one thing you remember that

you can delete record in master table : it wont check in the transaction table.

but while you delete record in transaction table : it will check record existance in master table.

Regards

ansumesh

Re: Delete entries from custom table

Former Member — Tue, 04 Nov 2008 09:55:18 GMT

Hi Siva,

The same issue was asked by one of SDNian yesterday and some views have been given for that.

If you delete the primary or check table records then till now i have never seen any alert like dependent entries are present it can be deleted.

But when you try to delete the table (check table or primary key table) then definitely the alert will come saying some objects are dependent with this table so cannot be deleted like.

Cheers!!

VEnk@

Re: Delete entries from custom table

PS_1978 — Tue, 04 Nov 2008 10:10:18 GMT

Hi,

Thanks for your replies.

If we try to delete the custom output types in NACE transaction, it will through the information message that, dependent entries also will be deleted. in the same way, i want to provide for the deletion of entries from master table.

Best Regards,

Phani

Re: Delete entries from custom table

Former Member — Tue, 04 Nov 2008 10:45:24 GMT

Then you need to implement your own logic(to check whether the entry is present in dependent tables) in the TMG generated code - PAI for DELETE. That can solve your problem,

Regards

Karthik D