C_PRAPricingFormulaTerms2TP

DDL: C_PRAPRICINGFORMULATERMS2TP Type: view_entity CONSUMPTION Package: OIU_ODATA_REV_PRICING
24 Fields 1 Data Sources 1 OData Services

Formula Terms B

C_PRAPricingFormulaTerms2TP is a Consumption CDS View that provides data about "Formula Terms B" in SAP S/4HANA. It reads from 1 data source (R_PRAPricingFormulaTerms2TP) and exposes 24 fields with key field PRAPricingFormulaTermUUID. It is exposed through 1 OData service (UI_PRAPRICINGFORMULA_MANAGE). Part of development package OIU_ODATA_REV_PRICING.

Data Sources (1)

SourceAliasJoin Type
R_PRAPricingFormulaTerms2TP R_PRAPricingFormulaTerms2TP projection

Annotations (8)

NameValueLevelField
EndUserText.label Formula Terms B view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
Search.searchable false view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRAPRICINGFORMULA_MANAGE UI_PRAPRICINGFRML_MANAGE V2 C1 NOT_RELEASED

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PRAPricingFormulaTermUUID PRAPricingFormulaTermUUID
PRAPricingFormulaUUID PRAPricingFormulaUUID
FormulaTermType FormulaTermType
PricingFormulaTermItemNumber PricingFormulaTermItemNumber
PricingQuotationSource PricingQuotationSource
PricingQuotationType PricingQuotationType
PricingQuotationNumber PricingQuotationNumber
PricingFormulaCalcFctrOneVal PricingFormulaCalcFctrOneVal
PricingFormulaCalcFctrTwoVal PricingFormulaCalcFctrTwoVal
PricingTermCalcRule PricingTermCalcRule
PricingFormulaSurchargeAmt PricingFormulaSurchargeAmt
PricingFormulaCurrency PricingFormulaCurrency
PricingSurchargeVolInQty PricingSurchargeVolInQty
PricingSurchargeVolUnit PricingSurchargeVolUnit
PeriodsBeforeRefDteInVal PeriodsBeforeRefDteInVal
PeriodsAfterRefDteInVal PeriodsAfterRefDteInVal
FormulaFixedPeriodStartDte FormulaFixedPeriodStartDte
FormulaFixedPeriodEndDte FormulaFixedPeriodEndDte
PRALoclLastChgdAtDateTime PRALoclLastChgdAtDateTime Time Stamp
PricingQuotationSourceText
PricingQuotationTypeText
PricingQuotationText
PricingTermCalcRuleText
_Currency _Currency

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_PRAPricingFormulaTerms2TP.
-- 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_PRAPricingFormulaTerms2TP AS
SELECT
  PRAPricingFormulaTermUUID,
  PRAPricingFormulaUUID,
  FormulaTermType,
  PricingFormulaTermItemNumber,
  PricingQuotationSource,
  PricingQuotationType,
  PricingQuotationNumber,
  PricingFormulaCalcFctrOneVal,
  PricingFormulaCalcFctrTwoVal,
  PricingTermCalcRule,
  PricingFormulaSurchargeAmt,
  PricingFormulaCurrency,
  PricingSurchargeVolInQty,
  PricingSurchargeVolUnit,
  PeriodsBeforeRefDteInVal,
  PeriodsAfterRefDteInVal,
  FormulaFixedPeriodStartDte,
  FormulaFixedPeriodEndDte,
  PRALoclLastChgdAtDateTime,
  _PRAQuotationSource._Text.PricingQuotationSourceText AS PricingQuotationSourceText,
  _PRAQuotationType._Text.PricingQuotationTypeText AS PricingQuotationTypeText,
  _PRAQuotation._Text.PricingQuotationText AS PricingQuotationText,
  _PRAFormulaTermItemRule._PRAFormulaTermItemRuleText.PricingTermCalcRuleText AS PricingTermCalcRuleText
FROM R_PRAPricingFormulaTerms2TP
;

Learn More