SAP ABAP Table MMDA_IM_S_BX_BF_UM (Common structure like structures for BX, BF, UM datasources)

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_IM_S_BX_BF_UM	Table Relationship Diagram
Short Description	Common structure like structures for BX, BF, UM datasources

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	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
3	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
4	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
5	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
6	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	*
7	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
8	BNBTR	☐	MC_BNBTR	WERT15	CURR	15	2	Delivery costs in local currency
9	BSTAUS	☐	BSTAUS	BSTAUS	CHAR	1	0	Stock Values in the Logistics Information System
10	BSTTYP	☐	BSTTYP	BSTTYP	CHAR	1	0	Stock categories in the Logistics Information System
11	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
12	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
13	BWAPPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
14	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
15	BWBREL	☐	MCBW_BREL	MCBW_BREL	CHAR	1	0	BW: Stock Relevance
16	BWCOUNTER	☐	MCBW_COUNTER	MCBW_COUNTER	NUMC	6	0	BW: Unique Identification of Line Item
17	BWGEO	☐	MCBW_GEO	WERTV10	CURR	19	2	BW: Cost Value in Local Currency
18	BWGVO	☐	MCBW_GVO	WERTV10	CURR	19	2	BW: Retail Value in Local Currency
19	BWGVP	☐	MCBW_GVP	WERTV10	CURR	19	2	BW: Retail Value with Tax in Local Currency
20	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
21	BWMNG	☐	MCBW_MNG	MENGV15_3	QUAN	15	3	BW: Quantity in Base Unit of Measure
22	BWPSPEX	☐	PS_PSPEX	PS_PSPEX	CHAR	24	0	Work Breakdown Structure Element (External)
23	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
24	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
25	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
26	DMBTR	☐	MC_DMBTR	WERT15	CURR	15	2	Amount in local currency
27	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
28	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
29	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	*
30	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
31	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
32	GRUND	☐	MB_GRUND	NUMC4	NUMC	4	0	Reason for goods movment
33	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
34	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
35	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
36	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
37	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
38	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
39	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
40	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
41	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
42	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
43	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	*
44	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
45	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	*
46	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	*
47	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
48	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
49	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
50	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
51	MENGE	☐	MC_MENG	MENGV15	QUAN	15	3	Quantity
52	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
53	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
54	PALAN	☐	PALAN	PALAN	DEC	11	0	WMS Number of pallets
55	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
56	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
57	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
58	SAKTO	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
59	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
60	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
61	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	*
62	WAERS	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
63	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
64	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
65	ZEILE	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
66	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
67	NOPOS	☐	MC_NOPOS	PL2	DEC	3	0	Counter for Items
68	TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

History

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