Variant table constraint

[former_member840419]

Hi I'm trying to build a Variant table to be able to move some of the complexity from constraint net to a table.

But I am running into a problem, take for example below:

Objects:
X is_a (300)Thing.

Condition:
table Thing
   (
      WIDTH_PROD = X.WIDTH_PROD,
      HEIGHT_PROD = X.SPC_HEIGHT_PROD
   ).

Restrictions:
false.

This works, but I need to check in intervals so i made some characteristics and put them im table:

WIDTH_PROD_FROM

WIDTH_PROD_TO

HEIGHT_PROD_FROM

HEIGHT_PROD_TO

Here comes my problem when i want to compare:

WIDTH_PROD_FROM > X.WIDTH_PROD,

WIDTH_PROD_TO < X.WIDTH_PROD_TO,

HEIGHT_PROD_FROM > X.SPC_HEIGHT_PROD,

HEIGHT_PROD_TO < X.SPC_HEIGHT_PROD,

How would I go about this problem of having a product specification saying 10-7500 mm width and height 800-9000 ,product X with H 500 and W 900 is then ok. The above does not make scense to have in table i know but i have a lot of other combinations as well 🙂

Thanks in advance.

[AndyS · Accepted solution]

Hi Anders,

I believe you can use a user-defined function (trx CU65) in combination with a maintenance view (trx SM30) of a z-table instead of a variant table.

In this case you have to implement the lower greater comparison in ABAP.

Wishes

Andreas

[Former Member · Accepted solution]

Hi,

For interval derivation go for variant function with reference of Z -tables.

WR,

Ajay Rana

[former_member840419]

Thanks for the answers I will look into that solution, I had hoped I didn't need to create a function for it but I will try 🙂