SAP ABAP Table S263BIW2 (SD - Sales order/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	S263BIW2	Table Relationship Diagram
Short Description	SD - Sales order/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	Key	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_VA	VBELN	CHAR	10	0	Sales Document	VBUK
4	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document 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: Sales Order/Delivery Note - Header
14	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
15	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
16	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
17	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
18	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
19	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
20	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
21	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
22	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
23	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
24	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
25	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
26	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
27	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
28	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
29	.INCLU--AP	☐				0	0	SIS Characteristics: Sales Order/Delivery Header Append
30	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	*
31	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
32	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
33	.INCLUDE	☐				0	0	SIS Characteristics: Sales Order/Delivery Note - Item
34	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
35	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
36	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
37	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
38	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
39	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
40	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
41	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
42	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	*
43	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
44	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
45	PKUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
46	PKUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
47	PSPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	*
48	PVRTNR	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
49	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
50	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
51	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
52	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
53	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
54	ABSTA	☐	ABSTA_VB	STATV	CHAR	1	0	Rejection status for SD item
55	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
56	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
57	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
58	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
59	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
60	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
61	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
62	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
63	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
64	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
65	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
66	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
67	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
68	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
69	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
70	.INCLU--AP	☐				0	0	SIS Characteristics: Sales Order/Delivery Item Append
71	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
72	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
73	.INCLUDE	☐				0	0	SIS Key Figures: Sales Order/Delivery Note - Item
74	OAUME	☐	MC_OAUME	MENGV15_3	QUAN	15	3	Open orders quantity in base unit of measure
75	OAUWE	☐	MC_OAUWE	WERTV10	CURR	19	2	Open net value of orders
76	.INCLU--AP	☐				0	0	SIS Key Figures: Sales Order/Delivery Item Append
77	ANZAU	☐	MC_ANZAU	MCZAEHLER	DEC	9	0	Number of orders
78	ANZAUPOS	☐	MC_ANZAUPO	MCZAEHLER	DEC	9	0	Number of order items
79	.INCLUDE	☐				0	0	SIS Characteristics: Sales Order/Delivery Note - Sched. Line
80	ETTYP	☐	ETTYP	ETTYP	CHAR	2	0	Item Cat. in Schedule Line	*
81	LIFSP	☐	LIFSP_EP	LIFSP	CHAR	2	0	Schedule line blocked for delivery	*
82	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
83	LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
84	TDDAT	☐	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
85	WADAT	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
86	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
87	WLDATBE	☐	WLDATBE	DATUM	DATS	8	0	Desired del. date in confirmed schedule lines
88	.INCLUDE	☐				0	0	SIS Key Figures: Sales Order/Delivery Note - Schedule Line
89	OLFMNG	☐	OLFMNG	MENG13	QUAN	13	3	Open quantity to be delivered (in sales unit)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S263BIW2	ETENR	VBEP	ETENR
2	S263BIW2	KUNNR	KNA1	KUNNR
3	S263BIW2	MANDT	T000	MANDT
4	S263BIW2	POSNR	VBUP	POSNR
5	S263BIW2	VBELN	VBUK	VBELN
6	S263BIW2	VRKME	T006	MSEHI

History

Last changed by/on	SAP	20130529
SAP Release Created in