RCML_ARC_REC SAP (Archiving: Fields in VDBEKI and VDBEPI) Structure details
Description: Archiving: Fields in VDBEKI and VDBEPI
Structure field list including key, data, relationships and ABAP select examples
RCML_ARC_REC 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 "Archiving: Fields in VDBEKI and VDBEPI" 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_RCML_ARC_REC TYPE RCML_ARC_REC.
The RCML_ARC_REC table consists of various fields, each holding specific information or linking keys about Archiving: Fields in VDBEKI and VDBEPI data available in SAP. These include BUKRS (Company Code), RBELKPFD (Document Number of Document Header (Loan)), RPOSNR (Item number of an executable right), RANL (Contract 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: Not classified
SAP RCML_ARC_REC 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RBELKPFD | Document Number of Document Header (Loan) | RBELKPFD | CHAR | 10 | ALPHA | RBELKPFD | |||
RPOSNR | Item number of an executable right | RPOSNR | NUMC | 8 | NUM8 | ||||
RANL | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
SBEWART | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
SLFDNR | Sequence Number (Summarization of Loan Document Data) | VVSLFDNR | NUMC | 5 | VVSLFDNR | ||||
SPLANIST | Plan/actual record/record to be released indicator | SPLANIST | CHAR | 1 | SPLANIST | ||||
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
NLFD_ANG | Offer consecutive number | NLFD_ANG | NUMC | 3 | LFNR3 | ||||
RKLAMMER | Classification Number for Finance Projects | RKLAMMER | CHAR | 13 | ALPHA | RANL | |||
DVORGANG | Activity date | DVORGANG | DATS | 8 | DATUM | ||||
NVORGANG | Activity number | NVORGANG | CHAR | 3 | CHAR3 | ||||
SSTATI | Status of data record | SSTATI | NUMC | 2 | Assigned to domain | STATI | |||
RREFKONT | Account Assignment Reference in Financial Assets Management | RREFKONT | CHAR | 8 | Assigned to domain | USTRU | KRE | ||
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKB1 | ALPHA | SAKNR | ||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
SBLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
DBLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
DBUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
DGJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
DMONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
SSTORNO | Reversal indicator | SSTORNO | CHAR | 1 | SSTORNO | ||||
SSTOGRD | Reason for Reversal | SSTOGRD | CHAR | 2 | TZST | SSTOGRD | |||
RSTBLG | Reverse Document Number | STBLG | CHAR | 10 | ALPHA | BELNR | |||
RZEBEL | Doc.no. of debit pos. doc.header (only for inc.pmnt records) | RZEBEL | CHAR | 10 | ALPHA | RBELKPFD | |||
DORDER | Order day | DORDER | DATS | 8 | DATUM | ||||
DANJRNL | Date of transferal to journal | DANJRNL | DATS | 8 | DATUM | ||||
DANFIBU | Date of transferal to FiAc | DANFIBU | DATS | 8 | DATUM | ||||
UANFIBU | Time of transfer to financial accounting | UANFIBU | TIMS | 6 | TIMES | ||||
SSPESEN | Expenses key | SSPESEN | CHAR | 1 | SSPESEN | ||||
NORDER | Order Number | NORDER | NUMC | 8 | NUM8 | ORD | |||
RBANKK | Bank account | RBANKK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | BKT | |
SSTCKTG | Accrued interest: Daily method | SSTCKTG | CHAR | 1 | SZBMETH | ||||
PEFFZINS | Effective Interest Rate | PEFFZINS | DEC | 10(7) | DEC3_7 | ||||
SEFFMETH | Effective Interest Method (Financial Mathematics) | SEFFMETH | NUMC | 1 | SEFFMETH | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
DSTOCK | Premium reserve fund date | VVDSTOCK | DATS | 8 | DATUM | ||||
RPNNR | Daybook no. | VVRPNNR | CHAR | 10 | VVRPNNR | ||||
RVZBLG | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
RPNSUP | Super prima nota for grouping in autom.deb.pos. | VVRPNSUP | CHAR | 10 | VVRPNNR | ||||
RUMBLG | Reference transfer document number | UMBLG | CHAR | 10 | ALPHA | BELNR | |||
SEVALPOST | PEC for flow executed indicator yes/no | SEVALPOST | CHAR | 1 | XFELD | ||||
RUZBEL | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
S_COMPR | Summarization indicator for summarization of loan doc. data | S_COMPR | CHAR | 1 | S_COMPR | ||||
HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | REBZJ | NUMC | 4 | GJAHR | GJAHR | |||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
REBZZ | Line Item in the Relevant Invoice | REBZZ | NUMC | 3 | BUZEI | ||||
RSOLL | Account for debit posting | RSOLL | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
RHABEN | Account for credit posting | RHABEN | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SREFBEW | Reference flow type | SREFBEW | CHAR | 4 | Assigned to domain | SBEWART | |||
SBEWZITI | Flow category | SBEWZITI | CHAR | 4 | Assigned to domain | SBEWZITI | |||
SREFZITI | Refer.flow category in accrual/deferral flow records | VVSREFZITI | CHAR | 4 | Assigned to domain | SBEWZITI | |||
S_SSDREF | Reference flow category in borrower's note loan flow records | VVS_SSDREF | CHAR | 4 | Assigned to domain | SBEWZITI | |||
SREVALEXCL | Price gains w/o proportionate gains from deferral write-back | VVSREVALEXCL | CHAR | 1 | XFELD | ||||
SWOHER | Source of flow record | SWOHER | CHAR | 1 | CHAR1 | ||||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | Assigned to domain | SKOART | |||
SVORGANG | Business Operation (Activity) | SVORFALL | CHAR | 4 | SVORFALL | ||||
ACENV | Source in TR-LO posting area | ACENV_LO | NUMC | 4 | ACENV_LO | ||||
DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM | ||||
NSTUFE | Level number of condition item for recurring payments | NSTUFE | NUMC | 2 | NUMC2 | ||||
SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 2 | VVSVORGKZ | ||||
SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | VVSSOLHAB | ||||
SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | CHAR | 4 | Assigned to domain | SBEWFIMA | |||
SSTCKKZ | Accrued interest method | SSTCKKZ | CHAR | 1 | SSTCKKZ | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
STGMETH | Daily Method | VVSTGMETH | NUMC | 1 | VVSTGMETH | ||||
STGBASIS | Base Days Method | VVSTGBASIS | NUMC | 1 | VVSTGBASIS | ||||
ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | INT6 | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
DPKOND | Determination date for percentage rate of condition items | VVDPKOND | DATS | 8 | DATUM | ||||
SBASIS | Calculation base reference | VVSBASIS | CHAR | 4 | Assigned to domain | VVSBASIS | |||
JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | Assigned to domain | WAERS | |||
BBWHR | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
BCWHR | Settlement Amount | BCWHR | CURR | 13(2) | WERTV7 | ||||
SCWHR | Settlement Currency | SCWHR | CUKY | 5 | Assigned to domain | WAERS | |||
BHWHR | Amount in local currency | BHWHR | CURR | 13(2) | WERTV7 | ||||
PKKURS | Purchase Price of Borrower's Note | PKKURS | DEC | 10(7) | PWKURS | ||||
PRUCK | Repayment rate in percent | PRUCK | DEC | 10(7) | DEC3_7 | ||||
KURS1 | Exchange rate | VVKURSF | DEC | 9(5) | EXCRT | KURSF | |||
KURS2 | Exchange rate | VVKURSF | DEC | 9(5) | EXCRT | KURSF | |||
DVALUT | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
DDISPO | Payment Date | DDISPO | DATS | 8 | DATUM | ||||
DBESTAND | Position value date | DBESTAND | DATS | 8 | DATUM | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
RZKSOLL | Debit interim account | RZKSOLL | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
RZKHABE | Credit interim account | RZKHABE | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
SBSLSOLL | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
SBSLZKSO | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
SBSLZKHA | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
SHSLHABEN | Posting Key | BSCHL | CHAR | 2 | Assigned to domain | BSCHL | |||
BUCHTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
SFDLEV | Planning level | FDLEV | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
JFDUPD | Record transferred to cash management and forecast | JFDUPD | CHAR | 1 | JANEI | ||||
JONLAEN | Indicator for fixing a flow record | JONLAEN | CHAR | 1 | VVSONLAEN | ||||
JZINSBAS | Flow in interest base | JZINSBAS | CHAR | 1 | JANEI | ||||
JZINSZPT | Interest date | JZINSZPT | CHAR | 1 | JANEI | ||||
BBASIS | Calculation base amount | BBASIS | CURR | 13(2) | WERTV7 | ||||
SSORTZIT | Sort indicator for interest/repayment schedule calculations | SSORTZIT | CHAR | 1 | CHAR1 | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
MABER | Dunning Area | MABER | CHAR | 2 | Assigned to domain | MABER | |||
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | Assigned to domain | ZAHLS | |||
RPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
SROLEXT | Dummy function | DUMMY_3 | CHAR | 3 | CHAR3 | ||||
JEINBEHALT | Indicator for Withholding of Amount During Disbursement | JEINBEHALT | CHAR | 1 | KENZX | ||||
JFIRUECK | Confirmation From FI Not Necessary | JFIRUECK | CHAR | 1 | JANEI | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
MWART | Tax Type | MWART | CHAR | 1 | MWART | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
ATAGE | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
JSTOCK | Premium reserve fund-relevant indicator | VVJSTOCK | CHAR | 1 | JANEI | ||||
SBUST | Posting control key | VVSBUST | NUMC | 2 | VVSBUST | ||||
DTRANS | Flow data key: System date | VVDTRANS | DATS | 8 | DATUM | ||||
TTRANS | Transaction data key: system time | VVTTRANS | TIMS | 6 | UZEIT | ||||
NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 4 | NUMC4 | ||||
SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | VVSEXCLVON | ||||
SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | VVSULT | ||||
SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | VVSINCLBIS | ||||
SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | VVSULT | ||||
SINCL | Inclusive indicator for beginning and end of a period | VVSINCL | NUMC | 1 | VVSINCL | ||||
DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | DATUM | ||||
SBUCHA | Indicator for postings to accruals/deferrals accounts | VVSBUCHA | CHAR | 1 | CHAR1 | ||||
ZINKZ | Exempted from interest calculation | DZINKZ | CHAR | 2 | ZINKZ | ||||
SVULT | Month-End Indicator for Value Date | VVSVULT | CHAR | 1 | VVSULT | ||||
SINCLVERR | Inclusive Indicator for Clearing Date | VVSINCLVER | NUMC | 1 | VVSINCLVER | ||||
SULTVERR | Month-End Indicator for Clearing Date | VVSULTVERR | CHAR | 1 | VVSULT | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | Assigned to domain | MANSP | |||
DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | DATUM | ||||
SPAEXCL | Exclusive Indicator for Start Date of a Period | TFMSPAEXCL | NUMC | 1 | TFMSPAEXCL | ||||
SPAULT | Month-End Indicator for Start Date of a Period | TFMSPAULT | CHAR | 1 | VVSULT | ||||
DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | DATUM | ||||
SPEINCL | Inclusive Indicator for End Date of a Period | TFMSPEINCL | NUMC | 1 | TFMSPEINCL | ||||
SPEULT | Month-End Indicator for End of a Period | TFMSPEULT | CHAR | 1 | VVSULT | ||||
RKONT | Quota number | RKONT | NUMC | 6 | RKONT | RKT | |||
DAUSZ | Lead date for withholding amounts for disbursement | VVDAUSZ | DATS | 8 | DATUM | ||||
SSOLIST | Calculation using actual principle (or debit) | SSOLIST | CHAR | 1 | CHAR1 | ||||
RDARNEHM | Borrower/Applicant Number | RDARNEHM_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BKOND | Condition item currency amount | BKOND | CURR | 13(2) | WERTV7 | ||||
SBERECH | Grace Period Interest Method | SBERECH | CHAR | 1 | XFELD | ||||
BKARZINS | Int.for days betw. redemption clear.and pmnt (FiMa-internal) | TFMBKAZINS | CURR | 13(2) | TFM_WRTV7 | ||||
BTITALK | Imputed annuity repayment amount (FiMa internal) | TFMBTIKALK | CURR | 13(2) | TFM_WRTV7 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SZART | Payment transaction | TB_SZART | CHAR | 1 | XFELD | ||||
PWKURS | Security price for percentage quotation | PWKURS | DEC | 10(7) | PWKURS | ||||
DZFEST | Interest rate fixing date | TB_DZFEST | DATS | 8 | DATUM | ||||
XPORE | Indicator: Individual Payment? | PRQ_XPORE | CHAR | 1 | XFELD | ||||
SPAYRQ | Generate payment request | TB_SPAYRQK | CHAR | 1 | XFELD | ||||
PRKEY | Key Number for Payment Request | PRQ_KEYNO | CHAR | 10 | Assigned to domain | ALPHA | PRQ_KEYNO | ||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
HKTID | ID for account details | HKTID | CHAR | 5 | Assigned to domain | HKTID | |||
VORGTYP | Activity Category (Posting Area) | VORGTYP_LO | CHAR | 4 | VORGTYP_LO | ||||
SSIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
SPRSNG | Individual payment | TB_SPRSNGK | CHAR | 1 | XFELD | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | Assigned to domain | UZAWE | |||
SPRGRD | Determine grouping definition | TB_SPRGRD | CHAR | 1 | T_SPRGRD | ||||
SCSPAY | Same direction necessary for joint payment? | TB_SCSPAY | CHAR | 1 | XFELD | ||||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
PAYGR | Grouping Field for Automatic Payments | PAYGR | CHAR | 20 | CHAR20 | ||||
JEXPOZINS | Exponential Interest Calculation | TB_JZINSRE | CHAR | 1 | XFELD | ||||
SROUND | Rounding Category | TFM_SROUND | CHAR | 1 | TFM_SROUND | ||||
SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
JVERF | Indicator whether drawings exist for the disbursement | JVERF | CHAR | 1 | JVERF | ||||
PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11(7) | TFM_PPAYMENT | ||||
AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | TFM_AMMRHYZV |
Key field | Non-key field |
How do I retrieve data from SAP structure RCML_ARC_REC using ABAP code?
As RCML_ARC_REC 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 RCML_ARC_REC as there is no data to select.How to access SAP table RCML_ARC_REC
Within an ECC or HANA version of SAP you can also view further information about RCML_ARC_REC 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