I_EntProjMarginAnalysisDSt
Enterprise Project Document Store
I_EntProjMarginAnalysisDSt is a Basic CDS View that provides data about "Enterprise Project Document Store" in SAP S/4HANA. It reads from 1 data source (ientprojmdsttab2) and exposes 141 fields with key fields docid, version. Part of development package FINS_COPA_REPORTING.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| ientprojmdsttab2 | ientprojmdsttab2 | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| EndUserText.label | Enterprise Project Document Store | view | |
| VDM.viewType | #BASIC | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DOCUMENT_STORE | view | |
| Analytics.dataCategory | #DOCSTORE | view | |
| Analytics.document.serviceClassName | CL_CELL_COMMENT_GENERIC_HDLR | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (141)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | docid | docid | Snapshot ID | |
| KEY | version | version | XML Vers. | |
| doctag | doctag | |||
| docqprov | docqprov | |||
| tra_ledger | tra_ledger | |||
| sva_ledger | sva_ledger | |||
| tra_00001 | tra_00001 | |||
| sva_00001 | sva_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_segment | tra_segment | |||
| sva_segment | sva_segment | |||
| svh_segment | svh_segment | |||
| hnm_segment | hnm_segment | |||
| hno_segment | hno_segment | |||
| hio_segment | hio_segment | |||
| 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_plant | tra_plant | |||
| sva_plant | sva_plant | |||
| tra_00008 | tra_00008 | |||
| sva_00008 | sva_00008 | |||
| tra_00009 | tra_00009 | |||
| sva_00009 | sva_00009 | |||
| 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_00010 | tra_00010 | |||
| sva_00010 | sva_00010 | |||
| tra_00011 | tra_00011 | |||
| sva_00011 | sva_00011 | |||
| tra_00012 | tra_00012 | |||
| sva_00012 | sva_00012 | |||
| svh_00012 | svh_00012 | |||
| hnm_00012 | hnm_00012 | |||
| hno_00012 | hno_00012 | |||
| hio_00012 | hio_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_product | tra_product | |||
| sva_product | sva_product | |||
| svh_product | svh_product | |||
| hnm_product | hnm_product | |||
| hno_product | hno_product | |||
| hio_product | hio_product | |||
| tra_00017 | tra_00017 | |||
| sva_00017 | sva_00017 | |||
| svh_00017 | svh_00017 | |||
| hnm_00017 | hnm_00017 | |||
| hno_00017 | hno_00017 | |||
| hio_00017 | hio_00017 | |||
| 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_orderid | tra_orderid | |||
| sva_orderid | sva_orderid | |||
| svh_orderid | svh_orderid | |||
| hnm_orderid | hnm_orderid | |||
| hno_orderid | hno_orderid | |||
| hio_orderid | hio_orderid | |||
| tra_supplier | tra_supplier | |||
| sva_supplier | sva_supplier | |||
| tra_00019 | tra_00019 | |||
| sva_00019 | sva_00019 | |||
| tra_00020 | tra_00020 | |||
| sva_00020 | sva_00020 | |||
| tra_00021 | tra_00021 | |||
| sva_00021 | sva_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 | |||
| svh_00026 | svh_00026 | |||
| hnm_00026 | hnm_00026 | |||
| hno_00026 | hno_00026 | |||
| hio_00026 | hio_00026 | |||
| tra_currency | tra_currency | |||
| sva_currency | sva_currency | |||
| tra_00027 | tra_00027 | |||
| sva_00027 | sva_00027 | |||
| tra_project | tra_project | |||
| sva_project | sva_project | |||
| tra_00028 | tra_00028 | |||
| sva_00028 | sva_00028 | |||
| tra_00029 | tra_00029 | |||
| sva_00029 | sva_00029 | |||
| tra_00030 | tra_00030 | |||
| sva_00030 | sva_00030 | |||
| tra_00031 | tra_00031 | |||
| sva_00031 | sva_00031 | |||
| tra_00032 | tra_00032 | |||
| sva_00032 | sva_00032 | |||
| 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_EntProjMarginAnalysisDSt.
-- 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_EntProjMarginAnalysisDSt AS
SELECT
docid,
version,
doctag,
docqprov,
tra_ledger,
sva_ledger,
tra_00001,
sva_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_segment,
sva_segment,
svh_segment,
hnm_segment,
hno_segment,
hio_segment,
tra_00006,
sva_00006,
svh_00006,
hnm_00006,
hno_00006,
hio_00006,
tra_00007,
sva_00007,
tra_plant,
sva_plant,
tra_00008,
sva_00008,
tra_00009,
sva_00009,
tra_customer,
sva_customer,
svh_customer,
hnm_customer,
hno_customer,
hio_customer,
tra_00010,
sva_00010,
tra_00011,
sva_00011,
tra_00012,
sva_00012,
svh_00012,
hnm_00012,
hno_00012,
hio_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_product,
sva_product,
svh_product,
hnm_product,
hno_product,
hio_product,
tra_00017,
sva_00017,
svh_00017,
hnm_00017,
hno_00017,
hio_00017,
tra_00018,
sva_00018,
svh_00018,
hnm_00018,
hno_00018,
hio_00018,
tra_orderid,
sva_orderid,
svh_orderid,
hnm_orderid,
hno_orderid,
hio_orderid,
tra_supplier,
sva_supplier,
tra_00019,
sva_00019,
tra_00020,
sva_00020,
tra_00021,
sva_00021,
tra_00022,
sva_00022,
tra_00023,
sva_00023,
tra_00024,
sva_00024,
tra_00025,
sva_00025,
tra_00026,
sva_00026,
svh_00026,
hnm_00026,
hno_00026,
hio_00026,
tra_currency,
sva_currency,
tra_00027,
sva_00027,
tra_project,
sva_project,
tra_00028,
sva_00028,
tra_00029,
sva_00029,
tra_00030,
sva_00030,
tra_00031,
sva_00031,
tra_00032,
sva_00032,
doctype,
owner,
infoprov,
sva_infoprov,
kyfnm,
docstat,
session_id,
timestamp,
document,
seldr,
docprop
FROM ientprojmdsttab2
;
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