What is I_JVAVentureCostObjectDets_2 in SAP S/4HANA?

I_JVAVentureCostObjectDets_2 is a composite CDS view in SAP S/4HANA. Joint Venture Cost Object Details It contains 52 fields.

Which tables does I_JVAVentureCostObjectDets_2 read from?

I_JVAVentureCostObjectDets_2 reads data from: I_JointVentureMasterFld.

What VDM layer is I_JVAVentureCostObjectDets_2?

I_JVAVentureCostObjectDets_2 is classified as a Composite view that combines data from multiple basic views.

I_JVAVentureCostObjectDets_2

DDL: I_JVAVENTURECOSTOBJECTDETS_2 SQL: IJVACOSTOBJECT_2 Type: view COMPOSITE

52 Fields 1 Data Sources 2 Associations

Joint Venture Cost Object Details

I_JVAVentureCostObjectDets_2 (Composite)

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

Cross Applications

I_JVAVentureCostObjectDets_2 is a Composite CDS View (Cube) that provides data about "Joint Venture Cost Object Details" in SAP S/4HANA. It reads from 1 data source (I_JointVentureMasterFld) and exposes 52 fields with key fields CompanyCode, JntOpgAgrmt, JointVenture, CostCenter, WBSElement. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Joint Venture Accounting
Data Category	Dimension
Status	Released

Purpose
This CDS view extracts the data by combining the joint venture CDS view with the cost object, project, and order data. This CDS view provides the data to answer the following business questions: Which projects are listed for joint ventures? What are the cost objects assigned to the joint venture? 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
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: J_JVA_VNT (Joint Venture Accounting: venture master)

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	CA-JVA
Capabilities	Data Provider for Analytical Queries, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Search
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_JointVentureMasterFld	_JointVentureMasterFld	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[1..1]	I_JntOpgAgrmt	_JntOpgAgrmt	`_JointVentureMasterFld.CompanyCode = _JntOpgAgrmt.CompanyCode and _JointVentureMasterFld.JntOpgAgrmt = _JntOpgAgrmt.JntOpgAgrmt`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	IJVACOSTOBJECT_2	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Joint Venture Cost Object Details	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view

Fields (52)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_JointVentureMasterFld	CompanyCode	Receiver Company Code
KEY	JntOpgAgrmt	I_JointVentureMasterFld	JntOpgAgrmt	Joint Operating Agreement
KEY	JointVenture	I_JointVentureMasterFld	JointVenture	Joint venture
KEY	CostCenter	_JointVentureCostCenter	CostCenter	Cost Center
KEY	WBSElement	_JointVentureProjectData	WBSElement	Work Breakdown Structure Element (WBS Element) Edited
KEY	InternalOrder	_JointVentureOrderData	InternalOrder	Order Number
	JntOpgAgrmtText			JOA Description
	JntOpgAgrmtClass	_JntOpgAgrmt	JntOpgAgrmtClass	Joint Operating Agreement Class
	JointVentureName			Joint Venture Name
	JointVentureType	I_JointVentureMasterFld	JointVentureType	Venture Type
	JointVentureOperator	I_JointVentureMasterFld	JointVentureOperator	Type of OPTION component in row type of a Ranges type
	JVAVentureClass	I_JointVentureMasterFld	JVAVentureClass	Venture Class
	JntVntrBillgCutbackIsBlk	I_JointVentureMasterFld	JntVntrBillgCutbackIsBlk	Block Joint Venture for Cutback and Billing
	JntVntrDrillingPayRate	I_JointVentureMasterFld	JntVntrDrillingPayRate	% Drilling Payroll Burden in U.S.
	JntVntrNonDrillingPayRate	I_JointVentureMasterFld	JntVntrNonDrillingPayRate	Non-Drilling % to Apply for U.S. Payroll Burden Clearing
	JntVntrParentCoOvhdExpnCostCtr	I_JointVentureMasterFld	JntVntrParentCoOvhdExpnCostCtr	Cost Centre for posting PCO expense
	JntVntrParentCoOvhdProject	I_JointVentureMasterFld	JntVntrParentCoOvhdProject	WBS Element
	JntVntrParentCoOvhdExpnOrder	I_JointVentureMasterFld	JntVntrParentCoOvhdExpnOrder	Parent Company Overhead Expense Order
	JntVntrSubstituteCostCtr	I_JointVentureMasterFld	JntVntrSubstituteCostCtr	Substitute Cost Centre
	JntVntrProperty	I_JointVentureMasterFld	JntVntrProperty	JV Property ID
	ControllingArea	_JointVentureCostCenter	ControllingArea	Controlling Area
	CostCenterName			Cost Center Name
	ValidityEndDate	_JointVentureCostCenter	ValidityEndDate	Valid To Date
	ValidityStartDate	_JointVentureCostCenter	ValidityStartDate	Validity Start Date
	CostCenterCategory	_JointVentureCostCenter	CostCenterCategory	Cost Center Category
	ProfitCenter	_JointVentureCostCenter	ProfitCenter	Profit Center
	FunctionalArea	_JointVentureCostCenter	FunctionalArea	Sendr Fctl Area
	JointVentureRecoveryCode	_JointVentureCostCenter	JointVentureRecoveryCode	Recovery Indicator
	JointVentureEquityType	_JointVentureCostCenter	JointVentureEquityType	Joint Venture Equity Type
	JointVentureObjectType	_JointVentureCostCenter	JointVentureObjectType	Joint Venture Object Type
	JointVentureClass	_JointVentureCostCenter	JointVentureClass	JIB/JIBE Class
	JointVentureSubClass	_JointVentureCostCenter	JointVentureSubClass	JIB/JIBE Subclass A
	WBSDescription	_JointVentureProjectData	WBSDescription	Work Breakdown Structure Element Name
	WBSElementShortID	_JointVentureProjectData	WBSElementShortID	WBS element short identification
	ProjectType	_JointVentureProjectData	ProjectType	Project Type
	WBSElementHierarchyLevel	_JointVentureProjectData	WBSElementHierarchyLevel	Level in Project Hierarchy
	WBSElementIsPlanningElement	_JointVentureProjectData	WBSElementIsPlanningElement	Indicator: Planning element
	WBSIsAccountAssignmentElement	_JointVentureProjectData	WBSIsAccountAssignmentElement	Indicator: Account assignment element
	WBSElementIsBillingElement	_JointVentureProjectData	WBSElementIsBillingElement	Indicator: Billing element
	NetworkAssignmentType	_JointVentureProjectData	NetworkAssignmentType	Network assignment
	RequestingCostCenter	_JointVentureProjectData	RequestingCostCenter	Requesting cost center
	ResponsibleCostCenter	_JointVentureProjectData	ResponsibleCostCenter	Responsible Cost Center
	FunctionalLocation	_JointVentureProjectData	FunctionalLocation	Functional location
	JointVentureCostRecoveryCode	_JointVentureProjectData	JointVentureCostRecoveryCode	Recovery Indicator
	JntVntrProjectType	_JointVentureProjectData	JntVntrProjectType	Joint Venture Object Type
	OrderType	_JointVentureOrderData	OrderType	Order Type
	OrderCategory	_JointVentureOrderData	OrderCategory	Order Category
	ReferenceOrder	_JointVentureOrderData	ReferenceOrder	Reference Order Number
	InternalOrderDescription	_JointVentureOrderData	InternalOrderDescription	Internal Order Description
	_CompanyCode		_CompanyCode
	Currency	_CompanyCode	Currency	Valuation Crcy
	_JntOpgAgrmt		_JntOpgAgrmt

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_JVAVentureCostObjectDets_2.
-- 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: IJVACOSTOBJECT_2

CREATE VIEW I_JVAVentureCostObjectDets_2 AS
SELECT
  _JointVentureMasterFld.CompanyCode AS CompanyCode,
  _JointVentureMasterFld.JntOpgAgrmt AS JntOpgAgrmt,
  _JointVentureMasterFld.JointVenture AS JointVenture,
  _JointVentureCostCenter.CostCenter AS CostCenter,
  _JointVentureProjectData.WBSElement AS WBSElement,
  _JointVentureOrderData.InternalOrder AS InternalOrder,
  _JntOpgAgrmt._JntOpgAgrmtText[1:Language = $session.system_language].JntOpgAgrmtText AS JntOpgAgrmtText,
  _JntOpgAgrmt.JntOpgAgrmtClass AS JntOpgAgrmtClass,
  _JointVentureMasterFld._JointVentureDesc[1:Language = $session.system_language].JointVentureName AS JointVentureName,
  _JointVentureMasterFld.JointVentureType AS JointVentureType,
  _JointVentureMasterFld.JointVentureOperator AS JointVentureOperator,
  _JointVentureMasterFld.JVAVentureClass AS JVAVentureClass,
  _JointVentureMasterFld.JntVntrBillgCutbackIsBlk AS JntVntrBillgCutbackIsBlk,
  _JointVentureMasterFld.JntVntrDrillingPayRate AS JntVntrDrillingPayRate,
  _JointVentureMasterFld.JntVntrNonDrillingPayRate AS JntVntrNonDrillingPayRate,
  _JointVentureMasterFld.JntVntrParentCoOvhdExpnCostCtr AS JntVntrParentCoOvhdExpnCostCtr,
  _JointVentureMasterFld.JntVntrParentCoOvhdProject AS JntVntrParentCoOvhdProject,
  _JointVentureMasterFld.JntVntrParentCoOvhdExpnOrder AS JntVntrParentCoOvhdExpnOrder,
  _JointVentureMasterFld.JntVntrSubstituteCostCtr AS JntVntrSubstituteCostCtr,
  _JointVentureMasterFld.JntVntrProperty AS JntVntrProperty,
  _JointVentureCostCenter.ControllingArea AS ControllingArea,
  _JointVentureCostCenter._Text[1:Language = $session.system_language].CostCenterName AS CostCenterName,
  _JointVentureCostCenter.ValidityEndDate AS ValidityEndDate,
  _JointVentureCostCenter.ValidityStartDate AS ValidityStartDate,
  _JointVentureCostCenter.CostCenterCategory AS CostCenterCategory,
  _JointVentureCostCenter.ProfitCenter AS ProfitCenter,
  _JointVentureCostCenter.FunctionalArea AS FunctionalArea,
  _JointVentureCostCenter.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  _JointVentureCostCenter.JointVentureEquityType AS JointVentureEquityType,
  _JointVentureCostCenter.JointVentureObjectType AS JointVentureObjectType,
  _JointVentureCostCenter.JointVentureClass AS JointVentureClass,
  _JointVentureCostCenter.JointVentureSubClass AS JointVentureSubClass,
  _JointVentureProjectData.WBSDescription AS WBSDescription,
  _JointVentureProjectData.WBSElementShortID AS WBSElementShortID,
  _JointVentureProjectData.ProjectType AS ProjectType,
  _JointVentureProjectData.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  _JointVentureProjectData.WBSElementIsPlanningElement AS WBSElementIsPlanningElement,
  _JointVentureProjectData.WBSIsAccountAssignmentElement AS WBSIsAccountAssignmentElement,
  _JointVentureProjectData.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  _JointVentureProjectData.NetworkAssignmentType AS NetworkAssignmentType,
  _JointVentureProjectData.RequestingCostCenter AS RequestingCostCenter,
  _JointVentureProjectData.ResponsibleCostCenter AS ResponsibleCostCenter,
  _JointVentureProjectData.FunctionalLocation AS FunctionalLocation,
  _JointVentureProjectData.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  _JointVentureProjectData.JntVntrProjectType AS JntVntrProjectType,
  _JointVentureOrderData.OrderType AS OrderType,
  _JointVentureOrderData.OrderCategory AS OrderCategory,
  _JointVentureOrderData.ReferenceOrder AS ReferenceOrder,
  _JointVentureOrderData.InternalOrderDescription AS InternalOrderDescription,
  _CompanyCode.Currency AS Currency
FROM I_JointVentureMasterFld AS _JointVentureMasterFld
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_JntOpgAgrmt AS _JntOpgAgrmt ON _JointVentureMasterFld.CompanyCode = _JntOpgAgrmt.CompanyCode AND _JointVentureMasterFld.JntOpgAgrmt = _JntOpgAgrmt.JntOpgAgrmt  -- association [1..1]
;

Depth:

I_JVAVentureCostObjectDets_2 view

I_JointVentureMasterFld view