FAAV_PLAN_VALUES

37 Fields 1 CDS Views

Generated Table for View

FAAV_PLAN_VALUES is an SAP database table in S/4HANA. Generated Table for View. It contains 37 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FAA_SIL_DEPR view from Intern: Abschreibungen verdichtet auf DEPR_PERIOD & SLALITTYPE-Ebene

Fields (37)

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 afaber AFABE_D Deprec. area
KEY poper POPER Posting Period
KEY slalittype SLALITTYPE SLALineItemType
KEY movcat FAA_MOVCAT Trans.Type Cat.
KEY depr_period POPER Posting Period
KEY posted abap.char
ldgrp FAGL_LDGRP Ledger Group
anlgr ANLGR Group Asset
anlgr2 ANLGR2 Subnumber
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
recid JV_RECIND Recovery Ind.
xpost FAA_XPOST To Be Posted
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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAV_PLAN_VALUES (
    MANDT,        -- Client [MANDT]
    BUKRS,        -- Company Code [BUKRS]
    ANLN1,        -- Asset [ANLN1]
    ANLN2,        -- Sub-number [ANLN2]
    GJAHR,        -- Fiscal Year [GJAHR]
    AFABER,       -- Deprec. area [AFABE_D]
    POPER,        -- Posting Period [POPER]
    SLALITTYPE,   -- SLALineItemType [SLALITTYPE]
    MOVCAT,       -- Trans.Type Cat. [FAA_MOVCAT]
    DEPR_PERIOD,  -- Posting Period [POPER]
    POSTED,       -- abap.char
    LDGRP,        -- Ledger Group [FAGL_LDGRP]
    ANLGR,        -- Group Asset [ANLGR]
    ANLGR2,       -- Subnumber [ANLGR2]
    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]
    RECID,        -- Recovery Ind. [JV_RECIND]
    XPOST,        -- To Be Posted [FAA_XPOST]
    MIG_SOURCE,   -- Migr. Source [FINS_ACDOC_MIG_SOURCE]
    PRIMARY KEY (MANDT, BUKRS, ANLN1, ANLN2, GJAHR, AFABER, POPER, SLALITTYPE, MOVCAT, DEPR_PERIOD, POSTED)
);

Learn More