R_PRAOwnerTransferHeaderTP

DDL: R_PRAOWNERTRANSFERHEADERTP Type: view_entity TRANSACTIONAL
34 Fields 1 Data Sources 2 Associations

PRA Owner Transfer Header - TP

R_PRAOwnerTransferHeaderTP is a Transactional CDS View that provides data about "PRA Owner Transfer Header - TP" in SAP S/4HANA. It reads from 1 data source (I_PRAOwnerTransferHeader) and exposes 34 fields with key fields PRAOwnerRequestDocNumber, PRAOwnerRequestDocYear. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PRAOwnerTransferHeader TransferHeader from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_PRAOwnrTransfChangeSelectTP _TransferSelect
[0..*] R_PRAOwnerTransferDetailTP _TransferDetail

Annotations (10)

NameValueLevelField
EndUserText.label PRA Owner Transfer Header - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.sapObjectNodeType.name PRAOwnerTransferDocument view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AbapCatalog.extensibility.extensible true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY PRAOwnerRequestDocNumber PRAOwnerRequestDocNumber
KEY PRAOwnerRequestDocYear PRAOwnerRequestDocYear Mat. Doc. Year
PRATransferEffectiveFromDate PRATransferEffectiveFromDate Effective From Date
PRATransferEffectiveToDate PRATransferEffectiveToDate Effective To Date
PRARequestDocumentType PRARequestDocumentType
PRARequestDocumentDescription PRARequestDocumentDescription Description
PRAOwnerRequestDescription PRAOwnerRequestDescription Unit
PRAReferenceDocNumber PRAReferenceDocNumber Ref. doc.nr
PRARequestStatus PRARequestStatus Well Status
PRARequestProcessDateTime PRARequestProcessDateTime Process date
PRARequestProcessedByUser PRARequestProcessedByUser Processed by
PRASuspenseStartDate PRASuspenseStartDate Sus.start dt
PRAIsTransferInventory PRAIsTransferInventory Xfer. inventory
PRAIsTransferImbalance PRAIsTransferImbalance Xfer. imbalance
PRAIsDOICheckIn PRAIsDOICheckIn Check-in DOI
PRATransferChangeReasonCode PRATransferChangeReasonCode
PRAIsCorrectionsAllowed PRAIsCorrectionsAllowed Generate PPA
PRAAccumulatedInterestRatio PRAAccumulatedInterestRatio Accum.int
PRATransferType PRATransferType Transfer Type
DOIDivisionOrderIsGnrtd DOIDivisionOrderIsGnrtd Generated DO
PRADivnOfIntrstCreatedByUser PRADivnOfIntrstCreatedByUser Created By
PRADivisionEffectiveDate PRADivisionEffectiveDate Div Eff Date
PRAOilMktgEffectiveDate PRAOilMktgEffectiveDate Oil/condensate
PRAGasMktgEffectiveDate PRAGasMktgEffectiveDate Gas/NGL
PRAPriorPerdNotifProcDte PRAPriorPerdNotifProcDte PPN proc. date
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
PRABurdenAllocationRule PRABurdenAllocationRule Burden Alloc. Rule
PRAOwnershipFundsType PRAOwnershipFundsType Owner Funds Type
_TransferSelect _TransferSelect
_TransferDetail _TransferDetail
_DocType _DocType
_TransferCode _TransferCode
_User _User

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 R_PRAOwnerTransferHeaderTP.
-- 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 R_PRAOwnerTransferHeaderTP AS
SELECT
  PRAOwnerRequestDocNumber,
  PRAOwnerRequestDocYear,
  PRATransferEffectiveFromDate,
  PRATransferEffectiveToDate,
  PRARequestDocumentType,
  PRARequestDocumentDescription,
  PRAOwnerRequestDescription,
  PRAReferenceDocNumber,
  PRARequestStatus,
  PRARequestProcessDateTime,
  PRARequestProcessedByUser,
  PRASuspenseStartDate,
  PRAIsTransferInventory,
  PRAIsTransferImbalance,
  PRAIsDOICheckIn,
  PRATransferChangeReasonCode,
  PRAIsCorrectionsAllowed,
  PRAAccumulatedInterestRatio,
  PRATransferType,
  DOIDivisionOrderIsGnrtd,
  PRADivnOfIntrstCreatedByUser,
  PRADivisionEffectiveDate,
  PRAOilMktgEffectiveDate,
  PRAGasMktgEffectiveDate,
  PRAPriorPerdNotifProcDte,
  CreatedByUser,
  CreationDateTime,
  PRABurdenAllocationRule,
  PRAOwnershipFundsType
FROM I_PRAOwnerTransferHeader AS TransferHeader
LEFT OUTER JOIN R_PRAOwnrTransfChangeSelectTP AS _TransferSelect ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PRAOwnerTransferDetailTP AS _TransferDetail ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More