Internal Tables – Introduction
- In BW related ABAP, you work mainly with tables. Tables are the essential data structures in the database system.
- Besides database tables, you can create internal tables which exist only during the runtime of your program.
- A particularly important use for internal tables is for storing and formatting data from a database table within a program.
- The data type of an internal table is normally a structure. Each component of the structure is a column in the internal table.
- The number of lines in an internal table is not fixed. Depending on requirements, the system increases the size of internal tables at runtime.
- The data is stored on a row-by-row basis, where each row has the same structure.
- It has two different parts. Header Line (optional) and Body (Compulsory). Any value that comes to or goes from internal table, that travels through header line.
The internal table with header lines are now obsolete.
- You can create explicit work area
- The statements for the access to individual rows use explicit work area specified.
Declaring Internal Tables
Method 1
TYPES BEGIN OF TY_FLY, CARRID TYPE SPFLI-CARRID, CONNID TYPE SPFLI-CONNID, CITYFROM TYPE SPFLI-CITYFROM, CITYTO TYPE SPFLI-CITYTO, END OF TY_FLY. DATA WA TYPE TY_FLY. DATA ITAB TYPE TABLE OF TY_FLY.
Method 2
DATA WA TYPE SPFLI. DATA ITAB TYPE TABLE OF SPFLI.
In the above two methods, WA is the work area defined for internal table ITAB.
Method 3
TABLES SPFLI. DATA ITAB TYPE TABLE OF SPFLI.
In this method TABLES SPFLI statement creates an Implicit Header Line for Database table SPFLI. But it can be used as explicit header line for internal table ITAB.
You may also like
BW System Scout
29 March, 2022
BW4HANA Interview questions
7 March, 2022
Using CDS View as source for Open ODS View in BW4HANA
4 February, 2022
1 Comment
SAP SERVER ACCESS @ Low Price
-SAP Server access are available for Testing, training & practice purpose..
-24X7 technical support with best PRICE & SERVICE GUARANTEED…
-We have excellent communication over FIBER OPTICAL CABLE with 24 HOURS power backup for all below server’s.
A) HANA SERVER’S:-
1) SAP S4 1610 + SLOG + Cash Management + HANA SPS12 + HANA LIVE
2) SAP Simple Finance (S4) + Simple Logistics 1511
3) SAP FIORI on HANA
4) SAP BI/BW 757 on HANA
5) SAP GRC 10.1 on HANA
6) SAP BPC 10.1 on HANA
7) SAP UI5 on HANA
8) SAP ECC IDES EHP7 ON HANA
9) SAP Screen Personas 3.0 on HANA
10) SAP Revenue Accounting 1.1
B) SAP Net weaver Based Server:-
1) SAP Netwaever 7.4 (ABAP + JAVA)
2) SAP PI/PO 7.4
3) SAP PO 7.5 + JAVA STACK
4) SAP Adobe Forms / ABAP/ JAVA Webdynpro
5) SAP Solman 7.1
6) SAP BI 7.3 or 7.4
7) SAP BPC 10.1
8) SAP GRC 10.0 or 10.1
9) SAP UI5 / Netweaver Gateway 2.0 + Web ID
10) SAP BRF+
11) SAP XMII 14.0
12) SAP BOBJ 4.1 + BODS 4.2 + All Client Tools
13) SAP ESS/MSS
14) SAP IDM 8.0
15) SAP Disclosure Management 10.1
C) SAP Business SUIT:-
1) SAP IDES ECC 6.0 EHP5/6/7
2) SAP IDES CRM 7.0 EHP2
3) SAP SCM/APO 7.0 EHP3
4) SAP SRM 7.0 EHP3
5) SAP NON IDES EHP8
D) SAP IS Server:-
1) SAP IS Utility
2) SAP IS Retail
3) SAP Insurance
4) SAP IS Oil & Gas
5) SAP IS Auto
6) SAP IS SLCM (Student Life Cycle Management)
7) SAP IS REMS (Real State Management System)
8) SAP EHSM 3.0/5.0
9) SAP TM 9.0
10) SAP EWM 9.0
11) SAP ETM
12) SAP IS Healthcare + ECC
13) SAP MDG 6.4 / 7.4
14) SAP CPM 2.0
E) SAP Mobility Server:-
1) SAP SMP 3.0 SP5 + SDK + Agentry
2) SAP Work Manger 6.3
3) SAP Afaria
F) SAP Specific Module Server:-
1) SAP PSCD + ECC
2) SAP FSCD + ECC
3) SAP DBM (Dealer Business Management) + ECC
4) SAP HYBRIS 5.7
5) SAP VIM 7.0
6) SAP MRS 9.0
7) SAP MRS 10.0
Free DEMO & more information, please contact us on:-
MAIL :- KPHBRK@gmail.com
MOB NO :- +91-7095161559
SKYKPE :- KPHBRK
website : http://www.erptrainingindia.com