BSAS_BCK

Transparent Table Application Table
89 Fields 1 CDS Views

Accounting: Secondary index for G/L accounts (cleared items)

BSAS_BCK is an SAP database table in S/4HANA. Accounting: Secondary index for G/L accounts (cleared items). It contains 89 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_BSAS_BCK view from BASIC

Fields (89)

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
tax_country FOT_TAX_COUNTRY Tax Ctry/Reg.
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
pgeber FM_PFUND Partner Fund
pgrant_nbr GM_GRANT_PARTNER Partner Grant
measure FM_MEASURE Funded Program
budget_pd FM_BUDGET_PERIOD Budget Period
pbudget_pd FM_PBUDGET_PERIOD Par. BudPer
gkont GKONT Offsetting Acct
gkart GKOAR Offst.Acct Type
ghkon GHKONT G/L Offsetting Acct
_dataaging DATA_TEMPERATURE Data Aging
kidno KIDNO Payment Ref.
fipex FM_FIPEX_DONT_USE Commitment Item
prodper JVA_PROD_MONTH Prod. Month
qsskz QSSKZ WTax Code
propmano REHORECNNRM Mandate

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.

-- Accounting: Secondary index for G/L accounts (cleared items)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSAS_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]
    TAX_COUNTRY,  -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
    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]
    PGEBER,       -- Partner Fund [FM_PFUND]
    PGRANT_NBR,   -- Partner Grant [GM_GRANT_PARTNER]
    MEASURE,      -- Funded Program [FM_MEASURE]
    BUDGET_PD,    -- Budget Period [FM_BUDGET_PERIOD]
    PBUDGET_PD,   -- Par. BudPer [FM_PBUDGET_PERIOD]
    GKONT,        -- Offsetting Acct [GKONT]
    GKART,        -- Offst.Acct Type [GKOAR]
    GHKON,        -- G/L Offsetting Acct [GHKONT]
    _DATAAGING,   -- Data Aging [DATA_TEMPERATURE]
    KIDNO,        -- Payment Ref. [KIDNO]
    FIPEX,        -- Commitment Item [FM_FIPEX_DONT_USE]
    PRODPER,      -- Prod. Month [JVA_PROD_MONTH]
    QSSKZ,        -- WTax Code [QSSKZ]
    PROPMANO,     -- Mandate [REHORECNNRM]
    PRIMARY KEY (MANDT, BUKRS, HKONT, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI)
);

Learn More