1. Home
  2. Resources
  3. SAP Tables
  4. VBKRED - Work Structure for Release of Credit Limit

SAP Table VBKRED

Work Structure for Release of Credit Limit

VBKRED (Work Structure for Release of Credit Limit) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBKRED to other SAP tables.

VBKRED table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
KKBER Credit control area KKBER T014 CHAR 4 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
KNKLI Customer's account number with credit limit reference KNKLI KNA1 CHAR 10 0
NAME1 Name NAME1 CHAR 30 0
ORT01 City ORT01 CHAR 25 0
LAND Country of company LAND T005 CHAR 3 0
ADRNR Address ADRNR CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
BNAME Name of orderer BNAME_V CHAR 35 0
TELF1 First telephone number TELF1 CHAR 16 0
GRUPP Customer Credit Group GRUPP_CM T691B CHAR 4 0
SBGRP Credit representative group for credit management SBGRP_CM T024B CHAR 3 0
CTLPC Credit management: Risk category CTLPC_CM T691A CHAR 3 0
CMWAE Currency key of credit control area WAERS_CM TCURC CUKY 5 0
CMFRE Release date of the document determined by credit management CMFRE DATS 8 0
CMNUP Date of next credit check of document CMNUP DATS 8 0
CMNGV Next date CMNGV DATS 8 0
CMPRE Item credit price CMPRE_FLT FLTP 16 16
CMTFG ID for partial release of order item, credit block CMTFG CHAR 1 0
X Yes
NULL No
CMPNT ID: Item with active credit function / relevant for credit CMPNT CHAR 1 0
X Yes
NULL No
CMKUA Credit data exchange rate for requested delivery date CMKUA DEC 9 5
AMTBL Released credit value of the document AMTBL_CM CURR 15 2
KLPRZ Credit limit used in % KLPRZ_CM NUMC 3 0
KWKKB Credit value in thousands KWKKB CURR 15 2
KWKKC Credit value KWKKC CURR 15 2
KWKKD Credit value in thousands beyond the credit horizon KWKKD CURR 15 2
KWKKE Credit value beyond the credit horizon KWKKE CURR 15 2
OEIKW Open sales order credit value (schedule lines) MC_OEIKW CURR 19 2
OLIKW Open delivery credit value MC_OLIKW CURR 19 2
OFAKW Open billing document credit value MC_OFAKW CURR 19 2
WAERS Currency Key WAERS TCURC CUKY 5 0
AWAER Currency AWAER CHAR 6 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
CSTAT Status field CSTAT CHAR 15 0
CMPSA Status of static credit limit check CMPSA CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSB Status of dynamic credit limit check in the credit horizon CMPSB CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSC Status of credit check against maximum document value CMPSC CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSD Status of credit check against terms of payment CMPSD CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSE Status of credit check against customer review date CMPSE CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSF Status of credit check against open items due CMPSF CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSG Status of credit check against oldest open items CMPSG CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSH Status of credit check against highest dunning level CMPSH CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSI Status of credit check against financial document CMPSI CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSJ Status of credit check against export credit insurance CMPSJ CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSK Status of credit check against payment card authorization CMPSK CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSL Status of credit check of reserves 4 CMPSL CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSM Credit check data is obsolete CMPSM CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS0 Status of credit check for customer reserve 1 CMPS0 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS1 Status of credit check for customer reserve 2 CMPS1 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS2 Status of credit check for customer reserve 3 CMPS2 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMGST Overall status of credit checks CMGST CHAR 1 0
NULL Credit check was not executed/Status not set
A Credit check was executed, document OK
B Credit check was executed, document not OK
C Credit check was executed, document not OK, partial release
D Document released by credit representative
SKFOR Total receivables (for credit limit check) SKFOR CURR 15 2
SSOBL Relevant special liabilities for credit limit check SSOBL CURR 15 2
CRBLB Indicator: Blocked by credit management ? CRBLB_CM CHAR 1 0
X Yes
NULL No
NXTRV Next internal review NXTRV_CM DATS 8 0
KRAUS Credit information number KRAUS_CM CHAR 11 0
DBPAY Payment Index DBPAY_CM CHAR 3 0
DBRTG Rating DBRTG_CM CHAR 5 0
REVDB Last review (external) REVDB_CM DATS 8 0
AEDAT Date of Last Change AEDAT_CM DATS 8 0
AETXT Date of Last Text Change AETXT_CM DATS 8 0
ZAEHL Counter with 7 Digits DZAEHL7 NUMC 7 0
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
ACTIV List Level in which the Line Item is Active ACTIV NUMC 2 0
KLIMK Customer's credit limit KLIMK CURR 15 2
BSTNK Customer purchase order number BSTNK CHAR 20 0
SIZEC Document value class (credit management) SIZEC_CM T691I CHAR 3 0
GBSTK Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WBSTK Total goods movement status WBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WAERK SD Document Currency WAERK TCURC CUKY 5 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
CRMGR Document credit group CRMGR_CM T691D CHAR 2 0
TAGEF Credit check: Number of days without check TAGEF_CM NUMC 3 0
KWKKF Guaranteed value in thousands KWKKF CURR 15 2
KWKKG Guaranteed value KWKKG CURR 15 2
LCNUM Financial doc. processing: Internal financial doc. number LCNUM AKKP CHAR 10 0
KUNAG Sold-to party KUNAG CHAR 10 0
VKBUR Sales Office VKBUR CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
AUST1 Payment cards: Status regarding requirements AUST1_CC CHAR 1 0
NULL Not Relevant
A Requirement not met
B Requirement met
AUST2 Payment cards: Totals status - Call external system AUST2_CC CHAR 1 0
NULL Not Relevant
A External system not reached
B External system reached: no response
C External system reached: response received
AUST3 Payment cards: Overall status - Responses from ext. system AUST3_CC CHAR 1 0
NULL Not Relevant
A Checks successful
B Unsuccessful: authorize later
C Unsuccessful: set authorization lock
AUST5 Payment cards: Authorization block AUST5_CC CHAR 1 0
X Yes
NULL No
AUST1TXT Description BEZEI40 CHAR 40 0
AUST2TXT Description BEZEI40 CHAR 40 0
AUST3TXT Description BEZEI40 CHAR 40 0
AGNAME1 Name NAME1 CHAR 30 0
AGORT01 City ORT01 CHAR 25 0
AGADRNR Address ADRNR CHAR 10 0
VBKLA Original system with release and transaction control VBKLA CHAR 9 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
CMPS_CM Status of Credit Check SAP Credit Management CMPS_CM CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
CMPS_TE Status of Technical Error SAP Credit Management CMPS_TE CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative

VBKRED foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBKRED CMWAE VBKRED MANDT TCURC Currency Codes MANDT
VBKRED CMWAE VBKRED CMWAE TCURC Currency Codes WAERS
VBKRED CRMGR VBKRED MANDT T691D Credit groups for document types MANDT
VBKRED CRMGR VBKRED CRMGR T691D Credit groups for document types CRMGR_CM
VBKRED CTLPC VBKRED MANDT T691A Credit management risk categories MANDT
VBKRED CTLPC VBKRED CTLPC T691A Credit management risk categories CTLPC
VBKRED CTLPC VBKRED KKBER T691A Credit management risk categories KKBER
VBKRED GRUPP VBKRED GRUPP T691B "Credit Management Groups" GRUPP
VBKRED GRUPP VBKRED KKBER T691B "Credit Management Groups" KKBER
VBKRED GRUPP VBKRED MANDT T691B "Credit Management Groups" MANDT
VBKRED KKBER VBKRED MANDT T014 Credit control areas MANDT
VBKRED KKBER VBKRED KKBER T014 Credit control areas KKBER
VBKRED KNKLI VBKRED MANDT KNA1 General Data in Customer Master MANDT
VBKRED KNKLI VBKRED KNKLI KNA1 General Data in Customer Master KUNNR
VBKRED LAND VBKRED LAND T005 Countries LAND1
VBKRED LAND VBKRED MANDT T005 Countries MANDT
VBKRED LCNUM VBKRED MANDT AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data MANDT
VBKRED LCNUM VBKRED LCNUM AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data LCNUM
VBKRED MANDT VBKRED MANDT T000 Clients MANDT
VBKRED POSNR VBKRED POSNR VBUP Sales Document: Item Status POSNR
VBKRED POSNR VBKRED MANDT VBUP Sales Document: Item Status MANDT
VBKRED POSNR VBKRED VBELN VBUP Sales Document: Item Status VBELN
VBKRED SBGRP VBKRED KKBER T024B Credit management: Credit representative groups KKBER
VBKRED SBGRP VBKRED MANDT T024B Credit management: Credit representative groups MANDT
VBKRED SBGRP VBKRED SBGRP T024B Credit management: Credit representative groups SBGRP
VBKRED SIZEC VBKRED MANDT T691I Document Value Class for Credit Management MANDT
VBKRED SIZEC VBKRED SIZEC T691I Document Value Class for Credit Management SIZEC
VBKRED SPART VBKRED MANDT TSPA Organizational Unit: Sales Divisions MANDT
VBKRED SPART VBKRED SPART TSPA Organizational Unit: Sales Divisions SPART
VBKRED VBELN VBKRED MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBKRED VBELN VBKRED VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBKRED VKORG VBKRED MANDT TVKO Organizational Unit: Sales Organizations MANDT
VBKRED VKORG VBKRED VKORG TVKO Organizational Unit: Sales Organizations VKORG
VBKRED VTWEG VBKRED MANDT TVTW Organizational Unit: Distribution Channels MANDT
VBKRED VTWEG VBKRED VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
VBKRED WAERK VBKRED MANDT TCURC Currency Codes MANDT
VBKRED WAERK VBKRED WAERK TCURC Currency Codes WAERS
VBKRED WAERS VBKRED WAERS TCURC Currency Codes WAERS
VBKRED WAERS VBKRED MANDT TCURC Currency Codes MANDT