Sending an IDOC to SAP – easiest/fastest way?

Assume as part of your business process, you obtain an IDOC from somewhere, in a flat-file format, as below, which you wand to send to SAP using the SAP adapter with the least amount of effort .. EDI_DC40 8000000000001064985620E2EDK01005 800000000000106498500000100000001E2EDK14 8000000000001064985000002000000020111000E2EDK14 8000000000001064985000003000000020081000E2EDK14 80000000000010649850000040000000200710E2EDK14 80000000000010649850000050000000200600 The SAP Adapter exposes an operation called SendIdoc (while browsing, this…


Receiving Idocs – getting the raw idoc data

Since the WCF based SAP Adapter is … well, WCF based, all data flowing in and out of the adapter is encapsulated within a SOAP message. Which means there are those pesky xml tags all over the place. If you want to receive an Idoc from SAP, you can receive it in “Typed” format (in…


Selecting LRAW fields using the SAP ADO Provider

I ran the following query a couple of days back: SELECT LRAWFIELD FROM Z_TEST_TABLE Z_TEST_TABLE is a table defined in my test SAP instance, and LRAWFIELD is a column of type LRAW and length 256. I was writing a unit test, and expected it to pass. Unfortunately, it failed! The value selected was only correct…


Validating SAP Client Libraries …

A number of customers have come back to us saying that error messages pop up when attempting to browse metadata in Visual Studio (the message being something to the tune of – “the binding could not be loaded”). Most of the time, it is due to the proper client libraries not being present. Irrespective of whether…


Date/Time handling in the Microsoft Biztalk.NET SAP Adapter (WCF).

SAP has the data types DATS and TIMS, which mean Date and Time respectively. DATS means YYYYMMDD, and TIMS means HHMMSS, with no timezone information being stored anywhere. However, the adapter, working with SOAP messages, accepts date/time values having timezone information in them. Besides, since both are exposed as xsd:datetime, the adapter can accept an…


Order of parameters for RFC operations?

The Adapter queries the SAP system for metadata for RFCs, and spews out a wsdl. The parameters for the RFC (as exposed in the wsdl) will appear in the following order – they will first be sorted into 4 groups, “Changing, Export, Import, Tables” (C, E, I, T) and then within each group, they will be sorted alphabetically….