C_ChrgPlanDateParameterTP

DDL: C_CHRGPLANDATEPARAMETERTP SQL: CCHPLPARAMDTP Type: view CONSUMPTION
34 Fields 1 Data Sources 3 Associations

Consumption view for charge plan parameter from type date

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

Data Sources (1)

SourceAliasJoin Type
I_ChrgPlanDateParameterTP ChrgPlanDateParameter from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_SubscrpnProdSpecTP _SubscrpnProdSpecTP _SubscrpnProdSpecTP.SubscrpnProdSpecUUID = $projection.SubscrpnProdSpecUUID
[1..1] C_ChargePlanAssignmentTP _ChargePlanAssignmentTP _ChargePlanAssignmentTP.ChargePlanAssignmentUUID = $projection.ChargePlanAssignmentUUID
[0..1] C_SOM_ChrgPlnParamUseValVH _SOM_ChrgPlnParamUseValVH _SOM_ChrgPlnParamUseValVH.ChargePlanParameterUseValue = $projection.ChargePlanParameterUseValue

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CCHPLPARAMDTP view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Consumption view for charge plan parameter from type date view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ChargePlanParameterUUID I_ChrgPlanDateParameterTP ChargePlanParameterUUID Parameter UUID
CreatedByUser I_ChrgPlanDateParameterTP CreatedByUser User Name
CreationDateTime I_ChrgPlanDateParameterTP CreationDateTime Timestamp
LastChangedByUser I_ChrgPlanDateParameterTP LastChangedByUser User Name
LastChangeDateTime I_ChrgPlanDateParameterTP LastChangeDateTime Timestamp
ChargePlanAssignmentUUID I_ChrgPlanDateParameterTP ChargePlanAssignmentUUID Assignment UUID
SubscrpnProdSpecUUID I_ChrgPlanDateParameterTP SubscrpnProdSpecUUID Sub. Prod. Data UUID
ChargePlanParameterID I_ChrgPlanDateParameterTP ChargePlanParameterID Parameter ID
ChargePlanParameterDescription I_ChrgPlanDateParameterTP ChargePlanParameterDescription Parameter Descript.
ChargePlanParameterType I_ChrgPlanDateParameterTP ChargePlanParameterType Parameter Type
ChargePlanParameterUsage I_ChrgPlanDateParameterTP ChargePlanParameterUsage Parameter Usage
ChargePlanParameterUseValue I_ChrgPlanDateParameterTP ChargePlanParameterUseValue Value Used
ChrgPlanParameterNumericValue I_ChrgPlanDateParameterTP ChrgPlanParameterNumericValue Numeric Value
ChrgPlnParamNmrcDefaultValue I_ChrgPlanDateParameterTP ChrgPlnParamNmrcDefaultValue Numeric Value
ChargePlanParameterStringValue I_ChrgPlanDateParameterTP ChargePlanParameterStringValue String Value
ChrgPlnParamStringDefaultValue I_ChrgPlanDateParameterTP ChrgPlnParamStringDefaultValue String Value
ChargePlanParameterDateValue I_ChrgPlanDateParameterTP ChargePlanParameterDateValue Date Parameter Value
ChrgPlnParamDateDefaultValue I_ChrgPlanDateParameterTP ChrgPlnParamDateDefaultValue Date Parameter Value
BRFFunctionUUID I_ChrgPlanDateParameterTP BRFFunctionUUID BRFplus UUID
BRFFunctionText
ChargePlanParameterIsMandatory I_ChrgPlanDateParameterTP ChargePlanParameterIsMandatory Parameter Is Mandato
ConvergentChargingTableClassID I_ChrgPlanDateParameterTP ConvergentChargingTableClassID Class ID
CreatedByUserName
LastChangedByUserName
Characteristic I_ChrgPlanDateParameterTP Characteristic Field Name
CharacteristicDescription Characteristic Description
AllowanceDefinitionGroupUUID I_ChrgPlanDateParameterTP AllowanceDefinitionGroupUUID Allo. Def. Grp. UUID
AllowanceDefinitionGroupID I_ChrgPlanDateParameterTP AllowanceDefinitionGroupID Allo. Def. Group ID
SbsChrgPlnParamIsRlvtForPrrtn I_ChrgPlanDateParameterTP SbsChrgPlnParamIsRlvtForPrrtn Relevant for Proration
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard
_SOM_ChrgPlnParamUseValVH _SOM_ChrgPlnParamUseValVH
_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 C_ChrgPlanDateParameterTP.
-- 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: CCHPLPARAMDTP

CREATE VIEW C_ChrgPlanDateParameterTP AS
SELECT
  ChrgPlanDateParameter.ChargePlanParameterUUID AS ChargePlanParameterUUID,
  ChrgPlanDateParameter.CreatedByUser AS CreatedByUser,
  ChrgPlanDateParameter.CreationDateTime AS CreationDateTime,
  ChrgPlanDateParameter.LastChangedByUser AS LastChangedByUser,
  ChrgPlanDateParameter.LastChangeDateTime AS LastChangeDateTime,
  ChrgPlanDateParameter.ChargePlanAssignmentUUID AS ChargePlanAssignmentUUID,
  ChrgPlanDateParameter.SubscrpnProdSpecUUID AS SubscrpnProdSpecUUID,
  ChrgPlanDateParameter.ChargePlanParameterID AS ChargePlanParameterID,
  ChrgPlanDateParameter.ChargePlanParameterDescription AS ChargePlanParameterDescription,
  ChrgPlanDateParameter.ChargePlanParameterType AS ChargePlanParameterType,
  ChrgPlanDateParameter.ChargePlanParameterUsage AS ChargePlanParameterUsage,
  ChrgPlanDateParameter.ChargePlanParameterUseValue AS ChargePlanParameterUseValue,
  ChrgPlanDateParameter.ChrgPlanParameterNumericValue AS ChrgPlanParameterNumericValue,
  ChrgPlanDateParameter.ChrgPlnParamNmrcDefaultValue AS ChrgPlnParamNmrcDefaultValue,
  ChrgPlanDateParameter.ChargePlanParameterStringValue AS ChargePlanParameterStringValue,
  ChrgPlanDateParameter.ChrgPlnParamStringDefaultValue AS ChrgPlnParamStringDefaultValue,
  ChrgPlanDateParameter.ChargePlanParameterDateValue AS ChargePlanParameterDateValue,
  ChrgPlanDateParameter.ChrgPlnParamDateDefaultValue AS ChrgPlnParamDateDefaultValue,
  ChrgPlanDateParameter.BRFFunctionUUID AS BRFFunctionUUID,
  cast( '' as fdt_text ) AS BRFFunctionText,
  ChrgPlanDateParameter.ChargePlanParameterIsMandatory AS ChargePlanParameterIsMandatory,
  ChrgPlanDateParameter.ConvergentChargingTableClassID AS ConvergentChargingTableClassID,
  ChrgPlanDateParameter._CreatedByUser.UserDescription AS CreatedByUserName,
  ChrgPlanDateParameter._LastChangedByUser.UserDescription AS LastChangedByUserName,
  ChrgPlanDateParameter.Characteristic AS Characteristic,
  cast( '' as atnam ) AS CharacteristicDescription,
  ChrgPlanDateParameter.AllowanceDefinitionGroupUUID AS AllowanceDefinitionGroupUUID,
  ChrgPlanDateParameter.AllowanceDefinitionGroupID AS AllowanceDefinitionGroupID,
  ChrgPlanDateParameter.SbsChrgPlnParamIsRlvtForPrrtn AS SbsChrgPlnParamIsRlvtForPrrtn
FROM I_ChrgPlanDateParameterTP AS ChrgPlanDateParameter
LEFT OUTER JOIN C_SubscrpnProdSpecTP AS _SubscrpnProdSpecTP ON _SubscrpnProdSpecTP.SubscrpnProdSpecUUID = SubscrpnProdSpecUUID  -- association [1..1]
LEFT OUTER JOIN C_ChargePlanAssignmentTP AS _ChargePlanAssignmentTP ON _ChargePlanAssignmentTP.ChargePlanAssignmentUUID = ChargePlanAssignmentUUID  -- association [1..1]
LEFT OUTER JOIN C_SOM_ChrgPlnParamUseValVH AS _SOM_ChrgPlnParamUseValVH ON _SOM_ChrgPlnParamUseValVH.ChargePlanParameterUseValue = ChargePlanParameterUseValue  -- association [0..1]
;

Learn More