SE11 ABAP Dictionary SE11 BSID

Popular:

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

BSID

Accounting: Secondary Index for Customers

SAP FI Transparent Table 176 Fields

Primary Key:

MANDT BUKRS KUNNR 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	KUNNR	KEY	Customer	CHAR	10	-	KNA1	Customer Number 1
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	SAKNR	-	G/L acct	CHAR	10	-	-	G/L Account Number
36	HKONT	-	G/L Acc	CHAR	10	-	-	General Ledger Account
37	FKONT	-	Fin.bud.im	NUMC	3	-	-	Financial Budget Item
38	FILKD	-	Branch	CHAR	10	-	-	Account Number of the Branch
39	ZFBDT	-	Bline Date	DATS	8	-	-	Baseline Date for Due Date Calculation
40	ZTERM	-	Payt Terms	CHAR	4	-	-	Terms of Payment Key
41	ZBD1T	-	Dy 1	DEC	3	-	-	Cash discount days 1
42	ZBD2T	-	Dy 2	DEC	3	-	-	Cash discount days 2
43	ZBD3T	-	Days net	DEC	3	-	-	Net Payment Terms Period
44	ZBD1P	-	Discount %	DEC	5	3	-	Cash Discount Percentage 1
45	ZBD2P	-	Discount 2	DEC	5	3	-	Cash Discount Percentage 2
46	SKFBT	-	Disc.base	CURR	13	2	-	Amount Eligible for Cash Discount in Document Currency
47	SKNTO	-	Disc.amnt	CURR	13	2	-	Cash discount amount in local currency
48	WSKTO	-	Discount	CURR	13	2	-	Cash discount amount in document currency
49	ZLSCH	-	Pay.Method	CHAR	1	-	-	Payment Method
50	ZLSPR	-	Pmnt Block	CHAR	1	-	-	Payment Block Key
51	ZBFIX	-	Fixed	CHAR	1	-	-	Fixed Payment Terms
52	HBKID	-	House Bank	CHAR	5	-	-	Short Key for a House Bank
53	BVTYP	-	Part. Bank	CHAR	4	-	-	Partner Bank Type
54	REBZG	-	Inv.ref.	CHAR	10	-	-	Number of the Invoice the Transaction Belongs to
55	REBZJ	-	Year	NUMC	4	-	-	Fiscal Year of the Relevant Invoice (for Credit Memo)
56	REBZZ	-	Item	NUMC	3	-	-	Line Item in the Relevant Invoice
57	SAMNR	-	Collct.inv	NUMC	8	-	-	Invoice List Number
58	ANFBN	-	B/e pmt rq	CHAR	10	-	-	Document Number of the Bill of Exchange Payment Request
59	ANFBJ	-	Fiscal yr	NUMC	4	-	-	Fiscal Year of the Bill of Exchange Payment Request Document
60	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
61	ANFAE	-	Bill of Exchange Payment Request Due Date	DATS	8	-	-	Bill of Exchange Payment Request Due Date
62	MANSP	-	Dunn.block	CHAR	1	-	-	Dunning block
63	MSCHL	-	Dunn.key	CHAR	1	-	-	Dunning key
64	MADAT	-	Last dunn.	DATS	8	-	-	Last dunned on
65	MANST	-	Dunn.level	NUMC	1	-	-	Dunning level
66	MABER	-	Dunn.area	CHAR	2	-	-	Dunning Area
67	XNETB	-	Indicator: Document posted net ?	CHAR	1	-	-	Indicator: Document posted net ?
68	XANET	-	Indicator: Down payment in net procedure ?	CHAR	1	-	-	Indicator: Down payment in net procedure ?
69	XCPDD	-	Indicator: Address and bank data set individually	CHAR	1	-	-	Indicator: Address and bank data set individually
70	XINVE	-	Invest.ID	CHAR	1	-	-	Indicator: Capital Goods Affected?
71	XZAHL	-	Tr	CHAR	1	-	-	Indicator: Is the posting key used in a payment transaction?
72	MWSK1	-	Tax code	CHAR	2	-	-	Tax Code for Distribution
73	DMBT1	-	Amount	CURR	13	2	-	Amount in Local Currency for Tax Distribution
74	WRBT1	-	Amount	CURR	13	2	-	Amount in foreign currency for tax breakdown
75	MWSK2	-	Tax code	CHAR	2	-	-	Tax Code for Distribution
76	DMBT2	-	Amount	CURR	13	2	-	Amount in Local Currency for Tax Distribution
77	WRBT2	-	Amount	CURR	13	2	-	Amount in foreign currency for tax breakdown
78	MWSK3	-	Tax code	CHAR	2	-	-	Tax Code for Distribution
79	DMBT3	-	Amount	CURR	13	2	-	Amount in Local Currency for Tax Distribution
80	WRBT3	-	Amount	CURR	13	2	-	Amount in foreign currency for tax breakdown
81	BSTAT	-	Status	CHAR	1	-	-	Document Status
82	VBUND	-	Tradg Part	CHAR	6	-	-	Company ID of trading partner
83	VBELN	-	Bill.Doc.	CHAR	10	-	VBAK	Billing Document
84	REBZT	-	Type	CHAR	1	-	-	Follow-On Document Type
85	INFAE	-	InvDueDate	CHAR	8	-	-	Inverted Date for Net Due Date
86	STCEG	-	VAT Reg.No	CHAR	20	-	-	VAT Registration Number
87	EGBLD	-	Dest.cntry	CHAR	3	-	-	Country of Destination for Delivery of Goods
88	EGLLD	-	Suppl.cnty	CHAR	3	-	-	Supplying Country for Delivery of Goods
89	RSTGR	-	Reason cde	CHAR	3	-	-	Reason Code for Payments
90	XNOZA	-	Indicator: Account is not counted	CHAR	1	-	-	Indicator: Account is not counted
91	VERTT	-	Cont.Type	CHAR	1	-	-	Contract Type
92	VERTN	-	Contract	CHAR	13	-	-	Contract Number
93	VBEWA	-	Flow Type	CHAR	4	-	-	Flow Type
94	WVERW	-	Usage	CHAR	1	-	-	Bill of exchange usage type
95	PROJK	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
96	FIPOS	-	Cmmt Item	CHAR	14	-	-	Commitment Item
97	NPLNR	-	Network	CHAR	12	-	-	Network Number for Account Assignment
98	AUFPL	-	Plan no.	NUMC	10	-	-	Routing number of operations in the order
99	APLZL	-	Counter	NUMC	8	-	-	Internal counter
100	XEGDR	-	Tri.deal	CHAR	1	-	-	Indicator: Triangular deal within the EU ?
101	DMBE2	-	LC2 amount	CURR	13	2	-	Amount in Second Local Currency
102	DMBE3	-	LC3 amount	CURR	13	2	-	Amount in Third Local Currency
103	DMB21	-	Amount	CURR	13	2	-	Amount in Second Local Currency for Tax Breakdown
104	DMB22	-	Amount	CURR	13	2	-	Amount in Second Local Currency for Tax Breakdown
105	DMB23	-	Amount	CURR	13	2	-	Amount in Second Local Currency for Tax Breakdown
106	DMB31	-	Amount	CURR	13	2	-	Amount in Third Local Currency for Tax Breakdown
107	DMB32	-	Amount	CURR	13	2	-	Amount in Third Local Currency for Tax Breakdown
108	DMB33	-	Amount	CURR	13	2	-	Amount in Third Local Currency for Tax Breakdown
109	BDIF3	-	Val.diff.	CURR	13	2	-	Valuation Difference for the Third Local Currency
110	XRAGL	-	Indicator: Clearing was Reversed	CHAR	1	-	-	Indicator: Clearing was Reversed
111	UZAWE	-	PmtMthSupl	CHAR	2	-	-	Payment Method Supplement
112	XSTOV	-	Indicator: Document is flagged for reversal	CHAR	1	-	-	Indicator: Document is flagged for reversal
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	XREF1	-	Ref.key 1	CHAR	12	-	-	Business partner reference key
118	XREF2	-	Ref.key 2	CHAR	12	-	-	Business partner reference key
119	XARCH	-	Ar	CHAR	1	-	-	Indicator: Document already archived ?
120	PSWSL	-	Currency	CUKY	5	-	-	Update Currency for General Ledger Transaction Figures
121	PSWBT	-	G/L amount	CURR	13	2	-	Amount for Updating in General Ledger
122	LZBKZ	-	SCB Ind.	CHAR	3	-	-	State Central Bank Indicator
123	LANDL	-	Suppl.Ctry	CHAR	3	-	-	Supplying Country
124	IMKEY	-	RE Key	CHAR	8	-	-	Internal Key for Real Estate Object
125	VBEL2	-	Sales Doc.	CHAR	10	-	-	Sales Document
126	VPOS2	-	Number	NUMC	6	-	-	Numeric field: Length 6
127	POSN2	-	Item	NUMC	6	-	-	Sales Document Item
128	ETEN2	-	Schd. Line	NUMC	4	-	-	Delivery Schedule Line Number
129	FISTL	-	Funds Ctr	CHAR	16	-	-	Funds Center
130	GEBER	-	Fund	CHAR	10	-	-	Fund
131	DABRZ	-	Ref. Date	DATS	8	-	-	Reference Date for Settlement
132	XNEGP	-	Neg.postng	CHAR	1	-	-	Indicator: Negative posting
133	KOSTL	-	Cost Ctr	CHAR	10	-	-	Cost Center
134	RFZEI	-	PmtCrdItem	NUMC	3	-	-	Payment Card Item
135	KKBER	-	CreditArea	CHAR	4	-	-	Credit control area
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	QSSKZ	-	W.Tax Code	CHAR	2	-	-	Withholding Tax Code
140	ZINKZ	-	Int.block	CHAR	2	-	-	Exempted from interest calculation
141	DTWS1	-	Inst.key 1	NUMC	2	-	-	Instruction key 1
142	DTWS2	-	C2	NUMC	2	-	-	Instruction key 2
143	DTWS3	-	C3	NUMC	2	-	-	Instruction key 3
144	DTWS4	-	C4	NUMC	2	-	-	Instruction key 4
145	XPYPR	-	Pymnt.sent	CHAR	1	-	-	Indicator: Payment Order Exists for this Item
146	KIDNO	-	Paymt ref.	CHAR	30	-	-	Payment Reference
147	ABSBT	-	HedgedAmnt	CURR	13	2	-	Credit management: Hedged amount
148	CCBTC	-	Settlement	CHAR	10	-	-	Payment cards: Settlement run
149	PYCUR	-	PmntCurrcy	CUKY	5	-	-	Currency for Automatic Payment
150	PYAMT	-	Pmnt/c amt	CURR	13	2	-	Amount in Payment Currency
151	BUPLA	-	Bus. Pl.	CHAR	4	-	-	Business Place
152	SECCO	-	Sect. Code	CHAR	4	-	-	Section Code
153	CESSION_KZ	-	AR pledg.	CHAR	2	-	-	Accounts Receivable Pledging Indicator
154	PPDIFF	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
155	PPDIF2	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
156	PPDIF3	-	Diff.real.	CURR	13	2	-	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
157	KBLNR	-	Earmd Fnds	CHAR	10	-	-	Document Number for Earmarked Funds
158	KBLPOS	-	Doc. item	NUMC	3	-	-	Earmarked Funds: Document Item
159	GRANT_NBR	-	Grant	CHAR	20	-	-	Grant
160	GMVKZ	-	Execution	CHAR	1	-	-	Item is in Execution
161	SRTYPE	-	Add.Rcvbls	CHAR	2	-	-	Type of Additional Receivable
162	LOTKZ	-	Request No	CHAR	10	-	-	Lot Number for Requests
163	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
164	INTRENO	-	RE code	CHAR	13	-	-	Internal Real Estate Master Data Code
165	PPRCT	-	Partner PC	CHAR	10	-	-	Partner Profit Center
166	BUZID	-	Item ID	CHAR	1	-	-	Identification of the Line Item
167	AUGGJ	-	Fisc. Year	NUMC	4	-	-	Fiscal Year of Clearing Document
168	HKTID	-	Acct ID	CHAR	5	-	-	ID for account details
169	BUDGET_PD	-	BP	CHAR	10	-	-	FM: Budget Period
170	KONTT	-	AcctAssCat	CHAR	2	-	-	Account Assignment Category for Industry Solution
171	KONTL	-	Acct.assgt	CHAR	50	-	-	Acct assignment string for industry-specific acct assignmnts
172	UEBGDAT	-	Date dunn.	DATS	8	-	-	Transfer date of an item to legal dunning proceeding
173	VNAME	-	Venture	CHAR	6	-	-	Joint Venture
174	EGRUP	-	Equity grp	CHAR	3	-	-	Equity group
175	BTYPE	-	BillngInd.	CHAR	2	-	-	Payroll Type
176	PROPMANO	-	PROPMANO	CHAR	13	-	-

Related References & SQL

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

Interactive ERD Diagrams

SAP Finance - FI/CO Document Tables →

Standard T-Codes

FBL5N FB70 F-28 FD10N

Related Tables

T001 KNA1 TCURC VBAK BKPF BSEG BSAD BSIK

ANSI SQL Query

SELECT a.BUKRS,
       a.KUNNR,
       a.UMSKS,
       a.UMSKZ,
       a.AUGDT,
       a.AUGBL,
       a.ZUONR
FROM BSID AS a
WHERE a.BUKRS = '1000'
  AND a.KUNNR = '0000100025';

ABAP OpenSQL (7.40+)

SELECT a~bukrs,
       a~kunnr,
       a~umsks,
       a~umskz,
       a~augdt,
       a~augbl,
       a~zuonr
  FROM bsid AS a
  WHERE a~bukrs = '1000'
  and a~kunnr = '0000100025'
  INTO TABLE @DATA(lt_bsid)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 BSID

BSID

Dictionary Fields Fields

Related References & SQL