SAP ABAP Table REIS_AL_L (Reporting Fields: Accruals/Deferrals)
Hierarchy
☛
EA-FIN (Software Component) EA-FIN
⤷ RE-FX-IS (Application Component) Information System
⤷ RE_IS_EX (Package) RE: External Applications Info System
⤷ RE-FX-IS (Application Component) Information System
⤷ RE_IS_EX (Package) RE: External Applications Info System
Basic Data
Table Category | INTTAB | Structure |
Structure | REIS_AL_L | Table Relationship Diagram |
Short Description | Reporting Fields: Accruals/Deferrals |
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 | .INCLUDE | 0 | 0 | Line Items for Accrual Item in Accrual Engine | |||||
2 | .INCLUDE | 0 | 0 | Unique Key for Table ACEPSOIT (Document in Accrual Engine) | |||||
3 | .INCLUDE | 0 | 0 | Keys of Accrual Posting Object | |||||
4 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
5 | COMP | ACE_COMP | ACE_COMP | CHAR | 4 | 0 | Accrual Engine Application Component | * | |
6 | BUKRS | ACE_BUKRS | ACE_BUKRS | CHAR | 4 | 0 | Company Code | * | |
7 | GJAHR | ACEPS_GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year in Accrual Engine | ||
8 | OBJID | ACE_GUID | ACE_GUID | RAW | 16 | 0 | Accrual Object (Internal Display in Form of a GUID) | * | |
9 | SUBID | ACE_SUBID | NUMC | 5 | 0 | Accrual Subobject (Internal Display, Sequence Number) | |||
10 | ACRTYPE | ACE_ACRTYPE | ACE_ACRTYPE | CHAR | 6 | 0 | Accrual Type | TACE_ACRTYPE | |
11 | ACCRULE | ACCOUNTING_PRINCIPLE | ACCOUNTING_PRINCIPLE | CHAR | 4 | 0 | Accounting Principle | TACC_PRINCIPLE | |
12 | DOCNR | ACEPS_DOCNR | CHAR15 | CHAR | 15 | 0 | Document Number of an Accrual Engine Document | ||
13 | .INCLUDE | 0 | 0 | Attributes: Accrual Item in Posting Component | |||||
14 | VALCUM | ACE_AMOUNT_CUMULATED | CURR | 15 | 2 | Cumulative Value (Previously Accrued) | |||
15 | VALTBP | ACE_AMOUNT_TBP | CURR | 15 | 2 | Amount Currently Posted | |||
16 | CURRENCY | ACEDS_VALCURRENCY | WAERS | CUKY | 5 | 0 | Currency Calculated/Posted in the Accrual Amounts | * | |
17 | TRANSTYPE | ACE_TRANSTYPE | ACE_TRANSTYPE | CHAR | 1 | 0 | Transaction in Accrual Engine | ||
18 | EFFDATE | ACE_EFFDATE | DATS | 8 | 0 | Key Date/Posting Date for Accruals | |||
19 | PODATE | ACE_PODATE | DATUM | DATS | 8 | 0 | Posting Date | ||
20 | POPER | ACE_POPER | POPER | NUMC | 3 | 0 | Posting Period in Financial Accounting | ||
21 | POYEAR | ACE_POYEAR | GJAHR | NUMC | 4 | 0 | Fiscal Year in Financial Accounting | ||
22 | RUNID | ACEPS_RUNID | ACEPS_RUNID | CHAR | 10 | 0 | Number (Run ID) of a Periodic Accrual Run in the Accl Engine | ||
23 | .INCLUDE | 0 | 0 | Reference to FI/CO Document | |||||
24 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
25 | AWKEY | ACE_AWKEY | AWKEY | CHAR | 20 | 0 | Reference Key for Accounting Document | ||
26 | AWSYS | AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | * | |
27 | TIMESTMP | ACE_HZSTMP | ACE_TSTMP | DEC | 16 | 0 | Time Added (Greenwich Meantime) | ||
28 | .INCLUDE | 0 | 0 | Reversal Information | |||||
29 | REVERSAL_DOC | ACEPS_FLAG_REVERSAL_DOC | FLAG | CHAR | 1 | 0 | Indicator: Document Is a Reversal Document | ||
30 | REVERSED_DOC | ACEPS_DOCNR_REVERSED | CHAR15 | CHAR | 15 | 0 | Number of the Reversed Accrual Engine Document | ||
31 | .INCLUDE | 0 | 0 | FI Documents: Items | |||||
32 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
33 | BSCHL | BSCHL | BSCHL | CHAR | 2 | 0 | Posting Key | * | |
34 | UMSKZ | UMSKZ | UMSKZ | CHAR | 1 | 0 | Special G/L Indicator | * | |
35 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
36 | SHKZG | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
37 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
38 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | * | |
39 | DMBTR | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
40 | WRBTR | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
41 | MENGE | MEGXXX | MENGV8 | QUAN | 15 | 3 | Total Quantity | ||
42 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
43 | HWAERS | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
44 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
45 | BRUTTO | DMBTR | WERT7 | CURR | 13 | 2 | Amount in local currency | ||
46 | MWSTS | MWSTS | WERT7 | CURR | 13 | 2 | Tax Amount in Local Currency | ||
47 | WMWST | WMWST | WERT7 | CURR | 13 | 2 | Tax amount in document currency | ||
48 | WBRUTTO | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
49 | DESCRIPTION | REEXACCOUNTDESCRIPTION | NAME | CHAR | 35 | 0 | Account Description | ||
50 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
51 | CLEARED | VVJAUGBEL | XFELD | CHAR | 1 | 0 | Indicator: Item from clearing document | ||
52 | AUGBL | AUGBL | BELNR | CHAR | 10 | 0 | Document Number of the Clearing Document | ||
53 | IDENT | RECAIDENT | CHAR50 | CHAR | 50 | 0 | Complete Object Identification, for Example BE 1000/123 | ||
54 | CREDITORNAME | RECACREDITORNAME | NAME | CHAR | 35 | 0 | Vendor Name | ||
55 | SWENR | RESCSUBE | REBDBENO | CHAR | 8 | 0 | Valid Business Entity | * | |
56 | SNKSL | RESCSCKEY | RESCSCKEY | CHAR | 4 | 0 | Service Charge Key | * | |
57 | SEMPSL | RESCSUID | RESCSUID | CHAR | 5 | 0 | Settlement Unit | ||
58 | DPERBEG | RESCSETTLEVALIDFROM | RECADATE | DATS | 8 | 0 | Start of Settlement Period | ||
59 | DPEREND | RESCSETTLEVALIDTO | RECADATEEND | DATS | 8 | 0 | End of Settlement Period | ||
60 | DABRBEZ | DABRBEZ | DDAT | DATS | 8 | 0 | Reference date for settlement | ||
61 | BELNR | CO_BELNR | CO_BELNR | CHAR | 10 | 0 | Document Number | * | |
62 | REFBN | CO_REFBN | BELNR | CHAR | 10 | 0 | Reference Document Number | ||
63 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
64 | LOGSYSTEM | LOGSYSTEM | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
65 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | * | |
66 | KOBEZ | KOBEZ | TEXT30 | CHAR | 30 | 0 | Account Description | ||
67 | RECNNR | RECNNR | RECNNR | CHAR | 13 | 0 | Real Estate Contract Number | ||
68 | .INCLUDE | 0 | 0 | RE Contract: Non-Key Fields | |||||
69 | OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
70 | IMKEY | RECAIMKEY | IMKEY | CHAR | 8 | 0 | Internal Key of Real Estate Object (FI) | ||
71 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
72 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
73 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
74 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
75 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
76 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
77 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
78 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
79 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
80 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
81 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | USR02 | |
82 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | USR02 | |
83 | AUTHGRP | RECAAUTHGRP | RECAAUTHGRP | CHAR | 40 | 0 | Authorization Group | ||
84 | RECNTYPE | RECNCONTRACTTYPE | SMVART | CHAR | 4 | 0 | Contract Type | TIV26 | |
85 | RECNBEG | RECNCNBEG | RECADATE | DATS | 8 | 0 | Date of contract start | ||
86 | RECNENDABS | RECNCNENDABS | RECADATEEND | DATS | 8 | 0 | Term End Date | ||
87 | RECNTXT | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
88 | RECNDACTIV | DAKTV | DATUM | DATS | 8 | 0 | Contract activation | ||
89 | RECNTLAW | SMIETR | SMIETR | CHAR | 5 | 0 | Tenancy law | TIV03 | |
90 | RECNTXTOLD | VVOSMIVE | VVOSMIVE | CHAR | 20 | 0 | Number of old contract | ||
91 | RECNBUKRSCOLLECT | RECNBUKRSCOLLECT | BUKRS | CHAR | 4 | 0 | Company code of main contract | T001 | |
92 | RECNNRCOLLECT | RECNNUMBERCOLLECT | RECNNUMBER | CHAR | 13 | 0 | Number of Real Estate Main Contract | ||
93 | RECNCNCURR | RECNWAERS_CN | WAERS | CUKY | 5 | 0 | Currency for Contract | TCURC | |
94 | INDUSTRY | BU_IND_SECTOR | BU_INDSECTOR | CHAR | 10 | 0 | Industry | * | |
95 | SRRELEVANT | RECNSALESRENTRELEVANT | RECABOOL | CHAR | 1 | 0 | Relevant to Sales | ||
96 | DPTARGETTYPE | RECNDPTYPE | RECNDPTYPE | CHAR | 4 | 0 | Security Deposit Type | TIVCNDPTYPE | |
97 | RECNDAT | RECNDAT | DDAT | DATS | 8 | 0 | Date of Contract Conclusion | ||
98 | RECN2DAT | RECN2DAT | RECADATE | DATS | 8 | 0 | Date of Second Signature | ||
99 | RECNDPO | RECDCFSTARTFROM | RECADATE | DATS | 8 | 0 | Cash Flow Generated Starting On | ||
100 | RECNEND1ST | RECNCNEND1ST | RECADATE | DATS | 8 | 0 | Date of First Contract End | ||
101 | RECNNOTPER | RECNNTPER | RECADATE | DATS | 8 | 0 | Contract Notice Per | ||
102 | RECNNOTRECEIPT | RECNNTRECEIPT | RECADATE | DATS | 8 | 0 | Date of receipt of notice | ||
103 | RECNNOTREASON | RECNNTREASON | RECNNTREASON | NUMC | 2 | 0 | Reason for Notice | TIVCNNTRE | |
104 | RECNDAKTKU | RECNNTACTIVATEDON | RECADATE | DATS | 8 | 0 | Notice: Date of Activation | ||
105 | CFARCHIVEDTO | RECDCFARCHIVEDTO | RECADATE | DATS | 8 | 0 | Date Up to Which the Cash Flow Is Archived | ||
106 | CFLOCKEDTO | RECDCFLOCKEDTO | RECADATE | DATS | 8 | 0 | Date Until Which the Cash Flow Is Locked | ||
107 | CFPOSTINGFROM | RECDCFPOSTINGFROM | RECADATE | DATS | 8 | 0 | First Posting From | ||
108 | BENOCN | RECNBENOCN | REBDBENO | CHAR | 8 | 0 | Business Entity That Belongs to Contract | * | |
109 | TRANSPOSSFROM | RECNTRANSPOSSFROM | RECADATEBEG | DATS | 8 | 0 | Transfer of Possession: Start Date | ||
110 | TRANSPOSSTO | RECNTRANSPOSSTO | RECADATEEND | DATS | 8 | 0 | Transfer of Possession: End Date | ||
111 | HASMULTIASSIGN | REBDHASMULTIASSIGN | RECABOOL | CHAR | 1 | 0 | Multiple Assignment of Object to Group Allowed | ||
112 | POSSDATEFROM | REBDPOSSDATEFROM | RECADATE | DATS | 8 | 0 | Date From Which the Object Is Made Available for Use | ||
113 | POSSDATETO | REBDPOSSDATETO | RECADATE | DATS | 8 | 0 | Date Up to Which the Object Is Used | ||
114 | .INCLUDE | 0 | 0 | ||||||
115 | .INCLU--AP | 0 | 0 | Country Specific Fields for Spain | |||||
116 | .INCLUDE | 0 | 0 | Country-Specific Fields for Spain - Contract | |||||
117 | SECDEPRELEVANT | REXCESCDREL | XFELD | CHAR | 1 | 0 | Relevant to Security Deposit | ||
118 | NOTADJSDCN | REXCESCDNOTADJ | RECABOOL | CHAR | 1 | 0 | No Data Update in Security Deposit Contract | ||
119 | .INCLUDE | 0 | 0 | Reporting Fields: Generic Part | |||||
120 | GEN_OBJTYPE | RECAOBJTYPE | J_OBART | CHAR | 2 | 0 | Object Type | * | |
121 | GEN_OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
122 | GEN_CONTRACT | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
123 | GEN_PARTNER1 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
124 | GEN_PARTNER2 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
125 | ALVROWS | REISALVROWS | INT2 | 5 | 0 | Number of Rows | |||
126 | .INCLUDE | 0 | 0 | Reporting Fields: Main Contractual Partner | |||||
127 | ROLE_BP1 | REBPROLE1 | BU_ROLE | CHAR | 6 | 0 | First Main Contractual Partner: Role | * | |
128 | XROLE_BP1 | REBPXROLE1 | RECAXMDESCRIPTION | CHAR | 30 | 0 | 1st Main Contractual Partner: Name of Role Category | ||
129 | PARTNER_BP1 | REBPPARTNER1 | BU_PARTNER | CHAR | 10 | 0 | First Main Contractual Partner | * | |
130 | XPARTNER_BP1 | REBPXPARTNER1 | TEXT80 | CHAR | 80 | 0 | Name/Address of 1st Business Partner | ||
131 | TEL_NUMBER_LONG_BP1 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
132 | FAX_NUMBER_LONG_BP1 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
133 | SMTP_ADDR_BP1 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
134 | XNAME_BP1 | REBPXNAME1 | BU_TEXT50 | CHAR | 50 | 0 | Short Description of 1st Business Partner | ||
135 | STREET_BP1 | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
136 | HOUSE_NUM1_BP1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
137 | POST_CODE1_BP1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
138 | CITY1_BP1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
139 | CITY2_BP1 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
140 | REGION_BP1 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
141 | PO_BOX_BP1 | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
142 | POST_CODE2_BP1 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
143 | ROLE_BP2 | REBPROLE2 | BU_ROLE | CHAR | 6 | 0 | Second Main Contractual Partner: Role | * | |
144 | XROLE_BP2 | REBPXROLE2 | RECAXMDESCRIPTION | CHAR | 30 | 0 | 2nd Main Contractual Partner: Name of Role Category | ||
145 | PARTNER_BP2 | REBPPARTNER2 | BU_PARTNER | CHAR | 10 | 0 | Second Main Contractual Partner | * | |
146 | XPARTNER_BP2 | REBPXPARTNER2 | TEXT80 | CHAR | 80 | 0 | Name/Address of 2nd Business Partner | ||
147 | TEL_NUMBER_LONG_BP2 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
148 | FAX_NUMBER_LONG_BP2 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
149 | SMTP_ADDR_BP2 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
150 | XNAME_BP2 | REBPXNAME2 | BU_TEXT50 | CHAR | 50 | 0 | Short Description of 2nd Business Partner | ||
151 | STREET_BP2 | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
152 | HOUSE_NUM1_BP2 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
153 | POST_CODE1_BP2 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
154 | CITY1_BP2 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
155 | CITY2_BP2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
156 | REGION_BP2 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
157 | PO_BOX_BP2 | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
158 | POST_CODE2_BP2 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
159 | DEBITAMOUNT | RERADEBITAMOUNT | RECACURR | CURR | 15 | 2 | Debit Amount | ||
160 | CREDITAMOUNT | RERACREDITAMOUNT | RECACURR | CURR | 15 | 2 | Credit Amount | ||
161 | .INCLUDE | 0 | 0 | Time Slot Valid in a Row in the Info System | |||||
162 | RECISVALIDFROM | REISRECVALIDFROM | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid From | ||
163 | RECISVALIDTO | REISRECVALIDTO | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid Until |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | REIS_AL_L | ACCRULE | TACC_PRINCIPLE | ACC_PRINCIPLE | KEY | ||
2 | REIS_AL_L | ACRTYPE | TACE_ACRTYPE | ACRTYPE | KEY | ||
3 | REIS_AL_L | DPTARGETTYPE | TIVCNDPTYPE | DPTYPE | REF | C | CN |
4 | REIS_AL_L | RECNBUKRSCOLLECT | T001 | BUKRS | REF | C | CN |
5 | REIS_AL_L | RECNCNCURR | TCURC | WAERS | REF | 1 | CN |
6 | REIS_AL_L | RECNNOTREASON | TIVCNNTRE | NTREASON | REF | C | CN |
7 | REIS_AL_L | RECNTLAW | TIV03 | SMIETR | REF | C | CN |
8 | REIS_AL_L | RECNTYPE | TIV26 | SMVART | KEY | 1 | CN |
9 | REIS_AL_L | RESPONSIBLE | USR02 | BNAME | REF | 1 | CN |
10 | REIS_AL_L | USEREXCLUSIVE | USR02 | BNAME | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |