1. Home
  2. Resources
  3. SAP Tables
  4. UKM_S_BOL - Structure of POWL "Blocked Sales Orders"

SAP Table UKM_S_BOL

Structure of POWL "Blocked Sales Orders"

UKM_S_BOL (Structure of POWL "Blocked Sales Orders") is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link UKM_S_BOL to other SAP tables.

UKM_S_BOL table fields

Field Data element Checktable Datatype Length Decimals
BP_NAME Name of Business Partner UKM_BP_NAME_CLIENT CHAR 50 0
STREET_HOUSE_NO House Number and Street UKM_STR_HOUSE CHAR 75 0
COUNTRY_ZIPCODE_CITY Country/Postal Code/City UKM_CTRY_ZIP_CITY CHAR 75 0
RATING Rating UKM_RATING_CLIENT CHAR 10 0
RISK_CLASS Name of the Risk Class UKM_RISK_CLASS_TXT_CLIENT CHAR 40 0
CREDIT_LIMIT Credit Limit UKM_CREDITLIMIT_CLIENT CURR 15 2
LIMIT_CURRENCY Currency Key WAERS CUKY 5 0
EXPOSURE Credit Exposure - Value UKM_EXPOSURE_CLIENT CURR 15 2
EXPOSURE_CURRENCY Currency Key WAERS CUKY 5 0
DUNNING_LEVEL Dunning Level - Value UKM_DUNN_LEVEL_VALUE_CLIENT INT4 10 0
OLD_OPEN_ITEMS_AMOUNT Oldest Open Items UKM_ITEM_AMOUNT_CLIENT CURR 15 2
OLD_OPEN_ITEMS_CURRENCY Currency Key WAERS CUKY 5 0
OLD_OPEN_ITEMS_DATE Field of type DATS DATS DATS 8 0
LAST_PAYMENT_AMOUNT Last Payment UKM_PAYMENT_AMOUNT_CLIENT CURR 15 2
LAST_PAYMENT_CURRENCY Currency Key WAERS CUKY 5 0
LAST_PAYMENT_DATE Field of type DATS DATS DATS 8 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
CREDIT_SGMNT Credit Segment UKM_CREDIT_SGMNT_CLIENT CHAR 10 0
PROCSTATUS Text (20 Characters) TEXT20 CHAR 20 0
MANDT Client MANDT T000 CLNT 3 0
KKBER Credit control area KKBER T014 CHAR 4 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
KNKLI Customer's account number with credit limit reference KNKLI KNA1 CHAR 10 0
NAME1 Name NAME1 CHAR 30 0
ORT01 City ORT01 CHAR 25 0
LAND Country of company LAND T005 CHAR 3 0
ADRNR Address ADRNR CHAR 10 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
BNAME Name of orderer BNAME_V CHAR 35 0
TELF1 First telephone number TELF1 CHAR 16 0
GRUPP Customer Credit Group GRUPP_CM T691B CHAR 4 0
SBGRP Credit representative group for credit management SBGRP_CM T024B CHAR 3 0
CTLPC Credit management: Risk category CTLPC_CM T691A CHAR 3 0
CMWAE Currency key of credit control area WAERS_CM TCURC CUKY 5 0
CMFRE Release date of the document determined by credit management CMFRE DATS 8 0
CMNUP Date of next credit check of document CMNUP DATS 8 0
CMNGV Next date CMNGV DATS 8 0
CMPRE Item credit price CMPRE_FLT FLTP 16 16
CMTFG ID for partial release of order item, credit block CMTFG CHAR 1 0
X Yes
NULL No
CMPNT ID: Item with active credit function / relevant for credit CMPNT CHAR 1 0
X Yes
NULL No
CMKUA Credit data exchange rate for requested delivery date CMKUA DEC 9 5
AMTBL Released credit value of the document AMTBL_CM CURR 15 2
KLPRZ Credit limit used in % KLPRZ_CM NUMC 3 0
KWKKB Credit value in thousands KWKKB CURR 15 2
KWKKC Credit value KWKKC CURR 15 2
KWKKD Credit value in thousands beyond the credit horizon KWKKD CURR 15 2
KWKKE Credit value beyond the credit horizon KWKKE CURR 15 2
OEIKW Open sales order credit value (schedule lines) MC_OEIKW CURR 19 2
OLIKW Open delivery credit value MC_OLIKW CURR 19 2
OFAKW Open billing document credit value MC_OFAKW CURR 19 2
WAERS Currency Key WAERS TCURC CUKY 5 0
AWAER Currency AWAER CHAR 6 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
CSTAT Status field CSTAT CHAR 15 0
CMPSA Status of static credit limit check CMPSA CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSB Status of dynamic credit limit check in the credit horizon CMPSB CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSC Status of credit check against maximum document value CMPSC CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSD Status of credit check against terms of payment CMPSD CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSE Status of credit check against customer review date CMPSE CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSF Status of credit check against open items due CMPSF CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSG Status of credit check against oldest open items CMPSG CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSH Status of credit check against highest dunning level CMPSH CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSI Status of credit check against financial document CMPSI CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSJ Status of credit check against export credit insurance CMPSJ CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSK Status of credit check against payment card authorization CMPSK CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSL Status of credit check of reserves 4 CMPSL CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSM Credit check data is obsolete CMPSM CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS0 Status of credit check for customer reserve 1 CMPS0 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS1 Status of credit check for customer reserve 2 CMPS1 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS2 Status of credit check for customer reserve 3 CMPS2 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMGST Overall status of credit checks CMGST CHAR 1 0
NULL Credit check was not executed/Status not set
A Credit check was executed, document OK
B Credit check was executed, document not OK
C Credit check was executed, document not OK, partial release
D Document released by credit representative
SKFOR Total receivables (for credit limit check) SKFOR CURR 15 2
SSOBL Relevant special liabilities for credit limit check SSOBL CURR 15 2
CRBLB Indicator: Blocked by credit management ? CRBLB_CM CHAR 1 0
X Yes
NULL No
NXTRV Next internal review NXTRV_CM DATS 8 0
KRAUS Credit information number KRAUS_CM CHAR 11 0
DBPAY Payment Index DBPAY_CM CHAR 3 0
DBRTG Rating DBRTG_CM CHAR 5 0
REVDB Last review (external) REVDB_CM DATS 8 0
AEDAT Date of Last Change AEDAT_CM DATS 8 0
AETXT Date of Last Text Change AETXT_CM DATS 8 0
ZAEHL Counter with 7 Digits DZAEHL7 NUMC 7 0
SELKZ Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
ACTIV List Level in which the Line Item is Active ACTIV NUMC 2 0
KLIMK Customer's credit limit KLIMK CURR 15 2
BSTNK Customer purchase order number BSTNK CHAR 20 0
SIZEC Document value class (credit management) SIZEC_CM T691I CHAR 3 0
GBSTK Overall processing status of document GBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WBSTK Total goods movement status WBSTK CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
WAERK SD Document Currency WAERK TCURC CUKY 5 0
NETWR Net Value of the Sales Order in Document Currency NETWR_AK CURR 15 2
CRMGR Document credit group CRMGR_CM T691D CHAR 2 0
TAGEF Credit check: Number of days without check TAGEF_CM NUMC 3 0
KWKKF Guaranteed value in thousands KWKKF CURR 15 2
KWKKG Guaranteed value KWKKG CURR 15 2
LCNUM Financial doc. processing: Internal financial doc. number LCNUM AKKP CHAR 10 0
KUNAG Sold-to party KUNAG KNA1 CHAR 10 0
VKBUR Sales Office VKBUR CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
AUST1 Payment cards: Status regarding requirements AUST1_CC CHAR 1 0
NULL Not Relevant
A Requirement not met
B Requirement met
AUST2 Payment cards: Totals status - Call external system AUST2_CC CHAR 1 0
NULL Not Relevant
A External system not reached
B External system reached: no response
C External system reached: response received
AUST3 Payment cards: Overall status - Responses from ext. system AUST3_CC CHAR 1 0
NULL Not Relevant
A Checks successful
B Unsuccessful: authorize later
C Unsuccessful: set authorization lock
AUST5 Payment cards: Authorization block AUST5_CC CHAR 1 0
X Yes
NULL No
AUST1TXT Description BEZEI40 CHAR 40 0
AUST2TXT Description BEZEI40 CHAR 40 0
AUST3TXT Description BEZEI40 CHAR 40 0
AGNAME1 Name NAME1 CHAR 30 0
AGORT01 City ORT01 CHAR 25 0
AGADRNR Address ADRNR CHAR 10 0
VBKLA Original system with release and transaction control VBKLA CHAR 9 0
CMPS_CM Status of Credit Check SAP Credit Management CMPS_CM CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
ABGRU_NEW Reason for rejection of quotations and sales orders ABGRU_VA CHAR 2 0
SBGRP_NEW Credit representative group for credit management SBGRP_CM CHAR 3 0
ABGRU_READONLY General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
MANAGEDBY Managed By UKM_BP_COACH_CLIENT CHAR 10 0
ANALYST Credit Specialist UKM_COORDINATOR_CLIENT USR02 CHAR 12 0
REJECT_REASON Reason for rejection of quotations and sales orders ABGRU_VA TVAG CHAR 2 0
ERDAT_BEFORE Number of Days before Current Date UKM_ERDAT_BEFORE NUMC 3 0
MANAGEDBY_DESCR Name of Business Partner UKM_BP_NAME_CLIENT CHAR 50 0
CREDIT_SGMNT_NAME Name of Credit Segment UKM_CREDIT_SGMNT_TXT_CLIENT CHAR 50 0
REJECT_REASON_DESCR Name of Rejection Reason UKM_RJ_RESAON_CLIENT CHAR 40 0
CREDIT_STATUS_DESCR STRG 0 0

UKM_S_BOL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
UKM_S_BOL ANALYST UKM_S_BOL ANALYST USR02 Logon Data (Kernel-Side Use) BNAME
UKM_S_BOL ANALYST SYST MANDT USR02 Logon Data (Kernel-Side Use) MANDT
UKM_S_BOL CMWAE UKM_S_BOL MANDT TCURC Currency Codes MANDT
UKM_S_BOL CMWAE UKM_S_BOL CMWAE TCURC Currency Codes WAERS
UKM_S_BOL CRMGR UKM_S_BOL CRMGR T691D Credit groups for document types CRMGR_CM
UKM_S_BOL CRMGR UKM_S_BOL MANDT T691D Credit groups for document types MANDT
UKM_S_BOL CTLPC UKM_S_BOL KKBER T691A Credit management risk categories KKBER
UKM_S_BOL CTLPC UKM_S_BOL MANDT T691A Credit management risk categories MANDT
UKM_S_BOL CTLPC UKM_S_BOL CTLPC T691A Credit management risk categories CTLPC
UKM_S_BOL GRUPP UKM_S_BOL MANDT T691B "Credit Management Groups" MANDT
UKM_S_BOL GRUPP UKM_S_BOL GRUPP T691B "Credit Management Groups" GRUPP
UKM_S_BOL GRUPP UKM_S_BOL KKBER T691B "Credit Management Groups" KKBER
UKM_S_BOL KKBER UKM_S_BOL KKBER T014 Credit control areas KKBER
UKM_S_BOL KKBER SYST MANDT T014 Credit control areas MANDT
UKM_S_BOL KNKLI UKM_S_BOL MANDT KNA1 General Data in Customer Master MANDT
UKM_S_BOL KNKLI UKM_S_BOL KNKLI KNA1 General Data in Customer Master KUNNR
UKM_S_BOL KUNAG UKM_S_BOL KUNAG KNA1 General Data in Customer Master KUNNR
UKM_S_BOL KUNAG SYST MANDT KNA1 General Data in Customer Master MANDT
UKM_S_BOL LAND UKM_S_BOL MANDT T005 Countries MANDT
UKM_S_BOL LAND UKM_S_BOL LAND T005 Countries LAND1
UKM_S_BOL LCNUM UKM_S_BOL MANDT AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data MANDT
UKM_S_BOL LCNUM UKM_S_BOL LCNUM AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data LCNUM
UKM_S_BOL MANDT UKM_S_BOL MANDT T000 Clients MANDT
UKM_S_BOL POSNR UKM_S_BOL MANDT VBUP Sales Document: Item Status MANDT
UKM_S_BOL POSNR UKM_S_BOL VBELN VBUP Sales Document: Item Status VBELN
UKM_S_BOL POSNR UKM_S_BOL POSNR VBUP Sales Document: Item Status POSNR
UKM_S_BOL REJECT_REASON SYST MANDT TVAG Sales Documents: Rejection Reasons MANDT
UKM_S_BOL REJECT_REASON UKM_S_BOL REJECT_REASON TVAG Sales Documents: Rejection Reasons ABGRU
UKM_S_BOL SBGRP UKM_S_BOL MANDT T024B Credit management: Credit representative groups MANDT
UKM_S_BOL SBGRP UKM_S_BOL SBGRP T024B Credit management: Credit representative groups SBGRP
UKM_S_BOL SBGRP UKM_S_BOL KKBER T024B Credit management: Credit representative groups KKBER
UKM_S_BOL SIZEC UKM_S_BOL MANDT T691I Document Value Class for Credit Management MANDT
UKM_S_BOL SIZEC UKM_S_BOL SIZEC T691I Document Value Class for Credit Management SIZEC
UKM_S_BOL SPART SYST MANDT TVTA Organizational Unit: Sales Area(s) MANDT
UKM_S_BOL SPART UKM_S_BOL VKORG TVTA Organizational Unit: Sales Area(s) VKORG
UKM_S_BOL SPART UKM_S_BOL VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
UKM_S_BOL SPART UKM_S_BOL SPART TVTA Organizational Unit: Sales Area(s) SPART
UKM_S_BOL VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
UKM_S_BOL VKORG UKM_S_BOL VKORG TVKO Organizational Unit: Sales Organizations VKORG
UKM_S_BOL VTWEG SYST MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
UKM_S_BOL VTWEG UKM_S_BOL VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
UKM_S_BOL VTWEG UKM_S_BOL VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
UKM_S_BOL WAERK UKM_S_BOL MANDT TCURC Currency Codes MANDT
UKM_S_BOL WAERK UKM_S_BOL WAERK TCURC Currency Codes WAERS
UKM_S_BOL WAERS UKM_S_BOL MANDT TCURC Currency Codes MANDT
UKM_S_BOL WAERS UKM_S_BOL WAERS TCURC Currency Codes WAERS