Tuesday, April 14, 2009

New Pricing Condition Table for Retail

Requirement:
Bill Promotional Items at Rs. 1 to Only those consignment Customers who are getting VAT Bills rest all would get normal bills with normal stock transfer price.

Resolution:
A new table in Pricing Condition ZTRF has been added with the following parameters

Customer: Customer Code
Plant Region: Region of Delivery Plant
Region: Customer's Region
Material: Material For which seperate pricing is needed (apart from normal transfer price)

This is the Most Specific Table which should have data for only those consignment customers which are getting VAT Bills.

Data for NO OTHER CUSTOMER SHOULD BE MAINTAINED in this TABLE.


LSMW by name of ZTRF2 has been created and format of import file is as below
KSCHL KUNNR WKREG REGIO MATNR_01 KBETR_01
ZTRF RWWMH0001 13 13 IDK.AO.0003.4 99.833
ZTRF RWWMH0001 13 13 IDU.AO.0004.0 99.967
ZTRF RWWMH0001 13 13 LCU.AO.0002.05 99.93
ZTRF RWWMH0001 13 13 LCU.AO.0002.75 99.91
ZTRF RWWMH0002 13 13 IDK.AO.0003.4 99.833
ZTRF RWWMH0002 13 13 IDU.AO.0004.0 99.967
ZTRF RWWMH0002 13 13 LCU.AO.0002.05 99.93
ZTRF RWWMH0002 13 13 LCU.AO.0002.75 99.91
ZTRF RNWUP0001 24 24 IDK.AO.0003.4 99.833
ZTRF RNWUP0001 24 24 IDU.AO.0004.0 99.967
ZTRF RNWUP0001 24 24 LCU.AO.0002.05 99.93
ZTRF RNWUP0001 24 24 LCU.AO.0002.75 99.91

Screenshot of the new table data maintenance:

No comments:

Post a Comment