P_CmmdtyPrcgTrmGrpgGenR

DDL: P_CMMDTYPRCGTRMGRPGGENR SQL: PTRMGRPGR Type: view BASIC
6 Fields 1 Data Sources

CPE Term Changed Grouping and General Term Result

P_CmmdtyPrcgTrmGrpgGenR is a Basic CDS View that provides data about "CPE Term Changed Grouping and General Term Result" in SAP S/4HANA. It reads from 1 data source (cped_termgrpout) and exposes 6 fields with key fields PrcgConditionFormulaInputUUID, PricingConditionTerm.

Data Sources (1)

SourceAliasJoin Type
cped_termgrpout cped_termgrpout from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PTRMGRPGR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CPE Term Changed Grouping and General Term Result view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PrcgConditionFormulaInputUUID forminput_guid Doc. Form. GUID
KEY PricingConditionTerm termno Term Number
ACMPrcgTermInputUUID terminput_guid Term Input GUID
ACMPrcgTermConversionInputUUID termconvin_guid ConvInputGUID
Quantity termcommquan Commodity Qty
UnitOfMeasure termcommuom Comm. Qty UoM

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 P_CmmdtyPrcgTrmGrpgGenR.
-- 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: PTRMGRPGR

CREATE VIEW P_CmmdtyPrcgTrmGrpgGenR AS
SELECT
  forminput_guid AS PrcgConditionFormulaInputUUID,
  termno AS PricingConditionTerm,
  terminput_guid AS ACMPrcgTermInputUUID,
  termconvin_guid AS ACMPrcgTermConversionInputUUID,
  termcommquan AS Quantity,
  termcommuom AS UnitOfMeasure
FROM cped_termgrpout
;

Learn More