VBKRED SAP (Work Structure for Release of Credit Limit) Structure details
Description: Work Structure for Release of Credit Limit
Structure field list including key, data, relationships and ABAP select examples
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. .
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
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 |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects