R_RevenueGrowthPromotionTP

DDL: R_REVENUEGROWTHPROMOTIONTP Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 4 Associations

Promotion - TP

R_RevenueGrowthPromotionTP is a Transactional CDS View that provides data about "Promotion - TP" in SAP S/4HANA. It reads from 1 data source (I_RevenueGrowthPromotion) and exposes 23 fields with key field RevnGrowthMgmtPromotionUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RevenueGrowthPromotion I_RevenueGrowthPromotion from

Associations (4)

CardinalityTargetAliasCondition
[0..*] R_RevnGrowthPromnCustAssgmtTP _PromotionCustomer
[0..*] R_RevnGrowthPromnProdAssgmtTP _PromotionProduct
[0..*] R_RevnGrowthTrdSpndAssgmtTP _PromotionTradeSpend
[0..*] R_RevnGrowthPromnDurationTP _PromotionDuration

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Promotion - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey RevnGrowthMgmtPromotionUUID view
ObjectModel.sapObjectNodeType.name RevnGrowthManagementPromotion view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY RevnGrowthMgmtPromotionUUID RevnGrowthMgmtPromotionUUID
RevnGrowthMgmtPromnExtUUID RevnGrowthMgmtPromnExtUUID
RevnGrowthMgmtPromotionID RevnGrowthMgmtPromotionID Promotion ID
RevnGrowthMgmtPromotionName RevnGrowthMgmtPromotionName
RevnGrowthMgmtPromotionType RevnGrowthMgmtPromotionType
RevnGrowthMgmtPromnProcStatus RevnGrowthMgmtPromnProcStatus User Status Code
RevnGrowthMgmtPromnClbkStatus RevnGrowthMgmtPromnClbkStatus
RevnGrowthMgmtPromnCurrency RevnGrowthMgmtPromnCurrency Valuation Crcy
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
RevnGrowthMgmtPromnRetryTimes RevnGrowthMgmtPromnRetryTimes
CreatedByUser CreatedByUser User Name
RevnGrowthPromnCrtnDateTime RevnGrowthPromnCrtnDateTime Variant created on
LastChangedByUser LastChangedByUser User Name
RevnGrowthPromnLstChgDateTime RevnGrowthPromnLstChgDateTime Variant Changed on
_PromotionCustomer _PromotionCustomer
_PromotionProduct _PromotionProduct
_PromotionTradeSpend _PromotionTradeSpend
_PromotionDuration _PromotionDuration
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division

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_RevenueGrowthPromotionTP.
-- 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_RevenueGrowthPromotionTP AS
SELECT
  RevnGrowthMgmtPromotionUUID,
  RevnGrowthMgmtPromnExtUUID,
  RevnGrowthMgmtPromotionID,
  RevnGrowthMgmtPromotionName,
  RevnGrowthMgmtPromotionType,
  RevnGrowthMgmtPromnProcStatus,
  RevnGrowthMgmtPromnClbkStatus,
  RevnGrowthMgmtPromnCurrency,
  SalesOrganization,
  DistributionChannel,
  Division,
  RevnGrowthMgmtPromnRetryTimes,
  CreatedByUser,
  RevnGrowthPromnCrtnDateTime,
  LastChangedByUser,
  RevnGrowthPromnLstChgDateTime
FROM I_RevenueGrowthPromotion
LEFT OUTER JOIN R_RevnGrowthPromnCustAssgmtTP AS _PromotionCustomer ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RevnGrowthPromnProdAssgmtTP AS _PromotionProduct ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RevnGrowthTrdSpndAssgmtTP AS _PromotionTradeSpend ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RevnGrowthPromnDurationTP AS _PromotionDuration ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More