I_EntProjMarginAnalysisDSt

DDL: I_ENTPROJMARGINANALYSISDST Type: view_entity BASIC Package: FINS_COPA_REPORTING

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)

SourceAliasJoin Type
ientprojmdsttab2 ientprojmdsttab2 from

Annotations (10)

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

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