sy-subrc = 4

[Former Member]

TYPES: BEGIN OF i_edidc, credat TYPE edidc-credat, "IDoc Created On docnum TYPE edi_docnum , "IDoc number status TYPE edi_status , "Status of IDoc rcvpor TYPE edi_rcvpor , "Receiver port (SAP System, EDI subsystem) direct TYPE edi_direct , "Direction for IDoc transmission END OF i_edidc.

DATA: it_edidc TYPE STANDARD TABLE OF i_edidc

SELECT credat docnum status rcvpor direct FROM edidc INTO CORRESPONDING FIELDS OF TABLE it_edidc WHERE credat IN s_credat "Created on AND status = '51' "Application document not posted AND rcvpor = 'sapdv1' "Receiver port AND direct = '2'. "Inbound

I get sy-subrc = 4.

requirementL:Select DOCNUM from EDIDC table where

STATUS = 51, RCVPOR = SAPDV1 & DIRECT = 2

AND selection screen date.

[Former Member]

TYPES: BEGIN OF i_edidc, credat TYPE edidc-credat, "IDoc Created On docnum TYPE edi_docnum , "IDoc number status TYPE edi_status , "Status of IDoc rcvpor TYPE edi_rcvpor , "Receiver port (SAP System, EDI subsystem) direct TYPE edi_direct , "Direction for IDoc transmission END OF i_edidc.

DATA: it_edidc TYPE STANDARD TABLE OF i_edidc

SELECT credat docnum status rcvpor direct FROM edidc INTO CORRESPONDING FIELDS OF TABLE it_edidc WHERE credat IN s_credat "Created on AND status = '51' "Application document not posted AND rcvpor = 'sapdv1' "Receiver port AND direct = '2'. "Inbound

I get sy-subrc = 4.

requirementL:Select DOCNUM from EDIDC table where

STATUS = 51, RCVPOR = SAPDV1 & DIRECT = 2

AND selection screen date.

[jyotheswar_p2]

Hi

Check your WHERE conditions correctly.Give the port name in capitals and GIVE a try.

Regards

Jyo

[Former Member]

Hi John

SELECT credat docnum status rcvpor direct
FROM edidc
INTO CORRESPONDING FIELDS OF
TABLE it_edidc
WHERE credat IN s_credat "Created on
AND status = '51' "Application document not posted
AND rcvpor = 'SAPDV1'  " Change it to Capitals this would work Fine
AND direct = '2'.{CODE} "Inbound

whenever you pass Char string in Single Quotes make sure there are in Capitals only

Cheerz

Ram

[Former Member]

Hi

Your select query is logically correct one, but as still it is not able to fetch the record, you can try the same in SE11 and give the input parameters as you are passing in your where condition and check if that is fecting the records,

Also just confirm that the status you are passing is '51' or say '0051' , like this you may try your query first in SE11 or SE16N

I hope this will definatly help you,

Rani