Price List and Import custom SAP price List

[SARAN_14]

Hi,

Can anyone explain the full functionality of Price lists (samp_price_list) and Import Custom SAP Price lists (imp_samp_sap_custom_price_list)? Though I have referred to the Product Docs, I couldn't get the exact point of what these tables do with SAP.

And please explain the fields concerning imp_samp_sap_custom_price_list in the attached Screenshot.

Thanks,

Saran K

[SwarnadeepNandy · Accepted solution]

Hello @SARAN_14,

Price lists (samp_price_list) and Import Custom SAP Price lists (imp_samp_sap_custom_price_list) are tables that store the price information for products or services that are sold by a company. They are used to integrate with SAP, a software system that manages business operations and customer relations.

The samp_price_list table contains the following fields:

• sys_id: The unique identifier of the price list record.
• name: The name of the price list.
• currency: The currency code of the price list.
• amount_type: The type of amount that the price list contains, either net or gross.
• valid_from: The date from which the price list is valid.
• valid_to: The date until which the price list is valid.
• items: A related list of price list items, which are the products or services that belong to the price list and their prices.

The imp_samp_sap_custom_price_list table contains the following fields:

• sys_id: The unique identifier of the import record.
• u_sap_price_list_id: The ID of the SAP price list that is imported.
• u_sap_price_list_name: The name of the SAP price list that is imported.
• u_sap_currency_code: The currency code of the SAP price list that is imported.
• u_sap_amount_type: The type of amount that the SAP price list contains, either net or gross.
• u_sap_valid_from: The date from which the SAP price list is valid.
• u_sap_valid_to: The date until which the SAP price list is valid.
• u_import_status: The status of the import process, either pending, in progress, completed, or failed.
• u_import_log: A log of the import process, which shows any errors or warnings that occurred during the import.
• u_imported_items_count: The number of items that were imported from the SAP price list.
• u_imported_items: A related list of imported items, which are the products or services that were imported from the SAP price list and their prices.

The purpose of these tables is to allow users to import price lists from SAP into ServiceNow, and use them for pricing calculations in ServiceNow. Users can use the Import Custom SAP Price Lists application to select a SAP price list and import it into ServiceNow. The application will create a record in the imp_samp_sap_custom_price_list table for each import, and populate the fields with the information from SAP. It will also create records in the samp_price_list and samp_price_list_item tables for each imported price list and item, and link them with the imp_samp_sap_custom_price_list record. Users can then use the samp_price_list table to view and manage the imported price lists in ServiceNow.

For more information on how to use these tables and applications, you can refer to these articles:

• Order Management - ServiceNow
• Price Lists | SAP Help Portal
• Sales Price Excel Upload in SAP S/4HANA with custom fields

I hope this answers your question.

Kind Regards,

Swarnadeep Nandy

[SARAN_14]

Thanks @SwarnadeepNandy