SAP Table S012BIW1
S012BIW1 * Purchasing
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table S012BIW1 (S012BIW1 * Purchasing) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S012BIW1 |
| Short Text | S012BIW1 * Purchasing |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S012BIW1
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| EKORG | ✔ | Purchasing Organization | EKORG | CHAR | 4 | T024E |
| LIFNR | ✔ | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| WERKS | ✔ | Plant | EWERK | CHAR | 4 | T001W |
| ESOKZ | ✔ | Purchasing info record category | ESOKZ | CHAR | 1 | |
| MATKL | ✔ | Material Group | MATKL | CHAR | 9 | T023 |
| INFNR | ✔ | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA |
| LAND1 | ✔ | Country key of vendor | MCLANDL | CHAR | 3 | T005 |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | |
| MENGE | Purchase order quantity | MC_MENGE | QUAN | 15 | ||
| WEMNG | Quantity of goods received | MC_WEMNG | QUAN | 15 | ||
| WEMGM | Goods receipt qty in base unit (calculate wtd.delivery time) | MC_WEMGMAX | QUAN | 15 | ||
| REMNG | Invoice receipt quantity | MC_REMNG | QUAN | 15 | ||
| LSMNG | Target delivery quantity in base unit of measure | MC_LSMNG | QUAN | 15 | ||
| NETWR | Effective order value | MC_EFFWR | CURR | 15 | ||
| REWRT | Invoice Amount | MC_REWRT | CURR | 15 | ||
| ABSTP | Number of purchase order items | MC_ABSTP | DEC | 9 | ||
| ABSTE | Number of purchase order item schedule lines | MC_ABSTE | DEC | 9 | ||
| AANFP | Number of requests for quotation items | MC_AANFP | DEC | 9 | ||
| AANGP | Number of Quotation Items | MC_AANGP | DEC | 9 | ||
| AKONP | Number of contract items | MC_AKONP | DEC | 9 | ||
| ALFPP | Number of scheduling agreement items | MC_ALFPP | DEC | 9 | ||
| ALFPE | Number of delivery schedules | MC_ALFPE | DEC | 9 | ||
| ALIEF | Number of deliveries | MC_ALIEF | DEC | 9 | ||
| MABW1 | Deviation 1 in the quantity delivered | MC_MABW1 | DEC | 9 | ||
| MABW2 | Variance 2 in the quantity delivered | MC_MABW2 | DEC | 9 | ||
| MABW3 | Variance 3 in the quantity delivered | MC_MABW3 | DEC | 9 | ||
| MABW4 | Variance 4 in the quantity delivered | MC_MABW4 | DEC | 9 | ||
| MABW5 | Variance 5 in the quantity delivered | MC_MABW5 | DEC | 9 | ||
| TABW1 | Delivery date variance 1 in days | MC_TABW1 | DEC | 9 | ||
| TABW2 | Delivery date variance 2 in days | MC_TABW2 | DEC | 9 | ||
| TABW3 | Delivery date variance 3 in days | MC_TABW3 | DEC | 9 | ||
| TABW4 | Delivery date variance 4 in days | MC_TABW4 | DEC | 9 | ||
| TABW5 | Delivery date variance 5 in days | MC_TABW5 | DEC | 9 | ||
| LFZTA | Total delivery time in days | MC_LFZTA | DEC | 13 | ||
| LFZTG | Weighted total delivery time | MC_LFZTG | DEC | 15 | ||
| MENGE_R | Order quantity (returns) | MC_MENGE_R | QUAN | 15 | ||
| REMNG_R | Invoice receipt quantity of returns | MC_REMNG_R | QUAN | 15 | ||
| WEMNG_R | Goods receipt quantity of returns | MC_WEMNG_R | QUAN | 15 | ||
| REWRT_R | Invoice amount: Returns | MC_REWRT_R | CURR | 15 | ||
| EFFWR_R | Effective order value of returns | MC_EFFWR_R | CURR | 15 | ||
| WEWRT | Value of goods received in local currency | MC_WEWERT | CURR | 13 | ||
| REMNG_B | Invoice receipt quantity as at posting date | MC_REMNG_B | QUAN | 15 | ||
| WEWRT_B | Goods receipt value as at posting date | MC_WEWRT_B | CURR | 15 | ||
| REWRT_B | Invoice Amount as at Posting Date | MC_REWRT_B | CURR | 15 | ||
| REMNG_R_B | IR quantity: Returns as at posting date | MC_REMNG_R_B | QUAN | 15 | ||
| REWRT_R_B | IR value: Returns as at posting date | MC_REWRT_R_B | CURR | 15 | ||
| WEWRT_R_B | GR value: Returns as at posting date | MC_WEWRT_R_B | CURR | 15 |