Reference Fields and Tables

[Former Member]

Hi there

I'm not getting Reference Fields and Tables, If I create a table with QUAN as a data type, how do I know which Reference Field and Table I should use?

Thanks,

Jan

[former_member194669]

For example you are creating a table YTAB with

YQTY

YUOM

In the YQTY field reference table you can give as YTAB and reference field as YUOM

a®

[former_member156446]

Hi there is not need that you always need to have a reference field and reference table... you can even create elements with PREDEFINED TYPES

data validations... check on if value exits etc... need to be done explicitely

[Sm1tje]

Look at this link:

[Reference Fields and Reference Tables |http://help.sap.com/saphelp_nw70/helpdata/EN/cf/21ea5d446011d189700000e8322d00/frameset.htm]

Actually, ' it does not matter' which table you choose. The easiest way would be to create both the quantity field and the Unit of Measure in the same table.

The thing is, the field quantity has to know to which it should reference to determine the actual quantity which can be almost 'anything'.

Edited by: Micky Oestreich on Mar 12, 2009 6:31 PM

[Former Member]

Awesome, thanks I got it. I just needed to see the relationship between QTY and UOM.