A_DocumentInfoRecordCharcValue

DDL: A_DOCUMENTINFORECORDCHARCVALUE SQL: ANGCDIRCLFN4 Type: view COMPOSITE Package: CV_VDM_API

Classification Characteristic Values

A_DocumentInfoRecordCharcValue is a Composite CDS View that provides data about "Classification Characteristic Values" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValForKeyDate) and exposes 26 fields with key fields DocumentInfoRecordDocType, DocumentInfoRecordDocNumber, DocumentInfoRecordDocVersion, DocumentInfoRecordDocPart, ClassType. It has 1 association to related views. Part of development package CV_VDM_API.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_DocumentInfoRecord _DocumentInfoRecord $projection.DocumentInfoRecordDocType = _DocumentInfoRecord.DocumentInfoRecordDocType and $projection.DocumentInfoRecordDocNumber = _DocumentInfoRecord.DocumentInfoRecordDocNumber and $projection.DocumentInfoRecordDocVersion = _DocumentInfoRecord.DocumentInfoRecordDocVersion and $projection.DocumentInfoRecordDocPart = _DocumentInfoRecord.DocumentInfoRecordDocPart

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ANGCDIRCLFN4 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Classification Characteristic Values view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Consumption.filter.businessDate.at true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY DocumentInfoRecordDocType DocumentInfoRecord DocumentInfoRecordDocType
KEY DocumentInfoRecordDocNumber DocumentInfoRecord DocumentInfoRecordDocNumber
KEY DocumentInfoRecordDocVersion DocumentInfoRecord DocumentInfoRecordDocVersion
KEY DocumentInfoRecordDocPart DocumentInfoRecord DocumentInfoRecordDocPart
KEY ClassType Valuation ClassType
KEY CharcInternalID Valuation CharcInternalID
KEY CharcValuePositionNumber Valuation CharcValuePositionNumber
KeyDate
CharcValueDependency Valuation CharcValueDependency
CharcValue Valuation CharcValue
CharcFromNumericValue Valuation CharcFromNumericValue
CharcFromNumericValueUnit Valuation CharcFromNumericValueUnit
CharcToNumericValue Valuation CharcToNumericValue
CharcToNumericValueUnit Valuation CharcToNumericValueUnit
CharcFromDecimalValue Valuation CharcFromDecimalValue
CharcToDecimalValue Valuation CharcToDecimalValue
CharcFromAmount Valuation CharcFromAmount
CharcToAmount Valuation CharcToAmount
Currency Valuation Currency
CharcFromDate Valuation CharcFromDate
CharcToDate Valuation CharcToDate
CharcFromTime Valuation CharcFromTime
CharcToTime Valuation CharcToTime
CharacteristicAuthor Valuation CharacteristicAuthor
CharcMaintAuthGrp
_DocumentInfoRecord _DocumentInfoRecord 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ANGCDIRCLFN4'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Classification Characteristic Values'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@Consumption.filter.businessDate.at: true
define view A_DocumentInfoRecordCharcValue 
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate:sydate
  as select from I_ClfnObjectCharcValForKeyDate(P_KeyDate: $parameters.P_KeyDate) as Valuation 
    join A_DocumentInfoRecord as DocumentInfoRecord on
      Valuation.ClfnObjectID = DocumentInfoRecord.DocumentInfoRecord
  
    association [1..1] to A_DocumentInfoRecord as _DocumentInfoRecord on
      $projection.DocumentInfoRecordDocType = _DocumentInfoRecord.DocumentInfoRecordDocType and
      $projection.DocumentInfoRecordDocNumber = _DocumentInfoRecord.DocumentInfoRecordDocNumber and
      $projection.DocumentInfoRecordDocVersion = _DocumentInfoRecord.DocumentInfoRecordDocVersion and
      $projection.DocumentInfoRecordDocPart = _DocumentInfoRecord.DocumentInfoRecordDocPart
  {
    key DocumentInfoRecord.DocumentInfoRecordDocType,
    key DocumentInfoRecord.DocumentInfoRecordDocNumber,
    key DocumentInfoRecord.DocumentInfoRecordDocVersion,
    key DocumentInfoRecord.DocumentInfoRecordDocPart,
    key Valuation.ClassType,
    key Valuation.CharcInternalID,
    key Valuation.CharcValuePositionNumber,
          
    $parameters.P_KeyDate as KeyDate,
    Valuation.CharcValueDependency,
    Valuation.CharcValue,
    Valuation.CharcFromNumericValue,  
    Valuation.CharcFromNumericValueUnit,
    Valuation.CharcToNumericValue,     
    Valuation.CharcToNumericValueUnit,
    Valuation.CharcFromDecimalValue,
    Valuation.CharcToDecimalValue,
    @Semantics.amount.currencyCode: 'Currency'
    Valuation.CharcFromAmount,
    @Semantics.amount.currencyCode: 'Currency'
    Valuation.CharcToAmount,
    @Semantics.currencyCode: true
    Valuation.Currency,
    Valuation.CharcFromDate,
    Valuation.CharcToDate,
    Valuation.CharcFromTime,
    Valuation.CharcToTime, 
    Valuation.CharacteristicAuthor,
    Valuation._Characteristic(P_KeyDate: $parameters.P_KeyDate).CharcMaintAuthGrp,
    
    _DocumentInfoRecord
  }
    where
      Valuation.ClfnObjectTable = 'DRAW' and 
      Valuation.ClfnObjectType = 'O'

Learn More