P_MstrProjActualsInProjCrcy

DDL: P_MSTRPROJACTUALSINPROJCRCY SQL: PMSTRPROJACTLS Type: view COMPOSITE
57 Fields 1 Data Sources

P_MstrProjActualsInProjCrcy is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_MstrProjCtrlgObjActlRevCost) and exposes 57 fields with key fields MasterProjectUUID, MasterProject.

Data Sources (1)

SourceAliasJoin Type
P_MstrProjCtrlgObjActlRevCost P_MstrProjCtrlgObjActlRevCost from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMSTRPROJACTLS view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY MasterProjectUUID MasterProjectUUID NodeID
KEY MasterProject MasterProject Project ID
MasterProjectName MasterProjectName
MasterProjectIsConfidential MasterProjectIsConfidential
MasterProjectOrganization MasterProjectOrganization
MasterProjectType MasterProjectType
Project Project WBS Element
ProjectDescription ProjectDescription Project Name
ControllingObjectExternalID ControllingObjectExternalID WBS Element
ControllingObjectType ControllingObjectType Object Type
AccoutAssgmntObj AccoutAssgmntObj Object number
WBSElementObject WBSElementObject Object number
WBSElement WBSElement WBS Internal ID
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
ControllingObjectDebitType ControllingObjectDebitType
GLAccount GLAccount General Ledger
PersonnelNumber PersonnelNumber Personnel No.
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
FiscalYear FiscalYear G/L Fiscal Year
FiscalYearPeriod FiscalYearPeriod Period/Year
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
Quantity Quantity Value
BaseUnit BaseUnit Unit of Measure
TransactionCurrency TransactionCurrency Transaction Currency
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
Material Material Vehicle Model
IsReversed IsReversed Reversed?
MstrProjAnchorObjectInternalID MstrProjAnchorObjectInternalID
MstrProjCutOffDate MstrProjCutOffDate
Plant Plant Valuation Area
DocumentDate DocumentDate Journal Entry Date
Currency Currency Valuation Crcy
TotalQuantity TotalQuantity Activity Quantity
AccountingDocument AccountingDocument Journal Entry
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
ActualRevenueAmount ActualRevenueAmount Billed Revenue
ActualCostAmount ActualCostAmount Actual Cost
ActlRevnInCoCodeCrcy ActlRevnInCoCodeCrcy
ActlCostInCoCodeCrcy ActlCostInCoCodeCrcy
ActualRevenueInObjectCrcy ActualRevenueInObjectCrcy
ActualCostInObjectCrcy ActualCostInObjectCrcy
ActualRevenueInTransCrcy ActualRevenueInTransCrcy
ActualCostInTransCrcy ActualCostInTransCrcy Actl Costs Bal. (TC)
ActlCostInProjCrcy ActlCostInProjCrcy
ActlEffortQty ActlEffortQty
Unit Unit UoM
StrtToDteActlCostInCOCrcy StrtToDteActlCostInCOCrcy
StrtToDteActlRevnInCOCrcy StrtToDteActlRevnInCOCrcy
_MstrProjFinPlan _MstrProjFinPlan

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 P_MstrProjActualsInProjCrcy.
-- 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: PMSTRPROJACTLS

CREATE VIEW P_MstrProjActualsInProjCrcy AS
SELECT
  MasterProjectUUID,
  MasterProject,
  MasterProjectName,
  MasterProjectIsConfidential,
  MasterProjectOrganization,
  MasterProjectType,
  Project,
  ProjectDescription,
  ControllingObjectExternalID,
  ControllingObjectType,
  AccoutAssgmntObj,
  WBSElementObject,
  WBSElement,
  CompanyCode,
  BusinessArea,
  ControllingArea,
  ControllingObjectDebitType,
  GLAccount,
  PersonnelNumber,
  SalesOrder,
  SalesOrderItem,
  FiscalYear,
  FiscalYearPeriod,
  FiscalPeriod,
  PostingDate,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  Quantity,
  BaseUnit,
  TransactionCurrency,
  ControllingObjectCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  Material,
  IsReversed,
  MstrProjAnchorObjectInternalID,
  MstrProjCutOffDate,
  Plant,
  DocumentDate,
  Currency,
  TotalQuantity,
  AccountingDocument,
  ClearingAccountingDocument,
  ActualRevenueAmount,
  ActualCostAmount,
  ActlRevnInCoCodeCrcy,
  ActlCostInCoCodeCrcy,
  ActualRevenueInObjectCrcy,
  ActualCostInObjectCrcy,
  ActualRevenueInTransCrcy,
  ActualCostInTransCrcy,
  ActlCostInProjCrcy,
  ActlEffortQty,
  Unit,
  StrtToDteActlCostInCOCrcy,
  StrtToDteActlRevnInCOCrcy
FROM P_MstrProjCtrlgObjActlRevCost
;

Learn More