P_CostCenterChangeDocument

DDL: P_COSTCENTERCHANGEDOCUMENT SQL: PCOSTCTRCHGDOC Type: view CONSUMPTION

P_CostCenterChangeDocument is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ChangeDocument) and exposes 11 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument. It has 1 association to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocument I_ChangeDocument from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_CostCtrChangeDocItem _CostCtrChangeDocItem $projection.ChangeDocObject = _CostCtrChangeDocItem.ChangeDocObject and $projection.ChangeDocObjectClass = _CostCtrChangeDocItem.ChangeDocObjectClass and $projection.ChangeDocument = _CostCtrChangeDocItem.ChangeDocument

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCOSTCTRCHGDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject I_ChangeDocument ChangeDocObject
KEY ChangeDocObjectClass I_ChangeDocument ChangeDocObjectClass
KEY ChangeDocument I_ChangeDocument ChangeDocument
CreatedByUser
CreationDate
CreationTime
ChangeTransactionCode I_ChangeDocument ChangeTransactionCode
ChangeDocChangeType I_ChangeDocument ChangeDocChangeType
ChangeDocLanguage I_ChangeDocument ChangeDocLanguage
_CostCtrChangeDocItem _CostCtrChangeDocItem
_ChangeDocLanguage I_ChangeDocument _ChangeDocLanguage 
@AbapCatalog.sqlViewName: 'PCOSTCTRCHGDOC'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.private: true
@VDM.viewType: #CONSUMPTION

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

@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_CostCenterChangeDocument as select from I_ChangeDocument 
  
  association [1..*] to P_CostCtrChangeDocItem as _CostCtrChangeDocItem on  $projection.ChangeDocObject      = _CostCtrChangeDocItem.ChangeDocObject
                                                                        and $projection.ChangeDocObjectClass = _CostCtrChangeDocItem.ChangeDocObjectClass
                                                                        and $projection.ChangeDocument       = _CostCtrChangeDocItem.ChangeDocument




{
  key I_ChangeDocument.ChangeDocObject,           // Controlling Area (4) + Cost Centre (10) i.e.: 0001CC00000001

  key I_ChangeDocument.ChangeDocObjectClass,
  key I_ChangeDocument.ChangeDocument,
  
      cast ( I_ChangeDocument.CreatedByUser as fco_cc_changedby preserving type ) as CreatedByUser,
      cast ( I_ChangeDocument.CreationDate as fco_cc_changedon preserving type ) as CreationDate,
      cast ( I_ChangeDocument.CreationTime as changedocchangetime preserving type ) as CreationTime,
      I_ChangeDocument.ChangeTransactionCode,
      I_ChangeDocument.ChangeDocChangeType,
      @Semantics.language: true
      I_ChangeDocument.ChangeDocLanguage,
      
      _CostCtrChangeDocItem,
      I_ChangeDocument._ChangeDocLanguage
  
} where I_ChangeDocument.ChangeDocObjectClass = 'KOSTL'

Learn More