C_MassMaintCapPMRPChgPrpsl

DDL: C_MASSMAINTCAPPMRPCHGPRPSL Type: view_entity CONSUMPTION
11 Fields 1 Data Sources

MMWKC PMRP change proposal

C_MassMaintCapPMRPChgPrpsl is a Consumption CDS View that provides data about "MMWKC PMRP change proposal" in SAP S/4HANA. It reads from 1 data source (R_MassMaintCapPMRPChgPrpslTP) and exposes 11 fields with key fields CapacityInternalID, BucketInternalID.

Data Sources (1)

SourceAliasJoin Type
R_MassMaintCapPMRPChgPrpslTP R_MassMaintCapPMRPChgPrpslTP from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label MMWKC PMRP change proposal view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CapacityInternalID CapacityInternalID Capacity ID
KEY BucketInternalID BucketInternalID Bucket ID
PMRPAvailCapTmePerdInHrs PMRPAvailCapTmePerdInHrs
AdaptedCapacityRateInPercent AdaptedCapacityRateInPercent
TotOperatingDurationInHours TotOperatingDurationInHours
PMRPBucketStartDate PMRPBucketStartDate
PMRPBucketEndDate PMRPBucketEndDate
PMRPBucketYear PMRPBucketYear
PMRPBucketPeriod PMRPBucketPeriod
PMRPBucketCategory PMRPBucketCategory
_CapListHeader _CapListHeader

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_MassMaintCapPMRPChgPrpsl.
-- 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 C_MassMaintCapPMRPChgPrpsl AS
SELECT
  CapacityInternalID,
  BucketInternalID,
  PMRPAvailCapTmePerdInHrs,
  AdaptedCapacityRateInPercent,
  TotOperatingDurationInHours,
  PMRPBucketStartDate,
  PMRPBucketEndDate,
  PMRPBucketYear,
  PMRPBucketPeriod,
  PMRPBucketCategory
FROM R_MassMaintCapPMRPChgPrpslTP
;

Learn More