A_PRAMaintVentureHierNode

DDL: A_PRAMAINTVENTUREHIERNODE Type: view_entity CONSUMPTION
30 Fields 1 Data Sources 1 Associations

Joint Venture

A_PRAMaintVentureHierNode is a Consumption CDS View that provides data about "Joint Venture" in SAP S/4HANA. It reads from 1 data source (I_PRAMaintVenture) and exposes 30 fields with key fields CompanyCode, PRAJointVenture. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PRAMaintVenture I_PRAMaintVenture from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_PRAMaintUnitVentureHierNode _UnitVenture

Annotations (11)

NameValueLevelField
EndUserText.label Joint Venture view
OData.entityType.name Venture_Type view
OData.entitySet.name Venture view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PRAJointVenture PRAJointVenture Ext vent name
PRAJointVentureInterestCode PRAJointVentureInterestCode Interest Code
PRAJointVentureName PRAJointVentureName Venture Name
PRAJointVentureDesc PRAJointVentureDesc Unit
PRAJointVentureStatus PRAJointVentureStatus PRA Venture Sta
PRAJointVentureStsEffctvDte PRAJointVentureStsEffctvDte Status Eff Date
Country Country Venue: Ctry/Reg
PrimaryGeogrlLocation PrimaryGeogrlLocation Primary geo.loc
SecondaryGeogrlLocation SecondaryGeogrlLocation Secndry geo.loc
PRAJointVentureAcquiredDate
PRAJointVentureUsageType PRAJointVentureUsageType Usage Type
PRAJointVentureOldLeaseID PRAJointVentureOldLeaseID Old lease ID
JointVentureIsUnit JointVentureIsUnit Unit venture
PRAJointVentureHasDOIByTract PRAJointVentureHasDOIByTract DOI By Tract
PRAJntVntrIsSubjToDrillFund PRAJntVntrIsSubjToDrillFund Drill Fund
PRAJntVntrOnshoreOffshoreCode PRAJntVntrOnshoreOffshoreCode On/Offshore
PRAJointVentureAcquiredFrom PRAJointVentureAcquiredFrom Party Acq From
PRAJointVentureSoldTo PRAJointVentureSoldTo Party Sold To
PRAJointVentureHasLegalDesc PRAJointVentureHasLegalDesc Legal desc.
PRAFieldID PRAFieldID Logical Field
PRAJntVntrSpacingOrdNmbr PRAJntVntrSpacingOrdNmbr Space order no.
PRAJntVntrLandPrptyNmbr PRAJntVntrLandPrptyNmbr LPN No
PRAJntVntrDOINameIsPrinted PRAJntVntrDOINameIsPrinted DOI Print Flag
CompanyCodeName
CountryName
PrimaryGeogrlLocationName
SecondaryGeogrlLocationName
GeologicFieldName _Field GeologicFieldName
_UnitVenture _UnitVenture

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 A_PRAMaintVentureHierNode.
-- 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 A_PRAMaintVentureHierNode AS
SELECT
  CompanyCode,
  PRAJointVenture,
  PRAJointVentureInterestCode,
  PRAJointVentureName,
  PRAJointVentureDesc,
  PRAJointVentureStatus,
  PRAJointVentureStsEffctvDte,
  Country,
  PrimaryGeogrlLocation,
  SecondaryGeogrlLocation,
  cast( '00000000' as abap.dats ) AS PRAJointVentureAcquiredDate,
  PRAJointVentureUsageType,
  PRAJointVentureOldLeaseID,
  JointVentureIsUnit,
  PRAJointVentureHasDOIByTract,
  PRAJntVntrIsSubjToDrillFund,
  PRAJntVntrOnshoreOffshoreCode,
  PRAJointVentureAcquiredFrom,
  PRAJointVentureSoldTo,
  PRAJointVentureHasLegalDesc,
  PRAFieldID,
  PRAJntVntrSpacingOrdNmbr,
  PRAJntVntrLandPrptyNmbr,
  PRAJntVntrDOINameIsPrinted,
  _CompanyCode[ 1: Language = $session.system_language ].CompanyCodeName AS CompanyCodeName,
  _Location._Country._Text[ 1: Language = $session.system_language ].CountryName AS CountryName,
  _Location._PrimaryGeogrlLocation._Text[ 1: Language = $session.system_language ].PrimaryGeogrlLocationName AS PrimaryGeogrlLocationName,
  _Location._Text[ 1: Language = $session.system_language ].SecondaryGeogrlLocationName AS SecondaryGeogrlLocationName,
  _Field.GeologicFieldName AS GeologicFieldName
FROM I_PRAMaintVenture
LEFT OUTER JOIN A_PRAMaintUnitVentureHierNode AS _UnitVenture ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More