SAP ABAP View V_VBSEGD (View of VBKPF and VBSEGD)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

View Type	D	Database View
Database View	V_VBSEGD
Short Description	View of VBKPF and VBSEGD
Root table	VBSEGD	Document Segment for Customer Document Parking

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBSEGD	VBSEGD
2	VBKPF

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBKPF	MANDT	JL	EQ				0	0
2	VBSEGD	MANDT	JR	EQ			AND	0	0
3	VBKPF	AUSBK	JL	EQ				0	0
4	VBSEGD	AUSBK	JR	EQ			AND	0	0
5	VBKPF	BUKRS	JL	EQ				0	0
6	VBSEGD	BUKRS	JR	EQ			AND	0	0
7	VBKPF	BELNR	JL	EQ				0	0
8	VBSEGD	BELNR	JR	EQ			AND	0	0
9	VBKPF	GJAHR	JL	EQ				0	0
10	VBSEGD	GJAHR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VBSEGD	MANDT		☐	MANDT	☐	Client
2	AUSBK	VBSEGD	AUSBK		☐	AUSBK	☐	Source Company Code
3	BELNR	VBSEGD	BELNR		☐	BELNR_D	☐	Accounting Document Number
4	GJAHR	VBSEGD	GJAHR		☐	GJAHR	☐	Fiscal Year
5	BZKEY	VBSEGD	BZKEY		☐	BUZEI	☐	Number of Line Item Within Accounting Document
6	BUKRS	VBSEGD	BUKRS		☐	BUKRS	☐	Company Code
7	BUZEI	VBSEGD	BUZEI		☐	BUZEI	☐	Number of Line Item Within Accounting Document
8	BSCHL	VBSEGD	BSCHL		☐	BSCHL	☐	Posting Key
9	UMSKZ	VBSEGD	UMSKZ		☐	UMSKZ	☐	Special G/L Indicator
10	UMSKS	VBSEGD	UMSKS		☐	UMSKS	☐	Special G/L Transaction Type
11	SHKZG	VBSEGD	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
12	GSBER	VBSEGD	GSBER		☐	GSBER	☐	Business Area
13	PARGB	VBSEGD	PARGB		☐	PARGB	☐	Trading partner's business area
14	MWSKZ	VBSEGD	MWSKZ		☐	MWSKZ	☐	Tax on sales/purchases code
15	DMBTR	VBSEGD	DMBTR		☐	DMBTR	☐	Amount in local currency
16	DMBE2	VBSEGD	DMBE2		☐	DMBE2	☐	Amount in Second Local Currency
17	DMBE3	VBSEGD	DMBE3		☐	DMBE3	☐	Amount in Third Local Currency
18	WRBTR	VBSEGD	WRBTR		☐	WRBTR	☐	Amount in document currency
19	HWMET	VBSEGD	HWMET		☐	HWMET	☐	Method with Which the Local Currency Amount Was Determined
20	MWSTS	VBSEGD	MWSTS		☐	MWSTS	☐	Tax Amount in Local Currency
21	MWST2	VBSEGD	MWST2		☐	MWST2	☐	Tax Amount in Second Local Currency
22	MWST3	VBSEGD	MWST3		☐	MWST3	☐	Tax Amount in Third Local Currency
23	WMWST	VBSEGD	WMWST		☐	WMWST	☐	Tax amount in document currency
24	HWBAS	VBSEGD	HWBAS		☐	HWBAS	☐	Tax Base Amount in Local Currency
25	FWBAS	VBSEGD	FWBAS		☐	FWBAS	☐	Tax Base Amount in Document Currency
26	MWART	VBSEGD	MWART		☐	MWART	☐	Tax Type
27	KURSR	VBSEGD	KURSR		☐	KURSR	☐	Hedged Exchange Rate
28	GBETR	VBSEGD	GBETR		☐	GBETR	☐	Hedged Amount in Foreign Currency
29	VALUT	VBSEGD	VALUT		☐	VALUT	☐	Fixed Value Date
30	ZUONR	VBSEGD	ZUONR		☐	DZUONR	☐	Assignment number
31	SGTXT	VBSEGD	SGTXT		☐	SGTXT	☐	Item Text
32	ZINKZ	VBSEGD	ZINKZ		☐	DZINKZ	☐	Exempted from Interest Calculation
33	FDLEV	VBSEGD	FDLEV		☐	FDLEV	☐	Planning Level
34	FDGRP	VBSEGD	FDGRP		☐	FDGRP	☐	Planning Group
35	FDWBT	VBSEGD	FDWBT		☐	FDWBT	☐	Planned Amount in Document or G/L Account Currency
36	FDTAG	VBSEGD	FDTAG		☐	FDTAG	☐	Planning Date
37	GEBER	VBSEGD	GEBER		☐	BP_GEBER	☐	Fund
38	FISTL	VBSEGD	FISTL		☐	FISTL	☐	Funds Center
39	VNAME	VBSEGD	VNAME		☐	JV_NAME	☐	Joint venture
40	EGRUP	VBSEGD	EGRUP		☐	JV_EGROUP	☐	Equity group
41	BTYPE	VBSEGD	BTYPE		☐	JV_BILIND	☐	Payroll Type
42	XUMSW	VBSEGD	XUMSW		☐	XUMSW	☐	Indicator: Sales-Related Item ?
43	XCPDD	VBSEGD	XCPDD		☐	XCPDD	☐	Indicator: Address and Bank Data Set Individually
44	XZEMP	VBSEGD	XZEMP		☐	XZEMP	☐	Indicator: Alternative payee in document allowed ?
45	HKONT	VBSEGD	HKONT		☐	HKONT	☐	General Ledger Account
46	KUNNR	VBSEGD	KUNNR		☐	KUNNR	☐	Customer Number
47	FILKD	VBSEGD	FILKD		☐	FILKD	☐	Account Number of the Branch
48	HZUON	VBSEGD	HZUON		☐	HZUON	☐	Assignment Number for Special G/L Accounts
49	ZFBDT	VBSEGD	ZFBDT		☐	DZFBDT	☐	Baseline date for due date calculation
50	ZTERM	VBSEGD	ZTERM		☐	DZTERM	☐	Terms of payment key
51	ZBD1T	VBSEGD	ZBD1T		☐	DZBD1T	☐	Cash discount days 1
52	ZBD2T	VBSEGD	ZBD2T		☐	DZBD2T	☐	Cash discount days 2
53	ZBD3T	VBSEGD	ZBD3T		☐	DZBD3T	☐	Net Payment Terms Period
54	ZBD1P	VBSEGD	ZBD1P		☐	DZBD1P	☐	Cash discount percentage 1
55	ZBD2P	VBSEGD	ZBD2P		☐	DZBD2P	☐	Cash Discount Percentage 2
56	XSKFB	VBSEGD	XSKFB		☐	XSKFB	☐	Indicator: Calculate amounts qualifying for cash discount ?
57	SKFBT	VBSEGD	SKFBT		☐	SKFBT	☐	Amount Eligible for Cash Discount in Document Currency
58	SKNTO	VBSEGD	SKNTO		☐	SKNTO	☐	Cash discount amount in local currency
59	WSKTO	VBSEGD	WSKTO		☐	WSKTO	☐	Cash Discount Amount in Document Currency
60	ZLSCH	VBSEGD	ZLSCH		☐	SCHZW_BSEG	☐	Payment Method
61	ZLSPR	VBSEGD	ZLSPR		☐	DZLSPR	☐	Payment Block Key
62	UZAWE	VBSEGD	UZAWE		☐	UZAWE	☐	Payment method supplement
63	HBKID	VBSEGD	HBKID		☐	HBKID	☐	Short key for a house bank
64	BVTYP	VBSEGD	BVTYP		☐	BVTYP	☐	Partner bank type
65	REBZG	VBSEGD	REBZG		☐	REBZG	☐	Number of the Invoice the Transaction Belongs to
66	REBZJ	VBSEGD	REBZJ		☐	REBZJ	☐	Fiscal Year of the Relevant Invoice (for Credit Memo)
67	REBZZ	VBSEGD	REBZZ		☐	REBZZ	☐	Line Item in the Relevant Invoice
68	REBZT	VBSEGD	REBZT		☐	REBZT	☐	Follow-On Document Type
69	LZBKZ	VBSEGD	LZBKZ		☐	LZBKZ	☐	State central bank indicator
70	LANDL	VBSEGD	LANDL		☐	LANDL	☐	Supplying Country
71	DIEKZ	VBSEGD	DIEKZ		☐	DIEKZ	☐	Service indicator (foreign payment)
72	VRSKZ	VBSEGD	VRSKZ		☐	VRSKZ	☐	Insurance Indicator
73	VRSDT	VBSEGD	VRSDT		☐	VRSDT	☐	Insurance Date
74	BLNBT	VBSEGD	BLNBT		☐	BLNBT	☐	Base Amount for Determining the Preference Amount
75	BLNKZ	VBSEGD	BLNKZ		☐	BLNKZ	☐	Subsidy Indicator for Determining the Reduction Rates
76	BLNPZ	VBSEGD	BLNPZ		☐	BLNPZ	☐	Preference Percentage Rate
77	MSCHL	VBSEGD	MSCHL		☐	MSCHL	☐	Dunning key
78	MANSP	VBSEGD	MANSP		☐	MANSP	☐	Dunning block
79	MABER	VBSEGD	MABER		☐	MABER	☐	Dunning Area
80	STCEG	VBSEGD	STCEG		☐	STCEG	☐	VAT Registration Number
81	XHKOM	VBSEGD	XHKOM		☐	XHKOM	☐	Indicator: G/L Account Assigned Manually?
82	VERTT	VBSEGD	VERTT		☐	RANTYP	☐	Contract Type
83	VERTN	VBSEGD	VERTN		☐	RANL	☐	Contract Number
84	VBEWA	VBSEGD	VBEWA		☐	SBEWART	☐	Flow Type
85	XEGDR	VBSEGD	XEGDR		☐	XEGDR	☐	Indicator: Triangular deal within the EU ?
86	FIPOS	VBSEGD	FIPOS		☐	FIPOS	☐	Commitment Item
87	SWAER	VBSEGD	SWAER		☐	WAERS	☐	Currency Key
88	MADAT	VBSEGD	MADAT		☐	MADAT	☐	Date of Last Dunning Notice
89	MANST	VBSEGD	MANST		☐	MAHNS_D	☐	Dunning Level
90	SAMNR	VBSEGD	SAMNR		☐	SAMNR	☐	Invoice List Number
91	ANFBN	VBSEGD	ANFBN		☐	ANFBN	☐	Document Number of the Bill of Exchange Payment Request
92	ANFBJ	VBSEGD	ANFBJ		☐	ANFBJ	☐	Fiscal Year of the Bill of Exchange Payment Request Document
93	ANFBU	VBSEGD	ANFBU		☐	ANFBU	☐	Company Code in Which Bill of Exch.Payment Request Is Posted
94	ANFAE	VBSEGD	ANFAE		☐	ANFAE	☐	Bill of Exchange Payment Request Due Date
95	EGMLD	VBSEGD	EGMLD		☐	EGMLD_BSEZ	☐	Reporting Country for Delivery of Goods within the EU
96	XEGMD	VBSEGD	XEGMD		☐	XEGMD	☐	EC reporting country deleted
97	XREF1	VBSEGD	XREF1		☐	XREF1	☐	Business partner reference key
98	XREF2	VBSEGD	XREF2		☐	XREF2	☐	Business partner reference key
99	XREF3	VBSEGD	XREF3		☐	XREF3	☐	Reference key for line item
100	XZANF	VBSEGD	XZANF		☐	XZANF	☐	Indicator: Payment demand
101	XFDIS	VBSEGD	XFDIS		☐	XFDIS	☐	Indicator: Cash Management activated?
102	KKBER	VBSEGD	KKBER		☐	KKBER	☐	Credit control area
103	RSTGR	VBSEGD	RSTGR		☐	RSTGR	☐	Reason Code for Payments
104	EMPFB	VBSEGD	EMPFB		☐	EMPFB	☐	Payee/Payer
105	BSTAT	VBKPF	BSTAT		☐	BSTAT_D	☐	Document Status
106	BLART	VBKPF	BLART		☐	BLART	☐	Document type
107	BLDAT	VBKPF	BLDAT		☐	BLDAT	☐	Document Date in Document
108	BUDAT	VBKPF	BUDAT		☐	BUDAT	☐	Posting Date in the Document
109	MONAT	VBKPF	MONAT		☐	MONAT	☐	Fiscal period
110	WWERT	VBKPF	WWERT		☐	WWERT_D	☐	Translation date
111	CPUDT	VBKPF	CPUDT		☐	CPUDT	☐	Accounting document entry date
112	CPUTM	VBKPF	CPUTM		☐	CPUTM	☐	Time of data entry
113	AEDAT	VBKPF	AEDAT		☐	AEDT_VBKPF	☐	Date of the Last Document Change
114	UPDDT	VBKPF	UPDDT		☐	UPDDT	☐	Date of the Last Document Update
115	USNAM	VBKPF	USNAM		☐	USNM_VBKPF	☐	User Name
116	TCODE	VBKPF	TCODE		☐	TCODE	☐	Transaction Code
117	BVORG	VBKPF	BVORG		☐	BVORG	☐	Number of Cross-Company Code Posting Transaction
118	XBLNR	VBKPF	XBLNR		☐	XBLNR1	☐	Reference Document Number
119	BKTXT	VBKPF	BKTXT		☐	BKTXT	☐	Document Header Text
120	FIKRS	VBKPF	FIKRS		☐	FIKRS	☐	Financial Management Area
121	KOARS	VBKPF	KOARS		☐	KOARS_003	☐	Account Types Allowed
122	XBSET	VBKPF	XBSET		☐	XBSET	☐	Tax information exists in the document
123	XSNET	VBKPF	XSNET		☐	XSNET	☐	G/L account amounts entered exclude tax
124	XBWAE	VBKPF	XBWAE		☐	XBWAE	☐	Only transfer document in document currency when posting
125	WAERS	VBKPF	WAERS		☐	WAERS	☐	Currency Key
126	HWAER	VBKPF	HWAER		☐	HWAER	☐	Local Currency
127	HWAE2	VBKPF	HWAE2		☐	HWAE2	☐	Currency Key of Second Local Currency
128	HWAE3	VBKPF	HWAE3		☐	HWAE3	☐	Currency Key of Third Local Currency
129	KURSF	VBKPF	KURSF		☐	KURSF	☐	Exchange rate
130	KURS2	VBKPF	KURS2		☐	KURS2	☐	Exchange Rate for the Second Local Currency
131	KURS3	VBKPF	KURS3		☐	KURS3	☐	Exchange Rate for the Third Local Currency
132	BASW2	VBKPF	BASW2		☐	CURSR	☐	Source Currency for Currency Translation
133	BASW3	VBKPF	BASW3		☐	CURSR	☐	Source Currency for Currency Translation
134	UMRD2	VBKPF	UMRD2		☐	UMRD2	☐	Translation Date Type for Second Local Currency
135	UMRD3	VBKPF	UMRD3		☐	UMRD3	☐	Translation Date Type for Third Local Currency
136	CURT2	VBKPF	CURT2		☐	CURT2	☐	Currency Type of Second Local Currency
137	CURT3	VBKPF	CURT3		☐	CURT3	☐	Currency Type of Third Local Currency
138	KUTY2	VBKPF	KUTY2		☐	KURST	☐	Exchange Rate Type
139	KUTY3	VBKPF	KUTY3		☐	KURST	☐	Exchange Rate Type
140	XMWST	VBKPF	XMWST		☐	XMWST	☐	Calculate tax automatically
141	PARGB_BKPF	VBKPF	PARGB		☐	PGBVW	☐	Partner Business Area Default Value
142	VBLNR	VBKPF	VBLNR		☐	BELNR_D	☐	Accounting Document Number
143	VGJHR	VBKPF	VGJHR		☐	GJAHR	☐	Fiscal Year
144	XFRGE	VBKPF	XFRGE		☐	XFRGE	☐	Released
145	XPRFG	VBKPF	XPRFG		☐	XPRFG	☐	Document complete
146	FRATH	VBKPF	FRATH		☐	FRATH	☐	Unplanned Delivery Costs
147	XWFFR	VBKPF	XWFFR		☐	XWFFR	☐	Release necessary
148	VBUND	VBKPF	VBUND		☐	RASSC	☐	Company ID of trading partner

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	20140121
SAP Release Created in