SAP ABAP Table FIP_S_MATERIAL_ALL_INFO (Material Information)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR-FIP (Application Component) Perishables Procurement
     ⤷ FIP_DDIC (Package) DDIC package for Fresh Item Procurement

Basic Data

Table Category	INTTAB	Structure
Structure	FIP_S_MATERIAL_ALL_INFO	Table Relationship Diagram
Short Description	Material Information

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	Material Master Settings (Detailed Data)
2	.INCLUDE	☐				0	0	FIP Material
3	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
4	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
5	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
6	WGBEZ	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
7	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
8	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
9	MHDHB	☐	FIP_MHDHB	DEC4	DEC	4	0	Total shelf life
10	MSTAE	☐	FIP_MSTAE	FIP_MMSTA	CHAR	2	0	Cross-Plant Material Status
11	MSTDE	☐	FIP_MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
12	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
13	LIQDT	☐	FIP_LIQDT	DATUM	DATS	8	0	Deletion date
14	FOLUP	☐	FIP_T_BAL_MATERIAL_FOLUP		TTYP	0	0
15	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
16	AKTKT	☐	FIP_AKTBEZ	TEXT40	CHAR	40	0	Promotion description
17	BRAND_ID	☐	FIP_BRAND_ID	FIP_BRAND_ID	CHAR	4	0	Brand
18	HERKL	☐	FIP_HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
19	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
20	RAUBE	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	*
21	STORAGE_DURATION	☐			STRG	0	0
22	MATERIAL_PIC	☐			STRG	0	0
23	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
24	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
25	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
26	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
27	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
28	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
29	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
30	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
31	COMPONENTS	☐	FIP_T_BAL_MATERIAL_COMP		TTYP	0	0
32	VARIANTS	☐	FIP_T_BAL_MATERIAL_VAR		TTYP	0	0
33	CONVERSIONS	☐	FIP_T_UNIT_CONVERSION		TTYP	0	0
34	UOM	☐	FIP_T_BAL_MATERIAL_UOM		TTYP	0	0
35	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
36	UNAME	☐	UNAME	UNAME	CHAR	12	0	User Name
37	.INCLUDE	☐				0	0	Supply Plant-Material Relational Information
38	LFRHY	☐	FIP_LFRHY	FIP_MRPPP	CHAR	3	0	Planning cycle
39	PPTXT	☐	FIP_PPTXT	TEXT40	CHAR	40	0	PP Planning calendar: short description
40	MRPPP	☐	FIP_MRPPP	FIP_MRPPP	CHAR	3	0	PPC planning calendar
41	PPTXT_D	☐	FIP_PPTXT	TEXT40	CHAR	40	0	PP Planning calendar: short description
42	DEFAULT_ORDER_TYPE	☐	FIP_ORDER_TYPE	FIP_ORDER_TYPE_D	CHAR	30	0	Material Order Type
43	FPRFM	☐	FIP_FPRFM	FIP_MPPRF	CHAR	3	0	Distribution profile of material in plant
44	DELIV_DATE_SP_PL	☐	FIP_DELIVERY_TO_SP		INT1	3	0	Delivery date to Supply Plant (in days)
45	HORIZON	☐	FIP_PL_HORIZON	DEC3	DEC	3	0	Defines the date range together with the delivery date
46	DISTRIBUTION_STRATEGY	☐	FIP_DISTRIBUTION_STRATEGY	FIP__DISTRIBUTION_STRATEGY	CHAR	2	0	Distribution strategy
47	FAIR_SHARE_PROFILE	☐	FIP_FAIR_SHARE_RULE	FIP_FAIR_SHARE_RULE	CHAR	2	0	Fair share rule
48	ROUNDING_STRATEGY	☐	FIP_ROUNDING_STRATEGY	FIP_ROUNDING_STRATEGY	CHAR	2	0	Rounding Strategy
49	PRICE_VALID_FOR	☐	FIP_PRICE_VALID_FOR	FIP_PRICE_VALID_FOR	CHAR	20	0	Price Valid For
50	STATISTICAL_DATA	☐	FIP_T_MAT_STYPE		TTYP	0	0
51	.INCLUDE	☐				0	0	Vendor-Material Relational Information
52	MAIN_VENDOR	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
53	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
54	ANGNR	☐	FIP_ANGNR	FIP_ANGNR	CHAR	10	0	Quotation Number
55	IDNLF	☐	FIP_IDNLF	FIP_IDNEX	CHAR	35	0	Material Number Used by Vendor
56	HERKL_R	☐	FIP_HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
57	LANDX_R	☐	LANDX	TEXT15	CHAR	15	0	Country Name
58	LZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
59	PURCHASE_PRICES	☐	FIP_T_PURCHASE_PRICE_DETAILS		TTYP	0	0
60	UOM_SPECIFIC	☐	FIP_S_BAL_MATERIAL_UOM		STRU	0	0
61	MEINH	☐	FIP_LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	*
62	MSEHL	☐	MSEHL	TEXT30	CHAR	30	0	Unit of Measurement Text (Maximum 30 Characters)
63	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
64	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
65	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
66	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	*
67	LAENG	☐	LAENG	MENG13	QUAN	13	3	Length
68	BREIT	☐	BREIT	MENG13	QUAN	13	3	Width
69	HOEHE	☐	HOEHE	MENG13	QUAN	13	3	Height
70	MEABM	☐	MEABM	MEINS	UNIT	3	0	Unit of Dimension for Length/Width/Height	*
71	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
72	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
73	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
74	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
75	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
76	MSEH3	☐	MSEH3	MSEH3	CHAR	3	0	External Unit of Measurement in Commercial Format (3-Char.)
77	MSEH6	☐	MSEH6	MSEH6	CHAR	6	0	External Unit of Measurement in Technical Format (6-Char.)
78	VABME	☐	FIP_VABME	FIP_VABME	CHAR	1	0	Variable Purchase Order Unit Active
79	.INCLUDE	☐				0	0	Recipient-Material Relational Information
80	MMSTA	☐	FIP_MMSTA	FIP_MMSTA	CHAR	2	0	Plant-Specific Material Status
81	STORE_AVAILIBILITY_DATE	☐			STRG	0	0
82	BSTRF	☐	FIP_BSTRF	MENG13	QUAN	13	3	rounding value
83	.INCLUDE	☐				0	0	Data Common to all Material Relations
84	ACTIVE	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
85	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
86	ENDPA	☐	FIP_ENDPA	WERTV6	CURR	11	2	Current Final Price (FIP)
87	SPABA	☐	FIP_SPABA	WERTV6	CURR	11	2	Current margin (gross) (FIP)
88	SPANA	☐	FIP_SPANA	WERTV6	CURR	11	2	Current margin (net) (FIP)
89	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
90	VKABA	☐	FIP_VKABA	DATUM	DATS	8	0	Current Sales Conditions Valid From
91	VKBIA	☐	FIP_VKBIA	DATUM	DATS	8	0	Current Sales Conditions Valid To
92	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
93	BPRME	☐	FIP_BBPRM	MEINS	UNIT	3	0	Order Price Unit (Purchasing)	*
94	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
95	RECIPIENT_NUM	☐	FIP_RECIPIENT_NUM	CHAR10	CHAR	10	0	FIP Recipient Number
96	SUPLG_PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
97	RECIPIENT_TYPE	☐	FIP_WDRD_RTYPE	FIP_WDRD_RTYPE	CHAR	1	0	Delivery Relationship: Type of Goods Recipient

History

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