{"id":14390,"date":"2022-01-31T14:50:55","date_gmt":"2022-01-31T13:50:55","guid":{"rendered":"https:\/\/www.rapidviews.io\/blog\/uncategorized\/sap-data-warehouse-cloud-cas-dutilisation-fi-co"},"modified":"2025-03-27T16:19:11","modified_gmt":"2025-03-27T15:19:11","slug":"fi-co-use-case","status":"publish","type":"post","link":"https:\/\/dev.rapidviews.io\/en\/blog\/sap-data-warehouse-cloud\/fi-co-use-case","title":{"rendered":"SAP Data Warehouse Cloud : FI-CO Use Case"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"14390\" class=\"elementor elementor-14390\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3b19aa88 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3b19aa88\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-16a3501d\" data-id=\"16a3501d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b8f455b elementor-widget elementor-widget-heading\" data-id=\"b8f455b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Introduction<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25b1f6d elementor-widget elementor-widget-text-editor\" data-id=\"25b1f6d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>This article details a use case of SAP Data Warehouse Cloud to create a financial statement with master data based on SAP FI-CO. SAP Data Warehouse Cloud is integrated with the SAP HANA Cloud Services Platform and offers the ability to model and govern data warehouses in the cloud.<\/p><p>This article details a use case for <a href=\"\/en\/blog\/sap-data-warehouse-cloud\/sap-data-warehouse-cloud\">SAP DWC<\/a> to create a financial statement with master data based on <a href=\"https:\/\/www.sap.com\/uk\/index.html\">SAP<\/a>&#8216;s <a href=\"\/en\/blog\/sap-fi-co\/module-presentation\">FI-CO module<\/a>.<\/p><p>For this example, we will deploy the profit and loss statement, a mandatory accounting document for companies in the same way as the balance sheet. The profit and loss account presents all the income and expenses of a company during an accounting period.<\/p><p>The data cube (or <a href=\"\/en\/blog\/datamart\/datamarts-on-sap-hana\">datamart<\/a>) to be built in SAP DWC must be based on all the accounting entries recorded in the general ledger.<\/p><p>The accounting documents will constitute the de facto view of our datamart, to which will be attached dimensional views such as attributes related to G\/L accounts, account hierarchy, companies, etc.<\/p><p>Once the datamart is created in SAP DWC, we will format the income statement using the SAP HANA Cloud Services reporting application : SAP Analytics Cloud module FI-CO from SAP.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-090b092 elementor-widget elementor-widget-heading\" data-id=\"090b092\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">SAP DWC - The factual view of accounting entries<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ccef37 elementor-widget elementor-widget-text-editor\" data-id=\"6ccef37\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The RapidViews F_GL_DETAILS_DV factual view contains all the detail in the general ledger that we need to construct the income statement.<\/p><p>The factual view developed in SAP DWC contains the data from tables BKPF and FAGLFLEXA. Depending on the version of SAP installed, we could have used table BSEG for SAP ECC, and table ACDOCA for SAP <a href=\"https:\/\/dev.rapidviews.io\/en\/business-content-sap\/rapidviews-for-s-4hana\">S\/4HANA<\/a>. All of the above tables contain accounting entries from the SAP FI-CO module.<\/p><p>Here is an overview of the factual view modelling in SAP DWC :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5fde2fd elementor-widget elementor-widget-image\" data-id=\"5fde2fd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2022\/01\/sap-data-warehouse-cloud-vue-de-fait.png\" title=\"\" alt=\"Vue de fait SAP Data Warehouse Cloud\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0fc2587 elementor-widget elementor-widget-text-editor\" data-id=\"0fc2587\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The join between BKPF and FAGLFLEXA allows us to link the header data of the accounting documents to the items.<\/p><p>Beyond the modelling structure contained in the RapidViews view, the other added value of this view lies in the addition of a semantic layer above the SAP technical terms. The semantics implemented give a functional meaning to the manipulated objects, and thus considerably facilitate developments at the datamart and report level.<\/p><p>In the image above, the semantics are visible in the right-hand panel of the screen. Here you can see all the objects needed to create the profit and loss account, such as tax years, companies, G\/L accounts, reconciliation dates, local currency values, etc.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2231b053 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2231b053\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-wider\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5d2989b8\" data-id=\"5d2989b8\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-71d1b7cc elementor-widget-divider--view-line_text elementor-widget-divider--element-align-right elementor-widget elementor-widget-divider\" data-id=\"71d1b7cc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t\t<span class=\"elementor-divider__text elementor-divider__element\">\n\t\t\t\tStay connected !\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d8ea358 elementor-widget elementor-widget-heading\" data-id=\"3d8ea358\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Subscribe to the Rapid Views Newsletter !<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-70a6a005 elementor-widget elementor-widget-text-editor\" data-id=\"70a6a005\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"color: #ffffff;\">Stay up to date with our latest blog posts, upcoming webinars and news!<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-210826ef elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"210826ef\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;button_width&quot;:&quot;20&quot;,&quot;step_next_label&quot;:&quot;Suivant&quot;,&quot;step_previous_label&quot;:&quot;Pr\\u00e9c\\u00e9dent&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Inscription Newsletter (EN)\" aria-label=\"Inscription Newsletter (EN)\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"14390\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"210826ef\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"SAP Data Warehouse Cloud : FI-CO Use Case\" \/>\n\n\t\t\t\t\t\t\t<input type=\"hidden\" name=\"queried_id\" value=\"14390\"\/>\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-40 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-email\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tYour e-mail address\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-xs  elementor-field-textual\" placeholder=\"Your e-mail address\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-20 e-form__buttons\">\n\t\t\t\t\t<button class=\"elementor-button elementor-size-sm\" type=\"submit\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Register<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-917008b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"917008b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f05f27f\" data-id=\"f05f27f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-58bdf6b elementor-widget elementor-widget-heading\" data-id=\"58bdf6b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">SAP DWC - Datamart<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7484326 elementor-widget elementor-widget-text-editor\" data-id=\"7484326\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The datamart, or data cube, is a view that calls on the previously created factual view, to which we will attach dimensions containing the attributes of the objects to be manipulated (the account hierarchy, company names, cost centre designations, etc.).<\/p><p>All the dimensions we need are already developed and contained in the RapidViews FI-CO view package.<\/p><p>We will use, among others, the dimension DIM_COMPANY_DV for company attributes, the dimension DIM_P_AND_L_STATEMENT_DV for the account hierarchy, and the dimension DIM_FD_TYPE_DV for displaying document types.<\/p><p>The following is an excerpt from the RapidViews datamart modeling in SAP DWC :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b71d666 elementor-widget elementor-widget-image\" data-id=\"b71d666\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2022\/01\/sap-data-warehouse-cloud-datamart.png\" title=\"\" alt=\"Datamart SAP Data Warehouse Cloud\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-840762e elementor-widget elementor-widget-heading\" data-id=\"840762e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">SAC - Report<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a29d20c elementor-widget elementor-widget-text-editor\" data-id=\"a29d20c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The datamart developed in the SAP Data Warehouse Cloud can now be used in the SAP Analytics Cloud. Below is a representation of the profit and loss statement :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-712c982 elementor-widget elementor-widget-image\" data-id=\"712c982\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2022\/01\/sap-data-warehouse-cloud-rapport.png\" title=\"\" alt=\"Rapport SAP Data Warehouse Cloud\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3acf905 elementor-widget elementor-widget-text-editor\" data-id=\"3acf905\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In the centre we can see the balances of the profit and loss accounts, and at the bottom the detail by accounting documents allowing a more in-depth analysis.<\/p><p>On the left, filters are available to the user allowing him to filter on an accounting year or a period.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-412e44c elementor-widget elementor-widget-heading\" data-id=\"412e44c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Conclusion<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0694ea1 elementor-widget elementor-widget-text-editor\" data-id=\"0694ea1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The RapidViews datamart based on the general ledger detail of the general ledger allows the deployment of financial statements on SAP Analytics Cloud, such as the balance sheet or the income statement.<\/p><p>This datamart is integrated into the FI-CO package of RapidViews, which contains about twenty other datamarts, used for other analyses: accounts receivable, accounts payable, bank accounting, fixed asset accounting, or analyses linked to management control by cost centre, profit centre or cost of goods sold.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>This article details a use case of the SAP Data Warehouse Cloud to create a financial statement whose master data is based on the SAP FI-CO module. <\/p>\n","protected":false},"author":10,"featured_media":44487,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[575],"tags":[],"class_list":["post-14390","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-data-warehouse-cloud"],"_links":{"self":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/14390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/comments?post=14390"}],"version-history":[{"count":0,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/14390\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media\/44487"}],"wp:attachment":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media?parent=14390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/categories?post=14390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/tags?post=14390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}