TDS_CREDBLOCKDOC2 SAP (Blocked for Credit SD Documents) Structure details
Description: Blocked for Credit SD Documents
Related tables to TDS_CREDBLOCKDOC2
Access table TDS_CREDBLOCKDOC2
Structure field list including key, data, relationships and ABAP select examples
TDS_CREDBLOCKDOC2 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 "Blocked for Credit SD Documents" 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_TDS_CREDBLOCKDOC2 TYPE TDS_CREDBLOCKDOC2.
The TDS_CREDBLOCKDOC2 table consists of various fields, each holding specific information or linking keys about Blocked for Credit SD Documents data available in SAP. These include PROCSTATUS (Text (20 Characters)), MANDT (Client), KKBER (Credit control area), VBELN (Sales and Distribution Document Number).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP TDS_CREDBLOCKDOC2 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 |
PROCSTATUS | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
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 | ||||
ABGRU_NEW | Reason for rejection of quotations and sales orders | ABGRU_VA | CHAR | 2 | Assigned to domain | ABGRU_VA | |||
SBGRP_NEW | Credit representative group for credit management | SBGRP_CM | CHAR | 3 | Assigned to domain | SBGRP_CM | KBG | ||
ABGRU_READONLY | General Flag | FLAG | CHAR | 1 | FLAG | ||||
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
AUARTT | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
VBTYP_T | Description of sales and distribution document category | VBTYP_TXT | CHAR | 60 | AS4TEXT | ||||
VDATU | Requested delivery date | EDATU_VBAK | DATS | 8 | DATUM | ||||
TRVOG | Transaction Group | TRVOG_GEN | CHAR | 1 | TRVOG_GEN | VTV | |||
TRVOGT | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
AUGRU | Order reason (reason for the business transaction) | AUGRU | CHAR | 3 | Assigned to domain | AUGRU | |||
AUGRUT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | Assigned to domain | VSBED | |||
VSBEDT | Description of the shipping conditions | VSBED_BEZ | CHAR | 20 | TEXT20 | ||||
GBSTKT | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
VSART | Shipping type | VSARTTR | CHAR | 2 | Assigned to domain | VERSART | |||
TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | Assigned to domain | TRATY | |||
TRMTYP | Means of Transport | TRMTYP | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | Assigned to domain | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | Assigned to domain | BSARK | |||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
DISPZPAVW | Partner Function | PARVW | CHAR | 2 | Assigned to domain | PARVW | PARVW | PAR | |
PZPERS_T | Name of Employee Responsible | PZPERS_BEZ | CHAR | 35 | NAME | ||||
PARVW_T | Description of partner function | PARVW_BEZ | CHAR | 20 | TEXT20 | ||||
ZPAVW | Partner Function | PARVW | CHAR | 2 | Assigned to domain | PARVW | PARVW | PAR | |
ZPERS | Person responsible | DZPERS | NUMC | 8 | PERNR |
Key field | Non-key field |
How do I retrieve data from SAP structure TDS_CREDBLOCKDOC2 using ABAP code?
As TDS_CREDBLOCKDOC2 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 TDS_CREDBLOCKDOC2 as there is no data to select.How to access SAP table TDS_CREDBLOCKDOC2
Within an ECC or HANA version of SAP you can also view further information about TDS_CREDBLOCKDOC2 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