SAP ABAP Table FMUSFGA_IS (Information Systems view for Federal Ledger Item)
Hierarchy
☛
EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷ PSM-FG (Application Component) Functions for U.S. Federal Government
⤷ FMFG_RPT_E (Package) US Federal Government Reporting
⤷ PSM-FG (Application Component) Functions for U.S. Federal Government
⤷ FMFG_RPT_E (Package) US Federal Government Reporting
Basic Data
Table Category | INTTAB | Structure |
Structure | FMUSFGA_IS | Table Relationship Diagram |
Short Description | Information Systems view for Federal Ledger Item |
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 | Actual line item table for US Federal Government | |||||
2 | RCLNT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | GL_SIRID | GU_RECID | OBJNR | CHAR | 18 | 0 | Record number of the line item record | ||
4 | RLDNR | RLDNR | RLDNR | CHAR | 2 | 0 | Ledger | T881 | |
5 | RRCTY | RRCTY | RRCTY | CHAR | 1 | 0 | Record Type | ||
6 | RVERS | RVERS | RVERS | CHAR | 3 | 0 | Version | T894 | |
7 | RYEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
8 | RTCUR | RTCUR | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
9 | DRCRK | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
10 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
11 | DOCCT | DOCCT | DOCCT | CHAR | 1 | 0 | Document Type | ||
12 | DOCNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
13 | DOCLN | DOCLN6 | DOCLN6 | CHAR | 6 | 0 | Six-Character Posting Item for Ledger | ||
14 | RBUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
15 | RACCT | RACCT | SAKNR | CHAR | 10 | 0 | Account Number | * | |
16 | RBUSA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
17 | RPRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
18 | RCNTR | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
19 | RPROJK | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
20 | RFAREA | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | TFKB | |
21 | RFUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
22 | RFIPEX | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | * | |
23 | RFISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
24 | RORDNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
25 | RVBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
26 | RAGNCY_LCTN_CODE | FMFG_ALC | FMFG_ALC | CHAR | 8 | 0 | Agency Location Code | * | |
27 | RFINUSE | FM_FINUSE | FM_FINUSE | CHAR | 16 | 0 | Application of Secondary Source Funds | * | |
28 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
29 | FMFG_SUBKEY_9 | FMFG_SUBKEY | CHAR10 | CHAR | 10 | 0 | Subkey for FMUSFGT | ||
30 | BLSTATUS_9 | FMFG_BLSTATUS | FMFG_BLSTATUS | CHAR | 5 | 0 | Budgetary ledger status | ||
31 | TSL | VTCUR9 | WERTV9 | CURR | 17 | 2 | Value in Transaction Currency | ||
32 | HSL | VLCUR9 | WERTV9 | CURR | 17 | 2 | Value in local currency | ||
33 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
34 | DOCTY | DOCTY | DOCTY | CHAR | 2 | 0 | FI-SL Document Type | T889 | |
35 | ACTIV | GLVOR | CHAR4 | CHAR | 4 | 0 | Business Transaction | ||
36 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
37 | WSDAT | WSDAT | DATUM | DATS | 8 | 0 | Value Date for Currency Translation | ||
38 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
39 | REFDOCNR | REFBELNR | BELNR | CHAR | 10 | 0 | Reference document number of an accounting document | ||
40 | REFRYEAR | REFGJAHR | GJAHR | NUMC | 4 | 0 | Reference fiscal year | ||
41 | REFDOCLN | REFBUZEI6 | BUZEI6 | NUMC | 6 | 0 | Six-digit number of the reference posting line | ||
42 | REFDOCCT | REFDOCCT | DOCCT | CHAR | 1 | 0 | Reference document category | ||
43 | REFACTIV | REFGLVOR | CHAR4 | CHAR | 4 | 0 | FI-SL Business Reference Transaction | ||
44 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
45 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
46 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
47 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | TTYP | |
48 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
49 | PMT_OFFICE | FMFG_PMT_OFF | FMFG_PMT_OFF | CHAR | 5 | 0 | Payment Office | * | |
50 | COHORT | FM_COHORT | FM_COHORT | CHAR | 4 | 0 | Reporting Year for Cohort | ||
51 | PUBLAW | FM_PUBLAW | FM_PUBLAW | CHAR | 20 | 0 | Public Law Cited | ||
52 | LEGIS | FM_LEGIS | FM_LEGIS | CHAR | 1 | 0 | Type of Legislation | ||
53 | FLG_COVERED | FM_FLG_COVERED | FM_FLG_COVERED | CHAR | 1 | 0 | Covered Indicator | ||
54 | FLG_CUSTODIAL | FM_FLG_CUSTODIAL | FM_FLG_CUSTODIAL | CHAR | 1 | 0 | Custodial Indicator | ||
55 | FLG_ENTITY | FM_FLG_ENTITY | FM_FLG_ENTITY | CHAR | 1 | 0 | Entity Indicator | ||
56 | FLG_EXCHANGE | FM_FLG_EXCHANGE | FM_FLG_EXCHANGE | CHAR | 1 | 0 | Exchange Indicator | ||
57 | FLG_FEDERAL | FM_FLG_FEDERAL | FM_FLG_FEDERAL | CHAR | 1 | 0 | Federal Indicator | ||
58 | FLG_APPORT | FM_FLG_APPORT | FM_FLG_APPORT | CHAR | 1 | 0 | Apportionment Category | ||
59 | FLG_AVAIL | FM_FLG_AVAIL | FM_FLG_AVAIL | CHAR | 1 | 0 | Availability Time | ||
60 | FLG_BORROW | FM_FLG_BORROW | FM_FLG_BORROW | CHAR | 1 | 0 | Borrowing Source | ||
61 | FLG_DEFINITE | FM_FLG_DEFINITE | FM_FLG_DEFINITE | CHAR | 1 | 0 | Definite/Indef indicator | ||
62 | FLG_PARTNER | FM_FLG_PARTNER | FM_FLG_PARTNER | CHAR | 1 | 0 | Transaction Partner | ||
63 | FLG_REIMBUR | FM_FLG_REIMBUR | FM_FLG_REIMBUR | CHAR | 1 | 0 | Reimbursable | ||
64 | FLG_AUTHOR | FM_FLG_AUTHOR | FM_FLG_AUTHOR | CHAR | 1 | 0 | Authority Type | ||
65 | FLG_BEA | FM_FLG_BEA | FM_FLG_BEA | CHAR | 1 | 0 | BEA Category | ||
66 | BUREAU | FM_BUREAU | FM_BUREAU | CHAR | 2 | 0 | Federal Bureau | ||
67 | BUSINESS_LINE | FM_BUSINESS_LINE | FM_BUSINESS_LINE | CHAR | 2 | 0 | Business Line | ||
68 | FGDPRTMNT | FM_DEPARTMENT | FM_DEPARTMENT | CHAR | 2 | 0 | Federal Department | ||
69 | FGDPRTMNT_PART | FM_DEPARTMENT_PARTNER | FM_DEPARTMENT | CHAR | 2 | 0 | Federal Department Partner | ||
70 | FUND_ACC_SYMBL | FM_MAIN_ACCT | FM_MAIN_ACCT | CHAR | 4 | 0 | Treasury Account Symbol - Main Account | ||
71 | WSL | VWCUR12 | WERTV12 | CURR | 23 | 2 | Value in Original Transaction Currency (Document Currency) | ||
72 | RWCUR | RWCUR | WAERS | CUKY | 5 | 0 | Currency key of the original transaction currency | * | |
73 | AWID | AWID | AWID | CHAR | 10 | 0 | Reference document: Current identification | ||
74 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
75 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
76 | LINETYPE | LINETYPE | LINETYPE | CHAR | 5 | 0 | Item category | * | |
77 | XSPLITMOD | XSPLITMOD | XFELD | CHAR | 1 | 0 | Item changed by document splitting | ||
78 | FUND_TYPE | FM_FUNDTYPE | FM_FUNDTYPE | CHAR | 6 | 0 | FM Fund Type | * | |
79 | FM_AREA | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
80 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
81 | XSKRL | XSKRL | XFELD | CHAR | 1 | 0 | Indicator: Line item not liable to cash discount? | ||
82 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
83 | SGL_ACCOUNT | FM_SGL_ACCOUNT | FM_SGL_ACCOUNT | CHAR | 4 | 0 | SGL Account, US Federal Government | ||
84 | BDGT_FUNC_CLSS | FM_BDGT_FUNC_CLSS | CHAR3 | CHAR | 3 | 0 | Classification of Data According to Major Purpose | ||
85 | FMCMMTSTR_9 | FMCMMTSTR | FMCMMTSTR | CHAR | 62 | 0 | FM Commitment String For Budgetary Ledger | ||
86 | TRANSFER_AGCY_9 | FMFG_TRANSFER_AGCY | FMFG_TRANSFER | CHAR | 2 | 0 | Transfer Agency | * | |
87 | TRANSFER_ACCT_9 | FMFG_TRANSFER_ACCT | FMFG_TRAN_ACCT | CHAR | 4 | 0 | Transfer Account | * | |
88 | YEAR_BDGT_AUTH_9 | FMFG_YR_BUD_AUTH | FMFG_YR_BUD_AUTH | CHAR | 4 | 0 | Year of Budget Authority | ||
89 | FLG_ADVANCE_9 | FM_FLG_ADVANCE | FMFG_FLG_ADVANCE | CHAR | 1 | 0 | Advanced Flag | ||
90 | DEFENSE_INDIC_9 | FMFG_DEFENSE_INDICATOR | FMFG_DEFENSE_INDICATOR | CHAR | 3 | 0 | Defense Indicator | ||
91 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | FMMEASURE | |
92 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
93 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
94 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
95 | PROG_REPT_CAT_9 | FMFG_PROGRAM_REPORT_CATEGORY | FMFG_PROGRAM_REPORT_CATEGORY | CHAR | 3 | 0 | Program Reporting Category Posted | ||
96 | TR_BELNR | FMFG_TRANSAC_BELNR | CHAR14 | CHAR | 14 | 0 | Transaction Reference Document Number for AC | ||
97 | IAWKEY | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
98 | PROG_REPT_CAT | FMFG_PROG_REPT_CAT | FMFG_PROGRAM_REPORT_CATEGORY | CHAR | 3 | 0 | Program Reporting Category | ||
99 | PROG_REPT_CAT_TX | FMFG_PROG_REPT_CAT_TEX | CHAR | 25 | 0 | Program Reporting Category Text | |||
100 | CURR1 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
101 | CRAMT | FMFG_CREDIT_AMOUNT | WERTV9 | CURR | 17 | 2 | Federal Government Credit Amount | ||
102 | DEAMT | FMFG_DEBIT_AMOUNT | WERTV9 | CURR | 17 | 2 | Federal Government Debit Amount | ||
103 | RBUKRS_TXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
104 | RACCT_TXT | TXT20_SKAT_RFPSD | TEXT20 | CHAR | 20 | 0 | G/L Account Short Text | ||
105 | RBUSA_TXT | FMFG_BUSA_TEXT | TEXT30 | CHAR | 30 | 0 | Federal Government Business Area Description | ||
106 | RPRCTR_TXT | FMFG_PRCTR_TEXT | CHAR20 | CHAR | 20 | 0 | Federal Government Profit Center Description | ||
107 | RCNTR_TXT | KSKTXT | TEXT20 | CHAR | 20 | 0 | Cost Center Short Text | ||
108 | RPROJK_TXT | FMFG_PROJK_TEXT | CHAR40 | CHAR | 40 | 0 | Federal Government Project Number Text | ||
109 | RFAREA_TXT | FMFG_FAREA_TEXT | TEXT25 | CHAR | 25 | 0 | Federal Government Functional Area Description | ||
110 | RFUND_TXT | FM_FNAME | TEXT20 | CHAR | 20 | 0 | Fund name | ||
111 | RFIPEX_TXT | FM_PNAME | TEXT20 | CHAR | 20 | 0 | Commitment item name | ||
112 | RFISTL_TXT | FM_CNAME | TEXT20 | CHAR | 20 | 0 | Funds center name | ||
113 | RORDNR_TXT | FMFG_ORDER_TEXT | CHAR20 | CHAR | 20 | 0 | Federal Government Order Description | ||
114 | RVBUND_TXT | FMFG_VBUND_TEXT | TEXT30 | CHAR | 30 | 0 | Federal Government Trading Partner Description | ||
115 | RFINUSE_TXT | FM_FUSETXT | TEXT20 | CHAR | 20 | 0 | Application of funds description | ||
116 | SGL_ACCOUNT_TXT | FMFG_SLG_ACCOUNT_TEXT | FM_SGL_ACCOUNT_TEXT | CHAR | 80 | 0 | Federal Government SGL Account Description | ||
117 | FM_AREA_TXT | FITXT | TEXT25 | CHAR | 25 | 0 | Name of FM area | ||
118 | MEASURE_TXT | FM_ME_NAME | TEXT20 | CHAR | 20 | 0 | Name of Funded Program (20-character) | ||
119 | LONGNUM_UC | /SAPPSPRO/LONGNUM_UC | /SAPPSPRO/LONGNUM_UC | CHAR | 40 | 0 | Smart Document Number | ||
120 | .INCLUDE | 0 | 0 | Additional Federal Government Reporting Attributes | |||||
121 | FUNDINYEAR | FMFG_FUNDINYEAR | FMFG_YN | CHAR | 1 | 0 | Fund flagged to be used in fiscal year | ||
122 | FUNDEARMARKED | FMFG_FUNDEARMARKED | FMFG_YN | CHAR | 1 | 0 | Fund flagged as earmarked |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FMUSFGA_IS | AWTYP | TTYP | AWTYP | REF | C | CN |
2 | FMUSFGA_IS | DOCTY | T889 | DOCTY | REF | C | CN |
3 | FMUSFGA_IS | LOGSYS | TBDLS | LOGSYS | REF | C | CN |
4 | FMUSFGA_IS | MEASURE | FMMEASURE | MEASURE | REF | C | CN |
5 | FMUSFGA_IS | RBUKRS | T001 | BUKRS | REF | C | CN |
6 | FMUSFGA_IS | RBUSA | TGSB | GSBER | REF | C | CN |
7 | FMUSFGA_IS | RCLNT | T000 | MANDT | KEY | 1 | CN |
8 | FMUSFGA_IS | RFAREA | TFKB | FKBER | REF | C | CN |
9 | FMUSFGA_IS | RLDNR | T881 | RLDNR | REF | C | CN |
10 | FMUSFGA_IS | RPROJK | PRPS | PSPNR | REF | C | CN |
11 | FMUSFGA_IS | RTCUR | TCURC | WAERS | REF | C | CN |
12 | FMUSFGA_IS | RVERS | T894 | RVERS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 500 |