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 |