SAP ABAP Class CL_FICO_DB_MANAGER (Database Access Management)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-FIM-FCO (Application Component) Financial Conditions
     ⤷ FICO_OBJECT_LAYER (Package) New Object Layer

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_FICO_DB_MANAGER	Administrator for Database Access	20080807

Properties

Class	CL_FICO_DB_MANAGER
Short Description	Database Access Management
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	FICO_OBJECT_LAYER	New Object Layer
Created	20080807	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	IF_FICO_LIST	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
3	IF_FICO_LIST_VERSION	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...
4	IF_FICO_VALPER	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_FICO_DB_MANAGER	☐	☐	Administrator for Database Access	20080807

Friends

Class CL_FICO_DB_MANAGER has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MS_LIST_DATA	Instance attribute	Protected	☐	Type reference (TYPE)	IF_FICO_LIST=>TS_DATA		List Data	20080903
2	MT_AMT	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_AMT		Table Type: Amount (Sorted)	20080812
3	MT_AMTPOS	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_AMTPOS		Table Type: Amount Item (Sorted)	20080812
4	MT_AMTPOSEXP	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_AMTPOSEXP		Interest and Interest Ref. Rates for Amount Item (Sorted)	20080812
5	MT_COND	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_COND		Table Type: Condition Table (Sorted)	20080812
6	MT_CONDDIFF	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDDIFF		Table Type: Assignment Condition - Differentiation	20080812
7	MT_CONDDIFF_T	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_DIFF_DISPLAY		Differentiations of Condition with Texts (Sorted)	20080812
8	MT_CONDI	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI_BUFF		Conditions	20080807
9	MT_COND_T	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_COND_T		Table Type: Texts for Conditions (Sorted)	20080807
10	MT_DATE	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_DATE		Table Type: Date (Sorted)	20080812
11	MT_DATEPOS	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_DATEPOS		Table Type: Date Item (Sorted)	20080812
12	MT_LIST_TYPES	Instance attribute	Protected	☐	Type reference (TYPE)	IF_FICO_VALPER=>TT_VALPER_LISTTYPE		Condition Group Types	20080903
13	MT_POS	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_BUFF		Items of the Conditions	20080807
14	MT_POS_REL	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_REL_BUFF		Table for Relationships	20080807
15	MT_RULE	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDIT_RULE_SHORT		Table Type Condition Item: Formula ID and Text	20080812
16	MV_FLG_CONVERT_ALL	Instance attribute	Protected	☐	Type reference (TYPE)	FLAG		Conversion to Normal Format Not Necessary	20080925
17	MV_ILIST	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_ILIST		Condition List	20080807
18	MV_MAX_VALIDTO	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_DVALIDTO		Valid-Top Date of Condition	20080825
19	MV_MIN_VALIDFROM	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_DVALIDFROM		Valid-From Date of Condition	20080825
20	MV_STARTDATE	Instance attribute	Protected	☐	Type reference (TYPE)	FICO_DVALIDFROM		Start Date	20080825

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADAPT_USERDATA	Instance method	Private	Method	Supplies User Information (Creation Date and Change Date)	20080910
2	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20081023
3	GET_CHANGE_DOCUMENTS_CONDI	Instance method	Private	Method	Gets Change Documents for Conditions	20081002
4	GET_CHANGE_DOCUMENTS_COND_T	Instance method	Private	Method	Gets Change Documents for Condition Texts	20081002
5	GET_CHANGE_DOCUMENTS_POS	Instance method	Private	Method	Gets Change Documents for Condition Items	20081002
6	GET_CHANGE_DOCUMENTS_POS_REL	Instance method	Private	Method	Gets Change Documents for Condition Item Relationships	20081002
7	GET_COMPONENT	Static method	Public	Method	Create Instance of DB Manager	20090320
8	GET_CONDI_TABLES_FOR_UPDATE	Instance method	Private	Method	Fills Table for Update Based on Buffer Structure	20080915
9	GET_COND_T_TABLES_FOR_UPDATE	Instance method	Private	Method	Fills Table for Update Based on Buffer Structure	20080915
10	GET_POS_REL_TABLES_FOR_UPDATE	Instance method	Private	Method	Fills Table for Update Based on Buffer Structure	20080912
11	GET_POS_TABLES_FOR_UPDATE	Instance method	Private	Method	Fills Table for Update Based on Buffer Structure	20080912
12	GET_TIME_INTERVAL	Instance method	Protected	Method	Gets Time Interval for Reading	20080905
13	ON_TRANSACTION_FINISHED	Instance method	Private	Event handling method	Event Handler For End of Transaction	20081023
14	READ_CONDITION	Static method	Public	Method	Create Instance of DB Manager	20090629
15	READ_FOBU	Instance method	Private	Method	Read FoBu Data for Item Formula (Fill FoBu Buffer)	20090723
16	READ_LIST_VERSION	Static method	Public	Method	Create Instance of DB Manager	20080807
17	SAVE_CHANGE_DOCUMENTS	Instance method	Private	Method	Save Change Documents	20081001
18	SAVE_LIST_VERSION	Static method	Public	Method	Create Instance of DB Manager	20080807
19	S_CREATE	Static method	Public	Method	Create Instance of DB Manager	20080812

Events

Class CL_FICO_DB_MANAGER has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TT_CONDITION_RULE	Private	See coding			20130410	tt_condition_rule TYPE TABLE OF ficos_condition_rule

Method Signatures

Method ADAPT_USERDATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_CONDI_BUFFER_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI		Konditionen (sortiert)	20080910
2	Changing	CT_CONDI_BUFFER_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI		Konditionen (sortiert)	20080910
3	Changing	CT_CONDI_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI		Konditionen (sortiert)	20080910
4	Changing	CT_CONDI_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI		Konditionen (sortiert)	20080910

Method ADAPT_USERDATA on class CL_FICO_DB_MANAGER has no exception.

Method CONSTRUCTOR Signature

Method CONSTRUCTOR on class CL_FICO_DB_MANAGER has no parameter.
Method CONSTRUCTOR on class CL_FICO_DB_MANAGER has no exception.

Method GET_CHANGE_DOCUMENTS_CONDI Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_CONDI_CD_NEW	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_CONDI		Tabelle für Änderungsbelege für Ficot_condi	20081002
2	Changing	CT_CONDI_CD_OLD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_CONDI		Tabelle für Änderungsbelege für Ficot_condi	20081002
3	Importing	IS_CONDI_CD	Call by reference	☐	Type reference (TYPE)	FICOS_CD_CONDI		Änderungsbelegstruktur für FICOT_CONDI	20081002
4	Importing	IV_UPDATE_MODE	Call by reference	☐	Type reference (TYPE)	CDCHNGIND		Art der Änderung (U, I, E, D)	20081002

Method GET_CHANGE_DOCUMENTS_CONDI on class CL_FICO_DB_MANAGER has no exception.

Method GET_CHANGE_DOCUMENTS_COND_T Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_COND_T_CD_NEW	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_COND_T		Tabelle für Änderungsbelege für Ficot_cond_t	20081002
2	Changing	CT_COND_T_CD_OLD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_COND_T		Tabelle für Änderungsbelege für Ficot_cond_t	20081002
3	Importing	IS_COND_T_CD	Call by reference	☐	Type reference (TYPE)	FICOS_CD_COND_T		Änderungsbelegstruktur für fico_cond_t	20081002
4	Importing	IV_LANGU	Call by reference	☐	Type reference (TYPE)	SPRAS	SYST-LANGU	Sprachenschlüssel	20090629
5	Importing	IV_UPDATE_MODE	Call by reference	☐	Type reference (TYPE)	CDCHNGIND		Art der Änderung (U, I, E, D)	20081002

Method GET_CHANGE_DOCUMENTS_COND_T on class CL_FICO_DB_MANAGER has no exception.

Method GET_CHANGE_DOCUMENTS_POS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_POS_CD_NEW	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_POS		Tabelle für Änderungsbelege für Ficot_pos	20081002
2	Changing	CT_POS_CD_OLD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_POS		Tabelle für Änderungsbelege für Ficot_pos	20081002
3	Importing	IS_POS_CD	Call by reference	☐	Type reference (TYPE)	FICOS_CD_POS		Änderungsbelegstruktur für FICOT_POS	20081002
4	Importing	IV_UPDATE_MODE	Call by reference	☐	Type reference (TYPE)	CDCHNGIND		Art der Änderung (U, I, E, D)	20081002

Method GET_CHANGE_DOCUMENTS_POS on class CL_FICO_DB_MANAGER has no exception.

Method GET_CHANGE_DOCUMENTS_POS_REL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_POS_REL_CD_NEW	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_POS_REL		Tabelle für Änderungsbelege für Ficot_pos	20081002
2	Changing	CT_POS_REL_CD_OLD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_POS_REL		Tabelle für Änderungsbelege für Ficot_pos	20081002
3	Importing	IS_POS_REL_CD	Call by reference	☐	Type reference (TYPE)	FICOS_CD_POS_REL		Änderungsbelegstruktur für FICOT_POS_REL	20081002
4	Importing	IV_UPDATE_MODE	Call by reference	☐	Type reference (TYPE)	CDCHNGIND		Art der Änderung (U, I, E, D)	20081002

Method GET_CHANGE_DOCUMENTS_POS_REL on class CL_FICO_DB_MANAGER has no exception.

Method GET_COMPONENT Signature

Method GET_COMPONENT on class CL_FICO_DB_MANAGER has no parameter.
Method GET_COMPONENT on class CL_FICO_DB_MANAGER has no exception.

Method GET_CONDI_TABLES_FOR_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CONDI_BUFFER_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI		Konditionen (sortiert)	20080915
2	Exporting	ET_CONDI_BUFFER_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI		Konditionen (sortiert)	20080915
3	Exporting	ET_CONDI_CD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_CONDI		Tabelle für Änderungsbelege für Ficot_condi	20081001
4	Exporting	ET_CONDI_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI		Konditionen (sortiert)	20080915
5	Exporting	ET_CONDI_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI		Konditionen (sortiert)	20080915
6	Importing	IT_CONDI	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI_BUFF		Konditionen mit Pufferungsflag	20080915

Method GET_CONDI_TABLES_FOR_UPDATE on class CL_FICO_DB_MANAGER has no exception.

Method GET_COND_T_TABLES_FOR_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_COND_T_CD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_COND_T		Tabelle für Änderungsbelege für Ficot_cond_t	20081002
2	Exporting	ET_COND_T_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_COND_T			20080915
3	Exporting	ET_COND_T_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_COND_T			20080915
4	Importing	IT_COND_T	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_COND_T			20080915

Method GET_COND_T_TABLES_FOR_UPDATE on class CL_FICO_DB_MANAGER has no exception.

Method GET_POS_REL_TABLES_FOR_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_POS_REL_BUFFER_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_REL		Konditionen (sortiert)	20080912
2	Exporting	ET_POS_REL_BUFFER_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_REL		Konditionen (sortiert)	20080912
3	Exporting	ET_POS_REL_CD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_POS_REL		Tabelle für Änderungsbelege für Ficot_pos	20081002
4	Exporting	ET_POS_REL_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_REL		Konditionen (sortiert)	20080912
5	Exporting	ET_POS_REL_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_REL		Konditionen (sortiert)	20080912
6	Importing	IT_POS_REL	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_REL_BUFF		Konditionen mit Pufferungsflag	20080912

Method GET_POS_REL_TABLES_FOR_UPDATE on class CL_FICO_DB_MANAGER has no exception.

Method GET_POS_TABLES_FOR_UPDATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_POS_BUFFER_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS		Konditionen (sortiert)	20080912
2	Exporting	ET_POS_BUFFER_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS		Konditionen (sortiert)	20080912
3	Exporting	ET_POS_CD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_POS		Tabelle für Änderungsbelege für Ficot_pos	20081002
4	Exporting	ET_POS_INSERT	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS		Konditionen (sortiert)	20080912
5	Exporting	ET_POS_UPDATE	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS		Konditionen (sortiert)	20080912
6	Importing	IT_POS	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_BUFF		Konditionen mit Pufferungsflag	20080912

Method GET_POS_TABLES_FOR_UPDATE on class CL_FICO_DB_MANAGER has no exception.

Method GET_TIME_INTERVAL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_FLG_REPLACE	Call by reference	☐	Type reference (TYPE)	FLAG		'X' -alter Puffer komplett ersetzen	20080905
2	Exporting	EV_FLG_SELECT	Call by reference	☐	Type reference (TYPE)	FLAG		'X' -selektieren aus vorhandenen Konditionen	20080925
3	Exporting	EV_READ_DATE	Call by reference	☐	Type reference (TYPE)	DATUM		Lesen zum	20080925
4	Exporting	EV_READ_FROM	Call by reference	☐	Type reference (TYPE)	DATUM		Lesen vom	20080905
5	Exporting	EV_READ_TO	Call by reference	☐	Type reference (TYPE)	DATUM		Lesen bis	20080905
6	Importing	IV_STARTDATE	Call by reference	☑	Type reference (TYPE)	DATUM		Startdatum	20080925
7	Importing	IV_VALID_FROM	Call by reference	☐	Type reference (TYPE)	DATUM	'19010101'	Anfang der Abfrageperiode	20080905
8	Importing	IV_VALID_TO	Call by reference	☐	Type reference (TYPE)	DATUM	'99991231'	Ende der Abfrageperiode	20080905

#	Exception	Resumable	Description	Created on
1	CX_FICO_OL_CALL_ERROR	☐	Aufruffehler	20090116

Method ON_TRANSACTION_FINISHED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	KIND	Value transfer	☐	Attribute reference (LIKE)				20081023

Method ON_TRANSACTION_FINISHED on class CL_FICO_DB_MANAGER has no exception.

Method READ_CONDITION Signature

Method READ_CONDITION on class CL_FICO_DB_MANAGER has no parameter.
Method READ_CONDITION on class CL_FICO_DB_MANAGER has no exception.

Method READ_FOBU Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CONDITION_RULE	Call by reference	☐	Type reference (TYPE)	TT_CONDITION_RULE			20130410
2	Importing	IT_CONDI	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_CONDI_BUFF			20090723
3	Importing	IT_POS	Call by reference	☐	Type reference (TYPE)	FICO_TYP_TAS_POS_BUFF		Positionen der Konditionen mit Pufferungsflag	20090723

Method READ_FOBU on class CL_FICO_DB_MANAGER has no exception.

Method READ_LIST_VERSION Signature

Method READ_LIST_VERSION on class CL_FICO_DB_MANAGER has no parameter.
Method READ_LIST_VERSION on class CL_FICO_DB_MANAGER has no exception.

Method SAVE_CHANGE_DOCUMENTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_CONDI_CD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_CONDI		Tabelle für Änderungsbelege für Ficot_condi	20081001
2	Importing	IT_COND_T_CD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_COND_T		Tabelle für Änderungsbelege für Ficot_cond_t	20081001
3	Importing	IT_POS_CD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_POS		Tabelle für Änderungsbelege für Ficot_pos	20081001
4	Importing	IT_POS_REL_CD	Call by reference	☐	Type reference (TYPE)	FICO_TAS_CD_POS_REL		Tabelle für Änderungsbelege für Ficot_pos_rel	20081001
5	Importing	IV_UPDATE_TASK	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20081001

Method SAVE_CHANGE_DOCUMENTS on class CL_FICO_DB_MANAGER has no exception.

Method SAVE_LIST_VERSION Signature

Method SAVE_LIST_VERSION on class CL_FICO_DB_MANAGER has no parameter.
Method SAVE_LIST_VERSION on class CL_FICO_DB_MANAGER has no exception.

Method S_CREATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_LIST	Call by reference	☐	Type reference (TYPE)	FICO_ILIST		GUID der Listversion	20081020
2	Returning	RO_DB_MANAGER	Value transfer	☐	Object reference (TYPE REF TO)	CL_FICO_DB_MANAGER		Verwalter zur DB Zugriffe	20080812

Method S_CREATE on class CL_FICO_DB_MANAGER has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	712