how to find document no. using FM in sap crm?

[sap_beginner98]

Hello,everybody

I want to create a report in ERP using document(excel files).

But I don't know how to get the documen id which is in CRM.

( inputs: Status,guid,etc.

outputs: document no.)

Is there anyone who can give me some advice?

[michael_piesche]

• Please be more specific on what your Inputs are.
  What status are you referring to and what is the GUID from?
• What documents and from what objects do you want to get these from CRM?
• What is the purpose of your report?
  "using documents" is not very helpful in fully describing the purpose.
  Do you want to simply view the document from CRM in ERP or download it to the local machine in ERP?

[MateuszAdamus]

Hi sap_beginner98

What sort of document?
If it's one of the sales document you can have a look at the CRM_GUID field in VBAK. It might contain the CRM GUID value.

regards,

Mateusz