SAP ABAP Table RERA_DOC_ITEM_EX (RE Document Item Transfer to External System)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-RA (Application Component) Rental Accounting
     ⤷ RE_RA_CA (Package) RE: Cross Application Rental Accounting

Basic Data

Table Category	INTTAB	Structure
Structure	RERA_DOC_ITEM_EX	Table Relationship Diagram
Short Description	RE Document Item Transfer to External System

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	RE Document Item
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	.INCLUDE	☐				0	0	Key Fields of RE Line Items
4	.INCLUDE	☐				0	0	Key Fields of RE Document Header
5	DOCGUID	☐	RERADOCGUID	RECAGUID	RAW	16	0	GUID: Unique Internal Key for RE Document	VIRADOC
6	ITEMNO	☐	POSNR_ACC	POSNR_ACC	NUMC	10	0	Accounting Document Line Item Number
7	.INCLUDE	☐				0	0	Contents of RE Line Items
8	REFITEMNO	☐	RERAREFITEMNO	POSNR_ACC	NUMC	10	0	Reference to Other Item Number of Document
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
10	ITEMTYPE	☐	RERAITEMTYPE	CHAR02	CHAR	2	0	Item Category
11	REFDATE	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
12	PROCESS	☐	RECAPROCESS	RECAPROCESS	CHAR	4	0	Process	*
13	PROCESSGUID	☐	RECAPROCESSGUID	RECAGUID	RAW	16	0	Generic Key of Process
14	.INCLUDE	☐				0	0	RE Document Item Status Fields
15	CLEARINGSTATUS	☐	RERACLEARINGSTATUS	CHAR02	CHAR	2	0	Clearing status
16	CLEARNGPROCESSID	☐	RECAPROCESSID	RECAPROCESSID	CHAR	16	0	Process Identification -> Accounting Reference Number
17	PAYEDSTATUS	☐	RERAPAYEDSTATUS	CHAR02	CHAR	2	0	Payment Status
18	DUNNINGSTATUS	☐	RERADUNNINGSTATUS	CHAR02	CHAR	2	0	Dunning Status
19	.INCLUDE	☐				0	0	RE Posting Rules
20	REFGUIDORIGIN	☐	RERAGUIDORIGIN	CHAR04	CHAR	4	0	Source of GUID
21	REFGUID	☐	RERAREFGUID	RECAGUID	RAW	16	0	Reference GUID
22	OBJNR	☐	RERAOBJNR	J_OBJNR	CHAR	22	0	Account Assignment: Object Number	*
23	PFROM	☐	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
24	PTO	☐	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
25	BLINEDATE	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
26	ORIGDUEDATE	☐	RECDORIGDUEDATE	DATUM	DATS	8	0	Original Due Date
27	CONDTYPE	☐	RECDCONDTYPE	RECDCONDTYPE	CHAR	4	0	Condition Type	TIVCDCONDTYPE
28	ISADVANCEPAYMENT	☐	RECDADVANCEPAYMENT	RECABOOL	CHAR	1	0	Condition Is Advance Payment Condition
29	FLOWTYPE	☐	RECDFLOWTYPE	RECDFLOWTYPE	CHAR	4	0	Flow Type	TIVCDFLOWTYPE
30	DCINDICATOR	☐	RERADCINDICATOR	RERADCINDICATOR	CHAR	1	0	Debit/Credit Indicator
31	TAXGROUPID	☐	RERATAXGROUPID	NUM03	NUMC	3	0	Group Indicator for Tax Line Items
32	TAXDATE	☐	RERATAXDATE	RECADATE	DATS	8	0	Date of Tax Calculation
33	TERMNOOA	☐	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
34	.INCLUDE	☐				0	0	Table Fields for Term Organizational Assignment
35	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
36	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
37	ADDOBJNR	☐	RERAADDOBJNR	J_OBJNR	CHAR	22	0	Object Number for Additional Account Assignment	*
38	.INCLUDE	☐				0	0	Table Fields: Funds Management Account Assignments
39	.INCLUDE	☐				0	0	Account Assignment Fields - Funds Management
40	FUND	☐	RERAFUND	CHAR24	CHAR	24	0	Fund
41	FUNDSCENTER	☐	RERAFUNDSCENTER	CHAR24	CHAR	24	0	Funds Center
42	COMMITMENTITEM	☐	RERACOMMITMENTITEM	FM_FIPEX	CHAR	24	0	Commitment Item	*
43	FUNCTIONALAREA	☐	RERAFUNCTIONALAREA	CHAR24	CHAR	24	0	Functional Area
44	GRANTNUMBER	☐	RERAGRANTNUMBER	CHAR24	CHAR	24	0	Grant
45	MEASURE	☐	RERAMEASURE	CHAR24	CHAR	24	0	Program in Funds Management
46	BUDGETPERIOD	☐	RERABUDGETPERIOD	CHAR24	CHAR	24	0	FM: Budget Period
47	TERMNOPY	☐	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
48	CDSPLITNO	☐	RETMCDSPLITNO	NUMC4	NUMC	4	0	Number of Condition Split
49	.INCLUDE	☐				0	0	Table Fields for Posting Rule
50	PYMTMETH	☐	RERAPYMTMETH	CHAR4	CHAR	4	0	Payment Method
51	PYMTMETHCRMO	☐	RERAPYMTMETHCRMO	CHAR4	CHAR	4	0	Payment Method for Credit Memos
52	PYMTBLOCK	☐	RERAPYMTBLOCK	CHAR4	CHAR	4	0	Payment block key
53	PYMTTERM	☐	RERAPYMTTERM	ZTERM	CHAR	4	0	Terms of Payment Key
54	HOUSEBKID	☐	RERAHOUSEBKID	CHAR15	CHAR	15	0	Key for House Bank
55	HOUSEBKACC	☐	RERAHOUSEBKACC	CHAR15	CHAR	15	0	Key for House Bank Account
56	BANKDETAILID	☐	RERABANKDETAILID	CHAR15	CHAR	15	0	Bank Details ID
57	NOTETOPAYEE	☐	RERANOTETOPAYEE	RERANOTETOPAYEE	CHAR	25	0	Note to Payee
58	DUNNAREA	☐	RERADUNNAREA	CHAR4	CHAR	4	0	Dunning Area
59	DUNNKEY	☐	RERADUNNKEY	CHAR4	CHAR	4	0	Dunning Keys
60	DUNNBLOCK	☐	RERADUNNBLOCK	CHAR4	CHAR	4	0	Dunning Block
61	ACCDETKEY	☐	RERAACCDETKEY	RERAACCDETKEY	CHAR	10	0	Account Determination Value	*
62	TAXTYPE	☐	RERATAXTYPE	RERATAXTYPE	CHAR	4	0	Tax Type	TIVRATAXTYPE
63	TAXGROUP	☐	RERATAXGROUP	RERATAXGROUP	CHAR	20	0	Tax Group	TIVRATAXGROUP
64	ISGROSS	☐	RECDISGROSS	RECABOOL	CHAR	1	0	Condition Amount Is Gross Amount
65	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
66	PARTNEROBJNR	☐	RETMPARTNEROBJNR	J_OBJNR	CHAR	22	0	Object Number for Internal Use	*
67	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
68	ISCDSPLIT	☐	RETMISCDSPLIT	RECABOOL	CHAR	1	0	Condition Split
69	CTRULE	☐	RECACTRULE	RECACTRULE	CHAR	20	0	Currency Translation Rule	*
70	ISPARTNERBLOCKED	☐	RERAISPARTNERBLOCKED	RECABOOL	CHAR	1	0	Lock of Partner Data in Posting Term
71	SEPAMNDID	☐	RETMSEPAMNDID	RETMSEPAMNDID	CHAR	35	0	SEPA Mandate: Unique Reference to Mandate per Vendor
72	SEPARECCRDID	☐	RETMSEPARECCRDID	RETMSEPACRDID	CHAR	35	0	SEPA Mandate: Creditor ID
73	TERMNOWT	☐	RETMTERMNO	RETMTERMNO	CHAR	4	0	Term Number
74	.INCLUDE	☐				0	0	RE Posting Record Account
75	ACCTYPE	☐	RERAACCTYPE	RERAACCTYPE	CHAR	1	0	Account Type
76	GLACCSYMB	☐	RERAGLACCSYMB	RERAGLACCSYMB	CHAR	15	0	Account Determination: Account Symbols	*
77	GLACCOUNT	☐	RERAGLACCOUNT	RERAGLACCOUNT	CHAR	10	0	General Ledger Account
78	.INCLUDE	☐				0	0	RE Currency Structure
79	.INCLUDE	☐				0	0	RE Currency Structure
80	AMOUNT	☐	RERAAMOUNT	RECACURR	CURR	15	2	Amount in Transaction Currency
81	GROSSAMOUNT	☐	RERAGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Transaction Currency
82	NETAMOUNT	☐	RERANETAMOUNT	RECACURR	CURR	15	2	Net Amount in Transaction Currency
83	TAXAMOUNT	☐	RERATAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Transaction Currency
84	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
85	CTLCAMOUNT	☐	RECACTLCAMOUNT	RECACURR	CURR	15	2	Amount in Local Currency
86	CTLCGROSSAMOUNT	☐	RECACTLCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Local Currency
87	CTLCNETAMOUNT	☐	RECACTLCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Local Currency
88	CTLCTAXAMOUNT	☐	RECACTLCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Local Currency
89	CTLCCURRKEY	☐	RECACTLCCURRKEY	WAERS	CUKY	5	0	Local Currency	*
90	CTFCAMOUNT	☐	RECACTFCAMOUNT	RECACURR	CURR	15	2	Amount in Foreign Currency
91	CTFCGROSSAMOUNT	☐	RECACTFCGROSSAMOUNT	RECACURR	CURR	15	2	Gross Amount in Foreign Currency
92	CTFCNETAMOUNT	☐	RECACTFCNETAMOUNT	RECACURR	CURR	15	2	Net Amount in Foreign Currency
93	CTFCTAXAMOUNT	☐	RECACTFCTAXAMOUNT	RECACURR	CURR	15	2	Tax Amount in Foreign Currency
94	CTFCCURRKEY	☐	RECACTFCCURRKEY	WAERS	CUKY	5	0	Foreign Currency	*
95	TAXRATE	☐	RERATAXRATE	PRZ43V	DEC	7	3	Tax Rate
96	EXTTAXCODE	☐	RERATAXCODE		CHAR	5	0	Tax Code of the Accounting System
97	EXTREF1	☐	RERAEXTREF1		CHAR	60	0	External Reference 1 (Line Item)
98	EXTREF2	☐	RERAEXTREF2		CHAR	60	0	External Reference 2 (Line Item)
99	EXTREF3	☐	RERAEXTREF3		CHAR	60	0	External Reference 3 (Line Item)
100	EXTREF4	☐	RERAEXTREF4		CHAR	60	0	External Reference 4 (Line Item)
101	ITEMTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
102	VENDOR	☐	RERAVENDORNO	RERAPARTNERNO	CHAR	10	0	Vendor number
103	CUSTOMER	☐	RERACUSTOMERNO	RERAPARTNERNO	CHAR	10	0	Customer Number
104	VALUEDATE	☐	RERAVALUEDATE	RECADATE	DATS	8	0	Value Date
105	ALLOCATIONNUMBER	☐	RERAALLOCATIONNUMBER		CHAR	18	0	Assignment Number
106	REIPREFGUID	☐	RERAREFGUID	RECAGUID	RAW	16	0	Reference GUID
107	ISFLATRATE	☐	RECDFLATRATE	RECABOOL	CHAR	1	0	Condition Is a Flat Rate Condition
108	HASMANUALTAX	☐	RERAHASMANUALTAX	RECABOOL	CHAR	1	0	Manual Entry of Tax?
109	TXJCD_DEEP	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
110	TXJLV	☐	TXJCD_LEVEL	CHAR1	CHAR	1	0	Tax jurisdiction code level
111	CTRATE	☐	RECACTRATE	KURSF	DEC	9	5	Exchange Rate
112	CTDATEREQ	☐	RECACTDATEREQ	DATS	DATS	8	0	Planned Translation Date
113	CTDATEACT	☐	RECACTDATEACT	DATS	DATS	8	0	Actual Translation Date
114	POSTCDCURR	☐	RECACTPOSTCDCURR	RECABOOL	CHAR	1	0	Post in Condition Currency
115	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
116	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
117	WBS_ELEMENT	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
118	COSTCENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
119	ORDERID	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
120	AMTRANSTYPE	☐	REITAMTRANSTYPE	BWASL	CHAR	3	0	Transaction Type of Asset Postings	*
121	PARTNER_PRCTR	☐	RERAPARTNERPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
122	PAROBJNR	☐	RERAPARTNEROBJNR	J_OBJNR	CHAR	22	0	Partner Object	*
123	CONDGUID	☐	RECDCONDGUID	RECAGUID	RAW	16	0	GUID (RAW16) for Conditions
124	OBJNRCALC	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
125	.INCLUDE	☐				0	0	Reference to Document in Funds Management
126	FMDOCNO	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
127	FMDOCITEMNO	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
128	FMDOCREVID	☐	RERAREVID	RERAREVID	CHAR	1	0	Indicator for Reversed Documents
129	GENDATA	☐			CHAR	60	0
130	MARKEDFORCLEARING	☐	RERAMARKEDFORCLEARING	RECABOOL	CHAR	1	0	Line Item Marked for Clearing
131	ZEROTAX	☐	RERAZEROTAX	RECABOOL	CHAR	1	0	Dummy Zero Tax Item
132	.INCLUDE	☐				0	0	Attributes for Input Tax Correction
133	TCOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
134	DATEOFSERVICE	☐	REITTCDATEOFSERVICE	RECADATE	DATS	8	0	Date of Service
135	HASDIFFOPTRATE	☐	REITHASDIFFOPTRATE	RECABOOL	CHAR	1	0	Has Differing Option Rate
136	DIFFOPTRATE	☐	REITDIFFOPTRATE	REITOPTRATE	DEC	9	6	Differing Option Rate for Distribution
137	NOTAXCORR	☐	REITNOTAXCORR	RECABOOL	CHAR	1	0	Do Not Consider Item in Input Tax Correction

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RERA_DOC_ITEM_EX	CONDTYPE	TIVCDCONDTYPE	CONDTYPE	KEY	1	CN
2	RERA_DOC_ITEM_EX	FLOWTYPE	TIVCDFLOWTYPE	FLOWTYPE	KEY	1	CN
3	RERA_DOC_ITEM_EX	TAXGROUP	TIVRATAXGROUP	TAXGROUP	REF	C	CN
4	RERA_DOC_ITEM_EX	TAXTYPE	TIVRATAXTYPE	TAXTYPE	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	110