How to restrict values in one prompt based on value from another prompt

Hi

I have a requirement as follows. I have two fields (objects)

program code
contract number

one program code can have several contract numbers.

I need to provide prompts on Program code and contract number. when user selects one program from the prompt on program code then contract field should only show contract numbers belonging the program user selected.

Please let me know how to bring this functionality in Webi report.

Consultant, needs help regarding “How to restrict values in one prompt based on value from another prompt “

SMSY system landscape data best practices

Dear SAP gurus,

Does anybody know where I can find System Landscape Data best practices/documentation for different SAP Solutions like SAP ERP, Solman, Portal, PI, etc?
I do not want to have info about how to set it up or achitecture etc… just information like:

• Can a technical system have more than one active product versions?For example SAP ERP 6.0, SAP EHP2 FOR NETEAVER 7.0, EHP5 FOR SAP ERP 6.0.
• What product instances should have SAP ERP6.0?

I need this information because Im struggling cleaning the data using LVSM and I get errors like:
“Some software components not covered by configured product instances”
“Product system <SID> has multiple active standalone product versions”

So I can make sure that all data in SMSY is correct which I am not sure…

Solution Manager Consultant, needs help regarding “SMSY system landscape data best practices “

Allocation Problem

Greetings Experts,

I am running BPC 7.5 MS. Happens to be SP3.

I am getting the following error when I attempt to run the below Allocation against a Category called “EX.PLAN1” and Time = 2012.FEB:

“– Merge WHAT with USING into WHERE

---

select u.ACCOUNT,u.BRANCH,w.CATEGORY,u.DATASRC,w.DEPARTMENT,u.LIFECYCLE,w.TIMEID,amtWHAT,amtUSING,amtWHAT*0 as amtWHERE
into #WHERE_313192 from #WHAT_313192 w,#USING_313192 u
where”

*RUNALLOCATION
*FACTOR=USING/TOTAL
 
*DIM ACCOUNT		WHAT=STSALES.INP;	WHERE=>>>;			USING=BAS(STSALES);		TOTAL=<<<
*DIM BRANCH		WHAT =WW.INP;		WHERE=>>>;			USING=BAS(WWNOAD);		TOTAL=<<<
*DIM CATEGORY					WHERE=<<<;			USING=CORE.ALLOC;		TOTAL=<<<
*DIM DATASRC		WHAT=INPUT;		WHERE=WWnoAdminAllocation;	USING=MINCRONGL;		TOTAL=<<<
*DIM DEPARTMENT		WHAT=D_NODEPT;		WHERE=<<<;			USING<>D_NODEPT;		TOTAL=<<<
*DIM LIFECYCLE		WHAT=L.WW.INP;		WHERE=>>>;			USINGL.WW.INP;			TOTAL=<<<
*DIM TIME		WHAT=%YEAR%.FEB;	WHERE=<<<;			USING=%YEAR%(-1).FEB;		TOTAL=<<<
*ENDALLOCATION
*COMMIT
 
 

It appears to me that after the last “where” in the above error, it would normally attempt to join the WHAT temp table with the USING temp table. In my example, NON of the dimensions match.

Any guidance would be appreciated.

SAP Consultant, needs help regarding “Allocation Problem “

Error calling data provider

Hello QnASAP,

I am having an issue while converting a SAP script to PDF.
Functionality is somewhat like this: Scripts output is generated and when user presses back button, it displays the file save dialog screen, user enters the name and path to be saved when save button is clicked, it gives *”Error Calling data provider“*which is a SY-SUBRC = 14 of Function module GUI_DOWNLOAD.

Code is somewhat like this:

data t_pdf like tline occurs 0 .
  data t_doctab like  docs occurs 0 .
  data fsize type i .
 
 
  

call function ‘CONVERT_OTF_2_PDF’

• EXPORTING
• USE_OTF_MC_CMD = ‘X’
• ARCHIVE_INDEX =

importing
bin_filesize = fsize
tables
otf = t_otfdata
doctab_archive = t_doctab
lines = t_pdf
exceptions
err_conv_not_possible = 1
err_otf_mc_noendmarker = 2
others = 3
.
if sy-subrc 0.
message id sy-msgid type sy-msgty number sy-msgno
with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
endif.

• Download to local file

if not t_pdf[] is initial .
DATA: l_filename1 TYPE string,
l_filen TYPE string,
l_path TYPE string,
l_fullpath TYPE string,
l_usr_act TYPE I.

CALL METHOD CL_GUI_FRONTEND_SERVICES=>FILE_SAVE_DIALOG

IF sy-subrc = 0
AND l_usr_act
CL_GUI_FRONTEND_SERVICES=>ACTION_CANCEL.

CALL FUNCTION ‘GUI_DOWNLOAD’
EXPORTING
BIN_FILESIZE = fsize
FILENAME = l_fullpath
FILETYPE = ‘BIN’

• APPEND = ‘ ‘
• WRITE_FIELD_SEPARATOR = ‘ ‘
• HEADER = ’00’
• TRUNC_TRAILING_BLANKS = ‘ ‘
• WRITE_LF = ‘X’
• COL_SELECT = ‘ ‘
• COL_SELECT_MASK = ‘ ‘
• DAT_MODE = ‘ ‘
• CONFIRM_OVERWRITE = ‘ ‘

NO_AUTH_CHECK = ‘X’

• CODEPAGE = ‘ ‘
• IGNORE_CERR = ABAP_TRUE
• REPLACEMENT = ‘#’
• WRITE_BOM = ‘ ‘
• TRUNC_TRAILING_BLANKS_EOL = ‘X’
• WK1_N_FORMAT = ‘ ‘
• WK1_N_SIZE = ‘ ‘
• WK1_T_FORMAT = ‘ ‘
• WK1_T_SIZE = ‘ ‘
• WRITE_EOL = ABAP_TRUE
• IMPORTING
• FILELENGTH =

TABLES
DATA_TAB = t_pdf[]

• FIELDNAMES =

EXCEPTIONS
FILE_WRITE_ERROR = 1
NO_BATCH = 2
GUI_REFUSE_FILETRANSFER = 3
INVALID_TYPE = 4
NO_AUTHORITY = 5
UNKNOWN_ERROR = 6
HEADER_NOT_ALLOWED = 7
SEPARATOR_NOT_ALLOWED = 8
FILESIZE_NOT_ALLOWED = 9
HEADER_TOO_LONG = 10
DP_ERROR_CREATE = 11
DP_ERROR_SEND = 12
DP_ERROR_WRITE = 13
UNKNOWN_DP_ERROR = 14
ACCESS_DENIED = 15
DP_OUT_OF_MEMORY = 16
DISK_FULL = 17
DP_TIMEOUT = 18
FILE_NOT_FOUND = 19
DATAPROVIDER_EXCEPTION = 20
CONTROL_FLUSH_ERROR = 21
OTHERS = 22
.

ENDIF.

• End of changes by TSOSSKUMAR change request <DV2K945761>

if sy-subrc 0.
message id sy-msgid type sy-msgty number sy-msgno
with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
endif.
endif .

ABAP Consultant, needs help regarding “Error calling data provider “

Can we install BO 3.1 and BI 4.0 clinet tools on one desktop machine ?

Hi I am currently working on BO 3.1 for development purpose and we are going for Bi 4.0 upgrade.So can I have (install) both BO 3.1 and BI 4.0 BOBJ client tools on my desktop at the same time ?

Consultant, needs help regarding “Can we install BO 3.1 and BI 4.0 clinet tools on one desktop machine ? “