SAP table UKM_S_BOL (Structure of POWL "Blocked Sales Orders")

Field Description Data Type Length Decimals Checktable Data Element
BP_NAME Name of Business Partner CHAR 50 0 UKM_BP_NAME_CLIENT
STREET_HOUSE_NO House Number and Street CHAR 75 0 UKM_STR_HOUSE
COUNTRY_ZIPCODE_CITY Country/Region/Postal Code/City CHAR 75 0 UKM_CTRY_ZIP_CITY
RATING Rating CHAR 10 0 UKM_RATING_CLIENT
RISK_CLASS Description of Risk Category CHAR 40 0 UKM_RISK_CLASS_TXT_CLIENT
CREDIT_LIMIT Credit Limit CURR 23 2 UKM_CREDITLIMIT_CLIENT
LIMIT_CURRENCY Currency Key CUKY 5 0 * WAERS
EXPOSURE Credit Exposure - Value CURR 23 2 UKM_EXPOSURE_CLIENT
EXPOSURE_CURRENCY Currency Key CUKY 5 0 * WAERS
DUNNING_LEVEL Dunning Level - Value INT4 10 0 UKM_DUNN_LEVEL_VALUE_CLIENT
OLD_OPEN_ITEMS_AMOUNT Oldest Open Items CURR 23 2 UKM_ITEM_AMOUNT_CLIENT
OLD_OPEN_ITEMS_CURRENCY Currency Key CUKY 5 0 * WAERS
OLD_OPEN_ITEMS_DATE Field of type DATS DATS 8 0 DATS
LAST_PAYMENT_AMOUNT Last Payment CURR 23 2 UKM_PAYMENT_AMOUNT_CLIENT
LAST_PAYMENT_CURRENCY Currency Key CUKY 5 0 * WAERS
LAST_PAYMENT_DATE Field of type DATS DATS 8 0 DATS
PARTNER Business Partner Number CHAR 10 0 * BU_PARTNER
CREDIT_SGMNT Credit Segment CHAR 10 0 * UKM_CREDIT_SGMNT_CLIENT
PROCSTATUS Text (20 Characters) CHAR 20 0 TEXT20
MANDT Client CLNT 3 0 T000 MANDT
KKBER Credit control area CHAR 4 0 T014 KKBER
VBELN Sales and Distribution Document Number CHAR 10 0 VBELN
POSNR Item number of the SD document NUMC 6 0 POSNR
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
KNKLI Customer's Account Number with Credit Limit Reference CHAR 10 0 KNA1 KNKLI
NAME1 Name CHAR 30 0 NAME1
ORT01 City CHAR 25 0 ORT01
LAND Company Country/Region CHAR 3 0 T005 LAND
ADRNR Address CHAR 10 0 ADRNR
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
BNAME Name of orderer CHAR 35 0 BNAME_V
TELF1 First telephone number CHAR 16 0 TELF1
GRUPP Customer Credit Group CHAR 4 0 T691B GRUPP_CM
SBGRP Credit Representative Group for Credit Management CHAR 3 0 T024B SBGRP_CM
CTLPC Credit Management: Risk Category CHAR 3 0 T691A CTLPC_CM
CMWAE Currency key of credit control area CUKY 5 0 TCURC WAERS_CM
CMFRE Release date of the document determined by credit management DATS 8 0 CMFRE
CMNUP Date of Next Credit Check of Document DATS 8 0 CMNUP
CMNGV Next date DATS 8 0 CMNGV
CMPRE Item Credit Price FLTP 16 16 CMPRE_FLT
CMTFG ID for partial release of order item, credit block CHAR 1 0 CMTFG
CMPNT ID: Item with active credit function / relevant for credit CHAR 1 0 CMPNT
CMKUA Credit data exchange rate for requested delivery date DEC 9 5 CMKUA
AMTBL Released credit value of the document CURR 15 2 AMTBL_CM
KLPRZ Credit limit used in % NUMC 3 0 KLPRZ_CM
KWKKB Credit value in thousands CURR 15 2 KWKKB
KWKKC Credit value CURR 15 2 KWKKC
KWKKD Credit value in thousands beyond the credit horizon CURR 15 2 KWKKD
KWKKE Credit value beyond the credit horizon CURR 15 2 KWKKE
OEIKW Open sales order credit value (schedule lines) CURR 19 2 MC_OEIKW
OLIKW Open delivery credit value CURR 19 2 MC_OLIKW
OFAKW Open billing document credit value CURR 19 2 MC_OFAKW
WAERS Currency Key CUKY 5 0 TCURC WAERS
AWAER Currency CHAR 6 0 AWAER
ZTERM Terms of payment key CHAR 4 0 DZTERM
CSTAT Status field CHAR 15 0 CSTAT
CMPSA Status of static credit limit check CHAR 1 0 CMPSA
CMPSB Status of dynamic credit limit check in the credit horizon CHAR 1 0 CMPSB
CMPSC Status of Credit Check Against Maximum Document Value CHAR 1 0 CMPSC
CMPSD Status of Credit Check Against Terms of Payment CHAR 1 0 CMPSD
CMPSE Status of credit check against customer review date CHAR 1 0 CMPSE
CMPSF Status of credit check against open items due CHAR 1 0 CMPSF
CMPSG Status of credit check against oldest open items CHAR 1 0 CMPSG
CMPSH Status of credit check against highest dunning level CHAR 1 0 CMPSH
CMPSI Status of Credit Check Against Financial Document CHAR 1 0 CMPSI
CMPSJ Status of Credit Check Against Export Credit Insurance CHAR 1 0 CMPSJ
CMPSK Status of Credit Check Against Payment Card Authorization CHAR 1 0 CMPSK
CMPSL Status of credit check of reserves 4 CHAR 1 0 CMPSL
CMPSM Credit check data is obsolete CHAR 1 0 CMPSM
CMPS0 Status of credit check for customer reserve 1 CHAR 1 0 CMPS0
CMPS1 Status of credit check for customer reserve 2 CHAR 1 0 CMPS1
CMPS2 Status of credit check for customer reserve 3 CHAR 1 0 CMPS2
CMGST Overall Status of Credit Checks CHAR 1 0 CMGST
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) CURR 23 2 SKFOR
SSOBL Relevant Special Liabilities for Credit Limit Check CURR 23 2 SSOBL
CRBLB Indicator: Blocked by Credit Management? CHAR 1 0 CRBLB_CM
NXTRV Next Review DATS 8 0 NXTRV_CM
KRAUS Credit Information Number CHAR 11 0 KRAUS_CM
DBPAY Payment Index CHAR 3 0 DBPAY_CM
DBRTG Rating CHAR 5 0 DBRTG_CM
REVDB Last External Review DATS 8 0 REVDB_CM
AEDAT Date of Last Change DATS 8 0 AEDAT_CM
AETXT Date of Last Text Change DATS 8 0 AETXT_CM
ZAEHL Counter with 7 Digits NUMC 7 0 DZAEHL7
SELKZ Selection flag CHAR 1 0 SELKZ
Not selected
* Selected and processed
X Selected but not yet processed
ACTIV List Level in Which the Line Item Is Active NUMC 2 0 ACTIV
KLIMK Customer's credit limit CURR 23 2 KLIMK
BSTNK Customer Reference CHAR 20 0 BSTNK
SIZEC Document value class (credit management) CHAR 3 0 T691I SIZEC_CM
GBSTK Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
WBSTK Goods Movement Status (All Items) CHAR 1 0 WBSTK
WAERK SD Document Currency CUKY 5 0 TCURC WAERK
NETWR Net Value of the Sales Order in Document Currency CURR 15 2 NETWR_AK
CRMGR Document credit group CHAR 2 0 T691D CRMGR_CM
TAGEF Credit check: Number of days without check NUMC 3 0 TAGEF_CM
KWKKF Guaranteed value in thousands CURR 15 2 KWKKF
KWKKG Guaranteed value CURR 15 2 KWKKG
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 LCNUM
KUNAG Sold-to Party CHAR 10 0 KNA1 KUNAG
VKBUR Sales office CHAR 4 0 VKBUR
VKGRP Sales group CHAR 3 0 VKGRP
AUST1 Payment Cards: Status Regarding Requirements CHAR 1 0 AUST1_CC
Not Relevant
A Requirement not met
B Requirement met
AUST2 Payment Cards: Totals Status - Call External System CHAR 1 0 AUST2_CC
AUST3 Payment cards: Overall status - Responses from ext. system CHAR 1 0 AUST3_CC
AUST5 Payment Cards: Authorization Block CHAR 1 0 AUST5_CC
AUST1TXT Description CHAR 40 0 BEZEI40
AUST2TXT Description CHAR 40 0 BEZEI40
AUST3TXT Description CHAR 40 0 BEZEI40
AGNAME1 Name CHAR 30 0 NAME1
AGORT01 City CHAR 25 0 ORT01
AGADRNR Address CHAR 10 0 ADRNR
VBKLA Original system with release and transaction control CHAR 9 0 VBKLA
CMPS_CM Status of Credit Check SAP Credit Management CHAR 1 0 CMPS_CM
DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
ABGRU_NEW Reason for Rejection of Sales Documents CHAR 2 0 ABGRU_VA
SBGRP_NEW Credit Representative Group for Credit Management CHAR 3 0 SBGRP_CM
ABGRU_READONLY General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
MANAGEDBY Managed By CHAR 10 0 UKM_BP_COACH_CLIENT
ANALYST Credit Specialist CHAR 12 0 USR02 UKM_COORDINATOR_CLIENT
REJECT_REASON Reason for Rejection of Sales Documents CHAR 2 0 TVAG ABGRU_VA
ERDAT_BEFORE Number of Days before Current Date NUMC 3 0 UKM_ERDAT_BEFORE
MANAGEDBY_DESCR Name of Business Partner CHAR 50 0 UKM_BP_NAME_CLIENT
CREDIT_SGMNT_NAME Name of Credit Segment CHAR 50 0 UKM_CREDIT_SGMNT_TXT_CLIENT
REJECT_REASON_DESCR Name of Rejection Reason CHAR 40 0 UKM_RJ_RESAON_CLIENT
CREDIT_STATUS_DESCR STRG 0 0

UKM_S_BOL foreign key relationships

Table Field Check Table Check Field
0 UKM_S_BOL ANALYST USR02 Logon Data (Kernel-Side Use) BNAME
1 UKM_S_BOL CMWAE TCURC Currency Codes MANDT
1 UKM_S_BOL CMWAE TCURC Currency Codes WAERS
0 UKM_S_BOL CRMGR T691D Credit groups for document types MANDT
1 UKM_S_BOL CTLPC T691A Credit management risk categories CTLPC
1 UKM_S_BOL CTLPC T691A Credit management risk categories KKBER
0 UKM_S_BOL GRUPP T691B "Credit Management Groups" GRUPP
0 UKM_S_BOL GRUPP T691B "Credit Management Groups" KKBER
1 UKM_S_BOL KKBER T014 Credit control areas KKBER
0 UKM_S_BOL KNKLI KNA1 General Data in Customer Master MANDT
0 UKM_S_BOL KNKLI KNA1 General Data in Customer Master KUNNR
1 UKM_S_BOL KUNAG KNA1 General Data in Customer Master MANDT
1 UKM_S_BOL KUNAG KNA1 General Data in Customer Master KUNNR
0 UKM_S_BOL LAND T005 Countries MANDT
0 UKM_S_BOL LAND T005 Countries LAND1
1 UKM_S_BOL MANDT T000 Clients MANDT
0 UKM_S_BOL REJECT_REASON TVAG Sales Documents: Rejection Reasons MANDT
0 UKM_S_BOL REJECT_REASON TVAG Sales Documents: Rejection Reasons ABGRU
1 UKM_S_BOL SBGRP T024B Credit management: Credit representative groups MANDT
1 UKM_S_BOL SBGRP T024B Credit management: Credit representative groups KKBER
0 UKM_S_BOL SPART TVTA Organizational Unit: Sales Area(s) MANDT
0 UKM_S_BOL SPART TVTA Organizational Unit: Sales Area(s) VKORG
0 UKM_S_BOL SPART TVTA Organizational Unit: Sales Area(s) VTWEG
0 UKM_S_BOL SPART TVTA Organizational Unit: Sales Area(s) SPART
1 UKM_S_BOL VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 UKM_S_BOL VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 UKM_S_BOL VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
0 UKM_S_BOL VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
0 UKM_S_BOL VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
1 UKM_S_BOL WAERK TCURC Currency Codes MANDT
1 UKM_S_BOL WAERK TCURC Currency Codes WAERS
0 UKM_S_BOL WAERS TCURC Currency Codes MANDT
0 UKM_S_BOL WAERS TCURC Currency Codes WAERS