Hi all,
Just in need of some help in creating a variable number of export files from a database.
The reason is i have a limit of the number of rows that each file can contain. in this case 3000 rows per file. I can create the file ok, but im having trouble dropping 3000 records into each...
that would rely on you having outlook running all the time.
since outlook is only a "mail client" if for example you were on holidays, the mail sent from SAP would sit in your mail server until you returned and opened outlook. Which would then action your code..
if you canb code in VB, i would...
Its not very straightforward!. I have been down this road before. Wanting to build a qry and have it run as a background job overnight to extract a report and dump it somewhere.
if you look on sdn.sap.com/forums you will see a number of posts in regards to how to set this up. From what i recall...
Ah...,
i see your issue. This type of report to the best of my knowledge cannot have a layout variant saved.
One alternative approach is to write an infoset Qry/ SAP Query using this same table
Use a ALV grid as the output
this will allow you to save a layout variant.
We have done this for...
ok,
if you dont have an SAP OSS signon, you cannot get to the SAP connector.
there are alternative products on the market. ive used on from these guys. http://rfcconnector.com/
its costs a little but its pretty good and does work with vb2005. It also has some neat tools for creating idocs...
also,
what about using SAP Query or Quick Query (SQ01)
you could write custom reports (info sets)
save them and run as a batch job via SM36
other ideas!
cheers
you cannot access SAP tables via odbc.
use the SAP .net connector
look on SAP for this.
Its an addin that allows you to make BAPI calls, ie: query some of the tables like customer master and material master.
if you look in SAP
run TCode BAPI and you will see all the BAPI's you can run...
yes there is. Variants by default cannot be saved unless you have the correct settings on your user profile
transaction code SU01
enter your user name
Goto the parameters tab
add the paramter ID
SD_VARIANT_MAINTAIN
and values : XXXX XXX XX
cheers
ive done vb.net app's that make BAPI calls to SAP. There are some standard BAPI's in SAP to read tables like customer master, material master and sales orders.
If you do a search on SAP for .net connector you will find there is a SAP.net connector for VB2003.
Note: this is version 2.0 this...
Hiya,
With regards to the crystal reports, you could publish these reports via crystal enterprise web application.
Or am i not understanding your problem
cheers
Hi All,
thanks for you help on this really!. I will try your suggestions out. Regarding the text odbc driver, yes went down that path, but unless your using a common delimter like "," you hit some brick walls
thanks again
Hiya
Thanks for your help, still trying to get my head round this
OK, so I have the following code that splits each line the splits inside that that as shown below.
But it doesnt loop through each line only the first line.
any help would be great
Dim strTemp() As String
Dim intLine As...
Hi all,
im just i need of help with splitting a file
The file looks like this
-------------------------------------------------------------------------------
OrderID|BillFirstname|BillLastname|BillCompany|BillAddress
1143658|Chris|Bell|Strutt & Parker|13 Hill St
1143659|Chris|Bell|Strutt &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.