/dmbe/C_CPF_Scale_Display

DDL: /DMBE/C_CPF_SCALE_DISPLAY SQL: /DMBE/CCPFSCLD Type: view
22 Fields 1 Data Sources 3 Associations

CPF Scale Display Consumption

/dmbe/C_CPF_Scale_Display is a CDS View that provides data about "CPF Scale Display Consumption" in SAP S/4HANA. It reads from 1 data source (/dmbe/I_CPF_Scale_Tp) and exposes 22 fields with key field scaleUuid. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
/dmbe/I_CPF_Scale_Tp /dmbe/I_CPF_Scale_Tp from

Associations (3)

CardinalityTargetAliasCondition
[0..1] /dmbe/c_CPFParameter_Display _ParentCpfParameterDisplay _ParentCpfParameterDisplay.parameterUuid = $projection.parameterUuid
[0..1] /dmbe/i_User_Description _CreatedBy _CreatedBy.UserID = $projection.createdBy
[0..1] /dmbe/i_User_Description _ChangedBy _ChangedBy.UserID = $projection.changedBy

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName /DMBE/CCPFSCLD view
EndUserText.label CPF Scale Display Consumption view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.semanticKey parameterUuid view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY scaleUuid scaleUuid UUID
parameterUuid parameterUuid UUID
dealUuid dealUuid UUID
scaleLevelNumber scaleLevelNumber Level Number
scaleLevel scaleLevel CPF Scale Level
scaleLevelValue scaleLevelValue Scale Level Value
scaleIncrement scaleIncrement Scale Increment
createdBy createdBy User Name
createdByDescr _CreatedBy UserDescription Full Name
createdAt createdAt Time Stamp
changedBy changedBy User Name
changedByDescr _ChangedBy UserDescription Full Name
changedAt changedAt Time Stamp
etag etag Update Token
deleted deleted Truth Value
buyingCompany _DealDocument buyingCompany Buying Company I/C
sellingCompany _DealDocument sellingCompany Selling Company I/C
producttype _DealDocument producttype Product Type Group
dealtype _DealDocument dealtype Deal Type
dealBlocked _DealDocument dealBlocked
_ParentCpfParameterDisplay _ParentCpfParameterDisplay
_DealDocument _DealDocument

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 /dmbe/C_CPF_Scale_Display.
-- 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: /DMBE/CCPFSCLD

CREATE VIEW /dmbe/C_CPF_Scale_Display AS
SELECT
  scaleUuid,
  parameterUuid,
  dealUuid,
  scaleLevelNumber,
  scaleLevel,
  scaleLevelValue,
  scaleIncrement,
  createdBy,
  _CreatedBy.UserDescription AS createdByDescr,
  createdAt,
  changedBy,
  _ChangedBy.UserDescription AS changedByDescr,
  changedAt,
  etag,
  deleted,
  _DealDocument.buyingCompany AS buyingCompany,
  _DealDocument.sellingCompany AS sellingCompany,
  _DealDocument.producttype AS producttype,
  _DealDocument.dealtype AS dealtype,
  _DealDocument.dealBlocked AS dealBlocked
FROM /dmbe/I_CPF_Scale_Tp
LEFT OUTER JOIN /dmbe/c_CPFParameter_Display AS _ParentCpfParameterDisplay ON _ParentCpfParameterDisplay.parameterUuid = parameterUuid  -- association [0..1]
LEFT OUTER JOIN /dmbe/i_User_Description AS _CreatedBy ON _CreatedBy.UserID = createdBy  -- association [0..1]
LEFT OUTER JOIN /dmbe/i_User_Description AS _ChangedBy ON _ChangedBy.UserID = changedBy  -- association [0..1]
;

Learn More