ENT3090 SAP (Generated Table for View ENT3090) Table View details
Dictionary Type: Table View
Description: Generated Table for View ENT3090
Description: Generated Table for View ENT3090
Table View field list including key, data, relationships and ABAP select examples
ENT3090 is a standard SAP Table View which is used to store Generated Table for View ENT3090 data and is available within R/3 SAP systems depending on the version and release level.
The ENT3090 table consists of various fields, each holding specific information or linking keys about Generated Table for View ENT3090 data available in SAP. These include BUKRS (Company Code), ANLN1 (Main Asset Number), ANLN2 (Asset Subnumber), AFABE (Real depreciation area).. 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: Not classified
SAP ENT3090 table view 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 |
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
AFABE | Real depreciation area | AFABE_D | NUMC | 2 | T093 | AFABE | AFB | ||
BDATU | Date validity ends | BDATU | DATS | 8 | DATUM | ||||
ADATU | Date for beginning of validity | ADATU | DATS | 8 | DATUM | ADT | |||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed on | AEDAT_ANLA | DATS | 8 | DATUM | ||||
XLOEV | Indicator: Account marked for deletion? | XLOEV | CHAR | 1 | XFELD | ||||
XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1 | XFELD | ||||
FELEI | Screen layout for Asset Accounting | FELEI | CHAR | 4 | T082A | FELEI | |||
XNEGA | Indicator: Negative values allowed | XNEGA | CHAR | 1 | XFELD | ||||
XGWGK | Low-value asset amount and quantity check | XGWGK | NUMC | 1 | XGWGK | ||||
XUNTA | Indicator: Depreciate main asset number totally | XUNTA | CHAR | 1 | XFELD | ||||
AFABG | Depreciation calculation start date | AFABG | DATS | 8 | DATUM | ||||
ZINBG | Start date for interest calculation | DZINBG | DATS | 8 | DATUM | ||||
SAFBG | Start date for special depreciation | SAFBG | DATS | 8 | DATUM | ||||
INVSL | Investment support key | INVSL | CHAR | 2 | T085 | INVSL | |||
AFASL | Depreciation key | AFASL | CHAR | 4 | T090NA | AFASL | SH_AFASL | ||
NDJAR | Planned useful life in years | NDJAR | NUMC | 3 | JARAF | ||||
NDPER | Planned useful life in periods | NDPER | NUMC | 3 | PERAF | ||||
NAPRZ | Ordinary depreciation percentage rate | NAPRZ | DEC | 7(4) | AFPROZ | ||||
SAPRZ | Special depreciation percentage rate | SAPRZ | DEC | 7(4) | AFPROZ | ||||
WBIND | Index series for replacement values | WBIND | CHAR | 5 | T094A | WBIND | |||
ALIND | Index series for replacement values by age | ALIND | CHAR | 5 | T094A | WBIND | |||
APROP | Variable depreciation portion | APROP | DEC | 7(4) | DEC3_4 | ||||
UMJAR | Depreciation key for the changeover year | UMJAR | NUMC | 4 | GJAHR | GJAHR | |||
NDURJ | Original useful life in years | NDURJ | NUMC | 3 | JARAF | ||||
NDURP | Original useful life in periods | NDURP | NUMC | 3 | PERAF | ||||
SCHRW | Asset scrap value | SCHRW | CURR | 13(2) | ANLKWERT | ||||
LGJAN | Last fiscal year for the annual values in Asset Acct. | LGJAN | NUMC | 4 | GJAHR | GJAHR | |||
PERFY | Period scaling in depreciation start year | PERFY | NUMC | 3 | PERAF | ||||
ANUPD | Indicator: Type of change to table | ANUPD | CHAR | 1 | ANUPD | ||||
AUFWTG | Revaluation | AUFWTG | NUMC | 2 | AUFWTG | ||||
XAFBE | Indicator: Depreciation area is deactivated | XAFBE | CHAR | 1 | XFELD | ||||
VYEAR | Acquisition year of the asset (manually changeable) | VYEAR | NUMC | 4 | GJAHR | GJAHR | |||
VMNTH | Asset Accounting: Acquis. month (in depreciation area) | VMNTH | NUMC | 3 | POPER | ||||
INBDA | Asset Accounting: Date of operating readiness | INBDA | DATS | 8 | DATUM | ||||
ABGDAT_B | Value date of last retirement for the depreciation area | ABGDAT_B | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table ENT3090 using ABAP code
The following ABAP code Example will allow you to do a basic selection on ENT3090 to SELECT all data from the tableDATA: WA_ENT3090 TYPE ENT3090.
SELECT SINGLE *
FROM ENT3090
INTO CORRESPONDING FIELDS OF WA_ENT3090
WHERE...
How to access SAP table ENT3090
Within an ECC or HANA version of SAP you can also view further information about ENT3090 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