SAP ABAP Table INV_INVENTORY_BY_LOC_MATQR (Inventory by location and material query)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-IM-GF-ES (Application Component) Enterprise Services in Inventory Management
     ⤷ OPS_SE_INV_XI_PROXY (Package) Web Service Proxies Inventory Management

Basic Data

Table Category	INTTAB	Structure
Structure	INV_INVENTORY_BY_LOC_MATQR	Table Relationship Diagram
Short Description	Inventory by location and material query

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	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
2	INVENTORY_BY_LOCATION_AND_MAT	☐	SAPPLCO_INVENTORY_BY_LOC_MATQR		STRU	0	0
3	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
4	INV_SELECTION_BY_LOC_MATERIAL	☐	SAPPLCO_INV_LOC_MATQR_INVSEL		STRU	0	0
5	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
6	MAIN_INVENTORY_INDICATORS	☐	SAPPLCO_INVLOCMATQR_MAIN_IND		STRU	0	0
7	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
8	LOGISTICS_AREA_INV_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
9	LOCATION_INV_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
10	SEPARATE_INV_BY_BATCHES_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
11	SEPARATE_INV_BY_LOG_AREA_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
12	AGGREGATE_INV_OVER_BATCHES_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
13	AGGREGATE_INV_OVER_LOG_AREA	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
14	AGGREGATE_UNREST_AND_POS_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
15	SERIAL_NUMBER_REQUESTED_INDICA	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
16	SPECIAL_INVENTORY_INDICATORS	☐	SAPPLCO_INVLOCMATQR_SPEC_IND		STRU	0	0
17	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
18	SUPPLIER_CONSIGNMENT_INV_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
19	SEPARATE_SUPPLIER_CONSIGNMENT	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
20	SUPPLIER_RET_PACKAGES_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
21	SEPARATE_SUPPLIER_RET_PACKAGES	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
22	CUSTOMER_CONSIGNMENT_INV_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
23	SEPARATE_CUSTOMER_CONSIGNMENT	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
24	CUSTOMER_RET_PACKAGES_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
25	SEPARATE_CUSTOMER_RET_PACKAGES	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
26	SUBCONTRACTOR_INV_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
27	SEPARATE_SUBCONTRACTOR	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
28	SALES_ORDER_INV_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
29	SEPARATE_SALES_ORDER	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
30	PROJECT_INV_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
31	SEPARATE_PROJECT	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
32	EXPECTED_INVENTORY_CHANGE_IND	☐	SAPPLCO_INVLOCMATQR_EXPCHG_IND		STRU	0	0
33	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
34	ON_ORDER_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
35	ON_ORDER_CONSIGN_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
36	GR_BLOCKED_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
37	STOCK_TRANSFER_ORD_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
38	IN_TRANSIT_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
39	PRODUCTION_ORD_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
40	INQUIRY_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
41	QUOTATION_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
42	SALES_ORDER_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
43	SCHEDULING_AGREE_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
44	SALES_CONTRACT_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
45	SO_FREE_CHARGE_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
46	OUT_DELIVERY_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
47	RESERVATIONS_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
48	RCPT_RESERVATIONS_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
49	POINT_OF_SALE_EXP_CHG_REQ	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
50	MATERIAL	☐	SAPPLCO_INVLOCMATQR_MAT_TTY		TTYP	0	0
51	LOCATION	☐	SAPPLCO_INVLOCMATQR_LOC_TTY		TTYP	0	0
52	PARTY	☐	SAPPLCO_INVLOCMATQR_PARTY_ST		STRU	0	0
53	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
54	SUPPLIER_PARTY	☐	SAPPLCO_PARTY_INTERNAL_ID_TAB		TTYP	0	0
55	CUSTOMER_PARTY	☐	SAPPLCO_PARTY_INTERNAL_ID_TAB		TTYP	0	0
56	SUPPLIER_SUBCONTRACTOR_PARTY	☐	SAPPLCO_PARTY_INTERNAL_ID_TAB		TTYP	0	0
57	SALES_ORDER_ID	☐	SAPPLCO_SALES_ORDER_TTY		TTYP	0	0
58	PROJECT_WORK_BREAKDOWN_STRUCT	☐	SAPPLCO_PROJECT_WORK_BREAK_TTY		TTYP	0	0
59	PROCESSING_CONDITIONS	☐	SAPPLCO_INVLOCMATQR_PROCOND_ST		STRU	0	0
60	CONTROLLER	☐	PRXCTRLTAB		TTYP	0	0
61	UNLIMITED_QUERY_HITS_INDICATOR	☐	SAPPLCO_INDICATOR		CHAR	5	0	Indicator is the representation of a situation that has exac
62	QUERY_HITS_MAXIMUM_NUMBER_VAL	☐	SAPPLCO_NUMBER_VALUE		INT4	10	0	Proxy Data Element (Generated)

History

Last changed by/on	SAP	20131127
SAP Release Created in	602