FAAD_RV_INDX

Transparent Table Application Table

Draft Table for entity R_AssetRevaluationIndexTP

FAAD_RV_INDX is an SAP database table in S/4HANA. Draft Table for entity R_AssetRevaluationIndexTP. It contains 20 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_AssetRevaluationIndexDraft view_entity from BASIC Asset Revaluation Index

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY assetrevaluationindex FAA_RV_INDEX_ID Revaluation Index ID
assetrevaluationindexname FAA_RV_INDEX_DESCRIPTION Index Description
assetrevalindexlifecyclestatus FAA_RV_INDEX_LC_STATUS Lifecycle Status
assetrevalidxisusinghistcalc FAA_RV_INDEX_USE_HIST_CALC Index Is Using Historical Calculation
assetrevaluationindextype FAA_RV_INDEX_TYPE Index Type
country LAND1 Country/Reg.
currency WAERS Currency
assetrevalidxdeactivationdate FAA_RV_INDEX_DEACT_DATE Deactivation Date
createdbyuser ABP_CREATION_USER Created By
creationdatetime ABP_CREATION_TSTMPL Created On
lastchangedbyuser ABP_LASTCHANGE_USER Changed By
lastchangedatetime ABP_LASTCHANGE_TSTMPL Changed On
locallastchangedatetime ABP_LOCINST_LASTCHANGE_TSTMPL Changed On
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Draft Table for entity R_AssetRevaluationIndexTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAD_RV_INDX (
    MANDT,                           -- Client [MANDT]
    ASSETREVALUATIONINDEX,           -- Revaluation Index ID [FAA_RV_INDEX_ID]
    ASSETREVALUATIONINDEXNAME,       -- Index Description [FAA_RV_INDEX_DESCRIPTION]
    ASSETREVALINDEXLIFECYCLESTATUS,  -- Lifecycle Status [FAA_RV_INDEX_LC_STATUS]
    ASSETREVALIDXISUSINGHISTCALC,    -- Index Is Using Historical Calculation [FAA_RV_INDEX_USE_HIST_CALC]
    ASSETREVALUATIONINDEXTYPE,       -- Index Type [FAA_RV_INDEX_TYPE]
    COUNTRY,                         -- Country/Reg. [LAND1]
    CURRENCY,                        -- Currency [WAERS]
    ASSETREVALIDXDEACTIVATIONDATE,   -- Deactivation Date [FAA_RV_INDEX_DEACT_DATE]
    CREATEDBYUSER,                   -- Created By [ABP_CREATION_USER]
    CREATIONDATETIME,                -- Created On [ABP_CREATION_TSTMPL]
    LASTCHANGEDBYUSER,               -- Changed By [ABP_LASTCHANGE_USER]
    LASTCHANGEDATETIME,              -- Changed On [ABP_LASTCHANGE_TSTMPL]
    LOCALLASTCHANGEDATETIME,         -- Changed On [ABP_LOCINST_LASTCHANGE_TSTMPL]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, ASSETREVALUATIONINDEX)
);