SAP ABAP Table EKPR (Transfer: MM Purchase Requisition)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CO-OM-OPA (Application Component) Overhead Cost Orders
     ⤷ KAO (Package) Cost Accounting: Commitments Management

Basic Data

Table Category	INTTAB	Structure
Structure	EKPR	Table Relationship Diagram
Short Description	Transfer: 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	T000
2	RFTYP	☐	AWTYP	AWTYP	CHAR	5	0	Reference procedure	*
3	BANFN	☑	BANFN	BANFN	CHAR	10	0	Purchase requisition number
4	RFORG	☐	AWORG	AWORG	CHAR	10	0	Reference organisational units
5	RFSYS	☐	AWSYS	LOGSYS	CHAR	10	0	Logical system of source document	*
6	BNFPO	☑	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
7	ZEBKN	☑	DZEBKN	ZEBKN	NUMC	2	0	Serial number for PReq account assignment segment
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
10	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
11	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
12	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
13	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
14	KNTYP	☐	KNTYP	KNTYP	CHAR	1	0	Condition Cat.: Frt, Tax, Basic Price=Revenue, Price, Cost
15	TWAER	☐	TWAER	WAERS	CUKY	5	0	Transaction Currency	*
16	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
17	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
18	LFDAT	☐	LFDAT	DATUM	DATS	8	0	Delivery date
19	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
20	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
21	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
22	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
23	VRGNG	☐	CO_VORGANG	J_VORGANG	CHAR	4	0	CO Business Transaction	*
24	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
25	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
26	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
27	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
28	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
29	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
30	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
31	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
32	VBELP	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
33	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
34	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
35	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
36	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
37	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
38	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
39	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	*
40	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
41	BAWTW	☐	BAWTW	WERT7	CURR	13	2	Purchase requisition value (transaction currency = TW)
42	BAWHW	☐	BAWHW	WERT7	CURR	13	2	Purchase requisition value (local currency = LC)
43	BSMNG	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
44	BEWTW	☐	BEWTW	WERT7	CURR	13	2	Real total value (purchase order currency = TC)
45	BEWHW	☐	BEWHW	WERT7	CURR	13	2	Real total value (local currency = LC)
46	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
47	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
48	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
49	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
50	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
51	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
52	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	*
53	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	*
54	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
55	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
56	XBAPI	☐	XFELD	XFELD	CHAR	1	0	Checkbox
57	CWHWO	☐	CWHWO	WERT7	CURR	13	2	Cost Commitments (Local Currency = LC)
58	CWTWO	☐	CWTWO	WERT7	CURR	13	2	Cost Commitments (Transaction Currency = TC)
59	FM_TRANS_DATE	☐	FM_TRANS_DATE	DATUM	DATS	8	0	FM Transaction Date
60	FM_TRANS_PERI	☐	CO_PERIO	PERBL	NUMC	3	0	Period
61	.INCLUDE	☐				0	0
62	.INCLUDE	☐				0	0	Include for the Reduction of Funds Reservations (FM)
63	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
64	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
65	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
66	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
67	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
68	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
69	INTROW	☐	INTROW	NUMC10	NUMC	10	0	Internal line number for limits
70	MAPNO	☐	MAPNO	NUMC4	NUMC	4	0	Mapping Field f. PACKNO, INTROW at Item Level for Commitment
71	MENGE_F	☐	BAMNG_F		FLTP	16	16	Purchase Requisition Quantity Floating Point Number
72	BSMNG_F	☐	BSTMG_F		FLTP	16	16	PO Quantity Floating Point Number
73	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
74	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
75	MEASURE	☐	FM_MEASURE	FM_MEASURE	CHAR	24	0	Funded Program	*
76	FM_SPLIT	☐	FMSP_SPLIT_RESULT_FLAG	FLAG	CHAR	1	0	Line is Result of Account Assignment Distribution
77	.INCLU--AP	☐				0	0	FMFG Additional Fields
78	FMFGUS_KEY	☐	FMFG_US_KEY	SYSUUID_22	CHAR	22	0	United States Federal Government Fields

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKPR	BNFPO	EBAN	BNFPO
2	EKPR	MANDT	T000	MANDT

History

Last changed by/on	SAP	20140121
SAP Release Created in