SAP ABAP Table /BEV1/TSRV43AAS (Order Item Data for SAPMV43A)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-SLS-PLL-OBS (Application Component) Remaining Beverage - Obsolete Objects
     ⤷ /BEV1/TS_OBSOLETE (Package) Telephone Sales - Obsolete Objects

Basic Data

Table Category	INTTAB	Structure
Structure	/BEV1/TSRV43AAS	Table Relationship Diagram
Short Description	Order Item Data for SAPMV43A

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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
2	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
4	KWMENG	☐	WMENG	MENG13	QUAN	13	3	Order quantity in sales units
5	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
6	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
7	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
8	PRGBZ	☐	PRGBZ	PRGBZ	CHAR	1	0	External date type	TPRG
9	ETDAT	☐	ETDAT	ETDAT	CHAR	10	0	Schedule line date
10	EZEIT	☐	EZEIT_VBEP	UZEIT	TIMS	6	0	Arrival time
11	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
12	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
13	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
14	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
15	KATPMN	☐	KATPMN	MENGV15	QUAN	15	3	Cumulative ATP quantity (available to promise)
16	KSTBS	☐	KSTBM	MENG15	QUAN	15	3	Condition scale quantity
17	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
18	FAKSP	☐	FAKSP	FAKSP	CHAR	2	0	Lock	*
19	KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
20	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
21	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	*
22	KBETR1	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
23	KWAER1	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
24	KPEIN1	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
25	KMEIN1	☐	KVMEI	MEINS	UNIT	3	0	Condition unit in the document	*
26	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
27	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
28	STKEY	☐	STKEY	STKEY	CHAR	1	0	Origin of the bill of material
29	STLNR	☐	STNUM	STNUM	CHAR	8	0	Bill of Material
30	STLTY	☐	STLTY	STLTY	CHAR	1	0	BOM Category
31	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	*
32	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
33	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
34	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
35	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
36	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
37	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	*
38	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	*
39	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	*
40	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	*
41	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
42	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
43	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
44	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
45	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
46	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
47	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
48	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
49	UMVKZ	☐	UMVKZ	UMBSZ	DEC	5	0	Numerator (factor) for conversion of sales quantity into SKU
50	UMVKN	☐	UMVKN	UMBSN	DEC	5	0	Denominator (divisor) for conversion of sales qty. into SKU
51	BRGEW	☐	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
52	NTGEW	☐	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
53	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
54	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
55	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
56	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
57	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	*
58	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
59	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	*
60	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
61	FIXMG	☐	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
62	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
63	STLAL	☐	STLAL	ALTNR	CHAR	2	0	Alternative BOM
64	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
65	.INCLUDE	☐				0	0	Sales Document: Item Status
66	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
67	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
68	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
69	RFSTA	☐	RFSTA	STATV	CHAR	1	0	Reference status
70	RFGSA	☐	RFGSA	STATV	CHAR	1	0	Overall Status of Reference
71	BESTA	☐	BESTA	STATV	CHAR	1	0	Confirmation status of the document item
72	LFSTA	☐	LFSTA	STATV	CHAR	1	0	Delivery status
73	LFGSA	☐	LFGSA	STATV	CHAR	1	0	Overall Delivery Status of the Item
74	WBSTA	☐	WBSTA	STATV	CHAR	1	0	Goods movement status
75	FKSTA	☐	FKSTA	STATV	CHAR	1	0	Billing status of delivery-related billing documents
76	FKSAA	☐	FKSAA	STATV	CHAR	1	0	Billing Status for Order-Related Billing Documents
77	ABSTA	☐	ABSTA_VB	STATV	CHAR	1	0	Rejection status for SD item
78	GBSTA	☐	GBSTA	STATV	CHAR	1	0	Overall Processing Status of the SD Document Item
79	KOSTA	☐	KOSTA	STATV	CHAR	1	0	Picking Status/Putaway Status
80	LVSTA	☐	LVSTA	STATV	CHAR	1	0	Status of warehouse management activities
81	UVALL	☐	UVALL_UP	STATV	CHAR	1	0	General Incompletion Status of the Item
82	UVVLK	☐	UVVLK_UP	STATV	CHAR	1	0	Incompletion Status of the Item with Regard to Delivery
83	UVFAK	☐	UVFAK_UP	STATV	CHAR	1	0	Item incompletion status with respect to billing
84	UVPRS	☐	UVPRS_UP	STATV	CHAR	1	0	Item is incomplete with respect to pricing
85	FKIVP	☐	FKIVP	STATV	CHAR	1	0	Intercompany billing status
86	UVP01	☐	UVP01	STATV	CHAR	1	0	Customer reserves 1: Item status
87	UVP02	☐	UVP02	STATV	CHAR	1	0	Customer reserves 2: Item status
88	UVP03	☐	UVP03	STATV	CHAR	1	0	Item reserves 3: Item status
89	UVP04	☐	UVP04	STATV	CHAR	1	0	Item reserves 4: Item status
90	UVP05	☐	UVP05	STATV	CHAR	1	0	Customer reserves 5: Item status
91	PKSTA	☐	PKSTA	STATV	CHAR	1	0	Packing status of item
92	KOQUA	☐	KOQUA	STATV	CHAR	1	0	Confirmation status of picking/putaway
93	COSTA	☐	COSTA_D	COSTA	CHAR	1	0	Confirmation status for ALE
94	CMPPI	☐	CMPSI	CMPSZ	CHAR	1	0	Status of credit check against financial document
95	CMPPJ	☐	CMPSJ	CMPSZ	CHAR	1	0	Status of credit check against export credit insurance
96	UVPIK	☐	UVPIP_UP	STATV	CHAR	1	0	Incomplete status of item for picking/putaway
97	UVPAK	☐	UVPAP_UP	STATV	CHAR	1	0	Incomplete status of item for packaging
98	UVWAK	☐	UVWAP_UP	STATV	CHAR	1	0	Incomplete status of item regarding goods issue
99	DCSTA	☐	DCSTA	STATV	CHAR	1	0	Delay status
100	RRSTA	☐	RR_STATUS	STATV	CHAR	1	0	Revenue determination status
101	VLSTP	☐	VLSTP	STATV	CHAR	1	0	Decentralized whse processing
102	FSSTA	☐	FSSTA	STATV	CHAR	1	0	Billing block status for items
103	LSSTA	☐	LSSTA	STATV	CHAR	1	0	Delivery block status for item
104	PDSTA	☐	PDSTA	STATV	CHAR	1	0	POD status on item level
105	MANEK	☐	MANEK	MANEK	CHAR	1	0	Manual Completion of Contract
106	HDALL	☐	/SPE/INB_HDALL_ITM	XFELD	CHAR	1	0	Inbound Delivery Item Not Yet Complete (on Hold)
107	.INCLU--AP	☐				0	0	sapht stockable type switch
108	LTSPS	☐	/SAPHT/SW_LTSPS	/SAPHT/SW_LTSPS	CHAR	1	0	Indicator : stockable type switched into standard product

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/BEV1/TSRV43AAS	ABGRU	TVAG	ABGRU	KEY	1	CN
2	/BEV1/TSRV43AAS	CHARG	MCH1	CHARG
3	/BEV1/TSRV43AAS	LPRIO	TPRIO	LPRIO
4	/BEV1/TSRV43AAS	MATNR	MARA	MATNR
5	/BEV1/TSRV43AAS	PRGBZ	TPRG	PRGBZ
6	/BEV1/TSRV43AAS	VRKME	T006	MSEHI
7	/BEV1/TSRV43AAS	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in