A_PRADivnOfIntrstOwner

DDL: A_PRADIVNOFINTRSTOWNER Type: view_entity CONSUMPTION
54 Fields 1 Data Sources 3 Associations

PRA DOI Owner Information

A_PRADivnOfIntrstOwner is a Consumption CDS View that provides data about "PRA DOI Owner Information" in SAP S/4HANA. It reads from 1 data source (I_PRADivnOfIntrstOwner) and exposes 54 fields with key fields CompanyCode, PRAJointVenture, DivisionOfInterest, PRACustomerSupplierCode, PRAOwner. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PRADivnOfIntrstOwner I_PRADivnOfIntrstOwner from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_PrimaryGeogrlLocationText _PrimaryGeogrlLocationText _PrimaryGeogrlLocationText.Country = $projection.Country and _PrimaryGeogrlLocationText.PrimaryGeogrlLocation = $projection.PrimaryGeogrlLocation and _PrimaryGeogrlLocationText.Language = $session.system_language
[0..1] I_SecondaryGeogrlLocationT _SecondaryGeogrlLocationT _SecondaryGeogrlLocationT.Country = $projection.Country and _SecondaryGeogrlLocationT.PrimaryGeogrlLocation = $projection.PrimaryGeogrlLocation and _SecondaryGeogrlLocationT.SecondaryGeogrlLocation = $projection.SecondaryGeogrlLocation and _SecondaryGeogrlLocationT.Language = $session.system_language
[0..1] I_CountryText _CountryText _CountryText.Country = $projection.Country and _CountryText.Language = $session.system_language

Annotations (9)

NameValueLevelField
EndUserText.label PRA DOI Owner Information view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (54)

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
PRAJointVentureName PRAJointVentureName
Country Country Venue: Ctry/Reg
CountryName _CountryText CountryName Country
PrimaryGeogrlLocation PrimaryGeogrlLocation
PrimaryGeogrlLocationName _PrimaryGeogrlLocationText PrimaryGeogrlLocationName
SecondaryGeogrlLocation SecondaryGeogrlLocation
SecondaryGeogrlLocationName _SecondaryGeogrlLocationT SecondaryGeogrlLocationName
DivisionOfInterestName DivisionOfInterestName
DOIOwnerEffectiveToDate DOIOwnerEffectiveToDate Effective To Date
PRADivisionOfInterestNmbr PRADivisionOfInterestNmbr Div.int.no
OwnerIsJntIntrstBilgEnabled OwnerIsJntIntrstBilgEnabled JIB Offset
NetRevenueInterestRatio NetRevenueInterestRatio NRI
SuspenseReason SuspenseReason Suspense Reason
SuspenseReasonName SuspenseReasonName
TaxBasis TaxBasis Tax Free
TaxBasisName TaxBasisName
PRABearerGroup PRABearerGroup Bearer Group
PRAPayoutCode PRAPayoutCode Payout Code
OwnerPaymentStatus OwnerPaymentStatus Pay Code
OwnerPaymentStatusName OwnerPaymentStatusName
PRAEntitlementCode PRAEntitlementCode Entitlement CD
DOIOwnerIsSlidingScEnbld DOIOwnerIsSlidingScEnbld Sliding Scale
DOIOwnerIsPctOfProceedsEnbld DOIOwnerIsPctOfProceedsEnbld MMS Proceeds =
DOIOwnerIsDualAcctgEnbld DOIOwnerIsDualAcctgEnbld Dual Acct Fl
PRALegalForm PRALegalForm Entity Type
PRALegalFormName PRALegalFormName
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

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_PRADivnOfIntrstOwner.
-- 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_PRADivnOfIntrstOwner AS
SELECT
  CompanyCode,
  PRAJointVenture,
  DivisionOfInterest,
  PRACustomerSupplierCode,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  DOIOwnerEffectiveFromDate,
  PRAJointVentureName,
  Country,
  _CountryText.CountryName AS CountryName,
  PrimaryGeogrlLocation,
  _PrimaryGeogrlLocationText.PrimaryGeogrlLocationName AS PrimaryGeogrlLocationName,
  SecondaryGeogrlLocation,
  _SecondaryGeogrlLocationT.SecondaryGeogrlLocationName AS SecondaryGeogrlLocationName,
  DivisionOfInterestName,
  DOIOwnerEffectiveToDate,
  PRADivisionOfInterestNmbr,
  OwnerIsJntIntrstBilgEnabled,
  NetRevenueInterestRatio,
  SuspenseReason,
  SuspenseReasonName,
  TaxBasis,
  TaxBasisName,
  PRABearerGroup,
  PRAPayoutCode,
  OwnerPaymentStatus,
  OwnerPaymentStatusName,
  PRAEntitlementCode,
  DOIOwnerIsSlidingScEnbld,
  DOIOwnerIsPctOfProceedsEnbld,
  DOIOwnerIsDualAcctgEnbld,
  PRALegalForm,
  PRALegalFormName,
  DOIOwnerHasAcctgEntrOvrrde,
  OwnerInterestCategory,
  DOIOwnerMinRoyaltyDate,
  CompanyCodeCurrency,
  DOIOwnerMinRoyaltyAmount,
  DOIOwnerAdvncArrearsPaytCode,
  DOIOwnerCarriedBearerGrpCode,
  DOIOwnerLeaseUsePaytCode,
  JntIntrstBilgPartner,
  DOIOwnerProdnPaytOwner,
  DOIOwnrHasTakeInKindContrExprd,
  CreatedByUser,
  CreationDateTime,
  DOIOwnerHasSettlmtDiversity,
  DOIOwnerLeaseID,
  DOIOwnerNetMineralAcresVal,
  GrossRevenueInterestRatio,
  OwnerAttributeGroup,
  DynSettlmtDiversityInstrn,
  DOIOwnerRecdTitleBearerGrp
FROM I_PRADivnOfIntrstOwner
LEFT OUTER JOIN I_PrimaryGeogrlLocationText AS _PrimaryGeogrlLocationText ON _PrimaryGeogrlLocationText.Country = Country AND _PrimaryGeogrlLocationText.PrimaryGeogrlLocation = PrimaryGeogrlLocation AND _PrimaryGeogrlLocationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SecondaryGeogrlLocationT AS _SecondaryGeogrlLocationT ON _SecondaryGeogrlLocationT.Country = Country AND _SecondaryGeogrlLocationT.PrimaryGeogrlLocation = PrimaryGeogrlLocation AND _SecondaryGeogrlLocationT.SecondaryGeogrlLocation = SecondaryGeogrlLocation AND _SecondaryGeogrlLocationT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON _CountryText.Country = Country AND _CountryText.Language = $session.system_language  -- association [0..1]
;

Learn More