SAP ABAP Table ROXABV0040 (Generated Table for View /BEV1/TSACT2_BWV)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-SLS-PLL-OBS (Application Component) Remaining Beverage - Obsolete Objects
     ⤷ BVBW_DSOURCE (Package) Beverage DataSources - Obsolete Objects

Basic Data

Table Category	INTTAB	Structure
Structure	ROXABV0040	Table Relationship Diagram
Short Description	Generated Table for View /BEV1/TSACT2_BWV

Delivery and Maintenance

Pool/cluster
Delivery Class
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	VBELV	☑	VBELN_VON	VBELN	CHAR	10	0	Preceding sales and distribution document	VBUK
3	POSNV	☑	POSNR_VON	POSNR	NUMC	6	0	Preceding item of an SD document	VBUP
4	VBELN	☑	VBELN_NACH	VBELN	CHAR	10	0	Subsequent sales and distribution document	VBUK
5	POSNN	☑	POSNR_NACH	POSNR	NUMC	6	0	Subsequent item of an SD document	VBUP
6	VBTYP_N	☑	VBTYP_N	VBTYP	CHAR	1	0	Document category of subsequent document
7	VBTYP_V	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
8	ERDAT1	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
12	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
13	RFMNG	☐	RFMNG	MENG15	QUAN	15	3	Referenced quantity in base unit of measure
14	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
15	RFWRT	☐	RFWRT	WERTV8	CURR	15	2	Reference value
16	WAERS	☐	WAERS_V	WAERS	CUKY	5	0	Statistics currency	TCURC
17	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
18	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
19	KUNNR1	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
20	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
21	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
22	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
23	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
24	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
25	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
26	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
27	BUKRS_VF	☐	BUKRS_VF	BUKRS	CHAR	4	0	Company code to be billed	T001
28	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
29	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
30	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
31	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
32	STADAT	☐	STADAT	DATUM	DATS	8	0	Statistics date
33	ERDAT2	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
34	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
35	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
36	SPART	☐	SPART	SPART	CHAR	2	0	Division	TVTA
37	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
38	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
39	KTAST	☐	KTAST	KTAST	CHAR	1	0	Status of sales activity	TVC3
40	KTAER	☐	KTAER	KTAER	CHAR	3	0	Outcome of sales activities	TVC1
41	KTAEB	☐	KTAEB	KTAEB	CHAR	3	0	Analysis of sales activity outcome	TVC7
42	KUNNR2	☐	KUNDE_D	KUNDE	CHAR	10	0	Partner number (KUNNR, LIFNR, or PERNR)
43	GBSTK	☐	GBSTK	STATV	CHAR	1	0	Overall processing status of document
44	/BEV1/TSANWBER	☐	/BEV1/TSABER___D	/BEV1/TSABER	CHAR	10	0	Application Area	/BEV1/TSABER
45	/BEV1/TSANWGRP	☐	/BEV1/TSAGRP___D	/BEV1/TSAGRP	CHAR	7	0	Application Group	/BEV1/TSAGRP
46	/BEV1/TSVERKMET	☐	/BEV1/TSVERKMET	/BEV1/TSVERKMET	CHAR	3	0	Sales Method	/BEV1/TSVM
47	/BEV1/TSSAISON	☐	/BEV1/TSSAISON	/BEV1/TSSAISON	CHAR	5	0	Season Indicator	/BEV1/TSSAIDEF
48	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
49	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
50	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
51	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
52	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
53	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
54	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
55	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
56	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
57	/BEV1/TSPARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROXABV0040	/BEV1/TSANWBER	/BEV1/TSABER	ANWBER
2	ROXABV0040	/BEV1/TSANWGRP	/BEV1/TSAGRP	ANWGRP		1	CN
3	ROXABV0040	/BEV1/TSSAISON	/BEV1/TSSAIDEF	SAISON
4	ROXABV0040	/BEV1/TSVERKMET	/BEV1/TSVM	VERKMET
5	ROXABV0040	AUART	TVAK	AUART		1	CN
6	ROXABV0040	BUKRS_VF	T001	BUKRS		C	CN
7	ROXABV0040	KTAEB	TVC7	KATEB		C	CN
8	ROXABV0040	KTAER	TVC1	KTAER		C	CN
9	ROXABV0040	KTAST	TVC3	KTAST		C	CN
10	ROXABV0040	KUNNR1	KNA1	KUNNR		C	CN
11	ROXABV0040	KURST	TCURV	KURST		C	CN
12	ROXABV0040	KVGR1	TVV1	KVGR1		C	CN
13	ROXABV0040	KVGR2	TVV2	KVGR2		C	CN
14	ROXABV0040	KVGR3	TVV3	KVGR3		C	CN
15	ROXABV0040	KVGR4	TVV4	KVGR4		C	CN
16	ROXABV0040	KVGR5	TVV5	KVGR5		C	CN
17	ROXABV0040	MANDT	T000	MANDT	KEY	1	CN
18	ROXABV0040	MATKL	T023	MATKL		C	CN
19	ROXABV0040	MATNR	MARA	MATNR		C	CN
20	ROXABV0040	MEINS	T006	MSEHI		C	CN
21	ROXABV0040	POSNN	VBUP	POSNR	KEY	1	CN
22	ROXABV0040	POSNV	VBUP	POSNR	KEY	1	CN
23	ROXABV0040	PSTYV	TVPT	PSTYV		1	CN
24	ROXABV0040	SPART	TVTA	SPART		1	CN
25	ROXABV0040	STWAE	TCURC	WAERS		C	CN
26	ROXABV0040	VBELN	VBUK	VBELN	KEY	1	CN
27	ROXABV0040	VBELV	VBUK	VBELN	KEY	1	CN
28	ROXABV0040	VKBUR	TVKBZ	VKBUR		C	CN
29	ROXABV0040	VKGRP	TVBVK	VKGRP		C	CN
30	ROXABV0040	VKORG	TVKO	VKORG		1	CN
31	ROXABV0040	VRKME	T006	MSEHI		C	CN
32	ROXABV0040	VTWEG	TVKOV	VTWEG		1	CN
33	ROXABV0040	WAERK	TCURC	WAERS		C	CN
34	ROXABV0040	WAERS	TCURC	WAERS		C	CN
35	ROXABV0040	WERKS	T001W	WERKS		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	461