Exporting Vendor or Customer Master Data 

Use

In order to assign D-U-N-S Numbers to your vendors/ customers, forward all vendor or customer master data to D&B for rationalization. D&B match all vendors/ customers to a unique D-U-N-S Number during rationalization. 

The rationalization process requires a flat file. To extract the relevant master data from BW, BW contains an extraction program that creates an export file in ASCII format. The program downloads a query result to a database table and from there to a flat file on the application server. All vendors in the master data table are included in the export file.

Before starting the program, you can determine how D&B will process your data . For each value of the match recommended flag 0DB_MATCH – flag is filled with X or not – you can choose between the following options:

·        Refresh

·        New Match

·        No match. Use this option if another refresh is not required, either because a match has previously failed or because the last refresh has been relatively recent

For each record in the flat file, the action flag is set accordingly to R (Refresh), M (new Match) or N (No match).

Prerequisites

You have successfully performed the previous steps of the upload process.

Procedure

To export the vendor or customer master data, proceed as follows:

...

Select transaction se38.

Choose the extraction program RS_BCT_DB_CREATE_TAB_AND_FILE and execute the program.

Enter the name of the database table to which the master data will be downloaded. You can overwrite the default table name DBFILE.

Enter the name of the BW Export file. You can overwrite the default filename DBFILE.ASCII.

Choose the required option for records where the match recommended flag is filled with X (Refresh, New Match or No match).

Choose the required option for records where the match recommended flag is not filled (Refresh, New Match or No match).

Click on the Execute icon to generate the flat file.

The vendor master data is extracted using the query 0PUR_C01_DB_Q04. The customer master data is extracted using the query 0PUR_C01_DB_Q04 You find the resulting flat file on the application server using transaction al11 in the default directory, for example your home directory DIR_HOME.

If you want to check the structure of the export file, you can use transaction se11 to display the RSDBEXPORTFILE database table. The database table structure corresponds to the export file structure.

Send the flat file to D&B.