I_EngmntPrjMarginItemCube

DDL: I_ENGMNTPRJMARGINITEMCUBE Type: view_entity COMPOSITE Package: FINS_COPA_REPORTING

Engagement Project Margin Items - Cube

I_EngmntPrjMarginItemCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_EngmntPrjMarginItemCube is a Composite CDS View (Cube) that provides data about "Engagement Project Margin Items - Cube" in SAP S/4HANA. It reads from 1 data source (P_EngagementProjectMarginItem) and exposes 125 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 4 associations to related views. Part of development package FINS_COPA_REPORTING.

SAP Help Documentation

CategoryCDS Views for Sales Accounting
Data CategoryCube
Purpose
This CDS view is designed to provide a comprehensive analytical cube for engagement project margin items. It aggregates and organizes data related to financial and project management aspects, enabling detailed analysis of project margins, financial transactions, and associated business entities. This CDS view provides the data to answer the following business questions: What are the margins associated with specific engagement projects? How do financial transactions impact the margins of engagement projects? Which business partners are managing the projects, and what are their roles? What are the fiscal details (year, period) associated with the project margins? How do different service contracts and solutions orders contribute to project margins? What is the distribution of project margins across different profit centers and sales organizations? How do various accounting documents and ledger items relate to project margins? What are the quantities and amounts in different currencies and units of measure for project margin items? How do customer and supplier details influence project margins? What is the impact of different cost centers and functional areas on project margins? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Restriction Type ID Restriction Type A_B_ANLKL Asset Postings: Company Code/Asset Class BEGRU_BKPF_BEK Authorization Group for Supplier-Related Journal Entries BEGRU_BKPF_BED Authorization Group for Customer Related Journal Entries SEGMENT_GLRRCTY Segment for Segmental Reporting/Record Type BUKRS_GLRLDNR_GLRRCTY_GLRVERS Company Code/Ledger/Record Type/Version BUKRS_PRCTR_KSTAR Company Code/ Profit Center / Cost Element SALES_AREA_OFFICE_GROUP Sales Area / Sales Office / Sales Group BEGRU_BKPF_BLA Authorization Groups for Journal Entry Document Type KOART Account Type COMPANYCODE_HIERARCHY Company Code Hierarchies BWKEY Valuation Area AUART Sales Document Type DATE Due Date for Authority Check KOSTL_KSTAR Cost Center/Cost Element FKBER Functional Area F_BKPF_ORD Order Category / Order Type for Journal Entries BUKRS Company Code SALES_AREA Sales Area You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important Fields Important fields in this view include the following: Field Name Label Ledger Ledger SourceLedger Source Ledger CompanyCode Company Code FiscalYear Fiscal Year AccountingDocument Journal Entry LedgerGLLineItem Journal Entry Item CurrencyField Currency Role Field LedgerFiscalYear Fiscal Year of Ledger FiscalYearVariant Fiscal Year Variant FiscalPeriod Fiscal Period FiscalYearPeriod Fiscal Year Period ServiceContractType Serv. Contract Type ServiceContract Service Contract ServiceContractItem Srv Contract Item BusinessSolutionOrder Solution Order BusinessSolutionOrderItem Solution Order Item ProviderContract Provider Contract ProviderContractItem Provider Contract Item SoldProduct Product Sold AccountAssignmentType Account Assignment Type Project Project ProjectInternalID Project Internal ID ProjectExternalID Project Definition ProjectProfileCode Project Profile ProfitCenter Profit Center OriginProfitCenter Origin Profit Center ServiceDocumentType Service Doc. Type ServiceDocument Service Document ServiceDocumentItem Service Doc. Item BillToParty Bill-to Party Customer Customer CustomerGroup Customer Group GLAccount G/L Account OldGLAccount G/L Account CustomerSupplierIndustry Custome

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-FIO-PA-2CL
CapabilitiesData Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)Yes
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view is designed to provide a comprehensive analytical cube for engagement project margin items. It aggregates and organizes data related to financial and project management aspects, enabling detailed analysis of project margins, financial transactions, and associated business entities.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the margins associated with specific engagement projects?</p></li> <li><p>How do financial transactions impact the margins of engagement projects?</p></li> <li><p>Which business partners are managing the projects, and what are their roles?</p></li> <li><p>What are the fiscal details (year, period) associated with the project margins?</p></li> <li><p>How do different service contracts and solutions orders contribute to project margins?</p></li> <li><p>What is the distribution of project margins across different profit centers and sales organizations?</p></li> <li><p>How do various accounting documents and ledger items relate to project margins?</p></li> <li><p>What are the quantities and amounts in different currencies and units of measure for project margin items?</p></li> <li><p>How do customer and supplier details influence project margins?</p></li> <li><p>What is the impact of different cost centers and functional areas on project margins?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_EngagementProjectMarginItem P_EngmProjectMarginItem from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _ProjectManagerBP $projection.ProjectManager = _ProjectManagerBP.BusinessPartner
[0..1] I_PrjMargAnlysRptCrcyFld _CurrencyField $projection.CurrencyField = _CurrencyField.CurrencyField
[1..1] E_JournalEntryItem _Extension_acdoca $projection.SourceLedger = _Extension_acdoca.SourceLedger and $projection.CompanyCode = _Extension_acdoca.CompanyCode and $projection.FiscalYear = _Extension_acdoca.FiscalYear and $projection.AccountingDocument = _Extension_acdoca.AccountingDocument and $projection.LedgerGLLineItem = _Extension_acdoca.LedgerGLLineItem
[0..1] I_EngmntPrjMarginItemDSt _DocumentStore _DocumentStore.TRA_LEDGER = $projection.Ledger and _DocumentStore.TRA_SOURCELEDGER = $projection.SourceLedger and _DocumentStore.TRA_COMPANYCODE = $projection.CompanyCode and _DocumentStore.TRA_FISCALYEAR = $projection.FiscalYear and _DocumentStore.TRA_00016 = $projection.AccountingDocument and _DocumentStore.TRA_00011 = $projection.LedgerGLLineItem and _DocumentStore.TRA_CURRENCYFIELD = $projection.CurrencyField

Annotations (12)

NameValueLevelField
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataCategory #CUBE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Engagement Project Margin Items - Cube view

Fields (125)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger in General Ledger Accounting
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem General Ledger Journal Entry Line Item
KEY CurrencyField CurrencyField Currency Role Field
LedgerFiscalYear LedgerFiscalYear Fiscal Year of Ledger
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
FiscalPeriod FiscalPeriod Fiscal Period
FiscalYearPeriod FiscalYearPeriod Fiscal Year Period
ServiceContractType ServiceContractType Service Contract Type
ServiceContract ServiceContract Service Contract ID
ServiceContractItem ServiceContractItem Service Contract Item ID
BusinessSolutionOrder BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem BusinessSolutionOrderItem Solution Order Item
ProviderContract ProviderContract Provider Contract
ProviderContractItem ProviderContractItem Provider Contract Item
SoldProduct SoldProduct Product Sold
AccountAssignmentType AccountAssignmentType Account Assignment Type
Project Project Project (external ID)
ProjectInternalID ProjectInternalID Project Internal ID
ProjectExternalID ProjectExternalID Project Number (External) Edited
ProjectProfileCode ProjectProfileCode Project Profile
ProfitCenter ProfitCenter Profit Center
OriginProfitCenter OriginProfitCenter Origin Profit Center
ServiceDocumentType ServiceDocumentType Service Document Type
ServiceDocument ServiceDocument Service Document ID
ServiceDocumentItem ServiceDocumentItem Service Document Item ID
BillToParty BillToParty Inv. Recipient
Customer Customer Customer Number
CustomerGroup CustomerGroup Customer Group
GLAccount GLAccount General Ledger
OldGLAccount OldGLAccount G/L Account
CustomerSupplierIndustry CustomerSupplierIndustry Customer Supplier Industry
SoldProductGroup SoldProductGroup Product Sold Group
SalesDocument SalesDocument Sales Document
SalesOrganization SalesOrganization Sales Organization
ShipToParty ShipToParty Ship-To Party (obsolete)
ChartOfAccounts ChartOfAccounts Chart of Accounts
ControllingArea ControllingArea Controlling Area
DistributionChannel DistributionChannel Distribution Channel
OrganizationDivision OrganizationDivision Org. Division
FunctionalArea FunctionalArea Sendr Fctl Area
Plant Plant Valuation Area
CustomerSupplierCountry CustomerSupplierCountry Customer or Supplier Country/Region
WBSElement WBSElement WBS Internal ID
WBSElementInternalID WBSElementInternalID WBS Element Internal ID
WBSElementExternalID WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited
SalesDistrict SalesDistrict Sales District
Segment Segment Segment for Segmental Reporting
OrderCategory OrderCategory Order Category
OrderID OrderID Order ID
OrderType OrderType Order Type
CostCenter CostCenter Cost Center
_CurrentCostCenter _CurrentCostCenter
_ServiceDocument _ServiceDocument
AssetClass AssetClass Asset Class
Supplier Supplier Supplier
_Supplier _Supplier
AccountingDocumentType AccountingDocumentType Journal Entry Type
_AccountingDocumentType _AccountingDocumentType
_CurrentProfitCenter _CurrentProfitCenter
FinancialAccountType FinancialAccountType Fin. Account Type
ValuationArea ValuationArea Valuation Area
ProjectManager ProjectManager Business Partner Number
ProjectManagerName ProjectManagerName Broker Name
EngagementProjectStage EngagementProjectStage Commercial Project: Stage
_ProjectStage _ProjectStage
_ProjectStageText _ProjectStageText
PostingDate PostingDate Posting Date
DebitCreditCode DebitCreditCode Single-Character Flag
_DebitCreditCode _DebitCreditCode
IsCommitment IsCommitment Indicator: Is Commitment
Currency Currency Valuation Crcy
AmountInDisplayCurrency AmountInDisplayCurrency Amount in Display Currency
BaseUnit BaseUnit Base Unit of Measure
Quantity Quantity Quantity
CostSourceUnit CostSourceUnit Cost Source Unit
ValuationQuantity ValuationQuantity Valuation Quantity
_CurrencyField _CurrencyField
_BaseUnit _BaseUnit
_CostSourceUnit _CostSourceUnit
_Order _Order
_Project _Project
_ProjectExternalID _ProjectExternalID
_WBSElementExternalID _WBSElementExternalID
_ProjectBasicData _ProjectBasicData
_SourceLedger _SourceLedger
_JournalEntry _JournalEntry
_CustomerSupplierCountry _CustomerSupplierCountry
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_Ledger _Ledger
_ObjectType _ObjectType
_SolutionOrder _SolutionOrder
_ServiceDocumentTypeNew _ServiceDocumentTypeNew
_ServiceDocumentNew _ServiceDocumentNew
_ServiceDocumentItemNew _ServiceDocumentItemNew
_ServiceContractNew _ServiceContractNew
_ServiceContractItemNew _ServiceContractItemNew
_ServiceContractTypeNew _ServiceContractTypeNew
_SalesDocument _SalesDocument
_Customer _Customer
_CustomerGroup _CustomerGroup
_ShipToParty _ShipToParty
_SoldProduct _SoldProduct
_SoldProductGroup _SoldProductGroup
_ProfitCenter _ProfitCenter
_OriginProfitCenter _OriginProfitCenter
_SalesOrganization _SalesOrganization
_BillToParty _BillToParty
_ChartOfAccounts _ChartOfAccounts
_ControllingArea _ControllingArea
_DistributionChannel _DistributionChannel
_FunctionalArea _FunctionalArea
_OldGLAccountInChartOfAccounts _OldGLAccountInChartOfAccounts
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_Plant _Plant
_SalesDistrict _SalesDistrict
_FiscalYearVariant _FiscalYearVariant
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_LedgerFiscalYearForLedger _LedgerFiscalYearForLedger
_ProjectManagerBP _ProjectManagerBP
_DocumentStore _DocumentStore

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_EngmntPrjMarginItemCube.
-- 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_EngmntPrjMarginItemCube AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  CurrencyField,
  LedgerFiscalYear,
  FiscalYearVariant,
  FiscalPeriod,
  FiscalYearPeriod,
  ServiceContractType,
  ServiceContract,
  ServiceContractItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  ProviderContract,
  ProviderContractItem,
  SoldProduct,
  AccountAssignmentType,
  Project,
  ProjectInternalID,
  ProjectExternalID,
  ProjectProfileCode,
  ProfitCenter,
  OriginProfitCenter,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  BillToParty,
  Customer,
  CustomerGroup,
  GLAccount,
  OldGLAccount,
  CustomerSupplierIndustry,
  SoldProductGroup,
  SalesDocument,
  SalesOrganization,
  ShipToParty,
  ChartOfAccounts,
  ControllingArea,
  DistributionChannel,
  OrganizationDivision,
  FunctionalArea,
  Plant,
  CustomerSupplierCountry,
  WBSElement,
  WBSElementInternalID,
  WBSElementExternalID,
  SalesDistrict,
  Segment,
  OrderCategory,
  OrderID,
  OrderType,
  CostCenter,
  AssetClass,
  Supplier,
  AccountingDocumentType,
  FinancialAccountType,
  ValuationArea,
  ProjectManager,
  ProjectManagerName,
  EngagementProjectStage,
  PostingDate,
  DebitCreditCode,
  IsCommitment,
  Currency,
  AmountInDisplayCurrency,
  BaseUnit,
  Quantity,
  CostSourceUnit,
  ValuationQuantity
FROM P_EngagementProjectMarginItem AS P_EngmProjectMarginItem
LEFT OUTER JOIN I_BusinessPartner AS _ProjectManagerBP ON ProjectManager = _ProjectManagerBP.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_PrjMargAnlysRptCrcyFld AS _CurrencyField ON CurrencyField = _CurrencyField.CurrencyField  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension_acdoca ON SourceLedger = _Extension_acdoca.SourceLedger AND CompanyCode = _Extension_acdoca.CompanyCode AND FiscalYear = _Extension_acdoca.FiscalYear AND AccountingDocument = _Extension_acdoca.AccountingDocument AND LedgerGLLineItem = _Extension_acdoca.LedgerGLLineItem  -- association [1..1]
LEFT OUTER JOIN I_EngmntPrjMarginItemDSt AS _DocumentStore ON _DocumentStore.TRA_LEDGER = Ledger AND _DocumentStore.TRA_SOURCELEDGER = SourceLedger AND _DocumentStore.TRA_COMPANYCODE = CompanyCode AND _DocumentStore.TRA_FISCALYEAR = FiscalYear AND _DocumentStore.TRA_00016 = AccountingDocument AND _DocumentStore.TRA_00011 = LedgerGLLineItem AND _DocumentStore.TRA_CURRENCYFIELD = CurrencyField  -- association [0..1]
;