/APE/C_PeriodTypeTP_C

DDL: /APE/C_PERIODTYPETP_C Type: view_entity CONSUMPTION

Period Type for Customer

/APE/C_PeriodTypeTP_C is a Consumption CDS View that provides data about "Period Type for Customer" in SAP S/4HANA. It reads from 1 data source (/APE/I_PeriodTypeTP_C) and exposes 30 fields with key field PeriodTypeKey. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/APE/I_PeriodTypeTP_C /APE/I_PeriodTypeTP_C projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] /APE/C_WhereUsed_UI _WhereUsed _WhereUsed.ConfigurationUUID = $projection.PeriodTypeKey

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Period Type for Customer view
Metadata.allowExtensions true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY PeriodTypeKey config_key Char
PeriodType period_type Repeat Appmt Type
PeriodTypeUUID period_type_uuid
descriptionasPeriodTypeTextlocalized
ProcessCluster proc_cluster
ProcClusterUUID proc_cluster_uuid
descriptionasProcessClusterTextlocalized
Version version XML Vers.
VersionUUID version_uuid
descriptionasVersionTextlocalized
TimeUnit timeunit Unit of Measure
TextasTimeUnitTextlocalized
TimeCount timecount
WorkCal work_cal
HLPeriodType hl_period_type Repeat Appmt Type
HLPeriodTypeUUID hl_period_type_uuid
descriptionasHLPeriodTypeTextlocalized
ExactTime exact_time
WorkHours work_hours
Time time Time Stamp
Category category Violation Category
TextasCategoryTextlocalized
MarketRole market_role
descriptionasMarketRoleTextlocalized
ConfigurationLayer config_layer
TextasConfigurationLayerTextlocalized
DeploymentTarget deploy_target
TextasDeploymentTargetTextlocalized
ChangedAt changed_at Timestamp
_WhereUsed _WhereUsed

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 /APE/C_PeriodTypeTP_C.
-- 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 /APE/C_PeriodTypeTP_C AS
SELECT
  config_key AS PeriodTypeKey,
  period_type AS PeriodType,
  period_type_uuid AS PeriodTypeUUID,
  _PeriodTypeText.description as PeriodTypeText : localized AS descriptionasPeriodTypeTextlocalized,
  proc_cluster AS ProcessCluster,
  proc_cluster_uuid AS ProcClusterUUID,
  _ProcessClusterText.description as ProcessClusterText : localized AS descriptionasProcessClusterTextlocalized,
  Version,
  version_uuid AS VersionUUID,
  _VersionText.description as VersionText : localized AS descriptionasVersionTextlocalized,
  TimeUnit,
  _TimeUnitText.Text as TimeUnitText : localized AS TextasTimeUnitTextlocalized,
  TimeCount,
  work_cal AS WorkCal,
  hl_period_type AS HLPeriodType,
  hl_period_type_uuid AS HLPeriodTypeUUID,
  _HLPeriodTypeText.description as HLPeriodTypeText : localized AS descriptionasHLPeriodTypeTextlocalized,
  exact_time AS ExactTime,
  work_hours AS WorkHours,
  Time,
  Category,
  _CategoryText.Text as CategoryText : localized AS TextasCategoryTextlocalized,
  market_role AS MarketRole,
  _MarketRoleText.description as MarketRoleText : localized AS descriptionasMarketRoleTextlocalized,
  config_layer AS ConfigurationLayer,
  _ConfigurationLayerText.Text as ConfigurationLayerText : localized AS TextasConfigurationLayerTextlocalized,
  deploy_target AS DeploymentTarget,
  _DeploymentTargetText.Text as DeploymentTargetText : localized AS TextasDeploymentTargetTextlocalized,
  changed_at AS ChangedAt
FROM /APE/I_PeriodTypeTP_C
LEFT OUTER JOIN /APE/C_WhereUsed_UI AS _WhereUsed ON _WhereUsed.ConfigurationUUID = PeriodTypeKey  -- association [0..*]
;