P_BatchChangeDocItemValuation

DDL: P_BATCHCHANGEDOCITEMVALUATION Type: view_entity COMPOSITE Package: LO_BM_BATCH_DB_SUPP

Batch change document items for valuation type

P_BatchChangeDocItemValuation is a Composite CDS View that provides data about "Batch change document items for valuation type" in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 9 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocTableKey, ChangeDocItemChangeType, ChangeDocument. Part of development package LO_BM_BATCH_DB_SUPP.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem _Item from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #NONE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocumentItem ChangeDocObject
KEY ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass
KEY ChangeDocTableKey I_ChangeDocumentItem ChangeDocTableKey
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType
KEY ChangeDocument ChangeDocument
NewValuationType I_ChangeDocumentItem ChangeDocNewFieldValue
OldValuationType I_ChangeDocumentItem ChangeDocPreviousFieldValue
CreationDateTime
_ChangeDocument _ChangeDocument 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass:#TRANSACTIONAL

@VDM.private: true
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #NONE
define view entity P_BatchChangeDocItemValuation
  as select from I_ChangeDocumentItem as _Item
{

  key _Item.ChangeDocObject,
  key _Item.ChangeDocObjectClass,
  key _Item.ChangeDocTableKey,
  key _Item.ChangeDocItemChangeType,
  key ChangeDocument,
 
  _Item.ChangeDocNewFieldValue as NewValuationType,
  _Item.ChangeDocPreviousFieldValue as OldValuationType,
  concat(_Item._ChangeDocument.CreationDate, _Item._ChangeDocument.CreationTime) as CreationDateTime,
  
  _ChangeDocument
}
where _Item.ChangeDocObjectClass = 'CHARGE_LM' 
  and _Item.DatabaseTable = 'MCHX'
  and _Item.ChangeDocDatabaseTableField = 'BWTAR'

Learn More