Posts

Last Physical Inventory Date In Quant (LQUA) Table - SAP Upload Tool.

Generally, when an organization goes live with warehouse management functionality, it faces a big challenge to upload the last physical inventory date from Inventory management data (MARD-DLINL) in warehouse management quant data (LQUA-IDATU). This code can be used to upload directly in quant data (LQUA) table. Once you upload the last physical inventory date in quant data table, you need to make changes in Cycle count physical inventory program. CODE: *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT  zupdate_lqua . TYPES :  BEGIN  OF  gty_upload ,          lgnum  TYPE  lqua - lgnum ,          lqnum  TYPE  lqua - lqnum ,          idatu  TYPE  lqua - idatu ,   ...

Routing Creation(CA01) - SAP Upload Tool - Using BDC.

Image
Routing defines the sequence of activities performed at the work center. Routing plays an important role in calculating production cost, machine time, and labor time. A routing is a description of which operations or list of activities has to be carried out during the production and planning process. It also tells what order or sequence the activities/operations needs to be carried out at work centers or machines. This program can be used for routing creation. Its a simple program which takes care of multiple options. This program also helps to generate the file format, which will remove the dependency on the file format all the time.  SAMPLE PROGRAM: REPORT zpp_routing_creation. *&---------------------------------------------------------------------* *& Report ZTEST *&---------------------------------------------------------------------* *& Report Name        : ZPP_ROUTING_CREATION *& Report Title    ...

SAP HR-OM/PA - Interview Questions And Answers.

Here you find some of the basic questions related to SAP Organizational Management(OM) & Personnel Administration(PA) related to SAP HR Module. Organizational Management (OM)  1. Where Do You Set Up The Integration Between PA & PD (OM) Structures? Answer:  Set the switches PLOGI-ORGA and PLOGI-PLOGI to active plan version in the table T77S0 (IMG) 2. What Are The Commonly Used Infotypes/ Subtypes In Organizational Management (OM)? Answer:  Commonly used Infotypes in OM are: 1000-Objects 1001-Relationships: Sub Types: O-O: A/B 002 O-S:  A/B 003 O-S:  A/B 012 O-K: A/B 011 S-S:  A/B 002 S-K: A/B 011 S-P: A/B 008 S-C: A/B 007 1005-Planned Compensation 1007-Vacancy 1008-Account Assignment 1013-EG/ESG 1610-EEO/AAP for US 1612- Worker Compensation State & Code for US 1613- Worker Compensation State, Code & Attribute for US 3. Name The Report That Lets You To Change The Status Of Several Objects At One Go? Answe...

Download Data Into XLSX/MHTML File/Format - Reusable FM.

Image
Most of the times, we are able to upload to upload XLSX file to internal table but to download data in XLSX format we struggle most of the time. Here we are presenting a simple solution to download data in XLSX/MHTML/XML format. This function module gives you an option to select a specific filetype to be chosen. If no filetype is chosen among XLSX/MHTML/XML, then a pop up window will appear as shown below to select required filetype. Create a simple function module as described below: IMPORT:   EXPORT: CHANGING: Function Module Code: FUNCTION  zdownload_file . *"---------------------------------------------------------------------- *"*"Local Interface: *"  IMPORTING *"     REFERENCE(I_FIELDCAT) TYPE  LVC_T_FCAT OPTIONAL *"     REFERENCE(I_SORT) TYPE  LVC_T_SORT OPTIONAL *"     REFERENCE(I_FILT) TYPE  ...

BAPI_INSPECTIONPLAN_CREATE-Quality Inspection Plan (Single File) With Long Text Upload.

Generally in all projects where Quality Management is implemented, there is a need of Mass upload of Quality Inspection Plan.  SAP Transaction code for this is QP01. So here we have made a tool for uploading quality plan using BAPI BAPI_INSPECTIONPLAN_CREATE which also support of uploading long text. To Download With File Template ,  Click Here . CODE: REPORT  zqm_inspection_plan_wlt_upload . TYPE-POOLS  :  slis . TABLES  : sscrfields . *----------------------------------------------------------------------* *     SELECTION SCREEN *----------------------------------------------------------------------* SELECTION-SCREEN  BEGIN  OF  BLOCK  s2  WITH  FRAME  TITLE  TEXT - 001 . PARAMETERS :  p_file   TYPE  ibipparms - path   . SELECTION-SCREEN  END  OF  BLOCK  s2  . *-------------------------------------------------...