Feature OLTP OLAP Full Form Online Transaction Processing Online Analytical Processing Purpose Run daily operations Analyze and report on business data Operation Type Short, frequent transactions Complex queries, aggregations Data Volume Large number of small transactions Smaller number of large queries Performance Focus Speed of write operations Speed of read/analysis Data Structure Highly normalized Often denormalized (e.g., star schema) Examples Insert/update orders, ...
SAP EWM Help Latest Questions
Identify the Type of CDS View You Want to Extend There are different layers in RAP: Interface View (I_) Consumption/Projection View (C_ or ZC_) Data Definition View (Z_) Usually, you extend interface or projection views. Use the EXTEND VIEW Statement You can extend a CDS view using ...
DCL (Data Control Language) in CDS is used to define and control data authorizations for CDS views.In other words, it allows you to restrict access to specific data records based on user roles, so that users can only see ...
1. Picking in SAP EWM Picking is the process of retrieving products from their storage bins in the warehouse to fulfill a customer order or delivery requirement. How Picking Works in EWM Sales Order → Outbound Delivery is created in ERP ...
FIELD-SYMBOLS are like pointers in other programming languages. They don’t store data themselves but rather point to memory locations dynamically. This is especially useful when you don’t know the field or structure you’re working with until runtime. Step 1: Declare an ...
A class can implement multiple interfaces at once, which allows you to combine functionality from many sources. Example: ” First interface INTERFACE if_flyable. METHODS: fly. ENDINTERFACE. ” Second interface INTERFACE if_swimmable. METHODS: swim. ENDINTERFACE. ” A class implementing multiple interfaces CLASS cl_duck DEFINITION. PUBLIC ...
SAPscript is the oldest SAP form development tool, mainly used for printing business documents such as invoices, purchase orders, delivery notes, and payment advices. It provides a way to design, format, and print text-based documents directly from SAP. How it works: The ...
This replaces the need for LOOP AT, IF, and APPEND all in one line—powerful and readable. *&---------------------------------------------------------------------* *& Report ZREP_LCLCLASS *& *&---------------------------------------------------------------------* *& *& *&---------------------------------------------------------------------* REPORT zrep_lclclass. TYPES: BEGIN OF ty_user, name TYPE string, status TYPE string, END OF ty_user. DATA: lt_users TYPE STANDARD TABLE OF ty_user WITH EMPTY KEY, lt_names TYPE STANDARD TABLE OF string WITH EMPTY KEY. lt_users = VALUE #( ( name = 'Alice' status = 'ACTIVE' ) ( name = 'Bob' status = 'INACTIVE' ) ( name = 'Charlie' status = 'ACTIVE' ) ). lt_names = VALUE string_table( FOR user IN lt_users WHERE ( status = 'ACTIVE' ) ( user-name ) ). LOOP AT lt_names INTO DATA(name). WRITE: / name. ENDLOOP. Output: Alice Charlie