S261BIW1 - SD - Delivery note

SD - Delivery note information is stored in SAP table S261BIW1.
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 S261BIW1

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
VBELN	Delivery	X	VBELN_VL	CHAR	20
POSNR	Delivery Item	X	POSNR_VL	NUMC	12
ETENR	Schedule Line Number	X	ETENR	NUMC	8	VBEP
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
PERIV	Fiscal Year Variant		PERIV	CHAR	4
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
.INCLUDE				MCVCACHAR	0
LIFNR	Account Number of Supplier		LIFNR	CHAR	20
VSTEL	Shipping Point / Receiving Point		VSTEL	CHAR	8	TVST
ROUTE	Route		ROUTE	CHAR	12	*
PSPDNR	Forwarding Agent		SPDNR	CHAR	20	*
PKUNRE	Bill-to Party		KUNRE	CHAR	20	*
PKUNRG	Payer		KUNRG	CHAR	20	*
PVRTNR	Sales employee		VRTNR	NUMC	16
KDGRP	Customer Group		KDGRP	CHAR	4	*
BZIRK	Sales District		BZIRK	CHAR	12	*
VKORG	Sales Organization		VKORG	CHAR	8
SPARA	Division for order header		SPART_AK	CHAR	4	*
LFART	Delivery Type		LFART	CHAR	8	*
FAKSK	Billing Block in SD Document		FAKSK	CHAR	4	*
LIFSK	Delivery Block (Document Header)		LIFSK	CHAR	4	*
ABLAD	Unloading Point		ABLAD	CHAR	50
INCO1	Incoterms (Part 1)		INCO1	CHAR	6	*
INCO2	Incoterms (Part 2)		INCO2	CHAR	56
KUNNR	Ship-to Party		KUNWE	CHAR	20	*
KUNAG	Sold-to Party		KUNAG	CHAR	20	*
LSTEL	Loading Point		LSTEL	CHAR	4	*
WADAT_IST	Actual Goods Movement Date		WADAT_IST	DATS	16
.INCLU--AP				MCVCACAP	0
LFDAT	Delivery Date		LFDAT_V	DATS	16
VBTYP	SD Document Category		VBTYPL	CHAR	8
BUKRS	Company Code		BUKRS	CHAR	8
.INCLUDE				MCVCNCHAR	0
VRKME	Sales unit		VRKME	UNIT	6	T006
MEINS	Base Unit of Measure		MEINS	UNIT	6	*
GEWEI	Weight Unit		GEWEI	UNIT	6	*
VOLEH	Volume unit		VOLEH	UNIT	6	*
ERDAT	Date on which the record was created		ERDAT	DATS	16
AEDAT	Last Changed On		AEDAT	DATS	16
STADAT	Statistics date		STADAT	DATS	16
UMVKZ	Numerator (factor) for conversion of sales quantity into SKU		UMVKZ	DEC	3
UMVKN	Denominator (divisor) for conversion of sales Qty into SKU		UMVKN	DEC	3
PSTYV	Sales document item category		PSTYV	CHAR	8	*
VGTYP	SD Document Category		VBTYPL	CHAR	8
MATNR	Material Number		MATNR	CHAR	80
MATKL	Material Group		MATKL	CHAR	18
WERKS	Plant		WERKS_D	CHAR	8
LGORT	Storage location		LGORT_D	CHAR	8	*
CHARG	Batch Number		CHARG_D	CHAR	20	*
PRODH	Product hierarchy		PRODH_D	CHAR	36	*
FAKSP	Billing Block		FAKSP	CHAR	4	*
VGBEL	Document number of the reference document		VGBEL	CHAR	20
VGPOS	Item number of the reference item		VGPOS	NUMC	12
KOMKZ	Indicator for picking control		KOMKZ	CHAR	2
LGNUM	Warehouse Number / Warehouse Complex		LGNUM	CHAR	6	*
LGTYP	Storage Type		LGTYP	CHAR	6
LGPLA	Storage Bin		LGPLA	CHAR	20
POSAR	Item Type		POSAR	CHAR	2
GSBER	Business Area		GSBER	CHAR	8	*
VKBUR	Sales office		VKBUR	CHAR	8	*
VKGRP	Sales group		VKGRP	CHAR	6	*
VTWEG	Distribution Channel		VTWEG	CHAR	4
SPART	Division		SPART	CHAR	4
KVGR1	Customer Group 1		KVGR1	CHAR	6	*
KVGR2	Customer Group 2		KVGR2	CHAR	6	*
KVGR3	Customer Group 3		KVGR3	CHAR	6	*
KVGR4	Customer Group 4		KVGR4	CHAR	6	*
KVGR5	Customer Group 5		KVGR5	CHAR	6	*
MVGR1	Material Group 1		MVGR1	CHAR	6	*
MVGR2	Material Group 2		MVGR2	CHAR	6	*
MVGR3	Material Group 3		MVGR3	CHAR	6	*
MVGR4	Material Group 4		MVGR4	CHAR	6	*
MVGR5	Material Group 5		MVGR5	CHAR	6	*
WBSTA	Goods Movement Status (Item)		WBSTA	CHAR	2
KOSTA	Picking Status/Putaway Status (Item)		KOSTA	CHAR	2
KOQUA	Confirmation Status of Picking/Putaway		KOQUA	CHAR	2
.INCLU--AP				MCVCNCAP	0
APERDAT	Creation Date of Order Item		MC_APERDAT	DATS	16
KZVBR	Consumption posting		KZVBR	CHAR	2
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
ERZET	Entry time		ERZET	TIMS	12
PS_POSID	Work Breakdown Structure Element (WBS Element)		PS_POSID	CHAR	48
.INCLUDE				MCVCNKYF	0
LFIMG	Actual quantity delivered (in sales units)		LFIMG	QUAN	7
NTGEW	Net weight		NTGEW_15	QUAN	8
BRGEW	Gross weight		BRGEW_15	QUAN	8
VOLUM	Volume		VOLUM_15	QUAN	8
LGMNG	Actual quantity delivered in stockkeeping units		LGMNG	QUAN	7
.INCLU--AP				MCVCNKAP	0
ANZLI	No. of deliveries		MC_ANZLI	DEC	5
ANZLIPOS	Number of delivery items		MC_ANZLIPO	DEC	5
.INCLUDE				MCVCOCHAR	0
ETTYP	Schedule line category		ETTYP	CHAR	4	*
LIFSP	Schedule Line Blocked for Delivery		LIFSP_EP	CHAR	4	*
LDDAT	Loading Date		LDDAT	DATS	16
TDDAT	Transportation Planning Date		TDDAT_D	DATS	16
EDATU	Schedule line date		EDATU	DATS	16
WADAT	Goods Issue Date		WADAT	DATS	16
MBDAT	Material Staging/Availability Date		MBDAT	DATS	16
WLDATBE	Desired del. date in confirmed schedule lines		WLDATBE	DATS	16
.INCLUDE				MCVCOKYF	0
VSMNG_L	Delivered quantity per schedule line and delivery item		MC_VSMNG_L	QUAN	8