SAP ABAP Table BSAD_KB (RE: Tenant Account/Cust. - Cleared Items and Addit.Fields)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVI (Package) R/3 appl.dev. for Financial Assets Management: Real estate

Basic Data

Table Category	INTTAB	Structure
Structure	BSAD_KB	Table Relationship Diagram
Short Description	RE: Tenant Account/Cust. - Cleared Items and Addit.Fields

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Accounting: Secondary Index for Customers (Cleared Items)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	KNB1
4	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
5	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
6	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
7	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
8	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
9	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
10	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
11	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
12	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
13	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
14	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
15	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
16	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
17	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
18	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
19	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
20	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
21	ZUMSK	☐	DZUMSK	UMSKZ	CHAR	1	0	Target Special G/L Indicator	*
22	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
23	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
24	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
25	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
26	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
27	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
28	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
29	BDIFF	☐	BDIFF	WRTV7	CURR	13	2	Valuation Difference
30	BDIF2	☐	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
31	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
32	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
33	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
34	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
35	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
36	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
37	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
38	FKONT	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
39	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
40	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
41	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
42	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
43	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
44	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
45	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
46	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
47	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
48	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
49	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
50	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
51	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
52	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
53	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
54	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
55	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
56	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
57	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
58	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
59	ANFBN	☐	ANFBN	BELNR	CHAR	10	0	Document Number of the Bill of Exchange Payment Request
60	ANFBJ	☐	ANFBJ	GJAHR	NUMC	4	0	Fiscal Year of the Bill of Exchange Payment Request Document
61	ANFBU	☐	ANFBU	BUKRS	CHAR	4	0	Company Code in Which Bill of Exch.Payment Request Is Posted	*
62	ANFAE	☐	ANFAE	DATUM	DATS	8	0	Bill of Exchange Payment Request Due Date
63	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
64	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
65	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
66	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
67	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
68	XNETB	☐	XNETB	XFELD	CHAR	1	0	Indicator: Document posted net ?
69	XANET	☐	XANET	XFELD	CHAR	1	0	Indicator: Down Payment in Net Procedure?
70	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
71	XINVE	☐	XINVE	XFELD	CHAR	1	0	Indicator: Capital Goods Affected?
72	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
73	MWSK1	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
74	DMBT1	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
75	WRBT1	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
76	MWSK2	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
77	DMBT2	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
78	WRBT2	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
79	MWSK3	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
80	DMBT3	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
81	WRBT3	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
82	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
83	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
84	VBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
85	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
86	INFAE	☐	INFAE	CHAR08	CHAR	8	0	Inverted Date for Net Due Date
87	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
88	EGBLD	☐	EGBLD	LAND1	CHAR	3	0	Country of Destination for Delivery of Goods	*
89	EGLLD	☐	EGLLD	LAND1	CHAR	3	0	Supplying Country for Delivery of Goods	*
90	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	*
91	XNOZA	☐	XNOZA	XFELD	CHAR	1	0	Indicator: Account is not counted
92	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
93	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
94	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
95	WVERW	☐	WVERW	WVERW	CHAR	1	0	Bill of Exchange Usage Type
96	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
97	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
98	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
99	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
100	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
101	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
102	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
103	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
104	DMB21	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
105	DMB22	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
106	DMB23	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
107	DMB31	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
108	DMB32	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
109	DMB33	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
110	BDIF3	☐	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
111	XRAGL	☐	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
112	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
113	XSTOV	☐	XSTOV	XFELD	CHAR	1	0	Indicator: Document is flagged for reversal
114	MWST2	☐	MWST2	WERT7	CURR	13	2	Tax Amount in Second Local Currency
115	MWST3	☐	MWST3	WERT7	CURR	13	2	Tax Amount in Third Local Currency
116	SKNT2	☐	SKNT2	WERT7	CURR	13	2	Cash Discount Amount in Second Local Currency
117	SKNT3	☐	SKNT3	WERT7	CURR	13	2	Cash Discount Amount in Third Local Currency
118	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
119	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
120	XARCH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
121	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
122	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
123	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	*
124	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	*
125	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
126	VBEL2	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
127	VPOS2	☐	NUM06	NUM06	NUMC	6	0	Numeric field: Length 6
128	POSN2	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
129	ETEN2	☐	ETENR	ETENR	NUMC	4	0	Schedule line	*
130	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
131	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
132	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
133	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
134	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
135	RFZEI	☐	RFZEI_CC	NUM03	NUMC	3	0	Payment Card Item
136	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
137	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
138	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
139	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
140	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
141	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
142	DTWS1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
143	DTWS2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
144	DTWS3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
145	DTWS4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
146	XPYPR	☐	XPYPR	XFELD	CHAR	1	0	Indicator: Items from Payment Program Blocked
147	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
148	ABSBT	☐	ABSBT	WERT7	CURR	13	2	Credit Management: Hedged Amount
149	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
150	PYCUR	☐	PYCUR	WAERS	CUKY	5	0	Currency for Automatic Payment	*
151	PYAMT	☐	PYAMT	WERT7	CURR	13	2	Amount in Payment Currency
152	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
153	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
154	CESSION_KZ	☐	CESSION_KZ	CESSION_KZ	CHAR	2	0	Accounts Receivable Pledging Indicator	TCESSION
155	PPDIFF	☐	PPDIFF	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
156	PPDIF2	☐	PPDIF2	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
157	PPDIF3	☐	PPDIF3	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
158	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
159	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
160	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
161	GMVKZ	☐	FM_GMVKZ	FM_GMVKZ	CHAR	1	0	Item is in Execution
162	SRTYPE	☐	FM_SRTYPE	FM_SRTYPE	CHAR	2	0	Type of Additional Receivable
163	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
164	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
165	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
166	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
167	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
168	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
169	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
170	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
171	PAYS_PROV	☐	COM_WEC_PAYMENT_SRV_PROVIDER	COM_WEC_PAYMENT_SRV_PROVIDER	CHAR	4	0	Payment Service Provider	*
172	PAYS_TRAN	☐	FPS_TRANSACTION	COM_WEC_PSP_TRANSACTION_ID	CHAR	35	0	Payment Reference of Payment Service Provider
173	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
174	.INCLU--AP	☐				0	0	IS-PS: Data Appendix Cleared Items Customers
175	KONTT	☐	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
176	KONTL	☐	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
177	UEBGDAT	☐	UEBGDAT	DATUM	DATS	8	0	Transfer date of an item to legal dunning proceeding
178	.INCLU--AP	☐				0	0	Joint Venture Fields
179	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
180	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
181	BTYPE	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
182	.INCLU--AP	☐				0	0	Append zur Mandatsverwaltung BSAD
183	.INCLUDE	☐				0	0	Append Struktur für die Mandatsnummer
184	PROPMANO	☐	REHORECNNRM	RECNNR	CHAR	13	0	Mandate, Mandate-Opening Contract
185	XBEWART	☐	XBEWART	TEXT30	CHAR	30	0	Name of flow type
186	PSATZ	☐	MSATZ_F05L	PRZ43V	DEC	7	3	Tax rate
187	XMWSKZ	☐	TEXT1_007S	TEXT50	CHAR	50	0	Name for value-added tax
188	JNOVBEWA	☐	VVJNOVBEWA	XFELD	CHAR	1	0	Indicator that item has not transaction type
189	LTEXT	☐	TEXT_BSLT	TEXT20	CHAR	20	0	Name of the Posting Key
190	JNOVERTN	☐	VVJNOVERTN	XFELD	CHAR	1	0	Indicator that item has no contract number
191	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
192	JAUGBEL	☐	VVJAUGBEL	XFELD	CHAR	1	0	Indicator: Item from clearing document
193	WRVBRT	☐	VVWRVBRT	WRTV7	CURR	13	2	Gross amount in document currency with +/- sign
194	WRVNET	☐	VVWRVNET	WRTV7	CURR	13	2	Net amount in document currency with +/- sign
195	WRVSTE	☐	VVWRVSTE	WRTV7	CURR	13	2	Tax amount (+/-) in document currency
196	HWAERS	☐	VVHAUSWHR	WAERS	CUKY	5	0	Local currency of company code	*
197	BDMVBRT	☐	VVDMVBRT	WRTV7	CURR	13	2	Gross amount in local currency with +/- sign
198	BDMVNET	☐	VVDMVNET	WRTV7	CURR	13	2	Net amount in local currency with +/- signs
199	BDMVSTE	☐	VVDMVSTE	WRTV7	CURR	13	2	Tax amount in local currency with +/- sign
200	.INCLUDE	☐				0	0	Amounts from BSAD_KB in second currency
201	.INCLUDE	☐				0	0	Amounts from BSID_KB in second currency
202	.INCLUDE	☐				0	0	Amounts from BSID in second currency
203	WAERSCUK	☐	SWHRKNDCUK	WAERS	CUKY	5	0	Second Currency for Correspondence	*
204	DMBTRCUK	☐	DMBTRCUK	WERT7	CURR	13	2	Amount in second currency
205	MWSTSCUK	☐	MWSTSCUK	WERT7	CURR	13	2	Tax amount in second currency
206	WRVBRTCUK	☐	WRVBRTCUK	WRTV7	CURR	13	2	Gross amount in second currency with +/- sign
207	WRVNETCUK	☐	WRVNETCUK	WRTV7	CURR	13	2	Net amount in second currency with +/- sign
208	WRVSTECUK	☐	WRVSTECUK	WRTV7	CURR	13	2	Tax amount in second curreny with +/- sign

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BSAD_KB	BTYPE	T8JA	BILIND	REF	C	CN
2	BSAD_KB	BUKRS	KNB1	BUKRS	KEY	1	CN
3	BSAD_KB	CESSION_KZ	TCESSION	CESSION_KZ
4	BSAD_KB	EGRUP	T8JF	EGRUP	REF	C	CN
5	BSAD_KB	KKBER	T014	KKBER	REF	1	CN
6	BSAD_KB	KUNNR	KNA1	KUNNR	KEY	1	CN
7	BSAD_KB	PSWSL	TCURC	WAERS
8	BSAD_KB	UZAWE	T042F	UZAWE	REF	C	CN
9	BSAD_KB	VNAME	T8JV	VNAME	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in