SAP ABAP View VB_DEBI (View of KNA1, KNB1 and BSID)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FREP (Package) RF reporting

Basic Data

View Type	D	Database View
Database View	VB_DEBI
Short Description	View of KNA1, KNB1 and BSID
Root table	KNA1	General Data in Customer Master

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNA1	KNA1
2	KNB1
3	BSID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ				0	0
2	KNB1	MANDT	JR	EQ			AND	0	0
3	KNA1	KUNNR	JL	EQ				0	0
4	KNB1	KUNNR	JR	EQ			AND	0	0
5	KNB1	MANDT	JL	EQ				0	0
6	BSID	MANDT	JR	EQ			AND	0	0
7	KNB1	KUNNR	JL	EQ				0	0
8	BSID	KUNNR	JR	EQ			AND	0	0
9	KNB1	BUKRS	JL	EQ				0	0
10	BSID	BUKRS	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20131127
SAP Release Created in	470