What is C_ChrgPlnAllwncParameterTP in SAP S/4HANA?

C_ChrgPlnAllwncParameterTP is a consumption CDS view in SAP S/4HANA. Consumption view for charge plan parameter - type allowance It contains 34 fields.

Which tables does C_ChrgPlnAllwncParameterTP read from?

C_ChrgPlnAllwncParameterTP reads data from: I_ChrgPlnAllwncParameterTP.

What VDM layer is C_ChrgPlnAllwncParameterTP?

C_ChrgPlnAllwncParameterTP is classified as a Consumption view optimized for specific business scenarios and reporting.

C_ChrgPlnAllwncParameterTP

DDL: C_CHRGPLNALLWNCPARAMETERTP SQL: CCHPLPARAMATP Type: view CONSUMPTION

34 Fields 1 Data Sources 5 Associations

Consumption view for charge plan parameter - type allowance

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

Data Sources (1)

Source	Alias	Join Type
I_ChrgPlnAllwncParameterTP	ChrgPlnAllwncParameter	from

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	C_SubscrpnProdSpecTP	_SubscrpnProdSpecTP	`_SubscrpnProdSpecTP.SubscrpnProdSpecUUID = $projection.SubscrpnProdSpecUUID`
[1..1]	C_ChargePlanAssignmentTP	_ChargePlanAssignmentTP	`_ChargePlanAssignmentTP.ChargePlanAssignmentUUID = $projection.ChargePlanAssignmentUUID`
[0..1]	C_SOM_ChrgPlnAllwncUseVH	_SOM_ChrgPlnAllwncUseVH	`_SOM_ChrgPlnAllwncUseVH.ChargePlanParameterUseValue = $projection.ChargePlanParameterUseValue`
[0..1]	C_AllwncDefinitionGroupVH	_AllwncDefinitionGroupVH	`_AllwncDefinitionGroupVH.AllowanceDefinitionGroupUUID = $projection.AllowanceDefinitionGroupUUID and _AllwncDefinitionGroupVH.AllowanceDefinitionGroupID = $projection.AllowanceDefinitionGroupID`
[0..1]	C_AllwncDefinitionGroupTP	_AllwncDefinitionGroupTP	`_AllwncDefinitionGroupTP.AllowanceDefinitionGroupUUID = $projection.AllowanceDefinitionGroupUUID`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	CCHPLPARAMATP	view
AbapCatalog.compiler.compareFilter	true	view
EndUserText.label	Consumption view for charge plan parameter - type allowance	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)

Key	Field	Source Table	Source Field	Description
KEY	ChargePlanParameterUUID	I_ChrgPlnAllwncParameterTP	ChargePlanParameterUUID	Parameter UUID
	CreatedByUser	I_ChrgPlnAllwncParameterTP	CreatedByUser	User Name
	CreationDateTime	I_ChrgPlnAllwncParameterTP	CreationDateTime	Timestamp
	LastChangedByUser	I_ChrgPlnAllwncParameterTP	LastChangedByUser	User Name
	LastChangeDateTime	I_ChrgPlnAllwncParameterTP	LastChangeDateTime	Timestamp
	ChargePlanAssignmentUUID	I_ChrgPlnAllwncParameterTP	ChargePlanAssignmentUUID	Assignment UUID
	SubscrpnProdSpecUUID	I_ChrgPlnAllwncParameterTP	SubscrpnProdSpecUUID	Sub. Prod. Data UUID
	ChargePlanParameterID	I_ChrgPlnAllwncParameterTP	ChargePlanParameterID	Parameter ID
	ChargePlanParameterDescription	I_ChrgPlnAllwncParameterTP	ChargePlanParameterDescription	Parameter Descript.
	ChargePlanParameterType	I_ChrgPlnAllwncParameterTP	ChargePlanParameterType	Parameter Type
	ChargePlanParameterUsage	I_ChrgPlnAllwncParameterTP	ChargePlanParameterUsage	Parameter Usage
	ChargePlanParameterUseValue	I_ChrgPlnAllwncParameterTP	ChargePlanParameterUseValue	Value Used
	ChrgPlanParameterNumericValue	I_ChrgPlnAllwncParameterTP	ChrgPlanParameterNumericValue	Numeric Value
	ChrgPlnParamNmrcDefaultValue	I_ChrgPlnAllwncParameterTP	ChrgPlnParamNmrcDefaultValue	Numeric Value
	ChargePlanParameterStringValue	I_ChrgPlnAllwncParameterTP	ChargePlanParameterStringValue	String Value
	ChrgPlnParamStringDefaultValue	I_ChrgPlnAllwncParameterTP	ChrgPlnParamStringDefaultValue	String Value
	ChargePlanParameterDateValue	I_ChrgPlnAllwncParameterTP	ChargePlanParameterDateValue	Date Parameter Value
	ChrgPlnParamDateDefaultValue	I_ChrgPlnAllwncParameterTP	ChrgPlnParamDateDefaultValue	Date Parameter Value
	BRFFunctionUUID	I_ChrgPlnAllwncParameterTP	BRFFunctionUUID	BRFplus UUID
	ChargePlanParameterIsMandatory	I_ChrgPlnAllwncParameterTP	ChargePlanParameterIsMandatory	Parameter Is Mandato
	ConvergentChargingTableClassID	I_ChrgPlnAllwncParameterTP	ConvergentChargingTableClassID	Class ID
	CreatedByUserName			Created By Description
	LastChangedByUserName			Changed By Description
	Characteristic	I_ChrgPlnAllwncParameterTP	Characteristic	Field Name
	AllowanceDefinitionGroupUUID	I_ChrgPlnAllwncParameterTP	AllowanceDefinitionGroupUUID	Allo. Def. Grp. UUID
	AllowanceDefinitionGroupID	I_ChrgPlnAllwncParameterTP	AllowanceDefinitionGroupID	Allo. Def. Group ID
	AllowanceDefinitionGroupDesc	_AllwncDefinitionGroupTP	AllowanceDefinitionGroupDesc	Allo. Def. Grp. Desc
	_CreatedByUserContactCard		_CreatedByUserContactCard
	_LastChangedByUserContactCard		_LastChangedByUserContactCard
	_SOM_ChrgPlnAllwncUseVH		_SOM_ChrgPlnAllwncUseVH
	_AllwncDefinitionGroupVH		_AllwncDefinitionGroupVH
	_AllwncDefinitionGroupTP		_AllwncDefinitionGroupTP
	_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_ChrgPlnAllwncParameterTP.
-- 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: CCHPLPARAMATP

CREATE VIEW C_ChrgPlnAllwncParameterTP AS
SELECT
  ChrgPlnAllwncParameter.ChargePlanParameterUUID AS ChargePlanParameterUUID,
  ChrgPlnAllwncParameter.CreatedByUser AS CreatedByUser,
  ChrgPlnAllwncParameter.CreationDateTime AS CreationDateTime,
  ChrgPlnAllwncParameter.LastChangedByUser AS LastChangedByUser,
  ChrgPlnAllwncParameter.LastChangeDateTime AS LastChangeDateTime,
  ChrgPlnAllwncParameter.ChargePlanAssignmentUUID AS ChargePlanAssignmentUUID,
  ChrgPlnAllwncParameter.SubscrpnProdSpecUUID AS SubscrpnProdSpecUUID,
  ChrgPlnAllwncParameter.ChargePlanParameterID AS ChargePlanParameterID,
  ChrgPlnAllwncParameter.ChargePlanParameterDescription AS ChargePlanParameterDescription,
  ChrgPlnAllwncParameter.ChargePlanParameterType AS ChargePlanParameterType,
  ChrgPlnAllwncParameter.ChargePlanParameterUsage AS ChargePlanParameterUsage,
  ChrgPlnAllwncParameter.ChargePlanParameterUseValue AS ChargePlanParameterUseValue,
  ChrgPlnAllwncParameter.ChrgPlanParameterNumericValue AS ChrgPlanParameterNumericValue,
  ChrgPlnAllwncParameter.ChrgPlnParamNmrcDefaultValue AS ChrgPlnParamNmrcDefaultValue,
  ChrgPlnAllwncParameter.ChargePlanParameterStringValue AS ChargePlanParameterStringValue,
  ChrgPlnAllwncParameter.ChrgPlnParamStringDefaultValue AS ChrgPlnParamStringDefaultValue,
  ChrgPlnAllwncParameter.ChargePlanParameterDateValue AS ChargePlanParameterDateValue,
  ChrgPlnAllwncParameter.ChrgPlnParamDateDefaultValue AS ChrgPlnParamDateDefaultValue,
  ChrgPlnAllwncParameter.BRFFunctionUUID AS BRFFunctionUUID,
  ChrgPlnAllwncParameter.ChargePlanParameterIsMandatory AS ChargePlanParameterIsMandatory,
  ChrgPlnAllwncParameter.ConvergentChargingTableClassID AS ConvergentChargingTableClassID,
  ChrgPlnAllwncParameter._CreatedByUser.UserDescription AS CreatedByUserName,
  ChrgPlnAllwncParameter._LastChangedByUser.UserDescription AS LastChangedByUserName,
  ChrgPlnAllwncParameter.Characteristic AS Characteristic,
  ChrgPlnAllwncParameter.AllowanceDefinitionGroupUUID AS AllowanceDefinitionGroupUUID,
  ChrgPlnAllwncParameter.AllowanceDefinitionGroupID AS AllowanceDefinitionGroupID,
  _AllwncDefinitionGroupTP.AllowanceDefinitionGroupDesc AS AllowanceDefinitionGroupDesc
FROM I_ChrgPlnAllwncParameterTP AS ChrgPlnAllwncParameter
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_ChrgPlnAllwncUseVH AS _SOM_ChrgPlnAllwncUseVH ON _SOM_ChrgPlnAllwncUseVH.ChargePlanParameterUseValue = ChargePlanParameterUseValue  -- association [0..1]
LEFT OUTER JOIN C_AllwncDefinitionGroupVH AS _AllwncDefinitionGroupVH ON _AllwncDefinitionGroupVH.AllowanceDefinitionGroupUUID = AllowanceDefinitionGroupUUID AND _AllwncDefinitionGroupVH.AllowanceDefinitionGroupID = AllowanceDefinitionGroupID  -- association [0..1]
LEFT OUTER JOIN C_AllwncDefinitionGroupTP AS _AllwncDefinitionGroupTP ON _AllwncDefinitionGroupTP.AllowanceDefinitionGroupUUID = AllowanceDefinitionGroupUUID  -- association [0..1]
;

Depth:

C_ChrgPlnAllwncParameterTP view

I_ChrgPlnAllwncParameterTP view