Problem in Selection Conditions Maintenance View

[Former Member]

Hello Gurus.

I've created a maintenance view for a ZTABLE, in this maintenance view in TABLE/JOIN Conditions i defined a relationship beetween my ZTABLE and SKAT.

Untill this point its fine. But when i go to the tab of selection conditions, there already there two automatic conditions. And i can't edit these conditions.

Why this is happening?? Anyone knows??

Thanks in advance

[Former Member]

Hello Gurus.

I've created a maintenance view for a ZTABLE, in this maintenance view in TABLE/JOIN Conditions i defined a relationship beetween my ZTABLE and SKAT.

Untill this point its fine. But when i go to the tab of selection conditions, there already there two automatic conditions. And i can't edit these conditions.

Why this is happening?? Anyone knows??

Thanks in advance

[Former Member]

Hi,

The already predefined set of relationship is due to the data integrity and foriegn key relation ship.

so we get a predefined set of relaionships if we take view of existing master table.

since SKAT is gl account master for chart of accounts and its key fields would have the set of foriegn key relations with the corresponding key tables

like

ktopl- t004 etc

[Former Member]

Hi There,

Those are the Primary fields or key fields sharing the common data,, This is required to maintain the data consistency. SAP's major strength is its data integrity...

You will not be able to edit primary keys since these values are maintained in several other tables too. changing at one place and keeping it as is in another table lead to data inconsistency.

let me know if you have further queries.

don't forget to rward pionts if found useful.

Thanks-