#TRANSTYPE 3 CODE#

#TRANSTYPE 3 CODE#

A long, long time ago I learned this lesson вЂ“ in a new version (2007!) of SAP B1, SAP introduced a new code on a table. However, I believe one technique you should always use while doing CASE is what I call the вЂњescapeвЂќ or вЂњresearchвЂќ portion of the CASE (see second bolded below). Comment or remove those fields when you go to finalize the SQL (see first line bolded below). Itis a good idea to include the fields in the CASE when drafting the SQL вЂ“ helps to identify how things are being handled. PROVIDING A WAY TO IDENTIFY MISSING INFORMATION/CODES. I have dozens of these in a Word Document so I can just copy them into SQL while writing, and that saves a lot of time!!! If you have any CASE you think would be helpful to others as вЂњtemplatesвЂќ, please do share with everyone and post it below as a Comment. You can use CAST and CONVERT and ISNULL and many other SQL parts in the CASES for Numeric Value below вЂ“ I am keeping it simple right now, and am presenting simple CASEs.В Some CASEs you write will need to check three or four data fields to come up with the correct displayed value (and it is important how you write that type of CASE in the way it is ordered) вЂ“ doing three and four data fields is too much to do in this blog as it can get very complicated, depending upon what you are doing. You might need to change some of the CASEs given below, or you might want to modify the SQL to your own preferences. Just a reminder that this blog is to introduce a concept. Very handy when writing any kind of report for the End Users вЂ“ just copy it in and onwards you go. I have a Word Document, about 8 pages long, with various CASEs used while writing SQL. All Marketing (Sales вЂ“ A/R and Purchasing вЂ“ AP) use the same data fields names such as DocStatus, so most of the below CASEs can be used as templates. Many of them are interchangeable with various tables. The CASEs in this blog are some commonly requested types of CASE Statements in the Forum. And you use END to let the SQL know you are finished with your IF/THEN lines. You must tell SQL first that you are about to do the IF/THEN by using the word вЂњCASEвЂќ. What a CASE does is group together statements of вЂњIF something is this THEN do thisвЂќ (display a name, term, perform a calculation, display a value, etc.). The concept can not only provide better descriptions, it can provide accurate values, handle exceptions correctly, can perform the correct calculation, and can also act as a filter when End Users (or yourself) are вЂњslicing and dicingвЂќ the SQL results. Instead of having an вЂњOвЂќ under a DocStatus column, you can display the word of вЂњOpenвЂќ. The CASE function in SQL is a great way to customize the output of your SQL to better suit the needs of your End Users. She has a great start, but we are going to get her up to the next level, and one way is going to be the usage of CASE in her new SQL. Am currently working with an individual, hoping to help her improve her SQL skills.

Transtype 3