SAP VBKRED Work Structure for Release of Credit Limit Table data and field list

VBKRED is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Work Structure for Release of Credit Limit" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VBKRED TYPE VBKRED.

The VBKRED table consists of various fields, each holding specific information or linking keys about Work Structure for Release of Credit Limit data available in SAP. These include KKBER (Credit control area), VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), VBTYP (SD document category)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VBKRED structure Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP VBKRED structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VBKRED table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
KKBER	Credit control area	KKBER	CHAR	4	T014		KKBER	KKB
VBELN	Sales and Distribution Document Number	VBELN	CHAR	10	VBUK	ALPHA	VBELN	AUN
POSNR	Item number of the SD document	POSNR	NUMC	6	VBUP		POSNR
VBTYP	SD document category	VBTYP	CHAR	1			VBTYP
VKORG	Sales Organization	VKORG	CHAR	4	TVKO		VKORG	VKO	C_VKORG
VTWEG	Distribution Channel	VTWEG	CHAR	2	TVTW		VTWEG	VTW	C_VTWEG
SPART	Division	SPART	CHAR	2	TSPA		SPART	SPA	C_SPART
KNKLI	Customer's account number with credit limit reference	KNKLI	CHAR	10	KNA1	ALPHA	KUNNR
NAME1	Name	NAME1	CHAR	30			TEXT30
ORT01	City	ORT01	CHAR	25			TEXT25
LAND	Country of company	LAND	CHAR	3	T005		LAND1
ADRNR	Address	ADRNR	CHAR	10	Assigned to domain	ALPHA	ADRNR
ERDAT	Date on Which Record Was Created	ERDAT	DATS	8			DATUM
ERNAM	Name of Person who Created the Object	ERNAM	CHAR	12			USNAM
BNAME	Name of orderer	BNAME_V	CHAR	35			NAME
TELF1	First telephone number	TELF1	CHAR	16			TEXT16
GRUPP	Customer Credit Group	GRUPP_CM	CHAR	4	T691B		GRUPP_CM
SBGRP	Credit representative group for credit management	SBGRP_CM	CHAR	3	T024B		SBGRP_CM	KBG
CTLPC	Credit management: Risk category	CTLPC_CM	CHAR	3	T691A		CTLPC_CM
CMWAE	Currency key of credit control area	WAERS_CM	CUKY	5	TCURC		WAERS
CMFRE	Release date of the document determined by credit management	CMFRE	DATS	8			DATUM
CMNUP	Date of next credit check of document	CMNUP	DATS	8			DATUM
CMNGV	Next date	CMNGV	DATS	8			DATUM
CMPRE	Item credit price	CMPRE_FLT	FLTP	16(16)			FLTP
CMTFG	ID for partial release of order item, credit block	CMTFG	CHAR	1			XFELD
CMPNT	ID: Item with active credit function / relevant for credit	CMPNT	CHAR	1			XFELD
CMKUA	Credit data exchange rate for requested delivery date	CMKUA	DEC	9(5)			KURRF
AMTBL	Released credit value of the document	AMTBL_CM	CURR	15(2)			WERTV8
KLPRZ	Credit limit used in %	KLPRZ_CM	NUMC	3			ABPRC
KWKKB	Credit value in thousands	KWKKB	CURR	15(2)			WERTV8
KWKKC	Credit value	KWKKC	CURR	15(2)			WERTV8
KWKKD	Credit value in thousands beyond the credit horizon	KWKKD	CURR	15(2)			WERTV8
KWKKE	Credit value beyond the credit horizon	KWKKE	CURR	15(2)			WERTV8
OEIKW	Open sales order credit value (schedule lines)	MC_OEIKW	CURR	19(2)			WERTV10
OLIKW	Open delivery credit value	MC_OLIKW	CURR	19(2)			WERTV10
OFAKW	Open billing document credit value	MC_OFAKW	CURR	19(2)			WERTV10
WAERS	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
AWAER	Currency	AWAER	CHAR	6			TEXT6	FWS
ZTERM	Terms of Payment Key	DZTERM	CHAR	4			ZTERM
CSTAT	Status field	CSTAT	CHAR	15			TEXT15
CMPSA	Status of static credit limit check	CMPSA	CHAR	1			CMPSZ
CMPSB	Status of dynamic credit limit check in the credit horizon	CMPSB	CHAR	1			CMPSZ
CMPSC	Status of credit check against maximum document value	CMPSC	CHAR	1			CMPSZ
CMPSD	Status of credit check against terms of payment	CMPSD	CHAR	1			CMPSZ
CMPSE	Status of credit check against customer review date	CMPSE	CHAR	1			CMPSZ
CMPSF	Status of credit check against open items due	CMPSF	CHAR	1			CMPSZ
CMPSG	Status of credit check against oldest open items	CMPSG	CHAR	1			CMPSZ
CMPSH	Status of credit check against highest dunning level	CMPSH	CHAR	1			CMPSZ
CMPSI	Status of credit check against financial document	CMPSI	CHAR	1			CMPSZ
CMPSJ	Status of credit check against export credit insurance	CMPSJ	CHAR	1			CMPSZ
CMPSK	Status of credit check against payment card authorization	CMPSK	CHAR	1			CMPSZ
CMPSL	Status of credit check of reserves 4	CMPSL	CHAR	1			CMPSZ
CMPSM	Credit check data is obsolete	CMPSM	CHAR	1			CMPSZ
CMPS0	Status of credit check for customer reserve 1	CMPS0	CHAR	1			CMPSZ
CMPS1	Status of credit check for customer reserve 2	CMPS1	CHAR	1			CMPSZ
CMPS2	Status of credit check for customer reserve 3	CMPS2	CHAR	1			CMPSZ
CMGST	Overall status of credit checks	CMGST	CHAR	1			CMGST
SKFOR	Total receivables (for credit limit check)	SKFOR	CURR	15(2)			WRTV8
SSOBL	Relevant special liabilities for credit limit check	SSOBL	CURR	15(2)			WRTV8
CRBLB	Indicator: Blocked by credit management ?	CRBLB_CM	CHAR	1			XFELD
NXTRV	Next internal review	NXTRV_CM	DATS	8			DATUM
KRAUS	Credit information number	KRAUS_CM	CHAR	11			CHAR11
DBPAY	Payment Index	DBPAY_CM	CHAR	3			CHAR3
DBRTG	Rating	DBRTG_CM	CHAR	5			CHAR5
REVDB	Last review (external)	REVDB_CM	DATS	8			DATUM
AEDAT	Date of Last Change	AEDAT_CM	DATS	8			DATUM
AETXT	Date of Last Text Change	AETXT_CM	DATS	8			DATUM
ZAEHL	Counter with 7 Digits	DZAEHL7	NUMC	7			NUM7
SELKZ	Selection flag	SELKZ	CHAR	1			SELKZ
ACTIV	List Level in which the Line Item is Active	ACTIV	NUMC	2			NUM02
KLIMK	Customer's credit limit	KLIMK	CURR	15(2)			WERT8
BSTNK	Customer purchase order number	BSTNK	CHAR	20			BSTNK
SIZEC	Document value class (credit management)	SIZEC_CM	CHAR	3	T691I		SIZEC_CM
GBSTK	Overall processing status of document	GBSTK	CHAR	1			STATV
WBSTK	Total goods movement status	WBSTK	CHAR	1			STATV
WAERK	SD Document Currency	WAERK	CUKY	5	TCURC		WAERS	FWS
NETWR	Net Value of the Sales Order in Document Currency	NETWR_AK	CURR	15(2)			WERTV8
CRMGR	Document credit group	CRMGR_CM	CHAR	2	T691D		CRMGR_CM
TAGEF	Credit check: Number of days without check	TAGEF_CM	NUMC	3			ANZTA
KWKKF	Guaranteed value in thousands	KWKKF	CURR	15(2)			WERTV8
KWKKG	Guaranteed value	KWKKG	CURR	15(2)			WERTV8
LCNUM	Financial doc. processing: Internal financial doc. number	LCNUM	CHAR	10	AKKP	ALPHA	LCNUM	AKN
KUNAG	Sold-to party	KUNAG	CHAR	10	Assigned to domain	ALPHA	KUNNR	VAG
VKBUR	Sales Office	VKBUR	CHAR	4	Assigned to domain		VKBUR	VKB
VKGRP	Sales Group	VKGRP	CHAR	3	Assigned to domain		VKGRP	VKG
AUST1	Payment cards: Status regarding requirements	AUST1_CC	CHAR	1			AUST1_CC
AUST2	Payment cards: Totals status - Call external system	AUST2_CC	CHAR	1			CCALL
AUST3	Payment cards: Overall status - Responses from ext. system	AUST3_CC	CHAR	1			REACT_SD
AUST5	Payment cards: Authorization block	AUST5_CC	CHAR	1			XFELD
AUST1TXT	Description	BEZEI40	CHAR	40			TEXT40
AUST2TXT	Description	BEZEI40	CHAR	40			TEXT40
AUST3TXT	Description	BEZEI40	CHAR	40			TEXT40
AGNAME1	Name	NAME1	CHAR	30			TEXT30
AGORT01	City	ORT01	CHAR	25			TEXT25
AGADRNR	Address	ADRNR	CHAR	10	Assigned to domain	ALPHA	ADRNR
VBKLA	Original system with release and transaction control	VBKLA	CHAR	9			CHAR9
VSTEL	Shipping Point/Receiving Point	VSTEL	CHAR	4	Assigned to domain		VSTEL	VST
CMPS_CM	Status of Credit Check SAP Credit Management	CMPS_CM	CHAR	1			CMPSZ
DUMMY	Dummy function in length 1	DUMMY	CHAR	1			DUMMY
CMPS_TE	Status of Technical Error SAP Credit Management	CMPS_TE	CHAR	1			CMPSZ

Key field

Non-key field

< VBKPF_CARD - Credit Card: Append for VBKPF VBKREDET - Structure for releasing credit limit ; Detail data >

How do I retrieve data from SAP structure VBKRED using ABAP code?

As VBKRED is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VBKRED as there is no data to select.

How to access SAP table VBKRED

Within an ECC or HANA version of SAP you can also view further information about VBKRED and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to VBKRED

VBKRED - Work Structure for Release of Credit Limit
VBKREDET - Work structure for releasing credit limit: Detail