A_PRAMaintDOIOwnTransfHierNode

DDL: A_PRAMAINTDOIOWNTRANSFHIERNODE Type: view_entity CONSUMPTION
32 Fields 2 Data Sources 1 Associations

Fund Transfer

A_PRAMaintDOIOwnTransfHierNode is a Consumption CDS View that provides data about "Fund Transfer" in SAP S/4HANA. It reads from 2 data sources (A_PRAMaintDOIOwnerHierNode, I_PRAOwnershipTransferChgHdr) and exposes 32 fields with key fields PRAFundsTransferChangeNumber, PRATransferFromCustSuplrCode, PRAFundsTransferFromOwner, PRAFndsTransfFrmOwnrIntrstType, PRAFndsTransfFrmOwnrIntrstSeq. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
A_PRAMaintDOIOwnerHierNode PRAMaintDOIOwnerHierNode inner
I_PRAOwnershipTransferChgHdr PRAOwnershipTransferChgHdr from

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_PRAMaintOwnTransfDetHierNode _PRAMaintOwnTransfDetHierNode

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Fund Transfer view
OData.entityType.name DOITransf_Type view
OData.entitySet.name DOITransf view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PRAFundsTransferChangeNumber I_PRAOwnershipTransferChgHdr PRAFundsTransferChangeNumber RTCH no.
KEY PRATransferFromCustSuplrCode I_PRAOwnershipTransferChgHdr PRATransferFromCustSuplrCode Ocust vend cd
KEY PRAFundsTransferFromOwner I_PRAOwnershipTransferChgHdr PRAFundsTransferFromOwner Old owner
KEY PRAFndsTransfFrmOwnrIntrstType I_PRAOwnershipTransferChgHdr PRAFndsTransfFrmOwnrIntrstType Opart int type
KEY PRAFndsTransfFrmOwnrIntrstSeq I_PRAOwnershipTransferChgHdr PRAFndsTransfFrmOwnrIntrstSeq Oown int seq no
KEY PRAReferenceCompanyCode A_PRAMaintDOIOwnerHierNode CompanyCode Receiver Company Code
KEY PRARefJointVentureName A_PRAMaintDOIOwnerHierNode PRAJointVenture Ext vent name
KEY PRAReferenceDOI A_PRAMaintDOIOwnerHierNode DivisionOfInterest Venture/DOI
KEY DOIOwnerEffectiveFromDate A_PRAMaintDOIOwnerHierNode DOIOwnerEffectiveFromDate
PRATransferChangeCode I_PRAOwnershipTransferChgHdr PRATransferChangeCode Tfr.chng.cd
PRATransferEffectiveFromDate I_PRAOwnershipTransferChgHdr PRATransferEffectiveFromDate Effective From Date
PRATransferEffectiveToDate I_PRAOwnershipTransferChgHdr PRATransferEffectiveToDate Effective To Date
PRAOwnerRequestDocNumber I_PRAOwnershipTransferChgHdr PRAOwnerRequestDocNumber Posted Doc. No.
PRAOwnerRequestDocYear I_PRAOwnershipTransferChgHdr PRAOwnerRequestDocYear Mat. Doc. Year
PRATransferLevelCode I_PRAOwnershipTransferChgHdr PRATransferLevelCode Tfr.lvl.cd
PRATransferChangeReasonCode I_PRAOwnershipTransferChgHdr PRATransferChangeReasonCode Reason Code
PRATransferApplicationToCode I_PRAOwnershipTransferChgHdr PRATransferApplicationToCode Appl to Cd
PRATransferIsForAllSuspense I_PRAOwnershipTransferChgHdr PRATransferIsForAllSuspense Xfer All Su Fl
SuspenseReason I_PRAOwnershipTransferChgHdr SuspenseReason Suspense Reason
OwnerPaymentStatus I_PRAOwnershipTransferChgHdr OwnerPaymentStatus Pay Code
CompanyCode I_PRAOwnershipTransferChgHdr CompanyCode Receiver Company Code
PRAJointVenture I_PRAOwnershipTransferChgHdr PRAJointVenture Ext vent name
DivisionOfInterest I_PRAOwnershipTransferChgHdr DivisionOfInterest Venture/DOI
PRATransferPriority I_PRAOwnershipTransferChgHdr PRATransferPriority Prty no.
PRAFundsTransferToOwnerCoCode I_PRAOwnershipTransferChgHdr PRAFundsTransferToOwnerCoCode Company Code
PRAFundsTransferToOwnerVenture I_PRAOwnershipTransferChgHdr PRAFundsTransferToOwnerVenture Joint venture
PRAFundsTransferToOwnerDOI I_PRAOwnershipTransferChgHdr PRAFundsTransferToOwnerDOI Venture/DOI
CreatedByUser A_PRAMaintDOIOwnerHierNode CreatedByUser User Name
CreationDateTime A_PRAMaintDOIOwnerHierNode CreationDateTime Timestamp
_PRAMaintOwnTransfDetHierNode _PRAMaintOwnTransfDetHierNode
_PRAMaintDOIOwnerHierNode _PRAMaintDOIOwnerHierNode
_PRAMaintDOIHierNode _PRAMaintDOIHierNode

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_PRAMaintDOIOwnTransfHierNode.
-- 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_PRAMaintDOIOwnTransfHierNode AS
SELECT
  PRAOwnershipTransferChgHdr.PRAFundsTransferChangeNumber AS PRAFundsTransferChangeNumber,
  PRAOwnershipTransferChgHdr.PRATransferFromCustSuplrCode AS PRATransferFromCustSuplrCode,
  PRAOwnershipTransferChgHdr.PRAFundsTransferFromOwner AS PRAFundsTransferFromOwner,
  PRAOwnershipTransferChgHdr.PRAFndsTransfFrmOwnrIntrstType AS PRAFndsTransfFrmOwnrIntrstType,
  PRAOwnershipTransferChgHdr.PRAFndsTransfFrmOwnrIntrstSeq AS PRAFndsTransfFrmOwnrIntrstSeq,
  PRAMaintDOIOwnerHierNode.CompanyCode AS PRAReferenceCompanyCode,
  PRAMaintDOIOwnerHierNode.PRAJointVenture AS PRARefJointVentureName,
  PRAMaintDOIOwnerHierNode.DivisionOfInterest AS PRAReferenceDOI,
  PRAMaintDOIOwnerHierNode.DOIOwnerEffectiveFromDate AS DOIOwnerEffectiveFromDate,
  PRAOwnershipTransferChgHdr.PRATransferChangeCode AS PRATransferChangeCode,
  PRAOwnershipTransferChgHdr.PRATransferEffectiveFromDate AS PRATransferEffectiveFromDate,
  PRAOwnershipTransferChgHdr.PRATransferEffectiveToDate AS PRATransferEffectiveToDate,
  PRAOwnershipTransferChgHdr.PRAOwnerRequestDocNumber AS PRAOwnerRequestDocNumber,
  PRAOwnershipTransferChgHdr.PRAOwnerRequestDocYear AS PRAOwnerRequestDocYear,
  PRAOwnershipTransferChgHdr.PRATransferLevelCode AS PRATransferLevelCode,
  PRAOwnershipTransferChgHdr.PRATransferChangeReasonCode AS PRATransferChangeReasonCode,
  PRAOwnershipTransferChgHdr.PRATransferApplicationToCode AS PRATransferApplicationToCode,
  PRAOwnershipTransferChgHdr.PRATransferIsForAllSuspense AS PRATransferIsForAllSuspense,
  PRAOwnershipTransferChgHdr.SuspenseReason AS SuspenseReason,
  PRAOwnershipTransferChgHdr.OwnerPaymentStatus AS OwnerPaymentStatus,
  PRAOwnershipTransferChgHdr.CompanyCode AS CompanyCode,
  PRAOwnershipTransferChgHdr.PRAJointVenture AS PRAJointVenture,
  PRAOwnershipTransferChgHdr.DivisionOfInterest AS DivisionOfInterest,
  PRAOwnershipTransferChgHdr.PRATransferPriority AS PRATransferPriority,
  PRAOwnershipTransferChgHdr.PRAFundsTransferToOwnerCoCode AS PRAFundsTransferToOwnerCoCode,
  PRAOwnershipTransferChgHdr.PRAFundsTransferToOwnerVenture AS PRAFundsTransferToOwnerVenture,
  PRAOwnershipTransferChgHdr.PRAFundsTransferToOwnerDOI AS PRAFundsTransferToOwnerDOI,
  PRAMaintDOIOwnerHierNode.CreatedByUser AS CreatedByUser,
  PRAMaintDOIOwnerHierNode.CreationDateTime AS CreationDateTime
FROM I_PRAOwnershipTransferChgHdr AS PRAOwnershipTransferChgHdr
INNER JOIN A_PRAMaintDOIOwnerHierNode AS PRAMaintDOIOwnerHierNode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_PRAMaintOwnTransfDetHierNode AS _PRAMaintOwnTransfDetHierNode ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More