How to create project : SPRO

 

1. Go to transaction : SPRO

 

2. Select Menu [Go to > Project Management]

 

3. Click Create Project and input project name.

4. Click button “Change selection…” and Select components.

5. Click button “Generate Project IMG” and Save.

How to SECATT

 

1. Go to transaction “SECATT”

2. Create Script

2.1 Check Test Script and input script name.

2.2 Click button

3.

4.

5.

6. Create Parameter name in VALIN.

6.1 Select Import and click Yes.

7. Save Script.

8. Run Script.

8.1 Check Test Configuration and input script name.

8.2 Click button

9. Set value and save.

10. Click Download Variants.

11. Input data on excel.

12. Execute and set start mode.

13. Input path and execute.

Error : Unable to open module file

 

 

Description

When we try opening an existing solution, every project inside this solution has the following error: Unable to open module file 'C:\Users\USER123\AppData\Local\Temp\2\.NETFramework,Version=v4.0.AssemblyAttributes.vb': System Error &H80070002& C:\Users\USER123\AppData\Local\Temp\2\.NETFramework,Version=v4.0.AssemblyAttributes.vb

 

 

This issue is still happening with VS2012 as well.
Steps to reproduce:

1. Create a project/application using .NetFramework 4.5
2. Close VS2012
3. Navigate to Temp Folder (C:\Users\xxxxx\AppData\Local\Temp)
4. Delete the .NETFramework,Version=v4.5.AssemblyAttributes.vb file
5. Restart VS2012 and Start debug.

 

 

URL : https://connect.microsoft.com/VisualStudio/feedback/details/515041/unable-to-open-module-file-when-an-existing-solution-is-loaded

How to changing default collation of SQL Server

1. Now open command prompt as Administrator user and navigate to the Setup.exe on installation media or local copy of setup.exe. In default installation setting; you’ll find this file here: (ตำแหน่งของไฟล์ Setup โปรแกรม SQL Server)


2. Next the command you want to run has following syntax:
Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=<Your Instance Name> /SQLSYSADMINACCOUNTS=<Your SQL SYS Admin account> [ /SAPWD=<Password> ] /SQLCOLLATION=<Your New SQL Collation name>

Ex. setup /QUIET /ACTION=RebuildDatabase /INSTANCENAME=”SQLEXPRESS” /SAPWD=”password user sa” /SQLCOLLATION=”SQL_Latin1_General_CP1_CI_AS” /SQLSYSADMINACCOUNTS=”user admin on PC”

3. Hit enter and you are done.


URL : http://www.carryoverbit.com/changing-default-collation-of-microsoft-sql-server-2012/

Linked Server

 

Linked Server in SQL Server Management Studio.

 

Ex. Select Query

select * from [SAPDEV]..[SAPDEV].[ZHST_MID]

 

Ex. Insert Query

INSERT into  OPENQUERY (SAPDEV, 'select * from SAPDEV.ZHST_MID')
values ('210','M002','Test','TT',' ',' ',' ')

INSERT OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles')
VALUES ('NewTitle')

Ex. Update Query

UPDATE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE id = 101') 
SET name = 'ADifferentName'

Ex. Delete Query

DELETE OPENQUERY (OracleSvr, 'SELECT name FROM joe.titles WHERE name = ''NewTitle''')

SAP Enhancements

Using SMOD you can search for enhancement and there component. Components includes Function Exit, Function Codes, Program,Calling Screen...so basically all exits.
CMOD allows you to create Project for your enhacement. In order to activate every exit code you need to create a project for same and activate it...Eventhough if you write a code and do not create a project for same your exit code will not reflect.

Ex. SMOD


Ex. CMOD

SAP Barcode

Location File .exe
\\SVSAPAPP01\CCSSAPAddon

Location VB.Net
\\SVSAPAPP01\IT_App\VB

Program Barcode in SAP se80
ZSD_BARCODE_AXCELIS