I_CompanyCodeVH
Company Code
I_CompanyCodeVH (Basic)
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_CompanyCodeVH is a Basic CDS View that provides data about "Company Code" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 21 fields with key field CompanyCode. It has 8 associations to related views. It is exposed through 86 OData services (ASQL_F0702A, ASQL_F0744A, ASQL_F0770, ...). It is used in 1 Fiori application: Manage Bank Account Reviews. Part of development package FIN_COMPANY_CODE_VDM.
SAP API Hub
| Category | Basic |
|---|---|
| State | C1 |
| Line of Business | Accounting and Financial Close |
| Application Component | FI-GL-GL-N-2CL |
| Capabilities | Data Provider for Value Help,Data Source for Search |
| Extensible (Key User) | No |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Released |
| Package | Accounting and Financial Close for SAP S/4HANA Cloud Public Edition |
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 |
|---|---|---|
| t001 | t001 | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Currency | _Currency | $projection.Currency = _Currency.Currency |
| [0..1] | I_Country | _Country | $projection.Country = _Country.Country |
| [0..1] | I_Language | _Language | $projection.Language = _Language.Language |
| [0..1] | I_ChartOfAccounts | _ChartOfAccounts | $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts |
| [0..1] | I_FiscalYearVariant | _FiscalYearVariant | $projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant |
| [0..1] | I_ChartOfAccounts | _CountryChartOfAccounts | $projection.CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts |
| [0..1] | I_ControllingArea | _ControllingArea | $projection.ControllingArea = _ControllingArea.ControllingArea |
| [0..1] | I_CreditControlArea | _CreditControlArea | $projection.CreditControlArea = _CreditControlArea.CreditControlArea |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #BASIC | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| ObjectModel.representativeKey | CompanyCode | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #ORGANIZATIONAL | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.modelingPattern | #VALUE_HELP_PROVIDER | view | |
| Analytics.technicalName | IFICC__VH1 | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| Search.searchable | true | view | |
| Consumption.ranked | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| EndUserText.label | Company Code | view |
OData Services (86)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| ASQL_F0702A | ASQL_F0702A | C2 | NOT_RELEASED | |
| ASQL_F0744A | ASQL_F0744A | C2 | NOT_RELEASED | |
| ASQL_F0770 | ASQL_F0770 | C2 | NOT_RELEASED | |
| ASQL_F0773 | ASQL_F0773 | C2 | NOT_RELEASED | |
| ASQL_F0997 | ASQL_F0997 | C2 | NOT_RELEASED | |
| ASQL_F1345 | ASQL_F1345 | C2 | NOT_RELEASED | |
| ASQL_F1367 | ASQL_F1367 | C2 | NOT_RELEASED | |
| ASQL_F1575 | ASQL_F1575 | C2 | NOT_RELEASED | |
| ASQL_F1579 | ASQL_F1579 | C2 | NOT_RELEASED | |
| ASQL_F1597 | ASQL_F1597 | C2 | NOT_RELEASED | |
| ASQL_F1612 | ASQL_F1612 | C2 | NOT_RELEASED | |
| ASQL_F1665 | ASQL_F1665 | C2 | NOT_RELEASED | |
| ASQL_F1688 | ASQL_F1688 | C2 | NOT_RELEASED | |
| ASQL_F1689 | ASQL_F1689 | C2 | NOT_RELEASED | |
| ASQL_F1757 | ASQL_F1757 | C2 | NOT_RELEASED | |
| ASQL_F1861 | ASQL_F1861 | C2 | NOT_RELEASED | |
| ASQL_F1992 | ASQL_F1992 | C2 | NOT_RELEASED | |
| ASQL_F2095 | ASQL_F2095 | C2 | NOT_RELEASED | |
| ASQL_F2096 | ASQL_F2096 | C2 | NOT_RELEASED | |
| ASQL_F2129 | ASQL_F2129 | C2 | NOT_RELEASED | |
| ASQL_F2218 | ASQL_F2218 | C2 | NOT_RELEASED | |
| ASQL_F2223 | ASQL_F2223 | C2 | NOT_RELEASED | |
| ASQL_F2388 | ASQL_F2388 | C2 | NOT_RELEASED | |
| ASQL_F2441 | ASQL_F2441 | C2 | NOT_RELEASED | |
| ASQL_F2527 | ASQL_F2527 | C2 | NOT_RELEASED | |
| ASQL_F2528 | ASQL_F2528 | C2 | NOT_RELEASED | |
| ASQL_F2564 | ASQL_F2564 | C2 | NOT_RELEASED | |
| ASQL_F2599 | ASQL_F2599 | C2 | NOT_RELEASED | |
| ASQL_F2917 | ASQL_F2917 | C2 | NOT_RELEASED | |
| ASQL_F2934 | ASQL_F2934 | C2 | NOT_RELEASED | |
| ASQL_F2986A | ASQL_F2986A | C2 | NOT_RELEASED | |
| ASQL_F3034 | ASQL_F3034 | C2 | NOT_RELEASED | |
| ASQL_F3040 | ASQL_F3040 | C2 | NOT_RELEASED | |
| ASQL_F3161 | ASQL_F3161 | C2 | NOT_RELEASED | |
| ASQL_F3162A | ASQL_F3162A | C2 | NOT_RELEASED | |
| ASQL_F3302 | ASQL_F3302 | C2 | NOT_RELEASED | |
| ASQL_F3303 | ASQL_F3303 | C2 | NOT_RELEASED | |
| ASQL_F3415 | ASQL_F3415 | C2 | NOT_RELEASED | |
| ASQL_F3517 | ASQL_F3517 | C2 | NOT_RELEASED | |
| ASQL_F3548 | ASQL_F3548 | C2 | NOT_RELEASED | |
| ASQL_F3625 | ASQL_F3625 | C2 | NOT_RELEASED | |
| ASQL_F3671 | ASQL_F3671 | C2 | NOT_RELEASED | |
| ASQL_F3697 | ASQL_F3697 | C2 | NOT_RELEASED | |
| ASQL_F3697A | ASQL_F3697A | C2 | NOT_RELEASED | |
| ASQL_F3732 | ASQL_F3732 | C2 | NOT_RELEASED | |
| ASQL_F3756 | ASQL_F3756 | C2 | NOT_RELEASED | |
| ASQL_F3840 | ASQL_F3840 | C2 | NOT_RELEASED | |
| ASQL_F3871 | ASQL_F3871 | C2 | NOT_RELEASED | |
| ASQL_F3915 | ASQL_F3915 | C2 | NOT_RELEASED | |
| ASQL_F4022 | ASQL_F4022 | C2 | NOT_RELEASED | |
| ASQL_F4363 | ASQL_F4363 | C2 | NOT_RELEASED | |
| ASQL_F4755 | ASQL_F4755 | C2 | NOT_RELEASED | |
| ASQL_F4756 | ASQL_F4756 | C2 | NOT_RELEASED | |
| ASQL_F4899 | ASQL_F4899 | C2 | NOT_RELEASED | |
| ASQL_F4900 | ASQL_F4900 | C2 | NOT_RELEASED | |
| ASQL_F5175 | ASQL_F5175 | C2 | NOT_RELEASED | |
| ASQL_F5176 | ASQL_F5176 | C2 | NOT_RELEASED | |
| ASQL_F5218 | ASQL_F5218 | C2 | NOT_RELEASED | |
| ASQL_F5380 | ASQL_F5380 | C2 | NOT_RELEASED | |
| ASQL_F5470 | ASQL_F5470 | C2 | NOT_RELEASED | |
| ASQL_F5488 | ASQL_F5488 | C2 | NOT_RELEASED | |
| ASQL_F5513 | ASQL_F5513 | C2 | NOT_RELEASED | |
| ASQL_F5742 | ASQL_F5742 | C2 | NOT_RELEASED | |
| ASQL_F5796 | ASQL_F5796 | C2 | NOT_RELEASED | |
| ASQL_F5935 | ASQL_F5935 | C2 | NOT_RELEASED | |
| ASQL_F5994 | ASQL_F5994 | C2 | NOT_RELEASED | |
| ASQL_F6073 | ASQL_F6073 | C2 | NOT_RELEASED | |
| ASQL_F6123 | ASQL_F6123 | C2 | NOT_RELEASED | |
| ASQL_F6728 | ASQL_F6728 | C2 | NOT_RELEASED | |
| ASQL_F6842 | ASQL_F6842 | C2 | NOT_RELEASED | |
| ASQL_F7100 | ASQL_F7100 | C2 | NOT_RELEASED | |
| ASQL_F7103 | ASQL_F7103 | C2 | NOT_RELEASED | |
| ASQL_F7289 | ASQL_F7289 | C2 | NOT_RELEASED | |
| ASQL_F7510 | ASQL_F7510 | C2 | NOT_RELEASED | |
| ASQL_F7551 | ASQL_F7551 | C2 | NOT_RELEASED | |
| ASQL_F7690 | ASQL_F7690 | C2 | NOT_RELEASED | |
| ASQL_F7866 | ASQL_F7866 | C2 | NOT_RELEASED | |
| ASQL_F7933 | ASQL_F7933 | C2 | NOT_RELEASED | |
| ASQL_F7934 | ASQL_F7934 | C2 | NOT_RELEASED | |
| ASQL_F8654 | ASQL_F8654 | C2 | NOT_RELEASED | |
| ASQL_F8829 | ASQL_F8829 | C2 | NOT_RELEASED | |
| ASQL_F8927 | ASQL_F8927 | C2 | NOT_RELEASED | |
| ASQL_F8940 | ASQL_F8940 | C2 | NOT_RELEASED | |
| ASQL_F9287 | ASQL_F9287 | C2 | NOT_RELEASED | |
| ASQL_F9300 | ASQL_F9300 | C2 | NOT_RELEASED | |
| UI_BANKACCOUNTREVIEW_MNG | UI_BANKACCOUNTREVIEW_MNG | V2 | C1 | NOT_RELEASED |
Fiori Apps (1)
| App ID | App Name | Type | Description |
|---|---|---|---|
| F7510 | Manage Bank Account Reviews | Transactional | With this app, you can create, start and monitor the bank account review process. |
Manage Bank Account Reviews
Business Role: Cash Management Specialist
With this app, you can initiate, monitor, and control your (periodic) bank account reviews to ensure the correctness and completeness of bank account master data. You split the review of the bank accounts for a specific reference date into different review areas tailored to the responsible reviewers. For each review area, you take a snapshot of the bank account master data to be reviewed. This snapshot of bank account data is stored in the app and used during the review. When you start the review for a review area in this app, a workflow assists reviewers in conducting the bank account review for the review area. The reviewers perform the check in their My Inbox - All Items app, but you can monitor the progress of bank account review for the review areas in the Manage Bank Account Reviews app to ensure timely completion and troubleshooting during the review process. When the bank account review is complete, you can set the bank account review to Completed. For more information, see also Advanced Bank Account Review Process.
Key Features: Creation of bank account reviews and the review areas you require. In the review areas, you define the bank account selections and assign the reviewers. For more information, see also Initiate Bank Account Review. Copy bank account reviews Instead of creating a bank account review from scratch, you can also create a bank account review by copying an existing bank account review. The data of the existing bank account review, such as the review areas including the bank account selections and reviewers, are copied. In this way, you only need to enter the header data of the review, such as the review ID, the review description, and the reference date. When the bank account review is created, you can make any necessary changes to the copied data of the bank account review and the review areas. Take a snapshot of the bank account master data to be reviewed for a review area. The snapshot can be deleted all the while the review hasn't been started. Note The snapshot is stored and displayed on the Bank Account Snapshot tab of the review area in the Manage Bank Account Reviews app. When the review is started, the snapshot data is also available in the workflow task of the reviewers in the My Inbox - All Items app (F0862). When the bank account review is completed, the reviewed data is still available, for example, for external auditors. Start and monitor the reviews of the review areas. Note It is possible to stop the review as long as the first reviewer has not yet approved or rejected the bank account data in the My Inbox - All Items app. Set the bank account reviews to Completed when all bank accounts have successfully passed the review process. In this case, the correctness and completeness of the bank account master data is confirmed and the review is completed. Note If reviewers find errors in the master data, they must reject the snapshot data during the review. The review process is stopped, and the review area fails the review. In this case, the errors in the master data need to be corrected. Afterwards, within the bank account review, a new review area is created for these bank accounts, a new snapshot of the corrected bank account master data is taken, and the review process is started again. Overview table of existing bank account reviews SAP delivers a default workflow for the workflow scenario WS48000097 for execution of bank account reviews. The default workflow allows up to five reviewers to be assigned to each review area. The Manage Bank Account Reviews app is updated automatically with the review results, and the Workflow tab in the app allows the initiator to navigate to the status information of the workflow task. The change document object FCLM_BAR is used to log changes to the reviewers in the bank account review areas. The data destruction object allows you to destroy the data of completed bank account reviews after the retention period.
Fields (21)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | t001 | bukrs | Company Code |
| CompanyCodeName | t001 | butxt | Name of Company Code or Company | |
| ControllingArea | tka02 | kokrs | Controlling Area | |
| CityName | t001 | ort01 | Province | |
| Country | t001 | land1 | Country/Region Key | |
| Currency | t001 | waers | Transaction Currency | |
| Language | t001 | spras | Off. Language | |
| ChartOfAccounts | t001 | ktopl | G/L Chart of Accounts | |
| FiscalYearVariant | t001 | periv | Fiscal Year Variant | |
| Company | t001 | rcomp | Trading Partner | |
| CreditControlArea | t001 | kkber | Credit Control Area | |
| CountryChartOfAccounts | Alternative Chart of Accounts for Country/Region | |||
| FinancialManagementArea | t001 | fikrs | Financial Management Area | |
| _ControllingArea | _ControllingArea | |||
| _Country | _Country | |||
| _Currency | _Currency | |||
| _Language | _Language | |||
| _ChartOfAccounts | _ChartOfAccounts | |||
| _FiscalYearVariant | _FiscalYearVariant | |||
| _CreditControlArea | _CreditControlArea | |||
| _CountryChartOfAccounts | _CountryChartOfAccounts |
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_CompanyCodeVH.
-- 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_CompanyCodeVH AS
SELECT
t001.bukrs AS CompanyCode,
t001.butxt AS CompanyCodeName,
tka02.kokrs AS ControllingArea,
t001.ort01 AS CityName,
t001.land1 AS Country,
t001.waers AS Currency,
t001.spras AS Language,
t001.ktopl AS ChartOfAccounts,
t001.periv AS FiscalYearVariant,
t001.rcomp AS Company,
t001.kkber AS CreditControlArea,
cast(t001.ktop2 as fis_ktop2 preserving type) AS CountryChartOfAccounts,
t001.fikrs AS FinancialManagementArea
FROM t001
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CountryChartOfAccounts ON CountryChartOfAccounts = _CountryChartOfAccounts.ChartOfAccounts -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea -- association [0..1]
LEFT OUTER JOIN I_CreditControlArea AS _CreditControlArea ON CreditControlArea = _CreditControlArea.CreditControlArea -- association [0..1]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- SAP Fiori Apps Architecture — How Fiori Apps Connect to Data
- 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