FMUSFGA - Actual line item table for US Federal Government.
Actual line item table for US Federal Government. information is stored in SAP table FMUSFGA.
It is part of development package FMFG_E in software component PSM-FM. This development package consists of objects that can be grouped under "US Federal Government budgetary ledger account derivation".
It is part of development package FMFG_E in software component PSM-FM. This development package consists of objects that can be grouped under "US Federal Government budgetary ledger account derivation".
Fields for table FMUSFGA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| RCLNT | Client | X | MANDT | CLNT | 6 | T000 |
| GL_SIRID | Record number of the line item record | X | GU_RECID | CHAR | 36 | |
| RLDNR | Ledger | RLDNR | CHAR | 4 | T881 | |
| RRCTY | Record Type | RRCTY | CHAR | 2 | ||
| RVERS | Version | RVERS | CHAR | 6 | T894 | |
| RYEAR | Fiscal Year | GJAHR | NUMC | 8 | ||
| RTCUR | Currency Key | RTCUR | CUKY | 10 | TCURC | |
| DRCRK | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
| POPER | Posting period | POPER | NUMC | 6 | ||
| DOCCT | Document Category | DOCCT | CHAR | 2 | ||
| DOCNR | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | CHAR | 12 | ||
| RBUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| RACCT | Account Number | RACCT | CHAR | 20 | ||
| RBUSA | Business Area | GSBER | CHAR | 8 | TGSB | |
| RPRCTR | Profit Center | PRCTR | CHAR | 20 | ||
| RCNTR | Cost Center | KOSTL | CHAR | 20 | ||
| RPROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | PRPS | |
| RFAREA | Functional Area | FKBER | CHAR | 32 | TFKB | |
| RFUND | Fund | BP_GEBER | CHAR | 20 | ||
| RFIPEX | Object Class for US Federal | FMFG_OBJ_CL | CHAR | 48 | ||
| RFISTL | Funds Center | FISTL | CHAR | 32 | ||
| RORDNR | Order Number | AUFNR | CHAR | 24 | ||
| RVBUND | Company ID of Trading Partner | RASSC | CHAR | 12 | ||
| RAGNCY_LCTN_CODE | Agency Location Code | FMFG_ALC | CHAR | 16 | ||
| RFINUSE | Application of Funds | FM_FINUSE | CHAR | 32 | ||
| LOGSYS | Logical system | LOGSYS | CHAR | 20 | TBDLS | |
| FMFG_SUBKEY_9 | Subkey for FMUSFGT | FMFG_SUBKEY | CHAR | 20 | ||
| BLSTATUS_9 | Budgetary ledger status | FMFG_BLSTATUS | CHAR | 10 | ||
| TSL | Value in Transaction Currency | VTCUR9_CS | CURR | 9 | ||
| HSL | Value in local currency | VLCUR9_CS | CURR | 9 | ||
| SGTXT | Item Text | SGTXT | CHAR | 100 | ||
| DOCTY | FI-SL Document Type | DOCTY | CHAR | 4 | T889 | |
| ACTIV | Business Transaction | GLVOR | CHAR | 8 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
| WSDAT | Value Date for Currency Translation | WSDAT | DATS | 16 | ||
| BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
| REFDOCNR | Reference document number of an accounting document | REFBELNR | CHAR | 20 | ||
| REFRYEAR | Reference fiscal year | REFGJAHR | NUMC | 8 | ||
| REFDOCLN | Six-Digit Number of the Reference Posting Line | REFBUZEI6 | NUMC | 12 | ||
| REFDOCCT | Reference Document Category | REFDOCCT | CHAR | 2 | ||
| REFACTIV | FI-SL Business Reference Transaction | REFGLVOR | CHAR | 8 | ||
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 16 | ||
| CPUTM | Time of Entry | CPUTM | TIMS | 12 | ||
| USNAM | User Name | USNAM | CHAR | 24 | ||
| AWTYP | Reference procedure | AWTYP | CHAR | 10 | TTYP | |
| AWORG | Reference Organizational Units | AWORG | CHAR | 20 | ||
| PMT_OFFICE | Payment Office | FMFG_PMT_OFF | CHAR | 10 | ||
| COHORT | Reporting Year for Cohort | FM_COHORT | CHAR | 8 | ||
| PUBLAW | Public Law Cited | FM_PUBLAW | CHAR | 40 | ||
| LEGIS | Type of Legislation | FM_LEGIS | CHAR | 2 | ||
| FLG_COVERED | Covered Indicator | FM_FLG_COVERED | CHAR | 2 | ||
| FLG_CUSTODIAL | Custodial Indicator | FM_FLG_CUSTODIAL | CHAR | 2 | ||
| FLG_ENTITY | Entity Indicator | FM_FLG_ENTITY | CHAR | 2 | ||
| FLG_EXCHANGE | Exchange Indicator | FM_FLG_EXCHANGE | CHAR | 2 | ||
| FLG_FEDERAL | Federal/Nonfederal Code | FM_FLG_FEDERAL | CHAR | 2 | ||
| FLG_APPORT | Apportionment Category | FM_FLG_APPORT | CHAR | 2 | ||
| FLG_AVAIL | Availability Time | FM_FLG_AVAIL | CHAR | 2 | ||
| FLG_BORROW | Borrowing Source | FM_FLG_BORROW | CHAR | 2 | ||
| FLG_DEFINITE | Definite/Indef indicator | FM_FLG_DEFINITE | CHAR | 2 | ||
| FLG_PARTNER | Transaction Partner | FM_FLG_PARTNER | CHAR | 2 | ||
| FLG_REIMBUR | Reimbursable | FM_FLG_REIMBUR | CHAR | 2 | ||
| FLG_AUTHOR | Authority Type | FM_FLG_AUTHOR | CHAR | 2 | ||
| FLG_BEA | Budget Enforcement Act Category | FM_FLG_BEA | CHAR | 2 | ||
| BUREAU | Federal Bureau | FM_BUREAU | CHAR | 4 | ||
| BUSINESS_LINE | Business Line | FM_BUSINESS_LINE | CHAR | 4 | ||
| FGDPRTMNT | Federal Department | FM_DEPARTMENT | CHAR | 4 | ||
| FGDPRTMNT_PART | Federal Department Partner | FM_DEPARTMENT_PARTNER | CHAR | 4 | ||
| FUND_ACC_SYMBL | Main Account | FM_MAIN_ACCT | CHAR | 8 | ||
| WSL | Value in Original Transaction Currency (Document Currency) | VWCUR12 | CURR | 12 | ||
| RWCUR | Currency key of the original transaction currency | RWCUR | CUKY | 10 | ||
| AWID | Reference document: Current identification | AWID | CHAR | 20 | ||
| BELNR | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 6 | ||
| LINETYPE | Item Category | LINETYPE | CHAR | 10 | ||
| XSPLITMOD | Item Changed by Document Splitting | XSPLITMOD | CHAR | 2 | ||
| FUND_TYPE | FM Fund Type | FM_FUNDTYPE | CHAR | 12 | ||
| FM_AREA | Financial Management Area | FIKRS | CHAR | 8 | ||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 4 | ||
| XSKRL | Indicator: Line Item Not Liable to Cash Discount? | XSKRL | CHAR | 2 | ||
| CO_AREA | Controlling Area | KOKRS | CHAR | 8 | ||
| SGL_ACCOUNT | Standard General Ledger Account for US Federal Government | FM_SGL_ACCOUNT | CHAR | 12 | ||
| BDGT_FUNC_CLSS | Classification of Data According to Major Purpose | FM_BDGT_FUNC_CLSS | CHAR | 6 | ||
| FMCMMTSTR_9 | FM Commitment String For Budgetary Ledger | FMCMMTSTR | CHAR | 124 | ||
| TRANSFER_AGCY_9 | Transfer Agency | FMFG_TRANSFER_AGCY | CHAR | 4 | ||
| TRANSFER_ACCT_9 | Transfer Account | FMFG_TRANSFER_ACCT | CHAR | 8 | ||
| YEAR_BDGT_AUTH_9 | Year of Budget Authority | FMFG_YR_BUD_AUTH | CHAR | 8 | ||
| FLG_ADVANCE_9 | Advanced Flag | FM_FLG_ADVANCE | CHAR | 2 | ||
| DEFENSE_INDIC_9 | Defense Indicator / Reduction Type | FMFG_DEFENSE_INDICATOR | CHAR | 6 | ||
| MEASURE | Funded Program | FM_MEASURE | CHAR | 48 | FMMEASURE | |
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 32 | ||
| LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | ||
| KUNNR | Customer Number | KUNNR | CHAR | 20 | ||
| PROG_REPT_CAT_9 | Program Reporting Category | FMFG_PROGRAM_REPORT_CATEGORY | CHAR | 6 | ||
| BUDGET_PD_9 | Budget Period | FM_BUDGET_PERIOD | CHAR | 20 | ||
| ASSETMAINO_9 | Main Asset Number | BF_ANLN1 | CHAR | 24 | ||
| ASSETSUBNO_9 | Asset Subnumber | BF_ANLN2 | CHAR | 8 | ||
| MOVEMENTTYPE_9 | Asset Transaction Type | ANBWA | CHAR | 6 | ||
| ASSET_ACQDATE_9 | Asset Value Date | BZDAT | DATS | 16 | ||
| NPLNR_9 | Network Number for Account Assignment | NPLNR | CHAR | 24 | ||
| APLZL_9 | Internal counter | CIM_COUNT | NUMC | 16 | ||
| AUFPL_9 | Routing number of operations in the order | CO_AUFPL | NUMC | 20 | ||
| PRZNR_9 | Business Process | CO_PRZNR | CHAR | 24 | ||
| IMKEY_9 | Internal Key for Real Estate Object | IMKEY | CHAR | 16 | ||
| INTRENO_9 | Internal Real Estate Master Data Code | VVINTRENO | CHAR | 26 | ||
| APPOR_CATB_DTL_9 | Apportionment Category B Program Code | FMFG_APPORTDTL | CHAR | 8 | ||
| BDGT_IMPACT_9 | Budgetary Impact | FMFG_BDGT_IMPACT | CHAR | 2 | ||
| FLG_PYA_9 | Prior Year Adjustment Code | FMFG_FLG_PYA | CHAR | 2 | ||
| PROGRAM_IND_9 | Disaster Emergency Fund Code | FMFG_PROGRAM_IND | CHAR | 6 | ||
| TP_SUBLEVL_9 | Sublevel Prefix (SP) for Trading Partner | FMFG_TP_SUBLEVL | CHAR | 4 | ||
| TP_AGENCID_9 | Agency Identifier (AID) for Trading Partner | FMFG_TP_AGENCID | CHAR | 6 | ||
| TP_ALTRAID_9 | Allocation Transfer Agency Identifier (ATA) Trading Partner | FMFG_TP_ALTRAID | CHAR | 6 | ||
| TP_BEGPER_9 | Beginning Period of Availability (BPOA) for Trading Partner | FMFG_TP_BEGPER | NUMC | 8 | ||
| TP_ENDPER_9 | Ending Period of Availability (EPOA) for Trading Partner | FMFG_TP_ENDPER | NUMC | 8 | ||
| TP_AVTYPE_9 | Availability Type Code (A) for Trading Partner | FMFG_TP_AVTYPE | CHAR | 2 | ||
| TP_MAIN_ACCT_9 | Main Account for Trading Partner | FMFG_TP_MAIN_ACCT | CHAR | 8 | ||
| TP_SUB_ACCT_9 | Subaccount for Trading Partner | FMFG_TP_SUB_ACCT | CHAR | 6 | ||
| BETC_9 | Business Event Type Code | FMFG_BETC | CHAR | 20 | ||
| TP_BETC_9 | Business Event Type Code for Trading Partner | FMFG_TP_BETC | CHAR | 20 | ||
| TREASURY_OFFS_9 | Treasury Offset Program Eligibility | FMFG_TREASURY_OFFSET | CHAR | 2 | ||
| GARNISHMENT_9 | Garnishment | FMFG_GARNISHMENT | CHAR | 2 | ||
| SUBLEVL_9 | Sublevel Prefix (SP) | FMFG_SUBLEVL | CHAR | 4 | ||
| AGENCID_9 | Agency Identifier (AID) | FMFG_AGENCID | CHAR | 6 | ||
| ALTRAID_9 | Allocation Transfer Agency Identifier (ATA) | FMFG_ALTRAID | CHAR | 6 | ||
| BEGPER_9 | Beginning Period of Availability (BPOA) | FMFG_BEGPER | NUMC | 8 | ||
| ENDPER_9 | Ending Period of Availability (EPOA) | FMFG_ENDPER | NUMC | 8 | ||
| AVTYPE_9 | Availability Type Code (A) | FMFG_AVTYPE | CHAR | 2 | ||
| SUB_ACCT_9 | Subaccount | FM_SUB_ACCT | CHAR | 6 |