C_JointVentureCostCenter

DDL: C_JOINTVENTURECOSTCENTER SQL: CJVCSTCENT Type: view CONSUMPTION
25 Fields 1 Data Sources

Joint Venture Cost Center

C_JointVentureCostCenter is a Consumption CDS View that provides data about "Joint Venture Cost Center" in SAP S/4HANA. It reads from 1 data source (I_JointVentureCostCenter) and exposes 25 fields with key fields ControllingArea, CostCenter, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_JointVentureCostCenter I_JointVentureCostCenter from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CJVCSTCENT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CostCenter view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Joint Venture Cost Center view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea Controlling Area
KEY CostCenter CostCenter Cost Center
KEY ValidityEndDate ValidityEndDate ValidTo
CompanyCode CompanyCode Receiver Company Code
JointVenture JointVenture Joint venture
JointVentureRecoveryCode JointVentureRecoveryCode Recovery Ind.
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JointVentureObjectType JointVentureObjectType JV Object Type
JntIntrstBillgClass JntIntrstBillgClass JIB/JIBE Class
JntIntrstBillgSubClass JntIntrstBillgSubClass JIB/JIBE SbClsA
JntVntrCostCtrIsSuspended JntVntrCostCtrIsSuspended
JntVntrCostCtrSuspensePerd JntVntrCostCtrSuspensePerd
JntVntrCostCtrSuspenseYear JntVntrCostCtrSuspenseYear
JntVntrCostCtrIsNotSuspended JntVntrCostCtrIsNotSuspended
JntVntrCostCtrNotSuspensePerd JntVntrCostCtrNotSuspensePerd
JntVntrCostCtrNotSuspenseYear JntVntrCostCtrNotSuspenseYear
_CompanyCode _CompanyCode
_Text _Text
_ControllingArea _ControllingArea
_JntIntrstBillgClass _JntIntrstBillgClass
_JntIntrstBillgSubclass _JntIntrstBillgSubclass
_JntVntrEquityType _JntVntrEquityType
_JntVntrRecoveryInd _JntVntrRecoveryInd
_JointVentureMasterFld _JointVentureMasterFld
_JointVentureSuspenseText _JointVentureSuspenseText

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_JointVentureCostCenter.
-- 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: CJVCSTCENT

CREATE VIEW C_JointVentureCostCenter AS
SELECT
  ControllingArea,
  CostCenter,
  ValidityEndDate,
  CompanyCode,
  JointVenture,
  JointVentureRecoveryCode,
  JointVentureEquityType,
  JointVentureObjectType,
  JntIntrstBillgClass,
  JntIntrstBillgSubClass,
  JntVntrCostCtrIsSuspended,
  JntVntrCostCtrSuspensePerd,
  JntVntrCostCtrSuspenseYear,
  JntVntrCostCtrIsNotSuspended,
  JntVntrCostCtrNotSuspensePerd,
  JntVntrCostCtrNotSuspenseYear
FROM I_JointVentureCostCenter
;

Learn More