SAP ABAP Table VB_DEBI (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VB_DEBI	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	KNB1
4	UMSKS	☑	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
5	UMSKZ	☑	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
6	AUGDT	☑	AUGDT	DATUM	DATS	8	0	Clearing Date
7	AUGBL	☑	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
8	ZUONR	☑	DZUONR	ZUONR	CHAR	18	0	Assignment number
9	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
10	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
11	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
12	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
13	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
14	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
15	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
16	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
17	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
18	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
19	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
20	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
21	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
22	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
23	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
24	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
25	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
26	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
27	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
28	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
29	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
30	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
31	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
32	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
33	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
34	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
35	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
36	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
37	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
38	BUSAB	☐	BUSAB	BUSAB	CHAR	2	0	Accounting clerk	T001S
39	AKONT	☐	AKONT	SAKNR	CHAR	10	0	Reconciliation Account in General Ledger	SKB1
40	BEGRU_B	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
41	ZTERM_B	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
42	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
43	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
44	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
45	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
46	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
47	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
48	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
49	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
50	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
51	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
52	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
53	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
54	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
55	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number
56	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account
57	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
58	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
59	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
60	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
61	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
62	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
63	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
64	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
65	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
66	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
67	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
68	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
69	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
70	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
71	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
72	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
73	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
74	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
75	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
76	XRACH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
77	CESSION_KZ	☐	CESSION_KZ	CESSION_KZ	CHAR	2	0	Accounts Receivable Pledging Indicator	TCESSION

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VB_DEBI	AKONT	SKB1	SAKNR	REF	1	CN
2	VB_DEBI	BLART	T003	BLART	REF	1	CN
3	VB_DEBI	BRSCH	T016	BRSCH	REF	C	CN
4	VB_DEBI	BSCHL	TBSL	BSCHL	REF	C	CN
5	VB_DEBI	BUKRS	KNB1	BUKRS	KEY	1	CN
6	VB_DEBI	BUSAB	T001S	BUSAB	REF	C	CN
7	VB_DEBI	CESSION_KZ	TCESSION	CESSION_KZ
8	VB_DEBI	CITYC	T005G	CITYC	REF	C	CN
9	VB_DEBI	COUNC	T005E	COUNC	REF	C	CN
10	VB_DEBI	GSBER	TGSB	GSBER	REF	C	CN
11	VB_DEBI	KUNNR	KNA1	KUNNR	KEY	1	CN
12	VB_DEBI	LAND1	T005	LAND1	REF	C	CN
13	VB_DEBI	LIFNR	LFA1	LIFNR	REF	C	CN
14	VB_DEBI	MANSP	T040S	MANSP	REF	C	CN
15	VB_DEBI	MSCHL	T040	MSCHL	REF	C	CN
16	VB_DEBI	MWSKZ	T007A	MWSKZ	REF	C	CN
17	VB_DEBI	REGIO	T005S	BLAND	REF	C	CN
18	VB_DEBI	SPRAS	T002	SPRAS	REF	1	CN
19	VB_DEBI	UMSKZ	T074U	UMSKZ	REF	C	CN
20	VB_DEBI	VBUND	T880	RCOMP	REF	C	CN
21	VB_DEBI	WAERS	TCURC	WAERS	REF	1	CN
22	VB_DEBI	ZLSCH	T042Z	ZLSCH	REF	C	CN
23	VB_DEBI	ZLSPR	T008	ZAHLS	REF	C	CN
24	VB_DEBI	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in