C_JntVntrEquityGroupValueHelp

DDL: C_JNTVNTREQUITYGROUPVALUEHELP SQL: CJNTVNTREGRPVH Type: view CONSUMPTION
7 Fields 1 Data Sources 1 Associations

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 7 fields with key fields CompanyCode, JointVenture, JntOpgAgrmtEquityGrp. It has 1 association to related views.

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 (14)

NameValueLevelField
AbapCatalog.sqlViewName CJNTVNTREGRPVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY 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

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY JointVenture JointVenture Joint venture
KEY JntOpgAgrmtEquityGrp JntOpgAgrmtEquityGrp Equity group
JntOpgAgrmtEquityGrpText JntOpgAgrmtEquityGrpText
_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,
  JntOpgAgrmtEquityGrpText
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