C_JntVntrEquityGroupValueHelp

DDL: C_JNTVNTREQUITYGROUPVALUEHELP SQL: CJNTVNTREGRPVH Type: view CONSUMPTION
6 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Joint Venture Equity Group Value Help

C_JntVntrEquityGroupValueHelp is a Consumption CDS View that provides data about "Joint Venture Equity Group Value Help" in SAP S/4HANA. It reads from 1 data source (I_JntVntrEquityGrp) and exposes 6 fields with key fields CompanyCode, JointVenture, JntOpgAgrmtEquityGrp. It has 1 association to related views. It is exposed through 1 OData service (UI_JVA_COST_ANALYSIS). It is used in 1 Fiori application: JVA Cost Analysis.

Data Sources (1)

SourceAliasJoin Type
I_JntVntrEquityGrp I_JntVntrEquityGrp from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_JntVntrEquityGrpText _JntVntrEquityGrpText $projection.CompanyCode = _JntVntrEquityGrpText.CompanyCode and $projection.JointVenture = _JntVntrEquityGrpText.JointVenture and $projection.JntOpgAgrmtEquityGrp = _JntVntrEquityGrpText.JntOpgAgrmtEquityGrp

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CJNTVNTREGRPVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CompanyCode view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view
EndUserText.label Joint Venture Equity Group Value Help view

OData Services (1)

ServiceBindingVersionContractRelease
UI_JVA_COST_ANALYSIS UI_JVA_COST_ANALYSIS V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4498 JVA Cost Analysis Transactional You use this feature to display information on gross or net cost and working capital for a venture and equity group by company code, period, year to date and inception to date basis. The default configuration variant consists only billable expenses for the gross and net expense and working capital values. The partner share percentages are displayed by partner for the selected equity group. A pie chart displays the working interest of the venture partners for the selected equity group.

JVA Cost Analysis

Business Role: Others

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY JointVenture JointVenture Joint venture
KEY JntOpgAgrmtEquityGrp JntOpgAgrmtEquityGrp Equity group
_CompanyCode _CompanyCode
_JointVentureMasterFld _JointVentureMasterFld
_JntVntrEquityGrpText _JntVntrEquityGrpText

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 C_JntVntrEquityGroupValueHelp.
-- 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: CJNTVNTREGRPVH

CREATE VIEW C_JntVntrEquityGroupValueHelp AS
SELECT
  CompanyCode,
  JointVenture,
  JntOpgAgrmtEquityGrp
FROM I_JntVntrEquityGrp
LEFT OUTER JOIN I_JntVntrEquityGrpText AS _JntVntrEquityGrpText ON CompanyCode = _JntVntrEquityGrpText.CompanyCode AND JointVenture = _JntVntrEquityGrpText.JointVenture AND JntOpgAgrmtEquityGrp = _JntVntrEquityGrpText.JntOpgAgrmtEquityGrp  -- association [0..*]
;

Learn More