SAP ABAP Table TXW_MM_PR (MM Purchase Requisition)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

Table Category	INTTAB	Structure
Structure	TXW_MM_PR	Table Relationship Diagram
Short Description	MM Purchase Requisition

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	*
2	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
3	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
4	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
5	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
6	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
7	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
11	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
12	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
13	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
14	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
15	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
16	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
17	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
18	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
19	MENGE	☐	TXW_BAMNG	CHAR17	CHAR	17	0	Purchase Requisition Quantity
20	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	*
21	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
22	PREIS	☐	TXW_PREIS	CHAR14	CHAR	14	0	Price in Purchase Requisition
23	PEINH	☐	TXW_EPEIN	CHAR6	CHAR	6	0	Price Unit
24	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
25	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
26	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
27	KFLAG	☐	KFLAG	XFELD	CHAR	1	0	Acct.asst.changeable
28	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
29	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
30	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
31	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
32	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
33	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	*
34	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	*
35	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
36	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
37	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
38	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
39	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
40	ZUGBA	☐	DZUGBA	XFELD	CHAR	1	0	Assigned Source of Supply
41	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
42	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
43	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
44	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
45	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
46	BSMNG	☐	TXW_BSMNG	CHAR17	CHAR	17	0	Quantity Ordered Against this Purchase Requisition
47	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
48	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
49	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
50	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
51	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
52	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
53	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
54	BMEIN	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
55	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
56	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
57	BPUEB	☐	BPUEB	BPUEB	CHAR	1	0	Adopt requisition price in purchase order
58	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
59	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
60	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
61	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
62	GEBER	☐	FM_FUND	BP_GEBER	CHAR	10	0	Fund	*
63	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
64	MNG02	☐	TXW_MNG06	CHAR18	CHAR	18	0	Committed Quantity
65	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
66	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
67	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	*
68	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	*
69	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
70	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
71	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
72	FORDN	☐	SFORDN	EBELN	CHAR	10	0	Framework Order	*
73	FORDP	☐	FORDP	EBELP	NUMC	5	0	Item of framework order	*
74	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
75	BESWK	☐	BESWK	WERKS	CHAR	4	0	Procuring Plant	*
76	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20110901
SAP Release Created in	606