SAP ABAP Class CL_OIUP_CODE_GEN (PDM - Code generation class)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU_P (Package) Partitioned Data Management

Properties

Class	CL_OIUP_CODE_GEN
Short Description	PDM - Code generation class
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class	OIUP
Program status
Category	0
Package	OIU_P	Partitioned Data Management
Created	20040518	SAP
Last change	20050615	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RSDS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	SQLS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_OIUP_CODE_GEN has no interface implemented.

Friends

Class CL_OIUP_CODE_GEN has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ALL_SPLIT_CODES	Static Attribute	Private	☐	Type reference (TYPE)	TY_SPLIT_CODE_T		Buffered Table of ITAB Split Code	20040520
2	ALL_SQLS	Static Attribute	Private	☐	Type reference (TYPE)	TY_CODE_T		All SQL Code (So Far)	20040518
3	ASCII	Static Attribute	Protected	☐	Type reference (TYPE)	FLAG		'X' = ASCII, SPACE = other code pages	20040519
4	C_AGGREGATE	Constant	Private	☐	Type reference (TYPE)	CHAR01	'A'	Constant - AGGREGATE	20040526
5	C_AND	Constant	Private	☐	Type reference (TYPE)	CHAR03	'AND'	Constant - AND	20040518
6	C_APPEND	Constant	Public	☐	Type reference (TYPE)	CHAR01	'A'	Constant - APPEND code	20040528
7	C_APPENDING	Constant	Private	☐	Type reference (TYPE)	STRING	'APPENDING'	Constant - APPENDING	20040730
8	C_ASTERISK	Constant	Private	☐	Type reference (TYPE)	CHAR01	'*'	Constant - SQL Type '*'	20040518
9	C_CLIENT_SPECIFIED	Constant	Private	☐	Type reference (TYPE)	STRING	'CLIENT SPECIFIED'	Constant - CLIENT_SPECIFIED	20040730
10	C_CORRESPONDING	Constant	Private	☐	Type reference (TYPE)	STRING	'CORRESPONDING'	Constant - CORRESPONDING	20040927
11	C_COUNT	Constant	Private	☐	Type reference (TYPE)	CHAR01	'C'	Constant - SQL Type 'Count'	20040518
12	C_DISTINCT	Constant	Public	☐	Type reference (TYPE)	CHAR01	'D'	Constant - SQL Type 'Distinct'	20040518
13	C_ENDSELECT_JOIN	Constant	Public	☐	Type reference (TYPE)	CHAR01	'J'	Constant - ENDSELECT with Join	20040604
14	C_ENDSELECT_SINGLE	Constant	Public	☐	Type reference (TYPE)	CHAR01	'E'	Constant - ENDSELECT single table	20040604
15	C_FALSE	Constant	Private	☐	Type reference (TYPE)	CHAR01	SPACE	Constant - False	20040518
16	C_FOR_ALL_ENTRIES	Constant	Public	☐	Type reference (TYPE)	CHAR01	'F'	Constant - FOR ALL ENTRIES	20040628
17	C_FROM	Constant	Private	☐	Type reference (TYPE)	CHAR01	'F'	Constant - FROM	20050520
18	C_GROUP_BY	Constant	Private	☐	Type reference (TYPE)	CHAR01	'G'	Constant - GROUP BY code	20040518
19	C_HAVING	Constant	Private	☐	Type reference (TYPE)	CHAR01	'H'	Constant - HAVING code	20040518
20	C_INTO	Constant	Private	☐	Type reference (TYPE)	CHAR01	'I'	Constant - INTO	20040518
21	C_MAX	Constant	Private	☐	Type reference (TYPE)	CHAR01	'X'	Constant - SQL Type 'Maximum'	20040518
22	C_MIN	Constant	Private	☐	Type reference (TYPE)	CHAR01	'N'	Constant - SQL Type 'Minimum'	20040518
23	C_OPEN_CURSOR	Constant	Public	☐	Type reference (TYPE)	CHAR01	'O'	Constant - FETCH CURSOR	20040622
24	C_ORDER_BY	Constant	Private	☐	Type reference (TYPE)	CHAR01	'O'	Constant - ORDER BY code	20040518
25	C_PACKAGE_SIZE	Constant	Public	☐	Type reference (TYPE)	CHAR01	'P'	Constant - PACKAGE SIZE construct	20040617
26	C_PERIOD	Constant	Private	☐	Type reference (TYPE)	CHAR01	'.'	Constant - Period	20040518
27	C_SHADOW	Constant	Public	☐	Type reference (TYPE)	CHAR01	'S'	Constant - SHADOW	20040518
28	C_SINGLE	Constant	Public	☐	Type reference (TYPE)	CHAR01	'1'	Constant - Single Table	20040526
29	C_SPLIT	Constant	Public	☐	Type reference (TYPE)	CHAR01	'I'	Constant - Split ITAB	20040520
30	C_STORE	Constant	Private	☐	Type reference (TYPE)	CHAR01	'R'	Constant - STORE code	20040527
31	C_SUM	Constant	Private	☐	Type reference (TYPE)	CHAR01	'S'	Constant - SQL Type 'Sum'	20040518
32	C_TRUE	Constant	Private	☐	Type reference (TYPE)	CHAR01	'X'	Constant - True	20040518
33	C_WHERE	Constant	Private	☐	Type reference (TYPE)	CHAR01	'W'	Constant - WHERE	20040518
34	ERROR_LINE	Instance attribute	Public	☐	Type reference (TYPE)	I		Line number of syntax error	20040518
35	FROM_CLAUSE	Instance attribute	Public	☐	Type reference (TYPE)	OIUP_STRING_ITAB		ITAB of FROM clause	20040518
36	GEN_PROGRAM_ITAB	Static Attribute	Public	☐	Type reference (TYPE)	OIUP_GENERATED_PROGRAMS_ITAB		Generated Programs ITAB buffer	20041210
37	GEN_SUBPOOL_COUNT	Static Attribute	Private	☐	Type reference (TYPE)	I		Number of subpools generated	20041210
38	INTO_CLAUSE	Instance attribute	Public	☐	Type reference (TYPE)	OIUP_STRING_ITAB		ITAB of INTO clause	20040518
39	I_SELECT	Instance attribute	Public	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER_SELECT		PDM - Parse SELECT Interface	20040518
40	I_WHERE	Instance attribute	Public	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER_WHERE		PDM - Parse SQL With WHERE Clause Interface	20040518
41	MESSAGE	Instance attribute	Public	☐	Type reference (TYPE)	STRING		Generation message	20040518
42	MOD_TABIX	Static Attribute	Private	☐	Type reference (TYPE)	I		Modification Tabix	20041210
43	O_PARSER	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_OIUP_SQL_PARSER		PDM - SQL Parser	20040518
44	PRIMARY_KEY_T	Instance attribute	Private	☐	Type reference (TYPE)	TY_PRIMARY_KEY_T		Primary Key table	20040610
45	PROGRAM	Instance attribute	Public	☐	Type reference (TYPE)	PROGRAM		Generated program name	20040518
46	R3_46	Static Attribute	Protected	☐	Type reference (TYPE)	FLAG		X' = 46x, SPACE = 472 & Higher	20040519
47	RETURN_CODE	Instance attribute	Public	☐	Type reference (TYPE)	SUBRC		Generation return code	20040518
48	SELECT_CLAUSE	Instance attribute	Public	☐	Type reference (TYPE)	OIUP_STRING_ITAB		ITAB of SELECT clause	20040518
49	SOURCE_ITAB	Instance attribute	Public	☐	Type reference (TYPE)	OIUP_STRING_ITAB		ITAB of ABAP source	20040518
50	SQL	Instance attribute	Public	☐	Type reference (TYPE)	OIUP_STRING_ITAB		ITAB for genarated SQL	20040518
51	UNICODE	Static Attribute	Protected	☐	Type reference (TYPE)	FLAG		X' = UNICODE, SPACE = not	20040519
52	VAR_SUB_COMPL	Instance attribute	Public	☐	Type reference (TYPE)	CHAR01		Flag, var. substitution complete	20040518
53	WHERE_CLAUSE	Instance attribute	Public	☐	Type reference (TYPE)	OIUP_STRING_ITAB		ITAB of WHERE clause	20040518

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_CLAUSE_TO_SQL	Instance method	Private	Method	Add GROUP BY,ORDER BY etc. to generated SQL	20040518
2	ADD_CLIENT_SPECIFIED	Instance method	Private	Method	Encaspulate logic for CLIENT addition in WHERE clause	20040802
3	ALL_ENTRIES_CHECK_FIELDNAMES	Instance method	Private	Method	ALL ENTRIES constr - Check if any field names are different	20040628
4	CLASS_CONSTRUCTOR	Static method	Public	Constructor	CLASS_CONSTRUCTOR	20040519
5	COPY_SQL_PARSER	Instance method	Private	Method	Make a copy of the SQL parser objects	20040617
6	CREATE	Static method	Public	Method	Create METHOD (with buffer check)	20040518
7	EXECUTE_SUBROUTINE	Instance method	Public	Method	Execute generated subroutine	20040518
8	GENERATE_PROGRAM	Instance method	Private	Method	Generate a physical report ( no. of subpool gens > 36)	20041210
9	GENERATE_SUBPOOL	Instance method	Private	Method	Use the SQL tab to generate the program	20040518
10	GEN_AGGREGATE_CODE	Instance method	Private	Method	Source code for Aggregate functions only	20040621
11	GEN_APPEND_ITAB	Instance method	Private	Method	Generate - Append Generic ITAB to original ITAB	20040518
12	GEN_ENDSELECT_SINGLE_TAB	Instance method	Private	Method	Create source code for Single table SELECT / ENDSELECT	20040607
13	GEN_MERGE_DATA	Instance method	Public	Method	Generate - Merge data from PRA and Nearline sources	20040518
14	GEN_PACKAGE_SIZE	Instance method	Private	Method	Generate source code for PACKAGE SIZE construct	20040616
15	GEN_SHADOW	Instance method	Private	Method	Generate - Shadow SQL	20040526
16	GEN_SINGLE_TABLE_SELECT	Instance method	Private	Method	Create source code for Single table SELECT	20040518
17	GEN_SPLIT_ITAB	Instance method	Private	Method	Generate - Split ITAB Based On Split Date	20040520
18	MARK_GEN_PROGRAM_DELETED	Static method	Public	Method	Mark Generated Program As "Deleted"	20041210
19	ORDER_BY_CHECK_FIELDNAMES	Instance method	Private	Method	Order By clause - Check if any field names are different	20040616
20	SET_VARIABLES	Instance method	Private	Method	Set generated program variables	20040518
21	STRING_ITAB_TO_DATA	Instance method	Public	Method	Convert an ITAB of STRING to a data tab	20040519
22	STRING_WA_TO_DATA	Instance method	Public	Method	Convert a work area of STRING to a data work area	20040527
23	SUBSTITUE_ALIAS	Instance method	Private	Method	Substitute ALIASes in the case of SHADOW	20050504
24	SUBSTITUTE_INTO_VARS	Instance method	Private	Method	Substitute field names for field symbols into SQL	20040518
25	TABLE_GET_PRIMARY_KEY	Instance method	Private	Method	Determine the primary key fields for a table	20040609

Events

Class CL_OIUP_CODE_GEN has no event.

Types

Class CL_OIUP_CODE_GEN has no local type.

Method Signatures

Method ADD_CLAUSE_TO_SQL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CLAUSE	Call by reference	☐	Type reference (TYPE)	OIUP_STRING_ITAB		ITAB of string type	20040518
2	Importing	CLAUSE_ID	Call by reference	☐	Type reference (TYPE)	CHAR1		'G' = Group By, 'O' = Order by, 'H' = Having, 'R' = Returnin	20040518
3	Importing	PRA_OR_SHADOW	Call by reference	☐	Type reference (TYPE)	CHAR1		'P' = PRA, 'S' = Shadow	20040518

Method ADD_CLAUSE_TO_SQL on class CL_OIUP_CODE_GEN has no exception.

Method ADD_CLIENT_SPECIFIED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	WHERE_ITAB	Call by reference	☐	Type reference (TYPE)	OIUP_STRING_ITAB		WHERE Clause ITAB	20040802

Method ADD_CLIENT_SPECIFIED on class CL_OIUP_CODE_GEN has no exception.

Method ALL_ENTRIES_CHECK_FIELDNAMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	DIFFERENT	Value transfer	☐	Type reference (TYPE)	CHAR01		Character field length 1	20040628
2	Exporting	FIELD_MAPPING	Call by reference	☐	Type reference (TYPE)	MAP_T		Field mapping table	20040628
3	Importing	REFERENCE	Call by reference	☐	Type reference (TYPE)	ROIUP_REFERENCE		INTO table reference	20040628

Method ALL_ENTRIES_CHECK_FIELDNAMES on class CL_OIUP_CODE_GEN has no exception.

Method CLASS_CONSTRUCTOR Signature

Method CLASS_CONSTRUCTOR on class CL_OIUP_CODE_GEN has no parameter.
Method CLASS_CONSTRUCTOR on class CL_OIUP_CODE_GEN has no exception.

Method COPY_SQL_PARSER Signature

Method COPY_SQL_PARSER on class CL_OIUP_CODE_GEN has no parameter.
Method COPY_SQL_PARSER on class CL_OIUP_CODE_GEN has no exception.

Method CREATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CODE_GEN	Value transfer	☐	Object reference (TYPE REF TO)	CL_OIUP_CODE_GEN		Generated Code	20040520
2	Importing	GEN_ID	Value transfer	☐	Type reference (TYPE)	CHAR01		'P' = PRA, 'S' = Shadow, 'A' = Append, 'M' = Merge,'I'=Split	20040518
3	Importing	PARSER	Value transfer	☑	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		SQL Parser Interface	20040518
4	Importing	TABNAME	Value transfer	☑	Type reference (TYPE)	TABNAME		Table Name	20040520

#	Exception	Resumable	Description	Created on
1	GENERATION_ERROR	☐	Error during the generation of the subroutine pool	20040518

Method EXECUTE_SUBROUTINE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	DBCNT	Value transfer	☑	Type reference (TYPE)	SYDBCNT		Processed Database Table Rows	20050506
2	Importing	FIELD_LIST	Value transfer	☑	Type reference (TYPE)	STRING		Field List	20040526
3	Importing	GEN_ID	Value transfer	☐	Type reference (TYPE)	CHAR01			20040526
4	Importing	GUID	Value transfer	☐	Type reference (TYPE)	GUID_32	SPACE	GUID in 'CHAR' Format in Upper Case	20040518
5	Importing	SPLIT_FROM_VALUE	Value transfer	☑	Type reference (TYPE)	ANY		Split From Value	20040520
6	Importing	SPLIT_INPUT_ITAB	Value transfer	☑	Type reference (TYPE)	ANY TABLE		Split Input ITAB	20040520
7	Exporting	SPLIT_OUTPUT_ITAB	Value transfer	☐	Type reference (TYPE)	ANY TABLE		Split Output ITAB	20040520
8	Importing	SPLIT_TO_VALUE	Value transfer	☑	Type reference (TYPE)	ANY		Split To Value	20040520
9	Changing	SUBRC	Value transfer	☑	Type reference (TYPE)	SYSUBRC		Return Value, Return Value After ABAP Statements	20050506

Method EXECUTE_SUBROUTINE on class CL_OIUP_CODE_GEN has no exception.

Method GENERATE_PROGRAM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_PROGRAM	Call by reference	☐	Type reference (TYPE)	PROGRAM		Program/transaction in SQL trace analysis	20041210

Method GENERATE_PROGRAM on class CL_OIUP_CODE_GEN has no exception.

Method GENERATE_SUBPOOL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ERROR_LINE	Call by reference	☐	Type reference (TYPE)	I		Line of Error	20040609
2	Exporting	MESSAGE	Call by reference	☐	Type reference (TYPE)	STRING		Message string	20040518
3	Exporting	PROGRAM	Call by reference	☐	Type reference (TYPE)	PROGNAME		Generated ABAP name	20040518
4	Exporting	RETURN_CODE	Call by reference	☐	Type reference (TYPE)	SUBRC		Return code	20040518
5	Importing	SOURCE_ITAB	Call by reference	☐	Type reference (TYPE)	OIUP_STRING_ITAB		PDM - Source ABAP	20040518

Method GENERATE_SUBPOOL on class CL_OIUP_CODE_GEN has no exception.

Method GEN_AGGREGATE_CODE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	AGG_SOURCE	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		Aggregate Source Code	20040621

Method GEN_AGGREGATE_CODE on class CL_OIUP_CODE_GEN has no exception.

Method GEN_APPEND_ITAB Signature

Method GEN_APPEND_ITAB on class CL_OIUP_CODE_GEN has no parameter.
Method GEN_APPEND_ITAB on class CL_OIUP_CODE_GEN has no exception.

Method GEN_ENDSELECT_SINGLE_TAB Signature

Method GEN_ENDSELECT_SINGLE_TAB on class CL_OIUP_CODE_GEN has no parameter.
Method GEN_ENDSELECT_SINGLE_TAB on class CL_OIUP_CODE_GEN has no exception.

Method GEN_MERGE_DATA Signature

Method GEN_MERGE_DATA on class CL_OIUP_CODE_GEN has no parameter.
Method GEN_MERGE_DATA on class CL_OIUP_CODE_GEN has no exception.

Method GEN_PACKAGE_SIZE Signature

Method GEN_PACKAGE_SIZE on class CL_OIUP_CODE_GEN has no parameter.
Method GEN_PACKAGE_SIZE on class CL_OIUP_CODE_GEN has no exception.

Method GEN_SHADOW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARSER	Value transfer	☐	Object reference (TYPE REF TO)	IF_OIUP_SQL_PARSER		PDM - SQL Parser Interface	20040526

Method GEN_SHADOW on class CL_OIUP_CODE_GEN has no exception.

Method GEN_SINGLE_TABLE_SELECT Signature

Method GEN_SINGLE_TABLE_SELECT on class CL_OIUP_CODE_GEN has no parameter.
Method GEN_SINGLE_TABLE_SELECT on class CL_OIUP_CODE_GEN has no exception.

Method GEN_SPLIT_ITAB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	TABNAME	Value transfer	☐	Type reference (TYPE)	TABNAME		Table Name	20040520

Method GEN_SPLIT_ITAB on class CL_OIUP_CODE_GEN has no exception.

Method MARK_GEN_PROGRAM_DELETED Signature

Method MARK_GEN_PROGRAM_DELETED on class CL_OIUP_CODE_GEN has no parameter.
Method MARK_GEN_PROGRAM_DELETED on class CL_OIUP_CODE_GEN has no exception.

Method ORDER_BY_CHECK_FIELDNAMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	DIFFERENT	Value transfer	☐	Type reference (TYPE)	CHAR01		Character field length 1	20040616
2	Exporting	FIELD_MAPPING	Call by reference	☐	Type reference (TYPE)	MAP_T		Field mapping table	20040616

Method ORDER_BY_CHECK_FIELDNAMES on class CL_OIUP_CODE_GEN has no exception.

Method SET_VARIABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INTO_ITAB	Call by reference	☑	Type reference (TYPE)	OIUP_REFERENCE_ITAB		INTO variables Reference	20040518
2	Importing	WHERE_ITAB	Call by reference	☑	Type reference (TYPE)	OIUP_REFERENCE_ITAB		WHERE variables Reference	20040518

Method SET_VARIABLES on class CL_OIUP_CODE_GEN has no exception.

Method STRING_ITAB_TO_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DATA_ITAB	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		STRING ITAB of data	20040519
2	Importing	REF	Value transfer	☐	Object reference (TYPE REF TO)	DATA		ITAB Reference	20040607

Method STRING_ITAB_TO_DATA on class CL_OIUP_CODE_GEN has no exception.

Method STRING_WA_TO_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DATA	Value transfer	☐	Type reference (TYPE)	STRING		String version of work area	20040527

Method STRING_WA_TO_DATA on class CL_OIUP_CODE_GEN has no exception.

Method SUBSTITUE_ALIAS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	ITAB	Call by reference	☐	Type reference (TYPE)	OIUP_STRING_ITAB		PDM - String Internal Table	20050504

Method SUBSTITUE_ALIAS on class CL_OIUP_CODE_GEN has no exception.

Method SUBSTITUTE_INTO_VARS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	REF_TAB	Value transfer	☐	Type reference (TYPE)	OIUP_REFERENCE_ITAB		PDM - Reference table type	20040518
2	Changing	SQL_TAB	Value transfer	☐	Type reference (TYPE)	OIUP_STRING_ITAB		PDM - String Internal Table	20040518
3	Importing	VAR_TYPE	Value transfer	☐	Type reference (TYPE)	CHAR1		'I' = INTO, 'W' = WHERE, 'F'=FROM	20040518

Method SUBSTITUTE_INTO_VARS on class CL_OIUP_CODE_GEN has no exception.

Method TABLE_GET_PRIMARY_KEY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PRIMARY_KEY_ONLY	Value transfer	☑	Type reference (TYPE)	FLAG		Only get key fields of table	20040623
2	Importing	TABNAME	Value transfer	☐	Type reference (TYPE)	TABNAME		Table Name	20040609

Method TABLE_GET_PRIMARY_KEY on class CL_OIUP_CODE_GEN has no exception.

History

Last changed by/on	SAP	20050615
SAP Release Created in	472