topic Reference Fields and Tables in Application Development and Automation Discussions

Reference Fields and Tables

Former Member — Thu, 12 Mar 2009 17:21:48 GMT

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

Re: Reference Fields and Tables

former_member194669 — Thu, 12 Mar 2009 17:29:53 GMT

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®

Re: Reference Fields and Tables

former_member156446 — Thu, 12 Mar 2009 17:29:53 GMT

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

Re: Reference Fields and Tables

Sm1tje — Thu, 12 Mar 2009 17:31:11 GMT

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

Re: Reference Fields and Tables

Former Member — Thu, 12 Mar 2009 17:34:32 GMT

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