SAP ABAP Table IFMREP3AX (Structure for Program RFFMEP3X)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ FI-FM-IS (Application Component) Information System
⤷ FMRP (Package) ISPS reporting
⤷ FI-FM-IS (Application Component) Information System
⤷ FMRP (Package) ISPS reporting
Basic Data
Table Category | INTTAB | Structure |
Structure | IFMREP3AX | Table Relationship Diagram |
Short Description | Structure for Program RFFMEP3X |
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 | FIKRS | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
2 | .INCLUDE | 0 | 0 | Master Data for Line Item Reports | |||||
3 | FNAME | FM_FNAME | TEXT20 | CHAR | 20 | 0 | Fund name | ||
4 | SPONSOR | FM_SPONSOR | KUNNR | CHAR | 10 | 0 | Customer account number for fund | * | |
5 | FINUSE | FM_FINUSE | FM_FINUSE | CHAR | 16 | 0 | Application of Secondary Source Funds | * | |
6 | FUND_TYPE | FM_FUNDTYPE | FM_FUNDTYPE | CHAR | 6 | 0 | FM Fund Type | * | |
7 | FUND_TYPET | FM_FUNDTYPET | FM_FUNDTYPET | CHAR | 35 | 0 | FM Fund Type Description | ||
8 | FDSTR_ID | FM_FDSTR_ID | CHAR10 | CHAR | 10 | 0 | Subdivision ID of the fund | ||
9 | FDSUB1 | FM_FDSUB1 | CHAR10 | CHAR | 10 | 0 | Substring 1 of Fund | ||
10 | FDSUB2 | FM_FDSUB2 | CHAR10 | CHAR | 10 | 0 | Substring 2 of Fund | ||
11 | .INCLUDE | 0 | 0 | Substructures of Funds - Text descriptions | |||||
12 | FDSUB1T_SH | FM_BESCHR1 | TEXT50 | CHAR | 50 | 0 | Description 1 | ||
13 | FDSUB1T_LO | FM_BESCHR2 | TEXT50 | CHAR | 50 | 0 | Description 2 | ||
14 | FDSUB2T_SH | FM_BESCHR1 | TEXT50 | CHAR | 50 | 0 | Description 1 | ||
15 | FDSUB2T_LO | FM_BESCHR2 | TEXT50 | CHAR | 50 | 0 | Description 2 | ||
16 | CNAME | FM_CNAME | TEXT20 | CHAR | 20 | 0 | Funds center name | ||
17 | BOSSID | FM_BOSSID | HROBJID_12 | CHAR | 12 | 0 | Funds Center Manager in Organization Model | ||
18 | FCSTR_ID | FM_FCSTR_ID | CHAR10 | CHAR | 10 | 0 | Subdivision ID of the funds center | ||
19 | FCSUB1 | FM_FCSUB1 | CHAR10 | CHAR | 10 | 0 | Substring 1 of Funds Center | ||
20 | FCSUB2 | FM_FCSUB2 | CHAR10 | CHAR | 10 | 0 | Substring 2 of Funds Center | ||
21 | FCSUB3 | FM_FCSUB3 | CHAR10 | CHAR | 10 | 0 | Substring 3 of Funds Center | ||
22 | .INCLUDE | 0 | 0 | Substructures of Fund Center - Text Descriptions | |||||
23 | FCSUB1T_SH | FM_FCSUB1T_SH | TEXT50 | CHAR | 50 | 0 | Description 1 of Substring 1 of Funds Center | ||
24 | FCSUB1T_LO | FM_FCSUB1T_LO | TEXT50 | CHAR | 50 | 0 | Description 2 of Substring 1 of Funds Center | ||
25 | FCSUB2T_SH | FM_FCSUB2T_SH | TEXT50 | CHAR | 50 | 0 | Description 1 of Substring 2 of Funds Center | ||
26 | FCSUB2T_LO | FM_FCSUB2T_LO | TEXT50 | CHAR | 50 | 0 | Description 2 of Substring 2 of Funds Center | ||
27 | FCSUB3T_SH | FM_FCSUB3T_SH | TEXT50 | CHAR | 50 | 0 | Description 1 of Substring 3 of Funds Center | ||
28 | FCSUB3T_LO | FM_FCSUB3T_LO | TEXT50 | CHAR | 50 | 0 | Description 2 of Substring 3 of Funds Center | ||
29 | PNAME | FM_PNAME | TEXT20 | CHAR | 20 | 0 | Commitment item name | ||
30 | POTYP | FM_POTYP | FM_POTYP | NUMC | 1 | 0 | Commitment Item Category | ||
31 | FIVOR | FM_FIVOR | FM_FIVOR | NUMC | 2 | 0 | Financial transaction | ||
32 | CISTR_ID | FM_CISTR_ID | CHAR10 | CHAR | 10 | 0 | Subdivision ID of the commitment item | ||
33 | CISUB1 | FM_CISUB1 | CHAR10 | CHAR | 10 | 0 | Substring 1 of Commitment Item | ||
34 | CISUB2 | FM_CISUB2 | CHAR10 | CHAR | 10 | 0 | Substring 2 of Commitment Item | ||
35 | CISUB3 | FM_CISUB3 | CHAR10 | CHAR | 10 | 0 | Substring 3 of Commitment Item | ||
36 | CISUB4 | FM_CISUB4 | CHAR10 | CHAR | 10 | 0 | Substring 4 of Commitment Item | ||
37 | CISUB5 | FM_CISUB5 | CHAR10 | CHAR | 10 | 0 | Substring 5 of Commitment Item | ||
38 | .INCLUDE | 0 | 0 | Subtructures of Commitment Item - Text descriptions | |||||
39 | CISUB1T_SH | FM_CISUB1T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 1 of Commitment Item | ||
40 | CISUB1T_LO | FM_CISUB1T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 1 of Commitment Item | ||
41 | CISUB2T_SH | FM_CISUB2T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 2 of Commitment Item | ||
42 | CISUB2T_LO | FM_CISUB2T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 2 of Commitment Item | ||
43 | CISUB3T_SH | FM_CISUB3T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 3 of Commitment Item | ||
44 | CISUB3T_LO | FM_CISUB3T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 3 of Commitment Item | ||
45 | CISUB4T_SH | FM_CISUB4T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 4 of Commitment Item | ||
46 | CISUB4T_LO | FM_CISUB4T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 4 of Commitment Item | ||
47 | CISUB5T_SH | FM_CISUB5T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 5 of Commitment Item | ||
48 | CISUB5T_LO | FM_CISUB5T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 5 of Commitment Item | ||
49 | FNSTR_ID | FM_FNSTR_ID | CHAR10 | CHAR | 10 | 0 | Subdivision ID of functional area | ||
50 | FNSUB1 | FM_FNSUB1 | CHAR10 | CHAR | 10 | 0 | Substring 1 of Functional Area | ||
51 | FNSUB2 | FM_FNSUB2 | CHAR10 | CHAR | 10 | 0 | Substring 2 of Functional Area | ||
52 | FNSUB3 | FM_FNSUB3 | CHAR10 | CHAR | 10 | 0 | Substring 3 of Functional Area | ||
53 | .INCLUDE | 0 | 0 | Substructures of Function - Text Descriptions | |||||
54 | FNSUB1T_SH | FM_FNSUB1T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 1 of Functional Area | ||
55 | FNSUB1T_LO | FM_FNSUB1T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 1 of Functional Area | ||
56 | FNSUB2T_SH | FM_FNSUB2T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 2 of Functional Area | ||
57 | FNSUB2T_LO | FM_FNSUB2T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 2 of Functional Area | ||
58 | FNSUB3T_SH | FM_FNSUB3T_SH | CHAR50 | CHAR | 50 | 0 | Description 1 of Substring 3 of Functional Area | ||
59 | FNSUB3T_LO | FM_FNSUB3T_LO | CHAR50 | CHAR | 50 | 0 | Description 2 of Substring 3 of Functional Area | ||
60 | .INCLUDE | 0 | 0 | ||||||
61 | .INCLUDE | 0 | 0 | ||||||
62 | .INCLUDE | 0 | 0 | ||||||
63 | .INCLUDE | 0 | 0 | Line Items - Extended | |||||
64 | .INCLUDE | 0 | 0 | FM Account Assignment Without Master Data | |||||
65 | FONDS | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | FMFINCODE | |
66 | FICTR | FM_FICTR | FISTL | CHAR | 16 | 0 | Funds Center | FMFCTR | |
67 | FIPEX | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | FMCI | |
68 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | * | |
69 | GRANT_NBR | GM_GRANT_NBR | GM_GRANT_NBR | CHAR | 20 | 0 | Grant | ||
70 | .INCLUDE | 0 | 0 | Line Items | |||||
71 | REFBN | CO_REFBN | BELNR | CHAR | 10 | 0 | Reference Document Number | ||
72 | RFPOS | CC_RFPOS | NUMC05 | NUMC | 5 | 0 | Item number of reference document | ||
73 | REFBT | CO_REFBTYP | BELEGTYP | NUMC | 3 | 0 | Reference document category (conversion exit; c.f. REFBTYP) | ||
74 | RFORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
75 | RFSYS | AWSYS | LOGSYS | CHAR | 10 | 0 | Logical system of source document | TBDLS | |
76 | RFTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | * | |
77 | RFKNT | CC_RFKNT | NUMC05 | NUMC | 5 | 0 | Account assignment number of reference document | ||
78 | RFETE | CC_RFETE | ETENR | NUMC | 4 | 0 | Reference document classification number | * | |
79 | RCOND | RCOND | RCOND | NUMC | 5 | 0 | Counter Conditions and Level Number | ||
80 | WRTTP | CO_WRTTP | CO_WRTTP | CHAR | 2 | 0 | Value Type | ||
81 | WTEXT | FM_WRTTPT | TEXT40 | CHAR | 40 | 0 | Val.type name | ||
82 | BTART | FM_BTART | FM_BTART | CHAR | 4 | 0 | Amount type | ||
83 | BTEXT | FM_BTARTT | TEXT40 | CHAR | 40 | 0 | Name of amount type | ||
84 | STATS | FM_STATS | FM_STATS | CHAR | 1 | 0 | Funds Management Statistical Indicator | ||
85 | STATT | FM_STATST | TEXT40 | CHAR | 40 | 0 | Name of statistics indicator | ||
86 | RRCTY | RRCTY | RRCTY | CHAR | 1 | 0 | Record Type | ||
87 | ERLKZ | KBLERLKZ | CHAR1_X | CHAR | 1 | 0 | Completion indicator for line item | ||
88 | LOEKZ | KBLLOEKZ | CHAR1_X | CHAR | 1 | 0 | Deletion Indicator | ||
89 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
90 | GNJHR | GNJHR | GJAHR | NUMC | 4 | 0 | Year of Cash Effectivity | ||
91 | PERIO | FM_PERIODE | PERDE | NUMC | 3 | 0 | Period | ||
92 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
93 | ZHLDT | FM_ZHLDT | DATUM | DATS | 8 | 0 | Funds Management - Update Date | ||
94 | TRANR | FM_TRANR | CHAR16 | CHAR | 16 | 0 | Funds Management Transaction Number | ||
95 | CTRNR | FM_CTRNR | CHAR20 | CHAR | 20 | 0 | Funds Management Control Number | ||
96 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
97 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | SKA1 | |
98 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
99 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
100 | FAREA | FM_FAREA | FKBER | CHAR | 16 | 0 | Functional Area | TFKB | |
101 | FTEXT | FKBTX | TEXT25 | CHAR | 25 | 0 | Name of the functional area | ||
102 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
103 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
104 | KTEXT | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
105 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
106 | ATEXT | AUFTEXT | TEXT40 | CHAR | 40 | 0 | Description | ||
107 | POSID | PS_POSID | PS_POSID | CHAR | 24 | 0 | Work Breakdown Structure Element (WBS Element) | ||
108 | POST1 | PS_POST1 | TEXT40 | CHAR | 40 | 0 | PS: Short description (first text line) | ||
109 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | CEPC | |
110 | PRCTRT | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
111 | NPLNR | NPLNR | AUFNR | CHAR | 12 | 0 | Network Number for Account Assignment | * | |
112 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
113 | CF_FLAG | FM_CF_FLAG | XFELD | CHAR | 1 | 0 | Carryforwards at year-end closing | ||
114 | CFSTAT | FM_CFST | FM_CFST | NUMC | 2 | 0 | FM Commitment Carryforward: Status | ||
115 | CFSTATSV | FM_CFSTSV | FM_CFST | NUMC | 2 | 0 | Year-End Closing: Status (Back Up) | ||
116 | CFCNT | FM_CFCNT | FM_CFCNT | NUMC | 2 | 0 | Year-End Closing: Number of Transfers | ||
117 | CFLEV | FM_CFLEV | FM_CFLEV | CHAR | 1 | 0 | Carryforward level | ||
118 | USERDIM | FM_USERDIM | CHAR10 | CHAR | 10 | 0 | Customer Field for FM Actual and Commitment Data | ||
119 | FWAER | FMWAER | WAERS | CUKY | 5 | 0 | FM area currency | TCURC | |
120 | FKBTRP | FM_FKBTRPY | WERTV8 | CURR | 15 | 2 | Amount to be checked against payment budget, in FM area crcy | ||
121 | FKBTRC | FM_FKBTRCM | WERTV8 | CURR | 15 | 2 | Amount to be checked against commt budget, in FM area crcy | ||
122 | FKBTRW | FM_FKBTRWF | WERTV8 | CURR | 15 | 2 | Amount processed in Workflows, expressed in FM area crcy | ||
123 | TWAER | TWAER | WAERS | CUKY | 5 | 0 | Transaction Currency | TCURC | |
124 | TRBTRP | FM_TRBTRPY | WERTV8 | CURR | 15 | 2 | Amount to be checked against the paymt budget, in trans crcy | ||
125 | TRBTRC | FM_TRBTRCM | WERTV8 | CURR | 15 | 2 | Amount to be checked against commt budget, in trans.crcy | ||
126 | TRBTRW | FM_TRBTRWF | WERTV8 | CURR | 15 | 2 | Amount processed in workflow, in transaciton currency | ||
127 | VREFBT | FM_VREFBT | FM_REFBTYP | NUMC | 3 | 0 | Predecessor document category | ||
128 | VRFPOS | FM_VRFPOS | NUMC05 | NUMC | 5 | 0 | Predecessor document item | ||
129 | VREFBN | FM_VREFBN | BELNR | CHAR | 10 | 0 | Predecessor document number | ||
130 | STUNR | FM_STUNR | CHAR16 | CHAR | 16 | 0 | Number that clearly identifies the line key in database | ||
131 | PERIO7 | JAHRPER | JAHRPER | NUMC | 7 | 0 | Period/year | ||
132 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
133 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
134 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
135 | TCODE | TCODE | TCODE | CHAR | 20 | 0 | Transaction Code | * | |
136 | BLDOCDATE | FM_BL_DOCDATE | DATUM | DATS | 8 | 0 | Budgetary Ledger Document Date | ||
137 | .INCLUDE | 0 | 0 | ||||||
138 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
139 | VRGNG | CO_VORGANG | J_VORGANG | CHAR | 4 | 0 | CO Business Transaction | * | |
140 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
141 | LOTKZ | LOTKZ | LOTKZ | CHAR | 10 | 0 | Lot Number for Documents | ||
142 | PSOTY | PSOTY_D | PSOTY | CHAR | 2 | 0 | Document category payment requests | PSOTP | |
143 | PSOAK | PSOAK | PSOAK | CHAR | 10 | 0 | Reason | PSO12 | |
144 | PSOKS | PSOKS | PSOKS | CHAR | 10 | 0 | Region | PSO14 | |
145 | PSOSG | PSOSG | PSOSG | CHAR | 1 | 0 | Reason for reversal - IS-PS requests | ||
146 | PSOFN | PSOFN | CHAR30 | CHAR | 30 | 0 | IS-PS: File number | ||
147 | DBBLG | DBBLG | BELNR | CHAR | 10 | 0 | Recurring Entry Document Number | ||
148 | VOGJAHR | FM_VOGJAHR | GJAHR | NUMC | 4 | 0 | Fiscal year for payment document number | ||
149 | VOBELNR | FM_VOBELNR | BELNR | CHAR | 10 | 0 | Payment Document Number | ||
150 | VOBUZEI | FM_VOBUZEI | BUZEI | NUMC | 3 | 0 | Item for payment document number | ||
151 | KNGJAHR | FM_KNGJAHR | GJAHR | NUMC | 4 | 0 | Fiscal year for FI document number | ||
152 | FMBELNR | FM_BELNR | BELNR | CHAR | 10 | 0 | Document Number of FM Line Item | ||
153 | FMBUZEI | FM_BUZEI | NUMC03 | NUMC | 3 | 0 | Number of a posting line in a TR-FM line item | ||
154 | SORTLK | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
155 | SORTLL | SORTL | CHAR10 | CHAR | 10 | 0 | Sort field | ||
156 | VTEXT | FM_VRGNGT | TEXT30 | CHAR | 30 | 0 | Name of CO transaction | ||
157 | BLART | BLART | BLART | CHAR | 2 | 0 | Document type | * | |
158 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
159 | PSOBT | PSOBT | DATUM | DATS | 8 | 0 | Posting Day | ||
160 | SKNTO | SKNTO | WERT7 | CURR | 13 | 2 | Cash discount amount in local currency | ||
161 | RDIFF | RDIFF | WRTV7 | CURR | 13 | 2 | Exchange Rate Gain/Loss Realized | ||
162 | XREVS | STNKZ | CHAR1 | CHAR | 1 | 0 | Cancelation flag | ||
163 | AWREF | FM_AWREF | AWREF | CHAR | 10 | 0 | RW document number | ||
164 | VRFKNT | FM_VRFKNT | NUM05 | NUMC | 5 | 0 | Predecessor account assignment | ||
165 | ME_SHORT_DESC | FM_ME_NAME | TEXT20 | CHAR | 20 | 0 | Name of Funded Program (20-character) | ||
166 | ME_DESCRIPTION | FM_ME_DESC | TEXT50 | CHAR | 50 | 0 | Description of Funded Program (50 character) | ||
167 | GRANT_TYPE | GM_GRANT_TYPE | GM_GRANT_TYPE | CHAR | 2 | 0 | Grant Type | * | |
168 | GM_SHORT_DESC | FM_GM_NAME | TEXT20 | CHAR | 20 | 0 | Name of Grant | ||
169 | GM_DESCRIPTION | FM_GM_DESC | TEXT80 | CHAR | 80 | 0 | Grant Description |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | IFMREP3AX | AUFNR | AUFK | AUFNR | |||
2 | IFMREP3AX | BUKRS | T001 | BUKRS | |||
3 | IFMREP3AX | FAREA | TFKB | FKBER | |||
4 | IFMREP3AX | FICTR | FMFCTR | FICTR | |||
5 | IFMREP3AX | FIPEX | FMCI | GJAHR | |||
6 | IFMREP3AX | FONDS | FMFINCODE | FINCODE | |||
7 | IFMREP3AX | FWAER | TCURC | WAERS | |||
8 | IFMREP3AX | HKONT | SKA1 | SAKNR | |||
9 | IFMREP3AX | KOKRS | TKA01 | KOKRS | |||
10 | IFMREP3AX | KOSTL | CSKS | KOSTL | |||
11 | IFMREP3AX | LIFNR | LFA1 | LIFNR | |||
12 | IFMREP3AX | PRCTR | CEPC | PRCTR | |||
13 | IFMREP3AX | PSOAK | PSO12 | PSOAK | |||
14 | IFMREP3AX | PSOKS | PSO14 | PSOKS | |||
15 | IFMREP3AX | PSOTY | PSOTP | PSOTYP | |||
16 | IFMREP3AX | RFSYS | TBDLS | LOGSYS | |||
17 | IFMREP3AX | TWAER | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462 |