I_AstBalDeprOvrDeprComprnDSt
ABS Depreciation Comparison Dst
I_AstBalDeprOvrDeprComprnDSt is a Basic CDS View that provides data about "ABS Depreciation Comparison Dst" in SAP S/4HANA. It reads from 1 data source (iastbaldedsttab) and exposes 161 fields with key fields docid, version. Part of development package UI_FIN_AA_RBOOKLET_A1.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| iastbaldedsttab | iastbaldedsttab | from |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| EndUserText.label | ABS Depreciation Comparison Dst | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DOCUMENT_STORE | view | |
| Analytics.dataCategory | #DOCSTORE | view | |
| Analytics.document.serviceClassName | CL_CELL_COMMENT_GENERIC_HDLR | view | |
| Analytics.technicalName | IAstBalDeprOvrDeprComprDST | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (161)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | docid | docid | Snapshot ID | |
| KEY | version | version | XML Vers. | |
| doctag | doctag | |||
| docqprov | docqprov | |||
| tra_00001 | tra_00001 | |||
| sva_00001 | sva_00001 | |||
| tra_00002 | tra_00002 | |||
| sva_00002 | sva_00002 | |||
| tra_00003 | tra_00003 | |||
| sva_00003 | sva_00003 | |||
| tra_00004 | tra_00004 | |||
| sva_00004 | sva_00004 | |||
| tra_00005 | tra_00005 | |||
| sva_00005 | sva_00005 | |||
| tra_00006 | tra_00006 | |||
| sva_00006 | sva_00006 | |||
| tra_00007 | tra_00007 | |||
| sva_00007 | sva_00007 | |||
| tra_grantid | tra_grantid | |||
| sva_grantid | sva_grantid | |||
| tra_00008 | tra_00008 | |||
| sva_00008 | sva_00008 | |||
| svh_00008 | svh_00008 | |||
| hnm_00008 | hnm_00008 | |||
| hno_00008 | hno_00008 | |||
| hio_00008 | hio_00008 | |||
| tra_00009 | tra_00009 | |||
| sva_00009 | sva_00009 | |||
| tra_country | tra_country | |||
| sva_country | sva_country | |||
| tra_ledger | tra_ledger | |||
| sva_ledger | sva_ledger | |||
| tra_00010 | tra_00010 | |||
| sva_00010 | sva_00010 | |||
| tra_00011 | tra_00011 | |||
| sva_00011 | sva_00011 | |||
| tra_00012 | tra_00012 | |||
| sva_00012 | sva_00012 | |||
| tra_00013 | tra_00013 | |||
| sva_00013 | sva_00013 | |||
| tra_00014 | tra_00014 | |||
| sva_00014 | sva_00014 | |||
| tra_00015 | tra_00015 | |||
| sva_00015 | sva_00015 | |||
| svh_00015 | svh_00015 | |||
| hnm_00015 | hnm_00015 | |||
| hno_00015 | hno_00015 | |||
| hio_00015 | hio_00015 | |||
| tra_00016 | tra_00016 | |||
| sva_00016 | sva_00016 | |||
| tra_00017 | tra_00017 | |||
| sva_00017 | sva_00017 | |||
| tra_00018 | tra_00018 | |||
| sva_00018 | sva_00018 | |||
| tra_00019 | tra_00019 | |||
| sva_00019 | sva_00019 | |||
| svh_00019 | svh_00019 | |||
| hnm_00019 | hnm_00019 | |||
| hno_00019 | hno_00019 | |||
| hio_00019 | hio_00019 | |||
| tra_00020 | tra_00020 | |||
| sva_00020 | sva_00020 | |||
| tra_00021 | tra_00021 | |||
| sva_00021 | sva_00021 | |||
| tra_segment | tra_segment | |||
| sva_segment | sva_segment | |||
| tra_00022 | tra_00022 | |||
| sva_00022 | sva_00022 | |||
| tra_00023 | tra_00023 | |||
| sva_00023 | sva_00023 | |||
| tra_00024 | tra_00024 | |||
| sva_00024 | sva_00024 | |||
| tra_00025 | tra_00025 | |||
| sva_00025 | sva_00025 | |||
| tra_supplier | tra_supplier | |||
| sva_supplier | sva_supplier | |||
| tra_00026 | tra_00026 | |||
| sva_00026 | sva_00026 | |||
| tra_00027 | tra_00027 | |||
| sva_00027 | sva_00027 | |||
| svh_00027 | svh_00027 | |||
| hnm_00027 | hnm_00027 | |||
| hno_00027 | hno_00027 | |||
| hio_00027 | hio_00027 | |||
| tra_00028 | tra_00028 | |||
| sva_00028 | sva_00028 | |||
| tra_00029 | tra_00029 | |||
| sva_00029 | sva_00029 | |||
| tra_00030 | tra_00030 | |||
| sva_00030 | sva_00030 | |||
| svh_00030 | svh_00030 | |||
| hnm_00030 | hnm_00030 | |||
| hno_00030 | hno_00030 | |||
| hio_00030 | hio_00030 | |||
| tra_00031 | tra_00031 | |||
| sva_00031 | sva_00031 | |||
| svh_00031 | svh_00031 | |||
| hnm_00031 | hnm_00031 | |||
| hno_00031 | hno_00031 | |||
| hio_00031 | hio_00031 | |||
| tra_00032 | tra_00032 | |||
| sva_00032 | sva_00032 | |||
| tra_00033 | tra_00033 | |||
| sva_00033 | sva_00033 | |||
| tra_00034 | tra_00034 | |||
| sva_00034 | sva_00034 | |||
| tra_00035 | tra_00035 | |||
| sva_00035 | sva_00035 | |||
| tra_00036 | tra_00036 | |||
| sva_00036 | sva_00036 | |||
| tra_fund | tra_fund | |||
| sva_fund | sva_fund | |||
| tra_00037 | tra_00037 | |||
| sva_00037 | sva_00037 | |||
| tra_00038 | tra_00038 | |||
| sva_00038 | sva_00038 | |||
| tra_00039 | tra_00039 | |||
| sva_00039 | sva_00039 | |||
| tra_baseunit | tra_baseunit | |||
| sva_baseunit | sva_baseunit | |||
| tra_00040 | tra_00040 | |||
| sva_00040 | sva_00040 | |||
| tra_00041 | tra_00041 | |||
| sva_00041 | sva_00041 | |||
| tra_00042 | tra_00042 | |||
| sva_00042 | sva_00042 | |||
| tra_00043 | tra_00043 | |||
| sva_00043 | sva_00043 | |||
| svh_00043 | svh_00043 | |||
| hnm_00043 | hnm_00043 | |||
| hno_00043 | hno_00043 | |||
| hio_00043 | hio_00043 | |||
| tra_room | tra_room | |||
| sva_room | sva_room | |||
| tra_00044 | tra_00044 | |||
| sva_00044 | sva_00044 | |||
| tra_00045 | tra_00045 | |||
| sva_00045 | sva_00045 | |||
| tra_00046 | tra_00046 | |||
| sva_00046 | sva_00046 | |||
| tra_00047 | tra_00047 | |||
| sva_00047 | sva_00047 | |||
| tra_00048 | tra_00048 | |||
| sva_00048 | sva_00048 | |||
| tra_00049 | tra_00049 | |||
| sva_00049 | sva_00049 | |||
| svh_00049 | svh_00049 | |||
| hnm_00049 | hnm_00049 | |||
| hno_00049 | hno_00049 | |||
| hio_00049 | hio_00049 | |||
| doctype | doctype | TSW Document type | ||
| owner | owner | Vehicle Owner | ||
| infoprov | infoprov | InfoProvider | ||
| sva_infoprov | sva_infoprov | |||
| kyfnm | kyfnm | Key figure | ||
| docstat | docstat | Nt.doc status | ||
| session_id | session_id | Transaction ID | ||
| timestamp | timestamp | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| document | document | Sales Document | ||
| seldr | seldr | |||
| docprop | docprop |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view I_AstBalDeprOvrDeprComprnDSt.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW I_AstBalDeprOvrDeprComprnDSt AS
SELECT
docid,
version,
doctag,
docqprov,
tra_00001,
sva_00001,
tra_00002,
sva_00002,
tra_00003,
sva_00003,
tra_00004,
sva_00004,
tra_00005,
sva_00005,
tra_00006,
sva_00006,
tra_00007,
sva_00007,
tra_grantid,
sva_grantid,
tra_00008,
sva_00008,
svh_00008,
hnm_00008,
hno_00008,
hio_00008,
tra_00009,
sva_00009,
tra_country,
sva_country,
tra_ledger,
sva_ledger,
tra_00010,
sva_00010,
tra_00011,
sva_00011,
tra_00012,
sva_00012,
tra_00013,
sva_00013,
tra_00014,
sva_00014,
tra_00015,
sva_00015,
svh_00015,
hnm_00015,
hno_00015,
hio_00015,
tra_00016,
sva_00016,
tra_00017,
sva_00017,
tra_00018,
sva_00018,
tra_00019,
sva_00019,
svh_00019,
hnm_00019,
hno_00019,
hio_00019,
tra_00020,
sva_00020,
tra_00021,
sva_00021,
tra_segment,
sva_segment,
tra_00022,
sva_00022,
tra_00023,
sva_00023,
tra_00024,
sva_00024,
tra_00025,
sva_00025,
tra_supplier,
sva_supplier,
tra_00026,
sva_00026,
tra_00027,
sva_00027,
svh_00027,
hnm_00027,
hno_00027,
hio_00027,
tra_00028,
sva_00028,
tra_00029,
sva_00029,
tra_00030,
sva_00030,
svh_00030,
hnm_00030,
hno_00030,
hio_00030,
tra_00031,
sva_00031,
svh_00031,
hnm_00031,
hno_00031,
hio_00031,
tra_00032,
sva_00032,
tra_00033,
sva_00033,
tra_00034,
sva_00034,
tra_00035,
sva_00035,
tra_00036,
sva_00036,
tra_fund,
sva_fund,
tra_00037,
sva_00037,
tra_00038,
sva_00038,
tra_00039,
sva_00039,
tra_baseunit,
sva_baseunit,
tra_00040,
sva_00040,
tra_00041,
sva_00041,
tra_00042,
sva_00042,
tra_00043,
sva_00043,
svh_00043,
hnm_00043,
hno_00043,
hio_00043,
tra_room,
sva_room,
tra_00044,
sva_00044,
tra_00045,
sva_00045,
tra_00046,
sva_00046,
tra_00047,
sva_00047,
tra_00048,
sva_00048,
tra_00049,
sva_00049,
svh_00049,
hnm_00049,
hno_00049,
hio_00049,
doctype,
owner,
infoprov,
sva_infoprov,
kyfnm,
docstat,
session_id,
timestamp,
document,
seldr,
docprop
FROM iastbaldedsttab
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA