C_PurContrItmCndnScalesTP

DDL: C_PURCONTRITMCNDNSCALESTP SQL: CCTRICNDNSCLTP Type: view CONSUMPTION Package: ODATA_MM_OA_MAINTAIN
24 Fields 1 Data Sources 3 Associations

CTR item condition scales

C_PurContrItmCndnScalesTP is a Consumption CDS View that provides data about "CTR item condition scales" in SAP S/4HANA. It reads from 1 data source (I_PurContrItmCndnScalesTP) and exposes 24 fields with key fields PurchaseContract, PurchaseContractItem, ConditionRecord, ConditionSequentialNumber, ConditionValidityEndDate. It has 3 associations to related views. Part of development package ODATA_MM_OA_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_PurContrItmCndnScalesTP I_PurContrItmCndnScalesTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_PurContrItmCndnAmountTP _PurContrItmCndnAmountTP _PurContrItmCndnAmountTP.PurchaseContract = $projection.PurchaseContract and _PurContrItmCndnAmountTP.PurchaseContractItem = $projection.PurchaseContractItem and _PurContrItmCndnAmountTP.ConditionRecord = $projection.ConditionRecord and _PurContrItmCndnAmountTP.ConditionValidityEndDate = $projection.ConditionValidityEndDate and _PurContrItmCndnAmountTP.ConditionSequentialNumber = $projection.ConditionSequentialNumber
[1..1] C_ContractMaintain _PurchaseContractTP _PurchaseContractTP.PurchaseContract = $projection.PurchaseContract
[0..1] I_PricingScaleTypeText _PricingScaleTypeText _PricingScaleTypeText.PricingScaleType = $projection.PricingScaleType and _PricingScaleTypeText.Language = $session.system_language

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CCTRICNDNSCLTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CTR item condition scales view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.transactionalProcessingDelegated true view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Scale view
UI.headerInfo.typeNamePlural Pricing Scales view
UI.headerInfo.description.value ConditionScaleLine view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract Purchasing Doc.
KEY PurchaseContractItem PurchaseContractItem Item
KEY ConditionRecord ConditionRecord Cond.Record No.
KEY ConditionSequentialNumber ConditionSequentialNumber SequNo of Cond.
KEY ConditionValidityEndDate ConditionValidityEndDate Valid To
KEY ConditionScaleLine ConditionScaleLine Line number
ConditionScaleQuantity ConditionScaleQuantity Scale Quantity
ConditionScaleQuantityUnit ConditionScaleQuantityUnit Scale UoM
ConditionScaleAmount ConditionScaleAmount Scale Value
ConditionScaleAmountCurrency ConditionScaleAmountCurrency Scale Currency
ConditionRateValue ConditionRateValue Condition Rate Value
ConditionRateValueUnit ConditionRateValueUnit Unit of Condition Rate Value
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionCurrency ConditionCurrency Currency
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionRateValueIsRatio ConditionRateValueIsRatio TRUE
ConditionRateValueIsAmount ConditionRateValueIsAmount TRUE
ConditionScaleIsDeleted ConditionScaleIsDeleted Deletion Indic.
PricingScaleType I_PurContrItmCndnScalesTP PricingScaleType Scale Type
PricingScaleTypeName _PricingScaleTypeText PricingScaleTypeName Scale Type
ConditionQuantity ConditionQuantity Pricing Unit
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
_PurchaseContractTP _PurchaseContractTP
_PurContrItmCndnAmountTP _PurContrItmCndnAmountTP

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_PurContrItmCndnScalesTP.
-- 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: CCTRICNDNSCLTP

CREATE VIEW C_PurContrItmCndnScalesTP AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  ConditionRecord,
  ConditionSequentialNumber,
  ConditionValidityEndDate,
  ConditionScaleLine,
  ConditionScaleQuantity,
  ConditionScaleQuantityUnit,
  ConditionScaleAmount,
  ConditionScaleAmountCurrency,
  ConditionRateValue,
  ConditionRateValueUnit,
  ConditionRateAmount,
  ConditionCurrency,
  ConditionRateRatioUnit,
  ConditionRateValueIsRatio,
  ConditionRateValueIsAmount,
  ConditionScaleIsDeleted,
  I_PurContrItmCndnScalesTP.PricingScaleType AS PricingScaleType,
  _PricingScaleTypeText.PricingScaleTypeName AS PricingScaleTypeName,
  ConditionQuantity,
  ConditionQuantityUnit
FROM I_PurContrItmCndnScalesTP
LEFT OUTER JOIN C_PurContrItmCndnAmountTP AS _PurContrItmCndnAmountTP ON _PurContrItmCndnAmountTP.PurchaseContract = PurchaseContract AND _PurContrItmCndnAmountTP.PurchaseContractItem = PurchaseContractItem AND _PurContrItmCndnAmountTP.ConditionRecord = ConditionRecord AND _PurContrItmCndnAmountTP.ConditionValidityEndDate = ConditionValidityEndDate AND _PurContrItmCndnAmountTP.ConditionSequentialNumber = ConditionSequentialNumber  -- association [1..1]
LEFT OUTER JOIN C_ContractMaintain AS _PurchaseContractTP ON _PurchaseContractTP.PurchaseContract = PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PricingScaleTypeText AS _PricingScaleTypeText ON _PricingScaleTypeText.PricingScaleType = PricingScaleType AND _PricingScaleTypeText.Language = $session.system_language  -- association [0..1]
;

Learn More