SAP ABAP Table REEX_FM_ACCT_DERIVE_X (Derived FM Account Assignments with Addit. Fields)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-RA (Application Component) Rental Accounting
     ⤷ RE_EX_FM (Package) RE: FM (Interface to Funds Management)

Basic Data

Table Category	INTTAB	Structure
Structure	REEX_FM_ACCT_DERIVE_X	Table Relationship Diagram
Short Description	Derived FM Account Assignments with Addit. Fields

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

Foreign Keys

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

History

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