1. Home
  2. Resources
  3. SAP Tables
  4. ISU_BI_COLL_BILL_S_SD_ITEM_P2 - SD Document Pricing Line Items

SAP Table ISU_BI_COLL_BILL_S_SD_ITEM_P2

SD Document Pricing Line Items

ISU_BI_COLL_BILL_S_SD_ITEM_P2 (SD Document Pricing Line Items) 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 ISU_BI_COLL_BILL_S_SD_ITEM_P2 to other SAP tables.

ISU_BI_COLL_BILL_S_SD_ITEM_P2 table fields

Field Data element Checktable Datatype Length Decimals
WA_SD_ITEM_P2 KOMVD STRU 0 0
KPOSN Condition item number KPOSN NUMC 6 0
STUNR Step number STUNR NUMC 3 0
ZAEHK Condition counter DZAEHK NUMC 2 0
KAPPL Application KAPPL CHAR 2 0
KSCHL Condition type KSCHA CHAR 4 0
KRECH Calculation type for condition KRECH CHAR 1 0
A Percentage
B Fixed amount
C Quantity
D Gross weight
E Net weight
F Volume
G Formula
H Percentage included
I Percentage (travel expenses)
K Per mille
J Per mille
L Points
M Quantity - monthy price
N Quantity - yearly price
O Quantity - daily price
P Quantity - weekly price
Q Commodity Price
R Distance-dependent
S Number of shipping units
T Multi-dimensional
U Percentage FIN (CRM Only)
KAWRT Condition base value KAWRT CURR 15 2
AWEIN Rate unit (currency, sales unit, or %) KOEIN CUKY 5 0
AWEI1 Rate unit (currency, sales unit, or %) KOEIN CUKY 5 0
KBETR Rate (condition amount or percentage) KBETR CURR 11 2
KOEIN Rate unit (currency, sales unit, or %) KOEIN CUKY 5 0
KOEI1 Rate unit (currency, sales unit, or %) KOEIN CUKY 5 0
KKURS Condition exchange rate for conversion to local currency KKURS DEC 9 5
KPEIN Condition pricing unit KPEIN DEC 5 0
KMEIN Condition unit in the document KVMEI UNIT 3 0
KUMZA Numerator for converting condition units to base units KUMZA DEC 5 0
KUMNE Denominator for converting condition units to base units KUMNE DEC 5 0
KNTYP Condition category (examples: tax, freight, price, cost) KNTYP CHAR 1 0
$ TaxJurCode trigger (without license check KNVL)
+ Tax exemption license via conditions
- Total charges (only IS-OIL)
0 Charges - condition records (only IS-OIL)
1 Tax JurDic level 1 (with license check KNVL)
2 Tax JurDic level 2
3 Tax JurDic level 3
4 Tax JurDic level 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
A Packaging
B Delivery costs
C Insurance
D Tax
E Cash discount
F Freight
G Internal price
H Basic price
I Price for intercompany billing
J Customer expected price / customer value (excl.tax)
K Base amount excluding tax
L Generally new when copying
M Sales tax w/license-checking (VAT)
N Input Tax not Deductible
O Variants
P Base amount including tax
Q Costing
R Invoice list condition
S Standard cost
T Moving cost
U Discount/surcharge for precious metals
V Price component
W Expected sales price (including tax)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
a Reserved (fixed extra pay)
b Transfer Price for Group Valuation
c Transfer price for profit centers
d Confirmed purchase net price/value
e Down payment request/down payment clearing
f Free goods - inclusive
g Payment
h Profit Center Cost
i Ship & Debit 1 (IBU HiTec)
j Ship & Debit 2 (IBU HiTec)
l TP-ILV: Base Tarif That Covers Costs
m SSR Discount (only IS-Oil)
n Profit Center Internal Price (Route)
o AFS Season Determination
p SSR Partner Commission (only IS-OIL)
& AFS Value-Added Services
KSTAT Condition is used for statistics KSTAT CHAR 1 0
X Yes
NULL No
KHERK Origin of the condition KHERK CHAR 1 0
A Automatic pricing
B Duplicated from main item
C Manually entered
D Header condition
E Item total
F Condition supplement
G Original header condition
H Correction Rebate
I Cost Correction
KWERT Condition value KWERT CURR 13 2
KSTEU Condition control KSTEU CHAR 1 0
A Adjust for quantity variance
B Free
C Changed manually
D Fixed
E Condition value and basis fixed
F Condition value fixed (billed items)
G Condition basis fixed
H Condition value fixed (cost price)
I Scale Base Value and Condition Amount Fixed (for BYD only)
KINAK Condition is inactive KINAK CHAR 1 0
A Condition exclusion item
K Inactive due to calculation basis/shipping material type
L Condition exclusion header or inactive at header level
M Inactive due to manual entry
T Inactive at header level
W The document item is statistical
X Inactive via formulae of incorrect
Y Inactive because of subsequent price
KOAID Condition class KOAID CHAR 1 0
A Discount or surcharge
B Prices
C Expense reimbursement
D Taxes
E Extra pay
F Fees or differential (only IS-OIL)
G Tax Classification
H Determining sales deal
Q Totals record for fees (only IS-OIL)
W Wage Withholding Tax
KNUMT Number of texts KNUMT CHAR 10 0
DRUKZ Print ID for condition lines DRUKZ CHAR 1 0
NULL It was not printed
X Printing at item level (previous procedure)
S Printing at totals level (previous procedure)
A Total: General
B Total: if value <> zero
C Total: if value <> previous value
D Total: if value <> zero and value <> previous value
a at item: General
b at item: if value <> zero
c at item: if value <> previous value
d at item: if value <> zero and value <> previous value
VTEXT Description BEZEI40 CHAR 40 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
STUFE Level (in multi-level BOM explosions) HISTU DEC 2 0
WEGXX Path (for multi-level BOM explosions) WEGXX DEC 4 0
KFAKTOR Factor for condition base value KFAKTOR FLTP 16 16
NRMNG Discount in kind: Inclusive bonus quantity of item NRMNG QUAN 13 3
MDFLG Indicator: Matrix maintenance MDFLG CHAR 1 0
NULL Standard maintenance
1 Matrix maintenance: 1-dimensional
2 Matrix maintenance: 2-dimensional
3 Matrix maintenance: 3-dimensional
KWERT_EURO Condition value KWERT CURR 13 2