Skip to Content
Technical Articles
Author's profile photo Celine Deng

How to overwrite the exclusion with exclusion whitelist

As a Sales Representative I want make sure that specific products can only be bought by specific customers, I don’t want to list all the other products and customers in the listing table. It is preferred to overwrite the exclusion with exclusion whitelist.

For example:

All customers under the customer group (01) can’t buy the product TG11 and TG12. Only the customer 10100001 under the customer group (01) can buy the product TG11.

Configuration steps

  1. Log in the system with a role contains Business Catalog SAP_CORE_BC_EXT_CBO. Create a customer business object YY1_EXCLUSIONWHITELIST with fields ‘Customer’ and ‘Material’. Add entries for whitelist in the business object.
  2.  Create a Cloud BAdI implementation YY1_EXCLUSION_WHITELIST with extension ID SD_LSTG_EXCLSN_RQMT_DOC_ITEM in the App’ Customer Logic’. Write the logic that records maintained in the whitelist can overwrite the records of exclusion. 
  3. Create requirement 3000001 with the task SD_LSTG_EXCLSN_RQMT_DOC_ITEM and assign the cloud BAdI implementation into the requirement.
  4. Set up listing/exclusion configuration and assign requirement 3000001 to the listing/exclusion procedure.

    Create the condition table 501 with fields Customer Group and Material. 

    Create the access sequence Z501 with the condition table 501.

    Create the condition type Z501 with the access sequence Z501. 

    Create the procedure Z501 with the condition type Z501 and assign the requirement 3000001 to the procedure. 

    Assign the procedure Z501 into exclusion for sales quotation (QT).

  5. Create new records in the App ‘Create Material Listings and Exclusions’.
  6. Create sales document to test it.

          Create a quotation with the customer 10100001 which is under the customer group (01).

         Add the product TG11 is allowed. Because the customer 10100001 with product TG11 is                     in the exclusion whitelist. Although it also fits to the condition of exclusion.

       Add the product TG12 is not allowed. Because the customer 10100001 with product TG12 fits           to the condition of exclusion.


Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jayden Nolan
      Jayden Nolan

      Thanks for this information its helped me alot.  MyTHDHR