RERA_GUI_CLEARING_L SAP (Clearing Data (Structure for Result List)) Structure details
Dictionary Type: Structure
Description: Clearing Data (Structure for Result List)
Description: Clearing Data (Structure for Result List)
ABAP Code to SELECT data from RERA_GUI_CLEARING_L
Related tables to RERA_GUI_CLEARING_L
Access table RERA_GUI_CLEARING_L
Related tables to RERA_GUI_CLEARING_L
Access table RERA_GUI_CLEARING_L
Structure field list including key, data, relationships and ABAP select examples
RERA_GUI_CLEARING_L is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Clearing Data (Structure for Result List)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_RERA_GUI_CLEARING_L TYPE RERA_GUI_CLEARING_L.
The RERA_GUI_CLEARING_L table consists of various fields, each holding specific information or linking keys about Clearing Data (Structure for Result List) data available in SAP. These include OBJNR (Account Assignment: Object Number), DOCITEMID (Coded Key of FI Document Item for RE Internal Use), REFDOCTYPE (Reference to Document Class), REFDOCID (Reference Key of Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP RERA_GUI_CLEARING_L structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| OBJNR | Account Assignment: Object Number | RERAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | |||
| DOCITEMID | Coded Key of FI Document Item for RE Internal Use | RERADOCITEMID | CHAR | 30 | RERADOCITEMID | ||||
| REFDOCTYPE | Reference to Document Class | RERAREFDOCTYPE | CHAR | 5 | Assigned to domain | AWTYP | |||
| REFDOCID | Reference Key of Document | RERAREFDOCID | CHAR | 20 | CHAR20 | ||||
| REFITEMNO | Accounting Document Line Item Number | POSNR_ACC | NUMC | 10 | POSNR_ACC | ||||
| LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| REFGUID | Reference GUID | RERAREFGUID | RAW | 16 | RECAGUID | ||||
| CUSTOMER | Customer Number | RERACUSTOMERNO | CHAR | 10 | ALPHA | RERAPARTNERNO | KUN | C_KUNNR | |
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| CONTRACT | Contract Number | RECNNUMBER | CHAR | 13 | ALPHA | RECNNUMBER | RECNNR | RECNCN | |
| PYMTMETH | Payment Method | RERAPYMTMETH | CHAR | 4 | CHAR4 | ||||
| PYMTTERM | Terms of Payment Key | RERAPYMTTERM | CHAR | 4 | ZTERM | ||||
| PYMTBLOCK | Payment block key | RERAPYMTBLOCK | CHAR | 4 | CHAR4 | SPE | |||
| FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDFLOWTYPE | ||
| DCINDICATOR | Debit/Credit Indicator | RERADCINDICATOR | CHAR | 1 | RERADCINDICATOR | ||||
| SPLGIND | Special G/L Indicator | RERASPLGIND | CHAR | 1 | |||||
| PSTNGDATE | Posting Date | RERAPSTNGDATE | DATS | 8 | RECADATE | ||||
| PSTNGPERIOD | Posting Period | RERAPSTNGPERIOD | NUMC | 2 | RERAFISCALPERIOD | ||||
| CLEARINGDATE | Clearing Date | RERACLRNGDATE | DATS | 8 | RECADATE | ||||
| CLRDOCID | Reference Key of Clearing Document | RERACLRDOCID | CHAR | 20 | CHAR20 | ||||
| CLEARNGPROCESSID | Process Identification -> Accounting Reference Number | RECAPROCESSID | CHAR | 16 | RECAPROCESSID | ||||
| DOCDATE | Document Date | RERADOCDATE | DATS | 8 | RECADATE | ||||
| DOCTYPE | Document Type | RERADOCTYPE | CHAR | 2 | Assigned to domain | BLART | |||
| BLINEDATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
| HOUSEBKID | Key for House Bank | RERAHOUSEBKID | CHAR | 15 | CHAR15 | ||||
| HOUSEBKACC | Key for House Bank Account | RERAHOUSEBKACC | CHAR | 15 | CHAR15 | ||||
| BANKDETAILID | Bank Details ID | RERABANKDETAILID | CHAR | 15 | CHAR15 | ||||
| TAXTYPE | Tax Type | RERATAXTYPE | CHAR | 4 | Assigned to domain | RERATAXTYPE | |||
| TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | Assigned to domain | RERATAXGROUP | |||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| AMOUNT | Amount in Transaction Currency | RERAAMOUNT | CURR | 15(2) | RECACURR | ||||
| GROSSAMOUNT | Gross Amount in Transaction Currency | RERAGROSSAMOUNT | CURR | 15(2) | RECACURR | ||||
| NETAMOUNT | Net Amount in Transaction Currency | RERANETAMOUNT | CURR | 15(2) | RECACURR | ||||
| TAXAMOUNT | Tax Amount in Transaction Currency | RERATAXAMOUNT | CURR | 15(2) | RECACURR | ||||
| CURRENCY | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| CTLCAMOUNT | Amount in Local Currency | RECACTLCAMOUNT | CURR | 15(2) | RECACURR | ||||
| CTLCGROSSAMOUNT | Gross Amount in Local Currency | RECACTLCGROSSAMOUNT | CURR | 15(2) | RECACURR | ||||
| CTLCNETAMOUNT | Net Amount in Local Currency | RECACTLCNETAMOUNT | CURR | 15(2) | RECACURR | ||||
| CTLCTAXAMOUNT | Tax Amount in Local Currency | RECACTLCTAXAMOUNT | CURR | 15(2) | RECACURR | ||||
| CTLCCURRKEY | Local Currency | RECACTLCCURRKEY | CUKY | 5 | Assigned to domain | WAERS | |||
| CTFCAMOUNT | Amount in Foreign Currency | RECACTFCAMOUNT | CURR | 15(2) | RECACURR | ||||
| CTFCGROSSAMOUNT | Gross Amount in Foreign Currency | RECACTFCGROSSAMOUNT | CURR | 15(2) | RECACURR | ||||
| CTFCNETAMOUNT | Net Amount in Foreign Currency | RECACTFCNETAMOUNT | CURR | 15(2) | RECACURR | ||||
| CTFCTAXAMOUNT | Tax Amount in Foreign Currency | RECACTFCTAXAMOUNT | CURR | 15(2) | RECACURR | ||||
| CTFCCURRKEY | Foreign Currency | RECACTFCCURRKEY | CUKY | 5 | Assigned to domain | WAERS | |||
| EXTREF1 | External Reference 1 (Line Item) | RERAEXTREF1 | CHAR | 60 | |||||
| EXTREF2 | External Reference 2 (Line Item) | RERAEXTREF2 | CHAR | 60 | |||||
| EXTREF3 | External Reference 3 (Line Item) | RERAEXTREF3 | CHAR | 60 | |||||
| EXTREF4 | External Reference 4 (Line Item) | RERAEXTREF4 | CHAR | 60 | |||||
| INVREFNUMBER | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
| INVREFYEAR | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
| INVREFITEM | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
| XMACCTSHEETITEM | Name of Contract Account Sheet Item | RERAXLACCTSHEETITEM | CHAR | 60 | RECAXLDESCRIPTION | ||||
| XMACCTSHEETHDR | Name from Document Header | RERAXLACCTSHEETHDR | CHAR | 60 | RECAXLDESCRIPTION | ||||
| XIDENTOBJNR | Complete Object Identification, for Example BE 1000/123 | RECAIDENT | CHAR | 50 | CHAR50 | ||||
| XFLOWTYPE | Name of Flow Type | RECDXFLOWTYPE | CHAR | 30 | TEXT30 | ||||
| BENOCN | Site That Belongs to Contract | RECNBENOCN | CHAR | 8 | Assigned to domain | SWENR | REBDBENO | REBDBENO | |
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | Assigned to domain | XUBNAME | USER_COMP | ||
| XNAME | Short Name of Business Partner | REBPXNAME | CHAR | 50 | BU_TEXT50 | ||||
| RECNTYPE | Contract Type | RECNCONTRACTTYPE | CHAR | 4 | Assigned to domain | SMVART | RECNTYPE | RECNCONTRACTTYPE |
| Key field | Non-key field |
How do I retrieve data from SAP structure RERA_GUI_CLEARING_L using ABAP code?
As RERA_GUI_CLEARING_L is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RERA_GUI_CLEARING_L as there is no data to select.How to access SAP table RERA_GUI_CLEARING_L
Within an ECC or HANA version of SAP you can also view further information about RERA_GUI_CLEARING_L and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects