C_OrganizationalChangeTP

DDL: C_ORGANIZATIONALCHANGETP Type: view_entity CONSUMPTION
29 Fields 1 Data Sources 1 Associations

Organizational Change

C_OrganizationalChangeTP is a Consumption CDS View that provides data about "Organizational Change" in SAP S/4HANA. It reads from 1 data source (R_OrganizationalChangeTP) and exposes 29 fields with key field OrganizationalChange. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_OrganizationalChangeTP R_OrganizationalChangeTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_OrglChangeActivityTP _ActivityHistory $projection.OrganizationalChange = _ActivityHistory.OrganizationalChange

Annotations (11)

NameValueLevelField
EndUserText.label Organizational Change view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey OrganizationalChange view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.uniqueIdField OrganizationalChange view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange OrganizationalChange Organizational Change
OrganizationalChangeForEdit OrganizationalChangeForEdit Organizational Change
OrganizationalChangeActivity OrganizationalChangeActivity Activity ID
OrglChangeEffectiveDate OrglChangeEffectiveDate Effective Date
OrglChangeProcessingStatus OrglChangeProcessingStatus Orgl Change Status
OrglChangeApplicationVersion OrglChangeApplicationVersion Application Version
OrglChgLastDateBeforeEffDate OrglChgLastDateBeforeEffDate
OrglChangeLastChangeDateTime OrglChangeLastChangeDateTime Last Chg Timestamp
OrglChangeLastChangedByUser OrglChangeLastChangedByUser Last Changed by
LastChangeByUserName _UserLastChgdContactCard FullName Name
OrglChangeCreationDateTime OrglChangeCreationDateTime Creation Timestamp
OrglChangeCreatedByUser OrglChangeCreatedByUser Created by
JobStatusValue _LastActivity JobStatusValue Status
OrganizationalChangeJobType _LastActivity OrganizationalChangeJobType
ApplicationJobStatusText _LastActivity ApplicationJobStatusText
NumberOfUniqueErrors _LastActivity NumberOfUniqueErrors Unique Error Count
NumberOfUniqueWarnings _LastActivity NumberOfUniqueWarnings Unique Warning Count
NumberOfOrglChgStagingErrors _OrglChangeStaging NumberOfOrglChgStagingErrors
ApplicationJobName _LastActivity ApplicationJobName Job Name
ApplicationJob _LastActivity ApplicationJob Job No.
ApplicationLog _LastActivity ApplicationLog Log Number
ApplicationLogHandle _LastActivity ApplicationLogHandle Log Handle
SitnNumberOfInstances _SitnInstceIndicator SitnNumberOfInstances
CreatedByUserFullName _UserCrtedContactCard FullName Name
virtualFixedAssetIsHiddenabap_boolean
_UserCrtedContactCard _UserCrtedContactCard
_UserLastChgdContactCard _UserLastChgdContactCard
_ActivityHistory _ActivityHistory
_SitnInstceIndicator _SitnInstceIndicator

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_OrganizationalChangeTP.
-- 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_OrganizationalChangeTP AS
SELECT
  OrganizationalChange,
  OrganizationalChangeForEdit,
  OrganizationalChangeActivity,
  OrglChangeEffectiveDate,
  OrglChangeProcessingStatus,
  OrglChangeApplicationVersion,
  OrglChgLastDateBeforeEffDate,
  OrglChangeLastChangeDateTime,
  OrglChangeLastChangedByUser,
  _UserLastChgdContactCard.FullName AS LastChangeByUserName,
  OrglChangeCreationDateTime,
  OrglChangeCreatedByUser,
  _LastActivity.JobStatusValue AS JobStatusValue,
  _LastActivity.OrganizationalChangeJobType AS OrganizationalChangeJobType,
  _LastActivity.ApplicationJobStatusText AS ApplicationJobStatusText,
  _LastActivity.NumberOfUniqueErrors AS NumberOfUniqueErrors,
  _LastActivity.NumberOfUniqueWarnings AS NumberOfUniqueWarnings,
  _OrglChangeStaging.NumberOfOrglChgStagingErrors AS NumberOfOrglChgStagingErrors,
  _LastActivity.ApplicationJobName AS ApplicationJobName,
  _LastActivity.ApplicationJob AS ApplicationJob,
  _LastActivity.ApplicationLog AS ApplicationLog,
  _LastActivity.ApplicationLogHandle AS ApplicationLogHandle,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  _UserCrtedContactCard.FullName AS CreatedByUserFullName,
  virtual FixedAssetIsHidden : abap_boolean AS virtualFixedAssetIsHiddenabap_boolean
FROM R_OrganizationalChangeTP
LEFT OUTER JOIN C_OrglChangeActivityTP AS _ActivityHistory ON OrganizationalChange = _ActivityHistory.OrganizationalChange  -- association [0..*]
;

Learn More