I_EngmntPrjMarginItemCube
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
| Category | CDS Views for Sales Accounting |
|---|---|
| Data Category | Cube |
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
SAP API Hub
| Category | Composite |
|---|---|
| State | C1 |
| Line of Business | Accounting and Financial Close |
| Application Component | CO-FIO-PA-2CL |
| Capabilities | Data 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 |
| Package | Accounting 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
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_EngagementProjectMarginItem | P_EngmProjectMarginItem | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA