Change request to a Z table

[Former Member]

I would like to build a generic extractor based on a Z table. The problem I am currently facing is that the reference tables for the quantity fields are in tables which the relationships give 0 records.

Is there anything wrong if I request that these reference fields are also part of the Z table i.e. and than the quantity fields reference the Z table field. My concern is that on this request will the people maintaining the z table face the same problem as me when trying to determine a relationship. If it is not a good suggestion are there any alternatives? Thanks

[Former Member · Accepted solution]

Thanks for that. Sorry for this but could you just show me say for one of the quantity fields on a line (with a header) how you are describing – its Friday and its hot in India 

[Former Member · Accepted solution]

in SE11 with your ZTABLE

TAB fields:

<b>FIELDS ..... CHECK TABLE</b>

LFIMG .....

VRKME ..... T006

QUANT_C .....

MEINS ..... T006

TAB Currency/quant.fields

<b>FIELDS ..... Ref table ..... ref field</b>

LFIMG ..... ZTABLE ..... VRKME

VRKME .....

QUANT_C ..... ZTABLE ..... MEINS

MEINS .....

hope that clears your doubts

Olivier.

Message was edited by:

Olivier Cora

[Former Member · Accepted solution]

Sorry guys one last thought if they are not able to modify the table does that mean I will have to build a generic extractor using the function module approach i.e. is this therefore doable in fm

[Former Member · Accepted solution]

well this will depends on what you have in your ZTABLE....

if you want to get your VRKME from LIPS, you'll have to have the key fields of LIPS in your ZTABLE (MANDT, VBELN, POSNR)

if you want to get MEINS from MARA then you'll need MANDT and MATNR in ZTABLE.

The point is if you can do that, then somebody could readjust your table as well!!

hope this helps

Olivier.

[Former Member]

Hi

When ever you have quantity fields and currency fields in your ztable and you need to create generic data source,you will get this problem.modify your table with taking reference fields from the tales t0006 etc depends on the requirement and then create the GDS...you can also give the self reference from your ztable

Hope it helps

Thanks

Teja

[Former Member]

Thanks for that. My scenario is as follows - the Ztable includes a number of fields two of which have reference tables. The details are below:

FIELD REFERENCE TABLE REF FIELD

LFIMG LIPS VRKME

QUANT_C MARA MEINS

My suggestion was that I ask that LIPS-VRKME and MARA-MEINS are included in the Z table and the reference details will become

FIELD REFERENCE TABLE REF FIELD

LFIMG ZTable VRKME

QUANT_C Ztable MEINS

Is this a feasible suggestion that I can make and what are your recommendations otherwise

[Former Member]

Hi,

Yes you should include both UNIT fields (VRKME and MEINS) in your ZTABLE and reference your quantities accordingly this this

LFIMG to VRKME (like in LIPS)

QUANT_C to MEINS.

In adition you should add the cjeck table T006 to your unit fields in order to avoid any non-unit typing.

hope this helps

Olivier.