topic Re: help with idoc selection in Application Development and Automation Discussions

help with idoc selection

Former Member — Thu, 30 Nov 2006 19:26:34 GMT

i want to read all the idocs created based on the date and user name.

select uname credat cretim docnum into table

itab from edids

where credat in s_rsdat and

uname in s_user and

countr = ' '.

In edids table for different countr field the user name differs for same idoc number what does that mean

thanks

Re: help with idoc selection

Former Member — Thu, 30 Nov 2006 19:30:27 GMT

Hi Swathi,

COUNTR is the EDI status counter. It states how many status records there are in the table EDIDS.

The field COUNTR is filled in the function module EDI_DOCUMENT_STATUS_SET, using the internal number assignment.

Regards,

Ferry Lianto

Re: help with idoc selection

Former Member — Thu, 30 Nov 2006 19:37:57 GMT

atleast the countr 0 indicates the date on which it is created for countr 1 the date may be different.

iam guessing that that the countr would be created when the idoc is created right.

thats the reason i am using it in my selection criteria.

i can read from edid4 table but again there is no user name field.

pls let me know.

if iam wrong pls let me how to read the idoc created based on date and and person responsible for creation

do you have any idea about the second question.

i.e for different counters the user name differs

thanks

Re: help with idoc selection

Former Member — Thu, 30 Nov 2006 19:50:27 GMT

Hi,

Can you check field STATUS instead of COUNTR?

Let's say 53 or 03.

Regards,

Ferry Lianto

Re: help with idoc selection

Former Member — Thu, 30 Nov 2006 20:02:29 GMT

Hi,

status 53 would give the date the idoc posted i mean the succesful date.

say i created a idoc today and iam post the application may be tommorrow .

in that case the selection query would return with o hits with sttus 53 right.

let me know if iam wrong

thanks

Re: help with idoc selection

Former Member — Thu, 30 Nov 2006 20:10:53 GMT

Hi,

Status 53 mean IDoc has been succesfully posted to application.

If you created the IDoc today but has not posted to application then the IDoc status is 64. Once successfully posted tomorrow, the status changes to 53.

So if you want to search IDoc which created today but has not posted yet then select STATUS = '64' and CREDAT = SY-DATUM.

if you want to search IDoc which created today and has been successfully posted then select STATUS = '53' and CREDAT = SY-DATUM.

Again, hope this will help.

Regards,

Ferry Lianto

Re: help with idoc selection

Former Member — Thu, 30 Nov 2006 20:30:44 GMT

Hi,

I have selection screen for user name and creation date .

so it may be any date .

in that case stutus doesn't work i guess right.

even the t code we 02 and we05 doesn't give the option of created by

let me know if you find a way

thanks