DEMO tables empty (SFLIGHT etc.), report to fill?

[Former Member]

Hi,

I'm on a SAP R/3 Enterprise system where the demo tables are empty. Does anyone know how to get them filled? (SFLIGHT, SCUSTOM, SPFLI etc.)

I tried to use RSBCDAT3 but this report is not available.

Regards,

Hans

[abdul_hakim]

hi

these tables will only have full fledged values only in

<b>IDES version</b>.

Cheers,

Abdul Hakim

[Former Member]

Hi ,

  try this

data : i_sflight like sflight occurs 0 with header line. 
select *  from sflight client specified into table i_sflight 
 where mandt eq '000'. 

loop at i_sflight. 
move sy-mandt to i_sflight-mandt. 
modify i_sflight. 
endloop. 

modify sflight from table i_sflight.

In short - All the demo tables have data in client 000.

[vinod_gunaware2]

SAPBC_GLOBAL_SFLIGHT_CREATE SFLIGHT - Create Table Entry

SAPBC_GLOBAL_SFLIGHT_DISPLAY SFLIGHT - Display Table Entry

SAPBC_GLOBAL_SFLIGHT_EDIT SFLIGHT - Change Table Entry

SCOL_REF_FLIGHT_INSERT REF FLIGHT: Insert

SFLIGHTL Demo Program for Reloading Flight Booking Data

regards

vinod

[Former Member]

check this report

<b>SAPBC_DATA_GENERATOR</b>

[Former Member]

Thanks all,

The generator programs works, and the data was also available in 000.

Regards,

Hans

[Former Member]

Pl. let ke know the steps for generating data.

Since I execute SAPBC_DATA_GENERATOR from se38 I got error saying this is not report prog.

[Former Member]

NITIN,

Use transaction BC_DATA_GEN. This starts the report.

Regards,

Hans van der Kooij

[Former Member]

Hans,

I am afraid, the transaction or report BC_DATA_GEN does not exist. I am on 4.6c training version.

Long time age I had generated same data, now I forgot the prog name.

Thanks

[Former Member]

MiniSAP 4.6D uses program S_FLIGHT_MODEL_DATA_GENERATOR.

MiniSAP 6.20 uses program SAPBC_DATA_GENERATOR.

MattG.

[Former Member]

Guys, when i ran this (sapbc_data_generator) i got a whole load of number range dumps 'error on number_Get_next'. Is there some preconfig that has to be done?

Thanks

[Former Member]

Andy,

Directly from the help on this report:

The report requires the following number range intervals:

SBOOKID, SCUSTOMID, SBUSPID, SFLTRIPID. You may have to create these (transaction SNRO) before executing the report.

If no number range intervals exist for these number range objects, the data generator creates them (in each case, interval 01 with internal number assignment, partly with subobjects, numbers from 1 to 2000000).

[emmanuel_fuentes]

Thanks Matthew, your tip was very useful.

[former_member184158]

Hi All,

on Hana, the FM "SAPBC_DATA_GENERATOR" does not exist. so what I have done,

Se38--> SAPBC_DATA_GENERATOR --> execute and it works fine,

this is only for hana user how faces the problem and they can not fill sflight on Hana,

Regards

[former_member184158]

This message was moderated.

[SAURABH99]

'SAPBC_DATA_GENERATOR' is the program provided by SAP to fill these tables in your system, which can also be accessed through the standard transaction 'BC_DATA_GEN'.

Advisable, that you run this program/transaction in background mode.

Regards,

Saurabh