Challenging.............

[#1]

Hi  Community,

PFA,

Material & Plant as KEY

Here in my table i have status(ok and invalid),

i want to compare with another table, only invalid field status.......

in my 3rd table i have a QTY field

i want to compare with this field (WRP QTY-ORDER QTY)

based on Material & Plant as KEY

Thanks in Advance.......

[#2]

Please any one can help me.........

[#3]

Anybody is there............

[#4]

I don't understand what you are trying to do.  Can you explain some more?

[#5]

Hi,

Order Date	Material No	Plant		ATP Qty1	Ordered Qty	Cumulative Qty	Status
2-11-2013	28112	A016		500	300	200	ATP
22-11-2013	28112	A016		200	200	0	ATP
24-11-2013	28112	A016		0	300	-300	Invalid
24-11-2013	28112	A016		-300	250	-550	Invalid
05-12-2013	1234	A017		100	80	20	ATP
06-12-2013	1234	A017		20	30	-10	Invalid

WRP_Table:

LOAD *, [Material No] & '|' & [Plant] as Key

INLINE [

MaterialNo1, Plant1, WRP Qty

28112,         A016,     350

1234,           A017,     80];

Here in my table invalid fields (Negative values), compare with the Order Qty and  WRP_Qty

(WRP QTY-ORDER QTY)

like this   WRP_Qty=350

               OrderQty= 300

350-300=50 status should be OK

based on Material & Plant Key

Thanks in Advance

[#6]

Hey Sunil,

I created a field called 'Flag'. Let me know if it meets your requirement.

[#7]

Made a small change based on your recent explanation.

check it now and let me know.

Thanks

AJ

[#8]

Hi Ajay,

Output would be

Order Date	Material No	Plant	RWt Qty	ATP Qty1	Ordered Qty	Cumulative Qty	Status	Status_Flag
2-11-2013	28112	A016	350	500	300	200	ATP	ATP
22-11-2013	28112	A016	350	200	200	0	ATP	ATP
24-11-2013	28112	A016	350	0	300	-300	Invalid	Ok
24-11-2013	28112	A016	350	-300	250	-550	Invalid	ok
05-12-2013	1234	A017	80	100	80	20	ATP	ATP
06-12-2013	1234	A017	80	20	30	-10	Invalid	ok

RWT Qty-Order Qty= Status_Flag

[#9]

Sorry used the wrong field. Check this one out.

Thanks

AJ

[#10]

Thank U Ajay..

I did small correction.........