P_PctrChangeDocument

DDL: P_PCTRCHANGEDOCUMENT SQL: PFIPCTRCHGDOC Type: view CONSUMPTION Package: ODATA_PROFIT_CENTER_V2

Profit Center Change Document

P_PctrChangeDocument is a Consumption CDS View that provides data about "Profit Center Change Document" 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. Part of development package ODATA_PROFIT_CENTER_V2.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeDocument I_ChangeDocument from

Associations (1)

CardinalityTargetAliasCondition
[1..*] P_PctrChangeDocItem _ProfitCtrChangeDocItem $projection.ChangeDocObject = _ProfitCtrChangeDocItem.ChangeDocObject and $projection.ChangeDocObjectClass = _ProfitCtrChangeDocItem.ChangeDocObjectClass and $projection.ChangeDocument = _ProfitCtrChangeDocItem.ChangeDocument

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFIPCTRCHGDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Profit Center Change Document 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
_ProfitCtrChangeDocItem _ProfitCtrChangeDocItem
_ChangeDocLanguage I_ChangeDocument _ChangeDocLanguage 
@AbapCatalog.sqlViewName: 'PFIPCTRCHGDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Profit Center Change Document'
@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_PctrChangeDocument as select from I_ChangeDocument 
  
  association [1..*] to P_PctrChangeDocItem as _ProfitCtrChangeDocItem on  $projection.ChangeDocObject      = _ProfitCtrChangeDocItem.ChangeDocObject
                                                                        and $projection.ChangeDocObjectClass = _ProfitCtrChangeDocItem.ChangeDocObjectClass
                                                                        and $projection.ChangeDocument       = _ProfitCtrChangeDocItem.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 fco_cc_changedat preserving type ) as CreationTime,
      I_ChangeDocument.ChangeTransactionCode,
      I_ChangeDocument.ChangeDocChangeType,
      @Semantics.language: true
      I_ChangeDocument.ChangeDocLanguage,
      
      _ProfitCtrChangeDocItem,
      I_ChangeDocument._ChangeDocLanguage
  
} where I_ChangeDocument.ChangeDocObjectClass = 'PRCTR'

Learn More