SAP Tips & Tricks

Have you had some SAP questions as follows?

- Do you know what entering /n in the Command Line will do?
- Do you know what entering /o in the Command Line will do?
- Do you know about the SEARCH_SAP_MENU transaction?
- Do you know what the Context menu is?
- Do you know how to adjust columns in a table and then save the settings as your own?
- Do you know how to stop a transaction when needed (if a search is running for a very long time for example)?
- Do you know how to copy and paste data in SAP using the Ctrl+Y functionality?
- Do you know how to print from SAP to a local printer?
- Where do you change the font size in SAP?
- Where do you change the setting to hide or show the transaction codes (technical names)?
- Where do you change the setting to display or hide codes (keys) in dropdown lists?
- Do you know what icon to choose to collapse all levels of the SAP menu (clean it up, start from scratch)?

Find the answers in this material: SAP Free Download

Read more »

Stop billing when the full amount is reached is SAP SD

We need to bill customer with certain amount of charges. The charges will be billed along with good sold. We maintain condition such as 1,000 USD per 10 EA that means each time customer buy 1 EA of good, we will bill them 100 USD extra charge until we bill them the full amount (1,000 USD in such case).


Since it's a condition, SAP system will continue bill customer unless we delete the condition or set the validity period.

Is there any SAP standard way that SAP system can stop billing for my situation?


The answer is: (Yadav)

Goto Transaction code: V/06, select your condition type and tick the "Condition update" check box and save it. Then, create the condition record (Transaction code: VK11) for the condition type, enter the material number, rate, validity period etc.

After filling up all your data, now click on the Menu: Goto --> Additional data. In
the "Additonal Sales data" screen , you will find a field called "Max.cond.base
value", here enter value 1000 and save your condition record. So once the
discount condition type reaches 1000 it will stop automatically.

Read more »

How to create SAP Error Message for the cancellation of paid billing document?

Can we create and SAP error message for the cancellation of paid billing document?


The scenario is:

SAP Accounting document is created upon creation of billing document. Upon
payment, document cleared is the accounting document created. There are instances wherein SAP accounting document was already cleared but our user is still able to reversed billing document. Now, i want to create an error message or user exist wherein, when a user will not be able to reverse the billing document if the SAP accounting document attached to this billing document is already paid.

The answer is yes, it's very well through SAP standard itself, you can address this SAP issue. Apply Routine 29 for the field Copying Requirements at header level in VTFL. Also Go to VOFA, select your billing type and assign routine 29 to the field "Copying Requirements". This should solve your problem.

Read more »

One-Time Vendor and Customer Table

I’ve searched the internet where I could possibly find One-time Vendor and One-time Customer data in SAP. You know what? I could not find any site telling the best table to find what I am looking.
Most of the sites I visited are mentioning about SAP table name: BSEC, One-Time Account Data Document Segment table.


Well, I’ve checked the table and yes it’s a table for One-time vendor/customer transaction data. However, what if the transactions have originated from PO (MM Module)?

Using BSEC table to get one-time vendor/customer data pose a problem for transactions that originate from PO (MM Module). Because the field that you use to access BSEC is belnr (accounting document number) and gjahr (Fiscal Year). And the belnr that you need is the document number created in accounting not the document number created from PO. To look for the created belnr of a specific PO you need to access table BSEG, and hell it’s cluster table. And worst is, belnr is unknown so it will definitely mess up your program performance because belnr is a key field.

I’d like to share what I’ve just learned as I continue to advance my learning in SAP ERP.

If transactions have originated from FI and SD module, you may use table BSEC. Key fields are satisfied because definitely you know your BELNR and GJAHR you want to access.

Elseif, transactions have originated from PO (MM Module) you can use table RBKP, Document Header: Invoice Receipt table. You can find all the information about the one-time vendor/customer you want to get such; name, address, TIN and etc.

Credit: sap-knowledge.com

Read more »

Define Field Status Variant in SAP

Purpose

In this SAP activity, you define and/or edit field status variants and groups. You group several field status groups together in one field status variant.


You assign the field status variants to a company code in the activity Assign Company Code to Field Status Variant. This allows you to work with the same field status groups in any number of company codes.

You can also define and process field status groups. As a requirement, you define a field status group in the company code-specific area of each G/L account. The field status group determines which fields are ready for input, which are required entry fields, and which are hidden during document entry. Just remember that additional account assignments (i.e. cost centers, profit centers or orders) are only possible if data can be entered in the corresponding fields.
Procedure

SAP IMG Path : Financial Accounting (NEW) → Financial Accounting Global Settings (NEW) → Ledger → Fields → Define Field Status Variant.

• On the Change View “Field status variants”: Overview screen in the left hand frame make a double-click Field status variants.
• In the right hand frame, choose the line with the field status variant Z001 (Field status for Z001) from the toolbar choose Copy as (F6).
• On the Change View “Field status variants”: Overview of chosen set screen enter the following data:
  

  FSTV : Z001
  Field Status Name : Field Status Z001

• Then choose Enter.
• On the Specify object to be copied dialog box choose copy all.
• Then confirm the Information dialog box
  h) Finally, choose Save.

Read more »

Disable/Enable User Menu and SAP Menu

1. Configure individual specific SAP users

Enter transaction code SM30 (Maintain Table Views) in your SAP command field and maintain USERS_SSM table.


You would notice that no data maintained in this table during initial access.

• To maintain entries, click ‘New Entries’ button. Enter the individual
  username on the User Name field.

  To enable user menu and SAP menu, tick the appropriate checkboxes. To
  disable, untick the chekcboxes.

2. Configure all SAP user
Enter transaction code SM30 (Maintain Table Views) in your SAP command field and maintain SSM_CUST table.

• To enable te user menu for all SAP users set ALL_USER_MENUS_OFF = No.
• To disable it, set ALL_USER_MENUS_OFF = Yes.
• To enable the SAP Menu set SAP_MENU_OFF = No
• To disable it set SAP_MENU_OFF = Yes.
  

Read more »