SAP ABAP Table TDS_CREDBLOCKDOC2 (Blocked for Credit SD Documents)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_O2C_SLS (Package) ERP Sales Order 2 Cash - Sales

Basic Data

Table Category	INTTAB	Structure
Structure	TDS_CREDBLOCKDOC2	Table Relationship Diagram
Short Description	Blocked for Credit SD Documents

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Credit-Blocked Documents - Structure of Line Items
2	PROCSTATUS	☐	TEXT20	TEXT20	CHAR	20	0	Text (20 Characters)
3	.INCLUDE	☐				0	0	Work Structure for Release of Credit Limit
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
6	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
7	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
8	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
12	KNKLI	☐	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
13	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
14	ORT01	☐	ORT01	TEXT25	CHAR	25	0	City
15	LAND	☐	LAND	LAND1	CHAR	3	0	Country of company	T005
16	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
17	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
18	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
19	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
20	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
21	GRUPP	☐	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group	T691B
22	SBGRP	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
23	CTLPC	☐	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
24	CMWAE	☐	WAERS_CM	WAERS	CUKY	5	0	Currency key of credit control area	TCURC
25	CMFRE	☐	CMFRE	DATUM	DATS	8	0	Release date of the document determined by credit management
26	CMNUP	☐	CMNUP	DATUM	DATS	8	0	Date of next credit check of document
27	CMNGV	☐	CMNGV	DATUM	DATS	8	0	Next date
28	CMPRE	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
29	CMTFG	☐	CMTFG	XFELD	CHAR	1	0	ID for partial release of order item, credit block
30	CMPNT	☐	CMPNT	XFELD	CHAR	1	0	ID: Item with active credit function / relevant for credit
31	CMKUA	☐	CMKUA	KURRF	DEC	9	5	Credit data exchange rate for requested delivery date
32	AMTBL	☐	AMTBL_CM	WERTV8	CURR	15	2	Released credit value of the document
33	KLPRZ	☐	KLPRZ_CM	ABPRC	NUMC	3	0	Credit limit used in %
34	KWKKB	☐	KWKKB	WERTV8	CURR	15	2	Credit value in thousands
35	KWKKC	☐	KWKKC	WERTV8	CURR	15	2	Credit value
36	KWKKD	☐	KWKKD	WERTV8	CURR	15	2	Credit value in thousands beyond the credit horizon
37	KWKKE	☐	KWKKE	WERTV8	CURR	15	2	Credit value beyond the credit horizon
38	OEIKW	☐	MC_OEIKW	WERTV10	CURR	19	2	Open sales order credit value (schedule lines)
39	OLIKW	☐	MC_OLIKW	WERTV10	CURR	19	2	Open delivery credit value
40	OFAKW	☐	MC_OFAKW	WERTV10	CURR	19	2	Open billing document credit value
41	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
42	AWAER	☐	AWAER	TEXT6	CHAR	6	0	Currency
43	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
44	CSTAT	☐	CSTAT	TEXT15	CHAR	15	0	Status field
45	CMPSA	☐	CMPSA	CMPSZ	CHAR	1	0	Status of static credit limit check
46	CMPSB	☐	CMPSB	CMPSZ	CHAR	1	0	Status of dynamic credit limit check in the credit horizon
47	CMPSC	☐	CMPSC	CMPSZ	CHAR	1	0	Status of credit check against maximum document value
48	CMPSD	☐	CMPSD	CMPSZ	CHAR	1	0	Status of credit check against terms of payment
49	CMPSE	☐	CMPSE	CMPSZ	CHAR	1	0	Status of credit check against customer review date
50	CMPSF	☐	CMPSF	CMPSZ	CHAR	1	0	Status of credit check against open items due
51	CMPSG	☐	CMPSG	CMPSZ	CHAR	1	0	Status of credit check against oldest open items
52	CMPSH	☐	CMPSH	CMPSZ	CHAR	1	0	Status of credit check against highest dunning level
53	CMPSI	☐	CMPSI	CMPSZ	CHAR	1	0	Status of credit check against financial document
54	CMPSJ	☐	CMPSJ	CMPSZ	CHAR	1	0	Status of credit check against export credit insurance
55	CMPSK	☐	CMPSK	CMPSZ	CHAR	1	0	Status of credit check against payment card authorization
56	CMPSL	☐	CMPSL	CMPSZ	CHAR	1	0	Status of credit check of reserves 4
57	CMPSM	☐	CMPSM	CMPSZ	CHAR	1	0	Credit check data is obsolete
58	CMPS0	☐	CMPS0	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 1
59	CMPS1	☐	CMPS1	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 2
60	CMPS2	☐	CMPS2	CMPSZ	CHAR	1	0	Status of credit check for customer reserve 3
61	CMGST	☐	CMGST	CMGST	CHAR	1	0	Overall status of credit checks
62	SKFOR	☐	SKFOR	WRTV8	CURR	15	2	Total receivables (for credit limit check)
63	SSOBL	☐	SSOBL	WRTV8	CURR	15	2	Relevant special liabilities for credit limit check
64	CRBLB	☐	CRBLB_CM	XFELD	CHAR	1	0	Indicator: Blocked by credit management ?
65	NXTRV	☐	NXTRV_CM	DATUM	DATS	8	0	Next internal review
66	KRAUS	☐	KRAUS_CM	CHAR11	CHAR	11	0	Credit information number
67	DBPAY	☐	DBPAY_CM	CHAR3	CHAR	3	0	Payment Index
68	DBRTG	☐	DBRTG_CM	CHAR5	CHAR	5	0	Rating
69	REVDB	☐	REVDB_CM	DATUM	DATS	8	0	Last review (external)
70	AEDAT	☐	AEDAT_CM	DATUM	DATS	8	0	Date of Last Change
71	AETXT	☐	AETXT_CM	DATUM	DATS	8	0	Date of Last Text Change
72	ZAEHL	☐	DZAEHL7	NUM7	NUMC	7	0	Counter with 7 Digits
73	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
74	ACTIV	☐	ACTIV	NUM02	NUMC	2	0	List Level in which the Line Item is Active
75	KLIMK	☐	KLIMK	WERT8	CURR	15	2	Customer's credit limit
76	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
77	SIZEC	☐	SIZEC_CM	SIZEC_CM	CHAR	3	0	Document value class (credit management)	T691I
78	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
79	WBSTK	☐	WBSTK	STATV	CHAR	1	0	Total goods movement status
80	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
81	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
82	CRMGR	☐	CRMGR_CM	CRMGR_CM	CHAR	2	0	Document credit group	T691D
83	TAGEF	☐	TAGEF_CM	ANZTA	NUMC	3	0	Credit check: Number of days without check
84	KWKKF	☐	KWKKF	WERTV8	CURR	15	2	Guaranteed value in thousands
85	KWKKG	☐	KWKKG	WERTV8	CURR	15	2	Guaranteed value
86	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
87	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
88	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
89	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
90	AUST1	☐	AUST1_CC	AUST1_CC	CHAR	1	0	Payment cards: Status regarding requirements
91	AUST2	☐	AUST2_CC	CCALL	CHAR	1	0	Payment cards: Totals status - Call external system
92	AUST3	☐	AUST3_CC	REACT_SD	CHAR	1	0	Payment cards: Overall status - Responses from ext. system
93	AUST5	☐	AUST5_CC	XFELD	CHAR	1	0	Payment cards: Authorization block
94	AUST1TXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
95	AUST2TXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
96	AUST3TXT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
97	AGNAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
98	AGORT01	☐	ORT01	TEXT25	CHAR	25	0	City
99	AGADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address	*
100	VBKLA	☐	VBKLA	CHAR9	CHAR	9	0	unused (sales doocument class)
101	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
102	CMPS_CM	☐	CMPS_CM	CMPSZ	CHAR	1	0	Status of Credit Check SAP Credit Management
103	.INCLUDE	☐				0	0	Customer Reserve for VBKRED
104	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
105	CMPS_TE	☐	CMPS_TE	CMPSZ	CHAR	1	0	Status of Technical Error SAP Credit Management
106	ABGRU_NEW	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
107	SBGRP_NEW	☐	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	*
108	ABGRU_READONLY	☐	FLAG	FLAG	CHAR	1	0	General Flag
109	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
110	AUARTT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
111	VBTYP_T	☐	VBTYP_TXT	AS4TEXT	CHAR	60	0	Description of sales and distribution document category
112	VDATU	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
113	TRVOG	☐	TRVOG_GEN	TRVOG_GEN	CHAR	1	0	Transaction Group
114	TRVOGT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
115	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
116	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
117	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
118	AUGRUT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
119	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
120	VSBEDT	☐	VSBED_BEZ	TEXT20	CHAR	20	0	Description of the shipping conditions
121	GBSTKT	☐	BEZEI40	TEXT40	CHAR	40	0	Description
122	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	*
123	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	*
124	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation	*
125	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
126	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
127	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	*
128	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
129	DISPZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
130	PZPERS_T	☐	PZPERS_BEZ	NAME	CHAR	35	0	Name of Employee Responsible
131	PARVW_T	☐	PARVW_BEZ	TEXT20	CHAR	20	0	Description of partner function
132	ZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
133	ZPERS	☐	DZPERS	PERNR	NUMC	8	0	Person responsible

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TDS_CREDBLOCKDOC2	CMWAE	TCURC	WAERS
2	TDS_CREDBLOCKDOC2	CRMGR	T691D	CRMGR_CM		C	CN
3	TDS_CREDBLOCKDOC2	CTLPC	T691A	CTLPC
4	TDS_CREDBLOCKDOC2	GRUPP	T691B	GRUPP		C	CN
5	TDS_CREDBLOCKDOC2	KKBER	T014	KKBER
6	TDS_CREDBLOCKDOC2	KNKLI	KNA1	KUNNR
7	TDS_CREDBLOCKDOC2	LAND	T005	LAND1
8	TDS_CREDBLOCKDOC2	LCNUM	AKKP	LCNUM	REF	C	CN
9	TDS_CREDBLOCKDOC2	MANDT	T000	MANDT
10	TDS_CREDBLOCKDOC2	POSNR	VBUP	POSNR
11	TDS_CREDBLOCKDOC2	SBGRP	T024B	SBGRP
12	TDS_CREDBLOCKDOC2	SIZEC	T691I	SIZEC
13	TDS_CREDBLOCKDOC2	SPART	TSPA	SPART
14	TDS_CREDBLOCKDOC2	VBELN	VBUK	VBELN
15	TDS_CREDBLOCKDOC2	VKORG	TVKO	VKORG
16	TDS_CREDBLOCKDOC2	VTWEG	TVTW	VTWEG
17	TDS_CREDBLOCKDOC2	WAERK	TCURC	WAERS		C	CN
18	TDS_CREDBLOCKDOC2	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in	604