I_CompanyCodeVH

DDL: I_COMPANYCODEVH Type: view_entity BASIC Package: FIN_COMPANY_CODE_VDM

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

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentFI-GL-GL-N-2CL
CapabilitiesData Provider for Value Help,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Associations (8)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

ServiceBindingVersionContractRelease
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 IDApp NameTypeDescription
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)

KeyFieldSource TableSource FieldDescription
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]
;