SAP ABAP Table RV45A (Data Fields for SAPMV45A)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VA (Package) Application development R/3 Sales

Basic Data

Table Category	INTTAB	Structure
Structure	RV45A	Table Relationship Diagram
Short Description	Data Fields for SAPMV45A

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	.INCLUDE	☐				0	0	Data Fields for Search Help when Creating with Reference
2	BSTNK	☐	BSTKD_M	CHAR35	CHAR	35	0	Customer PO number as matchcode field
3	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
4	LFNKD	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
5	PSPID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
6	KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
7	KNREF	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
8	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
9	ABRVW	☐	ABRVW	ABRVW	CHAR	3	0	Usage Indicator	*
10	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
11	AMODE	☐	AMODE	CHAR1	CHAR	1	0	Activity mode
12	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
13	AUBST	☐	AUBST	XFELD	CHAR	1	0	Purchase requisition with delivery scheduling
14	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
15	BEDAE	☐	BEDAE	BEDAE	CHAR	4	0	Requirements type	T459A
16	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
17	BASMN	☐	BASMN	MENG13	QUAN	13	3	Base quantity
18	BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
19	NTGEW	☐	NTGEW_15	MENG15	QUAN	15	3	Net weight
20	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
21	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
22	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
23	CUA_LONG	☐	CUA_TIT_TX	CUA_TIT_TX	CHAR	60	0	Text of title line
24	DRUCK	☐	DRUCK	XFELD	CHAR	1	0	Document has been printed
25	DWERK	☐	DWERK_EXT	WERKS	CHAR	4	0	Delivering Plant (Own or External)	*
26	EWERT	☐	EWERT	WERT8	CURR	15	2	Expected value
27	ETDAT	☐	ETDAT	ETDAT	CHAR	10	0	Schedule line date
28	ETDATB	☐	ETDAT	ETDAT	CHAR	10	0	Schedule line date
29	FORM1	☐	TDFORMAT	TDELEMSTYL	CHAR	2	0	Tag column
30	GRETD	☐	GRETD	DATUM	DATS	8	0	Schedule line date for the delivery group
31	GRMBD	☐	GRMBD	DATUM	DATS	8	0	Material availability date for the delivery group
32	KDKOP	☐	KDKOP	XFELD	CHAR	1	0	General business data from the header valid
33	KEDATU	☐	KEDATU	DATUM	DATS	8	0	Requested delivery date
34	KETDAT	☐	KETDAT	ETDAT	CHAR	10	0	Requested delivery date of the document
35	KNDNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
36	KMPMG	☐	KMPMG	MENGV13	QUAN	13	3	Component Quantity
37	KPRGRS	☐	KPRGRS	PRGRS	CHAR	1	0	Default period
38	KOEIN	☐	KOEIN	KOEIN	CUKY	5	0	Rate unit (currency, sales unit, or %)
39	KPRGBZ	☐	KPRGBZ	PRGBZ	CHAR	1	0	Date type of the requested delivery date	TPRG
40	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
41	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
42	KTONR	☐	KTONR	KTONR	CHAR	10	0	SD business partner identifier (number or code)
43	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
44	KWMENG_H	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
45	KZLTX	☐	LTXKZ	XFELD	CHAR	1	0	More Text Exists
46	LTEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
47	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
48	MEINS1	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
49	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
50	PO_MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
51	PO_ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
52	PO_KDMAT	☐	KDMAT	IDNEX	CHAR	35	0	Material belonging to the customer
53	PART0	☐	PART0	XFELD	CHAR	1	0	No business partners allowed
54	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
55	PREIS	☐	PREIS	WERT11	CURR	11	2	Price
56	PRGBZ	☐	PRGBZ	PRGBZ	CHAR	1	0	External date type	TPRG
57	PRGBZB	☐	PRGBZ	PRGBZ	CHAR	1	0	External date type	*
58	PRSFD	☐	PRSFD	PRSFD	CHAR	1	0	Carry out pricing
59	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
60	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	*
61	SERNR_VOR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
62	S_ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
63	S_LIFSP	☐	LIFSP_EP	LIFSP	CHAR	2	0	Schedule line blocked for delivery	TVLS
64	S_LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	TVLS
65	S_LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
66	S_FAKSP	☐	FAKSP	FAKSP	CHAR	2	0	Lock	TVFS
67	S_FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
68	S_PRGBZ	☐	S_PRGBZ	PRGBZ	CHAR	1	0	Date type for new requested delivery date	TPRG
69	S_ETDAT	☐	S_ETDAT	ETDAT	CHAR	10	0	New delivery date
70	S_WERKS	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
71	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
72	SPRAS_VOR	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
73	STTXT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
74	TTEXT	☐	TDTEXT	TDTEXT	CHAR	30	0	Short text
75	TXT_ANGDT	☐	TXT_ANGVO	TEXT20	CHAR	20	0	Date from which a quotation/inquiry is valid
76	TXT_BNDDT	☐	TXT_ANGBI	TEXT20	CHAR	20	0	Date up to which a quotation/inquiry is valid
77	TXT_AUART	☐	TXT_AUART	TEXT20	CHAR	20	0	Sales document type
78	TXT_SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
79	TXT_TITCUA	☐	VTXTK	TEXT20	CHAR	20	0	Name
80	TXT_TITEL	☐	VTXTK	TEXT20	CHAR	20	0	Name
81	TXT_VBELN	☐	TXT_VBELN	TEXT20	CHAR	20	0	Document number
82	TXT_VTRBER	☐	TXT_VTRBER	TXT_VTRBER	CHAR	64	0	Sales area
83	UEPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
84	VBAP_SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
85	VBEP_SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
86	VRKME1	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
87	VRKME2	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
88	VRKME3	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
89	VRKME4	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
90	VSMNG	☐	VSMNG	MENG13	QUAN	13	3	Delivered quantity in sales units
91	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
92	WAERZ	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
93	WEMPF	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	KNA1
94	WRKLG	☐	WRKLG	CHAR1	CHAR	1	0	Plant/storage location
95	ZEILE_LEER	☐	DZEILE_LEE	XFELD	CHAR	1	0	Current line of the list layout is empty
96	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
97	ZIEME1	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
98	ZMENG	☐	DZMENGV	MENGE	QUAN	13	3	Target quantity in sales units
99	ASTTX	☐	ASTTX	TEXT40	CHAR	40	0	User Status
100	VBSN_SELKZ	☐	SELKZ_LIST	SELKZ	CHAR	1	0	Selection indicator for list screens
101	AUFNO	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
102	PLANO	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	*
103	VBELNTO	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
104	AUARTTO	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
105	KFREL	☐	KFREL	CHAR1_X	CHAR	1	0	Indicator for billing plan in header
106	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
107	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
108	ABHOV	☐	ABHOZ	UZEIT	TIMS	6	0	Pick up time
109	ABHOB	☐	ABHOZ	UZEIT	TIMS	6	0	Pick up time
110	ABHOD	☐	ABHOD	DATUM	DATS	8	0	Pick up date
111	AWERT	☐	ABRUFWERT	ABRUFWERT	CURR	17	2	Value of value contract already released
112	SKOPF	☐	W_SORTK	WSORTK	CHAR	18	0	Assortment Module	WSOH
113	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
114	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
115	RKTIO	☐	RKTIO	RKTIO	CHAR	1	0	Response on reaching release order value in value contract
116	ABGESP	☐	ABGESP	PRZ32	DEC	5	2	Percent rate of guaranteed value
117	MONTBFLAG	☐	MONTBFLAG	CHAR1	CHAR	1	0	Assembly Procurement. For use in FV45EFMA
118	DOCNUM	☐	EDI_DOCNUM	EDI_DOCNUM	NUMC	16	0	IDoc number
119	KEZEIT	☐	KEZEIT	TIME_SHIPT	TIMS	6	0	Requested delivery time
120	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
121	PO_POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
122	FFPRF	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
123	TXT_ABRUF_PART	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
124	RB_AUART	☐	RB_AAUART	XFELD	CHAR	1	0	Alternative sales document type
125	RB_AAUART1	☐	RB_AAUART	XFELD	CHAR	1	0	Alternative sales document type
126	RB_AAUART2	☐	RB_AAUART	XFELD	CHAR	1	0	Alternative sales document type
127	TXT_RB_AUART	☐	TXT_AAUART	TEXT20	CHAR	20	0	Alternative sales document type
128	TXT_RB_AAUART1	☐	TXT_AAUART	TEXT20	CHAR	20	0	Alternative sales document type
129	TXT_RB_AAUART2	☐	TXT_AAUART	TEXT20	CHAR	20	0	Alternative sales document type
130	MONTAGE_INIT	☐	MONTAGE_INIT	CHAR1	CHAR	1	0	Assembly procurement. Initialization necessary
131	KONFIG_INIT	☐	KONFIG_INIT	CHAR1	CHAR	1	0	Configuration - Initialization needed
132	S_EZEIT	☐	S_EZEIT	UZEIT	TIMS	6	0	New arrival time
133	TEXT_BESCHAFFUNG	☐	TEXT_BESCHAFFUNG	TEXT35	CHAR	35	0	Procurement type text (purch. req., prod. or manuf. order)
134	MABNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
135	MUEBS	☐	MUEBS	MUEBS	CHAR	8	0	Characteristic display	VBMUE
136	MWERT01	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
137	MWERT02	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
138	MWERT03	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
139	MWERT04	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
140	MWERT05	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
141	MWERT06	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
142	MWERT07	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
143	MWERT08	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
144	MWERT09	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
145	MWERT10	☐	ATWRT	ATWRT	CHAR	30	0	Characteristic Value
146	MNAM01	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
147	MNAM02	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
148	MNAM03	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
149	MNAM04	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
150	MNAM05	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
151	MNAM06	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
152	MNAM07	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
153	MNAM08	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
154	MNAM09	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
155	MNAM10	☐	ATNAM	ATNAM	CHAR	30	0	Characteristic Name
156	MBEZ01	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
157	MBEZ02	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
158	MBEZ03	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
159	MBEZ04	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
160	MBEZ05	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
161	MBEZ06	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
162	MBEZ07	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
163	MBEZ08	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
164	MBEZ09	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
165	MBEZ10	☐	ATBEZ	TEXT30	CHAR	30	0	Characteristic description
166	BTN_FCODE	☐	BTN_FCODE	FCODE	CHAR	20	0	Function code for procurement button
167	BUKRSL	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
168	STAT01	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
169	STAT02	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
170	STAT03	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
171	STAT04	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
172	STAT05	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
173	STAT06	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
174	STAT07	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
175	STAT08	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
176	STAT09	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
177	STAT10	☐	STATUSFLAG	FLAG	CHAR	1	0	Active/inactive status
178	PVS01	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
179	PVS02	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
180	PVS03	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
181	PVS04	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
182	PVS05	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
183	PVS06	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
184	PVS07	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
185	PVS08	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
186	PVS09	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
187	PVS10	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
188	PVS11	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
189	PVS12	☐	PVSTXT	TEXT20	CHAR	20	0	Column title (quantity from product proposal)
190	CCODE	☐	W_PC_CCODE	W_PC_CCODE	CHAR	4	0	Catalog code
191	CCODE_HEAD	☐	CCODE_HEAD	W_PC_CCODE	CHAR	4	0	Product catalog code at header level in sales order
192	WMINR	☐	WMINR_HEAD	WMINR	CHAR	10	0	Product catalog at header level in sales order	*
193	MWSBK	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
194	ENDBP	☐	ENDBP	WERTV8	CURR	15	2	Total amount of item
195	ENDBK	☐	ENDBK	WERTV8	CURR	15	2	Total amount of document
196	TXT_MABNR	☐	TXT_MABNR	TEXT20	CHAR	20	0	Material (order number) description
197	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
198	VKONT	☐	CHAR12	CHAR12	CHAR	12	0	Character Field of Length 12
199	VKBEZ	☐	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
200	KZTLF_T	☐	BEZEI30	TEXT30	CHAR	30	0	Description
201	VTREF	☐	CHAR20	CHAR20	CHAR	20	0	Char 20
202	VTBEZ	☐	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
203	TXTHOL	☐	TXTHOL	TXTHOL	CHAR	255	0	Display text for Handover Loc (name, city, country, street)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RV45A	AUARTTO	TVAK	AUART
2	RV45A	BEDAE	T459A	BEDAE
3	RV45A	FFPRF	AD01C_PROF	PROFNR		1	CN
4	RV45A	KAPPL	T681A	KAPPL
5	RV45A	KNDNR	KNA1	KUNNR
6	RV45A	KPRGBZ	TPRG	PRGBZ
7	RV45A	MATNR	MARA	MATNR
8	RV45A	MEINS1	T006	MSEHI
9	RV45A	MUEBS	VBMUE	MUEBS
10	RV45A	POSNR	VBUP	POSNR
11	RV45A	PRGBZ	TPRG	PRGBZ
12	RV45A	SKOPF	WSOH	SKOPF		1	CN
13	RV45A	SPRAS	T002	SPRAS
14	RV45A	SPRAS_VOR	T002	SPRAS
15	RV45A	S_ABGRU	TVAG	ABGRU
16	RV45A	S_FAKSK	TVFS	FAKSP
17	RV45A	S_FAKSP	TVFS	FAKSP
18	RV45A	S_LIFSK	TVLS	LIFSP
19	RV45A	S_LIFSP	TVLS	LIFSP
20	RV45A	S_LPRIO	TPRIO	LPRIO
21	RV45A	S_PRGBZ	TPRG	PRGBZ
22	RV45A	UEPOS	VBUP	POSNR
23	RV45A	VBELNTO	VBUK	VBELN
24	RV45A	VKORG	TVKO	VKORG
25	RV45A	VRKME1	T006	MSEHI
26	RV45A	VRKME2	T006	MSEHI
27	RV45A	VRKME3	T006	MSEHI
28	RV45A	VRKME4	T006	MSEHI
29	RV45A	WAERS	TCURC	WAERS
30	RV45A	WAERZ	TCURC	WAERS
31	RV45A	WAKTION	WAKH	AKTNR	REF	1	CN
32	RV45A	WEMPF	KNA1	KUNNR
33	RV45A	ZIEME	T006	MSEHI
34	RV45A	ZIEME1	T006	MSEHI

History

Last changed by/on	SAP	20131127
SAP Release Created in