ZTable

[Former Member]

Hi,

I'm vish n BI consultant,

Can any one pl. tell me have u ever created ZTABLE in the real time, if created then what is table name, discription, field names(2 or 3) n discription.

Have u ever used data type currency, quantity and unit.

[Former Member]

since Ztable is a custom table you can have any name for the table (starting with Z)

the fields in this table can b custom created or you can reuse standard SAP fields along with their data elements...

[Former Member]

Hi Vish,

Z tables can be created in sap by t-code SE11.

SAP allows 'Z' , ' Y' name space for custom table creation .

To give you the steps for creating table:.

There are two approach in creating a table.

1. Bottom-up approach

2. Top-down approach.

Both are valid and you can choose which approach is suitable for you. I always use the bottom-up approach. Here are the steps to create the tables with this approach.

1. SE11 will take you to the DDIC and enter the name of the new table to be created. Let us say Zname. Click create.

2. Enter the short discription of the table and enter the field of the table. If it is primary key and you have to check the box.

3. Enter the data element and double click it, you will be asked to save and will take you to data element discription page. Enter the short discription of the data element and enter the information of domain like the length of field and type of field.

4. If you wanted to use the existing domain then its fine, or else, you have to create one. Enter the domain name in the data element page and double click it. Page will ask to save and jump to domain creation page.

5. In the domain page, you have to save the information which you have already given in the data elements page and check it. Before going to data element page, you have to activate the domain.

6. Go to data element page and save, check and activate.

7. Go to main table page and save, check, and activate.

8. Also, you have to save the technical settings of the table.

The table is now ready for operation. You can use it in your program or you can use it to enter information.

Check table: It is the table which will have all the information about the Foreign keys which are the primary keys in the check table.

It can be created by creating the foreign key from the main table. Click foreign key in the main table and it will take you to a page which will ask for table name and field to which foreign key relation has to be associated. Enter the information and you can create the check table automatically.

SM30 is used for maintenance of the table, that is to realease the errors occured during the creation of the table.

For more refer this link :

[http://help.sap.com/saphelp_46c/helpdata/en/4f/991f82446d11d189700000e8322d00/frameset.htm]

Reward if helpful.

Regards

Sourabh Verma

[Former Member]

Hi,

whatever table we create in realtime will start with 'Z' or 'Y',

about Discriptions, fields and other shoud be relevent to the usage of the table. Most of the times client will specify all the above things in spec.

Regarding currency fields, u can check it bye .. Goto SE11 and enter any table display ucan fine a tabstrip called CURRENCY/QUANTYTY fields there u cna find the type.

Regards,

kavitha.

[Former Member]

Hi,

step 1. Go to transaction se11.

step 2. write a table name prefix with z.

step 3. Give description.

step 4. It comes to delivery and maintainance, In delivery class u have 3 types u can select any of those 3. I have selected as A(master and transaction data).

Along with this u have to mention ur data browser as Display/ maintainance allowed only.

step 5. Go to technical settings, specify ur data class (APPL0) and size.

step 6. Create your fields with data element and domain.

step 7. While u enter ur data element ( the name u give should prefix with z) double click on that.

step 8. Now u have two options either to create domain or data type. After creating this, it will ask for field label, mention the field label.

step 9. Now activate at the same screen and come back u'll come to data element screen then again activate. Finally u'll come to first screen.

step 10. Follow steps 6 to 9 for more fields.

step 11. then activate.

step 12. To create entries in the table. On menu bar u have utilities, in that u have table contents, in that u have create entries.

step 13. After every entry save the data. That will be saved in the databaase.

This resolves your query.

Reward points.

Thanks and Regards.

Harish

[Former Member]

Hi,

Please follow the steps provided by others to create tables and fields.

Regarding CURRENCY and QUANITY

Whenever you are using the currency field it must refer to a currency type. suppose you want to make a field of type CURR then it must refer to CUKY similarly QUANTITY and UNIT.

i.e suppose if a field Amount is declared as CURR then it must refer to a field of type CUKY. that means Amount will handle some number for currency i.e dollars , rupees etc

ie CURR for amount and CUKY for currency type.

we can refer the CUKY field from the same table or existing tables. 1000 Dollars means 1000 for CURR and Dollars for CUKY.

Similarly QUANTITY and UNIT.

UNIT holds the measurement type and quantity contains values.

EG:

In mara table, fields ERGEW ( QUAN) has the reference field ERGEI (UNIT).

Hope its clear to use the currency , quantity fields.

Reward points if helpful.

Thanks and Regards.

.

[Former Member]

hi vish,

Please try this.

1) Go to SE11 and check table maintanance check box under attributes tab.

2) Go to menu Utilities -> Table Maintanance Generator ->

Create function group and assign it under function group input box. You can enter same as table name for function group. Also assign authorization group default &NC& .

3) Select standard recording routine radio in table table mainitainence generator to move table contents to quality and production by assigning it to request.

4) Select maintenance type as single step.

5) Maintainence screen as system generated numbers this dialog box appears when you click on create button.

6) Save and activate table

REFER

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

http://help.sap.com/saphelp_erp2005vp/helpdata/en/69/c251474ba111d189750000e8322d00/frameset.htm

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20im...

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

regards

karthik

if usefull reward me points

[Former Member]

Hi,

U can Create Z table, starting with Z or Y.

As its common letter Z followed by development area/module and Location followed by description specific to the table.

As far as , Data Element & Domain is concerned, you an make use of Standard Domain/Data Element if you field requirement is such as a standard one.

or you can create your own dataelement/domain.

Name of Table/Data element /Domain should be meaningful.

Every Z table should start with a Field MANDT.

Define appropriate Data Class & Delivery Class. Also According to the requirement mention buffering required or not.

After that you can have more than one primary fields.

For the Currency / Quantity field.. you need to mention the Reference field and reference table.

Reward point if useful