FAAGTT_PLAN_VAL

Transparent Table Temporary Data
42 Fields 8 CDS Views

GTT for Planned Depreciations and Revaluations

FAAGTT_PLAN_VAL is an SAP database table in S/4HANA. GTT for Planned Depreciations and Revaluations. It contains 42 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
FAA_CompDrvdAreaPlanVal01 view from Compare Derived Area PLAN_VALUES 01
FAA_CompDrvdAreaSplitNum view union_all Compare Derived Area Split Number
FAA_SDM_DOCIT_CP02 view union_all Compare splitting number of line items
FAA_SDM_DOCIT_CP21 view from Compare from PLAN_VALUE to ACDOCA
FAA_UPA_MIG_DA_PLANV_CMPR01 view_entity from Compare PLAN_VALUES for derived area L1
FAA_UPA_MIG_DA_PLANV_SPLT view_entity from Split PLAN_VALUES-DRCRK for derived area
FAA_UPA_MIG_DI_PLANV_CMPR01 view_entity from Compare PLAN_VALUES layer 1
FAA_UPA_MIG_DI_PLANV_SPLT view_entity from Split PLAN_VALUES-DRCRK

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY anln1 ANLN1 Asset
KEY anln2 ANLN2 Sub-number
KEY gjahr GJAHR Fiscal Year
KEY afabe AFABE_D Deprec. area
KEY poper POPER Posting Period
KEY slalittype SLALITTYPE SLALineItemType
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
sdm_status FAA_SDM_STATUS SDM Status

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.

-- GTT for Planned Depreciations and Revaluations
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAGTT_PLAN_VAL (
    MANDT,          -- Client [MANDT]
    BUKRS,          -- Company Code [BUKRS]
    ANLN1,          -- Asset [ANLN1]
    ANLN2,          -- Sub-number [ANLN2]
    GJAHR,          -- Fiscal Year [GJAHR]
    AFABE,          -- Deprec. area [AFABE_D]
    POPER,          -- Posting Period [POPER]
    SLALITTYPE,     -- SLALineItemType [SLALITTYPE]
    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]
    SDM_STATUS,     -- SDM Status [FAA_SDM_STATUS]
    PRIMARY KEY (MANDT, BUKRS, ANLN1, ANLN2, GJAHR, AFABE, POPER, SLALITTYPE)
);

Learn More