I_JntVntrParCompanyOverhead

DDL: I_JNTVNTRPARCOMPANYOVERHEAD Type: view_entity BASIC
9 Fields 1 Data Sources 3 Associations

Joint Venture Parent Company Overhead

I_JntVntrParCompanyOverhead is a Basic CDS View that provides data about "Joint Venture Parent Company Overhead" in SAP S/4HANA. It reads from 1 data source (t8jvet) and exposes 9 fields with key fields CompanyCode, JointVenture, JointVentureEquityType. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t8jvet t8jvet from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode _CompanyCode.CompanyCode = $projection.CompanyCode
[0..1] I_JointVentureMasterFld _JointVentureMasterFld _JointVentureMasterFld.CompanyCode = $projection.CompanyCode and _JointVentureMasterFld.JointVenture = $projection.JointVenture
[0..1] I_JntVntrEquityTypeMaster _JntVntrEquityType _JntVntrEquityType.CompanyCode = $projection.CompanyCode and _JntVntrEquityType.JointVentureEquityType = $projection.JointVentureEquityType

Annotations (6)

NameValueLevelField
EndUserText.label Joint Venture Parent Company Overhead view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY JointVenture Volatility Name
KEY JointVentureEquityType etype RDS Entity Type
JntVntrParentCoOvhdExpnCostCtr pcocostc PCO Cost Centre
JntVntrParentCoOvhdProject PCO Project
JntVntrParentCoOvhdExpnOrder pcoordnr PCO Order
_CompanyCode _CompanyCode
_JointVentureMasterFld _JointVentureMasterFld
_JntVntrEquityType _JntVntrEquityType

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_JntVntrParCompanyOverhead.
-- 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_JntVntrParCompanyOverhead AS
SELECT
  bukrs AS CompanyCode,
  cast( vname as jv_name_cds preserving type ) AS JointVenture,
  etype AS JointVentureEquityType,
  pcocostc AS JntVntrParentCoOvhdExpnCostCtr,
  cast( pcoprojk as fis_wbsint_no_conv preserving type ) AS JntVntrParentCoOvhdProject,
  pcoordnr AS JntVntrParentCoOvhdExpnOrder
FROM t8jvet
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JointVentureMasterFld AS _JointVentureMasterFld ON _JointVentureMasterFld.CompanyCode = CompanyCode AND _JointVentureMasterFld.JointVenture = JointVenture  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityTypeMaster AS _JntVntrEquityType ON _JntVntrEquityType.CompanyCode = CompanyCode AND _JntVntrEquityType.JointVentureEquityType = JointVentureEquityType  -- association [0..1]
;

Learn More