SAP ABAP Table FMRPF_USFGX (FM USFG Line Item Browser)
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 | FMRPF_USFGX | Table Relationship Diagram |
Short Description | FM USFG Line Item Browser |
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 | DEBIT_AMOUNT | FMFG_DEBIT_AMOUNT | WERTV9 | CURR | 17 | 2 | Federal Government Debit Amount | ||
97 | CREDIT_AMOUNT | FMFG_CREDIT_AMOUNT | WERTV9 | CURR | 17 | 2 | Federal Government Credit Amount | ||
98 | DBCNT | SYDBCNT | SYST_LONG | INT4 | 10 | 0 | Processed Database Table Rows |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FMRPF_USFGX | AWTYP | TTYP | AWTYP | REF | C | CN |
2 | FMRPF_USFGX | DOCTY | T889 | DOCTY | REF | C | CN |
3 | FMRPF_USFGX | LOGSYS | TBDLS | LOGSYS | REF | C | CN |
4 | FMRPF_USFGX | MEASURE | FMMEASURE | MEASURE | REF | C | CN |
5 | FMRPF_USFGX | RBUKRS | T001 | BUKRS | REF | C | CN |
6 | FMRPF_USFGX | RBUSA | TGSB | GSBER | REF | C | CN |
7 | FMRPF_USFGX | RCLNT | T000 | MANDT | KEY | 1 | CN |
8 | FMRPF_USFGX | RFAREA | TFKB | FKBER | REF | C | CN |
9 | FMRPF_USFGX | RLDNR | T881 | RLDNR | REF | C | CN |
10 | FMRPF_USFGX | RPROJK | PRPS | PSPNR | REF | C | CN |
11 | FMRPF_USFGX | RTCUR | TCURC | WAERS | REF | C | CN |
12 | FMRPF_USFGX | RVERS | T894 | RVERS | REF | C | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |