Using BAPI upload excel file for t-code AS02 in SAP

Using BAPI " BAPI_FIXEDASSET_CHANGE " create a zprogram to upload excel file for mass change fixed asset in SAP. REPORT  ZAS02_ASSET_CHANGE_UPLOAD . TYPE-POOLS :  truxs . " Structure for Excel data TYPES :  BEGIN  OF  ty_excel ,          anln1  TYPE  anln1 ,          bukrs  TYPE  bukrs ,          kostl  TYPE  kostl ,          werks  TYPE  werks ,          prctr  TYPE  prctr ,         END  OF  ty_excel . DATA :  lt_excel     TYPE  TABLE  OF  ty_excel ,       ls_excel     TYPE  ty_excel ,     ...
Post a Comment

SAP Material Management (MM) Important T-code: Part-1

 ME00 :Purchasing Menu 

This transaction gives users access to the purchasing menu. The areas accessible from this menu include the purchase order, purchase requisition, outline agreement, request for quotation, master data and purchasing reports.

 

ME01 :Maintain Source List 

This transaction is used to create a source list for a material at a specified plant. The selection screen requires a material and a plant to be entered. On the detail screen, the user can add a list of available sources of supply for a material, entering the periods during which procurement from each vendor is possible. The user can flag a vendor as the preferred source of supply for the material and also flag vendors as blocked for procurement. 


ME03 :Display Source List

 This transaction is used to display the source list for a material at a specific plant. The selection screen requires a material and a plant to be entered. The display will show a list of vendors if a list has been maintained. The source list shows the valid from and to dates for each vendor, the vendor number, purchasing organization and outline agreement, if relevant.

 

ME04 :Changes to Source List 

This transaction shows the changes that have been made to a source listfor a specific material. The selection requires a material and plant to be entered. The user can restrict the resulting display by entering the person’s name whose changes to the source list are to be shown and a date from which all changes are to be viewed. The resulting display shows the details of the change to the source list including user ID, date and time of the change, document change number and the values that were changed.

 

ME05 :Generate Source List 

This transaction is used to generate a source list using the system rather than manually entering values. The initial screen allows a single or range of materials to be selected and the dates from which the system will review the transactions to develop the source list. If the test run indicator on the selection screen is highlighted, the systemwill display a simulation of the source list changes, rather than make the changes. 


ME06 :Analyze Source List 

This transaction is used to analyze the source list for a material or range of materials. The selection screen allows the user to enter a range of dates between which the analysis should be performed. The resulting display will show, for each material/plant combination, whether there is a source list missing.

 

ME07 :Reorganize Source List 

This transaction is used to reorganize the source list. The user is required to enter a material and the date before which all records are to be deleted. The transaction will delete all source list entries before the date entered and is used to remove out of date source list records.

Comments

Post a Comment

Popular posts from this blog

New commodity code create in SAP S/4 Hana

Image
Commodity codes are internationally recognized reference numbers. A code describes a specific product when importing or exporting goods. You will use this code on any customs declarations and can find them in the Trade Tariff tool. Before S/4 Hana we can create commodity code by using GUI but from S/4 Hana need to use fiori interface to create commodity code. Let's explore it.   T-Code: /UI2/FLP Launchpad is opening and then select Manage commodity codes Tile. After that need to provide No. Scheme contend and click Go button and then need to click add button. Give commodity code and Description with valid from date to valid To date. After that press save button. That's it, your commodity code is created and now need to assign it against material number. Check /SAPSLL/CLSNR table for commodity code added or not.  Check MARC table stawn field to confirm material level assigned or not.
Read more

BAPI to Change STO PO/ PO Delivery date in SAP

Image
 In SAP, a BAPI (Business Application Programming Interface) serves as a standardized method to allow external applications or custom code to access and interact with data and processes within SAP business objects, essentially providing a way to "call" specific business functions within the SAP system from outside applications, ensuring data integrity and proper business logic execution through a defined interface. Function: BAPIs enable external applications to read, create, update, or delete data within SAP by interacting with the underlying business object model. Implementation: BAPIs are implemented as function modules in the SAP system, which can be called remotely using the Remote Function Call (RFC) protocol. Business Object Repository (BOR): BAPIs are defined as methods of SAP Business Object Types, which are stored and managed within the BOR.  Benefits:     Standardized Access: Provides a consistent way for external applications to interact with SAP fun...
Read more

Alpha IN/OUT to Handle Leading Zeros in SAP ABAP

 In SAP we use SHIFT keyword to delete leading zero's. Keyword is: SHIFT Variable LEFT DELETING LEADING '0'.  SHIFT Variable RIGHT DELETING LEADING '0'. We can also delete & add these zero's using new ABAP syntax. FM:  'CONVERSION_EXIT_ALPHA_OUTPUT' 'CONVERSION_EXIT_ALPHA_INPUT' DATA int_val TYPE char10 VALUE '0000012345' . DATA Chng_val TYPE char10. CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = int_val IMPORTING output = Chng_val. Final result: 12345    DATA Chng_val TYPE char10 VALUE '12345' . DATA int_val TYPE char10. CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT' EXPORTING input = Chng_val IMPORTING output = int_val.  Final result:  0000012345
Read more