I_PubSecBdgtLineItemDSt
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)
| Source | Alias | Join Type |
|---|---|---|
| ipubsecbddsttab | ipubsecbddsttab | from |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| 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 | |||
| 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
;
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