R_OrglChangeFixedAssetTP

DDL: R_ORGLCHANGEFIXEDASSETTP SQL: ROCFICFA Type: view_entity TRANSACTIONAL Package: ODATA_ORGL_CHANGE_MANAGE
21 Fields 1 Data Sources 3 Associations

Organizational Change Fixed Assets

R_OrglChangeFixedAssetTP is a Transactional CDS View that provides data about "Organizational Change Fixed Assets" in SAP S/4HANA. It reads from 1 data source (I_OrglChangeFixedAsset) and exposes 21 fields with key fields OrganizationalChange, CompanyCode, MasterFixedAsset, FixedAsset. It has 3 associations to related views. Part of development package ODATA_ORGL_CHANGE_MANAGE.

Data Sources (1)

SourceAliasJoin Type
I_OrglChangeFixedAsset I_OrglChangeFixedAsset from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompanyCodeForEdit $projection.CompanyCodeForEdit = _CompanyCodeForEdit.CompanyCode
[0..1] I_MasterFixedAsset _MasterFixedAssetForEdit $projection.CompanyCodeForEdit = _MasterFixedAssetForEdit.CompanyCode
[1..1] I_FixedAsset _FixedAssetForEdit $projection.CompanyCodeForEdit = _FixedAssetForEdit.CompanyCode and $projection.MasterFixedAssetForEdit = _FixedAssetForEdit.MasterFixedAsset and $projection.FixedAssetForEdit = _FixedAssetForEdit.FixedAsset and $projection.MasterFixedAssetForEdit = _FixedAssetForEdit.MasterFixedAsset

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey MasterFixedAsset view
EndUserText.label Organizational Change Fixed Assets view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChange OrganizationalChange Organizational Change
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
CompanyCodeForEdit CompanyCode Receiver Company Code
MasterFixedAssetForEdit MasterFixedAsset Fixed Asset
FixedAssetForEdit FixedAsset Sub-number
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
ProfitCenterByOrglChange ProfitCenterByOrglChange New Profit Center
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_OrganizationalChange _OrganizationalChange
_CompanyCode _CompanyCode
_CompanyCodeForEdit _CompanyCodeForEdit
_FixedAsset _FixedAsset
_FixedAssetForEdit _FixedAssetForEdit
_MasterFixedAsset _MasterFixedAsset
_MasterFixedAssetForEdit _MasterFixedAssetForEdit
_ProfitCenterBfrOrglChangeText _ProfitCenterBfrOrglChangeText
_ProfitCenterByOrglChangeText _ProfitCenterByOrglChangeText

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 R_OrglChangeFixedAssetTP.
-- 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.
-- SQL view name: ROCFICFA

CREATE VIEW R_OrglChangeFixedAssetTP AS
SELECT
  OrganizationalChange,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  CompanyCode AS CompanyCodeForEdit,
  MasterFixedAsset AS MasterFixedAssetForEdit,
  FixedAsset AS FixedAssetForEdit,
  ControllingArea,
  ProfitCenter,
  ProfitCenterByOrglChange,
  LastChangeDateTime,
  LastChangedByUser
FROM I_OrglChangeFixedAsset
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeForEdit ON CompanyCodeForEdit = _CompanyCodeForEdit.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MasterFixedAsset AS _MasterFixedAssetForEdit ON CompanyCodeForEdit = _MasterFixedAssetForEdit.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FixedAsset AS _FixedAssetForEdit ON CompanyCodeForEdit = _FixedAssetForEdit.CompanyCode AND MasterFixedAssetForEdit = _FixedAssetForEdit.MasterFixedAsset AND FixedAssetForEdit = _FixedAssetForEdit.FixedAsset AND MasterFixedAssetForEdit = _FixedAssetForEdit.MasterFixedAsset  -- association [1..1]
;

Learn More