1. Home
  2. Resources
  3. SAP Tables
  4. ARSEG - Work Structure for Releasing Invoices

SAP Table ARSEG

Work Structure for Releasing Invoices

ARSEG (Work Structure for Releasing Invoices) 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 ARSEG to other SAP tables.

ARSEG table fields

Field Data element Checktable Datatype Length Decimals
STATUS Name of an Icon ICONNAME CHAR 30 0
BELNR Document Number of an Invoice Document RE_BELNR CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
WAERS Currency Key WAERS CUKY 5 0
WWERT Translation Date WWERT_D DATS 8 0
KURSF Exchange rate KURSF DEC 9 5
HSWAE Local currency key HSWAE CUKY 5 0
BLART Document Type BLART CHAR 2 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BUKRS Company Code BUKRS CHAR 4 0
LIFNR Different Invoicing Party LIFRE CHAR 10 0
NAME1_LIFNR Name 1 AD_NAME1 CHAR 40 0
USNAM User name USNAM CHAR 12 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZLSPR Payment Block Key DZLSPR CHAR 1 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
MRM_ZLSPR Logistics payment block MRM_ZLSPR CHAR 1 0
A Automatically blocked due to existence of blocking reasons
S Stochastically blocked
M Manual payment block set in header - no blocking reasons
W Automatically blocked due to entry via Web Invoice
MRM_ZLSPR_NEW Logistics payment block MRM_ZLSPR CHAR 1 0
A Automatically blocked due to existence of blocking reasons
S Stochastically blocked
M Manual payment block set in header - no blocking reasons
W Automatically blocked due to entry via Web Invoice
BUZEI Document Item in Invoice Document RBLGP NUMC 6 0
WRBTR Amount in document currency WRBTR CURR 13 2
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
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
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D CHAR 4 0
EKGRP Purchasing Group BKGRP CHAR 3 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
XEKBZ Indicator: Update Purchase Order Delivery Costs XEKBZ CHAR 1 0
X Yes
NULL No
KSCHL Condition Type KSCHL CHAR 4 0
SSQSS QA Control Key SSQSS CHAR 8 0
MENGE Quantity MENGE_D QUAN 13 3
BSTME Purchase Order Unit of Measure BSTME UNIT 3 0
TBTKZ Indicator: subsequent debit/credit TBTKZ CHAR 1 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
SPGRC Block.reason: quality SPGRC CHAR 1 0
X Yes
NULL No
SPGRS Blocking Reason: Item Amount SPGRS CHAR 1 0
X Yes
NULL No
SPGRT Blocking Reason: Date SPGRT CHAR 1 0
X Yes
NULL No
SPGRQ Manual Blocking Reason SPGRQ CHAR 1 0
X Yes
NULL No
SPGREXT Blocking Reason Enhancement Fields SPGREXT CHAR 1 0
X Yes
NULL No
SPGRG_NEW Blocking reason: order price quantity SPGRG CHAR 1 0
X Yes
NULL No
SPGRM_NEW Blocking reason: quantity SPGRM CHAR 1 0
X Yes
NULL No
SPGRP_NEW Blocking reason: price SPGRP CHAR 1 0
X Yes
NULL No
SPGRC_NEW Block.reason: quality SPGRC CHAR 1 0
X Yes
NULL No
SPGRS_NEW Blocking Reason: Item Amount SPGRS CHAR 1 0
X Yes
NULL No
SPGRT_NEW Blocking Reason: Date SPGRT CHAR 1 0
X Yes
NULL No
SPGRQ_NEW Manual Blocking Reason SPGRQ CHAR 1 0
X Yes
NULL No
SPGREXT_NEW Blocking Reason Enhancement Fields SPGREXT CHAR 1 0
X Yes
NULL No
SPGRM_INV Blocking reason: quantity SPGRM CHAR 1 0
X Yes
NULL No
SPGRP_INV Blocking reason: price SPGRP CHAR 1 0
X Yes
NULL No
SPGRT_INV Blocking Reason: Date SPGRT CHAR 1 0
X Yes
NULL No
SPGRC_INV Block.reason: quality SPGRC CHAR 1 0
X Yes
NULL No
SPGREXT_INV Blocking Reason Enhancement Fields SPGREXT_INV CHAR 1 0
NULL No Change
X Blocking Reason No Longer Valid
P Blocking Reason Must Be Retained
DMENG Difference Quantity DMENG QUAN 13 3
DTAGE Difference days DTAGE DEC 3 0
DWERT Difference Value DWERT CURR 13 2
X_CHANGED New Input Values XFLAG CHAR 1 0
NULL Blank
. Radio button
X Selection
X_TEXT Indicator: Object has a Note XNOTE CHAR 1 0
X Yes
NULL No
X_INCOMPLETE New Input Values XFLAG CHAR 1 0
NULL Blank
. Radio button
X Selection
PACKNO Package Number of Service PACKNO_EKBE NUMC 10 0
INTROW Line Number of Service INTROW_EKBE NUMC 10 0
ICON_SPGRG Blocking Reason Order Price Quantity (Icon) ICON_SPGRG CHAR 30 0
ICON_SPGRM Blocking Reason Quantity (Icon) ICON_SPGRM CHAR 30 0
ICON_SPGRP Blocking Reason Price (Icon) ICON_SPGRP CHAR 30 0
ICON_SPGRC Blocking Reason Quality (Icon) ICON_SPGRC CHAR 30 0
ICON_SPGRS Blocking Reason Amount (Icon) ICON_SPGRS CHAR 30 0
ICON_SPGRT Blocking Reason Date (Icon) ICON_SPGRT CHAR 30 0
ICON_SPGRQ Indicator: Manual Blocking Reason (Icon) ICON_SPGRQ CHAR 30 0
ICON_SPGREXT Blocking Reason Enhancement Fields (Icon) ICON_SPGREXT CHAR 30 0
TM_PUSH_BUTTON Display Document Details (Transportation Mgmt) ERPTMS_ICON_DETAILS CHAR 30 0
CLIENT Client MANDT CLNT 3 0
PO_ID Purchasing Document Number EBELN CHAR 10 0
PO_ITEM Item Number of Purchasing Document EBELP NUMC 5 0
TOR_ID Freight Order ERPTMS_TOR_ID CHAR 20 0
TOR_ITEM Freight Order Item ERPTMS_TOR_ITEM CHAR 10 0
TSP_ID Business Partner ERPTMS_PARTY_ID CHAR 10 0
BOL_ID Bill of Lading ERPTMS_BOL_ID CHAR 35 0
AWB_ID Air Waybill ERPTMS_AWB_ID CHAR 35 0
FLIGHT_ID Flight Number ERPTMS_FLIGHT_ID CHAR 7 0
VOYAGE_ID Voyage Number ERPTMS_VOYAGE_ID CHAR 10 0
SFIR_ID Freight Settlement Document ERPTMS_SFIR_ID CHAR 20 0
SFIR_ITEM Item Freight Settlement Document ERPTMS_SFIR_ITEM CHAR 10 0
IVP_ID Business Partner ERPTMS_PARTY_ID CHAR 10 0
LOGSYS Logical system LOGSYS CHAR 10 0
SRCE_LOC Source Location ERPTMS_SRCE_LOC CHAR 20 0
DEST_LOC Destination Location ERPTMS_DEST_LOC CHAR 20 0
DEL_D Delivery Date ERPTMS_DELV_D DATS 8 0
PICKUP_D Pick-Up Date ERPTMS_PICKUP_D DATS 8 0
CPUDT Entry date SYDAT_EB DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
FREIGHTAGRMT_ID Freight Agreement ERPTMS_FRAGR_ID CHAR 20 0
LOADING_METER Loading Meter ERPTMS_LOAD_METER DEC 19 6
DISTANCE Distance ERPTMS_DISTANCE QUAN 31 14
DIST_UOM Distance Unit of Measure ERPTMS_DISTANCE_UOM UNIT 3 0
SHIPPER Shipper ERPTMS_SHIPPER CHAR 40 0
CONSIGNEE Consignee ERPTMS_CONSIGNEE CHAR 40 0
VEHICLE_ID Vehicle ERPTMS_VEHICLE_ID CHAR 40 0
EQUIPMENT_TYPE Equipment Type ERPTMS_EQUI_TYPE CHAR 10 0
PRICING_IND Pricing Indicator (Credit/Debit) ERPTMS_PRICING_IND CHAR 1 0
X true
- false
NULL unknown
CHRG_DUE_CODE Charges Due Code ERPTMS_CHRG_DUE_CODE CHAR 2 0
SRCE_CTRY Departure country (country from which the goods are sent) ALAND CHAR 3 0
DEST_CTRY Country of Destination LLAND CHAR 3 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
XDINV Indicator for Differential Invoicing XDINV CHAR 1 0
XCPRF Checkbox for Commodity Repricing in Invoice Verification XCPRF CHAR 1 0
WAERS_DWERT Currency Key WAERS CUKY 5 0
/CWM/BPMNG Quantity in Purchase Order Price Unit BPMNG QUAN 13 3
/CWM/BPRME Order Price Unit (Purchasing) BPRME UNIT 3 0
/CWM/DBPMN Difference Quantity DMENG QUAN 13 3
SPGRS_INV Blocking Reason: Item Amount SPGRS CHAR 1 0
X Yes
NULL No
SPGRQ_INV Manual Blocking Reason SPGRQ CHAR 1 0
X Yes
NULL No