What is I_JVAVentureCostObjectDetails in SAP S/4HANA?

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

Which tables does I_JVAVentureCostObjectDetails read from?

I_JVAVentureCostObjectDetails reads data from: I_JointVentureMasterFld.

What VDM layer is I_JVAVentureCostObjectDetails?

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

I_JVAVentureCostObjectDetails

DDL: I_JVAVENTURECOSTOBJECTDETAILS SQL: IJVACOSTOBJECT Type: view COMPOSITE

53 Fields 1 Data Sources 3 Associations

Joint Venture Cost Object Details

I_JVAVentureCostObjectDetails (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_JVAVentureCostObjectDetails is a Composite CDS View (Dimension) that provides data about "Joint Venture Cost Object Details" in SAP S/4HANA. It reads from 1 data source (I_JointVentureMasterFld) and exposes 53 fields with key fields CompanyCode, JointVenture. It has 3 associations to related views.

SAP Help Documentation

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

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	Deprecated
Line of Business	Cross Applications
Application Component	CA-JVA
Capabilities	Analytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction, Data Source for Search
Package	Cross Applications for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view extracts the data by combining the joint venture CDS view with the cost object, project, and order data.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which projects are listed for joint ventures?</p></li> <li><p>What are the cost objects assigned to the joint venture?</p></li> </ul> <p>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.</p>

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

Cardinality	Target	Alias	Condition
[1..1]	I_CostCenterText	_Text	`_JointVentureCostCenter.ControllingArea = _Text.ControllingArea and _JointVentureCostCenter.CostCenter = _Text.CostCenter and _JointVentureCostCenter.ValidityEndDate = _Text.ValidityEndDate and _Text.Language = $session.system_language`
[1..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[1..1]	I_JntOpgAgrmtText	_JntOpgAgrmtText	`_JointVentureMasterFld.CompanyCode = _JntOpgAgrmtText.CompanyCode and _JntOpgAgrmt.JntOpgAgrmt = _JntOpgAgrmtText.JntOpgAgrmt and _JntOpgAgrmtText.Language = $session.system_language`

Annotations (20)

Name	Value	Level
AbapCatalog.sqlViewName	IJVACOSTOBJECT	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	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
Analytics.internalName	#LOCAL	view
ObjectModel.representativeKey	JointVenture	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	I_JVAVentureCostObjectDets_2	view

Fields (53)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_JointVentureMasterFld	CompanyCode	Receiver Company Code
KEY	JointVenture	I_JointVentureMasterFld	JointVenture	Joint venture
	JntOpgAgrmt	_JntOpgAgrmt	JntOpgAgrmt	Joint Operating Agreement
	JntOpgAgrmtText	_JntOpgAgrmtText	JntOpgAgrmtText	JOA Description
	JntOpgAgrmtClass	_JntOpgAgrmt	JntOpgAgrmtClass	Joint Operating Agreement Class
	JointVentureName	_JointVentureDesc	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
	CostCenter	_JointVentureCostCenter	CostCenter	Cost Center
	CostCenterName	_Text	CostCenterName	Cost Center Name
	ValidityEndDate	_JointVentureCostCenter	ValidityEndDate	Valid To Date
	ValidityStartDate	_JointVentureCostCenter	ValidityStartDate	Validity Start Date
	JointVentureEquityGroupActive	_JntVntrValdInvmtGrp	JointVentureEquityGroupActive	Equity Group Active Status
	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
	WBSElement	_JointVentureProjectData	WBSElement	Work Breakdown Structure Element (WBS Element) Edited
	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
	OrderID	_JointVentureOrderData	OrderID	Order Number
	OrderType	_JointVentureOrderData	OrderType	Order Type
	OrderCategory	_JointVentureOrderData	OrderCategory	Order Category
	ReferenceOrder	_JointVentureOrderData	ReferenceOrder	Reference Order Number
	OrderDescription	_JointVentureOrderData	OrderDescription	Order Description
	_CompanyCode		_CompanyCode
	Currency	_CompanyCode	Currency	Valuation Crcy
	_JntOpgAgrmtText		_JntOpgAgrmtText

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_JVAVentureCostObjectDetails.
-- 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

CREATE VIEW I_JVAVentureCostObjectDetails AS
SELECT
  _JointVentureMasterFld.CompanyCode AS CompanyCode,
  _JointVentureMasterFld.JointVenture AS JointVenture,
  _JntOpgAgrmt.JntOpgAgrmt AS JntOpgAgrmt,
  _JntOpgAgrmtText.JntOpgAgrmtText AS JntOpgAgrmtText,
  _JntOpgAgrmt.JntOpgAgrmtClass AS JntOpgAgrmtClass,
  _JointVentureDesc.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.CostCenter AS CostCenter,
  _Text.CostCenterName AS CostCenterName,
  _JointVentureCostCenter.ValidityEndDate AS ValidityEndDate,
  _JointVentureCostCenter.ValidityStartDate AS ValidityStartDate,
  _JntVntrValdInvmtGrp.JointVentureEquityGroupActive AS JointVentureEquityGroupActive,
  _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.WBSElement AS WBSElement,
  _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.OrderID AS OrderID,
  _JointVentureOrderData.OrderType AS OrderType,
  _JointVentureOrderData.OrderCategory AS OrderCategory,
  _JointVentureOrderData.ReferenceOrder AS ReferenceOrder,
  _JointVentureOrderData.OrderDescription AS OrderDescription,
  _CompanyCode.Currency AS Currency
FROM I_JointVentureMasterFld AS _JointVentureMasterFld
LEFT OUTER JOIN I_CostCenterText AS _Text ON _JointVentureCostCenter.ControllingArea = _Text.ControllingArea AND _JointVentureCostCenter.CostCenter = _Text.CostCenter AND _JointVentureCostCenter.ValidityEndDate = _Text.ValidityEndDate AND _Text.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_JntOpgAgrmtText AS _JntOpgAgrmtText ON _JointVentureMasterFld.CompanyCode = _JntOpgAgrmtText.CompanyCode AND _JntOpgAgrmt.JntOpgAgrmt = _JntOpgAgrmtText.JntOpgAgrmt AND _JntOpgAgrmtText.Language = $session.system_language  -- association [1..1]
;

Depth:

I_JVAVentureCostObjectDetails view

I_JointVentureMasterFld view