I_CmmdtyPrcgPriceFixationSetTP

DDL: I_CMMDTYPRCGPRICEFIXATIONSETTP Type: view_entity TRANSACTIONAL

Price Fixation Set - TP

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

Data Sources (1)

SourceAliasJoin Type
R_CmmdtyPrcgPriceFixationSetTP R_CmmdtyPrcgPriceFixationSetTP projection

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Price Fixation Set - TP view
VDM.viewType #TRANSACTIONAL 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 IsSimulation
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
PrcFxtnSetConditionApplication PrcFxtnSetConditionApplication
PriceFixationSetScenarioType PriceFixationSetScenarioType
PriceFixationSetIdentifier PriceFixationSetIdentifier
PurchasingObjectCategory PurchasingObjectCategory Doc. Category
PriceCalculationProcessType PriceCalculationProcessType Event
SDDocumentCategory SDDocumentCategory Document Cat.
SAPObjectType SAPObjectType SOT Name
PrcFxtnSetComponentsAreFlat PrcFxtnSetComponentsAreFlat
CmmdtyPrcgPurSalesOrganization CmmdtyPrcgPurSalesOrganization
CmmdtyPricingDocumentCategory CmmdtyPricingDocumentCategory

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 I_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 I_CmmdtyPrcgPriceFixationSetTP AS
SELECT
  CmmdtyPrcgPriceFixationSetUUID,
  IsSimulation,
  LocalLastChangeDateTime,
  PrcFxtnSetConditionApplication,
  PriceFixationSetScenarioType,
  PriceFixationSetIdentifier,
  PurchasingObjectCategory,
  PriceCalculationProcessType,
  SDDocumentCategory,
  SAPObjectType,
  PrcFxtnSetComponentsAreFlat,
  CmmdtyPrcgPurSalesOrganization,
  CmmdtyPricingDocumentCategory
FROM R_CmmdtyPrcgPriceFixationSetTP
;