I_ChargePlanPriceParameterTP

DDL: I_CHARGEPLANPRICEPARAMETERTP SQL: ICHPLPARAMPRTP Type: view TRANSACTIONAL
34 Fields 1 Data Sources 2 Associations

Transactional view for charge plan parameter from type price

I_ChargePlanPriceParameterTP is a Transactional CDS View that provides data about "Transactional view for charge plan parameter from type price" in SAP S/4HANA. It reads from 1 data source (I_ChargePlanParameter) and exposes 34 fields with key field ChargePlanParameterUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChargePlanParameter ChargePlanPriceParameter from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SubscrpnProdSpecTP _SubscrpnProdSpecTP _SubscrpnProdSpecTP.SubscrpnProdSpecUUID = $projection.SubscrpnProdSpecUUID
[1..1] I_ChargePlanAssignmentTP _ChargePlanAssignmentTP _ChargePlanAssignmentTP.ChargePlanAssignmentUUID = $projection.ChargePlanAssignmentUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICHPLPARAMPRTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transactional view for charge plan parameter from type price view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.writeActivePersistence CRMS4D_SOM_PA view
ObjectModel.writeDraftPersistence CRMS4D_SOM_PAP_D view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ChargePlanParameterUUID I_ChargePlanParameter ChargePlanParameterUUID Parameter UUID
CreatedByUser I_ChargePlanParameter CreatedByUser User Name
CreationDateTime I_ChargePlanParameter CreationDateTime Timestamp
LastChangedByUser I_ChargePlanParameter LastChangedByUser User Name
LastChangeDateTime I_ChargePlanParameter LastChangeDateTime Timestamp
ChargePlanAssignmentUUID I_ChargePlanParameter ChargePlanAssignmentUUID Assignment UUID
SubscrpnProdSpecUUID I_ChargePlanParameter SubscrpnProdSpecUUID Sub. Prod. Data UUID
ChargePlanParameterID I_ChargePlanParameter ChargePlanParameterID Parameter ID
ChargePlanParameterDescription I_ChargePlanParameter ChargePlanParameterDescription Parameter Descript.
ChargePlanParameterType I_ChargePlanParameter ChargePlanParameterType Parameter Type
ChargePlanParameterUsage I_ChargePlanParameter ChargePlanParameterUsage Parameter Usage
ChargePlanParameterUseValue I_ChargePlanParameter ChargePlanParameterUseValue Value Used
ChrgPlanParameterNumericValue I_ChargePlanParameter ChrgPlanParameterNumericValue Numeric Value
ChrgPlnParamNmrcDefaultValue I_ChargePlanParameter ChrgPlnParamNmrcDefaultValue Numeric Value
ChargePlanParameterStringValue I_ChargePlanParameter ChargePlanParameterStringValue String Value
ChrgPlnParamStringDefaultValue I_ChargePlanParameter ChrgPlnParamStringDefaultValue String Value
ChargePlanParameterDateValue I_ChargePlanParameter ChargePlanParameterDateValue Date Parameter Value
ChrgPlnParamDateDefaultValue I_ChargePlanParameter ChrgPlnParamDateDefaultValue Date Parameter Value
BRFFunctionUUID I_ChargePlanParameter BRFFunctionUUID BRFplus UUID
ChargePlanParameterIsMandatory I_ChargePlanParameter ChargePlanParameterIsMandatory Parameter Is Mandato
ConvergentChargingTableClassID I_ChargePlanParameter ConvergentChargingTableClassID Class ID
Characteristic I_ChargePlanParameter Characteristic Field Name
AllowanceDefinitionGroupUUID I_ChargePlanParameter AllowanceDefinitionGroupUUID Allo. Def. Grp. UUID
AllowanceDefinitionGroupID I_ChargePlanParameter AllowanceDefinitionGroupID Allo. Def. Group ID
ConditionType I_ChargePlanParameter ConditionType Condition type
VariantCondition I_ChargePlanParameter VariantCondition Variant Key
ChrgPlnParamPriceIsMandatory I_ChargePlanParameter ChrgPlnParamPriceIsMandatory Price Param. is Mand
SbsChrgPlnParamIsRlvtForPrrtn I_ChargePlanParameter SbsChrgPlnParamIsRlvtForPrrtn Relevant for Proration
_LastChangedByUser _LastChangedByUser
_CreatedByUser _CreatedByUser
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
_SubscrpnProdSpecTP _SubscrpnProdSpecTP
_ChargePlanAssignmentTP _ChargePlanAssignmentTP

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_ChargePlanPriceParameterTP.
-- 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.
-- SQL view name: ICHPLPARAMPRTP

CREATE VIEW I_ChargePlanPriceParameterTP AS
SELECT
  ChargePlanPriceParameter.ChargePlanParameterUUID AS ChargePlanParameterUUID,
  ChargePlanPriceParameter.CreatedByUser AS CreatedByUser,
  ChargePlanPriceParameter.CreationDateTime AS CreationDateTime,
  ChargePlanPriceParameter.LastChangedByUser AS LastChangedByUser,
  ChargePlanPriceParameter.LastChangeDateTime AS LastChangeDateTime,
  ChargePlanPriceParameter.ChargePlanAssignmentUUID AS ChargePlanAssignmentUUID,
  ChargePlanPriceParameter.SubscrpnProdSpecUUID AS SubscrpnProdSpecUUID,
  ChargePlanPriceParameter.ChargePlanParameterID AS ChargePlanParameterID,
  ChargePlanPriceParameter.ChargePlanParameterDescription AS ChargePlanParameterDescription,
  ChargePlanPriceParameter.ChargePlanParameterType AS ChargePlanParameterType,
  ChargePlanPriceParameter.ChargePlanParameterUsage AS ChargePlanParameterUsage,
  ChargePlanPriceParameter.ChargePlanParameterUseValue AS ChargePlanParameterUseValue,
  ChargePlanPriceParameter.ChrgPlanParameterNumericValue AS ChrgPlanParameterNumericValue,
  ChargePlanPriceParameter.ChrgPlnParamNmrcDefaultValue AS ChrgPlnParamNmrcDefaultValue,
  ChargePlanPriceParameter.ChargePlanParameterStringValue AS ChargePlanParameterStringValue,
  ChargePlanPriceParameter.ChrgPlnParamStringDefaultValue AS ChrgPlnParamStringDefaultValue,
  ChargePlanPriceParameter.ChargePlanParameterDateValue AS ChargePlanParameterDateValue,
  ChargePlanPriceParameter.ChrgPlnParamDateDefaultValue AS ChrgPlnParamDateDefaultValue,
  ChargePlanPriceParameter.BRFFunctionUUID AS BRFFunctionUUID,
  ChargePlanPriceParameter.ChargePlanParameterIsMandatory AS ChargePlanParameterIsMandatory,
  ChargePlanPriceParameter.ConvergentChargingTableClassID AS ConvergentChargingTableClassID,
  ChargePlanPriceParameter.Characteristic AS Characteristic,
  ChargePlanPriceParameter.AllowanceDefinitionGroupUUID AS AllowanceDefinitionGroupUUID,
  ChargePlanPriceParameter.AllowanceDefinitionGroupID AS AllowanceDefinitionGroupID,
  ChargePlanPriceParameter.ConditionType AS ConditionType,
  ChargePlanPriceParameter.VariantCondition AS VariantCondition,
  ChargePlanPriceParameter.ChrgPlnParamPriceIsMandatory AS ChrgPlnParamPriceIsMandatory,
  ChargePlanPriceParameter.SbsChrgPlnParamIsRlvtForPrrtn AS SbsChrgPlnParamIsRlvtForPrrtn
FROM I_ChargePlanParameter AS ChargePlanPriceParameter
LEFT OUTER JOIN I_SubscrpnProdSpecTP AS _SubscrpnProdSpecTP ON _SubscrpnProdSpecTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [1..1]
LEFT OUTER JOIN I_ChargePlanAssignmentTP AS _ChargePlanAssignmentTP ON _ChargePlanAssignmentTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [1..1]
;

Learn More