Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Delphi7 and Sql statment

hi al Friends this is my first post, my question is simple:

How to do a select similar to:

SELECT BUKRS KUNNR BELNR GJAHR BUZEI WRBTR WAERS

INTO-CORRESPONDING FIELDS OF TABLE TBSID

FROM BSID

WHERE: KUNNR IN S_KUNNR,

BUKRS = P_BUKRS,

i am work with ActiveXcomponent, and have this code:

procedure TForm1.SAPLogonControl1Click(Sender: TObject);

begin

Connection := SAPLogoncontrol1.newConnection;

(* In some GUI-versions the username *)

(* must be written in uppercase !!! *)

Connection.User := AnsiUpperCase('XXXXX'); //Ok

Connection.System := 'XXX'; //Ok

Connection.Client := '400'; //Ok

Connection.ApplicationServer := '192.168.1.71'; //

Connection.SystemNumber := '44'; //Ok

Connection.Password := 'xXxXxXxX'; //Ok

Connection.Language := 'EN' ; //Ok

Connection.SAPRouter :='/H/188.122.133.22/H/'; //Ok

SAPLogonControl1.Enabled := false;

if Connection.LogOn(0,true) = true then

(* parameter "true" : SilentLogOn *)

begin

ShowMessage('Logon O.K.');

Button1.Enabled:= true;

end

else

begin

ShowMessage('Error on logon :-(((');

SAPLogonControl1.Enabled:=true;

end;

end;

my connection work: say me: ShowMessage('Logon O.K.');

my question is wich is the next step for execute a normal Sql statment?

i am interested in get all the (journalentries) accounting registers (accounting policy)

thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question