1. Home
  2. Resources
  3. SAP Tables
  4. DRSEG - Invoice Item (Dialog Processing)

SAP Table DRSEG

Invoice Item (Dialog Processing)

DRSEG (Invoice Item (Dialog Processing)) 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 DRSEG to other SAP tables.

DRSEG table fields

Field Data element Checktable Datatype Length Decimals
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
APLZL Internal counter CIM_COUNT NUMC 8 0
AREWR GR/IR account clearing value in local currency AREWR CURR 13 2
AREWW Clearing value on GR/IR clearing account (transac. currency) AREWW CURR 13 2
AUFNR Order Number AUFNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
BASME Base unit of measure F_MEINS UNIT 3 0
BEDAT Purchase Order Date BEDAT DATS 8 0
BEGRU Authorization Group BEGRU CHAR 4 0
BEWAE Purchase order currency BSTWA CUKY 5 0
EKGRP Purchasing Group BKGRP CHAR 3 0
BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
BPRME Order Price Unit (Purchasing) BPRME UNIT 3 0
BPUMN Denominator for Conv. of Order Price Unit into Order Unit BPUMN DEC 5 0
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit BPUMZ DEC 5 0
BPWEM Goods Receipt Quantity in Purchase Order Price Unit BPWEM QUAN 13 3
BPREM Invoice receipt quantity in order price unit BPREM QUAN 13 3
BSMNG Quantity Ordered Against this Purchase Requisition BSMNG QUAN 13 3
BUDAT Posting Date in the Document BUDAT DATS 8 0
BUKRS Company Code BUKRS CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
BWTTY Valuation Category BWTTY_D CHAR 1 0
BZDAT Asset value date BZDAT DATS 8 0
EBELN Purchase Order Number BSTNR CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
FIPOS Commitment Item FIPOS CHAR 14 0
FISTL Funds Center FISTL CHAR 16 0
FKBER Functional Area FKBER CHAR 16 0
GEBER Fund FM_FUND CHAR 10 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
GSBER Business Area GSBER CHAR 4 0
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
HWAER Local Currency HWAER CUKY 5 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KNTTP Account Assignment Category KNTTP CHAR 1 0
KOSTL Cost Center KOSTL CHAR 10 0
KO_GSBER Business area reported to the partner GSBER_GP CHAR 4 0
KO_PARGB assumed business area of the business partner PARGB_GP CHAR 4 0
KO_PRCTR Profit Center PRCTR CHAR 10 0
KO_PPRCTR Partner Profit Center PPRCTR CHAR 10 0
KSTRG Cost Object KSTRG CHAR 12 0
KUFIX Indicator: Fixing of Exchange Rate KUFIX CHAR 1 0
X Yes
NULL No
KZBAA Indicator: valuation type is set automatically KZBAA CHAR 1 0
X Yes
NULL No
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
KZVBF Valuation type "external procurement" mandatory KZVBF CHAR 1 0
X Yes
NULL No
LANDS Country from where output is sent (issuing country) LANDS CHAR 3 0
MATKL Material Group MATKL CHAR 9 0
MATNR Material Number MATNR CHAR 18 0
MEINS Purchase Order Unit of Measure BSTME UNIT 3 0
MEPRF Price Determination (Pricing) Date Control MEPRF CHAR 1 0
NULL No Control
1 Purchase Order Date
2 Delivery Date
3 Current Date
4 Manual
5 GR Date
MTART Material Type MTART CHAR 4 0
NETWR Net order value in document currency BSTWR CURR 13 2
NOQUANTITY No quantity logic (document item without quantity) NOQUANTITY CHAR 1 0
X Yes
NULL No
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PERNR Personnel Number PERNR_D NUMC 8 0
PRCTR Profit Center PRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
RECID Recovery Indicator JV_RECIND CHAR 2 0
REEWR Invoice Value Entered (in Local Currency) REEWR CURR 13 2
REFWR Invoice value in foreign currency REFWR CURR 13 2
REMNG Quantity invoiced REMNG QUAN 13 3
RETPO Returns Item RETPO CHAR 1 0
X Yes
NULL No
REWRT Invoice value in local currency REWRT CURR 13 2
REWWR Invoice Amount in Foreign Currency REWWR CURR 13 2
SAKNR G/L Account Number SAKNR CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
VBWAF Default: valuation type "external procurement" VBWAF CHAR 10 0
VPTNR Partner account number JV_PART CHAR 10 0
WAERS Currency Key WAERS CUKY 5 0
WEMNG Quantity of Goods Received WEMNG QUAN 13 3
WEPOS Goods Receipt Indicator WEPOS CHAR 1 0
X Yes
NULL No
WERKS Plant WERKS_D CHAR 4 0
WEUNB Goods Receipt, Non-Valuated WEUNB CHAR 1 0
X Yes
NULL No
WEWRT Value of goods received in local currency WEWRT CURR 13 2
WEWWR Value of goods received in foreign currency WEWWR CURR 13 2
WENWR Accepted net value of service in foreign currency WENWR CURR 13 2
XBLNR Number of External Delivery Note LFSNR1 CHAR 16 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
LSMNG Quantity from Delivery Note MRM_LSMNG QUAN 13 3
LSMEH Unit of Measure From Delivery Note LSMEH UNIT 3 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
KDATB Start of Validity Period KDATB DATS 8 0
KDATE End of Validity Period KDATE DATS 8 0
SUMLIMIT Overall Limit SUMLIMIT CURR 13 2
SUMNOLIM No Limit NOLIMIT CHAR 1 0
ACTVALUE Total Value of Unplanned Entered Services ACTVALUE CURR 13 2
WEMMG Non-valuated goods receipt quantity WEMMG QUAN 13 3
BPWMM Non-valuated goods receipt quantity in order price unit BPWMM QUAN 13 3
LSTAR Activity Type LSTAR CHAR 6 0
PRZNR Business Process CO_PRZNR CHAR 12 0
WENAM Goods receipt entered by WENAM CHAR 12 0
AFNAM Name of Requisitioner/Requester AFNAM CHAR 12 0
REBEL Referenced document REBEL CHAR 10 0
REPOS Invoice Receipt Indicator REPOS CHAR 1 0
X Yes
NULL No
AREWB Clearing Value on GR/IR Account in PO Currency AREWB CURR 13 2
TWRKZ Partial Invoice Indicator TWRKZ CHAR 1 0
NULL No multiple account assignment
1 Apportion IR quantities to GR quantities one after another
2 Apportion IR quantities to GR quantities proportionately
REWRB Invoice Amount in PO Currency REWRB CURR 13 2
WEWRB Value of Goods Received in PO Currency WEWRB CURR 13 2
XBESW Indicator: Update in PO Currency XBESW CHAR 1 0
X Yes
NULL No
WESBB Valuated Goods Receipt Blocked Stock in Order Unit WESBB QUAN 13 3
BPWEB Quantity in Valuated GR Blocked Stock in Order Price Unit BPWEB QUAN 13 3
KUDIF Exchange Rate Difference Amount KUDIF CURR 13 2
BSMNG_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
REMNG_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
WEMNG_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
BPREM_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
BPWEM_F Quantity Share Account Assignment Line for Item SHARE_F FLTP 16 16
XHISTMA Update Multiple Account Assignment EKBE_MA, EKBZ_MA XHISTMA CHAR 1 0
XUNPL Unplanned Account Assignment from Invoice Verification XUNPL CHAR 1 0
X Yes
NULL No
VRTKZ Distribution indicator for multiple account assignment VRTKZ CHAR 1 0
NULL Single account assignment
1 Distrib. on quantity basis
2 Distribution by percentage
WKURS_IR Exchange Rate WKURS DEC 9 5
WKURS_GR Exchange Rate WKURS DEC 9 5
MEASURE Funded Program FM_MEASURE CHAR 24 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
LAST_GR_DATE Last Goods Receipt Date LAST_GR_DATE DATS 8 0
LAST_DELIV_DATE Last Allowed Delivery Date LAST_DELIV_DATE DATS 8 0
AA_FINAL_IND Final Account Assignment Indicator AA_FINAL_IND CHAR 1 0
X Yes
NULL No
AA_FINAL_QTY Final Account Assignment Quantity AA_FINAL_QTY QUAN 13 3
AA_FINAL_QTY_F Final Account Assignment Quantity (Floating Point Number) AA_FINAL_QTY_F FLTP 16 16
PARKED_QTY Parked Invoice Quantity PARKED_QTY QUAN 13 3
PARKED_QTY_F Parked Invoice Quantity (Floating Point Number) PARKED_QTY_F FLTP 16 16
CHARG Batch Number CHARG_D CHAR 10 0
XDINV Indicator for Differential Invoicing XDINV CHAR 1 0
XCPRF Checkbox for Commodity Repricing in Invoice Verification XCPRF CHAR 1 0
FINAL_INV_EXIST Differential Invoicing: Final Invoice Exists FINAL_INV_EXIST CHAR 1 0
PRICING_QTY_GR Goods Receipt Quantity in Purchase Order Price Unit BPWEM QUAN 13 3
KUDIF_GR Exchange Rate Difference Amount KUDIF CURR 13 2
KUDIF_IR Exchange Rate Difference Amount KUDIF CURR 13 2
VNAME Joint Venture JV_NAME CHAR 6 0
EGRUP Equity group JV_EGROUP CHAR 3 0
ETYPE Equity type JV_ETYPE T8JG CHAR 3 0
NEBTR Net Payment Amount NEBTR CURR 13 2
OIEXGNUM Exchange agreement number OIA_EXGNUM CHAR 10 0
OIMATPST Posting rules for material OIA_MATPST CHAR 1 0
1 Material external
2 Mat. and taxes internal
3 Mat. internal, taxes external
OIA_IPMVAT VAT on internally-posted material OIA_IPMVAT CHAR 1 0
NULL No VAT calculation
X VAT calculation with subtotal V of pricing procedure
OIVATH Amount in Local Currency DMBTR CURR 13 2
OIVATF Amount in document currency WRBTR CURR 13 2
OINETTNG Netting indicator OIA_NETTNG CHAR 1 0
X Netting active
NULL Netting not active
OINETCYC Netting cycle (FI blocking indicator) OIA_NETCYC CHAR 1 0
OIEXGTYP Exchange type OIA_EXGTYP CHAR 4 0
OIMATCYC Invoicing cycle for purchase material costs OIA_MATCYC NUMC 1 0
OITAXGRP Excise Duty Group OIH_TAXGRP CHAR 2 0
OIHANTYP Excise Duty Handling Type OIH_HANTYP CHAR 2 0
OITAXFROM Excise duty tax key for 'from' location OIH_TAXFRO CHAR 2 0
OITAXTO Excise duty tax key for 'to' location OIH_TAXTO CHAR 2 0
OIPRICIE ED pricing: external (indicator) OIH_PRICIE CHAR 1 0
X Yes
NULL No
OIFULTAX Excise duty tax value at the full rate OIH_FULTAX CURR 13 2
OITXVAL0 Excise duty tax value 0 OIH_TXVAL0 CURR 13 2
OITXVAL1 Excise duty tax value 1 OIH_TXVAL1 CURR 13 2
OITXVAL2 Excise duty tax value 2 OIH_TXVAL2 CURR 13 2
OITXVAL3 Excise duty tax value 3 OIH_TXVAL3 CURR 13 2
OITXVAL4 Excise duty tax value 4 OIH_TXVAL4 CURR 13 2
OITXVAL5 Excise duty tax value 5 OIH_TXVAL5 CURR 13 2
OITXVAL6 Excise duty tax value 6 OIH_TXVAL6 CURR 13 2
OIOILCON Oil content in a material as a percentage OIH_OILCON DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OITAXCON Excise duty tax from pricing conditions OIH_TAXCON CURR 13 2
OITAXVAL Excise duty value in material inventory account OIH_TAXVAL CURR 13 2
OIOILCON2 Oil content of a material as a percentage (2) OIH_OILCN2 DEC 5 2
0 Range of permissible values for Mineral Oil Content %
OIUOMQT Base quantity for excise duty rate (e.g.per 1 or 100 UoM) OIH_UOMQT UNIT 3 0
OITAXQT Excise duty tax quantity in STBME OIH_TAXQT QUAN 13 3
OIFUTQT Future tax quantity OIH_FUTQT QUAN 13 3
OIFUTTX Future tax value OIH_FUTTX CURR 13 2
OIFUTDT Future tax date OIH_FUTDT DATS 8 0
OIFUTQT2 Future tax quantity 2 OIH_FUTQT2 QUAN 13 3
OIFUTTX2 Future tax value 2 OIH_FUTTX2 CURR 13 2
ROIFUTDT2 Future tax date 2 OIH_FUTDT2 DATS 8 0
OIEDCLT Excise duty clearing value total OIH_EDCLT CURR 13 2
OIWEEDWR Excise duty value - goods receipt OIH_WEEDWR CURR 13 2
OIREEDWR Excise duty value - invoice receipt OIH_REEDWR CURR 13 2
FRBNR Number of Bill of Lading at Time of Goods Receipt FRBNR1 CHAR 16 0
KMEIN Condition unit KMEIN UNIT 3 0
KSCHL Condition Type KSCHL CHAR 4 0
KVSL1 Account key KVSL1 CHAR 3 0
KVSL2 Account key - accruals / provisions KVSL2 CHAR 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
STUNR Step number STUNR NUMC 3 0
XBPRM New Input Values XFLAG CHAR 1 0
NULL Blank
. Radio button
X Selection
ZAEHK Condition counter DZAEHK NUMC 2 0
REBUZ Item in Material Document MBLPO NUMC 4 0
VNETW Net value of condition (predefined externally) VNETWR CURR 13 2
VMENG Quantity of Goods Received WEMNG QUAN 13 3
BNKTK Copy delivery costs from shipment costs document VF_BNKTK CHAR 1 0
NULL No copy from shipment cost documents
X Copy from shipment cost documents
XMACC Multiple Account Assignment XMACC CHAR 1 0
OIORBTR Fee amount before clearing (original amount, document curr.) OIA_ORBTR CURR 13 2
KONNR Number of Principal Purchase Agreement KONNR CHAR 10 0
OIA_FE Indicator: update fee order history OIA_FE CHAR 1 0
X Yes
NULL No
OIA_FD Indicator: fee is on detail level OIA_FD CHAR 1 0
X Yes
NULL No
OIACPOL Fee accounting policy indicator OIA_ACPOL CHAR 1 0
1 Fees included in inventory
2 Fees posted to expense account
3 Fees posted to revenue account
WKURS Exchange Rate WKURS DEC 9 5
OIRATE Exchange rate (for foreign currencies) OIA_RATE FLTP 16 16
ANZAL Total Down Payments in Local Currency ANZAL CURR 13 2
BPBSM Ordered quantity in order price unit BPBSM QUAN 13 3
BPWES Quantity in GR blocked stock in order price unit BPWES QUAN 13 3
EINDT Item Delivery Date EINDT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
FPLNR Invoicing plan number IPLNR CHAR 10 0
INCO1 Incoterms (Part 1) INCO1 TINC CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
LFBNR Document No. of a Reference Document LFBNR CHAR 10 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFPOS Item of a Reference Document LFPOS NUMC 4 0
MWSKZ Tax on sales/purchases code MWSKZ T007A CHAR 2 0
NETPR Net price NETPR CURR 11 2
PEINH Price Unit PEINH DEC 5 0
SCHPR Indicator: Estimated Price SCHPR CHAR 1 0
X Yes
NULL No
SSQSS QA Control Key SSQSS CHAR 8 0
STATU RFQ status ASTAT CHAR 1 0
NULL No Quotation Exists/Not Created via Sales
A Quotation Exists in Case of RFQ Item
F Created via Production Order
V Created via Sales document
W Created via Allocation Table
TXZ01 Short Text TXZ01 CHAR 40 0
VETEN Delivery Schedule Line Number ETENR NUMC 4 0
WEBRE Indicator: GR-Based Invoice Verification WEBRE CHAR 1 0
X Yes
NULL No
WESBS Goods Receipt Blocked Stock in Order Unit WESBS QUAN 13 3
XERSY Evaluated Receipt Settlement (ERS) XERSY CHAR 1 0
X Yes
NULL No
XSKRL Indicator: Line item not liable to cash discount? XSKRL CHAR 1 0
X Yes
NULL No
XUBNKR Indicates: Not relevant for unplanned delivery costs? XUBNKR CHAR 1 0
X Yes
NULL No
KORNR Correction of miscellaneous provisions KORNR CHAR 1 0
NULL No corrections of miscellaneous provisions
1 Correction of misc. provisions in invoice verification
EBONF Item Not Relevant to Subseq. (Period-End Rebate) Settlement EBONF CHAR 1 0
X Yes
NULL No
FKNUM Shipment Cost Number FKNUM CHAR 10 0
FKPOS Shipment costs item FKPOS NUMC 6 0
FKPTY Item category shipment costs FKPTY CHAR 4 0
EXTI1 External identification 1 EXTI1 CHAR 20 0
EXLIN Item Number Length EXLIN CHAR 40 0
EXSNR External Sorting EXSNR NUMC 5 0
EHTYP External Hierarchy Category EHTYP TMSRM_EHTYP CHAR 4 0
RETSUM_FC Total of Retention Amounts in Document Currency RET_SUM_FC CURR 13 2
RETSUM_LC Total of Retention Amounts in Company Code Currency RET_SUM_LC CURR 13 2
RETSUMP_FC Total Retention Amount Posted To Date in Document Currency RET_SUM_POST_FC CURR 13 2
RETSUMP_LC Total Retention Amount Posted in Company Code Currency RET_SUM_POST_LC CURR 13 2
RETPC Retention in Percent RETPZ DEC 5 2
RETTP Retention Indicator RETTP CHAR 1 0
NULL Not Applicable
H Applicable (Header Level)
I Applicable (Item Level)
B Secured by Bond
TRMRISK_RELEVANT Risk Relevancy in Purchasing PUR_TRM_RISK_RELEVANCY CHAR 2 0
NULL Not specified
C Relevant for Commodity TRM Integration
/BEV1/NEGEN_ITEM Indicator: Item Is Generated /BEV1/NEGEN_ITEM_FLAG CHAR 1 0
X Yes
NULL No
/BEV1/NESTRUCCAT Structure Category for Material Relationship /BEV1/NESTRUC_CAT CHAR 1 0
NULL No structure
F Full Product
S Structured Empties
ANBWA Asset Transaction Type ANBWA CHAR 3 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
BEWAR Consolidation Transaction Type BEWAR CHAR 3 0
BUZEI Document Item in Invoice Document RBLGP NUMC 6 0
BWKEY Valuation Area BWKEY CHAR 4 0
BWMOD Valuation Grouping Code BWMOD CHAR 4 0
EREKZ Final Invoice Indicator EREKZ CHAR 1 0
X Yes
NULL No
FAUS1 Account/Posting Key Field Selection FAUS1 CHAR 50 0
FAUS2 Account/Posting Key Field Selection FAUS1 CHAR 50 0
FMORE All additional account assignments FMORE CHAR 1 0
X Yes
NULL No
GJAHR Fiscal Year GJAHR NUMC 4 0
KOKRS Controlling Area KOKRS CHAR 4 0
KTOPL Chart of Accounts KTOPL CHAR 4 0
LNRAN Sequence number of asset line items in fiscal year LNRAN NUMC 5 0
MENGE Quantity MENGE_D QUAN 13 3
MLMAA Material ledger activated at material level CK_ML_MAAC CHAR 1 0
X Yes
NULL No
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
MWSKZ_SKB1 Tax on sales/purchases code MWSKZ CHAR 2 0
POPTS Real estate option rate POPTSATZ DEC 9 6
REUPD Account assignment can be changed at time of invoice receipt REUPD CHAR 1 0
X Yes
NULL No
SELKZ Selection indicator SELKZ_08 CHAR 1 0
X Yes
NULL No
SGTXT Item Text SGTXT CHAR 50 0
SPGRG Blocking reason: order price quantity SPGRG CHAR 1 0
X Yes
NULL No
SPGRM Blocking reason: quantity SPGRM CHAR 1 0
X Yes
NULL No
SPGRP Blocking reason: price SPGRP CHAR 1 0
X Yes
NULL No
SPGRQ Manual Blocking Reason SPGRQ CHAR 1 0
X Yes
NULL No
SPGRT Blocking Reason: Date SPGRT CHAR 1 0
X Yes
NULL No
SPGRV Blocking reason: project budget SPGRV CHAR 1 0
X Yes
NULL No
SPGRS Blocking Reason: Item Amount SPGRS CHAR 1 0
X Yes
NULL No
SPGRC Block.reason: quality SPGRC CHAR 1 0
X Yes
NULL No
SPGREXT Blocking Reason Enhancement Fields SPGREXT CHAR 1 0
X Yes
NULL No
SUBRC Subroutines for return code SUBRC NUMC 2 0
01 Record not found
02 Record logically deleted
TBTKZ Indicator: subsequent debit/credit TBTKZ CHAR 1 0
VTEXT Description VTEXT CHAR 20 0
WRBTR Amount in document currency WRBTR CURR 13 2
WMWST Tax amount in document currency WMWST CURR 13 2
XDETA Indicator: display detail screen XDETA CHAR 1 0
X Yes
NULL No
XLBPD Price difference posting in GR for subcontract oder XLBPD CHAR 1 0
X Yes
NULL No
XMWST Calculate tax automatically XMWST CHAR 1 0
X Yes
NULL No
XPRUE Indicator: check item XPRUE CHAR 1 0
X Yes
NULL No
ZUONR Assignment Number DZUONR CHAR 18 0
WEREC Clearing Indicator for GR/IR Posting for External Services MMWEREC CHAR 1 0
X Yes
NULL No
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
BKLAS Valuation Class BKLAS CHAR 4 0
BLART Document Type BLART CHAR 2 0
BNKAN_FW Delivery costs' share of item value BNK_ANTEIL CURR 13 2
BNKAN_HW Delivery costs share in local currency BNK_AN_HW CURR 13 2
BUSTW Posting string for values BUSTW CHAR 4 0
BWAER Currency Key WAERS CUKY 5 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
EPSTP Item Category in Purchasing Document EPSTP CHAR 1 0
GRICD Activity Code for Gross Income Tax J_1AGICD_D J_1AGICD CHAR 2 0
GRIRG Region (State, Province, County) REGIO T005S CHAR 3 0
GITYP Distribution Type for Employment Tax J_1ADTYP_D J_1ADTYP CHAR 2 0
HKMAT Material-related origin HKMAT CHAR 1 0
NULL No material-related origin
X Keep costs/quantities under material number
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 0
HSWAE Local currency key HSWAE CUKY 5 0
KURSF Exchange rate KURSF DEC 9 5
LBKUM Total Valuated Stock LBKUM QUAN 13 3
MARV_LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
MARV_LFMON Current period (posting period) LFMON NUMC 2 0
MATBF Material in Respect of Which Stock is Managed MATBF CHAR 18 0
MONAT Fiscal Period MONAT NUMC 2 0
NAV_FW Non-Deductible Input Tax (in Document Currency) NAVFW CURR 13 2
NAV_HW Non-Deductible Input Tax (in Local Currency) NAVHW CURR 13 2
FWSTE Tax Amount in Document Currency FWSTE CURR 13 2
NRWFW Net invoice value (incl. discount + tax adjustment) in FC NRWFW CURR 13 2
NRWHW Net invoice value (incl. disc. and n.d. tax adjustm.) in LC NRWHW CURR 13 2
PERIV Fiscal Year Variant PERIV CHAR 2 0
RBLGP Document Item in Invoice Document RBLGP NUMC 6 0
RBLGPK Document Item in Invoice Document RBLGP NUMC 6 0
SALK3 Value of Total Valuated Stock SALK3 CURR 13 2
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
SKONTO_FW Cash discount amount in document currency WSKTO CURR 13 2
SKONTO_HW Cash discount amount in local currency SKNTO CURR 13 2
VMSAL Value of total valuated stock in previous period VMSAL CURR 13 2
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VRKUM Total valuated stock in the previous posting period VRKUM QUAN 13 3
VWALT Amount posted in alternative price control BUALT CURR 13 2
VWERR Amount in Local Currency DMBTR CURR 13 2
VWERT Amount in Local Currency DMBTR CURR 13 2
WAART Indicates that material is a value-only material WAART CHAR 1 0
X Yes
NULL No
XEKBE Indicator: update purchase order history XEKBE CHAR 1 0
X Yes
NULL No
XEKBZ Indicator: Update Purchase Order Delivery Costs XEKBZ CHAR 1 0
X Yes
NULL No
XLIFO LIFO/FIFO-Relevant XLIFO CHAR 1 0
X LIFO and FIFO Relevant
NULL Not LIFO/FIFO Relevant
1 LIFO-relevant
2 FIFO-relevant
3 LIFO- and FIFO-relevant (obsolete)
XRUEJ Indicator: post to previous year XRUEJ CHAR 1 0
X Yes
NULL No
XRUEM Allow Posting to Previous Period (Backposting) XRUEM CHAR 1 0
X Yes
NULL No
XVKBW Sales price valuation active XVKBW CHAR 1 0
X Yes
NULL No
XVPAS Indicates price variance distributed for structured material XVPAS CHAR 1 0
X Yes
NULL No
BDIFP Stock correction tolerance BDIFP DEC 5 2
BUPLA Business Place BUPLA CHAR 4 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MJAHR Material Document Year MJAHR NUMC 4 0
MBLPO Item in Material Document MBLPO NUMC 4 0
KNUMVK Number of the document condition KNUMV CHAR 10 0
KNUMV Number of the document condition KNUMV CHAR 10 0
KNUMVR Number of the document condition KNUMV CHAR 10 0
SATNR Cross-Plant Configurable Material SATNR MARA CHAR 18 0
EAN11 International Article Number (EAN/UPC) EAN11 CHAR 18 0
IDNLF Material Number Used by Vendor IDNLF CHAR 35 0
AKTNR Promotion WAKTION WAKH CHAR 10 0
UPVOR Subitems Exist UPVOR CHAR 1 0
UPTYP Subitem Category, Purchasing Document UPTYP TMSI1 CHAR 1 0
UEBPO Higher-Level Item in Purchasing Documents UEBPO EKPO NUMC 5 0
SRVPOS Service number SRVPOS CHAR 18 0
PACKNO Package Number of Service PACKNO_EKBE NUMC 10 0
INTROW Line Number of Service INTROW_EKBE NUMC 10 0
LEBRE Indicator for Service-Based Invoice Verification LEBRE CHAR 1 0
X Yes
NULL No
BEKKN Number of PO Account Assignment BEKKN NUMC 2 0
PLN_PACKNO Source package number PLN_PACKNO NUMC 10 0
PLN_INTROW Entry: Planned package line PLN_INTROW NUMC 10 0
LIEFFN Vendor error (exclusive of tax) LIEFFN CURR 13 2
RBWWR Invoice amount in document currency of vendor invoice RBWWR CURR 13 2
RBMNG Qty invoiced in vendor invoice in PO order units RBMNG QUAN 13 3
BPRBM Qty invoiced in vendor invoice in PO price units BPRBM QUAN 13 3
KZMEK Correction indicator KZMEKORR CHAR 1 0
NULL No error
1 Unclarified error: park invoice
2 Vendor error: reduce invoice
MENGEALT Quantity MENGE_D QUAN 13 3
BPMNGALT Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
WRBTRALT Amount in document currency WRBTR CURR 13 2
XUPDA Select MARKE CHAR 1 0
EFKOR Type of correction to own error EFKOR CHAR 1 0
NULL No error correction
1 Price correction
2 Condition correction
3 Price and condition correction
LFKOR Type of vendor error LFEHL CHAR 1 0
NULL No vendor error
1 Price error
2 Conditions error
3 Quantity error
4 Quantity error + price error
5 Quantity error + condition error
OK Indicator: invoice item processed MRMOK CHAR 1 0
X Yes
NULL No
COMPLAINT_REASON Complaints Reason in an Invoice COMPLAINT_REASON CHAR 2 0
EKOND Condition correction status STKORR CHAR 1 0
X Yes
NULL No
LKOND Condition correction status STKORR CHAR 1 0
X Yes
NULL No
COWWR Condition Correction Value in Foreign Currency COWWR CURR 13 2
TEILZ Partial payment possible for service TEILZ CHAR 1 0
X Yes
NULL No
VORNR Operation/Activity Number VORNR CHAR 4 0
STATUS Name of an Icon ICONNAME CHAR 30 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
BSCHL Posting Key BSCHL CHAR 2 0
SWENR Site Number SWENR CHAR 8 0
SGENR Building Number SGENR CHAR 8 0
SGRNR Property Number for BE SGRNR CHAR 8 0
SMENR Number of Rental Unit SMENR CHAR 8 0
SMIVE Lease-Out Number SMIVE CHAR 13 0
SNKSL Service Charge Key SNKSL CHAR 4 0
SEMPSL Settlement Unit SEMPSL CHAR 5 0
SVWNR Management Contract Number VVSVWNR CHAR 13 0
RECNNR Real Estate Contract Number RECNNR CHAR 13 0
SBERI Correction item number SBERI CHAR 10 0
TCNO RE-FX: Number of Correction Object VVREITTCNO CHAR 16 0
ENQUEUE_REQUIRED Boolean Variable (X=True, -=False, Space=Unknown) BOOLEAN CHAR 1 0
X true
- false
NULL unknown
ENQUEUE_GRANTED Boolean Variable (X=True, -=False, Space=Unknown) BOOLEAN CHAR 1 0
X true
- false
NULL unknown
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
ERLKZ Used earmarked funds set to "Complete" REFSETERLK CHAR 1 0
NULL Not Selected
X Selected
FIKRS Financial Management Area FIKRS CHAR 4 0
PARGB Trading partner's business area PARGB CHAR 4 0
STOCK_POSTING Stock Posting of Line from an Incoming Invoice STOCK_POSTING CURR 13 2
STOCK_POSTING_PP Stock Posting of Line from an Incoming Invoice, Prev. Period STOCK_POSTING_PP CURR 13 2
STOCK_POSTING_PY Stock Posting of Line from an Incoming Invoice, Prev. Year STOCK_POSTING_PY CURR 13 2
MWART Tax Type MWART CHAR 1 0
A Output tax
V Input tax
FWBAS Tax Base Amount in Document Currency FWBAS CURR 13 2
HWBAS Tax Base Amount in Local Currency HWBAS CURR 13 2
WEBUD Goods receipt posting date WEBUD DATS 8 0
MAT_PSPNR Valuated Sales Order Stock WBS Element MAT_PSPNR NUMC 8 0
MAT_KDAUF Sales Order Number of Valuated Sales Order Stock MAT_KDAUF CHAR 10 0
MAT_KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6 0
UNPL_REMNG Quantity invoiced REMNG QUAN 13 3
XPL99 Checkbox XFELD CHAR 1 0
X Yes
NULL No
UNPL_REFWR Invoice value in foreign currency REFWR CURR 13 2
VARIANCE_TYPE Possible Variance Types in an Invoice MRM_VARIANCE_TYPE CHAR 2 0
ABPER Settlement period ABPER_RF ACCP 6 0
LEDAT Delivery Creation Date LEDAT DATS 8 0
C_RBLGP Document Item in Invoice Document RBLGP NUMC 6 0
C_KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
C_MATNR Material Number MATNR CHAR 18 0
DUMMY2 Checkbox XFELD CHAR 1 0
X Yes
NULL No
FASTPAY PPA Fast Pay Indicator FMFG_FASTPAY_FLG CHAR 1 0
X Yes
NULL No
PPA_EX_IND PPA Exclude Indicator EXCLUDE_FLG CHAR 1 0
X Yes
NULL No
PEROP_BEG Period of Performance Start FM_PEROP_LIV_LOW DATS 8 0
PEROP_END Period of Performance End FM_PEROP_LIV_HIGH DATS 8 0
DUMMY3 Checkbox XFELD CHAR 1 0
X Yes
NULL No
MENGE_F Quantity (Floating Point Number - Internal Field) MENGE_F FLTP 16 16
BPMNG_F Quantity (Floating Point Number - Internal Field) MENGE_F FLTP 16 16
RETAMT_FC Retention Amount in Document Currency RET_AMT_FC CURR 13 2
RETAMT_LC Retention Amount in Company Code Currency RET_AMT_LC CURR 13 2
RETDUEDT Due Date for Retention RET_DUE_DATE DATS 8 0
RETCHG Retention Data Changeable RET_CHG CHAR 1 0
X Yes
NULL No
RETDUEDT_MAND Due Date is Required Field RET_DUEDT_MAND CHAR 1 0
XRETTAXNET Tax Reduction for Retention RET_TAXNET CHAR 1 0
X Yes
NULL No
XRET_NO_CDB Do Not Change Cash Discount Base (Retention) RET_NO_CDB CHAR 1 0
X Yes
NULL No
RETTXAMT_FC Tax Portion of Retention in Document Currency RET_TXAMT_FC CURR 13 2
RE_ACCOUNT Cash Ledger: Expense or Revenue Account FAGL_RE_ACCOUNT CHAR 10 0
MSR_ID Process Identification Number MSR_PROCESS_ID CHAR 10 0
DEVIATION Credit Deviation MSR_FIN_DEVIATION CHAR 1 0
X Yes
NULL No
ERP_CONTRACT_ID Number of Principal Purchase Agreement KONNR CHAR 10 0
ERP_CONTRACT_ITM Item Number of Principal Purchase Agreement KTPNR NUMC 5 0
SRM_CONTRACT_ID Central Contract SRM_CONTRACT_ID CHAR 10 0
SRM_CONTRACT_ITM Central Contract Item Number SRM_CONTRACT_ITEM NUMC 10 0
EVART Agreement Type EVART CHAR 4 0
KTWRT Target Value for Header Area per Distribution KTWRT CURR 15 2
KTMNG Target Quantity KTMNG QUAN 13 3
REL_VALUE Release Value of Contract REL_VALUE CURR 15 2
REL_QUANT Release Quantity of Contract Item REL_QUANTITY QUAN 13 3
CONT_SERV_TEXT Contract Item or Service Text MRM_TEXT CHAR 40 0
CONT_PSTYP Item Category in Purchasing Document PSTYP CHAR 1 0
CONT_KDATB Start of Validity Period KDATB DATS 8 0
CONT_KDATE End of Validity Period KDATE DATS 8 0
QUNUM Number of Quota Arrangement QUNUM CHAR 10 0
QUPOS Quota Arrangement Item QUPOS NUMC 3 0
CONT_NETPR Net Price in Purchasing Document (in Document Currency) BPREI CURR 11 2
SRVMAPKEY Item Key for eSOA Messages SRVMAPKEY NUMC 10 0
XCONTRACT_PO Contract from Limit Purchase Order Item XCONTRACT_PO CHAR 1 0
X Yes
NULL No
XCONT_DIRECT_REF Invoice Item with Direct Contract Reference XCONT_DIRECT_REF CHAR 1 0
X Yes
NULL No
XPRICE_DETERMNTN New Price Determination for Item with Contract Reference XPRICE_DETERMINATION CHAR 1 0
X Yes
NULL No
XPLANT_CHANGEABL Plant Can Be Changed XPLANT_CHANGEABLE CHAR 1 0
X Yes
NULL No
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
CONT_REFWR Invoice value in foreign currency REFWR CURR 13 2
INV_ITM_ORIGIN Origin of an Invoice Item INV_ITM_ORIGIN CHAR 1 0
NULL Inv.Ver.: Item Newly Created
A Diff.Inv.: Item Newly Created
B Diff.Inv.: Item Copied from Preceding Invoice
DIFF_AMOUNT Difference Amount (in Document Currency) DIFFERENCE_AMOUNT CURR 13 2
CPE_GUID_E Globally Unique Identifier GUID RAW 16 0
CPE_GUID_L Globally Unique Identifier GUID RAW 16 0
COMPARISON_VALUE Comparison Value for Tolerance Check COMPARISON_VALUE CURR 13 2
XUSE_COMPARISON_VALUE Use Ext. Comparison Value Indicator for Tolerance Check XUSE_COMPARISON_VALUE CHAR 1 0
X Yes
NULL No
INVREL Grouping Characteristic for Invoice Verification INVREL NUMC 6 0
KURSX Market Data Exchange Rate GLE_FXR_DTE_RATEX28 DEC 28 14
EBELN_DCFL Purchase Order Number (Source System) DCFL_EBELN CHAR 35 0
LOGSYS_DCFL Logistics Source System DCFL_LOGSYS CHAR 10 0
LONGNUM Smart Number /SAPPSPRO/LONGNUM CHAR 40 0
LICNO Internal License Number J_1ILICNO NUMC 10 0
ZEILE Item Number J_1IZEILE NUMC 4 0
OINEGPSTG Negative posting line (exchange fees) OIA_NGPSTL CHAR 1 0
X Yes
NULL No
KBETR Rate (condition amount or percentage) KBETR CURR 11 2
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)
KPEIN Condition pricing unit KPEIN 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
OICONDWAERS Currency Key WAERS CUKY 5 0
OIA_SPLTIV Indicator for split invoice verification OIA_SPLTIV CHAR 1 0
NULL No split invoice verification
X Split invoice verification
OIINVCYC Invoice cycle OIA_INVCYC NUMC 1 0
OIA_ZTERM Terms of Payment Key DZTERM CHAR 4 0

DRSEG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DRSEG AKTNR WAKH MANDT WAKH Promotion Header Data, IS-R MANDT
DRSEG AKTNR DRSEG AKTNR WAKH Promotion Header Data, IS-R AKTNR
DRSEG EHTYP SYST MANDT TMSRM_EHTYP SRM Hierarchy Types MANDT
DRSEG EHTYP DRSEG EHTYP TMSRM_EHTYP SRM Hierarchy Types EHTYP
DRSEG ETYPE DRSEG ETYPE T8JG Valid Investment Group ETYPE
DRSEG ETYPE * T8JG Valid Investment Group FDATE
DRSEG ETYPE SYST MANDT T8JG Valid Investment Group MANDT
DRSEG ETYPE GJV_OBJDAT BUKRS T8JG Valid Investment Group BUKRS
DRSEG ETYPE DRSEG VNAME T8JG Valid Investment Group VNAME
DRSEG GITYP T000 MANDT J_1ADTYP Distribution Types for Gross Income Tax MANDT
DRSEG GITYP RBKPV BUKRS J_1ADTYP Distribution Types for Gross Income Tax BUKRS
DRSEG GITYP DRSEG GITYP J_1ADTYP Distribution Types for Gross Income Tax J_1ADTYP
DRSEG GRICD RM08M LAND1 J_1AGICD Activity codes for gross income tax declaration LAND1
DRSEG GRICD DRSEG GRICD J_1AGICD Activity codes for gross income tax declaration J_1AGICD
DRSEG GRICD T000 MANDT J_1AGICD Activity codes for gross income tax declaration MANDT
DRSEG GRIRG RM08M LAND1 T005S Taxes: Region (Province) Key LAND1
DRSEG GRIRG DRSEG GRIRG T005S Taxes: Region (Province) Key BLAND
DRSEG GRIRG T000 MANDT T005S Taxes: Region (Province) Key MANDT
DRSEG INCO1 SY MANDT TINC Customers: Incoterms MANDT
DRSEG INCO1 DRSEG INCO1 TINC Customers: Incoterms INCO1
DRSEG MWSKZ T007A KALSM T007A Tax Keys KALSM
DRSEG MWSKZ DRSEG MWSKZ T007A Tax Keys MWSKZ
DRSEG MWSKZ T007A MANDT T007A Tax Keys MANDT
DRSEG SATNR MARA MANDT MARA General Material Data MANDT
DRSEG SATNR DRSEG SATNR MARA General Material Data MATNR
DRSEG UEBPO DRSEG UEBPO EKPO Purchasing Document Item EBELP
DRSEG UEBPO EKPO MANDT EKPO Purchasing Document Item MANDT
DRSEG UEBPO EKPO EBELN EKPO Purchasing Document Item EBELN
DRSEG UPTYP DRSEG UPTYP TMSI1 Sub-Item Category in Purchasing UPTYP
DRSEG UPTYP TMSI1 MANDT TMSI1 Sub-Item Category in Purchasing MANDT
DRSEG ZZREGION SYST MANDT ZREG User Defined Regions MANDT
DRSEG ZZREGION DRSEG ZZREGION ZREG User Defined Regions ZZREGION
DRSEG ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
DRSEG ZZSPREG DRSEG ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
DRSEG ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
DRSEG ZZSTATE * T005S Taxes: Region (Province) Key LAND1
DRSEG ZZSTATE DRSEG ZZSTATE T005S Taxes: Region (Province) Key BLAND
DRSEG ZZUSERFLD1 DRSEG ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1
DRSEG ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT