A_PRAMaintVenture

DDL: A_PRAMAINTVENTURE Type: view_entity CONSUMPTION
29 Fields 1 Data Sources

Joint Venture

A_PRAMaintVenture is a Consumption CDS View that provides data about "Joint Venture" in SAP S/4HANA. It reads from 1 data source (A_PRAMaintVentureHierNode) and exposes 29 fields with key fields CompanyCode, PRAJointVenture.

Data Sources (1)

SourceAliasJoin Type
A_PRAMaintVentureHierNode A_PRAMaintVentureHierNode projection

Annotations (9)

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

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PRAJointVenture PRAJointVenture Ext vent name
PRAJointVentureInterestCode PRAJointVentureInterestCode
PRAJointVentureName PRAJointVentureName
PRAJointVentureDesc PRAJointVentureDesc
PRAJointVentureStatus PRAJointVentureStatus
PRAJointVentureStsEffctvDte PRAJointVentureStsEffctvDte
Country Country Venue: Ctry/Reg
PrimaryGeogrlLocation PrimaryGeogrlLocation
SecondaryGeogrlLocation SecondaryGeogrlLocation
PRAJointVentureAcquiredDate PRAJointVentureAcquiredDate
PRAJointVentureUsageType PRAJointVentureUsageType
PRAJointVentureOldLeaseID PRAJointVentureOldLeaseID
JointVentureIsUnit JointVentureIsUnit
PRAJointVentureHasDOIByTract PRAJointVentureHasDOIByTract
PRAJntVntrIsSubjToDrillFund PRAJntVntrIsSubjToDrillFund
PRAJntVntrOnshoreOffshoreCode PRAJntVntrOnshoreOffshoreCode
PRAJointVentureAcquiredFrom PRAJointVentureAcquiredFrom
PRAJointVentureSoldTo PRAJointVentureSoldTo
PRAJointVentureHasLegalDesc PRAJointVentureHasLegalDesc
PRAFieldID PRAFieldID
PRAJntVntrSpacingOrdNmbr PRAJntVntrSpacingOrdNmbr
PRAJntVntrLandPrptyNmbr PRAJntVntrLandPrptyNmbr
PRAJntVntrDOINameIsPrinted PRAJntVntrDOINameIsPrinted
CompanyCodeName CompanyCodeName Company Name
CountryName CountryName Country
PrimaryGeogrlLocationName PrimaryGeogrlLocationName
SecondaryGeogrlLocationName SecondaryGeogrlLocationName
GeologicFieldName GeologicFieldName

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_PRAMaintVenture.
-- 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_PRAMaintVenture AS
SELECT
  CompanyCode,
  PRAJointVenture,
  PRAJointVentureInterestCode,
  PRAJointVentureName,
  PRAJointVentureDesc,
  PRAJointVentureStatus,
  PRAJointVentureStsEffctvDte,
  Country,
  PrimaryGeogrlLocation,
  SecondaryGeogrlLocation,
  PRAJointVentureAcquiredDate,
  PRAJointVentureUsageType,
  PRAJointVentureOldLeaseID,
  JointVentureIsUnit,
  PRAJointVentureHasDOIByTract,
  PRAJntVntrIsSubjToDrillFund,
  PRAJntVntrOnshoreOffshoreCode,
  PRAJointVentureAcquiredFrom,
  PRAJointVentureSoldTo,
  PRAJointVentureHasLegalDesc,
  PRAFieldID,
  PRAJntVntrSpacingOrdNmbr,
  PRAJntVntrLandPrptyNmbr,
  PRAJntVntrDOINameIsPrinted,
  CompanyCodeName,
  CountryName,
  PrimaryGeogrlLocationName,
  SecondaryGeogrlLocationName,
  GeologicFieldName
FROM A_PRAMaintVentureHierNode
;

Learn More