Copy field from access table to SAP cc01 (1 Viewer)

S

Shiva Kemkar

Registered User.

Local time

Today, 19:43

Joined

May 16, 2018

Messages

31

• May 25, 2018

• #1

Hello,

I have a access table which is storing the change number and description and would like to link that with SAP transaction cc01.

on click of add change number in the access form, it should auto-logon to SAP and copy the change number and description from the form and create the change number in SAP.
Any suggestion please

 

Ranman256

Well-known member

Local time

Today, 10:13

Joined

Apr 9, 2015

Messages

4,339

• May 25, 2018

• #2

is the SAP data tables linked into Access via ODBC?
or
are you trying to input the data into SAP using the SAP frontend app?

 

S

Shiva Kemkar

Registered User.

Local time

Today, 19:43

Joined

May 16, 2018

Messages

31

• May 25, 2018

• #3

Hello Ranman,

The table is not linked to SAP. Yes, i want to input data using SAP front end.

Thanks

 

S

Shiva Kemkar

Registered User.

Local time

Today, 19:43

Joined

May 16, 2018

Messages

31

• May 25, 2018

• #4

i Have Change_Number and Change_Description on the access form which should be copied to SAP CC01.
Also add valid from date field in SAP. Request you to post some script which will help me to do this. Thanks

 

Minty

AWF VIP

Local time

Today, 15:13

Joined

Jul 26, 2013

Messages

10,368

• May 25, 2018

• #5

Unless SAP has some form of macro API I doubt you can do this in Access.
You might be able to do it through the SAP server (Is SAP SQL based ?)

 

S

Shiva Kemkar

Registered User.

Local time

Today, 19:43

Joined

May 16, 2018

Messages

31

• May 25, 2018

• #6

not sure Minty, i am using SAP logon 740.