I_AstBalDeprOvrDeprComprnDSt

DDL: I_ASTBALDEPROVRDEPRCOMPRNDST Type: view_entity BASIC Package: UI_FIN_AA_RBOOKLET_A1

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)

SourceAliasJoin Type
iastbaldedsttab iastbaldedsttab from

Annotations (11)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
;