P_SpecCharacteristicValue

DDL: P_SPECCHARACTERISTICVALUE SQL: PSPCCHARVALUE Type: view BASIC
26 Fields 2 Data Sources

P_SpecCharacteristicValue is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (ausp, cabn) and exposes 26 fields with key fields objek, CharacteristicInternalID, atzhl, mafid, ClassType.

Data Sources (2)

SourceAliasJoin Type
ausp ausp from
cabn cabn inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PSPCCHARVALUE view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #NONE view
VDM.viewType #BASIC view
VDM.private true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY objek ausp objek Object
KEY CharacteristicInternalID
KEY atzhl ausp atzhl Int counter
KEY mafid ausp mafid Record type
KEY ClassType ausp klart Class Type
KEY adzhl ausp adzhl Int. counter
CharacteristicValue ausp atwrt Char. Value
CharacteristicMinimumValue ausp atflv Value from
CharacteristicMinimumValueUnit ausp atawe Internal UoM
CharacteristicMaximumValue ausp atflb Value to
CharacteristicMaximumValueUnit ausp ataw1 Internal UoM
CharacteristicValueDpndcyCode ausp atcod Interval limits
attlv ausp attlv Tolerance from
attlb ausp attlb Tolerance to
atprz ausp atprz Percentage
atinc ausp atinc Increment
ataut ausp ataut Justification
aennr ausp aennr Change Number
datuv ausp datuv Valid-from date
atimb
atzis ausp atzis Instance cntr
atsrt ausp atsrt Position
atvglart ausp atvglart Comp. type
datub ausp datub Valid to
Characteristic cabn atnam Characteristic
CharacteristicBaseUnit cabn msehi Unit of measmnt

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 P_SpecCharacteristicValue.
-- 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: PSPCCHARVALUE

CREATE VIEW P_SpecCharacteristicValue AS
SELECT
  ausp.objek AS objek,
  cast(ausp.atinn as atinn_no_conv preserving type) AS CharacteristicInternalID,
  ausp.atzhl AS atzhl,
  ausp.mafid AS mafid,
  ausp.klart AS ClassType,
  ausp.adzhl AS adzhl,
  ausp.atwrt AS CharacteristicValue,
  ausp.atflv AS CharacteristicMinimumValue,
  ausp.atawe AS CharacteristicMinimumValueUnit,
  ausp.atflb AS CharacteristicMaximumValue,
  ausp.ataw1 AS CharacteristicMaximumValueUnit,
  ausp.atcod AS CharacteristicValueDpndcyCode,
  ausp.attlv AS attlv,
  ausp.attlb AS attlb,
  ausp.atprz AS atprz,
  ausp.atinc AS atinc,
  ausp.ataut AS ataut,
  ausp.aennr AS aennr,
  ausp.datuv AS datuv,
  cast(ausp.atimb as atinn_no_conv preserving type) AS atimb,
  ausp.atzis AS atzis,
  ausp.atsrt AS atsrt,
  ausp.atvglart AS atvglart,
  ausp.datub AS datub,
  cabn.atnam AS Characteristic,
  cabn.msehi AS CharacteristicBaseUnit
FROM ausp
INNER JOIN cabn ON /* join condition not captured in parsed metadata */
;

Learn More