SAP ABAP Table S260 (SD - Sales order)

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	S260	Table Relationship Diagram
Short Description	SD - Sales order

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	SSOUR	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	VBELN	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
9	POSNR	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
10	ETENR	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
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 - Header
14	WAERK	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
15	HWAER	HWAER	WAERS	CUKY	5	0	Local Currency	*
16	STWAE	STWAE	WAERS	CUKY	5	0	Statistics currency	*
17	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
18	AUART	AUART	AUART	CHAR	4	0	Sales Document Type	*
19	VBTYP	VBTYP	VBTYP	CHAR	1	0	SD document category
20	VKORG	VKORG	VKORG	CHAR	4	0	Sales Organization	*
21	VTWEG	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
22	VKBUR	VKBUR	VKBUR	CHAR	4	0	Sales office	*
23	KVGR1	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
24	KVGR2	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
25	KVGR3	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
26	KVGR4	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
27	KVGR5	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
28	VKGRP	VKGRP	VKGRP	CHAR	3	0	Sales group	*
29	KUNNR	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
30	SPARA	SPART_AK	SPART	CHAR	2	0	Division for order header	*
31	AUGRU	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
32	FAKSK	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
33	LIFSK	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
34	.INCLU--AP				0	0	Sales Info System Characteristics: Sales Order Header Append
35	VGTYP_AK	MC_VBTYPAK	VBTYP	CHAR	1	0	Sales Document Category of Reference Doc. in Order Header
36	.INCLUDE				0	0	SIS Characteristics: Sales Order - Item
37	PSTYV	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
38	MATNR	MATNR	MATNR	CHAR	18	0	Material Number	*
39	PRODH	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
40	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
41	CHARG	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
42	FAKSP	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	*
43	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant	*
44	LGORT	LGORT_D	LGORT	CHAR	4	0	Storage location	*
45	VSTEL	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
46	ROUTE	ROUTE	ROUTE	CHAR	6	0	Route	*
47	SPART	SPART	SPART	CHAR	2	0	Division	*
48	PKUNWE	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
49	PKUNRE	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
50	PKUNRG	KUNRG	KUNNR	CHAR	10	0	Payer	*
51	PSPDNR	SPDNR	LIFNR	CHAR	10	0	Carrier	*
52	PVRTNR	VRTNR	PERNR	NUMC	8	0	Sales employee
53	PABLA	PABLA	TEXT25	CHAR	25	0	Unloading point of the ship-to party
54	MVGR1	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
55	MVGR2	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
56	MVGR3	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
57	MVGR4	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
58	MVGR5	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
59	ABGRU	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	*
60	ABSTA	ABSTA_VB	STATV	CHAR	1	0	Rejection status for SD item
61	UVALL	UVALL_UP	STATV	CHAR	1	0	General Incompletion Status of the Item
62	UVVLK	UVVLK_UP	STATV	CHAR	1	0	Incompletion Status of the Item with Regard to Delivery
63	UVFAK	UVFAK_UP	STATV	CHAR	1	0	Item incompletion status with respect to billing
64	UVPRS	UVPRS_UP	STATV	CHAR	1	0	Item is incomplete with respect to pricing
65	KDGRP	KDGRP	KDGRP	CHAR	2	0	Customer group	*
66	BZIRK	BZIRK	BZIRK	CHAR	6	0	Sales district	*
67	INCO1	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
68	INCO2	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
69	KTGRD	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	*
70	ERDAT	ERDAT	DATUM	DATS	8	0	Date on which the record was created
71	AEDAT	AEDAT	DATUM	DATS	8	0	Last Changed On
72	PRSDT	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
73	FKDAT	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
74	FBUDA	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
75	STADAT	STADAT	DATUM	DATS	8	0	Statistics date
76	VRKME	VRKME	MEINS	UNIT	3	0	Sales unit	T006
77	MEINS	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
78	ZIEME	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	*
79	GEWEI	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
80	VOLEH	VOLEH	MEINS	UNIT	3	0	Volume unit	*
81	UMVKZ	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
82	UMVKN	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
83	UMZIZ	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
84	UMZIN	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
85	CMKUA	CMKUA	KURRF	DEC	9	5	Credit data exchange rate for requested delivery date
86	KURSK	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
87	STCUR	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
88	NETPR	NETPR	WERTV6	CURR	11	2	Net price
89	.INCLU--AP				0	0	SIS Characteristics: Sales Order Item Append
90	VGTYP	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
91	ERNAM	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
92	ERZET	ERZET	UZEIT	TIMS	6	0	Entry time
93	PS_POSID	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
94	.INCLUDE				0	0	SIS Key Figures: Sales Order - Item
95	NETWR	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
96	WAVWR	WAVWR	WERTV7	CURR	13	2	Cost in document currency
97	KZWI1	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
98	KZWI2	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
99	KZWI3	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
100	KZWI4	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
101	KZWI5	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
102	KZWI6	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
103	ZWERT	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
104	ZMENG	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
105	KWMENG	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
106	LSMENG	LSMENG	MENG15	QUAN	15	3	Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
107	KBMENG	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
108	KLMENG	KLMENG	MENG15	QUAN	15	3	Cumulative Confirmed Quantity in Base Unit of Measure
109	LFMNG	MINLF	MENG13	QUAN	13	3	Minimum delivery quantity in delivery note processing
110	BRGEW	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
111	NTGEW	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
112	VOLUM	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
113	.INCLU--AP				0	0	SIS Key Figures: Sales Order Item Append
114	ANZAU	MC_ANZAU	MCZAEHLER	DEC	9	0	Number of orders
115	ANZAUPOS	MC_ANZAUPO	MCZAEHLER	DEC	9	0	Number of order items
116	.INCLUDE				0	0	SIS Characteristics: Sales Order - Schedule Line
117	ETTYP	ETTYP	ETTYP	CHAR	2	0	Item Cat. in Schedule Line	*
118	LIFSP	LIFSP_EP	LIFSP	CHAR	2	0	Schedule line blocked for delivery	*
119	LDDAT	LDDAT	DATUM	DATS	8	0	Loading Date
120	TDDAT	TDDAT_D	DATUM	DATS	8	0	Transportation Planning Date
121	EDATU	EDATU	DATUM	DATS	8	0	Schedule line date
122	WADAT	WADAT	DATUM	DATS	8	0	Goods Issue Date
123	MBDAT	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
124	WLDATBE	WLDATBE	DATUM	DATS	8	0	Desired del. date in confirmed schedule lines
125	.INCLUDE				0	0	SIS Key Figures: Sales Order - Schedule Line
126	WMENG	WMENG	MENG13	QUAN	13	3	Order quantity in sales units
127	LMENG	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
128	BMENG	BMENG	MENG13	QUAN	13	3	Confirmed quantity
129	CMENG	CMENG	MENG13	QUAN	13	3	Corrected quantity in sales unit