The ways to editing tables

Here are listed powerful hacks which can be used to change even the standard tables and even in a production environment (if you have CHANGE access in Debugger). You should think twice before using them.
You can track changes made in SE16N by &SAP_EDIT (GD-SAPEDIT) option in SE16N_CD_KEY table.
With a right authorization concept in place you would not be allowed to debug in production. So end users should be restricted with debugging authorizations.

1. Go to SE16N, type the table name, turn on the debugger (type /H in the command field), press F8. In the debugger set the values of GD-EDIT and GD-SAPEDIT to ‘X’ and press F8.
2. Execute the function module SE16N_INTERFACE. Set parameters i_tab to table name and i_edit to ‘X’ and press F8.
3. Carry out the transaction UASE16N (obsolete, but sometimes still in use). Type &SAP_EDIT in the command field.

SE16N: Abschalten von &SAP_EDIT – SAP Note 1420281

LSMW upload classification

On the next screen, if you press the button “Object overview” you see next fields:

So in this case
KLART – 001 (Material Master)
OBJEK – material master number
CLASS – Class name
ATNAM – Characteristic name
ATWRT – Characteristic value

Save it.

Specify files:

Window of “Start direct input program”:

Working with the Material Master Data

In the SAP MM module, material master data refers to all the material master records that are stored in the system. In other words, material master data consists of the description of all the materials that an organization not only purchases but also produces and keeps in its stock. The material master data acts as a central database of information for the materials in an organization.

Maintaining the details of all the materials at a central location not only minimizes the risk of data redundancy but also allows other departments of the organization to share this data among themselves. The other departments of the organization can use the material master data to perform various tasks, such as invoice verification and inventory management. The material master record is used by different departments of an organization, and each department requires different information about the material. For example, the purchasing department might require only the price of the material to perform price control functions; whereas, the sales department might require the sales data to prepare the sales graph of a given period of time.

To facilitate locating the relevant data, various fields have been provided in the Create Material (Initial Screen). Every department can easily locate and access the data required by it by entering the relevant details in these fields.
Continue reading Working with the Material Master Data

What are Enjoy transactions in SAP?

sap_enjoy

An enjoy transaction is one that was released with the mysap.com release, which is also know as the “Enjoy” release.
Enjoy transactions are the new transactions (from rel. 4.6A, which is nearly 10 years old now) were created to “make life easier” for the endusers and performs all the operations performed by its classical counterpart in one screen only. All clickable elements have 3D qualities, while the input and output fields remain 2D for simplified reading.
A lot of transactions have been rewritten to use the new control framework. All Enjoy transactions are having ‘N’ character at the suffix of the transaction (ME21N, VL02N etc). These transactions “replaced” older transactions. The sap enjoy transactions typically are much more user friendly in appearance, support custom controls, ALV tree and ALV grids, docking containers, node structures, picture controls in them. But transactions ending with “N” doesn’t qualify them as eNjoy. May be “N” was used to indicate “New”, SE43 & SE43N – neither of them are eNjoy transactions.

sap-enjoy

As example described data can be found in the t-code ME21N (completely writting in OOPS ABAP). The old ME21 transaction uses the classic dynpro technology without using the control framework.
Enjoy sap controls are containers that can built dunamically using objects/classes. In general batch input is not possible for those screens. The SAP material BC412 contains all about this. It’s all about ABAP Screen programming.

Today the term “Enjoy” is not common anymore.

“SAP software works the way I do.”

P.S. MCV9 transaction:

MCV9

Change BOM with future Valid From date

In case that you need to plan the change in BoM for future, it is necessary to use Change records.

Create Change record

Transaction: CC01


(press Enter)

on the next screen fill Change number desription, Valid from, Reason for change and Change no. status field:

tick check boxes as shown and press “Save”:

Change BoM

In our example (material 64103) the component 39801 will be replaced by component 39802 with Validity from 25.10.2015.

CS02:

change component number here and save the BoM:

Now, if you reopen the BoM:

What Is Outline and Scheduling Agreement

Please give the difference between Purchase Order, Outline Agreement
and Scheduling Agreement.

PO is normal where you issue the PO to a vendor and expect the delivery.
The PO is termed completed when the vendor has delivered the PO quantity
or when you have preclosed the PO when the vendor has delivered partial
quantity and he has agreed not to send anymore with ref to the PO.

Outline Agreement can be of 2 types:- Contract and SA.

Contract is where you have a contract with the vendor,may be a for a
predetermined quantity or predefined value. So everytime you need the matl,
you need to make PO ref the contract asking for the delivery of the matl.
In such instance when PO is ref with contract its called contract release
orders or call off orders.

Scheduling agreement is a long term purchase agreement, where you will
keep issuing the delivery schedules whenever there is a change in requirement
or at predetermined time intervals. The delivery schedule can be on hour/daily/weekly/monthly
basis. But it will contain different zones viz. firm/tradeoff/Forecast.
Firm zone schedules are confirmed requirement and need to be taken by ordered
party. Tradeoff zone requirement is to purchase the raw materails and ordering
party is liable to pay raw material cost, in case of requirement cancellation.
Forecast zone requirement is to help the vendor to plan his requirements.

SA is also an agreement with the vendor for the supply of matl, may
be a quanity or value. The delivery dates will be maintained in ME38 ref
the SA which are called delivery schedules.So you can maintain the delivery
schedule and communicate the vendor on Forecase basis or JIT basis. And
when you need some more matl then will only create SA deliveries using
ME38. SA could be of 2 types:- without release documentation-system will
transmit the delivery info to the vendor once you save the document.

With release documentation- after creating the delivery schedules you
need to create SA release using ME84.

The main difference between contract and SA is volume of docs generated
would be higher in contract since everytime you need to make a PO ref the
contract and its time consuming, whereas SA can be integrated with MRP
such that it automatically creates delivery schedules during MRP run provided
if there is a requirement to the matl.

ABAP programming tips

  • Q: How to convert CHAR type to RAW type?
    A:
  • Q: What does mean asterisk in front of the name?
    A: EKPO and *EKPO are usually defined in TABLES statement, and both use the DDIC structure of EKPO. Classical usage is to distinguish between old and new value of the record.
    SELECT SINGLE * FROM *bkpf is equal to SELECT SINGLE * FROM bkpf into *bkpf
    the same as SELECT SINGLE * FROM bkpf is equal to SELECT SINGLE * FROM bkpf into bkpf
  • While declaring variables, always follow the naming conventions through out your code. Your variable names talks a lot about its usage.
    Make sure your variables are of the form:

    {Prefix1}{Prefix2}_{Name} where:

    Prefix1:
    L – Local
    I – Import
    E – Export
    G – Global
    T – Table Type

    Prefix2:
    V – Single Value
    S – Structure
    T – Table
    R – Type ref to Data
    O – Type ref to Object
    E – Type ref to Exception objects

    Name – name of the variable.
    e.g.:
    lt_sel – local table
    lo_rvs – local object
    and so on.

    Before changing the parameters (type or name), make sure that you run “Where used”, make a note and change them as well.
    While working on ABAP Classes and Interfaces, Never change a super class of a framework. It could potentially bring all applications down. Double check to make sure that the code you change is in your class only.

    Ctrl + D Duplicate any line.
    Ctrl + . & Ctrl + , Comment and Un-Comment selected lines.
    Ctrl+Shift+X Deletes the whole line.
    Ctrl+Shift+V Gives All Paste options.
    To assist in locating codes, can be a bookmark, using a combination: CTRL + ALT + (0 to 9).
    To go to bookmark created, use combination CTRL + (0 to 9).

    _sap

    • Please ensure that IV_UNAME (SY-UNAME) and IV_LANGUAGE (SY_UNAME) are mandatory for all modules.
    • Q: How to debug IDOCs inbound processing (most first FMs on receiver system (under ALEREMOTE non dialog user)?
      A: Simple and stupid solution is to put eternal loop in form FA5_DOCUMENT_SYNTAX_CHECK (program LEDI1FA5):

      Then the process will be available for debugging in the transaction SM50.
    • Please create lock objects on the header tables and make sure that you obtain a lock before changes and release the lock after changes.
    • Make sure that you transactions are atomic. Either commit your work after all changes are successful or Rollback in case of error. If you rollback, make sure that you have released the locks.
    • Q: How to pass dynamic varable into SELECT … WHERE IN clause?
      A:
    • During save, please make sure that entries in all the text (_T_*) tables that relate to your modules are also saved. If no data exists, treat it as an error. (As across check, you can verify the same by executing the view and making sure that the data is returned correctly)
    • The Function should be RFC Enabled. Never raise an exception. Always return errors in the ET_RETURN (Type BAPIRET2) structure.
    • Never hardcode text strings. Make sure that you use a text element. But use it with text reference.
      E.g. If you have an error during validating the email, use it as “Email ID is required”(001) instead of using text-001. This will ensure that error messages are displayed regardless of user logon language.
    • At the end of the function, Always call “get details” and return the values as export/table values. This will serve the purpose of reflecting the data as-is in the DB back to the user and will save another round trip to retrieve it again.
    • Q: How to get variable value from another running program?
      A:
    • Update audit fields created by, created date, created time only during create.
    • Please ensure that IV_UNAME (SY-UNAME) and IV_LANGUAGE (SY_UNAME) are mandatory for all modules. Extract the data for the language specified.
    • Q: Where are the packing handling units data stored during execution of transaction VL01/VL02/VL32N”? CVEKP table is always empty.
      A: The variable is (SAPLV51G)IVEKP[]

    “Changed REM profile regarding generation of postprocessing records”

    You can display backlogs from the backflush in repetitive manufacturingusing Transaction MF47/COGI. The repetitive manufacturing profile of the assembly provides for the generation of collective & individual postprocessing records.
    An inconsistency may arise between a collective record and the respective single records, that is, the quantity of the collective record is not equal to the cumulative quantity of the respective single records.

    Solution:

    MFBF/MF42N:

    or, JITM action BFLU:

    press the “Components” button in JITB and fill “Assembly” with the finished good numbers.

    JITM action BFLU:

    You will get the list of components:

    Carry out transacion SA38 and program ZINCON_REPROC in it and maintain the relevant components from the step above.

    You will get the list of all inconsistencies and final message “All displayed inconsistencies have been deleted”.

    Reprocess errors once again in JITB.

    Sales and Distribution