P_SpecCharacteristicValue

DDL: P_SPECCHARACTERISTICVALUE SQL: PSPCCHARVALUE Type: view BASIC

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.

2 data source(s) 26 fields

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
KEY CharacteristicInternalID
KEY atzhl ausp atzhl
KEY mafid ausp mafid
KEY ClassType ausp klart
KEY adzhl ausp adzhl
CharacteristicValue ausp atwrt
CharacteristicMinimumValue ausp atflv
CharacteristicMinimumValueUnit ausp atawe
CharacteristicMaximumValue ausp atflb
CharacteristicMaximumValueUnit ausp ataw1
CharacteristicValueDpndcyCode ausp atcod
attlv ausp attlv
attlb ausp attlb
atprz ausp atprz
atinc ausp atinc
ataut ausp ataut
aennr ausp aennr
datuv ausp datuv
atimb
atzis ausp atzis
atsrt ausp atsrt
atvglart ausp atvglart
datub ausp datub
Characteristic cabn atnam
CharacteristicBaseUnit cabn msehi 
@AbapCatalog.sqlViewName: 'PSPCCHARVALUE'
@AbapCatalog.compiler.compareFilter: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.lifecycle.contract.type: #NONE
@VDM.viewType: #BASIC
@VDM.private: true

define view P_SpecCharacteristicValue
  as select from ausp
            inner join   cabn on ausp.atinn = cabn.atinn
  
{

  key ausp.objek,
  key cast(ausp.atinn as atinn_no_conv preserving type) as CharacteristicInternalID,
  key ausp.atzhl,
  key ausp.mafid,
  key ausp.klart as ClassType,
  key ausp.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,
      ausp.attlb,
      ausp.atprz,
      ausp.atinc,
      ausp.ataut,
      ausp.aennr,
      ausp.datuv,
      //ausp.lkenz as CharacteristicIsDeleted,

      cast(ausp.atimb as atinn_no_conv preserving type) as atimb,
      ausp.atzis,
      ausp.atsrt,
      ausp.atvglart,
      ausp.datub,
      
      cabn.atnam as Characteristic,
      cabn.msehi as CharacteristicBaseUnit
      
}    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUSP",
"CABN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More