SE11 ABAP Dictionary SE11 BSAK

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

BSAK

Accounting: Secondary Index for Vendors (Cleared Items)

SAP FI Transparent Table 181 Fields

Primary Key:

MANDT BUKRS LIFNR UMSKS UMSKZ AUGDT AUGBL ZUONR GJAHR BELNR BUZEI

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	BUKRS	KEY	CoCode	CHAR	4	-	T001	Company Code
3	LIFNR	KEY	Vendor	CHAR	10	-	LFA1	Account Number of Vendor or Creditor
4	UMSKS	KEY	SpG/L	CHAR	1	-	-	Special G/L Transaction Type
5	UMSKZ	KEY	SGL Ind.	CHAR	1	-	-	Special G/L Indicator
6	AUGDT	KEY	Clearing	DATS	8	-	-	Clearing Date
7	AUGBL	KEY	Document Number of the Clearing Document	CHAR	10	-	-	Document Number of the Clearing Document
8	ZUONR	KEY	Assign.	CHAR	18	-	-	Assignment Number
9	GJAHR	KEY	Fiscal Yr	NUMC	4	-	-	Fiscal Year
10	BELNR	KEY	DocumentNo	CHAR	10	-	-	Accounting Document Number
11	BUZEI	KEY	Item	NUMC	3	-	-	Number of Line Item Within Accounting Document
12	BUDAT	-	Pstng Date	DATS	8	-	-	Posting Date in the Document
13	BLDAT	-	Doc. Date	DATS	8	-	-	Document Date in Document
14	CPUDT	-	Entered	DATS	8	-	-	Day On Which Accounting Document Was Entered
15	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
16	XBLNR	-	Reference	CHAR	16	-	-	Reference Document Number
17	BLART	-	Type	CHAR	2	-	-	Document Type
18	MONAT	-	Period	NUMC	2	-	-	Fiscal Period
19	BSCHL	-	PostKey	CHAR	2	-	-	Posting Key
20	ZUMSK	-	Trg.sp.G/L	CHAR	1	-	-	Target Special G/L Indicator
21	SHKZG	-	D/C indic.	CHAR	1	-	-	Debit/Credit Indicator
22	GSBER	-	Bus. Area	CHAR	4	-	-	Business Area
23	MWSKZ	-	Tax Code	CHAR	2	-	-	Sales Tax Code
24	DMBTR	-	Amount LC	CURR	13	2	-	Amount in Local Currency
25	WRBTR	-	Amount	CURR	13	2	-	Amount in document currency
26	MWSTS	-	LC tax	CURR	13	2	-	Tax Amount in Local Currency
27	WMWST	-	Tax	CURR	13	2	-	Tax amount in document currency
28	BDIFF	-	Val.diff.	CURR	13	2	-	Valuation Difference
29	BDIF2	-	Val.diff.2	CURR	13	2	-	Valuation Difference for the Second Local Currency
30	SGTXT	-	Text	CHAR	50	-	-	Item Text
31	PROJN	-	not in use	CHAR	16	-	-	Old: Project number : No longer used --> PS_POSNR
32	AUFNR	-	Order	CHAR	12	-	-	Order Number
33	ANLN1	-	Asset	CHAR	12	-	-	Main Asset Number
34	ANLN2	-	Subnumber	CHAR	4	-	-	Asset Subnumber
35	EBELN	-	Purch.Doc.	CHAR	10	-	EKKO	Purchasing Document Number
36	EBELP	-	Item	NUMC	5	-	-	Item Number of Purchasing Document
37	SAKNR	-	G/L acct	CHAR	10	-	-	G/L Account Number
38	HKONT	-	G/L Acc	CHAR	10	-	-	General Ledger Account
39	FKONT	-	Fin.bud.im	NUMC	3	-	-	Financial Budget Item
40	FILKD	-	Branch	CHAR	10	-	-	Account Number of the Branch
41	ZFBDT	-	Bline Date	DATS	8	-	-	Baseline Date for Due Date Calculation
42	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
43	ZBD1T	-	Dy 1	DEC	3	-	-	Cash discount days 1
44	ZBD2T	-	Dy 2	DEC	3	-	-	Cash discount days 2
45	ZBD3T	-	Days net	DEC	3	-	-	Net Payment Terms Period
46	ZBD1P	-	Discount %	DEC	5	3	-	Cash Discount Percentage 1
47	ZBD2P	-	Discount 2	DEC	5	3	-	Cash Discount Percentage 2
48	SKFBT	-	Disc.base	CURR	13	2	-	Amount Eligible for Cash Discount in Document Currency
49	SKNTO	-	Disc.amnt	CURR	13	2	-	Cash discount amount in local currency
50	WSKTO	-	Discount	CURR	13	2	-	Cash discount amount in document currency
51	ZLSCH	-	Pay.Method	CHAR	1	-	-	Payment Method
52	ZLSPR	-	Pmnt Block	CHAR	1	-	-	Payment Block Key
53	ZBFIX	-	Fixed	CHAR	1	-	-	Fixed Payment Terms
54	HBKID	-	House Bank	CHAR	5	-	-	Short Key for a House Bank
55	BVTYP	-	Part. Bank	CHAR	4	-	-	Partner Bank Type
56	REBZG	-	Inv.ref.	CHAR	10	-	-	Number of the Invoice the Transaction Belongs to
57	REBZJ	-	Year	NUMC	4	-	-	Fiscal Year of the Relevant Invoice (for Credit Memo)
58	REBZZ	-	Item	NUMC	3	-	-	Line Item in the Relevant Invoice
59	SAMNR	-	Collct.inv	NUMC	8	-	-	Invoice List Number
60	ZOLLT	-	Customs Tariff Number	CHAR	8	-	-	Customs Tariff Number
61	ZOLLD	-	Customs Date	DATS	8	-	-	Customs Date
62	LZBKZ	-	SCB Ind.	CHAR	3	-	-	State Central Bank Indicator
63	LANDL	-	Suppl.Ctry	CHAR	3	-	-	Supplying Country
64	DIEKZ	-	Serv. Ind.	CHAR	1	-	-	Service Indicator (Foreign Payment)
65	MANSP	-	Dunn.block	CHAR	1	-	-	Dunning block
66	MSCHL	-	Dunn.key	CHAR	1	-	-	Dunning key
67	MADAT	-	Last dunn.	DATS	8	-	-	Last dunned on
68	MANST	-	Dunn.level	NUMC	1	-	-	Dunning level
69	MABER	-	Dunn.area	CHAR	2	-	-	Dunning Area
70	XNETB	-	Indicator: Document posted net ?	CHAR	1	-	-	Indicator: Document posted net ?
71	XANET	-	Indicator: Down payment in net procedure ?	CHAR	1	-	-	Indicator: Down payment in net procedure ?
72	XCPDD	-	Indicator: Address and bank data set individually	CHAR	1	-	-	Indicator: Address and bank data set individually
73	XESRD	-	Indicator: Is any ISR data set in the document ?	CHAR	1	-	-	Indicator: Is any ISR data set in the document ?
74	XZAHL	-	Tr	CHAR	1	-	-	Indicator: Is the posting key used in a payment transaction?
75	MWSK1	-	Tax code	CHAR	2	-	-	Tax Code for Distribution
76	DMBT1	-	Amount	CURR	13	2	-	Amount in Local Currency for Tax Distribution
77	WRBT1	-	Amount	CURR	13	2	-	Amount in foreign currency for tax breakdown
78	MWSK2	-	Tax code	CHAR	2	-	-	Tax Code for Distribution
79	DMBT2	-	Amount	CURR	13	2	-	Amount in Local Currency for Tax Distribution
80	WRBT2	-	Amount	CURR	13	2	-	Amount in foreign currency for tax breakdown
81	MWSK3	-	Tax code	CHAR	2	-	-	Tax Code for Distribution
82	DMBT3	-	Amount	CURR	13	2	-	Amount in Local Currency for Tax Distribution
83	WRBT3	-	Amount	CURR	13	2	-	Amount in foreign currency for tax breakdown
84	QSSKZ	-	W.Tax Code	CHAR	2	-	-	Withholding Tax Code
85	QSSHB	-	W.tax base	CURR	13	2	-	Withholding Tax Base Amount
86	QBSHB	-	Wi.tax amt	CURR	13	2	-	Withholding Tax Amount (in Document Currency)
87	BSTAT	-	Status	CHAR	1	-	-	Document Status
88	ANFBN	-	B/e pmt rq	CHAR	10	-	-	Document Number of the Bill of Exchange Payment Request
89	ANFBJ	-	Fiscal yr	NUMC	4	-	-	Fiscal Year of the Bill of Exchange Payment Request Document
90	ANFBU	-	Company Code in Which Bill of Exch.Payment Request Is Posted	CHAR	4	-	-	Company Code in Which Bill of Exch.Payment Request Is Posted
91	VBUND	-	Tradg Part	CHAR	6	-	-	Company ID of trading partner
92	REBZT	-	Type	CHAR	1	-	-	Follow-On Document Type
93	STCEG	-	VAT Reg.No	CHAR	20	-	-	VAT Registration Number
94	EGBLD	-	Dest.cntry	CHAR	3	-	-	Country of Destination for Delivery of Goods
95	EGLLD	-	Suppl.cnty	CHAR	3	-	-	Supplying Country for Delivery of Goods
96	QSZNR	-	Exempt.no.	CHAR	10	-	-	Certificate Number of the Withholding Tax Exemption
97	QSFBT	-	W.tax expt	CURR	13	2	-	Withholding Tax-Exempt Amount (in Document Currency)
98	XINVE	-	Invest.ID	CHAR	1	-	-	Indicator: Capital Goods Affected?
99	PROJK	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
100	FIPOS	-	Cmmt Item	CHAR	14	-	-	Commitment Item
101	NPLNR	-	Network	CHAR	12	-	-	Network Number for Account Assignment
102	AUFPL	-	Plan no.	NUMC	10	-	-	Routing number of operations in the order
103	APLZL	-	Counter	NUMC	8	-	-	Internal counter
104	XEGDR	-	Tri.deal	CHAR	1	-	-	Indicator: Triangular deal within the EU ?
105	DMBE2	-	LC2 amount	CURR	13	2	-	Amount in Second Local Currency
106	DMBE3	-	LC3 amount	CURR	13	2	-	Amount in Third Local Currency
107	DMB21	-	Amount	CURR	13	2	-	Amount in Second Local Currency for Tax Breakdown
108	DMB22	-	Amount	CURR	13	2	-	Amount in Second Local Currency for Tax Breakdown
109	DMB23	-	Amount	CURR	13	2	-	Amount in Second Local Currency for Tax Breakdown
110	DMB31	-	Amount	CURR	13	2	-	Amount in Third Local Currency for Tax Breakdown
111	DMB32	-	Amount	CURR	13	2	-	Amount in Third Local Currency for Tax Breakdown
112	DMB33	-	Amount	CURR	13	2	-	Amount in Third Local Currency for Tax Breakdown
113	MWST2	-	LC2 tax	CURR	13	2	-	Tax Amount in Second Local Currency
114	MWST3	-	LC3 tax	CURR	13	2	-	Tax Amount in Third Local Currency
115	SKNT2	-	LC2 disc.	CURR	13	2	-	Cash Discount Amount in Second Local Currency
116	SKNT3	-	LC3 disc.	CURR	13	2	-	Cash Discount Amount in Third Local Currency
117	BDIF3	-	Val.diff.	CURR	13	2	-	Valuation Difference for the Third Local Currency
118	XRAGL	-	Indicator: Clearing was Reversed	CHAR	1	-	-	Indicator: Clearing was Reversed
119	RSTGR	-	Reason cde	CHAR	3	-	-	Reason Code for Payments
120	UZAWE	-	PmtMthSupl	CHAR	2	-	-	Payment Method Supplement
121	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
122	LNRAN	-	Seq.number	NUMC	5	-	-	Sequence number of asset line items in fiscal year
123	XSTOV	-	Indicator: Document is flagged for reversal	CHAR	1	-	-	Indicator: Document is flagged for reversal
124	KZBTR	-	Org.rdctn	CURR	13	2	-	Original Reduction Amount in Local Currency
125	XREF1	-	Ref.key 1	CHAR	12	-	-	Business partner reference key
126	XREF2	-	Ref.key 2	CHAR	12	-	-	Business partner reference key
127	XARCH	-	Ar	CHAR	1	-	-	Indicator: Document already archived ?
128	PSWSL	-	Currency	CUKY	5	-	-	Update Currency for General Ledger Transaction Figures
129	PSWBT	-	G/L amount	CURR	13	2	-	Amount for Updating in General Ledger
130	IMKEY	-	RE Key	CHAR	8	-	-	Internal Key for Real Estate Object
131	ZEKKN	-	SqNoAccAss	NUMC	2	-	-	Sequential Number of Account Assignment
132	FISTL	-	Funds Ctr	CHAR	16	-	-	Funds Center
133	GEBER	-	Fund	CHAR	10	-	-	Fund
134	DABRZ	-	Ref. Date	DATS	8	-	-	Reference Date for Settlement
135	XNEGP	-	Neg.postng	CHAR	1	-	-	Indicator: Negative posting
136	EMPFB	-	Payer	CHAR	10	-	-	Payee/Payer
137	PRCTR	-	Profit Ctr	CHAR	10	-	-	Profit Center
138	XREF3	-	RefKey 3	CHAR	20	-	-	Reference key for line item
139	DTWS1	-	Inst.key 1	NUMC	2	-	-	Instruction key 1
140	DTWS2	-	C2	NUMC	2	-	-	Instruction key 2
141	DTWS3	-	C3	NUMC	2	-	-	Instruction key 3
142	DTWS4	-	C4	NUMC	2	-	-	Instruction key 4
143	XPYPR	-	Pymnt.sent	CHAR	1	-	-	Indicator: Payment Order Exists for this Item
144	KIDNO	-	Paymt ref.	CHAR	30	-	-	Payment Reference
145	PYCUR	-	PmntCurrcy	CUKY	5	-	-	Currency for Automatic Payment
146	PYAMT	-	Pmnt/c amt	CURR	13	2	-	Amount in Payment Currency
147	BUPLA	-	Bus. Pl.	CHAR	4	-	-	Business Place
148	SECCO	-	Sect. Code	CHAR	4	-	-	Section Code
149	PPDIFF	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
150	PPDIF2	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
151	PPDIF3	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
152	PENLC1	-	Pen.charge	CURR	13	2	-	Penalty charge amount in first local currency
153	PENLC2	-	Pen.charge	CURR	13	2	-	Penalty charge amount in second local currency
154	PENLC3	-	Pen.charge	CURR	13	2	-	Penalty Charge Amount in Third Local Currency
155	PENFC	-	Pen.charge	CURR	13	2	-	Penalty charge amount in document currency
156	PENDAYS	-	Days	INT4	10	-	-	Number of days for penalty charge calculation
157	PENRC	-	Reason	CHAR	2	-	-	Reason for late payment
158	VERTT	-	Cont.Type	CHAR	1	-	-	Contract Type
159	VERTN	-	Contract	CHAR	13	-	-	Contract Number
160	VBEWA	-	Flow Type	CHAR	4	-	-	Flow Type
161	KBLNR	-	Earmd Fnds	CHAR	10	-	-	Document Number for Earmarked Funds
162	KBLPOS	-	Doc. item	NUMC	3	-	-	Earmarked Funds: Document Item
163	GRANT_NBR	-	Grant	CHAR	20	-	-	Grant
164	GMVKZ	-	Execution	CHAR	1	-	-	Item is in Execution
165	SRTYPE	-	Add.Rcvbls	CHAR	2	-	-	Type of Additional Receivable
166	LOTKZ	-	Request No	CHAR	10	-	-	Lot Number for Requests
167	ZINKZ	-	Int.block	CHAR	2	-	-	Exempted from interest calculation
168	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
169	INTRENO	-	RE code	CHAR	13	-	-	Internal Real Estate Master Data Code
170	PPRCT	-	Partner PC	CHAR	10	-	-	Partner Profit Center
171	BUZID	-	Item ID	CHAR	1	-	-	Identification of the Line Item
172	AUGGJ	-	Fisc. Year	NUMC	4	-	-	Fiscal Year of Clearing Document
173	HKTID	-	Acct ID	CHAR	5	-	-	ID for account details
174	BUDGET_PD	-	BP	CHAR	10	-	-	FM: Budget Period
175	KONTT	-	AcctAssCat	CHAR	2	-	-	Account Assignment Category for Industry Solution
176	KONTL	-	Acct.assgt	CHAR	50	-	-	Acct assignment string for industry-specific acct assignmnts
177	UEBGDAT	-	Date dunn.	DATS	8	-	-	Transfer date of an item to legal dunning proceeding
178	VNAME	-	Venture	CHAR	6	-	-	Joint Venture
179	EGRUP	-	Equity grp	CHAR	3	-	-	Equity group
180	BTYPE	-	BillngInd.	CHAR	2	-	-	Payroll Type
181	PROPMANO	-	Mandat	CHAR	13	-	-	Mandat, mandatseröffnender Vertrag

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk BSAK.

Interactive ERD Diagrams

SAP Finance - FI/CO Document Tables →

Standard T-Codes

FBL1N FB03 F110 FCHN

Related Tables

T001 LFA1 TCURC EKKO BKPF BSEG BSAD BSID

ANSI SQL Query

SELECT a.BUKRS,
       a.LIFNR,
       a.UMSKS,
       a.UMSKZ,
       a.AUGDT,
       a.AUGBL,
       a.ZUONR
FROM BSAK AS a
WHERE a.BUKRS = '1000'
  AND a.LIFNR = '0000100001';

ABAP OpenSQL (7.40+)

SELECT a~bukrs,
       a~lifnr,
       a~umsks,
       a~umskz,
       a~augdt,
       a~augbl,
       a~zuonr
  FROM bsak AS a
  WHERE a~bukrs = '1000'
  and a~lifnr = '0000100001'
  INTO TABLE @DATA(lt_bsak)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 BSAK

BSAK

Dictionary Fields Fields

Related References & SQL