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
DPM125Beginner
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
DPM125Beginner
Exposed Associations An exposed association is one that is defined in a CDS view and is made available (exposed) to consumers of the view — such as other CDS views, analytical queries, or OData services. You define the association using the ...
DPM125Beginner
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 ...
DPM125Beginner
Association An association is a declarative relationship between CDS entities (like foreign keys), defined using the association keyword. Key Characteristics: Lazy/Evaluated-on-demand: Data from the association is not fetched unless it is explicitly accessed using a path expression (like to_customer.name). Navigation-style ...
Example CDS view to join delivery table LIKP and LIPS on VBELN field and with LFART in where condition ------------------------------------------------------------ CDS VIEW: ------------------------------------------------------------ @AbapCatalog.viewEnhancementCategory: [#NONE] @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'CDS - Inner Join' @Metadata.ignorePropagatedAnnotations: true @ObjectModel.usageType:{ serviceQuality: #X, ...
Here in this example, We are going to create CDS view with Case statement, here new field “DocText” will be added and value will be calculated based on below. case ...
DPM125Beginner
In SAP, an enhancement refers to a mechanism that allows you to add or change standard SAP behavior without modifying the original SAP code. Enhancements are essential for implementing custom business logic while keeping the SAP standard upgradeable and maintainable. Purpose ...
DPM125Beginner
Purpose of TMG Events Events in TMG are used to: Validate data before it’s saved. Set default values when creating entries. Restrict access to rows based on user roles. Log changes or trigger custom logic. Enforce complex business rules beyond field-level checks. Where You Configure TMG Events Transaction: ...
DPM125Beginner
The Table Maintenance Generator allows authorized users or support staff to: Maintain data in custom or standard tables without writing ABAP code. Provide a standardized UI for table maintenance. Enforce data consistency and validation through events and screen logic. Use Case Description Maintain custom config tables Enter ...