topic Re: Uploading problem ..... in Application Development and Automation Discussions

Uploading problem .....

Former Member — Thu, 19 Jan 2006 23:14:03 GMT

Hi folks,

I have record the BDC using SHDB for (0028)… code is look like,

'Q0028-SBJKT(01)' ' ' ' ',

'Q0028-JNFLD(01)' ' ' ' ',

'Q0028-NMFLD(01)' ' ' ' ',

'Q0028-WTFLD(01)' ' ' ' ',

'Q0028-DTFLD(01)' ' ' ' ',

But this(01) will keep changing on the bases of excel sheet, how can I pass (01) dynamically to BDC code up to (30) … .

For example in some cased it could be ( 03),(05), or (20) or (30) ,

User will give me a excel sheet like

Pernr subtype result Sbj01 JNF01 NMF01 Wtf01 Dtf01 ……….up to Sbj30 JNF30 NMF30 Wtf30 Dtf30

I’ll appreciate your help.

Thanks

Bye

Re: Uploading problem .....

Former Member — Thu, 19 Jan 2006 23:30:18 GMT

data int1 type I,

n type I.

loop n times.

int1 = sy-index.

concatenate 'Q0028-SBJKT(' int1 ')' into field1.

concatenate 'Q0028-jnfld(' int1 ')' into field2.

concatenate 'Q0028-jnfld(' int1 ')' into field3.

...

clear int1.

endloop.

fields field1, field2,... will contain the data.

dynamically the number is increased.

hope this helps you.

Pls do reward points if its helpful to you.

Cheers,

Suresh

Message was edited by: Suresh Deshpande

Re: Uploading problem .....

Former Member — Thu, 19 Jan 2006 23:31:05 GMT

You should have an index to do that, for example if tha data file are stored in an internal table and every record is a record for your bdc:

DATA: INDEX(2) TYPE N,

COUNTER TYPE I.

DATA BDC_FIELD(20).

LOOP ....

COUNTER = COUNTER + 1.

IF COUNTER > 30.

COUNTER = 1.

ENDIF.

MOVE COUNTER TO INDEX.

PERFORM BUILD_FIELD_NAME USING: 'Q0028-SBJKT',

'Q0028-SBJKT',

'Q0028-JNFLD',

'Q0028-NMFLD',

'Q0028-WTFLD',

'Q0028-DTFLD'.

ENDLOOP.

FORM BUILD_FIELD_NAME USING FIELDNAME.

CONCATENATE FIELDNAME '(' INDEX ')' INTO BDC_FIELD.

ENDFORM. " BUILD_FIELD_NAME

max

Re: Uploading problem .....

Former Member — Fri, 20 Jan 2006 15:09:29 GMT

Thanks for the answers. Any other Suggestion out there.

Waiting

Bye

Re: Uploading problem .....

Former Member — Fri, 20 Jan 2006 15:15:36 GMT

Hi Suleman,

1. There is no other way !

2. The field name which we

pass in the bdc,

-- it is not necessasry

that we have to hardcode it.

3. we can use CONCATENATE and variable

to Dynamically construct the FIELD NAme

and also put Brackets ().

regards,

amit m.

Re: Uploading problem .....

Former Member — Fri, 20 Jan 2006 23:13:08 GMT

I wrote up the code , and I’m coming across another problem now…

I wrote logic like …

concatenate:'Q0028-SBJKT(' counter ')' into field1,

'Q0028-jnfld(' counter ')' into field2,

'Q0028-jnfld(' counter ')' into field3,

'Q0028-WTFLD(' counter ')' into field4,

'Q0028-DTFLD(' counter ')' into field5.

This fields are coming form excel and these fields are up to 30….

But when I record IT0028 , It only consider the fields 01… to 06, There is page down up to 30 .. fields

These fields are maintain as in tabular form ….

01 Degree Input from excel

02 Home Input from excel

03 dd Input from excel

04 dd Input from excel

05 dd Input from excel

06 dd Input from excel

07 ds Input from excel

08 ee Input from excel

09 ee Input from excel

03 yy Input from excel

Now I have write a code to page down depends upon every 06 fields …

if counter GE '06'.

i = 1.

elseif counter GE '12' and counter LE '18'

I = 2…

And so on up to 30

Endif.

do i times.

PERFORM sub_bdc_field USING :

'BDC_CURSOR' 'P0028-EXDAT' ' ' ,

'BDC_OKCODE' '=P+' ' '.

enddo.

Now when say we need to upload ‘8’ recorded which is 8th place in tabular but as we page down 1 when I pass 'Q0028-SBJKT(' counter ')' into field1 ( Where counter = ‘8) .. It pops the message field Q0028-SBJKT(08) does not exist . because tabular is only take care of fields from 01…..06 …

How I can upload the records till 30th … where these values are based on subtype ‘9030’ in IT0028..

What do you think guys..

Lets see

Thanks in Advanced...

Bye

Re: Uploading problem .....

Former Member — Fri, 20 Jan 2006 23:34:14 GMT

Try this. In your screen, when you do 'page-up', see where the next item can be inserted. Typically it will be in the second line. Assuming that it is, your do loop can be eliminated and rewritten as follows.


loop at items.
  if sy-tabix = 1.   
     prepare bdc data with counter 1.
  else.
     prepare bdc data with counter 2 always.
     do a page up.
  endif.
endloop

Re: Uploading problem .....

Former Member — Fri, 20 Jan 2006 23:52:53 GMT

No its not the case I am hitting Page down and values are coming for file for one employee there could be up to 30 entries .. I can only see first 01 ...to 06 fields in IT0028 Sub type = ‘9030’...

But for next field after one 'page down' is 07 but technically its field become (01) ....

I hope I made my self clear right?

Re: Uploading problem .....

Former Member — Sat, 21 Jan 2006 00:31:02 GMT

That is what I am trying to address. Do not try to enter all the lines (7 in this case). You enter one item, then the second, now do page up. This will bring the next empty line to second position. Enter item in the second position. Again press page up, the next empty line will be in the second position.

This way you will always enter constantly in the second position, no matter however many lines you have.

If you code the way you are doing, you will run into the problems that you are facing now and also the number lines available will vary depending on the screen resolution and running it online vs background. So even if you change the counter back to 1 after every seven entries, the number of lines available may be 6 or 9. So you will face a problem there.

So please try this logic.

enter first line with bdc field as field1(01).

enter second line with bdcfield as field2(01).

Bdc okcode = pageup

enter the third item of the itab into second position only.

bdcokcode = pageup.

enter 4th one again in the second position.

bdc okcode = pageup.

....... and so on...

Re: Uploading problem .....

Former Member — Mon, 23 Jan 2006 16:14:55 GMT

Thanks a lot for your answer...

in my case the value in rows are 'DEFAULT VALUES' based on subtype configuration in SPRO. For subtype '9030' I have 20 'DEFAULT VALUES' so Rows are like 01.....20. There’s no line feed on new line which I have to enter . When Ever I’ll click IT = 0028 and subtype = ‘9030’. I’ll get 20 values in rows and I have to put date in front of every Row till 20th (In fact Based on excel sheet ).

Any idea

Thanks

Message was edited by: Suleman Javed

Re: Uploading problem .....

suresh_datti — Mon, 23 Jan 2006 20:36:17 GMT

Hi Suleman,

From what I understand, the examination areas are defined in T528Z and are fixed values for each subty. ie the order in which you enter them should not matter. In your case for subty 9030, enter the first six entries as 'Q0028-SBJKT(01)' through 'Q0028-SBJKT(06)' page down & and next six entries as 'Q0028-SBJKT(01)' through 'Q0028-SBJKT(06)' and so on..

Regards,

Suresh Datti

Re: Uploading problem .....

Former Member — Mon, 23 Jan 2006 20:46:28 GMT

Hi Suresh,

Now we are on the same page .. I am trying to do the same but its not working ..like say 1st REC against any employee I get is 'Q0028-SBJKT(01), it will post it successfully , the next record is 20 OK ..Now we need to page down 3 times then we reach to record number '20'

3 * 6 = 18 ...Record will be 'Q0028-SBJKT(02)'....

How I can handle this in code. So far I am trying to do the following but its not working fine .

concatenate:'Q0028-SBJKT(' counter ')' into field1,

'Q0028-jnfld(' counter ')' into field2,

'Q0028-jnfld(' counter ')' into field3,

'Q0028-WTFLD(' counter ')' into field4,

'Q0028-DTFLD(' counter ')' into field5.

concatenate:'Q0028-jnfld(' count ')' into field6.

PERFORM sub_bdc_dynpro USING 'MP002800' '2000'.

PERFORM sub_bdc_field USING :

'P0028-EXDAT' p_rec-a_EXDATE ' ',

'P0028-RESUL' p_rec-a_RES ' ',

'BDC_CURSOR' field6 ' ' ,

'BDC_OKCODE' '=P+' ' ' , "NEXT PAGE

field1 p_rec-a_SBJKT ' ',

field2 p_rec-a_JNFLD ' ',

field3 p_rec-a_NMFLD ' ',

field4 p_rec-a_WTFLD ' ',

field5 p_rec-a_DTFLD ' ',

'BDC_OKCODE' '=UPD' ' '. "SAVE

In my case, subtype is also in excel file. Say for some subtype it will be till 30 or for some it will be till 10 or in some it will be: AL,AC etc....

Thanks For your help...

Bye

Re: Uploading problem .....

suresh_datti — Mon, 23 Jan 2006 21:00:17 GMT

Hi Suleman,

Even if the 2nd entry is '20', you don't need to really scroll down to the 20th entry in the table control.. you can enter it in 'Q0028-SBJKT(02)'. this is what I meant when I said the order in which you enter does not matter..

Regards,

Suresh Datti

Re: Uploading problem .....

Former Member — Mon, 23 Jan 2006 21:09:06 GMT

When I am trying to this for "20" its giving me following error message "Examination area 9030 02 cannot be delete"

Just do it in your SAP system and see how It reacts may be that will clear my question.

Thanks

Re: Uploading problem .....

suresh_datti — Mon, 23 Jan 2006 21:45:30 GMT

We don't use this infotype.. will try to do a recording in our sandbox & let u know..

Suresh

Re: Uploading problem .....

suresh_datti — Mon, 23 Jan 2006 22:05:53 GMT

HI,

You will get that error if the mode eq 'X' in T578Z for the examination area(SBJKT).. which is why you are getting the error message.. So, pl check the entries in this table for subty '9030'. If the mode is 'X' for all the 20 entries.. you will have to pass empty values in your BDC for the SBJKT that you don't need.. because if you skip them, the system tries to delete & throws up the error.. hope the scenario is clear for you now..

Regards,

Suresh Datti

Re: Uploading problem .....

Former Member — Mon, 23 Jan 2006 23:07:22 GMT

Hi Suleman/Suresh

I am also facing the Exact same kind of problem, I have tried almost everything.. But its not working ...

Any body out there who can solve it ..

Let me tell you its a real challenging stuff to do ..

Waiting

Bye

Re: Uploading problem .....

suresh_datti — Mon, 23 Jan 2006 23:15:59 GMT

Hi,

Did you try what I suggested in my earlier reply.. it should work..

Regards,

Suresh Datti

Re: Uploading problem .....

Former Member — Mon, 23 Jan 2006 23:30:46 GMT

Suresh

I have tried , I knew there are few tables which contains the entries against subtype , in my case I am validating entries from these tables..

Tables are T578T,T578W,T578X,and the one you just told ..( T578Z)...

For subtype '9030' I can see all the values in table are = 'X'.

Now you are suggesting that if in file we have entries SBJKT = 01,03,15,20.

We have to pass Spaces for all remaining SBJKT in BDC ?

I remember I have done same kind of work in SALES ORDER ( VA02 ) screen but it has the option which will populate the Item number .. but here looks like its going beyond the screen ...

Let me try this and get back to you...

Bye

Re: Uploading problem .....

Former Member — Mon, 23 Jan 2006 23:37:00 GMT

Saquib

I also tried to see option in Menu bar and also by right clicking on the table but there is no option which pulls up the rows .

I think I am not getting your point guys

I may need a break .

Thanks Saquib and Suresh...