C_PrftCtrCompanyCodeChangeLog

DDL: C_PRFTCTRCOMPANYCODECHANGELOG Type: view_entity CONSUMPTION
26 Fields 1 Data Sources 5 Associations

Change Log Profit Center Company Code

C_PrftCtrCompanyCodeChangeLog is a Consumption CDS View that provides data about "Change Log Profit Center Company Code" in SAP S/4HANA. It reads from 1 data source (P_PrftCtrCompanyCodeChangeLog) and exposes 26 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_PrftCtrCompanyCodeChangeLog _ChangeDocItem from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_PrftCtrChgLgCoCodeAssgmtText _CompCodeAssignmentText _ChangeDocItem.PrftCtrChgLgCoCodeAssgmt = _CompCodeAssignmentText.PrftCtrChgLgCoCodeAssgmt and _CompCodeAssignmentText.Language = $session.system_language
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_ChangeDocTableNames _ChangeDocTableNames _ChangeDocItem.DatabaseTable = _ChangeDocTableNames.Value and _ChangeDocTableNames.Language = $session.system_language
[0..1] I_ControllingAreaStdVH _ControllingAreaStdVH $projection.ControllingArea = _ControllingAreaStdVH.ControllingArea
[0..1] C_ProfitCenterChangeLogUserVH _ChangeLogUser _ChangeDocItem.CreatedByUser = _ChangeLogUser.CreatedByUser

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Change Log Profit Center Company Code view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
UI.headerInfo.typeName Item view
UI.headerInfo.typeNamePlural Items view
VDM.viewType #CONSUMPTION view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject P_PrftCtrCompanyCodeChangeLog ChangeDocObject Object Value
KEY ChangeDocObjectClass P_PrftCtrCompanyCodeChangeLog ChangeDocObjectClass Change Doc. Object
KEY ChangeDocument Document Number
KEY DatabaseTable
KEY ChangeDocTableKey P_PrftCtrCompanyCodeChangeLog ChangeDocTableKey
KEY DatabaseTableField
KEY ChangeDocItemChangeType P_PrftCtrCompanyCodeChangeLog ChangeDocItemChangeType
PrftCtrChgLgCoCodeAssgmt
PrftCtrChgLgCoCodeAssgmtName _CompCodeAssignmentText PrftCtrChgLgCoCodeAssgmtName
CompanyCode P_PrftCtrCompanyCodeChangeLog CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CreatedByUser P_PrftCtrCompanyCodeChangeLog CreatedByUser Changed By
FullName _ChangeLogUser FullName Name
CreationDate P_PrftCtrCompanyCodeChangeLog CreationDate Time Stamp
CreationTime P_PrftCtrCompanyCodeChangeLog CreationTime Time of Change
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue Old Value
ChangeDocNewFieldValue ChangeDocNewFieldValue New Value
DatabaseTableFieldText
Language _ChangeDocument ChangeDocLanguage
LanguageName
ControllingArea P_PrftCtrCompanyCodeChangeLog ControllingArea Controlling Area
ControllingAreaName _ControllingAreaStdVH ControllingAreaName Long Text
ProfitCenter P_PrftCtrCompanyCodeChangeLog ProfitCenter Profit Center
ProfitCenterName
ChangeDocumentTableName
_ChangeLogUser _ChangeLogUser

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_PrftCtrCompanyCodeChangeLog.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_PrftCtrCompanyCodeChangeLog AS
SELECT
  _ChangeDocItem.ChangeDocObject AS ChangeDocObject,
  _ChangeDocItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  cast( ChangeDocument as changedocumentnumber ) AS ChangeDocument,
  cast( _ChangeDocItem.DatabaseTable as changedoctabletechnicalname ) AS DatabaseTable,
  _ChangeDocItem.ChangeDocTableKey AS ChangeDocTableKey,
  cast( _ChangeDocItem.ChangeDocDatabaseTableField as costcenterfieldtechnicalname ) AS DatabaseTableField,
  _ChangeDocItem.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  cast( _ChangeDocItem.PrftCtrChgLgCoCodeAssgmt as prftctrchglgcocodeassgmt preserving type ) AS PrftCtrChgLgCoCodeAssgmt,
  _CompCodeAssignmentText.PrftCtrChgLgCoCodeAssgmtName AS PrftCtrChgLgCoCodeAssgmtName,
  _ChangeDocItem.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _ChangeDocItem.CreatedByUser AS CreatedByUser,
  _ChangeLogUser.FullName AS FullName,
  _ChangeDocItem.CreationDate AS CreationDate,
  _ChangeDocItem.CreationTime AS CreationTime,
  ChangeDocPreviousFieldValue,
  ChangeDocNewFieldValue,
  cast ( _FieldName.Text as fco_cc_fieldname ) AS DatabaseTableFieldText,
  _ChangeDocument.ChangeDocLanguage AS Language,
  _ChangeDocument._ChangeDocLanguage._Text[ 1: Language = $session.system_language ].LanguageName AS LanguageName,
  _ChangeDocItem.ControllingArea AS ControllingArea,
  _ControllingAreaStdVH.ControllingAreaName AS ControllingAreaName,
  _ChangeDocItem.ProfitCenter AS ProfitCenter,
  _ProfitCenter._Text[ 1: Language = $session.system_language ].ProfitCenterName AS ProfitCenterName,
  cast( _ChangeDocTableNames.Text as changedoctablename ) AS ChangeDocumentTableName
FROM P_PrftCtrCompanyCodeChangeLog AS _ChangeDocItem
LEFT OUTER JOIN I_PrftCtrChgLgCoCodeAssgmtText AS _CompCodeAssignmentText ON _ChangeDocItem.PrftCtrChgLgCoCodeAssgmt = _CompCodeAssignmentText.PrftCtrChgLgCoCodeAssgmt AND _CompCodeAssignmentText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocTableNames AS _ChangeDocTableNames ON _ChangeDocItem.DatabaseTable = _ChangeDocTableNames.Value AND _ChangeDocTableNames.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ControllingAreaStdVH AS _ControllingAreaStdVH ON ControllingArea = _ControllingAreaStdVH.ControllingArea  -- association [0..1]
LEFT OUTER JOIN C_ProfitCenterChangeLogUserVH AS _ChangeLogUser ON _ChangeDocItem.CreatedByUser = _ChangeLogUser.CreatedByUser  -- association [0..1]
;

Learn More