A_PRAMaintDOIOwnerHierNode

DDL: A_PRAMAINTDOIOWNERHIERNODE Type: view_entity CONSUMPTION
58 Fields 1 Data Sources 4 Associations

Ownership Maintain

A_PRAMaintDOIOwnerHierNode is a Consumption CDS View that provides data about "Ownership Maintain" in SAP S/4HANA. It reads from 1 data source (I_PRAMaintDOIOwner) and exposes 58 fields with key fields CompanyCode, PRAJointVenture, DivisionOfInterest, PRACustomerSupplierCode, PRAOwner. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PRAMaintDOIOwner I_PRAMaintDOIOwner from

Associations (4)

CardinalityTargetAliasCondition
[0..*] A_PRAMaintMktgExemptHierNode _PRAMaintMktgExemptHierNode
[0..*] A_PRAMaintStateTxExmptHierNode _PRAMaintStateTxExmptHierNode
[0..*] A_PRAMaintSlidingScHdrHierNode _PRAMaintSlidingScHdrHierNode
[0..*] A_PRAMaintDOIOwnTransfHierNode _PRAMaintDOIOwnTransfHierNode

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Ownership Maintain view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name DOIOwn_Type view
OData.entitySet.name DOIOwn 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

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PRAJointVenture PRAJointVenture Ext vent name
KEY DivisionOfInterest DivisionOfInterest Venture/DOI
KEY PRACustomerSupplierCode PRACustomerSupplierCode Ocust vend cd
KEY PRAOwner PRAOwner Owner Number
KEY OwnerInterestType OwnerInterestType Opart int type
KEY OwnerInterestSequence OwnerInterestSequence Own. ISQ
KEY DOIOwnerEffectiveFromDate DOIOwnerEffectiveFromDate Effective From Date
DOIOwnerEffectiveToDate DOIOwnerEffectiveToDate Effective To Date
PRADivisionOfInterestNmbr PRADivisionOfInterestNmbr Div.int.no
OwnerIsJntIntrstBilgEnabled OwnerIsJntIntrstBilgEnabled JIB Offset
NetRevenueInterestRatio NetRevenueInterestRatio NRI
SuspenseReason SuspenseReason Suspense Reason
TaxBasis TaxBasis Tax Free
PRABearerGroup PRABearerGroup Bearer Group
PRAPayoutCode PRAPayoutCode Payout Code
OwnerPaymentStatus OwnerPaymentStatus Pay Code
PRAEntitlementCode PRAEntitlementCode Entitlement CD
DOIOwnerIsSlidingScEnbld DOIOwnerIsSlidingScEnbld Sliding Scale
DOIOwnerIsPctOfProceedsEnbld DOIOwnerIsPctOfProceedsEnbld MMS Proceeds =
DOIOwnerIsDualAcctgEnbld DOIOwnerIsDualAcctgEnbld Dual Acct Fl
PRALegalForm PRALegalForm Entity Type
DOIOwnerHasAcctgEntrOvrrde DOIOwnerHasAcctgEntrOvrrde Acct. Override
OwnerInterestCategory OwnerInterestCategory Interest Cat.
DOIOwnerMinRoyaltyDate DOIOwnerMinRoyaltyDate Min. Royalty Dt.
CompanyCodeCurrency CompanyCodeCurrency Local Currency
DOIOwnerMinRoyaltyAmount DOIOwnerMinRoyaltyAmount Min. Royalty Am.
DOIOwnerAdvncArrearsPaytCode DOIOwnerAdvncArrearsPaytCode Adv. Arrears
DOIOwnerCarriedBearerGrpCode DOIOwnerCarriedBearerGrpCode Carried Bearer
DOIOwnerLeaseUsePaytCode DOIOwnerLeaseUsePaytCode Lease Use Fuel
JntIntrstBilgPartner JntIntrstBilgPartner JIB Partner
DOIOwnerProdnPaytOwner DOIOwnerProdnPaytOwner Prod. Pay. Own.
DOIOwnrHasTakeInKindContrExprd DOIOwnrHasTakeInKindContrExprd MMS Reconcile
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
DOIOwnerHasSettlmtDiversity DOIOwnerHasSettlmtDiversity Set Div
DOIOwnerLeaseID DOIOwnerLeaseID Lease ID
DOIOwnerNetMineralAcresVal DOIOwnerNetMineralAcresVal Net Mineral Acres
GrossRevenueInterestRatio GrossRevenueInterestRatio GRI
OwnerAttributeGroup OwnerAttributeGroup Attribute Group
DynSettlmtDiversityInstrn DynSettlmtDiversityInstrn DSD Instruction
DOIOwnerRecdTitleBearerGrp DOIOwnerRecdTitleBearerGrp Record Title BG
PRACombinedProductCode PRACombinedProductCode
CompanyCodeName
DivisionOfInterestName _DivisionOfInterest DivisionOfInterestName
DOIOwnerName _PRAOwner PRAOwnerName
OwnerInterestTypeName
SuspenseReasonName
TaxBasisName
DivisionOfInterestStartDate _PRAMaintDOIHierNode DivisionOfInterestStartDate
PRACombinedProductCodeName
OwnerPaymentStatusName
PRALegalFormName
_PRAMaintDOIHierNode _PRAMaintDOIHierNode
_PRAMaintMktgExemptHierNode _PRAMaintMktgExemptHierNode
_PRAMaintStateTxExmptHierNode _PRAMaintStateTxExmptHierNode
_PRAMaintSlidingScHdrHierNode _PRAMaintSlidingScHdrHierNode
_PRAMaintDOIOwnTransfHierNode _PRAMaintDOIOwnTransfHierNode

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_PRAMaintDOIOwnerHierNode.
-- 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_PRAMaintDOIOwnerHierNode AS
SELECT
  CompanyCode,
  PRAJointVenture,
  DivisionOfInterest,
  PRACustomerSupplierCode,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  DOIOwnerEffectiveFromDate,
  DOIOwnerEffectiveToDate,
  PRADivisionOfInterestNmbr,
  OwnerIsJntIntrstBilgEnabled,
  NetRevenueInterestRatio,
  SuspenseReason,
  TaxBasis,
  PRABearerGroup,
  PRAPayoutCode,
  OwnerPaymentStatus,
  PRAEntitlementCode,
  DOIOwnerIsSlidingScEnbld,
  DOIOwnerIsPctOfProceedsEnbld,
  DOIOwnerIsDualAcctgEnbld,
  PRALegalForm,
  DOIOwnerHasAcctgEntrOvrrde,
  OwnerInterestCategory,
  DOIOwnerMinRoyaltyDate,
  CompanyCodeCurrency,
  DOIOwnerMinRoyaltyAmount,
  DOIOwnerAdvncArrearsPaytCode,
  DOIOwnerCarriedBearerGrpCode,
  DOIOwnerLeaseUsePaytCode,
  JntIntrstBilgPartner,
  DOIOwnerProdnPaytOwner,
  DOIOwnrHasTakeInKindContrExprd,
  CreatedByUser,
  CreationDateTime,
  DOIOwnerHasSettlmtDiversity,
  DOIOwnerLeaseID,
  DOIOwnerNetMineralAcresVal,
  GrossRevenueInterestRatio,
  OwnerAttributeGroup,
  DynSettlmtDiversityInstrn,
  DOIOwnerRecdTitleBearerGrp,
  PRACombinedProductCode,
  _CompanyCode[ 1: Language = $session.system_language ].CompanyCodeName AS CompanyCodeName,
  _DivisionOfInterest.DivisionOfInterestName AS DivisionOfInterestName,
  _PRAOwner.PRAOwnerName AS DOIOwnerName,
  _OwnerInterestType._Text[ 1: Language = $session.system_language ].OwnerInterestTypeName AS OwnerInterestTypeName,
  _SuspenseReason._Text[ 1: Language = $session.system_language ].SuspenseReasonName AS SuspenseReasonName,
  _TaxBasis._Text[ 1: Language = $session.system_language ].TaxBasisName AS TaxBasisName,
  _PRAMaintDOIHierNode.DivisionOfInterestStartDate AS DivisionOfInterestStartDate,
  _PRAMaintCmbndProdCode._Text[ 1: Language = $session.system_language ].PRACombinedProductCodeName AS PRACombinedProductCodeName,
  _OwnerPaymentStatus._Text[ 1: Language = $session.system_language ].OwnerPaymentStatusName AS OwnerPaymentStatusName,
  _PRALegalForm._Text[ 1: Language = $session.system_language ].PRALegalFormName AS PRALegalFormName
FROM I_PRAMaintDOIOwner
LEFT OUTER JOIN A_PRAMaintMktgExemptHierNode AS _PRAMaintMktgExemptHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_PRAMaintStateTxExmptHierNode AS _PRAMaintStateTxExmptHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_PRAMaintSlidingScHdrHierNode AS _PRAMaintSlidingScHdrHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_PRAMaintDOIOwnTransfHierNode AS _PRAMaintDOIOwnTransfHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More