Select language:
Entering content frame!--a11y-->

Procedure documentation Load Master Data into SAP BW 

Use

For the InfoObjects 0material, 0plant and 0mat_plant, master data must be transferred to the BW System. Master data is optional for the attributes of these InfoObjects.

Procedure

Transfer from SAP R/3 to SAP BW

If the Leading Master Data System is an SAP R/3 System, perform the following steps in SAP BW to transfer master data for 0material and 0plant:

...

  1.  Execute transaction RSA1 (Administrator Workbench: Modeling).

  2.  Move to InfoSources.

  3.  Assign the DataSource 0ARTICLE_ATTR to the InfoSource 0MATERIAL.

  4.  Select the source system and create a Full-Update-InfoPackage.

  5.  Schedule the Full-Update-InfoPackage to transfer master data for 0material into BW.

Repeat the above steps for the following:

·  DataSource 0ARTICLE_TEXT and InfoSource 0MATERIAL

·  DataSource 0PLANT _ATTR and InfoSource 0PLANT

·  DataSource 0PLANT_TEXT and InfoSource 0PLANT

·  DataSource 0MAT_PLANT_ATTR and InfoSource 0MAT_PLANT

·  DataSource 0MAT_PLANT_TEXT and InfoSource 0MAT_PLANT

·  DataSource 0CLASS_NUM_TEXT and InfoSource 0CLASS_NUM (if you need values for the attributes 0rpa_wgh1, 0rpa_wgh2, 0rpa_wgh3 and 0rpa_wgh4 of 0material)

Transfer via Flat File

If the master data 0material, 0plant and 0mat_plant must be loaded by a flat file into BW, perform the following steps in the SAP BW System:

...

...

  1.  Execute transaction RSA1 (Administrator Workbench: Modeling).

  2.  Move to InfoSources.

  3.  Assign a DataSource to the InfoSource for 0material and select the file system as the source system.

  4.  Choose the External Data tabstrip for the Full-Update-InfoPackage.

  5.  Maintain all required settings for the flat file.

  6.  Schedule the Full-Update-InfoPackage to transfer the flat file to BW.

  7.  Execute the same steps for the InfoSource 0plant, 0mat_plant and 0class_num.

Transfer from SAP SCM to SAP BW

To transfer master data for the InfoObject 0mat_plant from the SAP SCM System, perform the following steps in the BW System:

...

  1.  Execute transaction RSA1 (Administrator Workbench: Modeling).

  2.  Move to InfoSources.

  3.  Assign the DataSource 0FRE_MATPLANT_ATTR to the InfoSource 0MAT_PLANT.

  4.  Select the source system and create a Full-Update-InfoPackage.

  5.  Schedule the Full-Update-InfoPackage to transfer the master data for 0mat_plant from SCM into BW.

Note

Values are optional for all other InfoObjects in the various InfoProviders of F&R and POS. Deciding whether to fill them with data depends on what you want to accomplish in the F&R solution. It is possible that the information is updated in the InfoProviders but cannot be selected in the queries.

See also

For more information about assigning DataSources to InfoSources, see the SAP Library under SAP NetWeaver ® SAP Business Information Warehouse ® Administrator Workbench ® Modeling ® Source System ® Data Extraction from SAP Source System ® Data Source System.

For more information on InfoPackages, see the SAP Library under SAP NetWeaver ® SAP Business Information Warehouse ® Administrator Workbench ® Administration ® Scheduler.

 

 

Leaving content frame