C_REUseEnableFxdAstObjAssgmtTP

DDL: C_REUSEENABLEFXDASTOBJASSGMTTP Type: view_entity CONSUMPTION
20 Fields 1 Data Sources

Real Estate Use Fixed Assets

C_REUseEnableFxdAstObjAssgmtTP is a Consumption CDS View that provides data about "Real Estate Use Fixed Assets" in SAP S/4HANA. It reads from 1 data source (R_REUseEnableFxdAstObjAssgmtTP) and exposes 20 fields with key fields InternalRealEstateNumber, REObjectAssignmentType, CompanyCode, MasterFixedAsset, FixedAsset.

Data Sources (1)

SourceAliasJoin Type
R_REUseEnableFxdAstObjAssgmtTP R_REUseEnableFxdAstObjAssgmtTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Real Estate Use Fixed Assets view
Metadata.allowExtensions true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
KEY REObjectAssignmentType REObjectAssignmentType Assignment Type
KEY CompanyCode CompanyCode Receiver Company Code
KEY MasterFixedAsset MasterFixedAsset Fixed Asset
KEY FixedAsset FixedAsset Sub-number
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
CompanyCodeForEdit CompanyCodeForEdit Company Code
MasterFixedAssetForEdit MasterFixedAssetForEdit
FixedAssetForEdit FixedAssetForEdit
REStatusObjectTarget REStatusObjectTarget Object Number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REOnlyInfoAssgmt REOnlyInfoAssgmt Informational
REIsMainAsset REIsMainAsset
FixedAssetDescription _FixedAsset FixedAssetDescription Description
AssetAdditionalDescription _FixedAsset AssetAdditionalDescription
AssetClass _FixedAsset AssetClass Asset Class
AssetClassNameasAssetClassNamelocalized
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality

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_REUseEnableFxdAstObjAssgmtTP.
-- 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_REUseEnableFxdAstObjAssgmtTP AS
SELECT
  InternalRealEstateNumber,
  REObjectAssignmentType,
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  ValidityStartEndDateValue,
  CompanyCodeForEdit,
  MasterFixedAssetForEdit,
  FixedAssetForEdit,
  REStatusObjectTarget,
  ValidityStartDate,
  ValidityEndDate,
  REOnlyInfoAssgmt,
  REIsMainAsset,
  _FixedAsset.FixedAssetDescription AS FixedAssetDescription,
  _FixedAsset.AssetAdditionalDescription AS AssetAdditionalDescription,
  _FixedAsset.AssetClass AS AssetClass,
  _FixedAsset._AssetClass._Text.AssetClassName as AssetClassName : localized AS AssetClassNameasAssetClassNamelocalized,
  REEntryValidity,
  REEntryValidityCriticality
FROM R_REUseEnableFxdAstObjAssgmtTP
;

Learn More