FAAT_D_PV_VALUES

Transparent Table Application Table
45 Fields 1 CDS Views

Temporary table for calulated plan values of an asset

FAAT_D_PV_VALUES is an SAP database table in S/4HANA. Temporary table for calulated plan values of an asset. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FixedAssetTmpPlanVal view inner BASIC

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key abap.raw
root_key abap.raw
bukrs BUKRS Company Code
anln1 ANLN1 Asset
anln2 ANLN2 Sub-number
gjahr GJAHR Fiscal Year
afabe AFABE_D Deprec. area
ledger FINS_LEDGER Ledger
poper POPER Posting Period
slalittype SLALITTYPE SLALineItemType
faa_use_val_ty FAA_USE_VAL_TY Value Type for Asset
ldgrp FAGL_LDGRP Ledger Group
rldnr FINS_LEDGER Ledger
anlgr ANLGR Group Asset
anlgr2 ANLGR2 Subnumber
movcat FAA_MOVCAT Trans.Type Cat.
hsl FINS_VHCUR12 Amnt in Comp Cd Crcy
ksl FINS_VKCUR12 Amnt in Global Crcy
osl FINS_VOCUR12 Amount in Currency 1
vsl FINS_VVCUR12 Amount in Currency 2
bsl FINS_VBCUR12 Amount in Currency 3
csl FINS_VCCUR12 Amount in Currency 4
dsl FINS_VDCUR12 Amount in Currency 5
esl FINS_VECUR12 Amount in Currency 6
fsl FINS_VFCUR12 Amount in Currency 7
gsl FINS_VGCUR12 Amount in Currency 8
rhcur FINS_CURRH CompanyCode Currency
rkcur FINS_CURRK Global Currency
rocur FINS_CURR1 Free Defined Crcy 1
rvcur FINS_CURR2 Free Defined Crcy 2
rbcur FINS_CURR3 Free Defined Crcy 3
rccur FINS_CURR4 Free Defined Crcy 4
rdcur FINS_CURR5 Free Defined Crcy 5
recur FINS_CURR6 Free Defined Crcy 6
rfcur FINS_CURR7 Free Defined Crcy 7
rgcur FINS_CURR8 Free Defined Crcy 8
anlkl ANLKL Asset Class
ktogr KTOGR Account Determ.
xanlgr XANLGR_1 Group Asset
xunull XUNULL Below-Zero Acct
xpost FAA_XPOST To Be Posted
poper_shifted FAA_POPER_SHIFTED Posting Period
recid JV_RECIND Recovery Ind.
mig_source FINS_ACDOC_MIG_SOURCE Migr. Source

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.

-- Temporary table for calulated plan values of an asset
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_D_PV_VALUES (
    MANDT,           -- Client [MANDT]
    DB_KEY,          -- abap.raw
    ROOT_KEY,        -- abap.raw
    BUKRS,           -- Company Code [BUKRS]
    ANLN1,           -- Asset [ANLN1]
    ANLN2,           -- Sub-number [ANLN2]
    GJAHR,           -- Fiscal Year [GJAHR]
    AFABE,           -- Deprec. area [AFABE_D]
    LEDGER,          -- Ledger [FINS_LEDGER]
    POPER,           -- Posting Period [POPER]
    SLALITTYPE,      -- SLALineItemType [SLALITTYPE]
    FAA_USE_VAL_TY,  -- Value Type for Asset [FAA_USE_VAL_TY]
    LDGRP,           -- Ledger Group [FAGL_LDGRP]
    RLDNR,           -- Ledger [FINS_LEDGER]
    ANLGR,           -- Group Asset [ANLGR]
    ANLGR2,          -- Subnumber [ANLGR2]
    MOVCAT,          -- Trans.Type Cat. [FAA_MOVCAT]
    HSL,             -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    KSL,             -- Amnt in Global Crcy [FINS_VKCUR12]
    OSL,             -- Amount in Currency 1 [FINS_VOCUR12]
    VSL,             -- Amount in Currency 2 [FINS_VVCUR12]
    BSL,             -- Amount in Currency 3 [FINS_VBCUR12]
    CSL,             -- Amount in Currency 4 [FINS_VCCUR12]
    DSL,             -- Amount in Currency 5 [FINS_VDCUR12]
    ESL,             -- Amount in Currency 6 [FINS_VECUR12]
    FSL,             -- Amount in Currency 7 [FINS_VFCUR12]
    GSL,             -- Amount in Currency 8 [FINS_VGCUR12]
    RHCUR,           -- CompanyCode Currency [FINS_CURRH]
    RKCUR,           -- Global Currency [FINS_CURRK]
    ROCUR,           -- Free Defined Crcy 1 [FINS_CURR1]
    RVCUR,           -- Free Defined Crcy 2 [FINS_CURR2]
    RBCUR,           -- Free Defined Crcy 3 [FINS_CURR3]
    RCCUR,           -- Free Defined Crcy 4 [FINS_CURR4]
    RDCUR,           -- Free Defined Crcy 5 [FINS_CURR5]
    RECUR,           -- Free Defined Crcy 6 [FINS_CURR6]
    RFCUR,           -- Free Defined Crcy 7 [FINS_CURR7]
    RGCUR,           -- Free Defined Crcy 8 [FINS_CURR8]
    ANLKL,           -- Asset Class [ANLKL]
    KTOGR,           -- Account Determ. [KTOGR]
    XANLGR,          -- Group Asset [XANLGR_1]
    XUNULL,          -- Below-Zero Acct [XUNULL]
    XPOST,           -- To Be Posted [FAA_XPOST]
    POPER_SHIFTED,   -- Posting Period [FAA_POPER_SHIFTED]
    RECID,           -- Recovery Ind. [JV_RECIND]
    MIG_SOURCE,      -- Migr. Source [FINS_ACDOC_MIG_SOURCE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More