Skip to content

Posts from the ‘SD Process’ Category

24
Mar
SAPTricks

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.

11
Mar
SAP Tricks

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

26
Nov
SAP Tricks

IDoc numbers related to Sales Documents

SAP used to have the Workflow button in VA02 and VA03, up to Version 4.7.
Due to impact on performance it was de-activated, and made optionally active depending on a user parameter.
If you would like to re-activate the workflow button the sales documents simply do the following: Read more »
22
Jun
SAP Tricks

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 »

17
Mar
SAP Tricks

New Determination of Sales Document Status

Tip
The report to correct the Sales Document status is SDVBUK00 (New Determination of Sales Document Status).

Use
If a sales order line item is rejected but still in the document flow it shows as open then this report can correct the status.
8
Mar
SAP Tricks

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.

3
Feb

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

2
Feb

Great tip – SE16n Shortcut

Instead of typing SE16N to access General table display, try just typing “N” into the command field.

29
Jan
SAP Tricks

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

4
Dec

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

2
Dec

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.

28
Oct

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.

6
Oct
SAP Tricks

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.

28
Sep

User Menus

Tip – Sometimes you may wish a user to login to a specific area menu or transaction code. This can be easily done by assigning the area menu or transaction code to the user profile. To set the user start menu in CRM to CRM_MENU, assign the start menu to the users profile in SU01.

To see what area menus are available in Standard SAP check the values in SE43. Here are some good area menus:

VA00 Sales
VC00 Sales Support
VF00 Billing
VKP0 Pricing
VL00 Shipping
VS00 Sales Master Data
VT00 Transportation

27
Sep

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: