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

Foreign Keys

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

History

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