BSAD_BCK

Transparent Table Application Table
187 Fields 2 CDS Views

Buchhaltung: Sekundärindex für Debitoren (ausgebl. Posten)

BSAD_BCK is an SAP database table in S/4HANA. Buchhaltung: Sekundärindex für Debitoren (ausgebl. Posten). It contains 187 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_APLineItem_6 view from BASIC Created from DDL source P_APLineItem_6
P_ARLineItem_7 view from BASIC Archived debtor line items (before HANA migration)

Fields (187)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY kunnr kunnr Customer
KEY umsks umsks Transact.Type
KEY umskz umskz Special G/L Ind
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
cpudt cpudt Entered On
waers waers Currency
xblnr xblnr1 Reference
blart blart Document Type
monat monat Period
bschl bschl Posting Key
zumsk dzumsk Trg.Sp.G/L Ind.
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
dmbtr dmbtr Amount in LC
wrbtr wrbtr Amount
mwsts mwsts LC Tax
wmwst wmwst Tax Amount
lwsts lwsts RC Tax
bdiff bdiff Valuation Diff.
bdif2 bdif2 Valuation Diff. 2
sgtxt sgtxt Text
projn projn not in use
aufnr aufnr Order
anln1 anln1 Asset
anln2 anln2 Sub-number
saknr saknr G/L Account
hkont hkont G/L Acct
fkont fipls Fin.Budget
filkd filkd Branch
zfbdt dzfbdt Baseline Date
zterm dzterm Pyt Terms
zbd1t dzbd1t Days 1
zbd2t dzbd2t Days 2
zbd3t dzbd3t Days Net
zbd1p dzbd1p CD Percentage 1
zbd2p dzbd2p CD Percentage 2
skfbt skfbt CD Base
sknto sknto Discount Amt
wskto wskto CD Amount
zlsch dzlsch Pymt Meth.
zlspr dzlspr Pmnt block
augrs farp_augrs
zbfix dzbfix Fixed
hbkid hbkid House Bank
bvtyp bvtyp Part.bank type
rebzg rebzg Invoice Ref.
rebzj rebzj Fiscal Year
rebzz rebzz Item
samnr samnr Collect.Inv.
anfbn anfbn BoE Payt Req.
anfbj anfbj Fisc. Year
anfbu anfbu Company Code
anfae anfae Return Bef.
mansp mansp Dunn. Block
mschl mschl Dunning key
madat madat Last Dunned
manst mahns_d Dunning Level
maber maber Dunning Area
xnetb xnetb Net document type
xanet xanet Indicator: Down Payment in Net Procedure?
xcpdd xcpdd Individ. Set
xinve xinve Invest.ID
xzahl xzahl Payt Tran.
mwsk1 mwskx Tax Code
txdat_from1 fot_txdat_fromx Tax Rate Valid-From
tax_country1 fot_tax_countryx Tax Breakdown C/R
dmbt1 dmbtx Amount
wrbt1 wrbtx Amount
hist_tax_factor1 fot_hist_factor_for_tax_amount CrcyCnvrsnFctrTaxAmt
mwsk2 mwskx Tax Code
txdat_from2 fot_txdat_fromx Tax Rate Valid-From
tax_country2 fot_tax_countryx Tax Breakdown C/R
dmbt2 dmbtx Amount
wrbt2 wrbtx Amount
hist_tax_factor2 fot_hist_factor_for_tax_amount CrcyCnvrsnFctrTaxAmt
mwsk3 mwskx Tax Code
txdat_from3 fot_txdat_fromx Tax Rate Valid-From
tax_country3 fot_tax_countryx Tax Breakdown C/R
dmbt3 dmbtx Amount
wrbt3 wrbtx Amount
hist_tax_factor3 fot_hist_factor_for_tax_amount CrcyCnvrsnFctrTaxAmt
hist_tax_factor fot_hist_factor_for_tax_amount CrcyCnvrsnFctrTaxAmt
bstat bstat_d Document Status
vbund rassc Trading Partner
vbeln vbeln_vf Billing Doc.
rebzt rebzt Follow-On Doc. Type
infae infae Inv. Due Date
stceg stceg VAT Reg. No.
egbld egbld Dest. C/R
eglld eglld Supplying C/R
rstgr rstgr Reason Code
xnoza xnoza Indicator: Account Is Not Counted
vertt rantyp Contract Type
vertn ranl Contract Number
vbewa sbewart Flow Type
wverw wverw Usage
projk ps_psp_pnr WBS Element
fipos fipos Commitment item
nplnr nplnr Network
aufpl co_aufpl Plan No.f.Oper.
aplzl cim_count Counter
xegdr xegdr EU Triang. Deal
dmbe2 dmbe2 LC2 Amount
dmbe3 dmbe3 LC3 Amount
dmb21 dmb2x Amount
dmb22 dmb2x Amount
dmb23 dmb2x Amount
dmb31 dmb3x Amount
dmb32 dmb3x Amount
dmb33 dmb3x Amount
bdif3 bdif3 Valuation Diff. 3
xragl xragl Reverse Clearing
uzawe uzawe Pmnt Meth. Sup.
xstov xstov Reversal Flag
mwst2 mwst2 LC2 Tax
mwst3 mwst3 LC3 Tax
sknt2 sknt2 CD Amt LC2
sknt3 sknt3 CD Amt LC3
xref1 xref1 Reference Key 1
xref2 xref2 Reference Key 2
xarch xarch Archive
pswsl pswsl G/L Currency
pswbt pswbt G/L Amount
lzbkz lzbkz SCB Ind.
landl landl Supply C/R
imkey imkey Real Estate Key
vbel2 vbeln_va Sales Document
vpos2 num06 Number
posn2 posnr_va Item
eten2 etenr Schedule Line
fistl fistl Funds Center
geber bp_geber Fund
dabrz dabrbez Reference date
xnegp xnegp Negative Postg
kostl kostl Cost Center
rfzei rfzei_cc Payt Card Item
kkber kkber Cred.Contr.Area
empfb empfb Payer
prctr prctr Profit Center
xref3 xref3 Reference Key 3
qsskz qsskz WTax Code
zinkz dzinkz Interest Block
dtws1 dtat16 Instruct. Key 1
dtws2 dtat17 Instruct. Key 2
dtws3 dtat18 Instruct. key 3
dtws4 dtat19 Instruct. key 4
xpypr xpypr Payment Sent
kidno kidno Payment Ref.
absbt absbt Hedged Amount
ccbtc ccbtc Settlement
pycur pycur Paymnt Crcy
pyamt pyamt Pt Crcy Amt
bupla bupla Business place
secco secco Section Code
cession_kz cession_kz AR Pledging Ind
ppdiff ppdiff Diff. Realized
ppdif2 ppdif2 Diff. Realized
ppdif3 ppdif3 Diff. Realized
kblnr kblnr_fi Earmarked funds
kblpos kblpos Document Item
grant_nbr gm_grant_nbr Grant
gmvkz fm_gmvkz Execution
srtype fm_srtype Addit.Receivab.
lotkz pso_lotkz Request Number
fkber fkber Functional Area
intreno vvintreno RE code
pprct pprctr Partner PC
buzid buzid Line Item ID
auggj auggj Clrg Fiscal Yr
hktid hktid Account ID
budget_pd fm_budget_period Budget Period
pays_prov com_wec_payment_srv_provider PSP
pays_tran fps_transaction PSP Payment Ref.
mndid sepa_mndid Mandate Ref.
_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 Debitoren (ausgebl. Posten)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSAD_BCK (
    MANDT,             -- Client [mandt]
    BUKRS,             -- Company Code [bukrs]
    KUNNR,             -- Customer [kunnr]
    UMSKS,             -- Transact.Type [umsks]
    UMSKZ,             -- Special G/L Ind [umskz]
    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]
    CPUDT,             -- Entered On [cpudt]
    WAERS,             -- Currency [waers]
    XBLNR,             -- Reference [xblnr1]
    BLART,             -- Document Type [blart]
    MONAT,             -- Period [monat]
    BSCHL,             -- Posting Key [bschl]
    ZUMSK,             -- Trg.Sp.G/L Ind. [dzumsk]
    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]
    DMBTR,             -- Amount in LC [dmbtr]
    WRBTR,             -- Amount [wrbtr]
    MWSTS,             -- LC Tax [mwsts]
    WMWST,             -- Tax Amount [wmwst]
    LWSTS,             -- RC Tax [lwsts]
    BDIFF,             -- Valuation Diff. [bdiff]
    BDIF2,             -- Valuation Diff. 2 [bdif2]
    SGTXT,             -- Text [sgtxt]
    PROJN,             -- not in use [projn]
    AUFNR,             -- Order [aufnr]
    ANLN1,             -- Asset [anln1]
    ANLN2,             -- Sub-number [anln2]
    SAKNR,             -- G/L Account [saknr]
    HKONT,             -- G/L Acct [hkont]
    FKONT,             -- Fin.Budget [fipls]
    FILKD,             -- Branch [filkd]
    ZFBDT,             -- Baseline Date [dzfbdt]
    ZTERM,             -- Pyt Terms [dzterm]
    ZBD1T,             -- Days 1 [dzbd1t]
    ZBD2T,             -- Days 2 [dzbd2t]
    ZBD3T,             -- Days Net [dzbd3t]
    ZBD1P,             -- CD Percentage 1 [dzbd1p]
    ZBD2P,             -- CD Percentage 2 [dzbd2p]
    SKFBT,             -- CD Base [skfbt]
    SKNTO,             -- Discount Amt [sknto]
    WSKTO,             -- CD Amount [wskto]
    ZLSCH,             -- Pymt Meth. [dzlsch]
    ZLSPR,             -- Pmnt block [dzlspr]
    AUGRS,             -- farp_augrs
    ZBFIX,             -- Fixed [dzbfix]
    HBKID,             -- House Bank [hbkid]
    BVTYP,             -- Part.bank type [bvtyp]
    REBZG,             -- Invoice Ref. [rebzg]
    REBZJ,             -- Fiscal Year [rebzj]
    REBZZ,             -- Item [rebzz]
    SAMNR,             -- Collect.Inv. [samnr]
    ANFBN,             -- BoE Payt Req. [anfbn]
    ANFBJ,             -- Fisc. Year [anfbj]
    ANFBU,             -- Company Code [anfbu]
    ANFAE,             -- Return Bef. [anfae]
    MANSP,             -- Dunn. Block [mansp]
    MSCHL,             -- Dunning key [mschl]
    MADAT,             -- Last Dunned [madat]
    MANST,             -- Dunning Level [mahns_d]
    MABER,             -- Dunning Area [maber]
    XNETB,             -- Net document type [xnetb]
    XANET,             -- Indicator: Down Payment in Net Procedure? [xanet]
    XCPDD,             -- Individ. Set [xcpdd]
    XINVE,             -- Invest.ID [xinve]
    XZAHL,             -- Payt Tran. [xzahl]
    MWSK1,             -- Tax Code [mwskx]
    TXDAT_FROM1,       -- Tax Rate Valid-From [fot_txdat_fromx]
    TAX_COUNTRY1,      -- Tax Breakdown C/R [fot_tax_countryx]
    DMBT1,             -- Amount [dmbtx]
    WRBT1,             -- Amount [wrbtx]
    HIST_TAX_FACTOR1,  -- CrcyCnvrsnFctrTaxAmt [fot_hist_factor_for_tax_amount]
    MWSK2,             -- Tax Code [mwskx]
    TXDAT_FROM2,       -- Tax Rate Valid-From [fot_txdat_fromx]
    TAX_COUNTRY2,      -- Tax Breakdown C/R [fot_tax_countryx]
    DMBT2,             -- Amount [dmbtx]
    WRBT2,             -- Amount [wrbtx]
    HIST_TAX_FACTOR2,  -- CrcyCnvrsnFctrTaxAmt [fot_hist_factor_for_tax_amount]
    MWSK3,             -- Tax Code [mwskx]
    TXDAT_FROM3,       -- Tax Rate Valid-From [fot_txdat_fromx]
    TAX_COUNTRY3,      -- Tax Breakdown C/R [fot_tax_countryx]
    DMBT3,             -- Amount [dmbtx]
    WRBT3,             -- Amount [wrbtx]
    HIST_TAX_FACTOR3,  -- CrcyCnvrsnFctrTaxAmt [fot_hist_factor_for_tax_amount]
    HIST_TAX_FACTOR,   -- CrcyCnvrsnFctrTaxAmt [fot_hist_factor_for_tax_amount]
    BSTAT,             -- Document Status [bstat_d]
    VBUND,             -- Trading Partner [rassc]
    VBELN,             -- Billing Doc. [vbeln_vf]
    REBZT,             -- Follow-On Doc. Type [rebzt]
    INFAE,             -- Inv. Due Date [infae]
    STCEG,             -- VAT Reg. No. [stceg]
    EGBLD,             -- Dest. C/R [egbld]
    EGLLD,             -- Supplying C/R [eglld]
    RSTGR,             -- Reason Code [rstgr]
    XNOZA,             -- Indicator: Account Is Not Counted [xnoza]
    VERTT,             -- Contract Type [rantyp]
    VERTN,             -- Contract Number [ranl]
    VBEWA,             -- Flow Type [sbewart]
    WVERW,             -- Usage [wverw]
    PROJK,             -- WBS Element [ps_psp_pnr]
    FIPOS,             -- Commitment item [fipos]
    NPLNR,             -- Network [nplnr]
    AUFPL,             -- Plan No.f.Oper. [co_aufpl]
    APLZL,             -- Counter [cim_count]
    XEGDR,             -- EU Triang. Deal [xegdr]
    DMBE2,             -- LC2 Amount [dmbe2]
    DMBE3,             -- LC3 Amount [dmbe3]
    DMB21,             -- Amount [dmb2x]
    DMB22,             -- Amount [dmb2x]
    DMB23,             -- Amount [dmb2x]
    DMB31,             -- Amount [dmb3x]
    DMB32,             -- Amount [dmb3x]
    DMB33,             -- Amount [dmb3x]
    BDIF3,             -- Valuation Diff. 3 [bdif3]
    XRAGL,             -- Reverse Clearing [xragl]
    UZAWE,             -- Pmnt Meth. Sup. [uzawe]
    XSTOV,             -- Reversal Flag [xstov]
    MWST2,             -- LC2 Tax [mwst2]
    MWST3,             -- LC3 Tax [mwst3]
    SKNT2,             -- CD Amt LC2 [sknt2]
    SKNT3,             -- CD Amt LC3 [sknt3]
    XREF1,             -- Reference Key 1 [xref1]
    XREF2,             -- Reference Key 2 [xref2]
    XARCH,             -- Archive [xarch]
    PSWSL,             -- G/L Currency [pswsl]
    PSWBT,             -- G/L Amount [pswbt]
    LZBKZ,             -- SCB Ind. [lzbkz]
    LANDL,             -- Supply C/R [landl]
    IMKEY,             -- Real Estate Key [imkey]
    VBEL2,             -- Sales Document [vbeln_va]
    VPOS2,             -- Number [num06]
    POSN2,             -- Item [posnr_va]
    ETEN2,             -- Schedule Line [etenr]
    FISTL,             -- Funds Center [fistl]
    GEBER,             -- Fund [bp_geber]
    DABRZ,             -- Reference date [dabrbez]
    XNEGP,             -- Negative Postg [xnegp]
    KOSTL,             -- Cost Center [kostl]
    RFZEI,             -- Payt Card Item [rfzei_cc]
    KKBER,             -- Cred.Contr.Area [kkber]
    EMPFB,             -- Payer [empfb]
    PRCTR,             -- Profit Center [prctr]
    XREF3,             -- Reference Key 3 [xref3]
    QSSKZ,             -- WTax Code [qsskz]
    ZINKZ,             -- Interest Block [dzinkz]
    DTWS1,             -- Instruct. Key 1 [dtat16]
    DTWS2,             -- Instruct. Key 2 [dtat17]
    DTWS3,             -- Instruct. key 3 [dtat18]
    DTWS4,             -- Instruct. key 4 [dtat19]
    XPYPR,             -- Payment Sent [xpypr]
    KIDNO,             -- Payment Ref. [kidno]
    ABSBT,             -- Hedged Amount [absbt]
    CCBTC,             -- Settlement [ccbtc]
    PYCUR,             -- Paymnt Crcy [pycur]
    PYAMT,             -- Pt Crcy Amt [pyamt]
    BUPLA,             -- Business place [bupla]
    SECCO,             -- Section Code [secco]
    CESSION_KZ,        -- AR Pledging Ind [cession_kz]
    PPDIFF,            -- Diff. Realized [ppdiff]
    PPDIF2,            -- Diff. Realized [ppdif2]
    PPDIF3,            -- Diff. Realized [ppdif3]
    KBLNR,             -- Earmarked funds [kblnr_fi]
    KBLPOS,            -- Document Item [kblpos]
    GRANT_NBR,         -- Grant [gm_grant_nbr]
    GMVKZ,             -- Execution [fm_gmvkz]
    SRTYPE,            -- Addit.Receivab. [fm_srtype]
    LOTKZ,             -- Request Number [pso_lotkz]
    FKBER,             -- Functional Area [fkber]
    INTRENO,           -- RE code [vvintreno]
    PPRCT,             -- Partner PC [pprctr]
    BUZID,             -- Line Item ID [buzid]
    AUGGJ,             -- Clrg Fiscal Yr [auggj]
    HKTID,             -- Account ID [hktid]
    BUDGET_PD,         -- Budget Period [fm_budget_period]
    PAYS_PROV,         -- PSP [com_wec_payment_srv_provider]
    PAYS_TRAN,         -- PSP Payment Ref. [fps_transaction]
    MNDID,             -- Mandate Ref. [sepa_mndid]
    _DATAAGING,        -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, BUKRS, KUNNR, UMSKS, UMSKZ, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI)
);

Learn More