R_CmmdtyPrcgPriceFixationSetTP

DDL: R_CMMDTYPRCGPRICEFIXATIONSETTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources 4 Associations

Price Fixation Set

R_CmmdtyPrcgPriceFixationSetTP is a Transactional CDS View that provides data about "Price Fixation Set" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyPrcgPriceFixationSet) and exposes 13 fields with key field CmmdtyPrcgPriceFixationSetUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyPrcgPriceFixationSet I_CmmdtyPrcgPriceFixationSet from

Associations (4)

CardinalityTargetAliasCondition
[1..1] E_CmmdtyPrcgPriceFixationSet _Extension $projection.CmmdtyPrcgPriceFixationSetUUID = _Extension.CmmdtyPrcgPriceFixationSetUUID
[*] R_CmPrcgPrcFixationSetCompTP _CmPrcgPrcFixationSetCompTP
[*] R_CmmdtyPrcgPrcFixationGroupTP _CmmdtyPrcgPrcFixationGroupTP
[*] R_CmPrcgPriceFixationSetLogTP _CmPrcgPriceFixationSetLogTP

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Price Fixation Set view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name CmmdtyPricingPriceFixationSet view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyPrcgPriceFixationSetUUID CmmdtyPrcgPriceFixationSetUUID Price Fix Set GUID
IsSimulation
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
PrcFxtnSetConditionApplication PrcFxtnSetConditionApplication Application
PriceFixationSetScenarioType PriceFixationSetScenarioType Scenario Type
PriceFixationSetIdentifier PriceFixationSetIdentifier Price Fixtn Set ID
PurchasingObjectCategory PurchasingObjectCategory Doc. Category
PriceCalculationProcessType PriceCalculationProcessType Event
SDDocumentCategory SDDocumentCategory Document Cat.
SAPObjectType SAPObjectType SOT Name
_CmPrcgPrcFixationSetCompTP _CmPrcgPrcFixationSetCompTP
_CmmdtyPrcgPrcFixationGroupTP _CmmdtyPrcgPrcFixationGroupTP
_CmPrcgPriceFixationSetLogTP _CmPrcgPriceFixationSetLogTP

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 R_CmmdtyPrcgPriceFixationSetTP.
-- 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 R_CmmdtyPrcgPriceFixationSetTP AS
SELECT
  CmmdtyPrcgPriceFixationSetUUID,
  cast ( ' ' as boolean ) AS IsSimulation,
  LocalLastChangeDateTime,
  PrcFxtnSetConditionApplication,
  PriceFixationSetScenarioType,
  PriceFixationSetIdentifier,
  PurchasingObjectCategory,
  PriceCalculationProcessType,
  SDDocumentCategory,
  SAPObjectType
FROM I_CmmdtyPrcgPriceFixationSet
LEFT OUTER JOIN E_CmmdtyPrcgPriceFixationSet AS _Extension ON CmmdtyPrcgPriceFixationSetUUID = _Extension.CmmdtyPrcgPriceFixationSetUUID  -- association [1..1]
LEFT OUTER JOIN R_CmPrcgPrcFixationSetCompTP AS _CmPrcgPrcFixationSetCompTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_CmmdtyPrcgPrcFixationGroupTP AS _CmmdtyPrcgPrcFixationGroupTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_CmPrcgPriceFixationSetLogTP AS _CmPrcgPriceFixationSetLogTP ON /* condition not available in parsed metadata */  -- association [*]
;

Learn More