SAP ABAP Table FMFG_SAV_FMUSFGA (Saved FMUSFGA data for docs excluded from SL Repost for 600)
Hierarchy
☛
EA-PS (Software Component) SAP Enterprise Extension Public Services
⤷ PSM-FM (Application Component) Funds Management
⤷ FMFG_E (Package) US Federal Government budgetary ledger account derivation
⤷ PSM-FM (Application Component) Funds Management
⤷ FMFG_E (Package) US Federal Government budgetary ledger account derivation
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | FMFG_SAV_FMUSFGA | Table Relationship Diagram |
Short Description | Saved FMUSFGA data for docs excluded from SL Repost for 600 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | RCLNT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | GL_SIRID | GU_RECID | OBJNR | CHAR | 18 | 0 | Record number of the line item record | ||
3 | RLDNR | RLDNR | RLDNR | CHAR | 2 | 0 | Ledger | T881 | |
4 | RRCTY | RRCTY | RRCTY | CHAR | 1 | 0 | Record Type | ||
5 | RVERS | RVERS | RVERS | CHAR | 3 | 0 | Version | T894 | |
6 | RYEAR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
7 | RTCUR | RTCUR | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
8 | DRCRK | SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
9 | POPER | POPER | POPER | NUMC | 3 | 0 | Posting period | ||
10 | DOCCT | DOCCT | DOCCT | CHAR | 1 | 0 | Document Type | ||
11 | DOCNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
12 | DOCLN | DOCLN6 | DOCLN6 | CHAR | 6 | 0 | Six-Character Posting Item for Ledger | ||
13 | RBUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
14 | RACCT | RACCT | SAKNR | CHAR | 10 | 0 | Account Number | * | |
15 | RBUSA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
16 | RPRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
17 | RCNTR | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
18 | RPROJK | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
19 | RFAREA | FKBER | FKBER | CHAR | 16 | 0 | Functional Area | TFKB | |
20 | RFUND | BP_GEBER | BP_GEBER | CHAR | 10 | 0 | Fund | * | |
21 | RFIPEX | FM_FIPEX | FM_FIPEX | CHAR | 24 | 0 | Commitment item | * | |
22 | RFISTL | FISTL | FISTL | CHAR | 16 | 0 | Funds Center | * | |
23 | RORDNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
24 | RVBUND | RASSC | RCOMP | CHAR | 6 | 0 | Company ID of trading partner | * | |
25 | RAGNCY_LCTN_CODE | FMFG_ALC | FMFG_ALC | CHAR | 8 | 0 | Agency Location Code | * | |
26 | RFINUSE | FM_FINUSE | FM_FINUSE | CHAR | 16 | 0 | Application of Secondary Source Funds | * | |
27 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
28 | FMFG_SUBKEY_9 | FMFG_SUBKEY | CHAR10 | CHAR | 10 | 0 | Subkey for FMUSFGT | ||
29 | BLSTATUS_9 | FMFG_BLSTATUS | FMFG_BLSTATUS | CHAR | 5 | 0 | Budgetary ledger status | ||
30 | TSL | VTCUR9 | WERTV9 | CURR | 17 | 2 | Value in Transaction Currency | ||
31 | HSL | VLCUR9 | WERTV9 | CURR | 17 | 2 | Value in local currency | ||
32 | SGTXT | SGTXT | TEXT50 | CHAR | 50 | 0 | Item Text | ||
33 | DOCTY | DOCTY | DOCTY | CHAR | 2 | 0 | FI-SL Document Type | T889 | |
34 | ACTIV | GLVOR | CHAR4 | CHAR | 4 | 0 | Business Transaction | ||
35 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
36 | WSDAT | WSDAT | DATUM | DATS | 8 | 0 | Value Date for Currency Translation | ||
37 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
38 | REFDOCNR | REFBELNR | BELNR | CHAR | 10 | 0 | Reference document number of an accounting document | ||
39 | REFRYEAR | REFGJAHR | GJAHR | NUMC | 4 | 0 | Reference fiscal year | ||
40 | REFDOCLN | REFBUZEI6 | BUZEI6 | NUMC | 6 | 0 | Six-digit number of the reference posting line | ||
41 | REFDOCCT | REFDOCCT | DOCCT | CHAR | 1 | 0 | Reference document category | ||
42 | REFACTIV | REFGLVOR | CHAR4 | CHAR | 4 | 0 | FI-SL Business Reference Transaction | ||
43 | CPUDT | CPUDT | DATUM | DATS | 8 | 0 | Accounting document entry date | ||
44 | CPUTM | CPUTM | UZEIT | TIMS | 6 | 0 | Time of data entry | ||
45 | USNAM | USNAM | XUBNAME | CHAR | 12 | 0 | User name | * | |
46 | AWTYP | AWTYP | AWTYP | CHAR | 5 | 0 | Reference procedure | TTYP | |
47 | AWORG | AWORG | AWORG | CHAR | 10 | 0 | Reference organisational units | ||
48 | PMT_OFFICE | FMFG_PMT_OFF | FMFG_PMT_OFF | CHAR | 5 | 0 | Payment Office | * | |
49 | COHORT | FM_COHORT | FM_COHORT | CHAR | 4 | 0 | Reporting Year for Cohort | ||
50 | PUBLAW | FM_PUBLAW | FM_PUBLAW | CHAR | 20 | 0 | Public Law Cited | ||
51 | LEGIS | FM_LEGIS | FM_LEGIS | CHAR | 1 | 0 | Type of Legislation | ||
52 | FLG_COVERED | FM_FLG_COVERED | FM_FLG_COVERED | CHAR | 1 | 0 | Covered Indicator | ||
53 | FLG_CUSTODIAL | FM_FLG_CUSTODIAL | FM_FLG_CUSTODIAL | CHAR | 1 | 0 | Custodial Indicator | ||
54 | FLG_ENTITY | FM_FLG_ENTITY | FM_FLG_ENTITY | CHAR | 1 | 0 | Entity Indicator | ||
55 | FLG_EXCHANGE | FM_FLG_EXCHANGE | FM_FLG_EXCHANGE | CHAR | 1 | 0 | Exchange Indicator | ||
56 | FLG_FEDERAL | FM_FLG_FEDERAL | FM_FLG_FEDERAL | CHAR | 1 | 0 | Federal Indicator | ||
57 | FLG_APPORT | FM_FLG_APPORT | FM_FLG_APPORT | CHAR | 1 | 0 | Apportionment Category | ||
58 | FLG_AVAIL | FM_FLG_AVAIL | FM_FLG_AVAIL | CHAR | 1 | 0 | Availability Time | ||
59 | FLG_BORROW | FM_FLG_BORROW | FM_FLG_BORROW | CHAR | 1 | 0 | Borrowing Source | ||
60 | FLG_DEFINITE | FM_FLG_DEFINITE | FM_FLG_DEFINITE | CHAR | 1 | 0 | Definite/Indef indicator | ||
61 | FLG_PARTNER | FM_FLG_PARTNER | FM_FLG_PARTNER | CHAR | 1 | 0 | Transaction Partner | ||
62 | FLG_REIMBUR | FM_FLG_REIMBUR | FM_FLG_REIMBUR | CHAR | 1 | 0 | Reimbursable | ||
63 | FLG_AUTHOR | FM_FLG_AUTHOR | FM_FLG_AUTHOR | CHAR | 1 | 0 | Authority Type | ||
64 | FLG_BEA | FM_FLG_BEA | FM_FLG_BEA | CHAR | 1 | 0 | BEA Category | ||
65 | BUREAU | FM_BUREAU | FM_BUREAU | CHAR | 2 | 0 | Federal Bureau | ||
66 | BUSINESS_LINE | FM_BUSINESS_LINE | FM_BUSINESS_LINE | CHAR | 2 | 0 | Business Line | ||
67 | FGDPRTMNT | FM_DEPARTMENT | FM_DEPARTMENT | CHAR | 2 | 0 | Federal Department | ||
68 | FGDPRTMNT_PART | FM_DEPARTMENT_PARTNER | FM_DEPARTMENT | CHAR | 2 | 0 | Federal Department Partner | ||
69 | FUND_ACC_SYMBL | FM_MAIN_ACCT | FM_MAIN_ACCT | CHAR | 4 | 0 | Treasury Account Symbol - Main Account | ||
70 | WSL | VWCUR12 | WERTV12 | CURR | 23 | 2 | Value in Original Transaction Currency (Document Currency) | ||
71 | RWCUR | RWCUR | WAERS | CUKY | 5 | 0 | Currency key of the original transaction currency | * | |
72 | AWID | AWID | AWID | CHAR | 10 | 0 | Reference document: Current identification | ||
73 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
74 | BUZEI | BUZEI | BUZEI | NUMC | 3 | 0 | Number of Line Item Within Accounting Document | ||
75 | LINETYPE | LINETYPE | LINETYPE | CHAR | 5 | 0 | Item category | * | |
76 | XSPLITMOD | XSPLITMOD | XFELD | CHAR | 1 | 0 | Item changed by document splitting | ||
77 | FUND_TYPE | FM_FUNDTYPE | FM_FUNDTYPE | CHAR | 6 | 0 | FM Fund Type | * | |
78 | FM_AREA | FIKRS | FIKRS | CHAR | 4 | 0 | Financial Management Area | * | |
79 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
80 | XSKRL | XSKRL | XFELD | CHAR | 1 | 0 | Indicator: Line item not liable to cash discount? | ||
81 | CO_AREA | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | * | |
82 | SGL_ACCOUNT | FM_SGL_ACCOUNT | FM_SGL_ACCOUNT | CHAR | 4 | 0 | SGL Account, US Federal Government | ||
83 | BDGT_FUNC_CLSS | FM_BDGT_FUNC_CLSS | CHAR3 | CHAR | 3 | 0 | Classification of Data According to Major Purpose | ||
84 | FMCMMTSTR_9 | FMCMMTSTR | FMCMMTSTR | CHAR | 62 | 0 | FM Commitment String For Budgetary Ledger | ||
85 | TRANSFER_AGCY_9 | FMFG_TRANSFER_AGCY | FMFG_TRANSFER | CHAR | 2 | 0 | Transfer Agency | * | |
86 | TRANSFER_ACCT_9 | FMFG_TRANSFER_ACCT | FMFG_TRAN_ACCT | CHAR | 4 | 0 | Transfer Account | * | |
87 | YEAR_BDGT_AUTH_9 | FMFG_YR_BUD_AUTH | FMFG_YR_BUD_AUTH | CHAR | 4 | 0 | Year of Budget Authority | ||
88 | FLG_ADVANCE_9 | FM_FLG_ADVANCE | FMFG_FLG_ADVANCE | CHAR | 1 | 0 | Advanced Flag | ||
89 | DEFENSE_INDIC_9 | FMFG_DEFENSE_INDICATOR | FMFG_DEFENSE_INDICATOR | CHAR | 3 | 0 | Defense Indicator | ||
90 | MEASURE | FM_MEASURE | FM_MEASURE | CHAR | 24 | 0 | Funded Program | FMMEASURE | |
91 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
92 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
93 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
94 | PROG_REPT_CAT_9 | FMFG_PROGRAM_REPORT_CATEGORY | FMFG_PROGRAM_REPORT_CATEGORY | CHAR | 3 | 0 | Program Reporting Category Posted |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FMFG_SAV_FMUSFGA | AWTYP | TTYP | AWTYP | REF | C | CN |
2 | FMFG_SAV_FMUSFGA | DOCTY | T889 | DOCTY | REF | C | CN |
3 | FMFG_SAV_FMUSFGA | LOGSYS | TBDLS | LOGSYS | REF | C | CN |
4 | FMFG_SAV_FMUSFGA | MEASURE | FMMEASURE | MEASURE | REF | C | CN |
5 | FMFG_SAV_FMUSFGA | RBUKRS | T001 | BUKRS | REF | C | CN |
6 | FMFG_SAV_FMUSFGA | RBUSA | TGSB | GSBER | REF | C | CN |
7 | FMFG_SAV_FMUSFGA | RCLNT | T000 | MANDT | KEY | 1 | CN |
8 | FMFG_SAV_FMUSFGA | RFAREA | TFKB | FKBER | REF | C | CN |
9 | FMFG_SAV_FMUSFGA | RLDNR | T881 | RLDNR | REF | C | CN |
10 | FMFG_SAV_FMUSFGA | RPROJK | PRPS | PSPNR | REF | C | CN |
11 | FMFG_SAV_FMUSFGA | RTCUR | TCURC | WAERS | REF | C | CN |
12 | FMFG_SAV_FMUSFGA | RVERS | T894 | RVERS | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |