SAP ABAP Table UKM_S_BOL (Structure of POWL "Blocked Sales Orders")

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-AP-AP (Application Component) Basic Functions
     ⤷ FOAP_UKM_WORK_CENTER_CLIENT (Package) Connection of FI-AR to FSCM Credit Management Work Center

Basic Data

Table Category	INTTAB	Structure
Structure	UKM_S_BOL	Table Relationship Diagram
Short Description	Structure of POWL "Blocked Sales Orders"

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	UKM_S_BOL	ANALYST	USR02	BNAME
2	UKM_S_BOL	CMWAE	TCURC	WAERS
3	UKM_S_BOL	CRMGR	T691D	CRMGR_CM		C	CN
4	UKM_S_BOL	CTLPC	T691A	CTLPC	REF
5	UKM_S_BOL	GRUPP	T691B	GRUPP	REF	C	CN
6	UKM_S_BOL	KKBER	T014	KKBER	REF
7	UKM_S_BOL	KNKLI	KNA1	KUNNR
8	UKM_S_BOL	KUNAG	KNA1	KUNNR	REF
9	UKM_S_BOL	LAND	T005	LAND1
10	UKM_S_BOL	LCNUM	AKKP	LCNUM	REF	C	CN
11	UKM_S_BOL	MANDT	T000	MANDT
12	UKM_S_BOL	POSNR	VBUP	POSNR
13	UKM_S_BOL	REJECT_REASON	TVAG	ABGRU
14	UKM_S_BOL	SBGRP	T024B	SBGRP	REF
15	UKM_S_BOL	SIZEC	T691I	SIZEC
16	UKM_S_BOL	SPART	TVTA	SPART	REF
17	UKM_S_BOL	VKORG	TVKO	VKORG	REF
18	UKM_S_BOL	VTWEG	TVKOV	VTWEG	REF
19	UKM_S_BOL	WAERK	TCURC	WAERS		C	CN
20	UKM_S_BOL	WAERS	TCURC	WAERS

History

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