Find Sybase(ASE) Database version
Use the following command to determine the Sybase database version installed.
Select @@ version
go
Or use below command
sp_version
go
Select @@ version
go
Or use below command
sp_version
go
Start and Stop Max DB
Start and Stop Via DBMCLI
The dbmcli commands to start/stop MaxDB Instance.
Shutdown:
dbmcli –d <db_name> -u <dbm_user>,<password> db_offline
Restart:
dbmcli –d <db_name> -u <dbm_user>,<password> db_online
What is SAP ALV?
ALV stands for ABAP List Viewer. ALV gives us a standard List format and user interface to all our ABAP reports. ALV is created by a set of standard function modules provided by SAP.
ALV provides a lot of inbuilt functions to our reports and some of the functions are listed below.
- Sorting of records
- Filtering of records
- Totals and Sub-totals
- Download the report output to Excel/HTML
- Changing the order of the columns in the report
- Hide the unwanted columns from the report
Because of the above functions, ALV substantially decreases the report development time. ALV takes care of rendering the list and we can concentrate only on the data retrieval part.
Some of the function modules used to create ALV reports are listed below.
| FUNCTION MODULE | DESCRIPTION |
|---|---|
| REUSE_ALV_LIST_DISPLAY | Display an ALV list |
| REUSE_ALV_GRID_DISPLAY | Display an ALV grid |
| REUSE_ALV_COMMENTARY_WRITE | Output List header information |
| REUSE_ALV_VARIANT_F4 | Display variant selection dialog box |
| REUSE_ALV_VARIANT_EXISTENCE | Checks whether a variant exists |
| REUSE_ALV_FIELDCATALOG_MERGE | Create field catalog from dictionary structure or internal table |
Simple ALV report.
DATA: it_spfli TYPE TABLE OF spfli.
SELECT * FROM spfli INTO TABLE it_spfli.
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
EXPORTING
i_structure_name = 'SPFLI'
TABLES
t_outtab = it_spfli.
Simple ALV Output List
SAP Transport Return Code Status
RC = 0, successfully imported.
RC = 4, imported ended with warning.
Common issue:
• Generation of programs and screens
• Columns missing and Rows missing.
Common issue:
• Generation of programs and screens
• Columns missing and Rows missing.
RC = 8, not imported ended with error
Common issue:
• Syntax error.
• Program generation error.
• Dictionary activation error.
• Method execution error.
Common issue:
• Syntax error.
• Program generation error.
• Dictionary activation error.
• Method execution error.
RC = 12, import is cancelled.
Common issue:
• Import is canceled due to object missing.
• Objects are not active.
• Program terminated due to job “RDDEXECL” is not working.
• Connection problem between system.
Common issue:
• Import is canceled due to object missing.
• Objects are not active.
• Program terminated due to job “RDDEXECL” is not working.
• Connection problem between system.
RC = 16, import is cancelled.
Common issue:
• Import cancelled due to system down while importing.
• Import cancelled due to user expires while importing
• Import cancelled due to insufficient roles.
Common issue:
• Import cancelled due to system down while importing.
• Import cancelled due to user expires while importing
• Import cancelled due to insufficient roles.
How to generate SAP Solman Key without having Solution manager
You might want to install SAP ECC 5 or SAP ECC 6 and been asking
SolmanKey. What if you don't have Solman Server ? Then how would you generate
solman key ? There are 2 ways (if you don't have Solman Server to generate
solman key) :
1. Ask your friend which have Solman Server to generate it. OR
2. Use this simple script (VB Script) to generate it.
' Solution Manager Key Generator '
Open Notepad and copy this Script and save it .vbs
'Save to SolManKeyGen.vbs and execute'
1. Ask your friend which have Solman Server to generate it. OR
2. Use this simple script (VB Script) to generate it.
' Solution Manager Key Generator '
Open Notepad and copy this Script and save it .vbs
'Save to SolManKeyGen.vbs and execute'
Dim SIDs, SNs, SERVs,
msg, ENDs, KEYs
msg="System ID (3 chr.)"
SIDs=InputBox(msg,"Solution Manager Key Generator")
msg="System Number (2 dig.)"
SNs=InputBox(msg,"Solution Manager Key Generator")
msg="Server Name (max. 15 chr.)"
SERVs=InputBox(msg,"Solution Manager Key Generator")
KEYs=SolManKeyGen(SIDs, SNs, SERVs)
msg="Solution Manager Key"
ENDs=InputBox(msg,"Solution Manager Key Generator",KEYs)
'-------------------------------------------------------
Function SolManKeyGen(SIDst, SNst, SERVst)
Dim SIDSNhex(5)
Dim SERVhex(15)
Dim reshex(5)
SIDSNstr = UCase(SIDst) + UCase(SNst)
SERVstr = UCase(SERVst)
For arrcnt = 1 To 5
SIDSNhex(arrcnt) = Asc(Mid(SIDSNstr, arrcnt, 1))
Next
For arrcnt = 1 To Len(SERVstr)
SERVhex(arrcnt) = Asc(Mid(SERVstr, arrcnt, 1))
Next
For arrcnt = Len(SERVstr) + 1 To 15
SERVhex(arrcnt) = 0
Next
If (Len(SERVstr) > 0) Then
If (Len(SERVstr) < 5) Then
For arrcnt = Len(SERVstr) + 1 To 5
SERVhex(arrcnt) = Asc(" ")
Next
End If
End If
If (Len(SERVstr) > 5) Then
If (Len(SERVstr) < 10) Then
For arrcnt = Len(SERVstr) + 1 To 10
SERVhex(arrcnt) = Asc(" ")
Next
End If
End If
If (Len(SERVstr) > 10) Then
If (Len(SERVstr) < 15) Then
For arrcnt = Len(SERVstr) + 1 To 15
SERVhex(arrcnt) = Asc(" ")
Next
End If
End If
For arrcnt = 1 To 5
reshex(arrcnt) = ((((0 Xor SIDSNhex(arrcnt)) Xor SERVhex(arrcnt)) Xor
SERVhex(arrcnt + 5)) Xor SERVhex(arrcnt + 10))
Next
reshex(1) = reshex(1) Xor 84 Xor 0
reshex(2) = reshex(2) Xor 131 Xor 11
reshex(3) = reshex(3) Xor 194 Xor 46
reshex(4) = reshex(4) Xor 52 Xor 105
reshex(5) = reshex(5) Xor 119 Xor 188
hexstr = "0123456789ABCDEF"
resstr = ""
For arrcnt = 1 To 5
hihex = reshex(arrcnt) \ 16
lohex = reshex(arrcnt) Mod 16
resstr = resstr + Mid(hexstr, hihex + 1, 1) + Mid(hexstr, lohex + 1, 1)
Next
SolManKeyGen = resstr
End Function
How to change the default SAP GUI client number
You need to change an instance profile parameter on the R/3 system.
Goto :TCODE RZ10,
Goto :TCODE RZ10,
login/system_client The default value is 000.
Which Client you want change client value like 300,800,000,.
How to increase Dialog work process time in SAP
Goto transaction code RZ11, enter the parameter name – rdisp/max_wprun_time and press enter. Once you get the below screen, click on Change Value and enter the desired time. Please not to set the value to 0 as it will make the running time unlimited.
No restart required as the parameter is dynamically switchable. For permanent change, please do it on transaction code RZ10. You can refer to SAP Note 25528.
No restart required as the parameter is dynamically switchable. For permanent change, please do it on transaction code RZ10. You can refer to SAP Note 25528.
How to Modify SAP Transport Number Range
You want to change the transport number range on the SAP System.
SAP stored the last transport request in the table E070L. You can find the information using transaction code SE16 or SE16N.
Due to non-modifiable function on transaction code SE16/SE16N, you may need to update the table from database level. Below example is on Oracle database. If let say, the latest transport number from table E070L is SIDK800111 and you wanted to change to SIDK000121.
ABAP
,
BASIS
,
SAP Beginners
Subscribe to:
Posts
(
Atom
)
