BSAK_BCK

Transparent Table Application Table
188 Fields 2 CDS Views

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

BSAK_BCK is an SAP database table in S/4HANA. Buchhaltung: Sekundärindex für Kreditoren (ausgegl. Posten). It contains 188 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_APLineItem_7 view from BASIC Created from DDL source P_APLineItem_7
P_ARLineItem_8 view from BASIC Archived creditor line items (mixed accts, before HANA migr)

Fields (188)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY lifnr lifnr Supplier
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
ebeln ebeln Purchasing Doc.
ebelp ebelp Item
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
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.
zollt dzollt Cust.Tariff No.
zolld dzolld Customs Date
lzbkz lzbkz SCB Ind.
landl landl Supply C/R
diekz diekz Service Ind.
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
xesrd xesrd Indicator: Is Any ISR Data Set in the Document?
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
qsskz qsskz WTax Code
qsshb qsshb WTax Base
qbshb qbshb Withholding Tax
bstat bstat_d Document Status
anfbn anfbn BoE Payt Req.
anfbj anfbj Fisc. Year
anfbu anfbu Company Code
vbund rassc Trading Partner
rebzt rebzt Follow-On Doc. Type
stceg stceg VAT Reg. No.
egbld egbld Dest. C/R
eglld eglld Supplying C/R
qsznr qsznr Exemption No.
qsfbt qsfbt WTax-Exempt
xinve xinve Invest.ID
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
mwst2 mwst2 LC2 Tax
mwst3 mwst3 LC3 Tax
sknt2 sknt2 CD Amt LC2
sknt3 sknt3 CD Amt LC3
bdif3 bdif3 Valuation Diff. 3
xragl xragl Reverse Clearing
rstgr rstgr Reason Code
uzawe uzawe Pmnt Meth. Sup.
kostl kostl Cost Center
lnran lnran Sequence Number
xstov xstov Reversal Flag
kzbtr kzbtr_fi Orig.Reduction
xref1 xref1 Reference Key 1
xref2 xref2 Reference Key 2
xarch xarch Archive
pswsl pswsl G/L Currency
pswbt pswbt G/L Amount
imkey imkey Real Estate Key
zekkn dzekkn Account Assgmt No.
fistl fistl Funds Center
geber bp_geber Fund
dabrz dabrbez Reference date
xnegp xnegp Negative Postg
empfb empfb Payer
prctr prctr Profit Center
xref3 xref3 Reference Key 3
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.
pycur pycur Paymnt Crcy
pyamt pyamt Pt Crcy Amt
bupla bupla Business place
secco secco Section Code
ppdiff ppdiff Diff. Realized
ppdif2 ppdif2 Diff. Realized
ppdif3 ppdif3 Diff. Realized
penlc1 penalty1 Penalty Chge LC
penlc2 penalty2 Pen.Charge LC2
penlc3 penalty3 Pen.Charge LC3
penfc penalty Penalty Charge
pendays pdays Days in Arrears
penrc penrc Reason f. Delay
vertt rantyp Contract Type
vertn ranl Contract Number
vbewa sbewart Flow Type
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
zinkz dzinkz Interest Block
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
_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 Kreditoren (ausgegl. Posten)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BSAK_BCK (
    MANDT,             -- Client [mandt]
    BUKRS,             -- Company Code [bukrs]
    LIFNR,             -- Supplier [lifnr]
    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]
    EBELN,             -- Purchasing Doc. [ebeln]
    EBELP,             -- Item [ebelp]
    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]
    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]
    ZOLLT,             -- Cust.Tariff No. [dzollt]
    ZOLLD,             -- Customs Date [dzolld]
    LZBKZ,             -- SCB Ind. [lzbkz]
    LANDL,             -- Supply C/R [landl]
    DIEKZ,             -- Service Ind. [diekz]
    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]
    XESRD,             -- Indicator: Is Any ISR Data Set in the Document? [xesrd]
    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]
    QSSKZ,             -- WTax Code [qsskz]
    QSSHB,             -- WTax Base [qsshb]
    QBSHB,             -- Withholding Tax [qbshb]
    BSTAT,             -- Document Status [bstat_d]
    ANFBN,             -- BoE Payt Req. [anfbn]
    ANFBJ,             -- Fisc. Year [anfbj]
    ANFBU,             -- Company Code [anfbu]
    VBUND,             -- Trading Partner [rassc]
    REBZT,             -- Follow-On Doc. Type [rebzt]
    STCEG,             -- VAT Reg. No. [stceg]
    EGBLD,             -- Dest. C/R [egbld]
    EGLLD,             -- Supplying C/R [eglld]
    QSZNR,             -- Exemption No. [qsznr]
    QSFBT,             -- WTax-Exempt [qsfbt]
    XINVE,             -- Invest.ID [xinve]
    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]
    MWST2,             -- LC2 Tax [mwst2]
    MWST3,             -- LC3 Tax [mwst3]
    SKNT2,             -- CD Amt LC2 [sknt2]
    SKNT3,             -- CD Amt LC3 [sknt3]
    BDIF3,             -- Valuation Diff. 3 [bdif3]
    XRAGL,             -- Reverse Clearing [xragl]
    RSTGR,             -- Reason Code [rstgr]
    UZAWE,             -- Pmnt Meth. Sup. [uzawe]
    KOSTL,             -- Cost Center [kostl]
    LNRAN,             -- Sequence Number [lnran]
    XSTOV,             -- Reversal Flag [xstov]
    KZBTR,             -- Orig.Reduction [kzbtr_fi]
    XREF1,             -- Reference Key 1 [xref1]
    XREF2,             -- Reference Key 2 [xref2]
    XARCH,             -- Archive [xarch]
    PSWSL,             -- G/L Currency [pswsl]
    PSWBT,             -- G/L Amount [pswbt]
    IMKEY,             -- Real Estate Key [imkey]
    ZEKKN,             -- Account Assgmt No. [dzekkn]
    FISTL,             -- Funds Center [fistl]
    GEBER,             -- Fund [bp_geber]
    DABRZ,             -- Reference date [dabrbez]
    XNEGP,             -- Negative Postg [xnegp]
    EMPFB,             -- Payer [empfb]
    PRCTR,             -- Profit Center [prctr]
    XREF3,             -- Reference Key 3 [xref3]
    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]
    PYCUR,             -- Paymnt Crcy [pycur]
    PYAMT,             -- Pt Crcy Amt [pyamt]
    BUPLA,             -- Business place [bupla]
    SECCO,             -- Section Code [secco]
    PPDIFF,            -- Diff. Realized [ppdiff]
    PPDIF2,            -- Diff. Realized [ppdif2]
    PPDIF3,            -- Diff. Realized [ppdif3]
    PENLC1,            -- Penalty Chge LC [penalty1]
    PENLC2,            -- Pen.Charge LC2 [penalty2]
    PENLC3,            -- Pen.Charge LC3 [penalty3]
    PENFC,             -- Penalty Charge [penalty]
    PENDAYS,           -- Days in Arrears [pdays]
    PENRC,             -- Reason f. Delay [penrc]
    VERTT,             -- Contract Type [rantyp]
    VERTN,             -- Contract Number [ranl]
    VBEWA,             -- Flow Type [sbewart]
    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]
    ZINKZ,             -- Interest Block [dzinkz]
    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]
    _DATAAGING,        -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, BUKRS, LIFNR, UMSKS, UMSKZ, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI)
);

Learn More