SAP table VBKRED (Work Structure for Release of Credit Limit)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KKBER Credit control area CHAR 4 0 T014 KKBER
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
KNKLI Customer's Account Number with Credit Limit Reference CHAR 10 0 KNA1 KNKLI
NAME1 Name CHAR 30 0 NAME1
ORT01 City CHAR 25 0 ORT01
LAND Company Country/Region CHAR 3 0 T005 LAND
ADRNR Address CHAR 10 0 ADRNR
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
BNAME Name of orderer CHAR 35 0 BNAME_V
TELF1 First telephone number CHAR 16 0 TELF1
GRUPP Customer Credit Group CHAR 4 0 T691B GRUPP_CM
SBGRP Credit Representative Group for Credit Management CHAR 3 0 T024B SBGRP_CM
CTLPC Credit Management: Risk Category CHAR 3 0 T691A CTLPC_CM
CMWAE Currency key of credit control area CUKY 5 0 TCURC WAERS_CM
CMFRE Release date of the document determined by credit management DATS 8 0 CMFRE
CMNUP Date of Next Credit Check of Document DATS 8 0 CMNUP
CMNGV Next date DATS 8 0 CMNGV
CMPRE Item Credit Price FLTP 16 16 CMPRE_FLT
CMTFG ID for partial release of order item, credit block CHAR 1 0 CMTFG
CMPNT ID: Item with active credit function / relevant for credit CHAR 1 0 CMPNT
CMKUA Credit data exchange rate for requested delivery date DEC 9 5 CMKUA
AMTBL Released credit value of the document CURR 15 2 AMTBL_CM
KLPRZ Credit limit used in % NUMC 3 0 KLPRZ_CM
KWKKB Credit value in thousands CURR 15 2 KWKKB
KWKKC Credit value CURR 15 2 KWKKC
KWKKD Credit value in thousands beyond the credit horizon CURR 15 2 KWKKD
KWKKE Credit value beyond the credit horizon CURR 15 2 KWKKE
OEIKW Open sales order credit value (schedule lines) CURR 19 2 MC_OEIKW
OLIKW Open delivery credit value CURR 19 2 MC_OLIKW
OFAKW Open billing document credit value CURR 19 2 MC_OFAKW
WAERS Currency Key CUKY 5 0 TCURC WAERS
AWAER Currency CHAR 6 0 AWAER
ZTERM Terms of payment key CHAR 4 0 DZTERM
CSTAT Status field CHAR 15 0 CSTAT
CMPSA Status of static credit limit check CHAR 1 0 CMPSA
CMPSB Status of dynamic credit limit check in the credit horizon CHAR 1 0 CMPSB
CMPSC Status of Credit Check Against Maximum Document Value CHAR 1 0 CMPSC
CMPSD Status of Credit Check Against Terms of Payment CHAR 1 0 CMPSD
CMPSE Status of credit check against customer review date CHAR 1 0 CMPSE
CMPSF Status of credit check against open items due CHAR 1 0 CMPSF
CMPSG Status of credit check against oldest open items CHAR 1 0 CMPSG
CMPSH Status of credit check against highest dunning level CHAR 1 0 CMPSH
CMPSI Status of Credit Check Against Financial Document CHAR 1 0 CMPSI
CMPSJ Status of Credit Check Against Export Credit Insurance CHAR 1 0 CMPSJ
CMPSK Status of Credit Check Against Payment Card Authorization CHAR 1 0 CMPSK
CMPSL Status of credit check of reserves 4 CHAR 1 0 CMPSL
CMPSM Credit check data is obsolete CHAR 1 0 CMPSM
CMPS0 Status of credit check for customer reserve 1 CHAR 1 0 CMPS0
CMPS1 Status of credit check for customer reserve 2 CHAR 1 0 CMPS1
CMPS2 Status of credit check for customer reserve 3 CHAR 1 0 CMPS2
CMGST Overall Status of Credit Checks CHAR 1 0 CMGST
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) CURR 15 2 SKFOR_CS
SSOBL Relevant Special Liabilities for Credit Limit Check CURR 15 2 SSOBL_CS
CRBLB Indicator: Blocked by Credit Management? CHAR 1 0 CRBLB_CM
NXTRV Next Review DATS 8 0 NXTRV_CM
KRAUS Credit Information Number CHAR 11 0 KRAUS_CM
DBPAY Payment Index CHAR 3 0 DBPAY_CM
DBRTG Rating CHAR 5 0 DBRTG_CM
REVDB Last External Review DATS 8 0 REVDB_CM
AEDAT Date of Last Change DATS 8 0 AEDAT_CM
AETXT Date of Last Text Change DATS 8 0 AETXT_CM
ZAEHL Counter with 7 Digits NUMC 7 0 DZAEHL7
SELKZ Selection flag CHAR 1 0 SELKZ
Not selected
* Selected and processed
X Selected but not yet processed
ACTIV List Level in Which the Line Item Is Active NUMC 2 0 ACTIV
KLIMK Customer's credit limit CURR 15 2 KLIMK_CS
BSTNK Customer Reference CHAR 20 0 BSTNK
SIZEC Document value class (credit management) CHAR 3 0 T691I SIZEC_CM
GBSTK Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
WBSTK Goods Movement Status (All Items) CHAR 1 0 WBSTK
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
NETWR Net Value of the Sales Order in Document Currency CURR 15 2 NETWR_AK
CRMGR Document credit group CHAR 2 0 T691D CRMGR_CM
TAGEF Credit check: Number of days without check NUMC 3 0 TAGEF_CM
KWKKF Guaranteed value in thousands CURR 15 2 KWKKF
KWKKG Guaranteed value CURR 15 2 KWKKG
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 LCNUM
KUNAG Sold-to Party CHAR 10 0 KUNAG
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
VKGRP Sales group CHAR 3 0 TVKGR VKGRP
AUST1 Payment Cards: Status Regarding Requirements CHAR 1 0 AUST1_CC
Not Relevant
A Requirement not met
B Requirement met
AUST2 Payment Cards: Totals Status - Call External System CHAR 1 0 AUST2_CC
AUST3 Payment cards: Overall status - Responses from ext. system CHAR 1 0 AUST3_CC
AUST5 Payment Cards: Authorization Block CHAR 1 0 AUST5_CC
AUST1TXT Description CHAR 40 0 BEZEI40
AUST2TXT Description CHAR 40 0 BEZEI40
AUST3TXT Description CHAR 40 0 BEZEI40
AGNAME1 Name CHAR 30 0 NAME1
AGORT01 City CHAR 25 0 ORT01
AGADRNR Address CHAR 10 0 ADRNR
VBKLA Original system with release and transaction control CHAR 9 0 VBKLA
VSTEL Shipping Point / Receiving Point CHAR 4 0 VSTEL
CMPS_CM Status of Credit Check SAP Credit Management CHAR 1 0 CMPS_CM
DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
CMPS_TE Status of Technical Error SAP Credit Management CHAR 1 0 CMPS_TE

VBKRED foreign key relationships

Table Field Check Table Check Field
0 VBKRED CMWAE TCURC Currency Codes MANDT
0 VBKRED CMWAE TCURC Currency Codes WAERS
1 VBKRED CRMGR T691D Credit groups for document types MANDT
0 VBKRED CTLPC T691A Credit management risk categories CTLPC
0 VBKRED CTLPC T691A Credit management risk categories KKBER
1 VBKRED GRUPP T691B "Credit Management Groups" GRUPP
1 VBKRED GRUPP T691B "Credit Management Groups" KKBER
0 VBKRED KKBER T014 Credit control areas KKBER
1 VBKRED KNKLI KNA1 General Data in Customer Master MANDT
1 VBKRED KNKLI KNA1 General Data in Customer Master KUNNR
0 VBKRED LAND T005 Countries MANDT
0 VBKRED LAND T005 Countries LAND1
1 VBKRED MANDT T000 Clients MANDT
0 VBKRED SBGRP T024B Credit management: Credit representative groups MANDT
0 VBKRED SBGRP T024B Credit management: Credit representative groups KKBER
1 VBKRED SPART TSPA Organizational Unit: Sales Divisions MANDT
1 VBKRED SPART TSPA Organizational Unit: Sales Divisions SPART
0 VBKRED VKBUR TVBUR Organizational Unit: Sales Offices MANDT
1 VBKRED VKGRP TVKGR Organizational Unit: Sales Groups MANDT
0 VBKRED VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 VBKRED VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 VBKRED VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 VBKRED VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
0 VBKRED WAERK TCURC Currency Codes MANDT
0 VBKRED WAERK TCURC Currency Codes WAERS
1 VBKRED WAERS TCURC Currency Codes MANDT
1 VBKRED WAERS TCURC Currency Codes WAERS