FAGLBSAS_BCK

Transparent Table Application Table
83 Fields 1 CDS Views

Buchhaltung: Sekundärindex für Sachkonten (ausgegl. Posten)

FAGLBSAS_BCK is an SAP database table in S/4HANA. Buchhaltung: Sekundärindex für Sachkonten (ausgegl. Posten). It contains 83 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_FAGLBSAS_BCK view from BASIC

Fields (83)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY hkont hkont G/L Acct
KEY augdt augdt Clearing
KEY augbl augbl Clrng doc.
KEY zuonr dzuonr Assignment
KEY gjahr gjahr Fiscal Year
KEY belnr belnr_d Document Number
KEY buzei buzei Item
budat budat Posting Date
bldat bldat Document Date
waers waers Currency
xblnr xblnr1 Reference
blart blart Document Type
monat monat Period
bschl bschl Posting Key
shkzg shkzg Debit/Credit
gsber gsber Business Area
mwskz mwskz Tax Code
txdat_from fot_txdat_from Tax Rate Valid-From
fkont fipls Fin.Budget
dmbtr dmbtr Amount in LC
wrbtr wrbtr Amount
mwsts mwsts LC Tax
wmwst wmwst Tax Amount
sgtxt sgtxt Text
projn projn not in use
aufnr aufnr_neu Order
werks werks_d Plant
kostl kostl Cost Center
zfbdt dzfbdt Baseline Date
xopvw xopvw OI Management
valut valut Value date
bstat bstat_d Document Status
bdiff bdiff Valuation Diff.
bdif2 bdif2 Valuation Diff. 2
vbund rassc Trading Partner
pswsl pswsl G/L Currency
wverw wverw Usage
dmbe2 dmbe2 LC2 Amount
dmbe3 dmbe3 LC3 Amount
mwst2 mwst2 LC2 Tax
mwst3 mwst3 LC3 Tax
bdif3 bdif3 Valuation Diff. 3
rdif3 rdif3 Diff.Realized 3
xragl xragl Reverse Clearing
projk ps_psp_pnr WBS Element
prctr prctr Profit Center
xstov xstov Reversal Flag
xarch xarch Archive
pswbt pswbt G/L Amount
xnegp xnegp Negative Postg
rfzei rfzei_cc Payt Card Item
ccbtc ccbtc Settlement
xref3 xref3 Reference Key 3
bupla bupla Business place
ppdiff ppdiff Diff. Realized
ppdif2 ppdif2 Diff. Realized
ppdif3 ppdif3 Diff. Realized
bewar rmvct Transact. Type
imkey imkey Real Estate Key
dabrz dabrbez Reference date
intreno vvintreno RE code
grant_nbr gm_grant_nbr Grant
fkber fkber Functional Area
fipos fipos Commitment item
fistl fistl Funds Center
geber bp_geber Fund
pprct pprctr Partner PC
buzid buzid Line Item ID
auggj auggj Clrg Fiscal Yr
uzawe uzawe Pmnt Meth. Sup.
segment fb_segment Segment
psegment fb_psegment Partner Segment
prodper jva_prod_month Prod. Month
qsskz qsskz WTax Code
ldgrp fagl_ldgrp Ledger Group
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
rebzt rebzt Follow-On Doc. Type
budget_pd fm_budget_period Budget Period
_dataaging data_temperature Data Aging

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.

-- Buchhaltung: Sekundärindex für Sachkonten (ausgegl. Posten)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAGLBSAS_BCK (
    MANDT,       -- Client [mandt]
    BUKRS,       -- Company Code [bukrs]
    HKONT,       -- G/L Acct [hkont]
    AUGDT,       -- Clearing [augdt]
    AUGBL,       -- Clrng doc. [augbl]
    ZUONR,       -- Assignment [dzuonr]
    GJAHR,       -- Fiscal Year [gjahr]
    BELNR,       -- Document Number [belnr_d]
    BUZEI,       -- Item [buzei]
    BUDAT,       -- Posting Date [budat]
    BLDAT,       -- Document Date [bldat]
    WAERS,       -- Currency [waers]
    XBLNR,       -- Reference [xblnr1]
    BLART,       -- Document Type [blart]
    MONAT,       -- Period [monat]
    BSCHL,       -- Posting Key [bschl]
    SHKZG,       -- Debit/Credit [shkzg]
    GSBER,       -- Business Area [gsber]
    MWSKZ,       -- Tax Code [mwskz]
    TXDAT_FROM,  -- Tax Rate Valid-From [fot_txdat_from]
    FKONT,       -- Fin.Budget [fipls]
    DMBTR,       -- Amount in LC [dmbtr]
    WRBTR,       -- Amount [wrbtr]
    MWSTS,       -- LC Tax [mwsts]
    WMWST,       -- Tax Amount [wmwst]
    SGTXT,       -- Text [sgtxt]
    PROJN,       -- not in use [projn]
    AUFNR,       -- Order [aufnr_neu]
    WERKS,       -- Plant [werks_d]
    KOSTL,       -- Cost Center [kostl]
    ZFBDT,       -- Baseline Date [dzfbdt]
    XOPVW,       -- OI Management [xopvw]
    VALUT,       -- Value date [valut]
    BSTAT,       -- Document Status [bstat_d]
    BDIFF,       -- Valuation Diff. [bdiff]
    BDIF2,       -- Valuation Diff. 2 [bdif2]
    VBUND,       -- Trading Partner [rassc]
    PSWSL,       -- G/L Currency [pswsl]
    WVERW,       -- Usage [wverw]
    DMBE2,       -- LC2 Amount [dmbe2]
    DMBE3,       -- LC3 Amount [dmbe3]
    MWST2,       -- LC2 Tax [mwst2]
    MWST3,       -- LC3 Tax [mwst3]
    BDIF3,       -- Valuation Diff. 3 [bdif3]
    RDIF3,       -- Diff.Realized 3 [rdif3]
    XRAGL,       -- Reverse Clearing [xragl]
    PROJK,       -- WBS Element [ps_psp_pnr]
    PRCTR,       -- Profit Center [prctr]
    XSTOV,       -- Reversal Flag [xstov]
    XARCH,       -- Archive [xarch]
    PSWBT,       -- G/L Amount [pswbt]
    XNEGP,       -- Negative Postg [xnegp]
    RFZEI,       -- Payt Card Item [rfzei_cc]
    CCBTC,       -- Settlement [ccbtc]
    XREF3,       -- Reference Key 3 [xref3]
    BUPLA,       -- Business place [bupla]
    PPDIFF,      -- Diff. Realized [ppdiff]
    PPDIF2,      -- Diff. Realized [ppdif2]
    PPDIF3,      -- Diff. Realized [ppdif3]
    BEWAR,       -- Transact. Type [rmvct]
    IMKEY,       -- Real Estate Key [imkey]
    DABRZ,       -- Reference date [dabrbez]
    INTRENO,     -- RE code [vvintreno]
    GRANT_NBR,   -- Grant [gm_grant_nbr]
    FKBER,       -- Functional Area [fkber]
    FIPOS,       -- Commitment item [fipos]
    FISTL,       -- Funds Center [fistl]
    GEBER,       -- Fund [bp_geber]
    PPRCT,       -- Partner PC [pprctr]
    BUZID,       -- Line Item ID [buzid]
    AUGGJ,       -- Clrg Fiscal Yr [auggj]
    UZAWE,       -- Pmnt Meth. Sup. [uzawe]
    SEGMENT,     -- Segment [fb_segment]
    PSEGMENT,    -- Partner Segment [fb_psegment]
    PRODPER,     -- Prod. Month [jva_prod_month]
    QSSKZ,       -- WTax Code [qsskz]
    LDGRP,       -- Ledger Group [fagl_ldgrp]
    REBZG,       -- Invoice Ref. [rebzg]
    REBZJ,       -- Fiscal Year [rebzj]
    REBZZ,       -- Item [rebzz]
    REBZT,       -- Follow-On Doc. Type [rebzt]
    BUDGET_PD,   -- Budget Period [fm_budget_period]
    _DATAAGING,  -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, BUKRS, HKONT, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI)
);

Learn More