I_CompanyMarginCube

Purpose
This CDS view is designed to provide a comprehensive analytical cube for evaluating company margins. It aggregates financial data from general ledger account line items and associates it with various business dimensions such as currency fields, product and service object types, solution orders, customer industries, and organizational divisions. The view is structured to support complex analytical queries and facilitate decision-making processes related to financial performance and margin analysis. This CDS view provides the data to answer the following business questions: What is the company's margin across different fiscal years and periods? How do margins vary by business solution orders and their items? What is the impact of different account assignment types on company margins? How do margins differ across various customer industries and divisions? What are the financial results associated with specific semantic tags like revenue, cost of goods sold, and overhead costs? How do margins correlate with sales orders, contracts, and service documents? What is the distribution of margins across different profit centers and organizational units? How do currency fluctuations affect the company's financial performance? What are the key drivers of variable and fixed amounts in company code currency? 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 the following authorization objects assigned: 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

Structure
Fields Used for Filtering The main filters are as follows: Field Name Label CurrencyField Currency Role Field The main filters are as follows: 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 GLAccountHierarchy FSV SemanticTag Semantic Tag ValidityStartDate Valid From ValidityEndDate Valid To FiscalYearVariant Fiscal Year Variant FiscalPeriod Fiscal Period FiscalYearPeriod Fiscal Year Period FiscalQuarter Fiscal Quarter FiscalYearQuarter Fiscal Year Quarter BusinessSolutionOrder Solution Order BusinessSolutionOrderItem Solution Order Item ProviderContract Provider Contract ProviderContractItem Provider Contract Item SoldProduct Product Sold Product Product AccountAssignmentType Account Assignment Type ProjectExternalID Project Definition ProfitCenter Profit Center ServiceDocumentType Service Doc. Type ServiceDocument Service Document ServiceDocumentItem Service Doc. Item BillToParty Bill-to Party BusinessTransactionType Business Transaction Type Customer Customer CustomerGroup Customer Group GLAccount G/L Account CustomerSuppl