SAP ABAP Table MMDA_PUR_S_PO_ACC (Extract structure for purchasing account)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM (Application Component) Materials Management
     ⤷ MMDA (Package) Data Provisioning for Real Time Reporting in MM

Basic Data

Table Category	INTTAB	Structure
Structure	MMDA_PUR_S_PO_ACC	Table Relationship Diagram
Short Description	Extract structure for purchasing account

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	ROCANCEL	☐	ROCANCEL	BOOLE	CHAR	1	0	Indicator: Cancel Data Record
2	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
3	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
4	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
5	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
6	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	*
7	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
8	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
9	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
10	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
11	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
12	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	*
13	LLIEF	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	*
14	LOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
15	ORGLOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
16	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
17	STATU	☐	ESTAK	ESTAK	CHAR	1	0	Status of Purchasing Document
18	SYDAT	☐	MC_ERFDAT	DATUM	DATS	8	0	Date on which the purchasing document was entered
19	WAERS	☐	BSTWA	WAERS	CUKY	5	0	Purchase order currency	*
20	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
21	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
22	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
23	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
24	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering
25	BWAPPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
26	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
27	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
28	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
29	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
30	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
31	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
32	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
33	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
34	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
35	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
36	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
37	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
38	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
39	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
40	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
41	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
42	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
43	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
44	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
45	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
46	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
47	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
48	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
49	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
50	AEDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
51	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
52	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
53	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
54	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
55	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
56	EFFHW	☐	MC_EFFHW	WERTV8	CURR	15	2	Effective order value in local currency
57	EFFWR	☐	MC_EFFWR	WERTV8	CURR	15	2	Effective order value
58	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
59	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
60	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
61	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
62	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
63	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
64	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
65	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
66	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
67	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
68	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
69	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
70	KTOPL	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
71	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
72	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
73	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
74	NETHW	☐	MC_NETHW	WERTV8	CURR	15	2	Net purchase local value (base unit)
75	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
76	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
77	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
78	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
79	PS_PSP_PNR	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
80	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
81	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
82	VBELP	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	*
83	VPROZ	☐	VPROZ	VPROZ	DEC	3	1	Distribution percentage in the case of multiple acct assgt
84	XBAUF	☐	XBAUF	XFELD	CHAR	1	0	Post To Order
85	XBKST	☐	XBKST	XFELD	CHAR	1	0	Posting to cost center?
86	XBPRO	☐	XBPRO	XFELD	CHAR	1	0	Post to project
87	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment

History

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