SAP ABAP Table REIS_ACR_ITEM_L (Reporting: Accrual/Deferral Records)
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_ACR_ITEM_L | Table Relationship Diagram |
Short Description | Reporting: Accrual/Deferral Records |
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 | AMOUNT_INV | RERAACRAMOUNTINV | CURR | 15 | 2 | Amount Currently Posted (Inverse +/- Sign) | |||
32 | BELNR | CO_BELNR | CO_BELNR | CHAR | 10 | 0 | Document Number | * | |
33 | PROCESSID | RECAPROCESSID | RECAPROCESSID | CHAR | 16 | 0 | Process Identification -> Accounting Reference Number | ||
34 | ACRVALIDFROM | RERAACRVALIDFROM | DATS | 8 | 0 | Start of Life of an Accrual Subobject | |||
35 | ACRVALIDTO | RERAACRVALIDTO | DATS | 8 | 0 | End of Life of an Accrual Subobject | |||
36 | RECNNR | RECNNR | RECNNR | CHAR | 13 | 0 | Real Estate Contract Number | ||
37 | .INCLUDE | 0 | 0 | RE Contract: Non-Key Fields | |||||
38 | OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
39 | IMKEY | RECAIMKEY | IMKEY | CHAR | 8 | 0 | Internal Key of Real Estate Object (FI) | ||
40 | CREATIONTYPE | RECACREATIONTYPE | RECACREATIONTYPE | CHAR | 1 | 0 | How the Object Was Created | ||
41 | .INCLUDE | 0 | 0 | Field String for Maintenance of User Data | |||||
42 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
43 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
44 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
45 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
46 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
47 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
48 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
49 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
50 | RESPONSIBLE | RECARESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | USR02 | |
51 | USEREXCLUSIVE | RECAUSEREXCLUSIVE | XUBNAME | CHAR | 12 | 0 | User with Exclusive Change Authorization | USR02 | |
52 | AUTHGRP | RECAAUTHGRP | RECAAUTHGRP | CHAR | 40 | 0 | Authorization Group | ||
53 | RECNTYPE | RECNCONTRACTTYPE | SMVART | CHAR | 4 | 0 | Contract Type | TIV26 | |
54 | RECNBEG | RECNCNBEG | RECADATE | DATS | 8 | 0 | Date of contract start | ||
55 | RECNENDABS | RECNCNENDABS | RECADATEEND | DATS | 8 | 0 | Term End Date | ||
56 | RECNTXT | RECNTXT | XTEXT80 | CHAR | 80 | 0 | Contract name | ||
57 | RECNDACTIV | DAKTV | DATUM | DATS | 8 | 0 | Contract activation | ||
58 | RECNTLAW | SMIETR | SMIETR | CHAR | 5 | 0 | Tenancy law | TIV03 | |
59 | RECNTXTOLD | VVOSMIVE | VVOSMIVE | CHAR | 20 | 0 | Number of old contract | ||
60 | RECNBUKRSCOLLECT | RECNBUKRSCOLLECT | BUKRS | CHAR | 4 | 0 | Company code of main contract | T001 | |
61 | RECNNRCOLLECT | RECNNUMBERCOLLECT | RECNNUMBER | CHAR | 13 | 0 | Number of Real Estate Main Contract | ||
62 | RECNCNCURR | RECNWAERS_CN | WAERS | CUKY | 5 | 0 | Currency for Contract | TCURC | |
63 | INDUSTRY | BU_IND_SECTOR | BU_INDSECTOR | CHAR | 10 | 0 | Industry | * | |
64 | SRRELEVANT | RECNSALESRENTRELEVANT | RECABOOL | CHAR | 1 | 0 | Relevant to Sales | ||
65 | DPTARGETTYPE | RECNDPTYPE | RECNDPTYPE | CHAR | 4 | 0 | Security Deposit Type | TIVCNDPTYPE | |
66 | RECNDAT | RECNDAT | DDAT | DATS | 8 | 0 | Date of Contract Conclusion | ||
67 | RECN2DAT | RECN2DAT | RECADATE | DATS | 8 | 0 | Date of Second Signature | ||
68 | RECNDPO | RECDCFSTARTFROM | RECADATE | DATS | 8 | 0 | Cash Flow Generated Starting On | ||
69 | RECNEND1ST | RECNCNEND1ST | RECADATE | DATS | 8 | 0 | Date of First Contract End | ||
70 | RECNNOTPER | RECNNTPER | RECADATE | DATS | 8 | 0 | Contract Notice Per | ||
71 | RECNNOTRECEIPT | RECNNTRECEIPT | RECADATE | DATS | 8 | 0 | Date of receipt of notice | ||
72 | RECNNOTREASON | RECNNTREASON | RECNNTREASON | NUMC | 2 | 0 | Reason for Notice | TIVCNNTRE | |
73 | RECNDAKTKU | RECNNTACTIVATEDON | RECADATE | DATS | 8 | 0 | Notice: Date of Activation | ||
74 | CFARCHIVEDTO | RECDCFARCHIVEDTO | RECADATE | DATS | 8 | 0 | Date Up to Which the Cash Flow Is Archived | ||
75 | CFLOCKEDTO | RECDCFLOCKEDTO | RECADATE | DATS | 8 | 0 | Date Until Which the Cash Flow Is Locked | ||
76 | CFPOSTINGFROM | RECDCFPOSTINGFROM | RECADATE | DATS | 8 | 0 | First Posting From | ||
77 | BENOCN | RECNBENOCN | REBDBENO | CHAR | 8 | 0 | Business Entity That Belongs to Contract | * | |
78 | TRANSPOSSFROM | RECNTRANSPOSSFROM | RECADATEBEG | DATS | 8 | 0 | Transfer of Possession: Start Date | ||
79 | TRANSPOSSTO | RECNTRANSPOSSTO | RECADATEEND | DATS | 8 | 0 | Transfer of Possession: End Date | ||
80 | HASMULTIASSIGN | REBDHASMULTIASSIGN | RECABOOL | CHAR | 1 | 0 | Multiple Assignment of Object to Group Allowed | ||
81 | POSSDATEFROM | REBDPOSSDATEFROM | RECADATE | DATS | 8 | 0 | Date From Which the Object Is Made Available for Use | ||
82 | POSSDATETO | REBDPOSSDATETO | RECADATE | DATS | 8 | 0 | Date Up to Which the Object Is Used | ||
83 | .INCLUDE | 0 | 0 | ||||||
84 | .INCLU--AP | 0 | 0 | Country Specific Fields for Spain | |||||
85 | .INCLUDE | 0 | 0 | Country-Specific Fields for Spain - Contract | |||||
86 | SECDEPRELEVANT | REXCESCDREL | XFELD | CHAR | 1 | 0 | Relevant to Security Deposit | ||
87 | NOTADJSDCN | REXCESCDNOTADJ | RECABOOL | CHAR | 1 | 0 | No Data Update in Security Deposit Contract | ||
88 | ACROBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
89 | ACROBJ | RERAACROBJ | CHAR50 | CHAR | 50 | 0 | Accrual Object ID | ||
90 | ASSIGNOBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
91 | ASSIGNOBJ | RERAASSIGNOBJ | CHAR50 | CHAR | 50 | 0 | Accrual Subobject ID | ||
92 | ACROBJGUID | RERAACROBJGUID | RECAGUID | RAW | 16 | 0 | GUID: Unique Key for External Accrual Object | ||
93 | REFGUID | RERAREFGUID | RECAGUID | RAW | 16 | 0 | Reference GUID | ||
94 | REFGUIDORIGIN | RERAGUIDORIGIN | CHAR04 | CHAR | 4 | 0 | Source of GUID | ||
95 | .INCLUDE | 0 | 0 | Reporting Fields: Generic Part | |||||
96 | GEN_OBJTYPE | RECAOBJTYPE | J_OBART | CHAR | 2 | 0 | Object Type | * | |
97 | GEN_OBJNR | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
98 | GEN_CONTRACT | RECAOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number | * | |
99 | GEN_PARTNER1 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
100 | GEN_PARTNER2 | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
101 | ALVROWS | REISALVROWS | INT2 | 5 | 0 | Number of Rows | |||
102 | .INCLUDE | 0 | 0 | Reporting Fields: Main Contractual Partner | |||||
103 | ROLE_BP1 | REBPROLE1 | BU_ROLE | CHAR | 6 | 0 | First Main Contractual Partner: Role | * | |
104 | XROLE_BP1 | REBPXROLE1 | RECAXMDESCRIPTION | CHAR | 30 | 0 | 1st Main Contractual Partner: Name of Role Category | ||
105 | PARTNER_BP1 | REBPPARTNER1 | BU_PARTNER | CHAR | 10 | 0 | First Main Contractual Partner | * | |
106 | XPARTNER_BP1 | REBPXPARTNER1 | TEXT80 | CHAR | 80 | 0 | Name/Address of 1st Business Partner | ||
107 | TEL_NUMBER_LONG_BP1 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
108 | FAX_NUMBER_LONG_BP1 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
109 | SMTP_ADDR_BP1 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
110 | XNAME_BP1 | REBPXNAME1 | BU_TEXT50 | CHAR | 50 | 0 | Short Description of 1st Business Partner | ||
111 | STREET_BP1 | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
112 | HOUSE_NUM1_BP1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
113 | POST_CODE1_BP1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
114 | CITY1_BP1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
115 | CITY2_BP1 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
116 | REGION_BP1 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
117 | PO_BOX_BP1 | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
118 | POST_CODE2_BP1 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
119 | ROLE_BP2 | REBPROLE2 | BU_ROLE | CHAR | 6 | 0 | Second Main Contractual Partner: Role | * | |
120 | XROLE_BP2 | REBPXROLE2 | RECAXMDESCRIPTION | CHAR | 30 | 0 | 2nd Main Contractual Partner: Name of Role Category | ||
121 | PARTNER_BP2 | REBPPARTNER2 | BU_PARTNER | CHAR | 10 | 0 | Second Main Contractual Partner | * | |
122 | XPARTNER_BP2 | REBPXPARTNER2 | TEXT80 | CHAR | 80 | 0 | Name/Address of 2nd Business Partner | ||
123 | TEL_NUMBER_LONG_BP2 | AD_TELNRLG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
124 | FAX_NUMBER_LONG_BP2 | AD_FXNRLNG | CHAR30 | CHAR | 30 | 0 | Complete number: dialling code+number+extension | ||
125 | SMTP_ADDR_BP2 | AD_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | E-Mail Address | ||
126 | XNAME_BP2 | REBPXNAME2 | BU_TEXT50 | CHAR | 50 | 0 | Short Description of 2nd Business Partner | ||
127 | STREET_BP2 | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
128 | HOUSE_NUM1_BP2 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
129 | POST_CODE1_BP2 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
130 | CITY1_BP2 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
131 | CITY2_BP2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
132 | REGION_BP2 | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
133 | PO_BOX_BP2 | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
134 | POST_CODE2_BP2 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
135 | .INCLUDE | 0 | 0 | Time Slot Valid in a Row in the Info System | |||||
136 | RECISVALIDFROM | REISRECVALIDFROM | RECADATE | DATS | 8 | 0 | Displayed Row Is Valid From | ||
137 | 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_ACR_ITEM_L | ACCRULE | TACC_PRINCIPLE | ACC_PRINCIPLE | KEY | ||
2 | REIS_ACR_ITEM_L | ACRTYPE | TACE_ACRTYPE | ACRTYPE | KEY | ||
3 | REIS_ACR_ITEM_L | DPTARGETTYPE | TIVCNDPTYPE | DPTYPE | REF | C | CN |
4 | REIS_ACR_ITEM_L | RECNBUKRSCOLLECT | T001 | BUKRS | REF | C | CN |
5 | REIS_ACR_ITEM_L | RECNCNCURR | TCURC | WAERS | REF | 1 | CN |
6 | REIS_ACR_ITEM_L | RECNNOTREASON | TIVCNNTRE | NTREASON | REF | C | CN |
7 | REIS_ACR_ITEM_L | RECNTLAW | TIV03 | SMIETR | REF | C | CN |
8 | REIS_ACR_ITEM_L | RECNTYPE | TIV26 | SMVART | KEY | 1 | CN |
9 | REIS_ACR_ITEM_L | RESPONSIBLE | USR02 | BNAME | REF | 1 | CN |
10 | REIS_ACR_ITEM_L | USEREXCLUSIVE | USR02 | BNAME | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 606 |