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-2

This is a sequence post of previous one. Here I am sharing some important MM t-code with description. Hope it will help us in our daily life task.

 

ME08 Send Source List 

This transaction is used to send source lists to another system via ALE. It is possible to restrict the source lists to be sent by entering a material, material class or plant. The user can enter the logicalsystem where the source list is to be sent.

ME0M Source List for Material 

This transaction is used to display the source listsfor a givenmaterial.The selection screen allows the user to enter a material or range of materials, and a plant or range of plants. If no values are entered, the resulting display will show all the source lists for all materials. 

ME11 Create Purchasing Info Record 

This transaction is used to create a purchasing information record for a material. The info record can be for a material/vendor combination or for a material group/vendor combination. The user can select the type of info record to be created: standard, subcontracting, pipeline or consignment. The info record can contain the net price for the material or material group charged by the specified vendor, as well as other information on delivery time, minimum quantity, purchasing group and shelf life.

 ME12 Change Purchasing Info Record 

This transaction allows the user to change an existing purchasing info record. The info record number can be entered or the user can enter a combination of vendor number, plant, material and purchasing organization to access the record. The user can change valuesin the info record,such as net price for the material or material group charged by the specified vendor, as well as other information on delivery time, minimum quantity, and purchasing group.

ME13 Display Purchasing Info Record 

This transaction is used to display the details of an existing purchasing info record. The info record number can be entered or the user can enter a combination of vendor number, plant, material and purchasing organization to display the info record. 

ME14 Changes to Purchasing Info Record 

This transaction is used to display changes that have been made to a purchasing info record. The selection screen requires that a purchasing info record number is to be entered, but the results can be restricted by entering the user ID of the person who made the change and the change date. The resulting display shows the entry and the change details of the info record, including the date of change, document change number and the table and field that was changed.

ME15 Flag Info Record for Deletion 

This transaction is used to flag a purchasing info record for deletion. The info record number can be entered or the user can enter a combination of vendor number, plant, material and purchasing organization to flag the info record for deletion. The user can select either the complete info record for deletion or just the data for the purchasing organization.

ME16 Deletion Proposals for Info Records 

This transaction is used to delete purchasing info records based on the selection entered. The transaction allows the user to enter the vendor, material, material group, purchasing organization, plant and purchasing group. The key date for the document or the entry date must be entered for this transaction. This process is useful to delete info records for vendors who are no longer used by your company.

 


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