I_RevnGrowthPromnCustAssgmt

DDL: I_REVNGROWTHPROMNCUSTASSGMT Type: view_entity BASIC

Promotion Customer

I_RevnGrowthPromnCustAssgmt is a Basic CDS View that provides data about "Promotion Customer" in SAP S/4HANA. It reads from 1 data source (rgm_promn_custas) and exposes 10 fields with key field RevnGrowthPromnCustAssgmtUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
rgm_promn_custas rgm_promn_custas from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Promotion Customer view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RevnGrowthPromnCustAssgmtUUID customer_uuid ID
RevnGrowthMgmtPromotionUUID promotion_uuid
Customer customer Sold-to Party
ValidityStartDate start_date Valn start date
ValidityEndDate end_date Valn End date
CreatedByUser created_by Version Created By
RevnGrowthPromnCrtnDateTime created_on Variant created on
LastChangedByUser changed_by User Name
RevnGrowthPromnLstChgDateTime changed_on Variant Changed on
_Customer _Customer

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 I_RevnGrowthPromnCustAssgmt.
-- 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 I_RevnGrowthPromnCustAssgmt AS
SELECT
  customer_uuid AS RevnGrowthPromnCustAssgmtUUID,
  promotion_uuid AS RevnGrowthMgmtPromotionUUID,
  Customer,
  start_date AS ValidityStartDate,
  end_date AS ValidityEndDate,
  created_by AS CreatedByUser,
  created_on AS RevnGrowthPromnCrtnDateTime,
  changed_by AS LastChangedByUser,
  changed_on AS RevnGrowthPromnLstChgDateTime
FROM rgm_promn_custas
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;