Kontakt

Ansicht
Dokumentation

PROD_SUBSTN_EXCLN_UPLOAD_DWNLD - Product Substitution and Exclusion: Download and Upload Mass Data

PROD_SUBSTN_EXCLN_UPLOAD_DWNLD - Product Substitution and Exclusion: Download and Upload Mass Data

RFUMSV00 - Advance Return for Tax on Sales/Purchases   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.
SAP E-Book

Use

You can use this Online report to download and upload data for product substitutions and product exclusions. This report allows you to upload data only in the prescribed template format provided by SAP. SAP provides separate templates for uploading product substitution and exclusion data. Download the specific template and populate it with the required data.

You can also download application-area specific substitution data. For example, you can choose to download only aATP relevant substitution data or eSPP relevant substitution data, or both.

The report displays the Application filter section only if the eSPP application-area is activated. If the eSPP application-area is not activated, by default you can download only aATP relevant substitution data.

Downloading data

To download data, proceed as follows:

  1. In the Processing Options section, select the type of data that you want to download.
  2. In the General Actions section, select Download Data. The filter criteria selection section appears.
  3. To download specific data, fill the required selection criteria fields. Note: This step is optional. You can skip this step if you want to download all the records.
  4. If you want to download application-area specific substitution data, in the Application section, select the required checkbox. For example, you can select aATP Relevant or eSPP Relevant.
  5. Click Execute icon.

Downloading templates

To download a required template, proceed as follows:

  1. In the Processing Options section, select the required template that you want to download. For example, Product Substitution.
  2. In the General Actions section, select Download Template.
  3. Click Execute icon.

Uploading data

To upload data, proceed as follows:

  1. In the Processing Options section, select the type of data that you want to upload.
  2. In the General Actions section, select Upload XLSX File.
  3. In the Execution section, select one of the following:
    1. Display Excel Data - Select this option if you want to upload the data and view it.
    2. Save Data - Select this option if you want to upload the data and save.
  4. Click Execute icon.

Instructions to fill the Excel sheet

Do not rename the header column(s), change the order of the columns, add new column(s), or delete column(s).

Note: Only XLSX file format is supported.

Column-specific instructions

  • Substitution UUID: For new records, do not fill any value in this column. If you are updating existing records, then fill the existing Substitution UUID value in this column.
  • Plant: If the plant name starts with zeros, precede the plant name with a single quote character. For example: If the plant name is 0001, then fill the value as '0001 (the single quote character followed by the plant name).
  • Sequence: Fill only integer values. For example: 1, 2, 3.
  • Numerator for Conversion: Do not use decimal values. Fill only integer values. For example, 5.
  • Denominator for Conversion: Do not use decimal values. Fill only integer values. For example, 5.
  • Percentage: If required, you can use decimal values. For example, 10.45.
  • Valid From Date: Fill the date in the YYYYMMDD format. For example, 20200101.
  • Valid From Time: Fill the time in the HHMMSS format. For example, 143020. If the time starts with zeros, precede the time with a single quote character. For example: If the time is 010545, means it is 01Hours 05Minutes and 45Seconds, then fill the value as '010545 (the single quote character followed by the time).
  • Valid To Date: Fill the date in the YYYYMMDD format. For example, 20201231.
  • Valid To Time: Fill the time in the HHMMSS format. For example, 235959. If the time starts with zeros, precede the time with a single quote character. For example: If the time is 010545, means it is 01Hours 05Minutes and 45Seconds, then fill the value as '010545 (the single quote character followed by the time).
  • Status: By default, this field is set to blank. Use only the values A or O, or you can maintain it as blank.

For the following columns, fill the value X or you can leave it blank:

  • Exit Indicator

  • Lead Indicator

If the eSPP application-area is activated, the template includes the following columns:
  • aATP Relevant: Use the value X or you can leave it blank.

  • eSPP Relevant: Use the value X or you can leave it blank.

  • Direction of Interchangeability: By default, this field is set to blank. Use only the values F or I, or you can leave it blank.

  • Use-up Strategy: By default, this field is set to blank. Use only the values Y, N, R, or you can leave it blank.

  • Prod.Substn.Grp.Type: Fill only integer values. For example, 1, 2.

  • Replacement Type: maintain a valid type. For example, REMAN, GENERIC.

For the following eSPP related columns, fill the date in the YYYYMMDD format. For example, 20200101.
  • Use-up Date

  • Exhaustion Date

  • Successor Product Planning Date

  • Exhaustion Warning Date

  • Successor Product Receipt Date

  • Data Realignment End Date

  • Final Date






ROGBILLS - Synchronize billing plans   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.

Length: 7676 Date: 20240531 Time: 215113     sap01-206 ( 106 ms )