C_EntProjectElementJVATP

DDL: C_ENTPROJECTELEMENTJVATP Type: view_entity CONSUMPTION
31 Fields 1 Data Sources

Enterprise Project WBS Joint Venture Accounting

C_EntProjectElementJVATP is a Consumption CDS View that provides data about "Enterprise Project WBS Joint Venture Accounting" in SAP S/4HANA. It reads from 1 data source (I_EntProjectElementJVATP_2) and exposes 31 fields with key field ProjectElementUUID.

Data Sources (1)

SourceAliasJoin Type
I_EntProjectElementJVATP_2 I_EntProjectElementJVATP_2 projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey ProjectElementUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
EndUserText.label Enterprise Project WBS Joint Venture Accounting view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ProjectElementUUID ProjectElementUUID Obj Link Entity GUID
ProjectUUID ProjectUUID Project UUID
WBSElementInternalID WBSElementInternalID WBS Internal ID
JointVenture JointVenture Joint venture
JointVentureName _JointVentureText JointVentureName
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureRecoveryCodeName _JntVntrCostRecoveryCodeText JointVentureRecoveryCodeName
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JointVentureEquityTypeName _JntVntrEquityTypeText JointVentureEquityTypeName
JntVntrProjectType JntVntrProjectType JV Object Type
JntVntrProjectTypeText _JntVntrProjectTypeText JntVntrProjectTypeText
JntIntrstBillgClass JntIntrstBillgClass JIB/JIBE Class
JntIntrstBillgClassText _JntIntrstBillgClassText JntIntrstBillgClassText
JntIntrstBillgSubClass JntIntrstBillgSubClass JIB/JIBE SbClsA
JntIntrstBillgSubClassText _JntIntrstBillgSubclassText JntIntrstBillgSubClassText
JointVentureType JointVentureType Venture Type
JointVentureTypeText _JntTypeText JointVentureTypeText
CompanyCode CompanyCode Receiver Company Code
_JointVentureVH _JointVentureVH
_JointVentureText _JointVentureText
_JntVntrCostRecoveryCodeVH _JntVntrCostRecoveryCodeVH
_JntVntrCostRecoveryCodeText _JntVntrCostRecoveryCodeText
_JntVntrEquityTypeVH _JntVntrEquityTypeVH
_JntVntrEquityTypeText _JntVntrEquityTypeText
_JntVntrProjectTypeVH _JntVntrProjectTypeVH
_JntIntrstBillgClassVH _JntIntrstBillgClassVH
_JntIntrstBillgClassText _JntIntrstBillgClassText
_JntIntrstBillgSubclassVH _JntIntrstBillgSubclassVH
_JntIntrstBillgSubclassText _JntIntrstBillgSubclassText
_JntVntrProjectTypeText _JntVntrProjectTypeText
_JntTypeText _JntTypeText

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_EntProjectElementJVATP.
-- 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 C_EntProjectElementJVATP AS
SELECT
  ProjectElementUUID,
  ProjectUUID,
  WBSElementInternalID,
  JointVenture,
  _JointVentureText.JointVentureName AS JointVentureName,
  JointVentureCostRecoveryCode,
  _JntVntrCostRecoveryCodeText.JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
  JointVentureEquityType,
  _JntVntrEquityTypeText.JointVentureEquityTypeName AS JointVentureEquityTypeName,
  JntVntrProjectType,
  _JntVntrProjectTypeText.JntVntrProjectTypeText AS JntVntrProjectTypeText,
  JntIntrstBillgClass,
  _JntIntrstBillgClassText.JntIntrstBillgClassText AS JntIntrstBillgClassText,
  JntIntrstBillgSubClass,
  _JntIntrstBillgSubclassText.JntIntrstBillgSubClassText AS JntIntrstBillgSubClassText,
  JointVentureType,
  _JntTypeText.JointVentureTypeText AS JointVentureTypeText,
  CompanyCode
FROM I_EntProjectElementJVATP_2
;

Learn More