REXA_GUI_ACCT_STATEMENT_L SAP (Account Statement (List)) Structure details
Description: Account Statement (List)
Related tables to REXA_GUI_ACCT_STATEMENT_L
Access table REXA_GUI_ACCT_STATEMENT_L
Structure field list including key, data, relationships and ABAP select examples
REXA_GUI_ACCT_STATEMENT_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 "Account Statement (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_REXA_GUI_ACCT_STATEMENT_L TYPE REXA_GUI_ACCT_STATEMENT_L.
The REXA_GUI_ACCT_STATEMENT_L table consists of various fields, each holding specific information or linking keys about Account Statement (List) data available in SAP. These include DOCNUMBER (Number of document in Contract A/R + A/P), DOCITEMNO (Number of Line Item Within Accounting Document), DOCITEMID (Coded Key of FI Document Item for RE Internal Use), PARTNER (Business Partner 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 REXA_GUI_ACCT_STATEMENT_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 |
CNACCT | Contract Account Number | REXACNACCT | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
DOCNUMBER | Number of document in Contract A/R + A/P | OPBEL_KK2 | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
DOCITEMNO | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
DOCITEMID | Coded Key of FI Document Item for RE Internal Use | RERADOCITEMID | CHAR | 30 | RERADOCITEMID | ||||
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 | |
OBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
OBJNRCALC | Object Number for Calculation | RECDOBJNRCALC | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
FISCALYEAR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
PSTNGPERIOD | Posting Period | RERAPSTNGPERIOD | NUMC | 2 | RERAFISCALPERIOD | ||||
PROCESSID | Process Identification -> Accounting Reference Number | RECAPROCESSID | CHAR | 16 | RECAPROCESSID | ||||
PSTNGPROCEDURE | Posting Procedure | RERAPROCEDURE | CHAR | 4 | Assigned to domain | RERAPROCEDURE | |||
REFDOCID | Reference Key of Document | RERAREFDOCID | CHAR | 20 | CHAR20 | ||||
REFITEMNO | Reference to Other Item Number of Document | RERAREFITEMNO | NUMC | 10 | POSNR_ACC | ||||
LOGSYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
CONDTYPE | Condition Type | RECDCONDTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDCONDTYPE | ||
ISADVANCEPAYMENT | Condition Is Advance Payment Condition | RECDADVANCEPAYMENT | CHAR | 1 | RECABOOL | ||||
FLOWTYPE | Flow Type | RECDFLOWTYPE | CHAR | 4 | Assigned to domain | ALPHA | RECDFLOWTYPE | ||
PSTNGDATE | Posting Date | RERAPSTNGDATE | DATS | 8 | RECADATE | ||||
DOCDATE | Document Date | RERADOCDATE | DATS | 8 | RECADATE | ||||
BLINEDATE | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
DCDEBITAMOUNT | Debit Amount | RERADEBITAMOUNT | CURR | 15(2) | RECACURR | ||||
DCCREDITAMOUNT | Credit Amount | RERACREDITAMOUNT | CURR | 15(2) | RECACURR | ||||
DCBALANCE | Balance | RERABALANCE | 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 | ||
TAXTYPE | Tax Type | RERATAXTYPE | CHAR | 4 | Assigned to domain | RERATAXTYPE | |||
TAXGROUP | Tax Group | RERATAXGROUP | CHAR | 20 | Assigned to domain | RERATAXGROUP | |||
CLEARINGSTATUS | Clearing status | RERACLEARINGSTATUS | CHAR | 2 | CHAR02 | ||||
XMACCTSTMNTITEM | Name of Contract Account Sheet Item | RERAXMACCTSHEETITEM | CHAR | 30 | RECAXMDESCRIPTION | ||||
XMACCTSTMNTHDR | Name from Document Header | RERAXMACCTSHEETHDR | CHAR | 30 | RECAXMDESCRIPTION | ||||
OBJ_TYPE | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
OBJ_KEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
DUNNBLOCK | Dunning Block | RERADUNNBLOCK | CHAR | 4 | CHAR4 | ||||
DUNNKEY | Dunning Keys | RERADUNNKEY | CHAR | 4 | CHAR4 | ||||
DUNNDATE | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
DUNNLEVEL | Dunning Level | RERADUNNLEVEL | NUMC | 1 | MAHNS | ||||
DUNNAREA | Dunning Area | RERADUNNAREA | CHAR | 4 | CHAR4 | ||||
PYMTMETH | Payment Method | RERAPYMTMETH | CHAR | 4 | CHAR4 | ||||
PYMTTERM | Terms of Payment Key | RERAPYMTTERM | CHAR | 4 | ZTERM | ||||
CALCFROM | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
CALCTO | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
REVID | Indicator for Reversed Documents | RERAREVID | CHAR | 1 | RERAREVID | ||||
DOCTYPE | Document Type | RERADOCTYPE | CHAR | 2 | Assigned to domain | BLART | |||
CLEARINGDATE | Clearing Date | RERACLRNGDATE | DATS | 8 | RECADATE | ||||
CLRDOCID | Reference Key of Clearing Document | RERACLRDOCID | CHAR | 20 | CHAR20 | ||||
PROCESSTITLE | Process Name | RECAPROCESSTITLE | CHAR | 30 | RECAXMDESCRIPTION | ||||
XCONDTYPEM | Name of Condition Type | RECDXCONDTYPEM | CHAR | 20 | TEXT20 | ||||
XFLOWTYPE | Name of Flow Type | RECDXFLOWTYPE | CHAR | 30 | TEXT30 | ||||
XTAXTYPE | Name of Tax Type | RERAXMTAXTYPE | CHAR | 30 | RECAXMDESCRIPTION | ||||
XTAXGROUP | Name of Tax Group | RERAXMTAXGROUP | CHAR | 30 | RECAXMDESCRIPTION | ||||
IDENTCALC | Complete Object Identification, for Example BE 1000/123 | RECAIDENT | CHAR | 50 | CHAR50 | ||||
XDUNNBLOCK | Reason for dunning block text | TEXT1_040T | CHAR | 50 | TEXT50 | ||||
XDUNNKEY | Name of Dunning Key | RERAXDUNNKEY | CHAR | 60 | RECAXLDESCRIPTION | ||||
XDUNNAREA | Name of Dunning Area | RERAXDUNNAREA | CHAR | 60 | RECAXLDESCRIPTION | ||||
XPYMTMETH | Name of Payment Method in Language of the Country | TEXT1_042Z | CHAR | 30 | TEXT30 | ||||
XPYMTTERM | Own Explanation of Term of Payment | TEXT1_052 | CHAR | 50 | TEXT50 | ||||
XREVID | Indicator for Reversed Documents | RERAXMREVID | CHAR | 30 | RECAXMDESCRIPTION | ||||
CUMBALANCE | Cumulative Balance | RERACUMBALANCE | CURR | 15(2) | RECACURR | ||||
XPSTNGPER | Posting Period in MM/YYYY Format | REEXPSTNGPERIOD6 | NUMC | 6 | PERI6 | REEXPSTNGPERIOD6 |
Key field | Non-key field |
How do I retrieve data from SAP structure REXA_GUI_ACCT_STATEMENT_L using ABAP code?
As REXA_GUI_ACCT_STATEMENT_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 REXA_GUI_ACCT_STATEMENT_L as there is no data to select.How to access SAP table REXA_GUI_ACCT_STATEMENT_L
Within an ECC or HANA version of SAP you can also view further information about REXA_GUI_ACCT_STATEMENT_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