S431

PURCHIS: (OIL-TSW) Purchasing document stats by TSW object | #transactional | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO FK Version number in the information structure
TSYST FK Transport system
LOCID FK Location ID
EBELN FK Purchasing Document Number
EBELP FK Item Number of Purchasing Document
ETENR FK Delivery Schedule Line Counter
Column Name Description
💲 Local Currency (HWAER):
NETWR Effective order value
REWRT Invoice Amount
Column Name Description
📏 Purchase Order Unit of Measure (BASME):
MENGE Purchase order quantity
WEMNG Quantity of goods received
WEMGM Goods receipt qty in base unit (calculate wtd.delivery time)
REMNG Invoice receipt quantity
LSMNG Target delivery quantity in base unit of measure
Column Name Description
AEDAT Last Changed On
BEDAT Purchase Order Date
ERDAT Date on which the record was created
EINDT Item delivery date
FROMDATE OIL-TSW: Deal validity From date
TODATE OIL-TSW: Deal validity To date
Column Name Description
OIJMTI OIL-TSW: TSW mode of transport indicator Show values
VBTYP TSW Details document type Show values
UNLIMITED Unlimited Overdelivery Allowed Show values
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
ABSTE Number of purchase order item schedule lines MCZAEHLER
CHARG Batch / Valuation type CHARG
BSART Order Type (Purchasing) BSART
RESWK Supplying (issuing) plant in case of stock transport order WERKS
SITYP Schedule type OIJ_SITYP
NMSHIPPER Shipper LIFNR
NMCARRIER Transport system Carrier LIFNR
ITBOTOL Quantity tolerance over (percentage) DEC3_1
ITBUTOL Quantity tolerance under (%) DEC3_1
PLANLOC Location ID OIJ_LOCID
PARTNR Location Partner OIJ_PARTNR
CONPAT Contract Partner OIJ_PARTNR
SOLDTO Customer Sold-to or Vendor OIJ_SOLDTO
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • S431.MANDT == T006.MANDT
  • S431.BASME == T006.MSEHI
Local Currency
  • S431.MANDT == TCURC.MANDT
  • S431.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S431.LGORT == T001L.LGORT
  • S431.MANDT == T001L.MANDT
  • S431.WERKS == T001L.WERKS
Reference to other supplier
  • S431.MANDT == LFA1.MANDT
  • S431.LIFN2 == LFA1.LIFNR
Account Number of Supplier
  • S431.MANDT == LFA1.MANDT
  • S431.LIFNR == LFA1.LIFNR
Location ID
Client S431.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S431.MATNR == MARA.MATNR
  • S431.MANDT == MARA.MANDT
Transport system
  • S431.MANDT == OIJTS.MANDT
  • S431.TSYST == OIJTS.TSYST
Mode of Transport
  • S431.MANDT == TVTR.MANDT
  • S431.VKTRA == TVTR.VKTRA
Version number in the information structure
  • Statistic(s) origin
  • Version number in the information structure
  • ?
  • S431.MANDT == P44V.MANDT
  • S431.SSOUR == P44V.SSOUR
  • S431.VRSIO == P44V.VRSIO
  • S431.[column in domain "GSTRU"] == P44V.GSTRU
Plant
  • S431.MANDT == T001W.MANDT
  • S431.WERKS == T001W.WERKS