SAP ABAP Table VBKRED (Work Structure for Release of Credit Limit)

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

Table Category	INTTAB	Structure
Structure	VBKRED	Table Relationship Diagram
Short Description	Work Structure for Release of Credit Limit

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
3	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
4	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
5	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
8	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
9	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
10	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
11	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
12	LAND	☐	LAND	LAND1	CHAR	3	0	Country of company	T005
13	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
14	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
15	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
16	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
17	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
18	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
19	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
20	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
21	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
22	CMFRE	☐	CMFRE	DATUM	DATS	8	0	Release date of the document determined by credit management
23	CMNUP	☐	CMNUP	DATUM	DATS	8	0	Date of next credit check of document
24	CMNGV	☐	CMNGV	DATUM	DATS	8	0	Next date
25	CMPRE	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
26	CMTFG	☐	CMTFG	XFELD	CHAR	1	0	ID for partial release of order item, credit block
27	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
28	CMKUA	☐	CMKUA	KURRF	DEC	9	5	Credit data exchange rate for requested delivery date
29	AMTBL	☐	AMTBL_CM	WERTV8	CURR	15	2	Released credit value of the document
30	KLPRZ	☐	KLPRZ_CM	ABPRC	NUMC	3	0	Credit limit used in %
31	KWKKB	☐	KWKKB	WERTV8	CURR	15	2	Credit value in thousands
32	KWKKC	☐	KWKKC	WERTV8	CURR	15	2	Credit value
33	KWKKD	☐	KWKKD	WERTV8	CURR	15	2	Credit value in thousands beyond the credit horizon
34	KWKKE	☐	KWKKE	WERTV8	CURR	15	2	Credit value beyond the credit horizon
35	OEIKW	☐	MC_OEIKW	WERTV10	CURR	19	2	Open sales order credit value (schedule lines)
36	OLIKW	☐	MC_OLIKW	WERTV10	CURR	19	2	Open delivery credit value
37	OFAKW	☐	MC_OFAKW	WERTV10	CURR	19	2	Open billing document credit value
38	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
39	AWAER	☐	AWAER	TEXT6	CHAR	6	0	Currency
40	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
41	CSTAT	☐	CSTAT	TEXT15	CHAR	15	0	Status field
42	CMPSA	☐	CMPSA	CMPSZ	CHAR	1	0	Status of static credit limit check
43	CMPSB	☐	CMPSB	CMPSZ	CHAR	1	0	Status of dynamic credit limit check in the credit horizon
44	CMPSC	☐	CMPSC	CMPSZ	CHAR	1	0	Status of credit check against maximum document value
45	CMPSD	☐	CMPSD	CMPSZ	CHAR	1	0	Status of credit check against terms of payment
46	CMPSE	☐	CMPSE	CMPSZ	CHAR	1	0	Status of credit check against customer review date
47	CMPSF	☐	CMPSF	CMPSZ	CHAR	1	0	Status of credit check against open items due
48	CMPSG	☐	CMPSG	CMPSZ	CHAR	1	0	Status of credit check against oldest open items
49	CMPSH	☐	CMPSH	CMPSZ	CHAR	1	0	Status of credit check against highest dunning level
50	CMPSI	☐	CMPSI	CMPSZ	CHAR	1	0	Status of credit check against financial document
51	CMPSJ	☐	CMPSJ	CMPSZ	CHAR	1	0	Status of credit check against export credit insurance
52	CMPSK	☐	CMPSK	CMPSZ	CHAR	1	0	Status of credit check against payment card authorization
53	CMPSL	☐	CMPSL	CMPSZ	CHAR	1	0	Status of credit check of reserves 4
54	CMPSM	☐	CMPSM	CMPSZ	CHAR	1	0	Credit check data is obsolete
55	CMPS0	☐	CMPS0	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 1
56	CMPS1	☐	CMPS1	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 2
57	CMPS2	☐	CMPS2	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 3
58	CMGST	☐	CMGST	CMGST	CHAR	1	0	Overall status of credit checks
59	SKFOR	☐	SKFOR	WRTV8	CURR	15	2	Total receivables (for credit limit check)
60	SSOBL	☐	SSOBL	WRTV8	CURR	15	2	Relevant special liabilities for credit limit check
61	CRBLB	☐	CRBLB_CM	XFELD	CHAR	1	0	Indicator: Blocked by credit management ?
62	NXTRV	☐	NXTRV_CM	DATUM	DATS	8	0	Next internal review
63	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
64	DBPAY	☐	DBPAY_CM	CHAR3	CHAR	3	0	Payment Index
65	DBRTG	☐	DBRTG_CM	CHAR5	CHAR	5	0	Rating
66	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
67	AEDAT	☐	AEDAT_CM	DATUM	DATS	8	0	Date of Last Change
68	AETXT	☐	AETXT_CM	DATUM	DATS	8	0	Date of Last Text Change
69	ZAEHL	☐	DZAEHL7	NUM7	NUMC	7	0	Counter with 7 Digits
70	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
71	ACTIV	☐	ACTIV	NUM02	NUMC	2	0	List Level in which the Line Item is Active
72	KLIMK	☐	KLIMK	WERT8	CURR	15	2	Customer's credit limit
73	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
74	SIZEC	☐	SIZEC_CM	SIZEC_CM	CHAR	3	0	Document value class (credit management)	T691I
75	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
76	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
77	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
78	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
79	CRMGR	☐	CRMGR_CM	CRMGR_CM	CHAR	2	0	Document credit group	T691D
80	TAGEF	☐	TAGEF_CM	ANZTA	NUMC	3	0	Credit check: Number of days without check
81	KWKKF	☐	KWKKF	WERTV8	CURR	15	2	Guaranteed value in thousands
82	KWKKG	☐	KWKKG	WERTV8	CURR	15	2	Guaranteed value
83	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
84	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
85	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
86	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
87	AUST1	☐	AUST1_CC	AUST1_CC	CHAR	1	0	Payment cards: Status regarding requirements
88	AUST2	☐	AUST2_CC	CCALL	CHAR	1	0	Payment cards: Totals status - Call external system
89	AUST3	☐	AUST3_CC	REACT_SD	CHAR	1	0	Payment cards: Overall status - Responses from ext. system
90	AUST5	☐	AUST5_CC	XFELD	CHAR	1	0	Payment cards: Authorization block
91	AUST1TXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
92	AUST2TXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
93	AUST3TXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
94	AGNAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
95	AGORT01	☐	ORT01	TEXT25	CHAR	25	0	City
96	AGADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
97	VBKLA	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
98	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
99	CMPS_CM	☐	CMPS_CM	CMPSZ	CHAR	1	0	Status of Credit Check SAP Credit Management
100	.INCLUDE	☐				0	0	Customer Reserve for VBKRED
101	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
102	CMPS_TE	☐	CMPS_TE	CMPSZ	CHAR	1	0	Status of Technical Error SAP Credit Management

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VBKRED	CMWAE	TCURC	WAERS
2	VBKRED	CRMGR	T691D	CRMGR_CM		C	CN
3	VBKRED	CTLPC	T691A	CTLPC
4	VBKRED	GRUPP	T691B	GRUPP		C	CN
5	VBKRED	KKBER	T014	KKBER
6	VBKRED	KNKLI	KNA1	KUNNR
7	VBKRED	LAND	T005	LAND1
8	VBKRED	LCNUM	AKKP	LCNUM	REF	C	CN
9	VBKRED	MANDT	T000	MANDT
10	VBKRED	POSNR	VBUP	POSNR
11	VBKRED	SBGRP	T024B	SBGRP
12	VBKRED	SIZEC	T691I	SIZEC
13	VBKRED	SPART	TSPA	SPART
14	VBKRED	VBELN	VBUK	VBELN
15	VBKRED	VKORG	TVKO	VKORG
16	VBKRED	VTWEG	TVTW	VTWEG
17	VBKRED	WAERK	TCURC	WAERS		C	CN
18	VBKRED	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in