WORKING WITH REFERENCE FIELDS

WORKING WITH REFERENCE FIELDS:

Whenever we are working with amount field then we must provide reference as currency field.

Whenever we are working with quantity field then we must provide reference as unit of measurement field.

Create the following material table.

1. Execute SE11.
2. Select the radio button ' Database table '.
3. Provide database table name ( Eg: ZDE_MATERIAL ) and click on Create.



4. Provide short description ( Eg: materail data ).
5. Provide delivery class ( Eg: A ) and data browser ( Eg: Display / Maintenance Allowed ).


6. Click on Fields tab.
7. Provide Field and Data elements as below.


8. Now click on Currency/Quantity Fields  tab and provide the reference table and reference fields.



9. Click on Technical settings in the application tool bar.
10. Provide the Data class ( Eg: APPL0 ) and Size category ( Eg: 0 ).


11. Save, Click on back.
12. Save, Check and Activate the table.


Note: - 

T006 is the standard data base table which contains all the unit of measurements. 

Note: - 

In the real time when ever we are working with unit of measurement field then we must establish the foreign key relations with T006 as a check table. If you want to establish the foreign key relation then you must maintain the SAP domain “MEINS” into our field domain. 

Steps to establish the foreign key relation: - Select the unit of measurement in our table. Click on foreign key icon under the fields tab. Then the system will give a proposal with values table T006 as check table. Then click on yes. Enter. Save, check, activate the table. 

Note: - 

TCURC” is the standard data base table which contains all the currencies. 

In the real time whenever we are working with currency field then we must establish the foreign key relation with TCURC as check table. If you want to establish the foreign key relation then we must maintain the SAP domain “WAERS” into our table field domain. Select the currency field in our table. Click on foreign key icon under the fields tab. Then the system automatically gives a proposal with TCURC as check table. Click on yes. Enter. Save, check, activate the table.