R_PRAIntMktgRateTransactionTP

DDL: R_PRAINTMKTGRATETRANSACTIONTP Type: view_entity TRANSACTIONAL Package: OIU_RAP_REV_MKT
16 Fields 1 Data Sources

PRA Internal Marketing Rate Trans - TP

R_PRAIntMktgRateTransactionTP is a Transactional CDS View that provides data about "PRA Internal Marketing Rate Trans - TP" in SAP S/4HANA. It reads from 1 data source (I_PRAIntMktgRateTransaction) and exposes 16 fields with key fields PRAMarketingRateNumber, MarketingType. Part of development package OIU_RAP_REV_MKT.

Data Sources (1)

SourceAliasJoin Type
I_PRAIntMktgRateTransaction I_PRAIntMktgRateTransaction from

Annotations (12)

NameValueLevelField
EndUserText.label PRA Internal Marketing Rate Trans - TP view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name PRAInternalMarketingRateTrans_Type view
OData.entitySet.name PRAIntMktgRateTrans view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name PRAInternalMarketingRateTrans view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PRAMarketingRateNumber PRAMarketingRateNumber Mkt rate no
KEY MarketingType MarketingType Mrktg Type Code
UnitOfMeasure UnitOfMeasure Unit Protected Qty
MarketingDeductionRateAmount MarketingDeductionRateAmount Mkting Ded Rt
MarketingCostDeductionPercent MarketingCostDeductionPercent Deduct %
CompanyCode CompanyCode Receiver Company Code
JointVenture JointVenture Joint venture
DivisionOfInterest DivisionOfInterest Venture/DOI
CreatedByUser CreatedByUser User Name
PRACreationDateTime PRACreationDateTime Time Stamp
_MarketingType _MarketingType
_UnitOfMeasure _UnitOfMeasure
_CompanyCode _CompanyCode
_PRAJointVenture _PRAJointVenture
_DivisionOfInterest _DivisionOfInterest
_PRAIntMktgRateHeader _PRAIntMktgRateHeader

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_PRAIntMktgRateTransactionTP.
-- 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_PRAIntMktgRateTransactionTP AS
SELECT
  PRAMarketingRateNumber,
  MarketingType,
  UnitOfMeasure,
  MarketingDeductionRateAmount,
  MarketingCostDeductionPercent,
  CompanyCode,
  JointVenture,
  DivisionOfInterest,
  CreatedByUser,
  PRACreationDateTime
FROM I_PRAIntMktgRateTransaction
;

Learn More