I_MasterProjectCurrency

DDL: I_MASTERPROJECTCURRENCY SQL: IMPCUR Type: view BASIC Package: VDM_CPM_WS

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.

4 data source(s) 8 fields

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
ProjectUUID I_MasterProject ProjectUUID
MasterProject I_MasterProject MasterProject
MasterProjectIsConfidential I_MasterProject MasterProjectIsConfidential
MasterProjectOrganization I_MasterProject MasterProjectOrganization
MasterProjectType I_MasterProject MasterProjectType
ControllingArea proj vkokr
Currency tka01 waers 
@AbapCatalog.sqlViewName: 'IMPCUR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Get master Project Currency'
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_MasterProjectCurrency
  as select from I_MasterProjectItem as Item
    inner join   I_MasterProject     as MProject        on Item.MasterProjectUUID = MProject.MasterProjectUUID
    inner join   proj                as Project         on Item.MasterProjectItem = Project.objnr
    inner join   tka01               as ControllingArea on Project.vkokr = ControllingArea.kokrs
{
  MProject.MasterProjectUUID,
  MProject.ProjectUUID,
  //MProject.MasterProjectUUID_E,

  MProject.MasterProject,
  MProject.MasterProjectIsConfidential,
  MProject.MasterProjectOrganization,
  MProject.MasterProjectType,
  Project.vkokr         as ControllingArea,
  ControllingArea.waers as Currency
}

Learn More