A_PRAOwnerTransferDetailTP

DDL: A_PRAOWNERTRANSFERDETAILTP Type: view_entity CONSUMPTION
45 Fields 1 Data Sources 1 OData Services

PRA Owner Transfer Change Detail

A_PRAOwnerTransferDetailTP is a Consumption CDS View that provides data about "PRA Owner Transfer Change Detail" in SAP S/4HANA. It reads from 1 data source (R_PRAOwnerTransferDetailTP) and exposes 45 fields with key fields PRAOwnerRequestDocNumber, PRAOwnerRequestDocYear, PRAOwnerRequestDocItmNmbr. It is exposed through 1 OData service (API_PRAOWNERTRANSFER).

Data Sources (1)

SourceAliasJoin Type
R_PRAOwnerTransferDetailTP R_PRAOwnerTransferDetailTP projection

Annotations (12)

NameValueLevelField
EndUserText.label PRA Owner Transfer Change Detail view
OData.entityType.name TransferDetail_Type view
OData.entitySet.name TransferDetail view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name PRAOwnerTransferDetails view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_PRAOWNERTRANSFER API_PRAOWNERTRANSFER V4 C2 C1

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY PRAOwnerRequestDocNumber PRAOwnerRequestDocNumber
KEY PRAOwnerRequestDocYear PRAOwnerRequestDocYear
KEY PRAOwnerRequestDocItmNmbr PRAOwnerRequestDocItmNmbr
PRATransferFromCustSuplrCode PRATransferFromCustSuplrCode
PRAFundsTransferFromOwner PRAFundsTransferFromOwner
PRAFndsTransfFrmOwnrIntrstType PRAFndsTransfFrmOwnrIntrstType
PRAFndsTransfFrmOwnrIntrstSeq PRAFndsTransfFrmOwnrIntrstSeq
PRATransferToCustSuplrCode PRATransferToCustSuplrCode
PRAFundsTransferToOwner PRAFundsTransferToOwner
PRAFndsTransfToOwnrIntrstType PRAFndsTransfToOwnrIntrstType
PRAFndsTransfToOwnrIntrstSeq PRAFndsTransfToOwnrIntrstSeq
PRAInterestAmount PRAInterestAmount
PRAOvrrdeTaxFreeCode PRAOvrrdeTaxFreeCode
PRAOvrrdeEntitlementCode PRAOvrrdeEntitlementCode
PRAOvrrdeOwnerIsJntIntrstBillg PRAOvrrdeOwnerIsJntIntrstBillg
PRAOvrrdeJntIntrstBillgPartner PRAOvrrdeJntIntrstBillgPartner
PRAOvrrdePayoutCode PRAOvrrdePayoutCode
PRAOvrrdeOwnerIsPctOfProceeds PRAOvrrdeOwnerIsPctOfProceeds
PRAOvrrdeOwnerIsDualAcctgEnbld PRAOvrrdeOwnerIsDualAcctgEnbld
PRAOvrrdeOwnerMinRoyaltyDate PRAOvrrdeOwnerMinRoyaltyDate
PRAOvrrdeDOICurrency PRAOvrrdeDOICurrency
PRAOvrrdeOwnerMinRoyaltyAmount PRAOvrrdeOwnerMinRoyaltyAmount
PRAOvrrdeOwnrAdvncArrearsCode PRAOvrrdeOwnrAdvncArrearsCode
PRAOvrrdeCustomerNumber PRAOvrrdeCustomerNumber
MineralMnngSrvcRecnclnIsOvrrde MineralMnngSrvcRecnclnIsOvrrde
PRAIsCommentsOvrrde PRAIsCommentsOvrrde
PRAOverrideOwnerPaymentStatus PRAOverrideOwnerPaymentStatus
PRAOverrideSuspenseReason PRAOverrideSuspenseReason
PRAIsCombination PRAIsCombination
PRABearerGroupCode PRABearerGroupCode
PRAOvrrdeOwnerLeaseUsePaytCode PRAOvrrdeOwnerLeaseUsePaytCode
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
PRAIsEscheat PRAIsEscheat
PRAIsNotJntIntrstBillgOffset PRAIsNotJntIntrstBillgOffset
DOIOwnerHasSettlmtDiversity DOIOwnerHasSettlmtDiversity
PRASettlmtDiversityIsOvrrde PRASettlmtDiversityIsOvrrde
PRASettlmtDiversityIsTrnsfd PRASettlmtDiversityIsTrnsfd
DOIOwnerLeaseID DOIOwnerLeaseID
PRAOverrideLeaseID PRAOverrideLeaseID
PRALeaseIdIsRemoved PRALeaseIdIsRemoved
PRAOverrideOwnerAttributeGrp PRAOverrideOwnerAttributeGrp
PRAOwnrAvailyGrpIsRemoved PRAOwnrAvailyGrpIsRemoved
PRAOvrrdeDynamicSDInstrn PRAOvrrdeDynamicSDInstrn
DynSettlmtDiversityIsRemoved DynSettlmtDiversityIsRemoved

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_PRAOwnerTransferDetailTP.
-- 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_PRAOwnerTransferDetailTP AS
SELECT
  PRAOwnerRequestDocNumber,
  PRAOwnerRequestDocYear,
  PRAOwnerRequestDocItmNmbr,
  PRATransferFromCustSuplrCode,
  PRAFundsTransferFromOwner,
  PRAFndsTransfFrmOwnrIntrstType,
  PRAFndsTransfFrmOwnrIntrstSeq,
  PRATransferToCustSuplrCode,
  PRAFundsTransferToOwner,
  PRAFndsTransfToOwnrIntrstType,
  PRAFndsTransfToOwnrIntrstSeq,
  PRAInterestAmount,
  PRAOvrrdeTaxFreeCode,
  PRAOvrrdeEntitlementCode,
  PRAOvrrdeOwnerIsJntIntrstBillg,
  PRAOvrrdeJntIntrstBillgPartner,
  PRAOvrrdePayoutCode,
  PRAOvrrdeOwnerIsPctOfProceeds,
  PRAOvrrdeOwnerIsDualAcctgEnbld,
  PRAOvrrdeOwnerMinRoyaltyDate,
  PRAOvrrdeDOICurrency,
  PRAOvrrdeOwnerMinRoyaltyAmount,
  PRAOvrrdeOwnrAdvncArrearsCode,
  PRAOvrrdeCustomerNumber,
  MineralMnngSrvcRecnclnIsOvrrde,
  PRAIsCommentsOvrrde,
  PRAOverrideOwnerPaymentStatus,
  PRAOverrideSuspenseReason,
  PRAIsCombination,
  PRABearerGroupCode,
  PRAOvrrdeOwnerLeaseUsePaytCode,
  CreatedByUser,
  CreationDateTime,
  PRAIsEscheat,
  PRAIsNotJntIntrstBillgOffset,
  DOIOwnerHasSettlmtDiversity,
  PRASettlmtDiversityIsOvrrde,
  PRASettlmtDiversityIsTrnsfd,
  DOIOwnerLeaseID,
  PRAOverrideLeaseID,
  PRALeaseIdIsRemoved,
  PRAOverrideOwnerAttributeGrp,
  PRAOwnrAvailyGrpIsRemoved,
  PRAOvrrdeDynamicSDInstrn,
  DynSettlmtDiversityIsRemoved
FROM R_PRAOwnerTransferDetailTP
;

Learn More