I_CompanyMarginCube_2

Purpose
This CDS view is designed to provide a comprehensive analytical cube for evaluating company margins by integrating various financial and operational data. It aggregates and presents data related to general ledger accounts, sales, services, and cost elements, allowing for detailed margin analysis across different dimensions such as products, services, customers, and organizational units. This CDS view provides the data to answer the following business questions: What is the overall company margin across different fiscal periods and organizational units? How do specific account assignment types (e.g., service orders, sales documents) contribute to the company margin? What are the financial impacts of different semantic tags such as billing revenue, cost of goods sold, and overhead costs on the company margin? How do different currencies (company code currency, global currency, functional currency) affect the financial results? What is the margin contribution from specific products, services, and customer groups? How do sales and service orders impact the financial performance and margin? What are the effects of various cost elements like travel costs, HR costs, and service costs on the overall margin? How does the margin vary across different sales organizations, distribution channels, and divisions? What is the impact of specific projects, contracts, and orders on the company margin? How do different fiscal year variants and periods influence the financial outcomes and margin analysis? 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 Measure or Attribute Ledger Ledger Attribute SourceLedger Source Ledger Attribute CompanyCode Company Code Attribute FiscalYear Fiscal Year Attribute AccountingDocument Journal Entry Attribute LedgerGLLineItem Journal Entry Item Attribute GLAccountHierarchy FSV Attribute SemanticTag Semantic Tag Attribute ValidityStartDate Valid From Attribute ValidityEndDate Valid To Attribute CurrencyField Currency Role Field Attribute FiscalYearVariant Fiscal Year Variant Attribute FiscalPeriod Fiscal Period Attribute FiscalYearPeriod Fiscal Year Period Attribute FiscalQuarter Fiscal Quarter Attribute FiscalYearQuarter Fiscal Year Quarter Attribute BusinessSolutionOrder Solution Order Attribute BusinessSolutionOrderItem Solution Order Item Attribute ProviderContract Provider Contract Attribute ProviderContractItem Pro