SAP ABAP Table S261BIW2 (SD - Delivery note)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM (Application Component) Customer Relationship Management
⤷

CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷

MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S261BIW2	Table Relationship Diagram
Short Description	SD - Delivery note

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	SPTAG	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
3	VBELN	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
4	POSNR	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
5	ETENR	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
6	VRSIO	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
7	SPMON	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
8	SPWOC	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
9	SPBUP	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
10	SSOUR	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
11	PERIV	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
12	VWDAT	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
13	.INCLUDE				0	0	SIS Characteristics: Delivery Note - Header
14	LIFNR	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
15	VSTEL	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
16	ROUTE	ROUTE	ROUTE	CHAR	6	0	Route	*
17	PSPDNR	SPDNR	LIFNR	CHAR	10	0	Carrier	*
18	PKUNRE	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
19	PKUNRG	KUNRG	KUNNR	CHAR	10	0	Payer	*
20	PVRTNR	VRTNR	PERNR	NUMC	8	0	Sales employee
21	KDGRP	KDGRP	KDGRP	CHAR	2	0	Customer group	*
22	BZIRK	BZIRK	BZIRK	CHAR	6	0	Sales district	*
23	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
24	SPARA	SPART_AK	SPART	CHAR	2	0	Division for order header	*
25	LFART	LFART	LFART	CHAR	4	0	Delivery Type	*
26	FAKSK	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
27	LIFSK	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
28	ABLAD	ABLAD	TEXT25	CHAR	25	0	Unloading Point
29	INCO1	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
30	INCO2	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
31	KUNNR	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
32	KUNAG	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
33	LSTEL	LSTEL	LSTEL	CHAR	2	0	Loading Point	*
34	WADAT_IST	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
35	.INCLU--AP				0	0	SIS Characteristics: Delivery Header Append
36	LFDAT	LFDAT_V	DATUM	DATS	8	0	Delivery Date
37	VBTYP	VBTYP	VBTYP	CHAR	1	0	SD document category
38	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
39	.INCLUDE				0	0	SIS Characteristics: Delivery Note - Item
40	VRKME	VRKME	MEINS	UNIT	3	0	Sales unit	T006
41	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
42	GEWEI	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
43	VOLEH	VOLEH	MEINS	UNIT	3	0	Volume unit	*
44	ERDAT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
45	AEDAT	AEDAT	DATUM	DATS	8	0	Last Changed On
46	STADAT	STADAT	DATUM	DATS	8	0	Statistics date
47	UMVKZ	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
48	UMVKN	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
49	PSTYV	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
50	VGTYP	VGTYP	VORG_TYP	CHAR	3	0	Activity or element category
51	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
52	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
53	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
54	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location	*
55	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
56	PRODH	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
57	FAKSP	FAKSP	FAKSP	CHAR	2	0	Lock	*
58	VGBEL	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
59	VGPOS	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
60	KOMKZ	KOMKZ	KOMKZ	CHAR	1	0	Indicator for picking control
61	LGNUM	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
62	LGTYP	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
63	LGPLA	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
64	POSAR	POSAR	POSAR	CHAR	1	0	Item type
65	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
66	VKBUR	VKBUR	VKBUR	CHAR	4	0	Sales office	*
67	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
68	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
69	SPART	SPART	SPART	CHAR	2	0	Division	*
70	KVGR1	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
71	KVGR2	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
72	KVGR3	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
73	KVGR4	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
74	KVGR5	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
75	MVGR1	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
76	MVGR2	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
77	MVGR3	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
78	MVGR4	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
79	MVGR5	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
80	WBSTA	WBSTA	STATV	CHAR	1	0	Goods movement status
81	KOSTA	KOSTA	STATV	CHAR	1	0	Picking Status/Putaway Status
82	KOQUA	KOQUA	STATV	CHAR	1	0	Confirmation status of picking/putaway
83	.INCLU--AP				0	0	SIS Characteristics: Delivery Item Append
84	APERDAT	MC_APERDAT	DATUM	DATS	8	0	Creation Date of Order Item
85	KZVBR	KZVBR	KZVBR	CHAR	1	0	Consumption posting
86	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
87	ERZET	ERZET	UZEIT	TIMS	6	0	Entry time
88	PS_POSID	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
89	.INCLUDE				0	0	SIS Key Figures: Delivery Note - Header
90	LFIMG	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
91	NTGEW	NTGEW_15	MENG15	QUAN	15	3	Net weight
92	BRGEW	BRGEW_15	MENG15	QUAN	15	3	Gross weight
93	VOLUM	VOLUM_15	MENG15	QUAN	15	3	Volume
94	LGMNG	LGMNG	MENG13	QUAN	13	3	Actual quantity delivered in stockkeeping units
95	.INCLU--AP				0	0	SIS Key Figures: Delivery Item Append
96	ANZLI	MC_ANZLI	MCZAEHLER	DEC	9	0	No. of deliveries
97	ANZLIPOS	MC_ANZLIPO	MCZAEHLER	DEC	9	0	Number of delivery items
98	.INCLUDE				0	0	SIS Characteristics: Delivery Note - Schedule Line
99	ETTYP	ETTYP	ETTYP	CHAR	2	0	Item Cat. in Schedule Line	*
100	LIFSP	LIFSP_EP	LIFSP	CHAR	2	0	Schedule line blocked for delivery	*
101	LDDAT	LDDAT	DATUM	DATS	8	0	Loading Date
102	TDDAT	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
103	EDATU	EDATU	DATUM	DATS	8	0	Schedule line date
104	WADAT	WADAT	DATUM	DATS	8	0	Goods Issue Date
105	MBDAT	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
106	WLDATBE	WLDATBE	DATUM	DATS	8	0	Desired del. date in confirmed schedule lines
107	.INCLUDE				0	0	SIS key Figures: Delivery Note - Schedule Line
108	VSMNG_L	MC_VSMNG_L	MENGV15_3	QUAN	15	3	Delivered quantity per schedule line and delivery item