R_ChargePlanAssignmentTP

DDL: R_CHARGEPLANASSIGNMENTTP Type: view_entity TRANSACTIONAL
34 Fields 1 Data Sources 13 Associations

Subscription Charge Plan Assignment - TP

R_ChargePlanAssignmentTP is a Transactional CDS View that provides data about "Subscription Charge Plan Assignment - TP" in SAP S/4HANA. It reads from 1 data source (I_ChargePlanAssignment) and exposes 34 fields with key field ChargePlanAssignmentUUID. It has 13 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChargePlanAssignment I_ChargePlanAssignment from

Associations (13)

CardinalityTargetAliasCondition
[1..1] R_SubscrpnProdSpecTP _SubscrpnProdSpec $projection.SubscrpnProdSpecUUID = _SubscrpnProdSpec.SubscrpnProdSpecUUID
[0..*] R_ChargePlanAssignmentTTP _ChargePlanAssignmentT
[0..*] R_ChargePlanPriceParameterTP _ChargePlanPriceParameter
[0..*] R_ChrgPlnPrTblParameterTP _ChrgPlnPrTblParameter
[0..*] R_ChrgPlanDateParameterTP _ChrgPlanDateParameter
[0..*] R_ChrgPlanNmrcParameterTP _ChrgPlanNmrcParameter
[0..*] R_ChrgPlnStringParameterTP _ChrgPlnStringParameter
[0..*] R_ChrgPlanTableParameterTP _ChrgPlanTableParameter
[0..*] R_ChrgPlnAllwncParameterTP _ChrgPlnAllwncParameter
[0..*] R_ChargePlanCountedObjectTP _ChargePlanCountedObject
[0..*] R_ChrgPlnAcctAssignmentTP _ChrgPlnAcctAssignment
[0..*] R_SOM_UnsupportedParamTP _SOM_UnsupportedParam
[0..*] R_ChrgPlnTechResourceTP _ChrgPlnTechResource

Annotations (9)

NameValueLevelField
EndUserText.label Subscription Charge Plan Assignment - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey ChargePlanAssignmentUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ChargePlanAssignmentUUID ChargePlanAssignmentUUID Assignment UUID
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
CrossCatalogMappingVersionUUID CrossCatalogMappingVersionUUID Version UUID
SubscrpnProdSpecUUID SubscrpnProdSpecUUID Sub. Prod. Data UUID
ChargePlanAssignmentID ChargePlanAssignmentID Assignment ID
ChargePlanAssignmentType ChargePlanAssignmentType Assignment Type
ChargePlanID ChargePlanID Charge Plan ID
ChargePlanDescription ChargePlanDescription Charge Plan Descript
ChargePlanActivationCondition ChargePlanActivationCondition Activation
BRFFunctionUUID BRFFunctionUUID BRFplus UUID
Characteristic Characteristic Field Name
CharacteristicValue CharacteristicValue Char. Value
SbsChrgPlnAssgmtIsRlvtForPrrtn SbsChrgPlnAssgmtIsRlvtForPrrtn Relevant for Proration
_CreatedByUser _CreatedByUser
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUser _LastChangedByUser
_LastChangedByUserContactCard _LastChangedByUserContactCard
_SubscrpnProdSpec _SubscrpnProdSpec
_CrsCtlgMappingVersion _CrsCtlgMappingVersion
_ChargePlanAssignmentT _ChargePlanAssignmentT
_ChargePlanPriceParameter _ChargePlanPriceParameter
_ChrgPlnPrTblParameter _ChrgPlnPrTblParameter
_ChrgPlanDateParameter _ChrgPlanDateParameter
_ChrgPlanNmrcParameter _ChrgPlanNmrcParameter
_ChrgPlnStringParameter _ChrgPlnStringParameter
_ChrgPlanTableParameter _ChrgPlanTableParameter
_ChrgPlnAllwncParameter _ChrgPlnAllwncParameter
_ChargePlanCountedObject _ChargePlanCountedObject
_ChrgPlnAcctAssignment _ChrgPlnAcctAssignment
_SOM_UnsupportedParam _SOM_UnsupportedParam
_ChrgPlnTechResource _ChrgPlnTechResource

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_ChargePlanAssignmentTP.
-- 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_ChargePlanAssignmentTP AS
SELECT
  ChargePlanAssignmentUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  CrossCatalogMappingVersionUUID,
  SubscrpnProdSpecUUID,
  ChargePlanAssignmentID,
  ChargePlanAssignmentType,
  ChargePlanID,
  ChargePlanDescription,
  ChargePlanActivationCondition,
  BRFFunctionUUID,
  Characteristic,
  CharacteristicValue,
  SbsChrgPlnAssgmtIsRlvtForPrrtn
FROM I_ChargePlanAssignment
LEFT OUTER JOIN R_SubscrpnProdSpecTP AS _SubscrpnProdSpec ON SubscrpnProdSpecUUID = _SubscrpnProdSpec.SubscrpnProdSpecUUID  -- association [1..1]
LEFT OUTER JOIN R_ChargePlanAssignmentTTP AS _ChargePlanAssignmentT ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChargePlanPriceParameterTP AS _ChargePlanPriceParameter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChrgPlnPrTblParameterTP AS _ChrgPlnPrTblParameter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChrgPlanDateParameterTP AS _ChrgPlanDateParameter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChrgPlanNmrcParameterTP AS _ChrgPlanNmrcParameter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChrgPlnStringParameterTP AS _ChrgPlnStringParameter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChrgPlanTableParameterTP AS _ChrgPlanTableParameter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChrgPlnAllwncParameterTP AS _ChrgPlnAllwncParameter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChargePlanCountedObjectTP AS _ChargePlanCountedObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChrgPlnAcctAssignmentTP AS _ChrgPlnAcctAssignment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SOM_UnsupportedParamTP AS _SOM_UnsupportedParam ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_ChrgPlnTechResourceTP AS _ChrgPlnTechResource ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More