SAP ABAP Table RERA_PRE_DOC_ITEM_GEN (RE Document Item Generated Preliminary Step)

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_PRE_DOC_ITEM_GEN	Table Relationship Diagram
Short Description	RE Document Item Generated Preliminary Step

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

History

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