Understanding Database Transactions: ACID Properties Explained

What is a Transaction? A transaction is an event which occurs on the database. Generally a transaction reads a value from the database or writes a value to the database. If you have any concept of Operating Systems, then we can say that a transaction is analogous to processes. Although a transaction can both read … Continue reading Understanding Database Transactions: ACID Properties Explained

ABAP Internal Tables Explained: Types and Usage

Internal tables are structures which are used to store temporary data during processing of an ABAP program. Following are the different kind of internal tables STANDARD SORTED HASHED CategoryInternally managed byAccessPrimary table keyWhen to useHintsSTANDARDPrimary table index (that's why these tables are called index tables)Table indexTable keyAlways non-unique, i.e. duplicate entries are always allowedDefinition of an … Continue reading ABAP Internal Tables Explained: Types and Usage

Understanding BDCDATA in SAP BDC Programs

What is use of BDCDATA ? While writing a BDC program, standard structure ‘BDCDATA’ is used to collect this information. The BDCDATA structure includes the following fields: PROGRAM DYNPRO DYNBEGIN FNAM FVAL BDCDATA structure is used to create an internal table in the BDC program which collect the above information for an entire transaction. Syntax … Continue reading Understanding BDCDATA in SAP BDC Programs

Inner Join and parallel Cursor in ABAP

We will see some examples of inner join and parallel cursor in abap Parallel Cursor Method REPORT ZPARALLEL_CURSOR. DATA: it_ekko TYPE TABLE OF ekko, wa_ekko TYPE ekko, it_ekpo TYPE TABLE OF ekpo, wa_ekpo TYPE ekpo. DATA: lv_tabix TYPE sy-tabix. SELECT * from ekko INTO TABLE it_ekko UP TO 50 ROWS. SELECT * from ekpo INTO … Continue reading Inner Join and parallel Cursor in ABAP