A line type defines the structure of a single row in an internal table. · It can be a: Data element (e.g., MATNR) Structure (e.g., SFLIGHT) Custom type created via TYPES Example: TYPES: BEGIN OF ty_line, matnr TYPE matnr, maktx TYPE maktx, END OF ty_line. Here, ty_line is the line type ...
SAP EWM Help Latest Questions
Aspect Service Definition Service Binding (Implementation) Purpose Lists which entities to expose Specifies how and in what format to expose File Type .srvcds .srvsbnd Output Logical definition Concrete, runnable OData service Required For Access? Not enough alone Needed to access via browser/API/UI Draft Support Not defined here Chosen in binding options
RAP is structured in 3 layers: 1. Data Modeling & Definition Layer Component Purpose CDS Data Model Defines entities and relationships (tables, views) CDS View Entities Provides the foundation for business objects Associations Represent relationships between entities Annotations Define metadata (UI, OData, behavior, etc.) 2. Business Service Provisioning Layer Component Purpose Behavior Definition (.behavior) Defines ...
Joins combine rows from two or more tables based on a related column, usually a key field. ABAP supports various join types (INNER JOIN, LEFT OUTER JOIN, etc.) mostly used inside Open SQL queries. How to Use Joins: SELECT a~vbeln, a~erdat, b~posnr, b~matnr
It is a file (with .behavior extension) that specifies the business behavior of an entity (CDS view), and it controls: Which operations are allowed Which fields are modifiable Which validations or determinations are triggered Custom logic, like actions Key Purposes of Behavior Definition Function Description Enable CRUD operations Define ...
Aspect DDIC View (ABAP Dictionary View) CDS View (Core Data Services View) Definition Tool Created using SE11 (Graphical interface) Created using ADT (Eclipse) with SQL-like DDL syntax Technology Base Classic SAP NetWeaver Modern SAP HANA / S/4HANA Definition Style GUI-based definition (drag-and-drop style) Text-based, code-centric with annotations Join Support Basic joins (Inner, Outer) Advanced ...
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, ...
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