SAP B1 ERP and MRP software could be easily built-in with your Electronic Document Interchange channel, possibly for outbound (when you are buying goods from your suppliers) or inbound (when your consumers spots their orders in EDI code). In this small short article, we would like to give your SB1 EDI programming and deployment highlights:
1. EDI as preset length fields format. This is traditional EDI, when you have doc header, traces and trailer. All the fields have predetermined fixed duration and placement
2. EDI as XML. This is new trend, exactly where XML does the same position as fastened duration structure, described previously mentioned. If your EDI channel necessitates XML, you are possibly far more adaptable in the resources and coding procedures selection
3. Outbound EDI. You must either analysis SB1 tables framework, which is explained in SAP Organization Just one SDK. Yet another selection is to help method data in SB: See -> Process Info. If it is enabled, open up your Buy Buy and put the cursor above the field you want to export in EDI code – in the still left base corner you need to now see the table and the field names. To format your information in fixed subject length way, use Solid or Change SQL clauses. Preserve your EDI export in the text file – you need to contemplate deploying DTS (Information Transformation) package deal to extract information and save the file. For XML you have robust help in MS SQL Server 2005 or 2000
4. Inbound EDI. Right here we recommend DTW or SAP Business enterprise One particular Info Transfer Workbench. Nonetheless you do not use listed here CSV information (also typically referred as Excel templates). Here you deploy ODBC supply to MS SQL Server. From MS SQL facet you need to put together views or SQL stored processes. Yet again, deploy DTS package deal, which will first go your EDI file into SQL staging tables. Then from these tables, use See to put together the success for Workbench. To steer clear of linking and configuration problems, in your SQL watch – have area names to be the exact as in Workbench Excel template for the identical item, you are intending to integrate.
