Enterprise Resource Planning Blog Posts by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
Siwen_Hu
Advisor
Advisor
19,717
In Manage Prices - Sales App, you can extend the App by creating new custom fields for condition records to fulfil your customize business requirement. Please following below steps for how to extend the App.

Create Custom Field


Before to create custom field, please make sure business role: SAP_BR_ANALYTICS_SPECIALIST is added in your current user.

Create In Head Level


Open Custom Fields and Logic App, click create button, create new custom field for pricing communication head level.



Click Create and Edit button, click UIs and Reports tab, enable all usage.



Click OData APIs tab, enable the usage for OData service.



Note: If you want to use this custom field in Sales document, Billing document and Service transaction, please enable usage on Business Scenarios tab. If you want to use this custom field in Pricing Condition Record Data Replicate Framework, please enable usage on SOAP APIs tab.

Save the changes and click Publish button. Will take some time to publish the created custom field. Once finished, you will see the publish status on the head of the field page.



Note: You also can create custom field with other supported data type, such as List, Date, Number and so on.

Create In Item Level


Create custom field for item level almost same as head level. On creation step, set Business Context as "Sales: Pricing Communication Item".

Change Field Catalog


Before to update configuration, please make sure the business role "SAP_BR_BPC_EXPERT" is assigned in current user. Open Manage Your Solution App, click Configure Your Solution button, searching with "Pricing". Click Sales Price Management line, all the configuration steps will list in the right page.



On Change Field Catalog configuration step, click New Entries button, on the new line click Search icon.





On the prompt up page, you will find the new created custom field, double click the filed line.



Then click Save button, the custom field will be added to field catalog successfully.


Create Custom Table


On Create Condition Table configuration step, set Table number, such as 932. Click Create button, the new table will be created successfully, find the needed fields, double click on right side to move it to left side.



Click Generate button to generate the table, you will got below message after generation.


Create Access Sequence


On Set Access Sequences configuration step, click New Entries button to create new access sequence.



Select the new created access sequence, click the Accesses node on the left tree. Click New Entries button to add created table.



Select the table line, double click the Fields node on the left tree. Then you need select the table line again on Access page, press Enter on Keyboard. Check all the fields for above table will be showed. Save all the changes for this new access sequence.


Create Condition Type


On Set Condition Types for Pricing configuration step, click New Entries button to create new condition type, such as ZPR1. Set the new created access sequence to this condition type and save the change.



Now, you can use this condition type to create condition record in Manage Prices - Sales App.

Use Custom Field on App


Open Manage Prices - Sales App, set Condition Type as ZPR1 and select Key Combination with above condition table. The new created field showed as filter and data column on App.



You can create, update, delete and filter condition records for this condition type with new created custom field. For more details, please see blog: https://blogs.sap.com?p=651

Use Custom Field on Excel Importing


The new created custom field is also supported in excel upload and download function on Manage Prices - Sales App. Below is the exported excel template for condition type ZPR0.

On Field List sheet, the field is listed.



On Condition Data sheet, the Additional Price Property column is listed as standard column.



You can use download condition record as excel or import condition record with excel file. For more details, please see blog: https://blogs.sap.com?p=579
37 Comments
TimothySanty
Participant
0 Kudos
Hi, very useful, thank you! Do you have any idea on how to assign a value to the new custom field? In the on prem world we would use USEREXIT_PRICING_PERPARE_TKOMP in MV45AFZZ but I cannot seem to find an alternative cloud BAdI for this?
ArcherZhang
Product and Topic Expert
Product and Topic Expert
0 Kudos
Hi Santy,

In Cloud, Even not need a cloud BAdI for this. So here under tab 'Business Scenario', you only need to enable the Business Scenario, which will take the value from document to pricing communication structure without additional coding.

BRs,

Archer
TimothySanty
Participant
0 Kudos
Hi,

you mean the tab business scenario in the custom field? It's empty, there are 0 business scenario's that you can enable if you create a custom field under “Sales: Pricing Communication Item”. I need to fill the field with a value from VBAP.
ArcherZhang
Product and Topic Expert
Product and Topic Expert
0 Kudos
Yes, should be there in that tab. If it`s not there. please raise an incident to SAP.

ArcherZhang
Product and Topic Expert
Product and Topic Expert
0 Kudos
please see my below comment.
TimothySanty
Participant
0 Kudos
Hmm very interesting!

Actually I'm doing this on a S/4HANA 2020 on prem system, initial stack. Nonetheless it should work since SAP is enforcing in-app extensibility to it's full extent. I'll log an incident for it and keep you posted! Tnx again.

Screen from the on prem version:

TimothySanty
Participant
0 Kudos
Hello,

I finally received an answer from SAP:

Dear customer,

Thank you for opening this incident and providing your valuable requirements on this matter. Unfortunately your requirements are not implemented as of now on promise. Nevertheless we will check the feasibility of delivering these features in one of the next release. In order to stay informed you can check the roadmap of S4/Hana Service here:

 https://www.sap.com/registration/protected/default-overlay.html?pdf-asset=b4f98b5d-c37c-0010-82c7-ed...

So for now it's business as usual: fill the custom fields in KOMP/KOMK via the known user-exits in MV45AFZZ/RVF60ZZ.
yusufavci
Explorer
0 Kudos
Hi Siwen,

Have you ever tried to upload with condition release status? I tried all way but I can't it. All condition records were created with status released.

I also defined processing status same as release status.

Excel;


Release and Processing Status;



Siwen_Hu
Advisor
Advisor
Hi, Yusuf

The condition release status could not be controlled manually, the default Release Status is Released after created condition record. And in excel upload, the input value will be ignored by system for Condition Release column.

 

Regards

Siwen
yusufavci
Explorer
0 Kudos
Hi Siwen,

I got it. Thank you so much for your answer. 🙂
wailoon_koo
Explorer
0 Kudos
Hi Siwen,

For existing custom fields added in the SPRO in the past for example KOMG-ZZ_ABC, is there a proper way to achieve in Custom Field app similar to your guide provided?

I do not see an option to add fields that already existing and the prefix in Custom Field is fixed with "ZZ1".

Thanks 🙂
Siwen_Hu
Advisor
Advisor
0 Kudos
Hi, Wai

Thanks very much for your question. But this Custom Field app could not support the field which your mentioned. In this case, could you please create a case to us, then we will provide the solution to you. Thanks.

Regards

Siwen
wailoon_koo
Explorer
0 Kudos
Hi Siwen,

Thanks for the prompt response. Actually we raised an incident "611985/2022" last month and the progress seems a little slow. We also struggling to find a feasible solution.

Not sure if you can view the incident, if not please drop me a message. 🙂
Siwen_Hu
Advisor
Advisor
0 Kudos
Hi, Wai

We can see the raised incident and already info the processor to speed up. Please check the updates in incident later.

 

Thanks

Siwen
0 Kudos

HI Siwen

 

FIXED - I was going to delete this but leaving in case it helps others.  We installed note 3190912 - Cannot edit custom fields in the "Manage Prices - Sales" app and this fixed the f4 drop down fied in VH Test so it is now working as expected.

 

Q - Can all types of fields be used in Custom Fields and Logic?  We tried code list.  The full f4 list shows in the backend in VK11/12 but not in Manage Prices Sales - in Fiori it is greyed out/not visible.  We are on S/4 core 106 FP02 with embedded fiori.

Field not visible

 

Drop down code list in backend - ok

Thanks

Karen

Alvaro_AH
Explorer
0 Kudos
Exact same scenario here. I have some former custom fields added to the pricing management tables, but not able to add them to 'Manage Price - Sales' app.

Could yo be so kind to share your solution, if found? Thanks!
0 Kudos
Hi Siwen

Thanks for blog, i have doubt i have existing condition record for PR00 which is already created and we have changed the validity to date to 10.01.2023, now when we try to upload the new price with different validity from and to 11.01.2023 to 31.12.2023, system is not allowing us to do export and import for this. please help
Siwen_Hu
Advisor
Advisor
0 Kudos
Could you please check this blog for upload price with excel: https://s4hanacloud.community.sap/blogs/show/rkLRUlcSpV3GblTfrVC70m. Thanks very much!

 
ricc_meggio
Discoverer
0 Kudos
Greetings,

we have the same request for old custom fields already created in  SPRO before S/4 Hana.

Any solution so far?

Thank you.
clulu
Newcomer
0 Kudos
Hi Siwen,

I have a requirement to upload file and the items should still be editable, this can only be achieved when status is blocked (A) and not to trigger the workflow. is this possible?
Siwen_Hu
Advisor
Advisor
0 Kudos
Hi, Riccardo

Please create an incident to us, we will provide solution after receive it. Thanks.

Siwen
Siwen_Hu
Advisor
Advisor
0 Kudos
Hi Alvaro

Please create an incident to us, we will provide solution after receive it. Thanks.

Siwen
Siwen_Hu
Advisor
Advisor
0 Kudos
Hi, Karen

Thanks for contact us, for this case we need do more investigation in your system.

Please create an incident to us. Thanks.

Siwen
Siwen_Hu
Advisor
Advisor
0 Kudos
Hi, Charmaine

Could you submit your requirement to SAP? Thanks.

Siwen
rammel
Participant
0 Kudos
Hi siwen.hu ,

Is there a way we can disable/enable some fields/columns via custom logic/badi? Currently, in on-prem, we are using enhancement spot ES_SAPMV13A enhancement section \PR:SAPMV13A\EX:MV13AF0F_01\EI to do this.
Siwen_Hu
Advisor
Advisor
0 Kudos
Hi, Rammel

It is not supported in Cloud version. You can create new requriement to us. Thanks.

Regards

Siwen
rammel
Participant
0 Kudos
Hi siwen.hu

How do we submit a new requirement? Via customer influence?
Siwen_Hu
Advisor
Advisor
0 Kudos

Hi, Rammel

Yes, you also can check this note: https://me.sap.com/notes/2963059. Thanks.

Or use this link: https://influence.sap.com/sap/ino/

 

HardikPatel886
Explorer
0 Kudos

Hello Experts,

 

We have a requirement to trigger the workflow based on pricing communication data. We created the workflow and implemented Badi SD_APM_SET_APPROVAL_REASON but it doesn't have pricing communication as importing and even standard CDS available for pricing will not return the pricing data during first time create of sales order as it is not created yet. This blog says about the data to be transferred from Order Item to Pricing, however is there any business process that would pass on the data from pricing communication to item of the order. Just FYI, order item has subtotal fields available to aggregate the values from the pricing procedure but all of them are occupied. Unfortunately, I couldn't find any solution for this yet. Have anyone came across such requirement and able to crack, request your inputs on it.

Best,

HP

Celine2
Product and Topic Expert
Product and Topic Expert
0 Kudos

Dear user,

The Pricing communication fields come from the sales order data. Then the provided paramether should meet your requirement. Could you give an example? which field you want but don't in the import parameter? Don't understand what do you mean the subtotal fields are occupid.

By the way, the extension fields in the sales order can be used in the cloud Badi too.

 

Thanks and Regards,

Celine

 

HardikPatel886
Explorer
0 Kudos

Hello Celine,

Thanks for your time. Let me explain you in detail about the requirement and our approach.

We have to trigger the workflow during the sales order create/change. We created the workflow using Manage Workflow for Sales Configuration and steps and approvers are defined for it.

HardikPatel886_0-1728894061614.png

 

In order to trigger this workflow we implemented the BADI SD_APM_SET_APPROVAL_REASON 

HardikPatel886_4-1728894356063.png

Here, we need to access the pricing communication data and check if any cline item has the discount(CondType : Z192)  greater than the threshold(CondType: Z190) then we have to set the sales order for the approval.

However, this BADI doesnot have the pricing communication as the importing parameter which we can use to compare the value of the condition types, so we tried to check whether CDS I_SalesDocItemPricingElement returns the runtime value of the pricing for the sales order which is not yet created, which ofcourse didnot return the value as Sales Order is not created yet. This could have been achieved only if the we have pricing communication data available to use in this BADI.

Since it is not, we tried to see if we can create custom field in pricing communication structure and extend it to sales order item, that might flow these amounts from pricing to sales order item field. But in business process i could only see the other way round i.e. flowing from item to pricing communication as shown here in this blog too.

I hope I was able to explain the problem statement here, apologies if anything is not clear and please let me know on that so that I could be more clear :).

Thanks in advance.

Cheers.

Celine2
Product and Topic Expert
Product and Topic Expert
0 Kudos

Dear User,

Thanks for your such detail explannation.

For BADI SD_APM_SET_APPROVAL_REASON itself, yes as you said, there is no pring element related importng parameter.

May I know are you in public cloud version? if yes, it's 2 system landscape( Q and P system) or 3 system landscape ( D, T and P system)?

Thanks and Regards,

Celine

 

HardikPatel886
Explorer
0 Kudos

Hello @Celine2 ,

Yes its public cloud version 2408 and its 3 system landscape.

Dmitry_K
Explorer
0 Kudos

Hello,

how to automatically trigger price update after some important fields have been changed by user in sales order?

For example, our prices depend on plant. Assume user changes plant on sales order item - the price should be redetermined automatically, but its not happening.

 

 

Pettmark
Explorer
0 Kudos

Anyone who knows if it is possible to use custom fields added with the old way in the Manage Prices - Sales app? 

I know of the option of using SCFD_EUI, but it looks like that process is only for fields in database tables such as VBAK, VBAP, MARA? 

ArcherZhang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Yes, SCFD_EUI is also working for this 'Manage Prices' app.

RafaYama
Newcomer
0 Kudos

@HardikPatel886 could you resolve the issue with price value?

I'm facing same issue here. Please help me.