The FMFGUSKONTKEY table in SAP ERP or S/4HANA stores Key for US Account Assignments data. There are total 11 fields in FMFGUSKONTKEY table. The Key for US Account Assignments table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMFGUSKONTKEY table. It is in US Federal Government budgetary ledger account derivation (FMFG_E) ABAP package and is part of the Funds Management (PSM-FM) module.
SAP FMFGUSKONTKEY Table Fields
Following is the list of fields that are available in SAP FMFGUSKONTKEY table. The primary key fields of the table are MANDT (Client), USKONTKEY (United States Federal Government Fields).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| USKONTKEY | United States Federal Government Fields | FMFG_US_KEY | CHAR (22) | |
| HASHVERS | Version for Hash Code | FMFG_HASHVERS | CHAR (2) | |
| HASHCODE | Hash Code to FG Data Fields | FMFG_HASHCODE | CHAR (16) | |
| HASHDEF | Hash Code Defect (Collisions) | FMFG_HASHDEF | CHAR (2) | |
| TP_SUBLEVL | Sublevel Prefix (SP) for Trading Partner | FMFG_TP_SUBLEVL | CHAR (2) | |
| TP_AGENCID | Agency Identifier (AID) for Trading Partner | FMFG_TP_AGENCID | CHAR (3) | |
| TP_ALTRAID | Allocation Transfer Agency Identifier (ATA) Trading Partner | FMFG_TP_ALTRAID | CHAR (3) | |
| TP_BEGPER | Beginning Period of Availability (BPOA) for Trading Partner | FMFG_TP_BEGPER | NUMC (4) | |
| TP_ENDPER | Ending Period of Availability (EPOA) for Trading Partner | FMFG_TP_ENDPER | NUMC (4) | |
| TP_AVTYPE | Availability Type Code (A) for Trading Partner | FMFG_TP_AVTYPE | CHAR (1) |
