I_MasterProjectCurrency

DDL: I_MASTERPROJECTCURRENCY SQL: IMPCUR Type: view BASIC Package: VDM_CPM_WS
8 Fields 4 Data Sources

Get master Project Currency

I_MasterProjectCurrency is a Basic CDS View that provides data about "Get master Project Currency" in SAP S/4HANA. It reads from 4 data sources (tka01, I_MasterProjectItem, I_MasterProject, proj) and exposes 8 fields. Part of development package VDM_CPM_WS.

Data Sources (4)

SourceAliasJoin Type
tka01 ControllingArea inner
I_MasterProjectItem Item from
I_MasterProject MProject inner
proj Project inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMPCUR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Get master Project Currency view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProject MasterProjectUUID NodeID
ProjectUUID I_MasterProject ProjectUUID Project UUID
MasterProject I_MasterProject MasterProject Project ID
MasterProjectIsConfidential I_MasterProject MasterProjectIsConfidential
MasterProjectOrganization I_MasterProject MasterProjectOrganization
MasterProjectType I_MasterProject MasterProjectType
ControllingArea proj vkokr CO area
Currency tka01 waers Transaction Currency

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_MasterProjectCurrency.
-- 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.
-- SQL view name: IMPCUR

CREATE VIEW I_MasterProjectCurrency AS
SELECT
  MProject.MasterProjectUUID AS MasterProjectUUID,
  MProject.ProjectUUID AS ProjectUUID,
  MProject.MasterProject AS MasterProject,
  MProject.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MProject.MasterProjectOrganization AS MasterProjectOrganization,
  MProject.MasterProjectType AS MasterProjectType,
  Project.vkokr AS ControllingArea,
  ControllingArea.waers AS Currency
FROM I_MasterProjectItem AS Item
INNER JOIN I_MasterProject AS MProject ON /* join condition not captured in parsed metadata */
INNER JOIN proj AS Project ON /* join condition not captured in parsed metadata */
INNER JOIN tka01 AS ControllingArea ON /* join condition not captured in parsed metadata */
;

Learn More