topic why we create ztable in Application Development and Automation Discussions

why we create ztable

Former Member — Wed, 18 Apr 2007 09:22:48 GMT

Hi Experts,

I am new to abap and i want to know why do we create ztable, when we have standard sap tables.

Adv tnx

nani

Re: why we create ztable

Former Member — Wed, 18 Apr 2007 09:29:02 GMT

Hi,

you create Z or Y-tables, because the SAP-standard can not be changed without a object key and in the best case, you should try to work with SAP without changing the SAP standard.

On the other side, if you have an update for release or so, the standard tables are overwritten with the standard and you need to rework all your changes after this.

The Z and Y-tables are saved from this.

So, if you don't want to make yourself more work, use the z and y namespace from sap. :O)

Regards

Nicole

Re: why we create ztable

Former Member — Wed, 18 Apr 2007 09:42:15 GMT

assume that your customer wants to track any user accessing a particular transaction and changes made by different users to the transaction. (example)

And the transaction realted SAP tables are not capturing that sort of details. Then we will go for a Z-table with the required fields. and we will write our own programs to Update the table as well as get reports from using the table data...

Whenever the existing SAP tables are not satisfying the requirements, we will go for Z-tables.

Re: why we create ztable

Former Member — Wed, 18 Apr 2007 09:50:35 GMT

Hi nani,

1.why do we create ztable

If we want to capture some data / information,

which is not available in standard r/3,

2. then for storing such data, we have to create Z tables.

(we cannot and should not directly use the standard tables , in sql,

for saving data)

regards,

amit m.

Re: why we create ztable

Former Member — Wed, 18 Apr 2007 10:40:22 GMT

Hi,

SAP standard tables does not mett all the client requirements.

When a client specifies a particular requiremenst and its not available with SAP std tables, then v goin for creating a Ztable with all Z fields, where in the client can upload his own set of records.

This makes it easy for the client for his further processings.

Z table thus plays a very vital role when it comes to specific requiremenst by the the various companies for their operation.

Hope wat i said is clear.

****reward points if useful.

All the best

Re: why we create ztable

Former Member — Wed, 18 Apr 2007 10:44:41 GMT

Z/Y Tables:

1)Standard Tables do not meet all the requirements. For example you may have to declare any structure as per the client requirement.

2) The enormous amount of data may not be any use to you when you need few lines of data

Re: why we create ztable

Former Member — Wed, 18 Apr 2007 12:01:00 GMT

CAN ANY BODY EXPLAIN THIS EXAMPLES