Posts

Showing posts from May, 2025

ALSM_EXCEL_TO_INTERNAL_TABLE

 *  CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE' *    EXPORTING *      filename                = p_file *      i_begin_col             = '1' *      i_begin_row             = '3' *      i_end_col               = '22' *      i_end_row               = '99999' *    TABLES *      intern                  = it_excel *    EXCEPTIONS *      inconsistent_parameters = 1 *      upload_ole              = 2 *      OTHERS                  = 3. * *  IF sy-subrc <> 0. *    MESSAGE ID sy-msgid TYPE sy-m...

Processing Internal and External Data

  All working data within the  internal session   is referred to as internal data. Assignments Numeric Calculations Character String and Byte String Processing Date and Time Processing Structures Enumerated Objects Internal Tables Meshes Attributes of Data Objects Streaming External data generally covers all data saved outside of the  internal session . The following sections describe the processing of external data. ABAP Database Access Data Clusters ABAP File Interface Refer  ABAP - Reference - ABAP Keyword Documentation

SAP CRM

ABAP Open/ Fetch Cursor

  The Open SQL statement OPEN CURSOR opens a database cursor for the result set of the main query defined after FOR and links a cursor variable dbcur with this database cursor. The results set of the main query can be read with the statement FETCH. If the addition WITH HOLD is specified, the database cursor is not closed by a database commit executed using Native SQL. Syntax OPEN CURSOR  [ WITH HOLD ]  @dbcur | @DATA(dbcur) FOR    [ WITH     +cte1 AS ( SELECT  subquery_clauses  ) [ ,     +cte2 AS ( SELECT  subquery_clauses  )     ... ] ]   SELECT  mainquery_clauses    [ UNION ... ]    [ UP TO ... ]   [ OFFSET ... ]    [ abap_options ] . Fetch cursor The  Open SQL  statement  FETCH  extracts the requested rows (using the addition  INTO  or  APPENDING ) from the results set of the  database cursor ...

SAP Technical (ABAP, HANA, BTP, MDG) Interview questions (2-3 Yrs Exp)

SAP ABAP DDIC How to save data in small case in module pool? How to create row store table? How to create search help exit. Reports Difference between Table control and Table control wizard Append vs collect Events of interactive reports, module pool,  FM/RFC and BAPI If BAPI is taking longer to execute mass data update, what can be solution? Enhancements (Exits, BAdIs, BTEs) How to create pre/post- Exits? BADI sorter works in classical BADI or Kernel BADI? Conversions - LSMW, BDC, LTMC Forms - Scripts, Smartforms, Adobe Forms Adobe forms - interactive adobe form. one more topic Object Oriented Concepts Workflows workflow interview questions: What is Workflow? Or Define Workflow Give one Example of Workflow What is disadvantages of Manual Workflow lack of transparency long waiting time lack of deadline monitoring What is SAP Business Workplace standard working environment for business user to receive the messages, documents, and work-items. Tcode - SBWP What is Task and Work-items ...

rough notes

Image
 BAL_DB_SEARCH      AIN -Asset Intelligence Network      /n/GRCPI/GRIA_EAM   https://community.sap.com/t5/technology-blogs-by-sap/benefit-from-sap-master-data-governance-on-sap-s-4hana-2023-feature-pack/ba-p/13808294 https://codesap.wordpress.com/2015/01/21/debug-smartforms-in-production-environment/   https://community.sap.com/t5/application-development-and-automation-blog-posts/debugging-smart-forms-in-production-environment/ba-p/13245694 https://sapcodes.com/2015/11/19/debugging-a-smartform/ https://codesap.wordpress.com/tag/debug-smartform/ https://www.indexit.org/how-to-debug-smartforms-in-sap-abap/ https://community.sap.com/t5/application-development-and-automation-discussions/how-to-delete-data-from-dynamic-internal-table/m-p/5345410 https://www.sapnet.ru/abap_docu/ABAPMODIFY_ITAB.htm#&ABAP_VARIANT_3@3@ ========================== Profile for Maintaining Task Lists   Relationships ==>The chronological order and time-based de...

POSDM vs POSDTA

  POSDM(Point of Sales Data Management) system traditionally sits under BW as its generally an integral component/system within BW. However there are few customers who have decoupled POSDM and BW primarily to reduce the dependency of BW system, wherein they can send Store/Online sales data directly from POSDM to various SAP(BW,ECC etc) and other Non SAP Systems too. Nowadays we have been talking about POSDTA and CAR(Customer Activity Repository) where customers have started the transition journey from POSDM to POSDTA. It is quite essential to know how POSDTA is different to POSDM and what are the new features within POSDTA. Well, POSDTA(Point of Sales Data Transfer and Audit) is one of the various modules of CAR. The other modules of CAR are listed below 1.DDF(Demand Data Foundation) 2.UDF(Unified Demand Forecast) 3.OSA(On Shelf Availability) 4.OPP(Omnichannel Promotional Pricing) 5.Multichannel Transaction Data Management 6.Inventory Visibility with Omnichannel Article Availabilit...

SAP Financial Supply Chain Management

SAP Financial Supply Chain Management (FSCM) focuses on managing cash flow, improving working capital, and streamlining financial processes across the entire supply chain, from supplier selection to payment processing and reporting. (OR) FIN-FSCM optimizes the financial and information flows within a company and between business partners. It contains the following components:   SAP Bank Relationship Management (FIN-FSCM-BNK)     -      Application for monitoring and releasing payment media in payment transactions with banks. SAP Biller Direct (FIN-FSCM-BD) Application for electronic issue of bills and payment SAP Cash and Liquidity Management (FIN-FSCM-CLM) - Application for managing liquidity items SAP Collections Management (FIN-FSCM-COL) - Application for proactive receivables management SAP Credit Management (FIN-FSCM-CR) - Application for supporting and automating credit decisions SAP Dispute Management (FIN-FSCM-DM) - Application for efficient process...

Definitions

SAP IBP Powered by SAP HANA, this cloud-based solution combines sales and operations planning (S&OP), forecasting and demand, response and supply, demand-driven replenishment, and inventory planning. Automated, tightly coordinated supply chain planning processes Advanced machine learning algorithms and planning capabilities Native integration with SAP Supply Chain Control Tower and other solutions ----------------- SAP ISU SAP IS-U, which stands for Industry Solution for Utilities, is a comprehensive SAP module designed for utility companies (e.g., electricity, gas, water, wastewater providers). It provides a wide range of functionalities to manage various aspects of their business, including customer care, billing, energy data management, and more.  ----------------- SAP BRIM SAP BRIM (Billing and Revenue Innovation Management) is a solution that helps businesses manage their billing, revenue, and customer engagement processes more efficiently, especially for recurring revenue...

SAP CPI

 Concepts Integration Flows Types of Adapters consuming prepackaged content content modifier content enricher data transformation and mappings content based routingsender and reciever steps integration process and local subprocess exception subprocessevents asynchronous message handling build completer wnd to end flow, consume iflows condition based routing message conversions data store multicast splitter join and gather process call payload monitoring trace function logging and tracing hybrid deployments enhancement features security  What is SAP CPI?     What types of integration patterns are supported in SAP CPI?     What are adapters in SAP CPI?     What are the basic components of an Integration Flow in SAP CPI?     Which message protocols does SAP CPI support?     What is an iFlow in SAP CPI?     What is Message Mapping in SAP CPI?     What is the purpose of the Content Modifier in SAP CPI?   ...

SAP BRIM