SE11 ABAP Dictionary SE11 BSAS

Popular:

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

BSAS

Accounting: Secondary Index for G/L Accounts (Cleared Items)

SAP FI Transparent Table 82 Fields

Primary Key:

MANDT BUKRS HKONT 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	HKONT	KEY	G/L Acc	CHAR	10	-	-	General Ledger Account
4	AUGDT	KEY	Clearing	DATS	8	-	-	Clearing Date
5	AUGBL	KEY	Document Number of the Clearing Document	CHAR	10	-	-	Document Number of the Clearing Document
6	ZUONR	KEY	Assign.	CHAR	18	-	-	Assignment Number
7	GJAHR	KEY	Fiscal Yr	NUMC	4	-	-	Fiscal Year
8	BELNR	KEY	DocumentNo	CHAR	10	-	-	Accounting Document Number
9	BUZEI	KEY	Item	NUMC	3	-	-	Number of Line Item Within Accounting Document
10	BUDAT	-	Pstng Date	DATS	8	-	-	Posting Date in the Document
11	BLDAT	-	Doc. Date	DATS	8	-	-	Document Date in Document
12	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
13	XBLNR	-	Reference	CHAR	16	-	-	Reference Document Number
14	BLART	-	Type	CHAR	2	-	-	Document Type
15	MONAT	-	Period	NUMC	2	-	-	Fiscal Period
16	BSCHL	-	PostKey	CHAR	2	-	-	Posting Key
17	SHKZG	-	D/C indic.	CHAR	1	-	-	Debit/Credit Indicator
18	GSBER	-	Bus. Area	CHAR	4	-	-	Business Area
19	MWSKZ	-	Tax Code	CHAR	2	-	-	Sales Tax Code
20	FKONT	-	Fin.bud.im	NUMC	3	-	-	Financial Budget Item
21	DMBTR	-	Amount LC	CURR	13	2	-	Amount in Local Currency
22	WRBTR	-	Amount	CURR	13	2	-	Amount in document currency
23	MWSTS	-	LC tax	CURR	13	2	-	Tax Amount in Local Currency
24	WMWST	-	Tax	CURR	13	2	-	Tax amount in document currency
25	SGTXT	-	Text	CHAR	50	-	-	Item Text
26	PROJN	-	not in use	CHAR	16	-	-	Old: Project number : No longer used --> PS_POSNR
27	AUFNR	-	Order	CHAR	12	-	-	Order Number
28	WERKS	-	Plant	CHAR	4	-	T001W	Plant
29	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
30	ZFBDT	-	Bline Date	DATS	8	-	-	Baseline Date for Due Date Calculation
31	XOPVW	-	OI mangmnt	CHAR	1	-	-	Indicator: Open item management?
32	VALUT	-	Value date	DATS	8	-	-	Value date
33	BSTAT	-	Status	CHAR	1	-	-	Document Status
34	BDIFF	-	Val.diff.	CURR	13	2	-	Valuation Difference
35	BDIF2	-	Val.diff.2	CURR	13	2	-	Valuation Difference for the Second Local Currency
36	VBUND	-	Tradg Part	CHAR	6	-	-	Company ID of trading partner
37	PSWSL	-	Currency	CUKY	5	-	-	Update Currency for General Ledger Transaction Figures
38	WVERW	-	Usage	CHAR	1	-	-	Bill of exchange usage type
39	DMBE2	-	LC2 amount	CURR	13	2	-	Amount in Second Local Currency
40	DMBE3	-	LC3 amount	CURR	13	2	-	Amount in Third Local Currency
41	MWST2	-	LC2 tax	CURR	13	2	-	Tax Amount in Second Local Currency
42	MWST3	-	LC3 tax	CURR	13	2	-	Tax Amount in Third Local Currency
43	BDIF3	-	Val.diff.	CURR	13	2	-	Valuation Difference for the Third Local Currency
44	RDIF3	-	Diff.real.	CURR	13	2	-	Exchange Rate Difference Realized for Third Local Currency
45	XRAGL	-	Indicator: Clearing was Reversed	CHAR	1	-	-	Indicator: Clearing was Reversed
46	PROJK	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
47	PRCTR	-	Profit Ctr	CHAR	10	-	-	Profit Center
48	XSTOV	-	Indicator: Document is flagged for reversal	CHAR	1	-	-	Indicator: Document is flagged for reversal
49	XARCH	-	Ar	CHAR	1	-	-	Indicator: Document already archived ?
50	PSWBT	-	G/L amount	CURR	13	2	-	Amount for Updating in General Ledger
51	XNEGP	-	Neg.postng	CHAR	1	-	-	Indicator: Negative posting
52	RFZEI	-	PmtCrdItem	NUMC	3	-	-	Payment Card Item
53	CCBTC	-	Settlement	CHAR	10	-	-	Payment cards: Settlement run
54	XREF3	-	RefKey 3	CHAR	20	-	-	Reference key for line item
55	BUPLA	-	Bus. Pl.	CHAR	4	-	-	Business Place
56	PPDIFF	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
57	PPDIF2	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
58	PPDIF3	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
59	BEWAR	-	Trans.Type	CHAR	3	-	-	Transaction Type
60	IMKEY	-	RE Key	CHAR	8	-	-	Internal Key for Real Estate Object
61	DABRZ	-	Ref. Date	DATS	8	-	-	Reference Date for Settlement
62	INTRENO	-	RE code	CHAR	13	-	-	Internal Real Estate Master Data Code
63	GRANT_NBR	-	Grant	CHAR	20	-	-	Grant
64	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
65	FIPOS	-	Cmmt Item	CHAR	14	-	-	Commitment Item
66	FISTL	-	Funds Ctr	CHAR	16	-	-	Funds Center
67	GEBER	-	Fund	CHAR	10	-	-	Fund
68	PPRCT	-	Partner PC	CHAR	10	-	-	Partner Profit Center
69	BUZID	-	Item ID	CHAR	1	-	-	Identification of the Line Item
70	AUGGJ	-	Fisc. Year	NUMC	4	-	-	Fiscal Year of Clearing Document
71	UZAWE	-	PmtMthSupl	CHAR	2	-	-	Payment Method Supplement
72	SEGMENT	-	Segment	CHAR	10	-	-	Segment for Segmental Reporting
73	PSEGMENT	-	Ptnr Segm.	CHAR	10	-	-	Partner Segment for Segmental Reporting
74	PGEBER	-	PartFund	CHAR	10	-	-	Partner Fund
75	PGRANT_NBR	-	Prtnr Grnt	CHAR	20	-	-	Partner Grant
76	MEASURE	-	Funded Prg	CHAR	24	-	-	Funded Program
77	BUDGET_PD	-	BP	CHAR	10	-	-	FM: Budget Period
78	PBUDGET_PD	-	P.BP	CHAR	10	-	-	FM: Partner Budget Period
79	FIPEX	-	Cmmt item	CHAR	24	-	-	Commitment item - Do not use field - see note 447805
80	PRODPER	-	Prd.Monat	ACCP	6	-	-	Produktionsmonat
81	QSSKZ	-	W.Tax Code	CHAR	2	-	-	Withholding Tax Code
82	PROPMANO	-	Mandat	CHAR	13	-	-	Mandat, mandatseröffnender Vertrag

Related References & SQL

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

Interactive ERD Diagrams

SAP Finance - FI/CO Document Tables →

Standard T-Codes

SE11 SE16

Related Tables

T001 TCURC T001W BKPF BSEG BSAD BSID BSIK

ANSI SQL Query

SELECT a.BUKRS,
       a.HKONT,
       a.AUGDT,
       a.AUGBL,
       a.ZUONR,
       a.GJAHR,
       a.BELNR
FROM BSAS AS a
WHERE a.BUKRS = '1000'
  AND a.HKONT = '0001';

ABAP OpenSQL (7.40+)

SELECT a~bukrs,
       a~hkont,
       a~augdt,
       a~augbl,
       a~zuonr,
       a~gjahr,
       a~belnr
  FROM bsas AS a
  WHERE a~bukrs = '1000'
  and a~hkont = '0001'
  INTO TABLE @DATA(lt_bsas)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 BSAS

BSAS

Dictionary Fields Fields

Related References & SQL