I_PubSecBdgtLineItemDSt

DDL: I_PUBSECBDGTLINEITEMDST Type: view_entity BASIC Package: ODATA_PSM_S4C_FM_REPORTING

Budget Line Items Doc Store

I_PubSecBdgtLineItemDSt is a Basic CDS View that provides data about "Budget Line Items Doc Store" in SAP S/4HANA. It reads from 1 data source (ipubsecbddsttab) and exposes 279 fields with key fields docid, version. Part of development package ODATA_PSM_S4C_FM_REPORTING.

Data Sources (1)

SourceAliasJoin Type
ipubsecbddsttab ipubsecbddsttab from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Budget Line Items Doc Store view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
Analytics.dataCategory #DOCSTORE view
Analytics.document.serviceClassName CL_CELL_COMMENT_GENERIC_HDLR view

Fields (279)

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
svh_00001 svh_00001
hnm_00001 hnm_00001
hno_00001 hno_00001
hio_00001 hio_00001
tra_00002 tra_00002
sva_00002 sva_00002
svh_00002 svh_00002
hnm_00002 hnm_00002
hno_00002 hno_00002
hio_00002 hio_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
svh_00006 svh_00006
hnm_00006 hnm_00006
hno_00006 hno_00006
hio_00006 hio_00006
tra_00007 tra_00007
sva_00007 sva_00007
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
svh_00009 svh_00009
hnm_00009 hnm_00009
hno_00009 hno_00009
hio_00009 hio_00009
tra_00010 tra_00010
sva_00010 sva_00010
svh_00010 svh_00010
hnm_00010 hnm_00010
hno_00010 hno_00010
hio_00010 hio_00010
tra_00011 tra_00011
sva_00011 sva_00011
svh_00011 svh_00011
hnm_00011 hnm_00011
hno_00011 hno_00011
hio_00011 hio_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
tra_00016 tra_00016
sva_00016 sva_00016
svh_00016 svh_00016
hnm_00016 hnm_00016
hno_00016 hno_00016
hio_00016 hio_00016
tra_00017 tra_00017
sva_00017 sva_00017
tra_customer tra_customer
sva_customer sva_customer
svh_customer svh_customer
hnm_customer hnm_customer
hno_customer hno_customer
hio_customer hio_customer
tra_fund tra_fund
sva_fund sva_fund
svh_fund svh_fund
hnm_fund hnm_fund
hno_fund hno_fund
hio_fund hio_fund
tra_fundtype tra_fundtype
sva_fundtype sva_fundtype
tra_grantid tra_grantid
sva_grantid sva_grantid
svh_grantid svh_grantid
hnm_grantid hnm_grantid
hno_grantid hno_grantid
hio_grantid hio_grantid
tra_ledger tra_ledger
sva_ledger sva_ledger
tra_orderid tra_orderid
sva_orderid sva_orderid
svh_orderid svh_orderid
hnm_orderid hnm_orderid
hno_orderid hno_orderid
hio_orderid hio_orderid
tra_plant tra_plant
sva_plant sva_plant
svh_plant svh_plant
hnm_plant hnm_plant
hno_plant hno_plant
hio_plant hio_plant
tra_product tra_product
sva_product sva_product
svh_product svh_product
hnm_product hnm_product
hno_product hno_product
hio_product hio_product
tra_segment tra_segment
sva_segment sva_segment
svh_segment svh_segment
hnm_segment hnm_segment
hno_segment hno_segment
hio_segment hio_segment
tra_workitem tra_workitem
sva_workitem sva_workitem
tra_00018 tra_00018
sva_00018 sva_00018
svh_00018 svh_00018
hnm_00018 hnm_00018
hno_00018 hno_00018
hio_00018 hio_00018
tra_00019 tra_00019
sva_00019 sva_00019
tra_00020 tra_00020
sva_00020 sva_00020
tra_00021 tra_00021
sva_00021 sva_00021
svh_00021 svh_00021
hnm_00021 hnm_00021
hno_00021 hno_00021
hio_00021 hio_00021
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_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
svh_00029 svh_00029
hnm_00029 hnm_00029
hno_00029 hno_00029
hio_00029 hio_00029
tra_00030 tra_00030
sva_00030 sva_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
svh_00033 svh_00033
hnm_00033 hnm_00033
hno_00033 hno_00033
hio_00033 hio_00033
tra_00034 tra_00034
sva_00034 sva_00034
svh_00034 svh_00034
hnm_00034 hnm_00034
hno_00034 hno_00034
hio_00034 hio_00034
tra_00035 tra_00035
sva_00035 sva_00035
tra_00036 tra_00036
sva_00036 sva_00036
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_00040 tra_00040
sva_00040 sva_00040
svh_00040 svh_00040
hnm_00040 hnm_00040
hno_00040 hno_00040
hio_00040 hio_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
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
svh_00047 svh_00047
hnm_00047 hnm_00047
hno_00047 hno_00047
hio_00047 hio_00047
tra_00048 tra_00048
sva_00048 sva_00048
tra_00049 tra_00049
sva_00049 sva_00049
tra_00050 tra_00050
sva_00050 sva_00050
tra_00051 tra_00051
sva_00051 sva_00051
tra_00052 tra_00052
sva_00052 sva_00052
svh_00052 svh_00052
hnm_00052 hnm_00052
hno_00052 hno_00052
hio_00052 hio_00052
tra_00053 tra_00053
sva_00053 sva_00053
tra_00054 tra_00054
sva_00054 sva_00054
tra_00055 tra_00055
sva_00055 sva_00055
tra_00056 tra_00056
sva_00056 sva_00056
tra_00057 tra_00057
sva_00057 sva_00057
svh_00057 svh_00057
hnm_00057 hnm_00057
hno_00057 hno_00057
hio_00057 hio_00057
tra_00058 tra_00058
sva_00058 sva_00058
svh_00058 svh_00058
hnm_00058 hnm_00058
hno_00058 hno_00058
hio_00058 hio_00058
tra_00059 tra_00059
sva_00059 sva_00059
svh_00059 svh_00059
hnm_00059 hnm_00059
hno_00059 hno_00059
hio_00059 hio_00059
tra_00060 tra_00060
sva_00060 sva_00060
tra_00061 tra_00061
sva_00061 sva_00061
tra_00062 tra_00062
sva_00062 sva_00062
tra_00063 tra_00063
sva_00063 sva_00063
tra_00064 tra_00064
sva_00064 sva_00064
tra_00065 tra_00065
sva_00065 sva_00065
tra_00066 tra_00066
sva_00066 sva_00066
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_PubSecBdgtLineItemDSt.
-- 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_PubSecBdgtLineItemDSt AS
SELECT
  docid,
  version,
  doctag,
  docqprov,
  tra_00001,
  sva_00001,
  svh_00001,
  hnm_00001,
  hno_00001,
  hio_00001,
  tra_00002,
  sva_00002,
  svh_00002,
  hnm_00002,
  hno_00002,
  hio_00002,
  tra_00003,
  sva_00003,
  tra_00004,
  sva_00004,
  tra_00005,
  sva_00005,
  tra_00006,
  sva_00006,
  svh_00006,
  hnm_00006,
  hno_00006,
  hio_00006,
  tra_00007,
  sva_00007,
  tra_00008,
  sva_00008,
  svh_00008,
  hnm_00008,
  hno_00008,
  hio_00008,
  tra_00009,
  sva_00009,
  svh_00009,
  hnm_00009,
  hno_00009,
  hio_00009,
  tra_00010,
  sva_00010,
  svh_00010,
  hnm_00010,
  hno_00010,
  hio_00010,
  tra_00011,
  sva_00011,
  svh_00011,
  hnm_00011,
  hno_00011,
  hio_00011,
  tra_00012,
  sva_00012,
  tra_00013,
  sva_00013,
  tra_00014,
  sva_00014,
  tra_00015,
  sva_00015,
  tra_00016,
  sva_00016,
  svh_00016,
  hnm_00016,
  hno_00016,
  hio_00016,
  tra_00017,
  sva_00017,
  tra_customer,
  sva_customer,
  svh_customer,
  hnm_customer,
  hno_customer,
  hio_customer,
  tra_fund,
  sva_fund,
  svh_fund,
  hnm_fund,
  hno_fund,
  hio_fund,
  tra_fundtype,
  sva_fundtype,
  tra_grantid,
  sva_grantid,
  svh_grantid,
  hnm_grantid,
  hno_grantid,
  hio_grantid,
  tra_ledger,
  sva_ledger,
  tra_orderid,
  sva_orderid,
  svh_orderid,
  hnm_orderid,
  hno_orderid,
  hio_orderid,
  tra_plant,
  sva_plant,
  svh_plant,
  hnm_plant,
  hno_plant,
  hio_plant,
  tra_product,
  sva_product,
  svh_product,
  hnm_product,
  hno_product,
  hio_product,
  tra_segment,
  sva_segment,
  svh_segment,
  hnm_segment,
  hno_segment,
  hio_segment,
  tra_workitem,
  sva_workitem,
  tra_00018,
  sva_00018,
  svh_00018,
  hnm_00018,
  hno_00018,
  hio_00018,
  tra_00019,
  sva_00019,
  tra_00020,
  sva_00020,
  tra_00021,
  sva_00021,
  svh_00021,
  hnm_00021,
  hno_00021,
  hio_00021,
  tra_00022,
  sva_00022,
  tra_00023,
  sva_00023,
  tra_00024,
  sva_00024,
  tra_00025,
  sva_00025,
  tra_00026,
  sva_00026,
  tra_00027,
  sva_00027,
  svh_00027,
  hnm_00027,
  hno_00027,
  hio_00027,
  tra_00028,
  sva_00028,
  tra_00029,
  sva_00029,
  svh_00029,
  hnm_00029,
  hno_00029,
  hio_00029,
  tra_00030,
  sva_00030,
  tra_00031,
  sva_00031,
  svh_00031,
  hnm_00031,
  hno_00031,
  hio_00031,
  tra_00032,
  sva_00032,
  tra_00033,
  sva_00033,
  svh_00033,
  hnm_00033,
  hno_00033,
  hio_00033,
  tra_00034,
  sva_00034,
  svh_00034,
  hnm_00034,
  hno_00034,
  hio_00034,
  tra_00035,
  sva_00035,
  tra_00036,
  sva_00036,
  tra_00037,
  sva_00037,
  tra_00038,
  sva_00038,
  tra_00039,
  sva_00039,
  tra_00040,
  sva_00040,
  svh_00040,
  hnm_00040,
  hno_00040,
  hio_00040,
  tra_00041,
  sva_00041,
  tra_00042,
  sva_00042,
  tra_00043,
  sva_00043,
  tra_00044,
  sva_00044,
  tra_00045,
  sva_00045,
  tra_00046,
  sva_00046,
  tra_00047,
  sva_00047,
  svh_00047,
  hnm_00047,
  hno_00047,
  hio_00047,
  tra_00048,
  sva_00048,
  tra_00049,
  sva_00049,
  tra_00050,
  sva_00050,
  tra_00051,
  sva_00051,
  tra_00052,
  sva_00052,
  svh_00052,
  hnm_00052,
  hno_00052,
  hio_00052,
  tra_00053,
  sva_00053,
  tra_00054,
  sva_00054,
  tra_00055,
  sva_00055,
  tra_00056,
  sva_00056,
  tra_00057,
  sva_00057,
  svh_00057,
  hnm_00057,
  hno_00057,
  hio_00057,
  tra_00058,
  sva_00058,
  svh_00058,
  hnm_00058,
  hno_00058,
  hio_00058,
  tra_00059,
  sva_00059,
  svh_00059,
  hnm_00059,
  hno_00059,
  hio_00059,
  tra_00060,
  sva_00060,
  tra_00061,
  sva_00061,
  tra_00062,
  sva_00062,
  tra_00063,
  sva_00063,
  tra_00064,
  sva_00064,
  tra_00065,
  sva_00065,
  tra_00066,
  sva_00066,
  doctype,
  owner,
  infoprov,
  sva_infoprov,
  kyfnm,
  docstat,
  session_id,
  timestamp,
  document,
  seldr,
  docprop
FROM ipubsecbddsttab
;