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

As a sequence I am going to describe some important T-code of  MM module.

ME17 Archive Purchasing Info Records 

This transaction is used to archive purchasing info records. Before a record is ready to be archived, it must have the deletion flag set, which can be achieved using transaction ME15.

ME18 Send Purchasing Info Records 

This transaction is used to send purchasing info records to another system via ALE. It is possible to restrict the purchasing info records to be sent by entering a vendor, material, material class or info record number. The user can enter the logical system where the source list is to be sent.

ME1A Archived Purchasing Info Records 

This transaction is used to access archived purchasing info records. The archived info records can only be accessed if read from a flat file, which has to be on an application server. If the archived records are held externally, then they will need to be loaded onto the server in order to be accessed.

ME1E Quotation Price History 

This transaction is used to display price history from the purchasing info record. The resulting display can be restricted by entering a vendor, material, material group, purchasing organization, plant or purchasing group. The report will show the current price for each relevant purchasing info record. The price details can be accessed from the results screen. 

ME1L Info Records per Vendor 

This transaction is used to display all the purchasing info records for a single or range of vendors. The output can be restricted by entering a material, material group, purchasing organization, plant or purchasing group. The output shows the purchasing info record details for each vendor within the selection criteria.

ME1M Purchasing Info Records per Material

 This transaction is used to display all the purchasing info records for a single or range of materials. The output can be restricted by entering a vendor, material group, purchasing organization, plant or purchasing group. The output shows the purchasing info record details for each material within the selection criteria.

ME1P Purchase Order Price History 

This transaction is used to display the purchase order price for each purchase info record. The selection can be restricted by vendor, material, material group, purchasing organization and plant. The output is in purchase info record sequence and shows the purchase order detail for each purchase info record. The date, net price, quantity, purchase order number and variance are shown for each purchase order.

ME1W Purchasing Info Records per Material Group 

This transaction is used to display the purchasing info records for a material group.The selection can be restricted by material group, vendor, purchasing organization, plant and purchasing group. The output is in material group order and shows all the relevant purchasing info records for each material group. The details of the purchasing info record include the net price from the info record and the net price from purchase orders.

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