SAP ABAP Table RVKRED_TS_POST (Credit-Blocked Documents - Structure of Line Items)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_PORTAL (Package) ERP Sales Portal Roles

Basic Data

Table Category	INTTAB	Structure
Structure	RVKRED_TS_POST	Table Relationship Diagram
Short Description	Credit-Blocked Documents - Structure of Line Items

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

Foreign Keys

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

History

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