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‘
Translations
Hi Glynn do you have any tips on translations of texts?
This is a big area, however, a little time saver can be to use the unicode translator transaction SE63 which is a shortcut to all texts which need to be maintained and translated. Always check oss note – 0585116 for more info on using SE63.
Dont forget you can use SO10 to translate standard texts as well.
How to change Servers on a System
So you login to server X on a system and you would like to move to server Y on the same system without logging off and back on again – How do you do it?
You can do this a number of ways – the method I follow is:
- Go to transaction SM51. (see server overview)
- Double click on a server to see the processes.
- Then open a new session, you will now be on the new server you double clicked.
Be careful NOT to use the back arrow from the work process overview or else you will move back to the old server.
LIS SIS Update Analysis
Tip – You may be using LIS (Logistics Information Services) or SIS (Sales Information Services) and woudl like to analyse what structures are updated with what Key Figures and Characteristics, you can do that with these awesome transaction codes:
MC30 Update Log
MCE2 PURCHIS: Update Diagnosis Purch.Doc.
MCVCHECK01 SIS: Update Group Check
MCVR SIS: update diagnosis – order
MCVS TIS: Update Diagnosis: Transportation
MCVT SIS: update diagnosis – delivery
MCVV SIS: update diagnosis – billing doc.
Transaction – CUUPDMV – Material Variant update
One can use transaction CUUPDMV or report RCUUPDMATVAR via SA38 to update the material variants after a model change.
Usage of the Report
A configuration model was changed. For example, a new characteristic was included in a class and this characteristic is analyzed via object dependencies. Alternatively, object dependencies are changed and calculated characteristic values change as a result. At the same time, many material variants, which would now have to be changed, exist in order to adjust the stored configurations to the new model. The system sees a material variant as a product variant of a configurable material whose characteristic values are already defined in the material master record. It is therefore treated as a stock material. In principle, the configurations of the material variants may be updated manually by executing transaction MM02 and calling the configuration in this case. An alternative is to execute CUUPDMV to update the material variants.
Credit Management Analysis
Credit management has so many variables it is usually difficult to analyse for the average SAP consultant. Here are the tools which you need to ensure you are not average!
Transaction FD33 - Customer Credit Management Display.
Transaction F.35 – Customer Credit Master Sheet.
Transaction SE16 – on table S066 – Open orders: credit management.
Transaction SA38 – Report CHECK_CM – Awesome report for Credit analysis.
Transaction SA38 – Report RVKRED88 – Re-organization Simulation after update errors.
Transaction SA38 – Report RVKRED77 – Re-organization after update errors.
How to re-set the Sales Document Status
Quick SAP Tip – How to re-set the Sales Document Status.
Why: Sometimes a sales Document may be updated incorrectly and the status may be out of sync with the attributes in the document. For example the item may be rejected but this may not be showing correctly in VBUP.
How: Run SA38 with report SDVBUK00
Other Related Tips: A great table/view which shows a combination of header details and status information is VBAKUK.
Command Line “OK-Codes”
Direct call of transactions, session handling:
/nxxxx
- This terminates the current transaction, and call transaction “xxxx”, for example, “sa38″ for reporting.
/n
- This terminates the transaction. This generally corresponds to going back with F15.
/nend
- This terminates all separate sessions and logs off (corresponds to “System -> Log off”).
/nex
- This terminates all separate sessions and logs off immediately (without any warning).
/oxxxx
- This opens a new session and starts transaction xxxx in this session.
/o
- This lists existing sessions and allows deletion or opening of a new session.
/i
- This terminates the current session (corresponds to “System -> End session”).
/i1 , /i2 ,…
- This terminates the session with the specified number.
.xyzw
- “Fast path”: “xyzw” refers to the underlined letters in the menus. This type of navigation is uncommon and is provided more for emergencies (such as a defective mouse).
Background input:
The following commands can be entered in correction mode (“Process in foreground” or “Display errors only”) when processing a background input session: Read more 
Quick and Easy Tut – EDI – Pricing Condition Records
Introduction
So you know that SAP can send pricing condition records from your SAP system to another system using ALE/EDI. An investigation of transaction WE60 can show you the structure of the Basic Type “COND_A03″.
But what is the easiest method of sending the initial data load from SAP to another system for pricing condition records, or how do you use it? Read more
SAP SD – FAQ Notes
The SAP OSS FAQ notes are full of information, they are recommended reading, login to OSS on the left (under links) and search for these:
Number Range Buffering
Basic Introduction to NRIV
The document number is assigned in chronologically ascending order based on the table NRIV. For this, the table NRIV is locked until the application (LUW) is terminated by either a COMMIT WORK or ROLLBACK (OSS Note 639754). Another application cannot take a document number during this time. Read more
Change a customer account group
What happens to the customer number when I change an customer account group? Read more
ATP – Storage Location Check
Can I deactivate the storage location check for checking rule ‘A’ (sales order) but leave checking rule ‘B’ (delivery) activated when I customize the scope of check, so that sales orders are not checked at storage location level? Read more
Where does the system determine the Accounting Doc Type?
The Accounting document type is determined in various ways, according to type of transaction, for example the default can be configured in SAP Customizing Implementation Guide–>Financial Accounting–>Accounts Receivable and Accounts Payable–>Business Transactions–>Outgoing Invoices/Credit Memos–>Carry Out and Check Document Settings–>Define Default Values
However in the case where you have a sales billing document and you would like to default a specific accounting document type you should Read more
Function Modules for SD Reports and Smartforms
These function modules are great to get the information used to populate Smartforms and reports in SD.
Remember you can access the data with transaction SE37 and use the test/execute icon [F8].
IDoc numbers related to Sales Documents
Purchase Order Transactions
MASS MAINTENANCE
- MEMASSPO : Mass maintenance of POs
- MEMASSRQ : Mass maintenance of PRs
- MEMASSCONTRACT : Mass Maintenance of Contracts
- MEMASSSA : Mass Maintenance of Scheduling Agreements
- MEMASSIN : Mass Maintenance of info records
- XK99 : Mass Maintenance of vendors Read more
Transaction Codes – FI
F-01 Enter Sample Document
F-02 Enter G/L Account Posting
F-03 Clear G/L Account
F-04 Post with Clearing
F-05 Post Foreign Currency Valuation
F-06 Post Incoming Payments Read more
SAP Tips – VPRS condition Type currency in Billing
SAP Tips – VBAP-CEPOK – EDI Price/Value
Not all customer expected prices are causing the documents to be incomplete for with EDI. This will help:
SAP Tips – View Table Change Logs
If the IMG change log has been activated you are able to analyse the changes with the following programs: Read more
Business Intelligence Info Cubes
FI
AR
Info Cubes
Key Points
|
Read more
MDM and Netweaver
SAP NetWeaver is an integration and application platform that helps unify and align, information and business processes across technologies and organizations.
SAP Master Data Management (MDM) is a building block of SAP NetWeaver to enable information integrity across the business network and to facilitate a better communication of information across multiple systems.
Does MDM replace the existing master data distribution techniques for example between mySAP CRM and SAP ERP or SAP ERP and mySAP SCM? Read more
Introduction to MDM
MDM is SAP Master Data Management. MDM enables data integrity across a multiple system, IT landscape. Now your SAP Master data, for example, business partners, product masters, product structures may be shared.
SAP MDM enables the sharing of harmonized master data, formerly trapped in multiple systems, and ensures cross system data consistency – regardless of physical system location. It helps to align master data by providing services that recognize identical master data objects and keep them consistent.
SAP Tips – Information Structure Updates
If you wish to see which information structures have been updated from Sales or Transportation you can use the following transaction codes:
SAP Tips – Content of database relevant to configuration of objects
Should you wish to see the tables and information extracted from them for a configured item in a sales document you can use the transaction code:
CUTABLEINFO.
CRM BDoc Monitor
Great information on the use of SMW01/SMW02:
Transactions: SMW01 / SMW02
Menu path:
CRM 4.0/5.0: Architecture and Technology –> Middleware –> Monitoring –> Message Flow
–> Display BDoc Messages / Display BDoc Messages Summary
SMW01 has the following features:
Revenue Recognition
1. Is it possible to use a customized document type for the revenue recognition in FI?
2. Why is a revenue recognition not possible, and why is an entry made in the incompleteness log of the order or contract?
3. How can I use the revenue distribution, and what is the purpose of the revenue distribution?
4. When is an update of the revenue recognition data required, and how do I execute this update?
5. When are the sales costs transferred to CO-PA during the revenue recognition process?
6. Why are not all fields filled in the CO document for the revenue recognition documents that are also filled during the billing document transfer?
7. Why is the account for non-billed receivables, and not the account for deferred revenues, posted in the case of revenue recognition-relevant items in the credit memo?
8. Why is monitoring of the revenue recognition data required, and how do I monitor the data? Read more
Revenue Recognition Cancellation
Why does transaction VF46 (Revenue Recognition: Cancellation) not cancel the revenue recognition posting?
The revenue recognition cancellation (transaction VF46) is not a real cancellation in the sense of a reverse posting, but a posting to a prior period. This is based on the balances in the accounts when the cancellation is created.
How To Pricing – Condition Basis
This is a series of steps to create a pricing procedure covering Condition Basis, From and To Step Numbers and the condition basis formula.
