SAP ABAP View V_CM09_OPT (Selection VBAK, VBUK, VBKD)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VKM (Package) Application development R/3 credit management

Basic Data

View Type	D	Database View
Database View	V_CM09_OPT
Short Description	Selection VBAK, VBUK, VBKD
Root table	VBAK	Sales Document: Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBAK	VBAK
2	VBKD
3	VBUK

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBUK	MANDT	JL	EQ				0	0
2	VBAK	MANDT	JR	EQ			AND	0	0
3	VBUK	VBELN	JL	EQ				0	0
4	VBAK	VBELN	JR	EQ			AND	0	0
5	VBAK	MANDT	JL	EQ				0	0
6	VBKD	MANDT	JR	EQ			AND	0	0
7	VBAK	VBELN	JL	EQ				0	0
8	VBKD	VBELN	JR	EQ			AND	0	0
9	VBKD	POSNR		EQ	'000000'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VBAK	MANDT		☐	MANDT	☐	Client
2	GBSTK	VBUK	GBSTK		☐	GBSTK	☐	Overall processing status of document
3	CMGST	VBUK	CMGST		☐	CMGST	☐	Overall status of credit checks
4	VBOBJ	VBUK	VBOBJ		☐	VBOBJ	☐	SD document object
5	VBELN	VBAK	VBELN		☐	VBELN_VA	☐	Sales Document
6	ERNAM	VBAK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
7	VKORG	VBAK	VKORG		☐	VKORG	☐	Sales Organization
8	VTWEG	VBAK	VTWEG		☐	VTWEG	☐	Distribution Channel
9	SPART	VBAK	SPART		☐	SPART	☐	Division
10	VKGRP	VBAK	VKGRP		☐	VKGRP	☐	Sales group
11	VKBUR	VBAK	VKBUR		☐	VKBUR	☐	Sales office
12	KKBER	VBAK	KKBER		☐	KKBER	☐	Credit control area
13	KNKLI	VBAK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
14	GRUPP	VBAK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
15	SBGRP	VBAK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
16	CTLPC	VBAK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
17	CMNUP	VBAK	CMNUP		☐	CMNUP	☐	Date of next credit check of document
18	CMNGV	VBAK	CMNGV		☐	CMNGV	☐	Next date
19	RPLNR	VBAK	RPLNR		☐	RPLNR	☐	Installment Plan Number
20	POSNR	VBKD	POSNR		☐	POSNR	☐	Item number of the SD document
21	KONDA	VBKD	KONDA		☐	KONDA	☐	Price Group (Customer)
22	KDGRP	VBKD	KDGRP		☐	KDGRP	☐	Customer group
23	BZIRK	VBKD	BZIRK		☐	BZIRK	☐	Sales district
24	PLTYP	VBKD	PLTYP		☐	PLTYP	☐	Price list type
25	INCO1	VBKD	INCO1		☐	INCO1	☐	Incoterms (part 1)
26	INCO2	VBKD	INCO2		☐	INCO2	☐	Incoterms (part 2)
27	KZAZU	VBKD	KZAZU		☐	KZAZU_D	☐	Order combination indicator
28	PERFK	VBKD	PERFK		☐	PERFK	☐	Invoice dates (calendar identification)
29	PERRL	VBKD	PERRL		☐	PERRL	☐	Invoice list schedule (calendar identification)
30	MRNKZ	VBKD	MRNKZ		☐	MRNKZ	☐	Manual invoice maintenance
31	KURRF	VBKD	KURRF		☐	KURRF	☐	Exchange rate for FI postings
32	VALTG	VBKD	VALTG		☐	VALTG	☐	Additional value days
33	VALDT	VBKD	VALDT		☐	VALDT	☐	Fixed value date
34	ZTERM	VBKD	ZTERM		☐	DZTERM	☐	Terms of payment key
35	ZLSCH	VBKD	ZLSCH		☐	SCHZW_BSEG	☐	Payment Method
36	KTGRD	VBKD	KTGRD		☐	KTGRD	☐	Account assignment group for this customer
37	KURSK	VBKD	KURSK		☐	KURSK	☐	Exchange Rate for Pricing and Statistics
38	PRSDT	VBKD	PRSDT		☐	PRSDT	☐	Date for pricing and exchange rate
39	FKDAT	VBKD	FKDAT		☐	FKDAT	☐	Billing date for billing index and printout
40	FBUDA	VBKD	FBUDA		☐	FBUDA	☐	Date When Services Rendered
41	GJAHR	VBKD	GJAHR		☐	GJAHR	☐	Fiscal Year
42	POPER	VBKD	POPER		☐	POPER	☐	Posting period
43	STCUR	VBKD	STCUR		☐	STCUR	☐	Exchange rate for statistics
44	MSCHL	VBKD	MSCHL		☐	MSCHL	☐	Dunning key
45	MANSP	VBKD	MANSP		☐	MANSP	☐	Dunning block
46	FPLNR	VBKD	FPLNR		☐	FPLNR	☐	Billing plan number / invoicing plan number
47	WAKTION	VBKD	WAKTION		☐	WAKTION	☐	Promotion
48	ABSSC	VBKD	ABSSC		☐	ABSSCHE_CM	☐	Payment Guarantee Procedure
49	LCNUM	VBKD	LCNUM		☐	LCNUM	☐	Financial doc. processing: Internal financial doc. number
50	J_1AFITP	VBKD	J_1AFITP		☐	J_1AFITP_D	☐	Tax type
51	J_1ARFZ	VBKD	J_1ARFZ		☐	J_1ARFZVAT	☐	Reason for zero VAT
52	J_1AREGIO	VBKD	J_1AREGIO		☐	REGIO	☐	Region (State, Province, County)
53	J_1AGICD	VBKD	J_1AGICD		☐	J_1AGICD_D	☐	Activity Code for Gross Income Tax
54	J_1ADTYP	VBKD	J_1ADTYP		☐	J_1ADTYP_D	☐	Distribution Type for Employment Tax
55	J_1ATXREL	VBKD	J_1ATXREL		☐	J_1ATXREL_	☐	Tax relevant classification
56	ABTNR	VBKD	ABTNR		☐	ABTNR	☐	Department number
57	EMPST	VBKD	EMPST		☐	EMPST	☐	Receiving point
58	BSTKD	VBKD	BSTKD		☐	BSTKD	☐	Customer purchase order number
59	BSTDK	VBKD	BSTDK		☐	BSTDK	☐	Customer purchase order date
60	BSARK	VBKD	BSARK		☐	BSARK	☐	Customer Order Type
61	IHREZ	VBKD	IHREZ		☐	IHREZ	☐	Your Reference
62	BSTKD_E	VBKD	BSTKD_E		☐	BSTKD_E	☐	Ship-to Party's Purchase Order Number
63	BSTDK_E	VBKD	BSTDK_E		☐	BSTDK_E	☐	Ship-to party's PO date
64	BSARK_E	VBKD	BSARK_E		☐	BSARK_E	☐	Ship-to party purchase order type
65	IHREZ_E	VBKD	IHREZ_E		☐	IHREZ_E	☐	Ship-to party character
66	POSEX_E	VBKD	POSEX_E		☐	POSEX_E	☐	Item Number of the Underlying Purchase Order
67	KURSK_DAT	VBKD	KURSK_DAT		☐	WWERT_D	☐	Translation date
68	KURRF_DAT	VBKD	KURRF_DAT		☐	WWERT_D	☐	Translation date
69	KDKG1	VBKD	KDKG1		☐	KDKG1	☐	Customer condition group 1
70	KDKG2	VBKD	KDKG2		☐	KDKG2	☐	Customer condition group 2
71	KDKG3	VBKD	KDKG3		☐	KDKG3	☐	Customer condition group 3
72	KDKG4	VBKD	KDKG4		☐	KDKG4	☐	Customer condition group 4
73	KDKG5	VBKD	KDKG5		☐	KDKG5	☐	Customer condition group 5
74	WKWAE	VBKD	WKWAE		☐	WKWAE	☐	Value contract currency
75	WKKUR	VBKD	WKKUR		☐	WKKUR	☐	Exchange rate in value contract currency
76	AKWAE	VBKD	AKWAE		☐	AKWAE	☐	Currency key for letter-of-credit procg in foreign trade
77	AKKUR	VBKD	AKKUR		☐	AKKUR	☐	Exchange rate for letter-of-credit procg in foreign trade
78	AKPRZ	VBKD	AKPRZ		☐	AKPRZ	☐	Depreciation percentage for financial document processing
79	J_1AINDXP	VBKD	J_1AINDXP		☐	J_1AINDXP	☐	Inflation Index
80	J_1AIDATEP	VBKD	J_1AIDATEP		☐	J_1AIDATES	☐	Indexing base date
81	BSTKD_M	VBKD	BSTKD_M		☐	BSTKD_M	☐	Customer PO number as matchcode field
82	DELCO	VBKD	DELCO		☐	DELCO	☐	Agreed delivery time
83	FFPRF	VBKD	FFPRF		☐	AD01PROFNR	☐	Dynamic Item Processor Profile
84	BEMOT	VBKD	BEMOT		☐	BEMOT	☐	Accounting Indicator
85	FAKTF	VBKD	FAKTF		☐	FAKTF	☐	Billing Form
86	RRREL	VBKD	RRREL		☐	RR_RELTYP	☐	Revenue recognition category
87	ACDATV	VBKD	ACDATV		☐	RR_ACDATV	☐	Proposed start date for accrual period
88	VSART	VBKD	VSART		☐	VSARTTR	☐	Shipping type
89	TRATY	VBKD	TRATY		☐	TRATY	☐	Means-of-Transport Type
90	TRMTYP	VBKD	TRMTYP		☐	TRMTYP	☐	Means of Transportation
91	SDABW	VBKD	SDABW		☐	SDABW	☐	Special Processing Indicator
92	WMINR	VBKD	WMINR		☐	WMINR	☐	Product catalog number
93	FKBER	VBKD	FKBER		☐	FKBER	☐	Functional Area
94	PODKZ	VBKD	PODKZ		☐	PODKZ	☐	Relevant for POD processing
95	CAMPAIGN	VBKD	CAMPAIGN		☐	CGPL_GUID16_R3	☐	Generic project planning: GUID from external R/3 system
96	VKONT	VBKD	VKONT		☐	CORR_VKONT_KK	☐	Contract Account Number
97	DPBP_REF_FPLNR	VBKD	DPBP_REF_FPLNR		☐	FPLNR	☐	Billing plan number / invoicing plan number
98	DPBP_REF_FPLTR	VBKD	DPBP_REF_FPLTR		☐	FPLTR	☐	Item for billing plan/invoice plan/payment cards
99	REVSP	VBKD	REVSP		☐	RR_REVSP	☐	Revenue Distribution Type
100	REVEVTYP	VBKD	REVEVTYP		☐	RR_REVEVTYP_CUST	☐	Revenue Event Type (Customizing)
101	VTREF	VBKD	VTREF		☐	CORR_VTREF_KK	☐	Reference Specifications from Contract
102	PEROP_BEG	VBKD	PEROP_BEG		☐	FM_PEROP_SD_LOW	☐	Period of Performance Start Date
103	PEROP_END	VBKD	PEROP_END		☐	FM_PEROP_SD_HIGH	☐	Period of Performance End Date
104	STCODE	VBKD	STCODE		☐	J_1ISTCODE	☐	LST CST applicability code
105	FORMC1	VBKD	FORMC1		☐	J_1IFORTYP	☐	Form Type
106	FORMC2	VBKD	FORMC2		☐	J_1IFORTYP	☐	Form Type
107	STEUC	VBKD	STEUC		☐	STEUC	☐	Control code for consumption taxes in foreign trade
108	COMPREAS	VBKD	COMPREAS		☐	CMP_COMPREAS_COPY	☐	Abbreviation for Complaints Reason

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	616