P_ChangeDocumentItem

DDL: P_CHANGEDOCUMENTITEM SQL: PMMPCHGEDOCITEM Type: view CONSUMPTION

P_ChangeDocumentItem is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ChangeDocumentItem) and exposes 16 fields with key fields ChangeDocObject, ChangeDocDatabaseTableField, DatabaseTable, ChangeDocTableKey, ChangeDocObjectClass.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMPCHGEDOCITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject ChangeDocObject
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
KEY DatabaseTable DatabaseTable
KEY ChangeDocTableKey ChangeDocTableKey
KEY ChangeDocObjectClass ChangeDocObjectClass
KEY ChangeDocument ChangeDocument
KEY ChangeDocItemChangeType ChangeDocItemChangeType
ChangeDocNewCurrency ChangeDocNewCurrency
ChangeDocNewFieldValue
NewFieldValAfterDecimal
ChangeDocPreviousCurrency ChangeDocPreviousCurrency
ChangeDocPreviousFieldValue
PreviousFieldValAfterDecimal
dec240asCreationDateTime
CreationDate _ChangeDocument CreationDate
CreationTime _ChangeDocument CreationTime 
@AbapCatalog.sqlViewName: 'PMMPCHGEDOCITEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view P_ChangeDocumentItem 
 as select from I_ChangeDocumentItem 
 
{ 
  key ChangeDocObject,
   
  key ChangeDocDatabaseTableField,
  key DatabaseTable,
  key ChangeDocTableKey,

  key ChangeDocObjectClass,

  key ChangeDocument,
  key ChangeDocItemChangeType,
  
  ChangeDocNewCurrency,
  cast(cast(substring(ChangeDocNewFieldValue, 1, 9) as abap.numc( 21 ) ) as abap.dec( 21, 2 ) ) as ChangeDocNewFieldValue,
  cast(cast(RIGHT(ChangeDocNewFieldValue,2) as abap.char( 2 )) as abap.numc(21)) as NewFieldValAfterDecimal,
 
  ChangeDocPreviousCurrency,
  cast(cast(substring(ChangeDocPreviousFieldValue, 1, 9) as abap.numc( 21 ) ) as abap.dec( 21, 2 ) ) as  ChangeDocPreviousFieldValue,
  cast(cast(RIGHT(ChangeDocPreviousFieldValue,2) as abap.char( 2 )) as abap.numc(21)) as PreviousFieldValAfterDecimal,
    
  cast(dats_tims_to_tstmp( _ChangeDocument.CreationDate, 
                           _ChangeDocument.CreationTime, 
                           abap_system_timezone( $session.client,'NULL' ), 
                           $session.client, 
                           'NULL' ) as abap.dec( 24, 0 ) ) as CreationDateTime,
  _ChangeDocument.CreationDate, 
  _ChangeDocument.CreationTime
}

where (DatabaseTable = 'EKPO' or DatabaseTable = 'EINE')
  and ChangeDocItemChangeType = 'U' 
  and ChangeDocDatabaseTableField = 'NETPR' 

 



/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEDOCUMENT",
"I_CHANGEDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More