SAP ABAP Interface IF_PCO_DB_QUERY (PCo: Methods for Database Query)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-SRV-PCO (Application Component) Plant Connectivity (Pco): ABAP part
⤷
S_PCO (Package) Plant Connectivity: Business Suite Integration (ABAP Part)
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-SRV-PCO (Application Component) Plant Connectivity (Pco): ABAP part⤷
S_PCO (Package) Plant Connectivity: Business Suite Integration (ABAP Part)
Meta Relationship - Used By
| # | Relationship type | Used by | Short Description | Created on |
|---|---|---|---|---|
| 1 | Interface implementation (CLASS c. INTERFACES i_ref) | CL_PCO_DB_QUERY | PCo: Database Query | 20100721 |
Properties
| Interface | IF_PCO_DB_QUERY | |
| Short Description | PCo: Methods for Database Query |
General Data
| Package | S_PCO | Plant Connectivity: Business Suite Integration (ABAP Part) |
| Created | 20100721 | SAP |
| Last changed | 20130531 | SAP |
| Unicode checks active |
Forward declarations
Interface IF_PCO_DB_QUERY has no forward declaration.
Interfaces
Interface IF_PCO_DB_QUERY has no interface.
Friends
Interface IF_PCO_DB_QUERY has no friend.
Attributes
Interface IF_PCO_DB_QUERY has no attribute.
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | EXECUTE_DB_QUERY |
Instance method | Public | Method | Execution of a Database Query | 20100723 |
| 2 | GET_DB_TABLES |
Instance method | Public | Method | Delivers Database Tables of Data Source | 20100721 |
| 3 | GET_DB_TAB_COLUMNS |
Instance method | Public | Method | Delivers Column Headers for Database Table of Data Source | 20100721 |
| 4 | INSERT_DB_TAB_DATA |
Instance method | Public | Method | Adds Data Records to Database Table (Data Source) | 20110715 |
| 5 | SELECT_DB_TAB_DATA |
Instance method | Public | Method | Delivers Selection of Database Table Data (Data Source) | 20110715 |
| 6 | UPDATE_DB_TAB_DATA |
Instance method | Public | Method | Changes Data Records of Database Table (Data Source) | 20110715 |
Events
Interface IF_PCO_DB_QUERY has no event.
Types
Interface IF_PCO_DB_QUERY has no local type.
Method Signatures
Method EXECUTE_DB_QUERY Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
ET_BOOL_VAL | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_BOOLVAL | PCo: Query-Ergebniswerte im Boolean-Format | 20100802 | ||
| 2 | Exporting |
ET_CHAR_VAL | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_CHARVAL | PCo: Query-Ergebniswerte im CHAR-Format | 20100802 | ||
| 3 | Exporting |
ET_COLUMNS | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_COLUMNS | PCo: Tabellentyp Spalteninformation zu Query-Ergebnis | 20100802 | ||
| 4 | Exporting |
ET_DEC_VAL | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_DECVAL | PCo: Tabellentyp für Query-Ergebniswerte im DEC-Format | 20100802 | ||
| 5 | Exporting |
ET_FLOAT_VAL | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_FLOATVAL | PCo: Tabellentyp für Query-Ergebniswerte im Float-Format | 20100802 | ||
| 6 | Exporting |
ET_INT_VAL | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_INTVAL | PCo: Tabellentyp für Query-Ergebniswerte im INT4-Format | 20100802 | ||
| 7 | Exporting |
ET_MESSAGE_DATA | Call by reference | Type reference (TYPE) | PCO_T_QUERY_MESSAGE_DATA | PCo: Tabellentyp für Meldungen zu PCo-Queries | 20100802 | ||
| 8 | Exporting |
ET_META_DATA | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_META_DATA | PCo: Tabellentyp für Metadaten zu Query-Ergebnis | 20100802 | ||
| 9 | Exporting |
ET_PCO_MSG_OBJ | Call by reference | Type reference (TYPE) | PCO_T_QUERY_MESSAGE_OBJ | Meldungen zu PCo-Queries (Objektinstanzen) | 20100901 | ||
| 10 | Exporting |
ET_ROWS | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_ROWS | PCo: Tabelle mit Zeileninformation zu Query-Ergebnistabelle | 20100802 | ||
| 11 | Exporting |
ET_TIMEST_VAL | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_TIMESTVAL | PCo: Tabellentyp Query-Ergebniswerte im TIMESTAMPL-Format | 20100802 | ||
| 12 | Exporting |
EV_QUERY_RESULT_STATUS | Call by reference | Type reference (TYPE) | S_PCO_QUERY_RESULT_STATUS | PCo: Status Query-Ergebnis | 20100802 | ||
| 13 |  Importing |
IV_QUERY_CONTENT | Call by reference | Type reference (TYPE) | STRING | Inhalt der Query | 20100723 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_PCO_BS_INT |
20100827 |
Method GET_DB_TABLES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_DB_TAB_RESULT | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_DB_DATA | PCo: Daten einer OLEDB-Abfrage (Tabellenname & - spalten) | 20110714 | ||
| 2 | Exporting |
ET_PCO_MSG_OBJ | Call by reference | Type reference (TYPE) | PCO_T_QUERY_MESSAGE_OBJ | Meldungen zu PCo-Queries (Objektinstanzen) | 20100901 | ||
| 3 | Exporting |
EV_QUERY_RESULT_STATUS | Call by reference | Type reference (TYPE) | S_PCO_QUERY_RESULT_STATUS | PCo: Status Query-Ergebnis | 20100802 | ||
| 4 | Importing |
IV_SEARCH_MASK | Call by reference | Type reference (TYPE) | S_PCO_SEARCH_MASK | PCo: Maskierungshilfe bei Suche | 20100721 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_PCO_BS_INT |
20100827 |
Method GET_DB_TAB_COLUMNS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_DB_TAB_RESULT | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_DB_DATA | PCo: Daten einer OLEDB-Abfrage (Tabellenname & - spalten) | 20110714 | ||
| 2 | Exporting |
ET_PCO_MSG_OBJ | Call by reference | Type reference (TYPE) | PCO_T_QUERY_MESSAGE_OBJ | Meldungen zu PCo-Queries (Objektinstanzen) | 20100901 | ||
| 3 | Exporting |
EV_QUERY_RESULT_STATUS | Call by reference | Type reference (TYPE) | S_PCO_QUERY_RESULT_STATUS | PCo: Status Query-Ergebnis | 20100802 | ||
| 4 | Importing |
IV_ADD_DB_TAB_CHAR | Call by reference | Type reference (TYPE) | STRING | Fügt zusätzliche Zeichen an Tabellennamen an | 20110725 | ||
| 5 | Importing |
IV_DB_TAB_NAME | Call by reference | Type reference (TYPE) | S_PCO_DB_TAB_NAME | PCo: Name Datenbanktabelle | 20100721 | ||
| 6 | Importing |
IV_DB_TAB_TSET | Call by reference | Type reference (TYPE) | INT4 | Tabellensatznummer für Tabellenname | 20110714 | ||
| 7 | Importing |
IV_SEARCH_MASK | Call by reference | Type reference (TYPE) | S_PCO_SEARCH_MASK | PCo: Maskierungshilfe bei Suche | 20100721 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_PCO_BS_INT |
20100827 |
Method INSERT_DB_TAB_DATA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_PCO_MSG_OBJ | Call by reference | Type reference (TYPE) | PCO_T_QUERY_MESSAGE_OBJ | Meldungen zu PCo-Queries (Objektinstanzen) | 20110715 | ||
| 2 | Exporting |
EV_QUERY_RESULT_STATUS | Call by reference | Type reference (TYPE) | S_PCO_QUERY_RESULT_STATUS | PCo: Status Query-Ergebnis | 20110715 | ||
| 3 | Importing |
IT_PAR_VAL | Call by reference | Type reference (TYPE) | PCO_T_DB_PAR_VAL | Datensätze (Name/Wert), die in DB-Tabelle eingefügt werden | 20110715 | ||
| 4 | Importing |
IV_ADD_DB_TAB_CHAR | Call by reference | Type reference (TYPE) | STRING | Fügt zusätzliche Zeichen an Tabellennamen an | 20110718 | ||
| 5 | Importing |
IV_DB_TAB_NAME | Call by reference | Type reference (TYPE) | S_PCO_DB_TAB_NAME | PCo: Name Datenbanktabelle | 20110715 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_PCO_BS_INT |
20110715 |
Method SELECT_DB_TAB_DATA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_DB_TAB_RESULT | Call by reference | Type reference (TYPE) | PCO_T_QUERY_RESULT_DB_DATA | PCo: Daten einer OLEDB-Abfrage (Tabellenname & - spalten) | 20110715 | ||
| 2 | Exporting |
ET_PCO_MSG_OBJ | Call by reference | Type reference (TYPE) | PCO_T_QUERY_MESSAGE_OBJ | Meldungen zu PCo-Queries (Objektinstanzen) | 20110715 | ||
| 3 | Exporting |
EV_QUERY_RESULT_STATUS | Call by reference | Type reference (TYPE) | S_PCO_QUERY_RESULT_STATUS | PCo: Status Query-Ergebnis | 20110715 | ||
| 4 | Importing |
IT_SEL_COL | Call by reference | Type reference (TYPE) | PCO_T_DB_PAR_VAL | Spalten der DB-Tabelle, deren Inhalt ausgewählt wird | 20110715 | ||
| 5 | Importing |
IV_ADD_DB_TAB_CHAR | Call by reference | Type reference (TYPE) | STRING | Fügt zusätzliche Zeichen an Tabellennamen an | 20110718 | ||
| 6 | Importing |
IV_DB_TAB_NAME | Call by reference | Type reference (TYPE) | S_PCO_DB_TAB_NAME | PCo: Name Datenbanktabelle | 20110715 | ||
| 7 | Importing |
IV_DB_TAB_TSET | Call by reference | Type reference (TYPE) | INT4 | '1' | Tabellensatznummer für Tabellenname | 20110715 | |
| 8 | Importing |
IV_SEL_COND | Call by reference | Type reference (TYPE) | STRING | optionale Auswahlkriterien (WHERE-Clause) | 20110715 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_PCO_BS_INT |
20110715 |
Method UPDATE_DB_TAB_DATA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ET_PCO_MSG_OBJ | Call by reference | Type reference (TYPE) | PCO_T_QUERY_MESSAGE_OBJ | Meldungen zu PCo-Queries (Objektinstanzen) | 20110715 | ||
| 2 | Exporting |
EV_QUERY_RESULT_STATUS | Call by reference | Type reference (TYPE) | S_PCO_QUERY_RESULT_STATUS | PCo: Status Query-Ergebnis | 20110715 | ||
| 3 | Importing |
IT_PAR_VAL | Call by reference | Type reference (TYPE) | PCO_T_DB_PAR_VAL | DB-Tabelleninhalte (Name/Wert), die geändert werden | 20110715 | ||
| 4 | Importing |
IV_ADD_DB_TAB_CHAR | Call by reference | Type reference (TYPE) | STRING | Fügt zusätzliche Zeichen an Tabellennamen an | 20110718 | ||
| 5 | Importing |
IV_DB_TAB_NAME | Call by reference | Type reference (TYPE) | S_PCO_DB_TAB_NAME | PCo: Name Datenbanktabelle | 20110715 | ||
| 6 | Importing |
IV_UPDATE_COND | Call by reference | Type reference (TYPE) | STRING | Auswahlkriterien (WHERE-Clause) | 20110715 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_PCO_BS_INT |
20110715 |
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 703 |
