RERA_CLEARING_RECORD SAP (Record of Open Items for Clearing) Structure details
Dictionary Type: Structure
Description: Record of Open Items for Clearing
Description: Record of Open Items for Clearing
ABAP Code to SELECT data from RERA_CLEARING_RECORD
Related tables to RERA_CLEARING_RECORD
Access table RERA_CLEARING_RECORD
Related tables to RERA_CLEARING_RECORD
Access table RERA_CLEARING_RECORD
Structure field list including key, data, relationships and ABAP select examples
RERA_CLEARING_RECORD 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 "Record of Open Items for Clearing" 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_CLEARING_RECORD TYPE RERA_CLEARING_RECORD.
The RERA_CLEARING_RECORD table consists of various fields, each holding specific information or linking keys about Record of Open Items for Clearing data available in SAP. These include DOCITEMID (Coded Key of FI Document Item for RE Internal Use), REFDOCTYPE (Reference to Document Class), REFDOCID (Reference Key of Document), REFITEMNO (Accounting Document Line Item Number).. 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_CLEARING_RECORD 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 |
| Key field | Non-key field |
How do I retrieve data from SAP structure RERA_CLEARING_RECORD using ABAP code?
As RERA_CLEARING_RECORD 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_CLEARING_RECORD as there is no data to select.How to access SAP table RERA_CLEARING_RECORD
Within an ECC or HANA version of SAP you can also view further information about RERA_CLEARING_RECORD 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