I_JointVentureDesc

DDL: I_JOINTVENTUREDESC SQL: IJVTEXT Type: view BASIC
7 Fields 1 Data Sources 3 Associations

Joint Venture - Text

I_JointVentureDesc (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_JointVentureDesc is a Basic CDS View that provides data about "Joint Venture - Text" in SAP S/4HANA. It reads from 1 data source (t8jvt) and exposes 7 fields with key fields CompanyCode, Language, JointVenture. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Joint Venture Accounting
StatusReleased
Purpose
This CDS view gives the descriptions of the joint ventures available in the system and gets the information from the T8JVT table. This CDS view provides the data to answer the following business questions: How do I get descriptions of the available joint ventures? 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
The Joint Venture Accounting (JVA) should be active for the company code in the T001 table. Authorizations Users who want to access this view need to have JVA activated in the system and the authorization object J_JVA_VNT is needed.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentCA-JVA
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
t8jvt t8jvt from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..1] I_JointVentureMasterFld _JointVentureMasterFld $projection.CompanyCode = _JointVentureMasterFld.CompanyCode and $projection.JointVenture = _JointVentureMasterFld.JointVenture

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IJVTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Joint Venture - Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey JointVenture view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.modelingPattern #NONE view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Company Code
KEY Language spras Off. Language
KEY JointVenture vname Volatility Name
JointVentureName Joint Venture Name
_CompanyCode _CompanyCode
_Language _Language
_JointVentureMasterFld _JointVentureMasterFld

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_JointVentureDesc.
-- 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: IJVTEXT

CREATE VIEW I_JointVentureDesc AS
SELECT
  cast( bukrs as fis_bukrs preserving type ) AS CompanyCode,
  spras AS Language,
  vname AS JointVenture,
  cast ( vtext as jv_venturename preserving type ) AS JointVentureName
FROM t8jvt
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_JointVentureMasterFld AS _JointVentureMasterFld ON CompanyCode = _JointVentureMasterFld.CompanyCode AND JointVenture = _JointVentureMasterFld.JointVenture  -- association [1..1]
;

Learn More