Feature Row Store Column Store Data Layout Row by row Column by column Best Use Case OLTP (transactions) OLAP (analytics, reporting) Read Performance Good for full row reads Excellent for column-specific reads Write Performance Fast for row-level writes Slower for frequent updates/inserts Compression Lower Higher Aggregations & Filters Slower Much faster
SAP EWM Help Latest Questions
DPM125Beginner
It ensures that: Users see data in a friendly, understandable format (e.g., formatted dates, leading zeros removed). System stores data in a standardized internal format (for consistency and integrity). How It Works When a domain is assigned a conversion routine: At input (user ...
DPM125Beginner
Using an AMDP (ABAP Managed Database Procedure) inside another AMDP can be useful in specific scenarios, especially when trying to modularize complex logic or reuse database-side procedures. However, it comes with certain considerations and limitations. Code Reusability If you have logic encapsulated ...
adminBeginner
Create a Function module with following code, use following parameter in FM Use Node WHRO (Outbound delivery Header Node IV_LGNUM TYPE /SCWM/LGNUM IT_DATA TYPE STANDARD ...
DPM125Beginner
Polymorphism allows different classes to be treated through a common parent reference, while still calling their own version of a method at runtime. When to use it: When you want to treat multiple objects generically, but still get their specific behavior. In ...
DPM125Beginner
Synchronous RFC (sRFC) Default type when you call a function module via RFC. The caller program waits until the remote system has completed the function execution and returned the result. Example use: Real-time data retrieval (e.g., fetching stock from another SAP system). FM execution: ...
DPM125Beginner
The Enhancement Category in SAP defines how a structure or table can be enhanced with custom fields by a developer or customer without breaking system integrity or compatibility. In SE11, when you create or display a table or structure, under the ...
DPM125Beginner
A macro is a text replacement technique defined using DEFINE … END-OF-DEFINITION. It’s similar to a preprocessor directive and is expanded at runtime. When to use: · For short code blocks with similar patterns (e.g., logging or repetitive output). · Used mainly in ...