Order search based on appointment types

[Former Member]

Hi Gurus,

I need to find orders based on one appointment type date range, please let me the know FM or Tables that can be used. Thanks in advance.

[Former Member · Accepted solution]

The links are in the table CRMD_LINK (between the date table and CRMD_ORDERADM_H or I).

And I think the third table I gave should be the one for your problem.

Regards,

Benoî

[Former Member · Accepted solution]

Thanks for the quick reply, third table SCAPPTSEG can get me the link between the tables.

Thanks a lot Benoît.

[Former Member]

Hello Feroz,

You can have Appointment data in these tables :

SCGENAPPT

SCAPPT

SCAPPTSEG

And to read them for a particular order you can use the MF CRM_DATES_READ_SINGLE_OW.

Regards,

Benoî

[Former Member]

Thanks for the reply. I went through the table but couldnt identify the links between those tables and CRMD_ORDERADM_H and i would like to explain in detail.

Following is my requirement

Search Criteria: APPOINTTYPE: 'ZSTART_DATE'

Date Range : '01/01/2008' to '31/01/2008'.

and the Result should be : ORDER GUIDs or Object IDs.