To make this easy to work with, you must use the name DTW wants. You'll notice here the last two columns, where you'd expect the SQL column for OITM, SellItem and AvgPrice has a different name: SalesItem and AvgStdPrice. Notice what DTW thinks should be a column name and what we might expect is not the same. P10001 PC - 8x core, DDR 32GB, 2TB HDD Y 1495.95ĭTW maps the names in the header to columns it knows and then puts the data in the correct row and column.
DTW SAP BUSINESS ONE CODE
Code (ItemCode) Description (ItemName) Sales Item(SellItem) price(AvgPrice) DTW and similar applications also use the header descriptions to figure out where data is going and check what type it is, so quotes are even less necessary to decide between text, dates, and numbers. The original use of the quotes to handle the comma in the description is not as necessary here. One common one is a tab, to create the tab-separated value "Code (ItemCode)" "Description (ItemName)" "Sales Item(SellItem)" " price(AvgPrice)"
Other delimiters besides commas started to show up. Some CSV files go one step more and add a header to explain the columns "Code (ItemCode)", "Description (ItemName)", "Sales Item(SellItem)", "price(AvgPrice)" This is the basic comma separated value you'll find as.
If we had numbers, say average prices, they would remain outside of quotes, and be only digits and decimal points, avoiding the comma thousand separator. The system thinks there are five, not three columns. How do we designate three columns? By using quote marks for all strings. We only want three columns, but the extra two commas in the description mess up the reading of this. For example what if I had a row like this one? P1001,PC - 8x core,DDR 32GB, 2TB HDD, Y One answer is to separate the columns with commas. Here's a question: how do you make a line of text to correspond to a row in a database table? Since 1963, this is the ASCII character set, later to be extended to the ANSI character set. In Excel, we see this: Now suppose you only have basic keyboard characters to work with. There's also a A text description and a Y or N if it is a sales item. Each row has an identifier or primary key, the code. For simplicity, let's look at three columns in my list, code, description, and sales item. If you just want instructions you can skip to the next part, but it won't make as much sense.ĭTW uses tab delimted text.
That will help you later when we talk about some of the precautions you should make with your data. Prelude: Getting good data for tab delimitedīefore we go through the steps, I want to explain what happens in DTW. Whether you are a channel partner, consultant, or user, running DTW yourself, or having someone else do it, getting the preparation work done right will save you a lot of time and effort down the road. Preparation is the most critical step to get right.
DTW SAP BUSINESS ONE HOW TO
With the data changed, This time I'll show you how to prepare your data for import in DTW.
I picked an example of preparing for MRP implementation. In the last newsletter, We exported data from an SAP SQL Query and changed it for a mass change.
0 kommentar(er)
