a doubt

[Former Member]

hello friends,

can i know ,what the reason is to create custom table when there are already

so many built in tables in sap, can any one plz give few scenarios where we need to create custom tables.

thanks in advance.

[Former Member]

The SAP tables are used specifically for SAP transcations. If you require to store extra data realted to say a Sales Order then you could create an append structure to VBAK for example. Alternitively you could create a ZVBAK table to store the extra data.

There will also be occasions when the data you are storing is for a bespoke application. This will require bespoke tables to be created.

[Former Member]

Hi,

SAP Comes with most of the Transactions/Tables that are useful for different types of Company Business scenarios.

Even then for a particular company a special scenario will be there, for which SAP has not provided any screen/transaction/tables etc.

So to create our own Transaction(means some new business scenarios) we require some Z tables , screens, etc. of our own .

Regards,

Anji

[Former Member]

Hi ,

The reason is that the requirement of the customer may not fit into any of the standard tables available in SAP. SAP assumes that the processes followed in any industry in a particular module to be a standard, which is not the case in real world. The customer may follow a business process which doesn't get mapped to the existing functionality provided by sap.

the same logic applies for tables as well.

regards,

Ravi

[kiran_k8]

Kutumb,

First and Foremsot the situation where we need to created a ZTABLE arises very rarely.In some situations we need to create a ZTABLE when the existing tables doesn't serve the business need.As far as I know ZTABLES is a case we can see with non-english speaking clients.

One more reason is when a particular business doesn't have a PP or MM or SD or any functional module but still they want to use some of the tables related to that then the situation will ask for ZTABLE.

K.Kiran

[Former Member]

thanks martin for your reply,

can i get few more examples and little bit more precize, as to what such need would be to create a Z table, ie wat would be those extra fields.

thanks again

[hermanoclaro]

Hi there,

A scenario that could happen is:

A company have a system along SAP R3. They need you to send information from SAP to the system but, this information, can't be merged only with selects and all, maybe they need some information that will be given by the user and doesn't exist in SAP because the standard tables don't scope for this info. More than that, let's say that this company, would like to record this info that will be sent to this other system for log purposes.

I hope this helps.

[Former Member]

With any system, if there is no standard way to do something you would create a bespoke object. Whether it be a program, table etc.

You may want to store a list of users that have certain authorisations. You could use standard SAP authorisation obects, but there could be extra validation required. This information could be stored on a bespoke table.

I have just been involved in a project where a scanning station application has been written. The config for these scanning stations is stored in bespoke table on SAP as there is no standard table to store this data.

There are thousands of reasons to create a bespoke table. It will just depend on the requirements of the task at hand. You may start to work on a peice of work then at some later stage decide that a bespoke table is required.

[Former Member]

now its pretty clear,

extra authorizations or validations is one area where a bespoke table can be used.

thanks again.

[Former Member]

Hi,

Though SAP has created a number of standard tables there is a necessity for custom tables to be created where the relation between few fileds can be maintained in one single table and the record can be got from 1 table rather than selection of data from a number of table. For example you can define a custom table to maintain the relation between a IDOC number , and the purchase order number when creating a delivery .

Regards,

Sowmya.

[Former Member]

every one thank you very much for your replies,

can any one plz give a real example for this.

[Former Member]

Is this for an interview question.

[Former Member]

not exactly, but to get an idea of a real time scenario would look like.

thanks for your time.

[Former Member]

By saying 'not exactly' - You mean it is then.

Why would you think you need to create a bespoke table. Maybe if you thought about it you would know. How much SAP experience do you have.

[Former Member]

hi martin,

i am new to sap, previously worked on java.

[Former Member]

Hi Kutumba Rao,

ztables come into picture when the customers requirements are not met with the SAP standard tables.

Regards,

Naresh