FAAV_LINEITEMS

101 Fields 2 CDS Views

Generated Table for View

FAAV_LINEITEMS is an SAP database table in S/4HANA. Generated Table for View. It contains 101 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
FAA_LINEITEMS_SUM view from Condense on FAAV_LINEITEMS keyfields
FAA_SIL_ITEMS view from Intern: Bewegungen verdichtet auf AWREF & SLALITTYPE-Ebene

Fields (101)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
ldgrp FAGL_TARGET_LDGRP Target Ledger Group
bukrs BUKRS Company Code
anln1 ANLN1 Asset
anln2 ANLN2 Sub-number
gjahr GJAHR_POS G/L Fiscal Year
subta FINS_SUBTA Sub Transaction
afabe AFABER Deprec. Area
slalittype SLALITTYPE SLALineItemType
drcrk SHKZG Debit/Credit
xnegp abap.char
koart KOART Account type
racct RACCT Account Number
vorgn VORGN Transact. Type
budat BUDAT Posting Date
bzdat BZDAT Asset Val. Date
bwasl ANBWA Ast Transaction Type
poper POPER Posting Period
depr_period PERAF Deprec. Period
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
anlgr ANLGR Group Asset
anlgr2 ANLGR2 Subnumber
anlkl ANLKL Asset Class
ktogr KTOGR Account Determ.
pbukr PBUKRS Partner CoCode
panl1 PANL1 Partner Asset
panl2 PANL2 Partner Sub-No.
subta_rev FINS_SUBTA_REV Reversal Sub Trans
awtyp AWTYP Ref. procedure
awref AWREF Reference Doc.
aworg AWORG Refer. Org.Unit
awsys AWSYS Logical System
awitgrp FINS_AWITGRP Ref. Item Group
awitem FINS_AWITEM Ref. Doc. Item
buzei BUZEI Item
recid JV_RECIND Recovery Ind.
has_fi_doc abap.char
afabe_fi_doc AFABER Deprec. Area
mig_source FINS_ACDOC_MIG_SOURCE Migr. Source
statistic_item abap.char
xreversing FINS_XREVERSING Is Reversing
xreversed FINS_XREVERSED Is Reversed
xsettling FINS_XSETTLING Is Settling
xsettled FINS_XSETTLED Is Settled
prec_awtyp FINS_PREC_AWTYP PrecRefTransact
prec_aworg FINS_PREC_AWORG PrecRefOrgUnit
prec_awref FINS_PREC_AWREF PrecRefDocument
prec_subta FINS_PREC_SUBTA Prec. Sub Transactn
awtyp_rev AWTYP_REV ReversalRefTran
awref_rev AWREF_REV Reversal Ref.
aworg_rev AWORG_REV Reversal Org.
belnr BELNR_D Document Number
glvor GLVOR Bus.transaction
vbund RASSC Trading Partner
bldat BLDAT Document Date
cpudt CPUDT Entered On
cputm CPUTM Entered at
usnam USNAM User Name
tcode TCODE Transaction Code
sgtxt SGTXT Text
menge QUAN1_12 Quantity
meins MEINS Base Unit
xblnr XBLNR1 Reference
zuonr DZUONR Assignment
ebeln EBELN Purchasing Doc.
ebelp EBELP Item
settlement_rule BUREG Distr. Rule Grp
obart abap.char
objid abap.char
augln abap.char
trava_pn TRANSVAR Transfer var.
ldgrpspec_pn XLDGRPSPEC LDGRP-Specific
afabespec_pn XAFABESPEC Area-Specific
ubzdt_pn UBZDT Orig. Val. Dat
xvabg_pn XVABG Compl.Retiremnt
prozs_pn PROZS Percentage Rate
xmanpropval_pn XMANPROPVAL Man. Proport. Values
sdm_curr_conv_src abap.char
sdm_curr_adjust abap.char
sdm_xvabg_set abap.char
sdm_status abap.char

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_LINEITEMS (
    MANDT,              -- Client [MANDT]
    LDGRP,              -- Target Ledger Group [FAGL_TARGET_LDGRP]
    BUKRS,              -- Company Code [BUKRS]
    ANLN1,              -- Asset [ANLN1]
    ANLN2,              -- Sub-number [ANLN2]
    GJAHR,              -- G/L Fiscal Year [GJAHR_POS]
    SUBTA,              -- Sub Transaction [FINS_SUBTA]
    AFABE,              -- Deprec. Area [AFABER]
    SLALITTYPE,         -- SLALineItemType [SLALITTYPE]
    DRCRK,              -- Debit/Credit [SHKZG]
    XNEGP,              -- abap.char
    KOART,              -- Account type [KOART]
    RACCT,              -- Account Number [RACCT]
    VORGN,              -- Transact. Type [VORGN]
    BUDAT,              -- Posting Date [BUDAT]
    BZDAT,              -- Asset Val. Date [BZDAT]
    BWASL,              -- Ast Transaction Type [ANBWA]
    POPER,              -- Posting Period [POPER]
    DEPR_PERIOD,        -- Deprec. Period [PERAF]
    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]
    ANLGR,              -- Group Asset [ANLGR]
    ANLGR2,             -- Subnumber [ANLGR2]
    ANLKL,              -- Asset Class [ANLKL]
    KTOGR,              -- Account Determ. [KTOGR]
    PBUKR,              -- Partner CoCode [PBUKRS]
    PANL1,              -- Partner Asset [PANL1]
    PANL2,              -- Partner Sub-No. [PANL2]
    SUBTA_REV,          -- Reversal Sub Trans [FINS_SUBTA_REV]
    AWTYP,              -- Ref. procedure [AWTYP]
    AWREF,              -- Reference Doc. [AWREF]
    AWORG,              -- Refer. Org.Unit [AWORG]
    AWSYS,              -- Logical System [AWSYS]
    AWITGRP,            -- Ref. Item Group [FINS_AWITGRP]
    AWITEM,             -- Ref. Doc. Item [FINS_AWITEM]
    BUZEI,              -- Item [BUZEI]
    RECID,              -- Recovery Ind. [JV_RECIND]
    HAS_FI_DOC,         -- abap.char
    AFABE_FI_DOC,       -- Deprec. Area [AFABER]
    MIG_SOURCE,         -- Migr. Source [FINS_ACDOC_MIG_SOURCE]
    STATISTIC_ITEM,     -- abap.char
    XREVERSING,         -- Is Reversing [FINS_XREVERSING]
    XREVERSED,          -- Is Reversed [FINS_XREVERSED]
    XSETTLING,          -- Is Settling [FINS_XSETTLING]
    XSETTLED,           -- Is Settled [FINS_XSETTLED]
    PREC_AWTYP,         -- PrecRefTransact [FINS_PREC_AWTYP]
    PREC_AWORG,         -- PrecRefOrgUnit [FINS_PREC_AWORG]
    PREC_AWREF,         -- PrecRefDocument [FINS_PREC_AWREF]
    PREC_SUBTA,         -- Prec. Sub Transactn [FINS_PREC_SUBTA]
    AWTYP_REV,          -- ReversalRefTran [AWTYP_REV]
    AWREF_REV,          -- Reversal Ref. [AWREF_REV]
    AWORG_REV,          -- Reversal Org. [AWORG_REV]
    BELNR,              -- Document Number [BELNR_D]
    GLVOR,              -- Bus.transaction [GLVOR]
    VBUND,              -- Trading Partner [RASSC]
    BLDAT,              -- Document Date [BLDAT]
    CPUDT,              -- Entered On [CPUDT]
    CPUTM,              -- Entered at [CPUTM]
    USNAM,              -- User Name [USNAM]
    TCODE,              -- Transaction Code [TCODE]
    SGTXT,              -- Text [SGTXT]
    MENGE,              -- Quantity [QUAN1_12]
    MEINS,              -- Base Unit [MEINS]
    XBLNR,              -- Reference [XBLNR1]
    ZUONR,              -- Assignment [DZUONR]
    EBELN,              -- Purchasing Doc. [EBELN]
    EBELP,              -- Item [EBELP]
    SETTLEMENT_RULE,    -- Distr. Rule Grp [BUREG]
    OBART,              -- abap.char
    OBJID,              -- abap.char
    AUGLN,              -- abap.char
    TRAVA_PN,           -- Transfer var. [TRANSVAR]
    LDGRPSPEC_PN,       -- LDGRP-Specific [XLDGRPSPEC]
    AFABESPEC_PN,       -- Area-Specific [XAFABESPEC]
    UBZDT_PN,           -- Orig. Val. Dat [UBZDT]
    XVABG_PN,           -- Compl.Retiremnt [XVABG]
    PROZS_PN,           -- Percentage Rate [PROZS]
    XMANPROPVAL_PN,     -- Man. Proport. Values [XMANPROPVAL]
    SDM_CURR_CONV_SRC,  -- abap.char
    SDM_CURR_ADJUST,    -- abap.char
    SDM_XVABG_SET,      -- abap.char
    SDM_STATUS,         -- abap.char
    PRIMARY KEY (MANDT)
);

Learn More