I_JointVentureCompanyCodeVH

DDL: I_JOINTVENTURECOMPANYCODEVH SQL: IJVCOMPCODEVH Type: view BASIC
2 Fields 1 Data Sources

JVA Company Code Value Help

I_JointVentureCompanyCodeVH is a Basic CDS View (Dimension) that provides data about "JVA Company Code Value Help" in SAP S/4HANA. It reads from 1 data source (t001) and exposes 2 fields with key field CompanyCode.

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IJVCOMPCODEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
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
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label JVA Company Code Value Help view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Value
CompanyCodeName butxt Posting Text

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_JointVentureCompanyCodeVH.
-- 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.
-- SQL view name: IJVCOMPCODEVH

CREATE VIEW I_JointVentureCompanyCodeVH AS
SELECT
  cast(bukrs as fis_bukrs preserving type) AS CompanyCode,
  butxt AS CompanyCodeName
FROM t001
;

Learn More