S431 - PURCHIS: (OIL-TSW) Purchasing document stats by TSW object
PURCHIS: (OIL-TSW) Purchasing document stats by TSW object information is stored in SAP table S431.
It is part of development package OIJ in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Traders and Schedulers Workbench".
It is part of development package OIJ in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Traders and Schedulers Workbench".
Fields for table S431
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | P44V |
| TSYST | Transport system | X | OIJ_TSYST | CHAR | 20 | OIJTS |
| LOCID | Location ID | X | OIJ_LOCID | CHAR | 20 | OIJLOC |
| EBELN | Purchasing Document Number | X | EBELN | CHAR | 20 | EKKO |
| EBELP | Item Number of Purchasing Document | X | EBELP | NUMC | 10 | EKPO |
| ETENR | Delivery Schedule Line Counter | X | EETEN | NUMC | 8 | EKET |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| HWAER | Local Currency | HWAER | CUKY | 10 | TCURC | |
| BASME | Purchase Order Unit of Measure | BSTME | UNIT | 6 | T006 | |
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| LGORT | Storage location | LGORT_D | CHAR | 8 | T001L | |
| LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | LFA1 | |
| LIFN2 | Reference to other supplier | LIFN2 | CHAR | 20 | LFA1 | |
| MATNR | Material Number | MATNR | CHAR | 80 | MARA | |
| MENGE | Purchase order quantity | MC_MENGE | QUAN | 8 | ||
| WEMNG | Quantity of goods received | MC_WEMNG | QUAN | 8 | ||
| WEMGM | Goods receipt qty in base unit (calculate wtd.delivery time) | MC_WEMGMAX | QUAN | 8 | ||
| REMNG | Invoice receipt quantity | MC_REMNG | QUAN | 8 | ||
| LSMNG | Target delivery quantity in base unit of measure | MC_LSMNG | QUAN | 8 | ||
| NETWR | Effective order value | MC_EFFWR | CURR | 8 | ||
| REWRT | Invoice Amount | MC_REWRT | CURR | 8 | ||
| ABSTE | Number of purchase order item schedule lines | MC_ABSTE | DEC | 5 | ||
| AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
| VKTRA | Mode of Transport | VKTRA | CHAR | 4 | TVTR | |
| BEDAT | Purchase Order Date | BEDAT | DATS | 16 | ||
| ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
| EINDT | Item delivery date | EINDT | DATS | 16 | ||
| OIJMTI | OIL-TSW: TSW mode of transport indicator | OIJ_TSWMTI | CHAR | 2 | ||
| CHARG | Batch / Valuation type | OIJ_CHARG | CHAR | 20 | ||
| VBTYP | TSW Details document type | OIJ_EL_VBTYP | CHAR | 8 | ||
| BSART | Order Type (Purchasing) | BSART | CHAR | 8 | ||
| RESWK | Supplying (issuing) plant in case of stock transport order | RESWK | CHAR | 8 | ||
| SITYP | Schedule type | OIJ_SITYP | CHAR | 4 | ||
| .INCLUDE | ROIJ_RDDOC_ADDS | 0 | ||||
| NMSHIPPER | Shipper | OIJ_SHIPNR | CHAR | 20 | ||
| NMCARRIER | Transport system Carrier | OIJ_CARRNR | CHAR | 20 | ||
| UNLIMITED | Unlimited Overdelivery Allowed | UEBTK | CHAR | 2 | ||
| ITBOTOL | Quantity tolerance over (percentage) | OIJ_BOTOL | DEC | 3 | ||
| ITBUTOL | Quantity tolerance under (%) | OIJ_BUTOL | DEC | 3 | ||
| PLANLOC | Location ID | OIJ_LOCID | CHAR | 20 | ||
| PARTNR | Location Partner | OIJ_PARTNR | CHAR | 20 | ||
| CONPAT | Contract Partner | OIJ_CONPAT | CHAR | 20 | ||
| FROMDATE | OIL-TSW: Deal validity From date | OIJ_FROMDATE | DATS | 16 | ||
| TODATE | OIL-TSW: Deal validity To date | OIJ_TODATE | DATS | 16 | ||
| SOLDTO | Customer Sold-to or Vendor | OIJ_SOLDTO | CHAR | 20 |