on 05-25-2015 1:19 PM
Hello All ,
Kindly suggest me how to have SAP sales pricing data to an external system.
Best possible solution or general implementation scenario.
ASAP.
Regards,
Kinjal
Hi Kinjal,
Can you elaborate when you say " want to convert them in following format customer id / material / net price/ tax code " ?
With the available information I can suggest that you need to build an interface program which should extract the data from tables (Accesses) of the Pricing condition types within validity and map to the data to the medium (Ex: Flat file) through which you are planning to relay the data.
Thanks,
Yati
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It is depending of what is your business scenarios.
For example in one of our scenario for a company we only need to send specific prices , which of course are valid , to the external system throught SAP PI. In this case we read specific tables to take the relevant prices.
In other case , for other company, we use web service which simulates the pricing procedure to calculate price. In this scenario our customers are B2B customers with specific pricing discounts according to their size and other things.
I could also mention some functions to help you for the second case.
SPR_PRICING_SCHEME_GET -> to determine the schema
SPR_KOMK_KOMP_FILL
PRICING
Regards.
Hi Kinjal,
As mentioned above create your own pricing report logic in V12L_A - Create with Reference. Then to pull the same go in V/LD - Condition List.
In V/LD put your pricing report key (in below example I have put 15 - Material Price) and execute. In selection screen I have put below details for condition type along sales organization.
A | V | PR00 | Price |
Execute the same. As you can see below it gave me all materials in sales organization with there prices. Same way you define your pricing report (or could use standard), put all conditions in the variant and execute the same.
Since you want to put a dump in specific location, you can pull this in Excel and dump it or check with ABAPer if you need to automate the same with interface.
I hope this resolves your issue.
Regards
Rahul
Hi,
Transferring price from SAP to external system
First of all, can you tell us, how your SAP is getting connected to third party system?
Thanks, JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kinjal,
You can go through transaction V12L_A - Create with Reference.
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.