I_JntVntrSubstituteCostObject

DDL: I_JNTVNTRSUBSTITUTECOSTOBJECT SQL: IJVSUBCOBJ Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Joint Venture Substitute Cost Object

I_JntVntrSubstituteCostObject is a Basic CDS View that provides data about "Joint Venture Substitute Cost Object" in SAP S/4HANA. It reads from 1 data source (t8jsc) and exposes 8 fields with key fields CompanyCode, JointVenture, JointVentureEquityGroup, JointVentureRecoveryCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
t8jsc t8jsc from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IJVSUBCOBJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Joint Venture Substitute Cost Object view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY JointVenture vname Volatility Name
KEY JointVentureEquityGroup egrup Equity group
KEY JointVentureRecoveryCode Statistical Key Figure Item
JntVntrSubstituteCostCtr sub_cctr Sub. Cost Ctr
JntVntrSubstituteWBSElmntIntID Sub. Project
JointVentureSubstituteOrder sub_ordnr Sub. Order
_CompanyCode _CompanyCode

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_JntVntrSubstituteCostObject.
-- 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: IJVSUBCOBJ

CREATE VIEW I_JntVntrSubstituteCostObject AS
SELECT
  bukrs AS CompanyCode,
  vname AS JointVenture,
  egrup AS JointVentureEquityGroup,
  cast( recid as jv_recind_cds preserving type ) AS JointVentureRecoveryCode,
  sub_cctr AS JntVntrSubstituteCostCtr,
  cast ( sub_projk as ps_s4_pspnr preserving type ) AS JntVntrSubstituteWBSElmntIntID,
  sub_ordnr AS JointVentureSubstituteOrder
FROM t8jsc
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More