SAP ABAP Table S262 (SD - Billing document)

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	S262	Table Relationship Diagram
Short Description	SD - Billing document

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	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_VF	VBELN	CHAR	10	0	Billing document	VBUK
9	POSNR	☑	POSNR_VF	POSNR	NUMC	6	0	Billing item	VBUP
10	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
11	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
12	.INCLUDE	☐				0	0	SIS Characteristics: Billing Document - Header
13	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
14	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	*
15	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
16	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
17	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	*
18	FKTYP	☐	FKTYP	FKTYP	CHAR	1	0	Billing Category
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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
23	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
24	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
25	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
26	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
27	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
28	.INCLUDE	☐				0	0	SIS Characteristics: Billing Document - Item
29	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
30	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
31	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
32	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
33	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
34	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
35	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
36	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
37	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
38	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
39	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
40	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
41	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
42	POSAR	☐	POSAR	POSAR	CHAR	1	0	Item type
43	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
44	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
45	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
46	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
47	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
48	BONUS	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	*
49	PROVG	☐	PROVG	PROVG	CHAR	2	0	Commission group	*
50	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
51	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
52	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
53	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
54	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
55	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
56	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
57	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*
58	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	*
59	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	*
60	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	*
61	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	*
62	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
63	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	*
64	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	*
65	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	*
66	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	*
67	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
68	PKUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
69	PKUNRE	☐	KUNRE	KUNNR	CHAR	10	0	Bill-to party	*
70	PSPDNR	☐	SPDNR	LIFNR	CHAR	10	0	Carrier	*
71	PVRTNR	☐	VRTNR	PERNR	NUMC	8	0	Sales employee
72	AUBEL	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
73	AUPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
74	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	*
75	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	*
76	.INCLU--AP	☐				0	0	SIS Characteristics: Billing Document Item Append
77	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
78	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
79	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
80	PS_POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
81	.INCLUDE	☐				0	0	SIS Key Figures: Billing Document - Item
82	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
83	SMENG	☐	SMENG	MENG13	QUAN	13	3	Scale quantity in base unit of measure
84	FKLMG	☐	FKLMG	MENG13	QUAN	13	3	Billing quantity in stockkeeping unit
85	LMENG	☐	LMENG	MENG13	QUAN	13	3	Required quantity for mat.management in stockkeeping units
86	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
87	BRGEW	☐	BRGEW_15	MENG15	QUAN	15	3	Gross weight
88	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
89	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
90	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
91	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
92	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
93	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
94	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
95	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
96	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
97	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
98	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
99	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
100	.INCLU--AP	☐				0	0	SIS Key Figures: Billing Document - Item
101	ANZFK	☐	MC_ANZFK	MCZAEHLER	DEC	9	0	No.of billing docs
102	ANZFKPOS	☐	MC_ANZFKPO	MCZAEHLER	DEC	9	0	Number of billing items

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S262	KUNAG	KNA1	KUNNR
2	S262	MANDT	T000	MANDT
3	S262	POSNR	VBUP	POSNR
4	S262	VBELN	VBUK	VBELN
5	S262	WAERK	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in