Download Sales Orders according to SH Party
Recently Asked: How do you download sales orders in SAP by ship to party address?
Its easier than you think:
You can easily do this in VA05.
When in VA05 change the Search parameter from Sold to Party to Ship To Party by selecting the “Partner Function” button Ctrl+F10. Then use the other selection parameters as required.
The resultant lists can be downloaded/exported from the ALV grid.
If you dont find SH partner function in in VA05,please add it in the below mentioned menu path
IMG–>SD–>Sales–>Lists–>Set updating of partner index
Add SH to Transaction Group ’0′.
Then you can get a report based on Ship to Party in VA05.
Sales Documents Item View Table Control
Have you ever opened a sales document and wished your quantity field was adjacent to the material field? or the plant field was visible on the screen and not hidden on column xyz. Well the layout of these columns may be controlled by the user: you can change the table control of a sales document item view. For example you can drag columns into different positions on the table. You can also save the view of the columns as a user specific variant.
But did you know that you can also set a system/client specific variant for all users. You can do this by changing the columns and selecting the small icon called “configuration” on the top right hand side of the items list. Then select “Administrator” then select “Activate“. This controls Program SAPMV45A and Control TCTRL_U_ERF_AUFT.
Note to do this you must have the following authorization – authorization object ‘S_ADMI_FCD‘
IDoc numbers related to Sales Documents

SAP Tips – Billing document cancellations have hard coded copy routines
Very valuable tip on Billing document cancellations.
Routine LV60A006 is hardcoded by SAP for billing item cancellation.
Routine LV60A005 is hardcoded by SAP for billing header cancellation. Read more 
New Determination of Sales Document Status
Tip – Credit Management Report
Report : CHECK_CM
This standard SAP report gives complete credit management analysis executed for a sales document.This report is very helpful for analyzing credit management issues.
Tip – Price report
Is it possible to have a report which shows who changed what pricing condition record at what time and what was changed?
Yes – use SA38 to execute report – RV16ACHD
or use transaction code – S_P6B_12000142
Great tip – SE16n Shortcut
Instead of typing SE16N to access General table display, try just typing “N” into the command field.
Cross System Lock – ECC CRM
Hi Glynn, What do I do if I have a document that is blocked in 1 system when operating with ECC and CRM?
Answer – You need to start investigating the cause of the block/lock. I generally follow the following process:
1) Check document for errors in ECC and fix.
2) Check document for errors in CRM and fix.
3) Check middleware queues SMQ1 and SMQ2.
4) From CRM
Great Pricing OSS consulting note
note: 836243
This note deals with the following topics in detail:
1. Attributes of the inactivity indicator (KINAK field).
2. Use of the KZNEP exclusion indicator to exclude conditions.
3. Condition exclusion based on the properties of thecondition type.
4. Use of exclusion group Customizing to exclude conditions.
5. Use of KINAK ‘Y’ (‘last price’ logic) to exclude conditions.
6. Summary/program steps for condition exclusion.
7. No exclusion on header level
Transaction and Screen Variants
Tip – Did you know that you can control elements of a screen display from within a transaction, say for example a sales document eg: VA01, for example program SAPMV45A screen 4440, so that only specific fields are shown to the user and are available for input or required to have input. Use transaction SHD0 – there is great SAP documentation on the use of these settings as well.
Output condition record ignored
Tip – Did you know that if you set a output condition record with no printer. The condition record is ignored by the system for example in VV12, VV22, VV32.
Mass change of Sales orders in VA05
Tip - You may be used to VA05. You may now be using a more user friendly transaction VA05N, which displays the results of sales order list in the ALV grid format. But did you know that VA05 has a mass update function.
Try the following: execute VA05, then select Edit –>Mass change –>New Pricing. Some of the changes are more logical to use in this report than others such as the pricing. Changing material or plant is a bit more cumbersome.
SD – ERP – Worklists
Tip – Often people ask what transaction codes/reports should be executed by the business as part of a daily or weekly function. The exact list and frequency of execution is dependent on the business process however for SD the following may be used:
V.26 – Sales Documents By Object Status (System or User Status)
V.00 – Incomplete SD Documents
VA14L – Sales Documents Blocked for Delivery
V23 – Sales Documents Blocked for Billing
V.25 – Release Customer Expected Price (Used for EDI)
V_RA – Backorder Processing: Selection List by sales docs
CO06 – Backorder Processing:




