S431 SAP table for – PURCHIS: (OIL-TSW) Purchasing document stats by TSW object

Here we would like to draw your attention to S431 table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). S431 is a SAP standard transp table used for storing PURCHIS: (OIL-TSW) Purchasing document stats by TSW object related data in SAP. It comes under the package OIJ.

SAP S431 table

Table S431 technical data

TableS431
Data storingPURCHIS: (OIL-TSW) Purchasing document stats by TSW object
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP S431 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in S431 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SSOUR : Statistic(s) origin
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VRSIO : Version number in the information structure
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • TSYST : Transport system
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • LOCID : Location ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • EBELN : Purchasing Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • ETENR : Delivery Schedule Line Counter
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • VWDAT : Pointer to administrative data
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BASME : Order unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • LGORT : Storage location
    Its data type is CHAR (Character String) with field length 4
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • LIFN2 : Reference to other vendor
    Its data type is CHAR (Character String) with field length 10
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • MENGE : Purchase order quantity
    Its data type is QUAN (Quantity field) with field length 15
  • WEMNG : Quantity of goods received
    Its data type is QUAN (Quantity field) with field length 15
  • WEMGM : Goods receipt qty in base unit (calculate wtd.delivery time)
    Its data type is QUAN (Quantity field) with field length 15
  • REMNG : Invoice receipt quantity
    Its data type is QUAN (Quantity field) with field length 15
  • LSMNG : Target delivery quantity in base unit of measure
    Its data type is QUAN (Quantity field) with field length 15
  • NETWR : Effective order value
    Its data type is CURR (Currency Field) with field length 15
  • REWRT : Invoice Amount
    Its data type is CURR (Currency Field) with field length 15
  • ABSTE : Number of purchase order item schedule lines
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VKTRA : Mode of transport
    Its data type is CHAR (Character String) with field length 2
  • BEDAT : Purchase Order Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EINDT : Item delivery date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OIJMTI : OIL-TSW: TSW mode of transport indicator
    Its data type is CHAR (Character String) with field length 1
  • CHARG : Batch / Valuation type
    Its data type is CHAR (Character String) with field length 10
  • VBTYP : TSW Details document type
    Its data type is CHAR (Character String) with field length 1
  • BSART : Order Type (Purchasing)
    Its data type is CHAR (Character String) with field length 4
  • RESWK : Supplying (issuing) plant in case of stock transport order
    Its data type is CHAR (Character String) with field length 4
  • SITYP : Schedule type
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Additional fields for data transfer from TSW details to whif
  • NMSHIPPER : Shipper
    Its data type is CHAR (Character String) with field length 10
  • NMCARRIER : Transport system Carrier
    Its data type is CHAR (Character String) with field length 10
  • UNLIMITED : Indicator: Unlimited Overdelivery Allowed
    Its data type is CHAR (Character String) with field length 1
  • ITBOTOL : Quantity tolerance over (percentage)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • ITBUTOL : Quantity tolerance under (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • PLANLOC : Location ID
    Its data type is CHAR (Character String) with field length 10
  • PARTNR : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • CONPAT : Contract Partner
    Its data type is CHAR (Character String) with field length 10
  • FROMDATE : OIL-TSW: Deal validity From date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TODATE : OIL-TSW: Deal validity To date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SOLDTO : Customer Sold-to or Vendor
    Its data type is CHAR (Character String) with field length 10