IASTBALDEDSTTAB
Table for View:I_AstBalDeprOvrDeprComprnDst
IASTBALDEDSTTAB is an SAP database table in S/4HANA. Table for View:I_AstBalDeprOvrDeprComprnDst. It contains 208 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AstBalDeprOvrDeprComprnDSt | view_entity | from | BASIC | ABS Depreciation Comparison Dst |
Fields (208)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | client | abap.clnt | |
| KEY | docid | abap.numc | |
| KEY | version | abap.numc | |
| doctag | abap.char | ||
| docqprov | abap.char | ||
| tra_00001 | abap.numc | ||
| sva_00001 | abap.char | ||
| tra_00002 | abap.char | ||
| sva_00002 | abap.char | ||
| tra_00003 | abap.char | ||
| sva_00003 | abap.char | ||
| tra_00004 | abap.numc | ||
| sva_00004 | abap.char | ||
| tra_00005 | abap.numc | ||
| sva_00005 | abap.char | ||
| tra_00006 | abap.numc | ||
| sva_00006 | abap.char | ||
| tra_00007 | abap.numc | ||
| sva_00007 | abap.char | ||
| tra_assetplant | abap.char | ||
| sva_assetplant | abap.char | ||
| tra_grantid | abap.char | ||
| sva_grantid | abap.char | ||
| tra_00008 | abap.dats | ||
| sva_00008 | abap.char | ||
| svh_00008 | abap.char | ||
| hnm_00008 | abap.char | ||
| hno_00008 | abap.char | ||
| hio_00008 | abap.char | ||
| tra_00009 | abap.numc | ||
| sva_00009 | abap.char | ||
| tra_country | abap.char | ||
| sva_country | abap.char | ||
| tra_ledger | abap.char | ||
| sva_ledger | abap.char | ||
| tra_00010 | abap.char | ||
| sva_00010 | abap.char | ||
| tra_00011 | abap.char | ||
| sva_00011 | abap.char | ||
| tra_00012 | abap.char | ||
| sva_00012 | abap.char | ||
| tra_fixedasset | abap.char | ||
| sva_fixedasset | abap.char | ||
| tra_00013 | abap.char | ||
| sva_00013 | abap.char | ||
| tra_00014 | abap.char | ||
| sva_00014 | abap.char | ||
| tra_fiscalyear | abap.numc | ||
| sva_fiscalyear | abap.char | ||
| tra_00015 | abap.char | ||
| sva_00015 | abap.char | ||
| svh_00015 | abap.char | ||
| hnm_00015 | abap.char | ||
| hno_00015 | abap.char | ||
| hio_00015 | abap.char | ||
| tra_00016 | abap.char | ||
| sva_00016 | abap.char | ||
| tra_00017 | abap.numc | ||
| sva_00017 | abap.char | ||
| tra_costcenter | abap.char | ||
| sva_costcenter | abap.char | ||
| tra_00018 | abap.cuky | ||
| sva_00018 | abap.char | ||
| tra_00019 | abap.dats | ||
| sva_00019 | abap.char | ||
| svh_00019 | abap.char | ||
| hnm_00019 | abap.char | ||
| hno_00019 | abap.char | ||
| hio_00019 | abap.char | ||
| tra_00020 | abap.numc | ||
| sva_00020 | abap.char | ||
| tra_assetfund | abap.char | ||
| sva_assetfund | abap.char | ||
| tra_00021 | abap.numc | ||
| sva_00021 | abap.char | ||
| tra_profitcenter | abap.char | ||
| sva_profitcenter | abap.char | ||
| tra_segment | abap.char | ||
| sva_segment | abap.char | ||
| tra_00022 | abap.char | ||
| sva_00022 | abap.char | ||
| tra_p_fiscalyear | abap.numc | ||
| sva_p_fiscalyear | abap.char | ||
| tra_postingdate | abap.dats | ||
| sva_postingdate | abap.char | ||
| svh_postingdate | abap.char | ||
| hnm_postingdate | abap.char | ||
| hno_postingdate | abap.char | ||
| hio_postingdate | abap.char | ||
| tra_00023 | abap.char | ||
| sva_00023 | abap.char | ||
| tra_00024 | abap.char | ||
| sva_00024 | abap.char | ||
| tra_assetlocation | abap.char | ||
| sva_assetlocation | abap.char | ||
| tra_00025 | abap.char | ||
| sva_00025 | abap.char | ||
| tra_supplier | abap.char | ||
| sva_supplier | abap.char | ||
| tra_companycode | abap.char | ||
| sva_companycode | abap.char | ||
| tra_fiscalperiod | abap.numc | ||
| sva_fiscalperiod | abap.char | ||
| tra_00026 | abap.char | ||
| sva_00026 | abap.char | ||
| tra_00027 | abap.dats | ||
| sva_00027 | abap.char | ||
| svh_00027 | abap.char | ||
| hnm_00027 | abap.char | ||
| hno_00027 | abap.char | ||
| hio_00027 | abap.char | ||
| tra_00028 | abap.char | ||
| sva_00028 | abap.char | ||
| tra_00029 | abap.char | ||
| sva_00029 | abap.char | ||
| tra_assetgrant | abap.char | ||
| sva_assetgrant | abap.char | ||
| tra_glaccount | abap.char | ||
| sva_glaccount | abap.char | ||
| tra_00030 | abap.dats | ||
| sva_00030 | abap.char | ||
| svh_00030 | abap.char | ||
| hnm_00030 | abap.char | ||
| hno_00030 | abap.char | ||
| hio_00030 | abap.char | ||
| tra_fundscenter | abap.char | ||
| sva_fundscenter | abap.char | ||
| tra_p_fiscalperiod | abap.numc | ||
| sva_p_fiscalperiod | abap.char | ||
| tra_00031 | abap.dats | ||
| sva_00031 | abap.char | ||
| svh_00031 | abap.char | ||
| hnm_00031 | abap.char | ||
| hno_00031 | abap.char | ||
| hio_00031 | abap.char | ||
| tra_00032 | abap.char | ||
| sva_00032 | abap.char | ||
| tra_00033 | abap.char | ||
| sva_00033 | abap.char | ||
| tra_00034 | abap.char | ||
| sva_00034 | abap.char | ||
| tra_functionalarea | abap.char | ||
| sva_functionalarea | abap.char | ||
| tra_00035 | abap.char | ||
| sva_00035 | abap.char | ||
| tra_00036 | abap.char | ||
| sva_00036 | abap.char | ||
| tra_fund | abap.char | ||
| sva_fund | abap.char | ||
| tra_00037 | abap.numc | ||
| sva_00037 | abap.char | ||
| tra_00038 | abap.char | ||
| sva_00038 | abap.char | ||
| tra_00039 | abap.numc | ||
| sva_00039 | abap.char | ||
| tra_creationtime | abap.tims | ||
| sva_creationtime | abap.char | ||
| tra_baseunit | abap.unit | ||
| sva_baseunit | abap.char | ||
| tra_00040 | abap.char | ||
| sva_00040 | abap.char | ||
| tra_00041 | abap.char | ||
| sva_00041 | abap.char | ||
| tra_00042 | abap.char | ||
| sva_00042 | abap.char | ||
| tra_00043 | abap.dats | ||
| sva_00043 | abap.char | ||
| svh_00043 | abap.char | ||
| hnm_00043 | abap.char | ||
| hno_00043 | abap.char | ||
| hio_00043 | abap.char | ||
| tra_room | abap.char | ||
| sva_room | abap.char | ||
| tra_currencyrole | abap.char | ||
| sva_currencyrole | abap.char | ||
| tra_assetsegment | abap.char | ||
| sva_assetsegment | abap.char | ||
| tra_00044 | abap.char | ||
| sva_00044 | abap.char | ||
| tra_inventory | abap.char | ||
| sva_inventory | abap.char | ||
| tra_00045 | abap.char | ||
| sva_00045 | abap.char | ||
| tra_00046 | abap.char | ||
| sva_00046 | abap.char | ||
| tra_00047 | abap.char | ||
| sva_00047 | abap.char | ||
| tra_00048 | abap.char | ||
| sva_00048 | abap.char | ||
| tra_00049 | abap.dats | ||
| sva_00049 | abap.char | ||
| svh_00049 | abap.char | ||
| hnm_00049 | abap.char | ||
| hno_00049 | abap.char | ||
| hio_00049 | abap.char | ||
| tra_assetclass | abap.char | ||
| sva_assetclass | abap.char | ||
| doctype | abap.char | ||
| owner | abap.char | ||
| infoprov | abap.char | ||
| sva_infoprov | abap.char | ||
| kyfnm | abap.char | ||
| docstat | abap.char | ||
| session_id | abap.char | ||
| timestamp | abap.dec | ||
| document | abap.rawstring | ||
| seldr | abap.rawstring | ||
| docprop | abap.rawstring |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Table for View:I_AstBalDeprOvrDeprComprnDst
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IASTBALDEDSTTAB (
CLIENT, -- abap.clnt
DOCID, -- abap.numc
VERSION, -- abap.numc
DOCTAG, -- abap.char
DOCQPROV, -- abap.char
TRA_00001, -- abap.numc
SVA_00001, -- abap.char
TRA_00002, -- abap.char
SVA_00002, -- abap.char
TRA_00003, -- abap.char
SVA_00003, -- abap.char
TRA_00004, -- abap.numc
SVA_00004, -- abap.char
TRA_00005, -- abap.numc
SVA_00005, -- abap.char
TRA_00006, -- abap.numc
SVA_00006, -- abap.char
TRA_00007, -- abap.numc
SVA_00007, -- abap.char
TRA_ASSETPLANT, -- abap.char
SVA_ASSETPLANT, -- abap.char
TRA_GRANTID, -- abap.char
SVA_GRANTID, -- abap.char
TRA_00008, -- abap.dats
SVA_00008, -- abap.char
SVH_00008, -- abap.char
HNM_00008, -- abap.char
HNO_00008, -- abap.char
HIO_00008, -- abap.char
TRA_00009, -- abap.numc
SVA_00009, -- abap.char
TRA_COUNTRY, -- abap.char
SVA_COUNTRY, -- abap.char
TRA_LEDGER, -- abap.char
SVA_LEDGER, -- abap.char
TRA_00010, -- abap.char
SVA_00010, -- abap.char
TRA_00011, -- abap.char
SVA_00011, -- abap.char
TRA_00012, -- abap.char
SVA_00012, -- abap.char
TRA_FIXEDASSET, -- abap.char
SVA_FIXEDASSET, -- abap.char
TRA_00013, -- abap.char
SVA_00013, -- abap.char
TRA_00014, -- abap.char
SVA_00014, -- abap.char
TRA_FISCALYEAR, -- abap.numc
SVA_FISCALYEAR, -- abap.char
TRA_00015, -- abap.char
SVA_00015, -- abap.char
SVH_00015, -- abap.char
HNM_00015, -- abap.char
HNO_00015, -- abap.char
HIO_00015, -- abap.char
TRA_00016, -- abap.char
SVA_00016, -- abap.char
TRA_00017, -- abap.numc
SVA_00017, -- abap.char
TRA_COSTCENTER, -- abap.char
SVA_COSTCENTER, -- abap.char
TRA_00018, -- abap.cuky
SVA_00018, -- abap.char
TRA_00019, -- abap.dats
SVA_00019, -- abap.char
SVH_00019, -- abap.char
HNM_00019, -- abap.char
HNO_00019, -- abap.char
HIO_00019, -- abap.char
TRA_00020, -- abap.numc
SVA_00020, -- abap.char
TRA_ASSETFUND, -- abap.char
SVA_ASSETFUND, -- abap.char
TRA_00021, -- abap.numc
SVA_00021, -- abap.char
TRA_PROFITCENTER, -- abap.char
SVA_PROFITCENTER, -- abap.char
TRA_SEGMENT, -- abap.char
SVA_SEGMENT, -- abap.char
TRA_00022, -- abap.char
SVA_00022, -- abap.char
TRA_P_FISCALYEAR, -- abap.numc
SVA_P_FISCALYEAR, -- abap.char
TRA_POSTINGDATE, -- abap.dats
SVA_POSTINGDATE, -- abap.char
SVH_POSTINGDATE, -- abap.char
HNM_POSTINGDATE, -- abap.char
HNO_POSTINGDATE, -- abap.char
HIO_POSTINGDATE, -- abap.char
TRA_00023, -- abap.char
SVA_00023, -- abap.char
TRA_00024, -- abap.char
SVA_00024, -- abap.char
TRA_ASSETLOCATION, -- abap.char
SVA_ASSETLOCATION, -- abap.char
TRA_00025, -- abap.char
SVA_00025, -- abap.char
TRA_SUPPLIER, -- abap.char
SVA_SUPPLIER, -- abap.char
TRA_COMPANYCODE, -- abap.char
SVA_COMPANYCODE, -- abap.char
TRA_FISCALPERIOD, -- abap.numc
SVA_FISCALPERIOD, -- abap.char
TRA_00026, -- abap.char
SVA_00026, -- abap.char
TRA_00027, -- abap.dats
SVA_00027, -- abap.char
SVH_00027, -- abap.char
HNM_00027, -- abap.char
HNO_00027, -- abap.char
HIO_00027, -- abap.char
TRA_00028, -- abap.char
SVA_00028, -- abap.char
TRA_00029, -- abap.char
SVA_00029, -- abap.char
TRA_ASSETGRANT, -- abap.char
SVA_ASSETGRANT, -- abap.char
TRA_GLACCOUNT, -- abap.char
SVA_GLACCOUNT, -- abap.char
TRA_00030, -- abap.dats
SVA_00030, -- abap.char
SVH_00030, -- abap.char
HNM_00030, -- abap.char
HNO_00030, -- abap.char
HIO_00030, -- abap.char
TRA_FUNDSCENTER, -- abap.char
SVA_FUNDSCENTER, -- abap.char
TRA_P_FISCALPERIOD, -- abap.numc
SVA_P_FISCALPERIOD, -- abap.char
TRA_00031, -- abap.dats
SVA_00031, -- abap.char
SVH_00031, -- abap.char
HNM_00031, -- abap.char
HNO_00031, -- abap.char
HIO_00031, -- abap.char
TRA_00032, -- abap.char
SVA_00032, -- abap.char
TRA_00033, -- abap.char
SVA_00033, -- abap.char
TRA_00034, -- abap.char
SVA_00034, -- abap.char
TRA_FUNCTIONALAREA, -- abap.char
SVA_FUNCTIONALAREA, -- abap.char
TRA_00035, -- abap.char
SVA_00035, -- abap.char
TRA_00036, -- abap.char
SVA_00036, -- abap.char
TRA_FUND, -- abap.char
SVA_FUND, -- abap.char
TRA_00037, -- abap.numc
SVA_00037, -- abap.char
TRA_00038, -- abap.char
SVA_00038, -- abap.char
TRA_00039, -- abap.numc
SVA_00039, -- abap.char
TRA_CREATIONTIME, -- abap.tims
SVA_CREATIONTIME, -- abap.char
TRA_BASEUNIT, -- abap.unit
SVA_BASEUNIT, -- abap.char
TRA_00040, -- abap.char
SVA_00040, -- abap.char
TRA_00041, -- abap.char
SVA_00041, -- abap.char
TRA_00042, -- abap.char
SVA_00042, -- abap.char
TRA_00043, -- abap.dats
SVA_00043, -- abap.char
SVH_00043, -- abap.char
HNM_00043, -- abap.char
HNO_00043, -- abap.char
HIO_00043, -- abap.char
TRA_ROOM, -- abap.char
SVA_ROOM, -- abap.char
TRA_CURRENCYROLE, -- abap.char
SVA_CURRENCYROLE, -- abap.char
TRA_ASSETSEGMENT, -- abap.char
SVA_ASSETSEGMENT, -- abap.char
TRA_00044, -- abap.char
SVA_00044, -- abap.char
TRA_INVENTORY, -- abap.char
SVA_INVENTORY, -- abap.char
TRA_00045, -- abap.char
SVA_00045, -- abap.char
TRA_00046, -- abap.char
SVA_00046, -- abap.char
TRA_00047, -- abap.char
SVA_00047, -- abap.char
TRA_00048, -- abap.char
SVA_00048, -- abap.char
TRA_00049, -- abap.dats
SVA_00049, -- abap.char
SVH_00049, -- abap.char
HNM_00049, -- abap.char
HNO_00049, -- abap.char
HIO_00049, -- abap.char
TRA_ASSETCLASS, -- abap.char
SVA_ASSETCLASS, -- abap.char
DOCTYPE, -- abap.char
OWNER, -- abap.char
INFOPROV, -- abap.char
SVA_INFOPROV, -- abap.char
KYFNM, -- abap.char
DOCSTAT, -- abap.char
SESSION_ID, -- abap.char
TIMESTAMP, -- abap.dec
DOCUMENT, -- abap.rawstring
SELDR, -- abap.rawstring
DOCPROP, -- abap.rawstring
PRIMARY KEY (CLIENT, DOCID, VERSION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA