R_PPDSProdOvwCharcsPrvdr

DDL: R_PPDSPRODOVWCHARCSPRVDR Type: view_entity BASIC
12 Fields 4 Data Sources

MPS Characteristics Provider

R_PPDSProdOvwCharcsPrvdr is a Basic CDS View that provides data about "MPS Characteristics Provider" in SAP S/4HANA. It reads from 4 data sources (R_PPDSApplPrflCharcsPrvdr, ibin, ibinvalues, ibsymbol) and exposes 12 fields with key fields ConfigurationNumber, PPDSVisualizationProfile, CharcInternalID, PPDSCharcColumn, CharacteristicVarLine.

Data Sources (4)

SourceAliasJoin Type
R_PPDSApplPrflCharcsPrvdr charc_prvdr inner
ibin ibin inner
ibinvalues ibinvalues from
ibsymbol ibsymbol inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label MPS Characteristics Provider view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ConfigurationNumber
KEY PPDSVisualizationProfile R_PPDSApplPrflCharcsPrvdr PPDSVisualizationProfile
KEY CharcInternalID
KEY PPDSCharcColumn R_PPDSApplPrflCharcsPrvdr PPDSCharcColumn Item Number (int.)
KEY CharacteristicVarLine charcs CharacteristicVarLine
CharcDataType R_PPDSApplPrflCharcsPrvdr CharcDataType Format
CharcValueUnit R_PPDSApplPrflCharcsPrvdr CharcValueUnit Internal UoM
CharcFromNumericValue ibsymbol atflv Value from
CharcLength R_PPDSApplPrflCharcsPrvdr CharcLength Number of Chars
CharcDecimals R_PPDSApplPrflCharcsPrvdr CharcDecimals Decimal Places
CharcValue ibsymbol atwrt Char. Value
CharcValueDescription charcs CharcValueDescription

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_PPDSProdOvwCharcsPrvdr.
-- 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_PPDSProdOvwCharcsPrvdr AS
SELECT
  cast( ibin.instance as cuobj preserving type ) AS ConfigurationNumber,
  charc_prvdr.PPDSVisualizationProfile AS PPDSVisualizationProfile,
  cast( ibsymbol.atinn as atinn_no_conv preserving type) AS CharcInternalID,
  charc_prvdr.PPDSCharcColumn AS PPDSCharcColumn,
  charcs.CharacteristicVarLine AS CharacteristicVarLine,
  charc_prvdr.CharcDataType AS CharcDataType,
  charc_prvdr.CharcValueUnit AS CharcValueUnit,
  ibsymbol.atflv AS CharcFromNumericValue,
  charc_prvdr.CharcLength AS CharcLength,
  charc_prvdr.CharcDecimals AS CharcDecimals,
  ibsymbol.atwrt AS CharcValue,
  charcs.CharcValueDescription AS CharcValueDescription
FROM ibinvalues
INNER JOIN ibsymbol ON /* join condition not captured in parsed metadata */
INNER JOIN ibin ON /* join condition not captured in parsed metadata */
INNER JOIN R_PPDSApplPrflCharcsPrvdr AS charc_prvdr ON /* join condition not captured in parsed metadata */
;

Learn More