SAP Knowledge Base Article - Public

3552320 - Data Extraction of Price Lists Not Generating Correctly the Number of Records

Symptom

The extraction file contains only a few records, despite having a large number of customer-specific price lists.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Navigate to the work center Application and User Management > Data Extraction.
  2. Click New to open the data extraction configuration screen.
  3. Input a Run ID and select the Extraction Object as FLEX_PRICE_LIST.
  4. Leave the Selection Criteria section empty.
  5. Click Save and Run.
  6. Wait for the run to end. The total number of extracted records will be lower than the number of price lists available in the system.

Cause

This behavior is expected for full data extraction of the Price List business object due to its specific framework.

Resolution

  1. Repeat the steps above up to number 4.
  2. Click Add Row in the Selection Criteria section and set the parameters as such:
    • Parameter Name: ID-CONTENT
    • Inclusion/Exclusion: Inclusion
    • Operator: Equal To
    • Lower Boundary:*
  3. Click Save and Run.

Please note that with Release 2502 we introduced a Filter Option:

You can now filter Sales Price Lists and Discount Lists that are in Released status and have a specific validity start date or validity end date along with the filter option Price List ID or Discount List ID using newly added data extraction objects , FLEX_DISCOUNT_LIST01-Discount List (with Filters) and FLEX_PRICE_LIST_1 - Price List (with Filters),

Selection criteria parameters:

  • Price List ID or Discount List ID
  • Status (Enter 3 for Released Status) (Other Statuses : 1- Not Released, 2-Partially Released, 5-Release Canceled)
  • Validity Start Date (should be maintained in YYYYMMDD format)
  • Validity End Date (should be maintained in YYYYMMDD format)

Keywords

Data extraction, Price list, FLEX_PRICE_LIST, ID-CONTENT, Inclusion, Equal To, Lower Boundary, Business ByDesign , KBA , SRD-MD-BP , Business Partner , How To

Product

SAP Business ByDesign all versions