R_AssetRevaluationIndexDraft

DDL: R_ASSETREVALUATIONINDEXDRAFT Type: view_entity BASIC
19 Fields 1 Data Sources

Asset Revaluation Index

R_AssetRevaluationIndexDraft is a Basic CDS View that provides data about "Asset Revaluation Index" in SAP S/4HANA. It reads from 1 data source (faad_rv_indx) and exposes 19 fields with key field AssetRevaluationIndex.

Data Sources (1)

SourceAliasJoin Type
faad_rv_indx faad_rv_indx from

Annotations (7)

NameValueLevelField
EndUserText.label Asset Revaluation Index view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY AssetRevaluationIndex assetrevaluationindex
AssetRevaluationIndexName assetrevaluationindexname
AssetRevalIndexLifecycleStatus assetrevalindexlifecyclestatus
AssetRevalIdxIsUsingHistCalc assetrevalidxisusinghistcalc
AssetRevaluationIndexType assetrevaluationindextype
Country country Venue: Ctry/Reg
Currency currency Valuation Crcy
AssetRevalIdxDeactivationDate assetrevalidxdeactivationdate
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LocalLastChangeDateTime locallastchangedatetime Time Stamp
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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_AssetRevaluationIndexDraft.
-- 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 R_AssetRevaluationIndexDraft AS
SELECT
  AssetRevaluationIndex,
  AssetRevaluationIndexName,
  AssetRevalIndexLifecycleStatus,
  AssetRevalIdxIsUsingHistCalc,
  AssetRevaluationIndexType,
  Country,
  Currency,
  AssetRevalIdxDeactivationDate,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  LocalLastChangeDateTime,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM faad_rv_indx
;

Learn More