J_3RANLCV SAP (PBU-18 FI-AA Infoset structure) Structure details
Description: PBU-18 FI-AA Infoset structure
Structure field list including key, data, relationships and ABAP select examples
J_3RANLCV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "PBU-18 FI-AA Infoset structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_J_3RANLCV TYPE J_3RANLCV.
The J_3RANLCV table consists of various fields, each holding specific information or linking keys about PBU-18 FI-AA Infoset structure data available in SAP. These include MANDT (Client), BUKRS (Company Code), ANLN1 (Main Asset Number), ANLN2 (Asset Subnumber).. 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 J_3RANLCV 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
AFABE | Real depreciation area | AFABE_D | NUMC | 2 | Assigned to domain | AFABE | AFB | ||
ZUJHR | Asset acquisition year (currently not used) | DZUJHR | NUMC | 4 | GJAHR | GJAHR | |||
ZUCOD | Sub-classification of asset acquisitions(currently not used) | DZUCOD | NUMC | 4 | AZCOD | ||||
AFBLPE | Period in which last depreciation was posted | AFBLPE | NUMC | 3 | PERAF | ||||
AFBANZ | Number of depreciation posting runs in the period | AFBANZ | NUMC | 2 | NUM2 | ||||
XAFAR | Indicator: Errors in depreciation | XAFAR | NUMC | 1 | XAFAR | ||||
NDABJ | Expired useful life in years at start of the fiscal year | NDABJ | NUMC | 3 | JARAF | ||||
NDABP | Expired useful life in periods at start of fiscal year | NDABP | NUMC | 3 | PERAF | ||||
ANDSJ | Yrs Expired up to Fisc.Yr Start from Start of Spec.Dep. | ANDSJ | NUMC | 3 | JARAF | ||||
ANDSP | Expired useful life in periods during FY from SDep start dat | ANDSP | NUMC | 3 | PERAF | ||||
RSTCK | Number of units depreciated in unit-of-prod. depreciation | RSTCK | DEC | 15 | PACK8 | ||||
KANSW | Cumulative acquisition and production costs | KANSW | CURR | 13(2) | ANLKWERT | ||||
KAUFW | Cumulative revaluation on the replacement value | KAUFW | CURR | 13(2) | ANLKWERT | ||||
KINVZ | Cumulative investment grants | KINVZ | CURR | 13(2) | ANLKWERT | ||||
KNAFA | Accumulated ordinary depreciation | KNAFA | CURR | 13(2) | ANLKWERT | ||||
KSAFA | Cumulative special depreciation | KSAFA | CURR | 13(2) | ANLKWERT | ||||
KAAFA | Cumulative unplanned depreciation | KAAFA | CURR | 13(2) | ANLKWERT | ||||
KMAFA | Cumulative reserves transfer | KMAFA | CURR | 13(2) | ANLKWERT | ||||
KZINW | Cumulative interest | KZINW | CURR | 13(2) | ANLKWERT | ||||
KAUFN | Cumulative revaluation of ordinary depreciation | KAUFN | CURR | 13(2) | ANLKWERT | ||||
KANZA | Cumulative down payments | KANZA | CURR | 13(2) | ANLKWERT | ||||
KVOST | Cumulative input tax | KVOST | CURR | 13(2) | ANLKWERT | ||||
AUFWP | Planned revaluation on replacement value | AUFWP | CURR | 13(2) | ANLKWERT | ||||
NAFAP | Planned ordinary depreciation for the year | NAFAP | CURR | 13(2) | ANLKWERT | ||||
SAFAP | Planned special depreciation for the year | SAFAP | CURR | 13(2) | ANLKWERT | ||||
AAFAP | Scheduled unplanned depreciation for the year | AAFAP | CURR | 13(2) | ANLKWERT | ||||
MAFAP | Planned transfer of reserves for the year | MAFAP | CURR | 13(2) | ANLKWERT | ||||
ZINSP | Interest planned for the year | DZINSP | CURR | 13(2) | ANLKWERT | ||||
AUFNP | Planned revaluation of accumulated ordinary depreciation | AUFNP | CURR | 13(2) | ANLKWERT | ||||
AUFWB | Revaluation posted on replacement value | AUFWB | CURR | 13(2) | ANLKWERT | ||||
NAFAG | Ordinary depreciation posted in the current year | NAFAG | CURR | 13(2) | ANLKWERT | ||||
SAFAG | Special depreciation posted in the current fiscal year | SAFAG | CURR | 13(2) | ANLKWERT | ||||
AAFAG | Unplanned depreciation posted for the year | AAFAG | CURR | 13(2) | ANLKWERT | ||||
MAFAG | Acquisition value reducing depreciation posted for the year | MAFAG | CURR | 13(2) | ANLKWERT | ||||
ZINSG | Interest posted for the year | DZINSG | CURR | 13(2) | ANLKWERT | ||||
AUFNG | Posted revaluation of accumulated ordinary depreciation | AUFNG | CURR | 13(2) | ANLKWERT | ||||
ANSWL | Transactions for the year affecting asset values | ANSWL | CURR | 13(2) | ANLKWERT | ||||
ABGAN | Total retirements and retiring transfers | ABGAN | CURR | 13(2) | ANLKWERT | ||||
ANSAZ | Down payments on asset | ANSAZ | CURR | 13(2) | ANLKWERT | ||||
AUFWM | Manual revaluation on replacement value | AUFWM | CURR | 13(2) | ANLKWERT | ||||
INVZM | Investment grant for the year | INVZM | CURR | 13(2) | ANLKWERT | ||||
NAFAM | Manually planned ordinary depreciation for the year | NAFAM | CURR | 13(2) | ANLKWERT | ||||
SAFAM | Manual special depreciation planned for the year | SAFAM | CURR | 13(2) | ANLKWERT | ||||
AAFAM | Manual unplanned depreciation for the year | AAFAM | CURR | 13(2) | ANLKWERT | ||||
MAFAM | Manual transfer of reserves for the year | MAFAM | CURR | 13(2) | ANLKWERT | ||||
ZINSM | Manual interest planned for the year | DZINSM | CURR | 13(2) | ANLKWERT | ||||
AUFNM | Manual revaluation of cumulative ordinary depreciation | AUFNM | CURR | 13(2) | ANLKWERT | ||||
ZUSNA | Write-up on ordinary depreciation | DZUSNA | CURR | 13(2) | ANLKWERT | ||||
ZUSSA | Write-up on special depreciation | DZUSSA | CURR | 13(2) | ANLKWERT | ||||
ZUSAA | Write-up on unplanned depreciation | DZUSAA | CURR | 13(2) | ANLKWERT | ||||
ZUSMA | Write-up on transferred reserves | DZUSMA | CURR | 13(2) | ANLKWERT | ||||
AUFWV | Proportional cumulative revaluation on replacement value | AUFWV | CURR | 13(2) | ANLKWERT | ||||
INVZV | Proportional cumulative investment grants | INVZV | CURR | 13(2) | ANLKWERT | ||||
NAFAV | Proportional accumulated ordinary depreciation | NAFAV | CURR | 13(2) | ANLKWERT | ||||
SAFAV | Proportional cumulative special depreciation | SAFAV | CURR | 13(2) | ANLKWERT | ||||
AAFAV | Proportional cumulative unplanned depreciation | AAFAV | CURR | 13(2) | ANLKWERT | ||||
MAFAV | Proportional cumulative transfer of reserves | MAFAV | CURR | 13(2) | ANLKWERT | ||||
AUFNV | Proportional cum. revaluation on ordinary depreciation | AUFNV | CURR | 13(2) | ANLKWERT | ||||
AUFWL | Proportional revaluation for the year on replacement value | AUFWL | CURR | 13(2) | ANLKWERT | ||||
INVZL | Proportional investment grant for the year | INVZL | CURR | 13(2) | ANLKWERT | ||||
NAFAL | Proportional ordinary depreciation for the year | NAFAL | CURR | 13(2) | ANLKWERT | ||||
SAFAL | Proportional special depreciation for the year | SAFAL | CURR | 13(2) | ANLKWERT | ||||
AAFAL | Proportional unplanned depreciation for the year | AAFAL | CURR | 13(2) | ANLKWERT | ||||
MAFAL | Proportional transfer of reserves for the year | MAFAL | CURR | 13(2) | ANLKWERT | ||||
AUFNL | Proportional revaluation of annual ordinary dep. | AUFNL | CURR | 13(2) | ANLKWERT | ||||
ANUPD | Indicator: Type of change to table | ANUPD | CHAR | 1 | ANUPD | ||||
KSANS | Cumulative statistical acquisition value | KSANS | CURR | 13(2) | ANLKWERT | ||||
SANSL | Statistical aquisition value of current year | SANSL | CURR | 13(2) | ANLKWERT | ||||
GJA_AUFW | Cumulative appreciation on replacement value for fiscal year | GJA_AUFW | CURR | 13(2) | ANLKWERT | ||||
GJE_AUFW | Appreciation on replacement value in current year | GJE_AUFW | CURR | 13(2) | ANLKWERT | ||||
GEB_AUFWTG | Posted planned and manual revaluation of replacement value | GEB_AUFWTG | CURR | 13(2) | ANLKWERT | ||||
GJA_KANSW | Asset acquisition value at fiscal year start | GJA_KANSW | CURR | 13(2) | ANLKWERT | ||||
LFD_KANSW | Current asset acquisition value | LFD_KANSW | CURR | 13(2) | ANLKWERT | ||||
GJE_KANSW | Asset acquisition value at end of fiscal year | GJE_KANSW | CURR | 13(2) | ANLKWERT | ||||
GJA_BCHWRT | Asset book value at beginning of fiscal year | GJA_BCHWRT | CURR | 13(2) | ANLKWERT | ||||
LFD_BCHWRT | Current Book Value of Asset | LFD_BCHWRT | CURR | 13(2) | ANLKWERT | ||||
GJE_BCHWRT | Asset net book value at end of fiscal year | GJE_BCHWRT | CURR | 13(2) | ANLKWERT | ||||
GJE_ZUSCHR | Write-up | GJE_ZUSCHR | CURR | 13(2) | ANLKWERT | ||||
GJE_BWGWB | Value adjustments on transactions, at FY end | GJE_BWGWB | CURR | 13(2) | ANLKWERT | ||||
GEB_ABSCHR | Depreciation posted (general) | GEB_ABSCHR | CURR | 13(2) | ANLKWERT | ||||
GEP_ABSCHR | Total depreciation planned | GEP_ABSCHR | CURR | 13(2) | ANLKWERT | ||||
NVG_ABSCHR | Ordinary depreciation: Past | NVG_ABSCHR | CURR | 13(2) | ANLKWERT | ||||
RVG_ABSCHR | Remaining past depreciation (without ordinary depreciation) | RVG_ABSCHR | CURR | 13(2) | ANLKWERT | ||||
RGP_ABSCHR | Remaining depreciation planned (without ordinary dep.) | RGP_ABSCHR | CURR | 13(2) | ANLKWERT | ||||
GJE_INVZ | Investment grant at end of the year | GJE_INVZ | CURR | 13(2) | ANLKWERT | ||||
BEST_GJA | Cumulative acquisition value at FY start (w/o inv.support) | BEST_GJA | CURR | 13(2) | ANLKWERT | ||||
BEST_BEW | Transactions affecting acquisition value (w/o inv. support) | BEST_BEW | CURR | 13(2) | ANLKWERT | ||||
BEST_LFD | Current acquisition value (without investment support) | BEST_LFD | CURR | 13(2) | ANLKWERT | ||||
BEST_GJE | Acquisition value at fiscal year end (w/o inv.support) | BEST_GJE | CURR | 13(2) | ANLKWERT | ||||
ANSW_GJA | Cumulative acquisition value at fiscal year start | ANSW_GJA | CURR | 13(2) | ANLKWERT | ||||
ANSW_BEW | Transactions on the acquisition value | ANSW_BEW | CURR | 13(2) | ANLKWERT | ||||
ANSW_LFD | Current acquisition value | ANSW_LFD | CURR | 13(2) | ANLKWERT | ||||
ANSW_GJE | Acquisition value at fiscal year end | ANSW_GJE | CURR | 13(2) | ANLKWERT | ||||
INV_GJA | Cumulative investment support at fiscal year start | INV_GJA | CURR | 13(2) | ANLKWERT | ||||
INV_BEW | Transactions on investment support | INV_BEW | CURR | 13(2) | ANLKWERT | ||||
INV_ANT | Proportional investment support | INV_ANT | CURR | 13(2) | ANLKWERT | ||||
INV_LFD | Current investment support | INV_LFD | CURR | 13(2) | ANLKWERT | ||||
INV_GJE | Investment support at fiscal year end | INV_GJE | CURR | 13(2) | ANLKWERT | ||||
AUFW_GJA | Cumulative revaluation at fiscal year start | AUFW_GJA | CURR | 13(2) | ANLKWERT | ||||
AUFW_GEP | Planned revaluation | AUFW_GEP | CURR | 13(2) | ANLKWERT | ||||
AUFW_GEB | Revaluation posted | AUFW_GEB | CURR | 13(2) | ANLKWERT | ||||
AUFW_ANT | Proportional revaluation | AUFW_ANT | CURR | 13(2) | ANLKWERT | ||||
AUFW_LFD | Current revaluation | AUFW_LFD | CURR | 13(2) | ANLKWERT | ||||
AUFW_GJE | Revaluation at fiscal year end | AUFW_GJE | CURR | 13(2) | ANLKWERT | ||||
AUFW_LFDP | Revaluation for the current year (with planned values) | AUFW_LFDP | CURR | 13(2) | ANLKWERT | ||||
AUFW_LFDG | Revaluation from the current year (with posted values) | AUFW_LFDG | CURR | 13(2) | ANLKWERT | ||||
RUECK_GJA | Cumulative reserves at fiscal year start | RUECK_GJA | CURR | 13(2) | ANLKWERT | ||||
RUECK_GEP | Planned transfer of reserves | RUECK_GEP | CURR | 13(2) | ANLKWERT | ||||
RUECK_GEB | Posted transfer of reserves | RUECK_GEB | CURR | 13(2) | ANLKWERT | ||||
RUECK_ZUS | Write-up to transferred reserves | RUECK_ZUS | CURR | 13(2) | ANLKWERT | ||||
RUECK_ANT | Proportional values from reserves | RUECK_ANT | CURR | 13(2) | ANLKWERT | ||||
RUECK_LFD | Current reserves | RUECK_LFD | CURR | 13(2) | ANLKWERT | ||||
RUECK_GJE | Transferred reserves at fiscal year end | RUECK_GJE | CURR | 13(2) | ANLKWERT | ||||
RUECK_LFDP | Transferred reserves from current year (w/planned values) | RUECK_LFDP | CURR | 13(2) | ANLKWERT | ||||
RUECK_LFDG | Transferred reserves from current year (w/posted values) | RUECK_LFDG | CURR | 13(2) | ANLKWERT | ||||
NAFA_GJA | Accumulated ordinary depreciation at fiscal year start | NAFA_GJA | CURR | 13(2) | ANLKWERT | ||||
NAFA_GEP | Planned ordinary depreciation | NAFA_GEP | CURR | 13(2) | ANLKWERT | ||||
NAFA_GEB | Ordinary depreciation posted | NAFA_GEB | CURR | 13(2) | ANLKWERT | ||||
NAFA_ZUS | Write-up of ordinary depreciation | NAFA_ZUS | CURR | 13(2) | ANLKWERT | ||||
NAFA_ANT | Proportional ordinary depreciation | NAFA_ANT | CURR | 13(2) | ANLKWERT | ||||
NAFA_LFD | Current ordinary depreciation | NAFA_LFD | CURR | 13(2) | ANLKWERT | ||||
NAFA_GJE | Ordinary depreciation at fiscal year end | NAFA_GJE | CURR | 13(2) | ANLKWERT | ||||
NAFA_LFDP | Ordinary depreciation of the current year(w/ planned values) | NAFA_LFDP | CURR | 13(2) | ANLKWERT | ||||
NAFA_LFDG | Ordinary depreciation for current year (with posted values) | NAFA_LFDG | CURR | 13(2) | ANLKWERT | ||||
RAFA_GJA | Cumulative remaining depreciation fiscal year start | RAFA_GJA | CURR | 13(2) | ANLKWERT | ||||
RAFA_GEP | Planned remaining depreciation | RAFA_GEP | CURR | 13(2) | ANLKWERT | ||||
RAFA_GEB | Remaining depreciation posted | RAFA_GEB | CURR | 13(2) | ANLKWERT | ||||
RAFA_ZUS | Write-up to remaining depreciation | RAFA_ZUS | CURR | 13(2) | ANLKWERT | ||||
RAFA_ANT | Proportional remaining depreciation | RAFA_ANT | CURR | 13(2) | ANLKWERT | ||||
RAFA_LFD | Current remaining depreciation | RAFA_LFD | CURR | 13(2) | ANLKWERT | ||||
RAFA_GJE | Remaining depreciation at fiscal year end | RAFA_GJE | CURR | 13(2) | ANLKWERT | ||||
RAFA_LFDP | Remaining depreciation for the current year (w/planned val.) | RAFA_LFDP | CURR | 13(2) | ANLKWERT | ||||
RAFA_LFDG | Remaining depreciation for current year (with posted values) | RAFA_LFDG | CURR | 13(2) | ANLKWERT | ||||
AFA_GJA | Accumulated depreciation at fiscal year start | AFA_GJA | CURR | 13(2) | ANLKWERT | ||||
AFA_GEP | Planned depreciation | AFA_GEP | CURR | 13(2) | ANLKWERT | ||||
AFA_GEB | Depreciation posted | AFA_GEB | CURR | 13(2) | ANLKWERT | ||||
AFA_ZUS | Write-up to depreciation | AFA_ZUS | CURR | 13(2) | ANLKWERT | ||||
AFA_ANT | Proportional depreciation | AFA_ANT | CURR | 13(2) | ANLKWERT | ||||
AFA_LFD | Current depreciation | AFA_LFD | CURR | 13(2) | ANLKWERT | ||||
AFA_GJE | Depreciation at fiscal year end | AFA_GJE | CURR | 13(2) | ANLKWERT | ||||
AFA_LFDP | Depreciation for the current year (with planned values) | AFA_LFDP | CURR | 13(2) | ANLKWERT | ||||
AFA_LFDG | Ordinary depreciation for current year (with posted values) | AFA_LFDG | CURR | 13(2) | ANLKWERT | ||||
SZINS_GJA | Cumulative interest at fiscal year start | SZINS_GJA | CURR | 13(2) | ANLKWERT | ||||
SZINS_GEP | Interest planned | SZINS_GEP | CURR | 13(2) | ANLKWERT | ||||
SZINS_GEB | Interest posted | SZINS_GEB | CURR | 13(2) | ANLKWERT | ||||
SZINS_LFD | Current interest | SZINS_LFD | CURR | 13(2) | ANLKWERT | ||||
SZINS_GJE | Interest at fiscal year end | SZINS_GJE | CURR | 13(2) | ANLKWERT | ||||
SZINS_LFDP | Current interest | SZINS_LFD | CURR | 13(2) | ANLKWERT | ||||
SZINS_LFDG | Current interest | SZINS_LFD | CURR | 13(2) | ANLKWERT | ||||
BACKL_GJA | Cumulative revaluation of ordinary depreciation | BACKL_GJA | CURR | 13(2) | ANLKWERT | ||||
BACKL_GEP | Planned revaluation of accumulated ordinary depreciation | BACKL_GEP | CURR | 13(2) | ANLKWERT | ||||
BACKL_GEB | Posted revaluation of accumulated ordinary depreciation | BACKL_GEB | CURR | 13(2) | ANLKWERT | ||||
BACKL_LFD | Current cumulative revaluation of ordinary depreciation | BACKL_LFD | CURR | 13(2) | ANLKWERT | ||||
BACKL_GJE | Cum. revaluation of ord. depreciation at fiscal year end | BACKL_GJE | CURR | 13(2) | ANLKWERT | ||||
BACKL_LFDG | Current cumulative revaluation of ordinary depreciation | BACKL_LFD | CURR | 13(2) | ANLKWERT | ||||
BACKL_LFDP | Current cumulative revaluation of ordinary depreciation | BACKL_LFD | CURR | 13(2) | ANLKWERT | ||||
BCHWRT_GJA | Book value at fiscal year start | BCHWRT_GJA | CURR | 13(2) | ANLKWERT | ||||
BCHWRT_LFD | Current book value | BCHWRT_LFD | CURR | 13(2) | ANLKWERT | ||||
BCHWRT_GJE | Book value at fiscal year end | BCHWRT_GJE | CURR | 13(2) | ANLKWERT | ||||
PERAF | Depreciation calculation period | PERAF | NUMC | 3 | PERAF | ||||
AMORT | Depreciation posted (general) | GEB_ABSCHR | CURR | 13(2) | ANLKWERT | ||||
OSTAT | Asset book value at beginning of fiscal year | GJA_BCHWRT | CURR | 13(2) | ANLKWERT |
Key field | Non-key field |
How do I retrieve data from SAP structure J_3RANLCV using ABAP code?
As J_3RANLCV 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 J_3RANLCV as there is no data to select.How to access SAP table J_3RANLCV
Within an ECC or HANA version of SAP you can also view further information about J_3RANLCV 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