S012BIW1 - S012BIW1 * Purchasing

S012BIW1 * Purchasing information is stored in SAP table S012BIW1.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".

Fields for table S012BIW1

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
SSOURStatistic(s) originXSSOURCHAR8
VRSIOVersion number in the information structureXVRSIOCHAR6*
SPMONPeriod to analyze - monthXSPMONNUMC12
SPTAGPeriod to analyze - current dateXSPTAGDATS16
SPWOCPeriod to analyze - weekXSPWOCNUMC12
SPBUPPeriod to analyze - posting periodXSPBUPNUMC12
EKORGPurchasing organizationXEKORGCHAR8T024E
LIFNRVendor's account numberXELIFNCHAR20LFA1
MATNRMaterial NumberXMATNRCHAR80MARA
WERKSPlantXEWERKCHAR8T001W
ESOKZPurchasing info record categoryXESOKZCHAR2
MATKLMaterial GroupXMATKLCHAR18T023
INFNRNumber of purchasing info recordXINFNRCHAR20EINA
LAND1Country/Region Key of SupplierXMCLANDLCHAR6T005
PERIVFiscal Year VariantPERIVCHAR4*
VWDATPointer to administrative dataVWDATNUMC20
BASMEBase Unit of MeasureMEINSUNIT6T006
HWAERLocal CurrencyHWAERCUKY10TCURC
MENGEPurchase order quantityMC_MENGEQUAN8
WEMNGQuantity of goods receivedMC_WEMNGQUAN8
WEMGMGoods receipt qty in base unit (calculate wtd.delivery time)MC_WEMGMAXQUAN8
REMNGInvoice receipt quantityMC_REMNGQUAN8
LSMNGTarget delivery quantity in base unit of measureMC_LSMNGQUAN8
NETWREffective order valueMC_EFFWRCURR8
REWRTInvoice AmountMC_REWRTCURR8
ABSTPNumber of purchase order itemsMC_ABSTPDEC5
ABSTENumber of purchase order item schedule linesMC_ABSTEDEC5
AANFPNumber of requests for quotation itemsMC_AANFPDEC5
AANGPNumber of Quotation ItemsMC_AANGPDEC5
AKONPNumber of contract itemsMC_AKONPDEC5
ALFPPNumber of scheduling agreement itemsMC_ALFPPDEC5
ALFPENumber of delivery schedulesMC_ALFPEDEC5
ALIEFNumber of deliveriesMC_ALIEFDEC5
MABW1Deviation 1 in the quantity deliveredMC_MABW1DEC5
MABW2Variance 2 in the quantity deliveredMC_MABW2DEC5
MABW3Variance 3 in the quantity deliveredMC_MABW3DEC5
MABW4Variance 4 in the quantity deliveredMC_MABW4DEC5
MABW5Variance 5 in the quantity deliveredMC_MABW5DEC5
TABW1Delivery date variance 1 in daysMC_TABW1DEC5
TABW2Delivery date variance 2 in daysMC_TABW2DEC5
TABW3Delivery date variance 3 in daysMC_TABW3DEC5
TABW4Delivery date variance 4 in daysMC_TABW4DEC5
TABW5Delivery date variance 5 in daysMC_TABW5DEC5
LFZTATotal delivery time in daysMC_LFZTADEC7
LFZTGWeighted total delivery timeMC_LFZTGDEC8
MENGE_ROrder quantity (returns)MC_MENGE_RQUAN8
REMNG_RInvoice receipt quantity of returnsMC_REMNG_RQUAN8
WEMNG_RGoods receipt quantity of returnsMC_WEMNG_RQUAN8
REWRT_RInvoice amount: ReturnsMC_REWRT_RCURR8
EFFWR_REffective order value of returnsMC_EFFWR_RCURR8
WEWRTValue of goods received in local currencyMC_WEWERTCURR7
REMNG_BInvoice receipt quantity as at posting dateMC_REMNG_BQUAN8
WEWRT_BGoods receipt value as at posting dateMC_WEWRT_BCURR8
REWRT_BInvoice Amount as at Posting DateMC_REWRT_BCURR8
REMNG_R_BIR quantity: Returns as at posting dateMC_REMNG_R_BQUAN8
REWRT_R_BIR value: Returns as at posting dateMC_REWRT_R_BCURR8
WEWRT_R_BGR value: Returns as at posting dateMC_WEWRT_R_BCURR8
Privacy Policy