A_PRAMaintOwnTransfDetHierNode

DDL: A_PRAMAINTOWNTRANSFDETHIERNODE Type: view_entity CONSUMPTION
30 Fields 2 Data Sources

Funds Transfer Items

A_PRAMaintOwnTransfDetHierNode is a Consumption CDS View that provides data about "Funds Transfer Items" in SAP S/4HANA. It reads from 2 data sources (I_PRAOwnershipTransferChgDet, A_PRAMaintDOIOwnTransfHierNode) and exposes 30 fields with key fields PRAFundsTransferChangeNumber, PRATransferFromCustSuplrCode, PRAFundsTransferFromOwner, PRAFndsTransfFrmOwnrIntrstType, PRAFndsTransfFrmOwnrIntrstSeq.

Data Sources (2)

SourceAliasJoin Type
I_PRAOwnershipTransferChgDet PRAOwnershipTransferChgDet from
A_PRAMaintDOIOwnTransfHierNode PRAOwnershipTransferChgHdr inner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Funds Transfer Items view
OData.entityType.name DOITransfDet_Type view
OData.entitySet.name DOITransfDet 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 (30)

KeyFieldSource TableSource FieldDescription
KEY PRAFundsTransferChangeNumber I_PRAOwnershipTransferChgDet PRAFundsTransferChangeNumber RTCH no.
KEY PRATransferFromCustSuplrCode I_PRAOwnershipTransferChgDet PRATransferFromCustSuplrCode Ocust vend cd
KEY PRAFundsTransferFromOwner I_PRAOwnershipTransferChgDet PRAFundsTransferFromOwner Old owner
KEY PRAFndsTransfFrmOwnrIntrstType I_PRAOwnershipTransferChgDet PRAFndsTransfFrmOwnrIntrstType Opart int type
KEY PRAFndsTransfFrmOwnrIntrstSeq I_PRAOwnershipTransferChgDet PRAFndsTransfFrmOwnrIntrstSeq Oown int seq no
KEY PRATransferToCustSuplrCode I_PRAOwnershipTransferChgDet PRATransferToCustSuplrCode Nwcust vend cd
KEY PRAFundsTransferToOwner I_PRAOwnershipTransferChgDet PRAFundsTransferToOwner New owner
KEY PRAFndsTransfToOwnrIntrstType I_PRAOwnershipTransferChgDet PRAFndsTransfToOwnrIntrstType Nwpart int type
KEY PRAFndsTransfToOwnrIntrstSeq I_PRAOwnershipTransferChgDet PRAFndsTransfToOwnrIntrstSeq ISQ
KEY PRAReferenceCompanyCode A_PRAMaintDOIOwnTransfHierNode CompanyCode Receiver Company Code
KEY PRARefJointVentureName A_PRAMaintDOIOwnTransfHierNode PRAJointVenture Ext vent name
KEY PRAReferenceDOI A_PRAMaintDOIOwnTransfHierNode DivisionOfInterest Venture/DOI
KEY DOIOwnerEffectiveFromDate A_PRAMaintDOIOwnTransfHierNode DOIOwnerEffectiveFromDate
KEY CompanyCode I_PRAOwnershipTransferChgDet CompanyCode Receiver Company Code
KEY PRAJointVenture I_PRAOwnershipTransferChgDet PRAJointVenture Ext vent name
KEY DivisionOfInterest I_PRAOwnershipTransferChgDet DivisionOfInterest Venture/DOI
KEY PRATransferEffectiveFromDate I_PRAOwnershipTransferChgDet PRATransferEffectiveFromDate Effective From Date
PRATransferChangeCode I_PRAOwnershipTransferChgDet PRATransferChangeCode Tfr.chng.cd
PRATransferEffectiveToDate I_PRAOwnershipTransferChgDet PRATransferEffectiveToDate Effective To Date
PRAOwnerRequestDocNumber I_PRAOwnershipTransferChgDet PRAOwnerRequestDocNumber Posted Doc. No.
PRAOwnerRequestDocYear I_PRAOwnershipTransferChgDet PRAOwnerRequestDocYear Mat. Doc. Year
PRAOwnerRequestDocItmNmbr I_PRAOwnershipTransferChgDet PRAOwnerRequestDocItmNmbr Sort No.
NetRevenueInterestRatio I_PRAOwnershipTransferChgDet NetRevenueInterestRatio NRI dec.
PRAOwnerAllocationRatio I_PRAOwnershipTransferChgDet PRAOwnerAllocationRatio Al decm
OverrideOwnerPaymentStatus I_PRAOwnershipTransferChgDet OverrideOwnerPaymentStatus Pay Code
OverrideSuspenseReason I_PRAOwnershipTransferChgDet OverrideSuspenseReason Suspense Reason
PRAOverrideLeaseID I_PRAOwnershipTransferChgDet PRAOverrideLeaseID Lease ID
CreatedByUser I_PRAOwnershipTransferChgDet CreatedByUser User Name
CreationDateTime I_PRAOwnershipTransferChgDet CreationDateTime Timestamp
_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_PRAMaintOwnTransfDetHierNode.
-- 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_PRAMaintOwnTransfDetHierNode AS
SELECT
  PRAOwnershipTransferChgDet.PRAFundsTransferChangeNumber AS PRAFundsTransferChangeNumber,
  PRAOwnershipTransferChgDet.PRATransferFromCustSuplrCode AS PRATransferFromCustSuplrCode,
  PRAOwnershipTransferChgDet.PRAFundsTransferFromOwner AS PRAFundsTransferFromOwner,
  PRAOwnershipTransferChgDet.PRAFndsTransfFrmOwnrIntrstType AS PRAFndsTransfFrmOwnrIntrstType,
  PRAOwnershipTransferChgDet.PRAFndsTransfFrmOwnrIntrstSeq AS PRAFndsTransfFrmOwnrIntrstSeq,
  PRAOwnershipTransferChgDet.PRATransferToCustSuplrCode AS PRATransferToCustSuplrCode,
  PRAOwnershipTransferChgDet.PRAFundsTransferToOwner AS PRAFundsTransferToOwner,
  PRAOwnershipTransferChgDet.PRAFndsTransfToOwnrIntrstType AS PRAFndsTransfToOwnrIntrstType,
  PRAOwnershipTransferChgDet.PRAFndsTransfToOwnrIntrstSeq AS PRAFndsTransfToOwnrIntrstSeq,
  PRAOwnershipTransferChgHdr.CompanyCode AS PRAReferenceCompanyCode,
  PRAOwnershipTransferChgHdr.PRAJointVenture AS PRARefJointVentureName,
  PRAOwnershipTransferChgHdr.DivisionOfInterest AS PRAReferenceDOI,
  PRAOwnershipTransferChgHdr.DOIOwnerEffectiveFromDate AS DOIOwnerEffectiveFromDate,
  PRAOwnershipTransferChgDet.CompanyCode AS CompanyCode,
  PRAOwnershipTransferChgDet.PRAJointVenture AS PRAJointVenture,
  PRAOwnershipTransferChgDet.DivisionOfInterest AS DivisionOfInterest,
  PRAOwnershipTransferChgDet.PRATransferEffectiveFromDate AS PRATransferEffectiveFromDate,
  PRAOwnershipTransferChgDet.PRATransferChangeCode AS PRATransferChangeCode,
  PRAOwnershipTransferChgDet.PRATransferEffectiveToDate AS PRATransferEffectiveToDate,
  PRAOwnershipTransferChgDet.PRAOwnerRequestDocNumber AS PRAOwnerRequestDocNumber,
  PRAOwnershipTransferChgDet.PRAOwnerRequestDocYear AS PRAOwnerRequestDocYear,
  PRAOwnershipTransferChgDet.PRAOwnerRequestDocItmNmbr AS PRAOwnerRequestDocItmNmbr,
  PRAOwnershipTransferChgDet.NetRevenueInterestRatio AS NetRevenueInterestRatio,
  PRAOwnershipTransferChgDet.PRAOwnerAllocationRatio AS PRAOwnerAllocationRatio,
  PRAOwnershipTransferChgDet.OverrideOwnerPaymentStatus AS OverrideOwnerPaymentStatus,
  PRAOwnershipTransferChgDet.OverrideSuspenseReason AS OverrideSuspenseReason,
  PRAOwnershipTransferChgDet.PRAOverrideLeaseID AS PRAOverrideLeaseID,
  PRAOwnershipTransferChgDet.CreatedByUser AS CreatedByUser,
  PRAOwnershipTransferChgDet.CreationDateTime AS CreationDateTime
FROM I_PRAOwnershipTransferChgDet AS PRAOwnershipTransferChgDet
INNER JOIN A_PRAMaintDOIOwnTransfHierNode AS PRAOwnershipTransferChgHdr ON /* join condition not captured in parsed metadata */
;

Learn More