USFEDERAL SAP (US Federal extension) Append Structure details
Dictionary Type: Append Structure
Description: US Federal extension
Description: US Federal extension
Append Structure field list including key, data, relationships and ABAP select examples
USFEDERAL is a standard SAP Append Structure which is used to store US Federal extension data and is available within R/3 SAP systems depending on the version and release level.
The USFEDERAL table consists of various fields, each holding specific information or linking keys about US Federal extension data available in SAP. These include DATA (), DUNS (DUNS Number), DUNS4 (DUNS+4), CAGE (CAGE Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP USFEDERAL append structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| CCR_RECORD | 0 | ||||||||
| DATA | 0 | ||||||||
| DUNS | DUNS Number | FMCCRDUNS | CHAR | 9 | |||||
| DUNS4 | DUNS+4 | FMCCRDUNS4 | CHAR | 4 | |||||
| CAGE | CAGE Code | FMCCRCAGE | CHAR | 5 | |||||
| RENDATE | Obsolete field (do not use) - Renewal date for CCR Vendor | FMCCRENDAT | DATS | 8 | DATS | ||||
| REG_IND | CCR Registration Indicator | FMFGCCRREGIND | CHAR | 1 | FMFGCCRREGIND | ||||
| REG_STAT | Obsolete field (do not use) - CCR Registration Status | FMFGCCRREGSTAT | CHAR | 1 | FMFGCCRREGSTAT | ||||
| DATAX | 0 | ||||||||
| DUNS | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
| DUNS4 | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
| CAGE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
| RENDATE | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
| REG_IND | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE | ||||
| REG_STAT | Updated information in related user data field | BAPIUPDATE | CHAR | 1 | BAPIUPDATE |
| Key field | Non-key field |
How do I retrieve data from SAP append structure USFEDERAL using ABAP code?
As USFEDERAL is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on USFEDERAL as there is no data to select. You could however select data from any tables that this append structure has been assigned too.How to access SAP table USFEDERAL
Within an ECC or HANA version of SAP you can also view further information about USFEDERAL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects