SAP ABAP Table RCML_ARC_REC (Archiving: Fields in VDBEKI and VDBEPI)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD_ARCHIVE (Package) Loan Reorganization and Archiving
⤷ FS-CML (Application Component) Loans Management
⤷ FVVD_ARCHIVE (Package) Loan Reorganization and Archiving
Basic Data
Table Category | INTTAB | Structure |
Structure | RCML_ARC_REC | Table Relationship Diagram |
Short Description | Archiving: Fields in VDBEKI and VDBEPI |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | RBELKPFD | RBELKPFD | RBELKPFD | CHAR | 10 | 0 | Document Number of Document Header (Loan) | ||
4 | RPOSNR | RPOSNR | NUM8 | NUMC | 8 | 0 | Item number of an executable right | ||
5 | RANL | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
6 | SBEWART | SBEWART | SBEWART | CHAR | 4 | 0 | Flow Type | * | |
7 | SLFDNR | VVSLFDNR | VVSLFDNR | NUMC | 5 | 0 | Sequence Number (Summarization of Loan Document Data) | ||
8 | SPLANIST | SPLANIST | SPLANIST | CHAR | 1 | 0 | Plan/actual record/record to be released indicator | ||
9 | SANLF | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | * | |
10 | NLFD_ANG | NLFD_ANG | LFNR3 | NUMC | 3 | 0 | Offer consecutive number | ||
11 | RKLAMMER | RKLAMMER | RANL | CHAR | 13 | 0 | Classification Number for Finance Projects | ||
12 | DVORGANG | DVORGANG | DATUM | DATS | 8 | 0 | Activity date | ||
13 | NVORGANG | NVORGANG | CHAR3 | CHAR | 3 | 0 | Activity number | ||
14 | SSTATI | SSTATI | STATI | NUMC | 2 | 0 | Status of data record | * | |
15 | RREFKONT | RREFKONT | USTRU | CHAR | 8 | 0 | Account Assignment Reference in Financial Assets Management | * | |
16 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | SKB1 | |
17 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
18 | SBLART | BLART | BLART | CHAR | 2 | 0 | Document type | T003 | |
19 | DBLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
20 | DBUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
21 | DGJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
22 | DMONAT | MONAT | MONAT | NUMC | 2 | 0 | Fiscal period | ||
23 | SSTORNO | SSTORNO | SSTORNO | CHAR | 1 | 0 | Reversal indicator | ||
24 | SSTOGRD | SSTOGRD | SSTOGRD | CHAR | 2 | 0 | Reason for Reversal | TZST | |
25 | RSTBLG | STBLG | BELNR | CHAR | 10 | 0 | Reverse Document Number | ||
26 | RZEBEL | RZEBEL | RBELKPFD | CHAR | 10 | 0 | Doc.no. of debit pos. doc.header (only for inc.pmnt records) | ||
27 | DORDER | DORDER | DATUM | DATS | 8 | 0 | Order day | ||
28 | DANJRNL | DANJRNL | DATUM | DATS | 8 | 0 | Date of transferal to journal | ||
29 | DANFIBU | DANFIBU | DATUM | DATS | 8 | 0 | Date of transferal to FiAc | ||
30 | UANFIBU | UANFIBU | TIMES | TIMS | 6 | 0 | Time of transfer to financial accounting | ||
31 | SSPESEN | SSPESEN | SSPESEN | CHAR | 1 | 0 | Expenses key | ||
32 | NORDER | NORDER | NUM8 | NUMC | 8 | 0 | Order Number | ||
33 | RBANKK | RBANKK | SAKNR | CHAR | 10 | 0 | Bank account | * | |
34 | SSTCKTG | SSTCKTG | SZBMETH | CHAR | 1 | 0 | Accrued interest: Daily method | ||
35 | PEFFZINS | PEFFZINS | DEC3_7 | DEC | 10 | 7 | Effective Interest Rate | ||
36 | SEFFMETH | SEFFMETH | SEFFMETH | NUMC | 1 | 0 | Effective Interest Method (Financial Mathematics) | ||
37 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
38 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
39 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
40 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
41 | DSTOCK | VVDSTOCK | DATUM | DATS | 8 | 0 | Premium reserve fund date | ||
42 | RPNNR | VVRPNNR | VVRPNNR | CHAR | 10 | 0 | Daybook no. | ||
43 | RVZBLG | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
44 | RPNSUP | VVRPNSUP | VVRPNNR | CHAR | 10 | 0 | Super prima nota for grouping in autom.deb.pos. | ||
45 | RUMBLG | UMBLG | BELNR | CHAR | 10 | 0 | Reference transfer document number | ||
46 | SEVALPOST | SEVALPOST | XFELD | CHAR | 1 | 0 | PEC for flow executed indicator yes/no | ||
47 | RUZBEL | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
48 | S_COMPR | S_COMPR | S_COMPR | CHAR | 1 | 0 | Summarization indicator for summarization of loan doc. data | ||
49 | HDN_KUNNR | HDN_KUNNR | KUNNR | CHAR | 10 | 0 | Main Borrower Customer Number | * | |
50 | REBZJ | REBZJ | GJAHR | NUMC | 4 | 0 | Fiscal Year of the Relevant Invoice (for Credit Memo) | ||
51 | REBZG | REBZG | BELNR | CHAR | 10 | 0 | Number of the Invoice the Transaction Belongs to | ||
52 | REBZZ | REBZZ | BUZEI | NUMC | 3 | 0 | Line Item in the Relevant Invoice | ||
53 | RSOLL | RSOLL | SAKNR | CHAR | 10 | 0 | Account for debit posting | * | |
54 | RHABEN | RHABEN | SAKNR | CHAR | 10 | 0 | Account for credit posting | * | |
55 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
56 | SREFBEW | SREFBEW | SBEWART | CHAR | 4 | 0 | Reference flow type | * | |
57 | SBEWZITI | SBEWZITI | SBEWZITI | CHAR | 4 | 0 | Flow category | * | |
58 | SREFZITI | VVSREFZITI | SBEWZITI | CHAR | 4 | 0 | Refer.flow category in accrual/deferral flow records | * | |
59 | S_SSDREF | VVS_SSDREF | SBEWZITI | CHAR | 4 | 0 | Reference flow category in borrower's note loan flow records | * | |
60 | SREVALEXCL | VVSREVALEXCL | XFELD | CHAR | 1 | 0 | Price gains w/o proportionate gains from deferral write-back | ||
61 | SWOHER | SWOHER | CHAR1 | CHAR | 1 | 0 | Source of flow record | ||
62 | DGUEL_KK | DGUEL | DATUM | DATS | 8 | 0 | Date Condition Effective from | ||
63 | SKOART | SKOART | SKOART | NUMC | 4 | 0 | Condition Type (Smallest Subdivision of Condition Records) | * | |
64 | SVORGANG | SVORFALL | SVORFALL | CHAR | 4 | 0 | Business Operation (Activity) | ||
65 | ACENV | ACENV_LO | ACENV_LO | NUMC | 4 | 0 | Source in TR-LO posting area | ||
66 | DGUEL_KP | DGUEL_KP | DATUM | DATS | 8 | 0 | Condition Item Valid From | ||
67 | NSTUFE | NSTUFE | NUMC2 | NUMC | 2 | 0 | Level number of condition item for recurring payments | ||
68 | SVORGKZ | VVSVORGKZ | VVSVORGKZ | NUMC | 2 | 0 | Activity indicator for debit/credit control | ||
69 | SSOLHAB | VVSSOLHAB | VVSSOLHAB | CHAR | 1 | 0 | Debit/credit indicator | ||
70 | SBERFIMA | SBEWFIMA | SBEWFIMA | CHAR | 4 | 0 | Calculation category for cash flow calculator | * | |
71 | SSTCKKZ | SSTCKKZ | SSTCKKZ | CHAR | 1 | 0 | Accrued interest method | ||
72 | SZBMETH | SZBMETH | SZBMETH | CHAR | 1 | 0 | Interest Calculation Method | ||
73 | STGMETH | VVSTGMETH | VVSTGMETH | NUMC | 1 | 0 | Daily Method | ||
74 | STGBASIS | VVSTGBASIS | VVSTGBASIS | CHAR | 1 | 0 | Base Days Method | ||
75 | ABASTAGE | ABASTAGE | INT6 | NUMC | 6 | 0 | Number of base days in a calculation period | ||
76 | PKOND | PKOND | DECV3_7 | DEC | 10 | 7 | Percentage rate for condition items | ||
77 | DPKOND | VVDPKOND | DATUM | DATS | 8 | 0 | Determination date for percentage rate of condition items | ||
78 | SBASIS | VVSBASIS | VVSBASIS | CHAR | 4 | 0 | Calculation base reference | * | |
79 | JSOFVERR | JSOFVERR | TFMSOFVERR | CHAR | 1 | 0 | Immediate settlement | ||
80 | BNWHR | BNWHR | WERTV7 | CURR | 13 | 2 | Nominal amount | ||
81 | SNWHR | SNWHR | WAERS | CUKY | 5 | 0 | Currency of nominal amount | * | |
82 | BBWHR | BBWHR | WERTV7 | CURR | 13 | 2 | Amount in position currency | ||
83 | SBWHR | SBWHR | WAERS | CUKY | 5 | 0 | Position Currency (Currency of Position Amount) | * | |
84 | BCWHR | BCWHR | WERTV7 | CURR | 13 | 2 | Settlement Amount | ||
85 | SCWHR | SCWHR | WAERS | CUKY | 5 | 0 | Settlement Currency | * | |
86 | BHWHR | BHWHR | WERTV7 | CURR | 13 | 2 | Amount in local currency | ||
87 | PKKURS | PKKURS | PWKURS | DEC | 10 | 7 | Purchase Price of Borrower's Note | ||
88 | PRUCK | PRUCK | DEC3_7 | DEC | 10 | 7 | Repayment rate in percent | ||
89 | KURS1 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
90 | KURS2 | VVKURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
91 | DVALUT | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
92 | DFAELL | DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
93 | DDISPO | DDISPO | DATUM | DATS | 8 | 0 | Payment Date | ||
94 | DBESTAND | DBESTAND | DATUM | DATS | 8 | 0 | Position value date | ||
95 | DBERVON | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
96 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
97 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
98 | RZKSOLL | RZKSOLL | SAKNR | CHAR | 10 | 0 | Debit interim account | * | |
99 | RZKHABE | RZKHABE | SAKNR | CHAR | 10 | 0 | Credit interim account | * | |
100 | SBSLSOLL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
101 | SBSLZKSO | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
102 | SBSLZKHA | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
103 | SHSLHABEN | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
104 | BUCHTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
105 | SFDLEV | FDLEV | FDLEV | CHAR | 2 | 0 | Planning Level | * | |
106 | JFDUPD | JFDUPD | JANEI | CHAR | 1 | 0 | Record transferred to cash management and forecast | ||
107 | JONLAEN | JONLAEN | VVSONLAEN | CHAR | 1 | 0 | Indicator for fixing a flow record | ||
108 | JZINSBAS | JZINSBAS | JANEI | CHAR | 1 | 0 | Flow in interest base | ||
109 | JZINSZPT | JZINSZPT | JANEI | CHAR | 1 | 0 | Interest date | ||
110 | BBASIS | BBASIS | WERTV7 | CURR | 13 | 2 | Calculation base amount | ||
111 | SSORTZIT | SSORTZIT | CHAR1 | CHAR | 1 | 0 | Sort indicator for interest/repayment schedule calculations | ||
112 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
113 | BVTYP | BVTYP | BVTYP | CHAR | 4 | 0 | Partner bank type | ||
114 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | * | |
115 | MABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | * | |
116 | ZAHLS | DZAHLS | ZAHLS | CHAR | 1 | 0 | Block Key for Payment | * | |
117 | RPARTNR | BP_PARTNR_NEW | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
118 | SROLEXT | DUMMY_3 | CHAR3 | CHAR | 3 | 0 | Dummy function | ||
119 | JEINBEHALT | JEINBEHALT | KENZX | CHAR | 1 | 0 | Indicator for Withholding of Amount During Disbursement | ||
120 | JFIRUECK | JFIRUECK | JANEI | CHAR | 1 | 0 | Confirmation From FI Not Necessary | ||
121 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
122 | MWART | MWART | MWART | CHAR | 1 | 0 | Tax Type | ||
123 | DBERBIS | DBERBIS | DATUM | DATS | 8 | 0 | End of Calculation Period | ||
124 | ATAGE | VVATAGE | INT6 | NUMC | 6 | 0 | Number of days | ||
125 | JSTOCK | VVJSTOCK | JANEI | CHAR | 1 | 0 | Premium reserve fund-relevant indicator | ||
126 | SBUST | VVSBUST | VVSBUST | NUMC | 2 | 0 | Posting control key | ||
127 | DTRANS | VVDTRANS | DATUM | DATS | 8 | 0 | Flow data key: System date | ||
128 | TTRANS | VVTTRANS | UZEIT | TIMS | 6 | 0 | Transaction data key: system time | ||
129 | NTRANS | VVNTRANS | NUMC4 | NUMC | 4 | 0 | Transaction data key: Consecutive number | ||
130 | SEXCLVON | VVSEXCLVON | VVSEXCLVON | NUMC | 1 | 0 | Exclusive Indicator for the Start of a Calculation Period | ||
131 | SULTVON | VVSULTVON | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start of a Calculation Period | ||
132 | SINCLBIS | VVSINCLBIS | VVSINCLBIS | NUMC | 1 | 0 | Inclusive Indicator for the End of a Calculation Period | ||
133 | SULTBIS | VVSULTBIS | VVSULT | CHAR | 1 | 0 | Month-End Indicator for the End of a Calculation Period | ||
134 | SINCL | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period | ||
135 | DVERRECH | VVDVERRECH | DATUM | DATS | 8 | 0 | Settlement date | ||
136 | SBUCHA | VVSBUCHA | CHAR1 | CHAR | 1 | 0 | Indicator for postings to accruals/deferrals accounts | ||
137 | ZINKZ | DZINKZ | ZINKZ | CHAR | 2 | 0 | Exempted from Interest Calculation | ||
138 | SVULT | VVSVULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Value Date | ||
139 | SINCLVERR | VVSINCLVER | VVSINCLVER | NUMC | 1 | 0 | Inclusive Indicator for Clearing Date | ||
140 | SULTVERR | VVSULTVERR | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Clearing Date | ||
141 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
142 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | * | |
143 | DBPERIOD | VVDBPERIOD | DATUM | DATS | 8 | 0 | Period start | ||
144 | SPAEXCL | TFMSPAEXCL | TFMSPAEXCL | NUMC | 1 | 0 | Exclusive Indicator for Start Date of a Period | ||
145 | SPAULT | TFMSPAULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start Date of a Period | ||
146 | DEPERIOD | VVDEPERIOD | DATUM | DATS | 8 | 0 | Period End | ||
147 | SPEINCL | TFMSPEINCL | TFMSPEINCL | NUMC | 1 | 0 | Inclusive Indicator for End Date of a Period | ||
148 | SPEULT | TFMSPEULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for End of a Period | ||
149 | RKONT | RKONT | RKONT | NUMC | 6 | 0 | Quota number | ||
150 | DAUSZ | VVDAUSZ | DATUM | DATS | 8 | 0 | Lead date for withholding amounts for disbursement | ||
151 | SSOLIST | SSOLIST | CHAR1 | CHAR | 1 | 0 | Calculation using actual principle (or debit) | ||
152 | RDARNEHM | RDARNEHM_NEW | BU_PARTNER | CHAR | 10 | 0 | Borrower/Applicant Number | * | |
153 | BKOND | BKOND | WERTV7 | CURR | 13 | 2 | Condition item currency amount | ||
154 | SBERECH | SBERECH | XFELD | CHAR | 1 | 0 | Grace Period Interest Method | ||
155 | BKARZINS | TFMBKAZINS | TFM_WRTV7 | CURR | 13 | 2 | Int.for days betw. redemption clear.and pmnt (FiMa-internal) | ||
156 | BTITALK | TFMBTIKALK | TFM_WRTV7 | CURR | 13 | 2 | Imputed annuity repayment amount (FiMa internal) | ||
157 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
158 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
159 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
160 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
161 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
162 | PWKURS | PWKURS | PWKURS | DEC | 10 | 7 | Security price for percentage quotation | ||
163 | DZFEST | TB_DZFEST | DATUM | DATS | 8 | 0 | Interest rate fixing date | ||
164 | XPORE | PRQ_XPORE | XFELD | CHAR | 1 | 0 | Indicator: Individual Payment? | ||
165 | SPAYRQ | TB_SPAYRQK | XFELD | CHAR | 1 | 0 | Generate payment request | ||
166 | PRKEY | PRQ_KEYNO | PRQ_KEYNO | CHAR | 10 | 0 | Key Number for Payment Request | * | |
167 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | * | |
168 | HKTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | * | |
169 | VORGTYP | VORGTYP_LO | VORGTYP_LO | CHAR | 4 | 0 | Activity Category (Posting Area) | ||
170 | SSIGN | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
171 | SPRSNG | TB_SPRSNGK | XFELD | CHAR | 1 | 0 | Individual payment | ||
172 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | * | |
173 | SPRGRD | TB_SPRGRD | T_SPRGRD | CHAR | 1 | 0 | Determine grouping definition | ||
174 | SCSPAY | TB_SCSPAY | XFELD | CHAR | 1 | 0 | Same direction necessary for joint payment? | ||
175 | ZWELS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
176 | PAYGR | PAYGR | CHAR20 | CHAR | 20 | 0 | Grouping Field for Automatic Payments | ||
177 | JEXPOZINS | TB_JZINSRE | XFELD | CHAR | 1 | 0 | Exponential Interest Calculation | ||
178 | SROUND | TFM_SROUND | TFM_SROUND | CHAR | 1 | 0 | Rounding Category | ||
179 | SKALIDWT | TFMSKALIDWT | WFCID | CHAR | 2 | 0 | Interest Calendar | * | |
180 | JVERF | JVERF | JVERF | CHAR | 1 | 0 | Indicator whether drawings exist for the disbursement | ||
181 | PPAYMENT | TFM_PPAYMENT | TFM_PPAYMENT | DEC | 11 | 7 | Payment Rate | ||
182 | AMMRHYZV | TFM_AMMRHYZV | TFM_AMMRHYZV | NUMC | 2 | 0 | Interest Settlement Frequency for Exponential Interest Calc. |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RCML_ARC_REC | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | RCML_ARC_REC | HKONT | SKB1 | SAKNR | KEY | 1 | CN |
3 | RCML_ARC_REC | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | RCML_ARC_REC | SBLART | T003 | BLART | KEY | 1 | CN |
5 | RCML_ARC_REC | SSTOGRD | TZST | SSTOGRD | KEY | 1 | 1 |
History
Last changed by/on | SAP | 20141121 |
SAP Release Created in | 462_10 |