Replaced in S/4HANA
This table is replaced by ACDOCA

Cleared customer items table replaced by ACDOCA.

View all S/4HANA migration mappings →

BSAD

209 Fields 1 CDS Views

Generated Table for View

BSAD is an SAP database table in S/4HANA. Generated Table for View. It contains 209 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MPCustomerClearedItem view from BASIC

Fields (209)

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
fcsl FINS_VFCCUR12 Amount in FunctCrcy
rfccur FINS_CURRFC Functional Currency
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
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
bdgt_account PSM_BDGT_ACCOUNT Budget Account
re_account FAGL_RE_ACCOUNT Ex/Rv A/c in CL
pays_prov COM_WEC_PAYMENT_SRV_PROVIDER PSP
pays_tran FPS_TRANSACTION PSP Payment Ref.
mndid SEPA_MNDID Mandate Ref.
payt_rsn FARP_PAYT_RSN Payment Reason
_dataaging DATA_TEMPERATURE Data Aging
kontt KONTT_FI Acct Assmt Cat.
kontl KONTL_FI Acct assignment
uebgdat UEBGDATUM Date of Legal Dunn.
vname JV_NAME Joint venture
egrup JV_EGROUP Equity group
btype JV_BILIND Billing ind.
propmano REHORECNNRM Mandate
gkont GKONT Offsetting Acct
gkart GKOAR Offst.Acct Type
ghkon GHKONT G/L Offsetting Acct
awtyp AWTYP Ref. procedure
logsystem_sender LOGSYSTEM_SENDER Sender Log Sys.
bukrs_sender BUKRS_SENDER Sender CoCode
belnr_sender BELNR_SENDER Sender Doc.No.
gjahr_sender GJAHR_SENDER Sender FiscalYr
buzei_sender BUZEI_SENDER Sender Item
pendays PDAYS Days in Arrears
j_1tpbupl BCODE Branch Code

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 BSAD (
    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]
    FCSL,              -- Amount in FunctCrcy [FINS_VFCCUR12]
    RFCCUR,            -- Functional Currency [FINS_CURRFC]
    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]
    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]
    BDGT_ACCOUNT,      -- Budget Account [PSM_BDGT_ACCOUNT]
    RE_ACCOUNT,        -- Ex/Rv A/c in CL [FAGL_RE_ACCOUNT]
    PAYS_PROV,         -- PSP [COM_WEC_PAYMENT_SRV_PROVIDER]
    PAYS_TRAN,         -- PSP Payment Ref. [FPS_TRANSACTION]
    MNDID,             -- Mandate Ref. [SEPA_MNDID]
    PAYT_RSN,          -- Payment Reason [FARP_PAYT_RSN]
    _DATAAGING,        -- Data Aging [DATA_TEMPERATURE]
    KONTT,             -- Acct Assmt Cat. [KONTT_FI]
    KONTL,             -- Acct assignment [KONTL_FI]
    UEBGDAT,           -- Date of Legal Dunn. [UEBGDATUM]
    VNAME,             -- Joint venture [JV_NAME]
    EGRUP,             -- Equity group [JV_EGROUP]
    BTYPE,             -- Billing ind. [JV_BILIND]
    PROPMANO,          -- Mandate [REHORECNNRM]
    GKONT,             -- Offsetting Acct [GKONT]
    GKART,             -- Offst.Acct Type [GKOAR]
    GHKON,             -- G/L Offsetting Acct [GHKONT]
    AWTYP,             -- Ref. procedure [AWTYP]
    LOGSYSTEM_SENDER,  -- Sender Log Sys. [LOGSYSTEM_SENDER]
    BUKRS_SENDER,      -- Sender CoCode [BUKRS_SENDER]
    BELNR_SENDER,      -- Sender Doc.No. [BELNR_SENDER]
    GJAHR_SENDER,      -- Sender FiscalYr [GJAHR_SENDER]
    BUZEI_SENDER,      -- Sender Item [BUZEI_SENDER]
    PENDAYS,           -- Days in Arrears [PDAYS]
    J_1TPBUPL,         -- Branch Code [BCODE]
    PRIMARY KEY (MANDT, BUKRS, KUNNR, UMSKS, UMSKZ, AUGDT, AUGBL, ZUONR, GJAHR, BELNR, BUZEI)
);

Learn More