S260 - SD - Sales order

SD - Sales order information is stored in SAP table S260.
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 S260

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
VBELN	Sales Document	X	VBELN_VA	CHAR	20
POSNR	Sales Document Item	X	POSNR_VA	NUMC	12
ETENR	Schedule Line Number	X	ETENR	NUMC	8	VBEP
PERIV	Fiscal Year Variant		PERIV	CHAR	4
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
.INCLUDE				MCVAACHAR	0
WAERK	SD Document Currency		WAERK	CUKY	10	TCURC
HWAER	Local Currency		HWAER	CUKY	10	*
STWAE	Statistics Currency		STWAE	CUKY	10	*
BUKRS	Company Code		BUKRS	CHAR	8
AUART	Sales Document Type		AUART	CHAR	8	*
VBTYP	SD Document Category		VBTYPL	CHAR	8
VKORG	Sales Organization		VKORG	CHAR	8
VTWEG	Distribution Channel		VTWEG	CHAR	4
VKBUR	Sales office		VKBUR	CHAR	8	*
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	*
VKGRP	Sales group		VKGRP	CHAR	6	*
KUNNR	Sold-to Party		KUNAG	CHAR	20	KNA1
SPARA	Division for order header		SPART_AK	CHAR	4	*
AUGRU	Order Reason (Reason for the Business Transaction)		AUGRU	CHAR	6	*
FAKSK	Billing Block in SD Document		FAKSK	CHAR	4	*
LIFSK	Delivery Block (Document Header)		LIFSK	CHAR	4	*
.INCLU--AP				MCVAACAP	0
VGTYP_AK	Sales Document Category of Reference Doc. in Order Header		MC_VBTYPAK	CHAR	8
.INCLUDE				MCVANCHAR	0
PSTYV	Sales document item category		PSTYV	CHAR	8	*
MATNR	Material Number		MATNR	CHAR	80
PRODH	Product hierarchy		PRODH_D	CHAR	36	*
MATKL	Material Group		MATKL	CHAR	18
CHARG	Batch Number		CHARG_D	CHAR	20	*
FAKSP	Billing Block for Item		FAKSP_AP	CHAR	4	*
WERKS	Plant		WERKS_D	CHAR	8
LGORT	Storage location		LGORT_D	CHAR	8	*
VSTEL	Shipping Point / Receiving Point		VSTEL	CHAR	8	*
ROUTE	Route		ROUTE	CHAR	12	*
SPART	Division		SPART	CHAR	4
PKUNWE	Ship-to Party		KUNWE	CHAR	20	*
PKUNRE	Bill-to Party		KUNRE	CHAR	20	*
PKUNRG	Payer		KUNRG	CHAR	20	*
PSPDNR	Forwarding Agent		SPDNR	CHAR	20	*
PVRTNR	Sales employee		VRTNR	NUMC	16
PABLA	Unloading point of the ship-to party		PABLA	CHAR	50
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	*
ABGRU	Reason for Rejection of Sales Documents		ABGRU_VA	CHAR	4	*
ABSTA	Rejection Status (Item)		ABSTA_VB	CHAR	2
UVALL	Incompletion Status (Item)		UVALL_UP	CHAR	2
UVVLK	Delivery Incompletion Status (Item)		UVVLK_UP	CHAR	2
UVFAK	Billing Incompletion Status (Item)		UVFAK_UP	CHAR	2
UVPRS	Pricing Incompletion Status (Item)		UVPRS_UP	CHAR	2
KDGRP	Customer Group		KDGRP	CHAR	4	*
BZIRK	Sales District		BZIRK	CHAR	12	*
INCO1	Incoterms (Part 1)		INCO1	CHAR	6	*
INCO2	Incoterms (Part 2)		INCO2	CHAR	56
KTGRD	Account Assignment Group for this Customer		KTGRD	CHAR	4	*
ERDAT	Date on which the record was created		ERDAT	DATS	16
AEDAT	Last Changed On		AEDAT	DATS	16
PRSDT	Date for Pricing and Exchange Rate		PRSDT	DATS	16
FKDAT	Billing Date		FKDAT	DATS	16
FBUDA	Date on which services are rendered		FBUDA	DATS	16
STADAT	Statistics date		STADAT	DATS	16
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	*
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
UMZIZ	Factor for Converting Sales Units to Base Units (Target Qty)		UMZIZ	DEC	3
UMZIN	Factor for Converting Sales Units to Base Units (Target Qty)		UMZIN	DEC	3
CMKUA	Credit data exchange rate for requested delivery date		CMKUA	DEC	5
KURSK	Exchange Rate for Price Determination		KURSK	DEC	5
STCUR	Exchange rate for statistics		STCUR	DEC	5
NETPR	Net Price		NETPR	CURR	6
.INCLU--AP				MCVANCAP	0
VGTYP	SD Document Category		VBTYPL	CHAR	8
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				MCVANKYF	0
NETWR	Net Value of the Order Item in Document Currency		NETWR_AP	CURR	8
WAVWR	Cost in Document Currency		WAVWR	CURR	7
KZWI1	Subtotal 1 from Pricing Procedure for Price Element		KZWI1	CURR	7
KZWI2	Subtotal 2 from Pricing Procedure for Price Element		KZWI2	CURR	7
KZWI3	Subtotal 3 from Pricing Procedure for Price Element		KZWI3	CURR	7
KZWI4	Subtotal 4 from Pricing Procedure for Price Element		KZWI4	CURR	7
KZWI5	Subtotal 5 from Pricing Procedure for Price Element		KZWI5	CURR	7
KZWI6	Subtotal 6 from Pricing Procedure for Price Element		KZWI6	CURR	7
KWMENG	Cumulative order quantity in sales units		KWMENG	QUAN	8
LSMENG	Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)		LSMENG	QUAN	8
KBMENG	Cumulative Confirmed Quantity in Sales Unit		KBMENG	QUAN	8
KLMENG	Cumulative Confirmed Quantity in Base Unit		KLMENG	QUAN	8
LFMNG	Minimum Delivery Quantity in Delivery Note Processing		MINLF	QUAN	7
BRGEW	Gross Weight of the Item		BRGEW_AP	QUAN	8
NTGEW	Net Weight of the Item		NTGEW_AP	QUAN	8
VOLUM	Volume of the item		VOLUM_AP	QUAN	8
.INCLU--AP				MCVANKAP	0
ANZAU	Number of Orders		MC_ANZAU	DEC	5
ANZAUPOS	Number of Order Items		MC_ANZAUPO	DEC	5
.INCLUDE				MCVAOCHAR	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				MCVAOKYF	0
WMENG	Order Quantity in Sales Units		WMENG	QUAN	7
LMENG	Required quantity for mat.management in stockkeeping units		LMENG	QUAN	7
BMENG	Confirmed Quantity		BMENG	QUAN	7
CMENG	Corrected quantity in sales unit		CMENG	QUAN	7