Changing Inspection Plan Uploading using Bdc

[SrihariNerella]

Hi Guru's,

I am developing BDC for uploading the data from flat file to Changing Inspection Plan ( qp02 ). I want to upload the Decimals , Unit of measurement , Low value , Upper value .It is based on Material Characteristic value in previous screen . I facing probelm to create a flat file and it contains multiple table controls how can we can code based on Materail value .

My requirement is

In qp02

First screen

Material : -

---

Plant : -

---

Keydate:----

---

Click on Task list bar

Second screen

It contains 2 line items .

First time Select the 1 line item group counter and click on Operations

Third screen.

It contains only one line item.

Select first line item then click on Inspection characteristics.

Fourth screen.

It contains so many line items.

First select first line item based on Material Inspection characteristic in flat file .

Click on Dependent Characteristics

Fifth screen

Click on insert button it will contain no of items select the line item based on customer in flat file ,

then updating fields

Decimals places

Unit of measurement

Lower specification

Upper specification

For every line item.

Then go back to Fourth screen .

It selecting second line item .

Repeat the procedure up to total line according to falt file .

My flat file is

1 20000310 1030 17.04.2009 1 10

0 MF0002 31101257 4 % 10 20

0 MF0002 31101283 4 % 11 20

0 MF0007 31101257 4 % 15 25

0 MF0007 31101283 4 % 16 30

1 20000310 1030 17.04.2009 1 20

0 MF0002 31101257 4 % 10 20

0 MF0002 31101283 4 % 11 20

0 MF0007 31101257 4 % 15 25

0 MF0007 31101283 4 % 16 30

This one i am using .

Please give some suggestion whether my flat file is wrong .

Regards

Nandan.

[Former Member]

Hi,

Ur flat file should be like in this format.

1 20000310 1030 17.04.2009 1 10 0 MF0002 31101257 4 % 10 20

1 20000310 1030 17.04.2009 1 10 0 MF0002 31101283 4 % 11 20

1 20000310 1030 17.04.2009 1 10 0 MF0007 31101257 4 % 15 25

1 20000310 1030 17.04.2009 1 10 0 MF0007 31101283 4 % 16 30

1 20000310 1030 17.04.2009 1 20 0 MF0002 31101257 4 % 10 20

1 20000310 1030 17.04.2009 1 20 0 MF0002 31101283 4 % 11 20

1 20000310 1030 17.04.2009 1 20 0 MF0007 31101257 4 % 15 25

1 20000310 1030 17.04.2009 1 20 0 MF0007 31101283 4 % 16 30

[SrihariNerella]

Hi Murali,

Thanks for your quick reply .

In this transaction it contains multiple table controls .I want to update only four fileds in last screen based on customer no . How can we identify the item data and header data .

Regards

Nandan.N

[Former Member]

Hi,

If u have operations multiple then do loop at operation level first, for that operation you do another loop at

characteristic scree level where u update the values of Target, UOM, Lower, Upper.

[SrihariNerella]

Hi,

In my faltfile I have Material Characteristic field .When the materail characteristic is same as material characteristic in transaction then i want to select the particular column .How can i select that one .

And in next screen it contains customerno when it is same as my falt file customer no then i want to

select the particular row .

Regards

Nandan.

[SrihariNerella]

I am closing the issue .Still i did not get the answer.

Regards

Nandan.N