I need to get the range of Plant codes as a datatable based on the Company Code. The company code is my input. How can I get the plant codes as a datatable for the Company Code? For example: If the company code is 4000, The Plant code I need to get should be 4551-4556 as a datatable.
@esakki1612 build one datatable-
In for each row in datatable
If currentrow(“company code”)=“4000”
Then add that datarow to datatable.
Outside for each remove datacolumn of company code from datatable