SAP ABAP Table /ISDFPS/S_BI_MATPLN (Transfer Structure for Stock List)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS (Application Component) Defense Forces and Public Security
     ⤷ /ISDFPS/BI_CONTENT (Package) BI Content Defense (Extractors And So On)

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/S_BI_MATPLN	Table Relationship Diagram
Short Description	Transfer Structure for Stock List

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	DELIVERY_DATE	☐	/ISDFPS/DELIVERY_DATE		DATS	8	0	Delivery Date
2	RECTYPE	☐	/ISDFPS/FDPMAT_RECTYPE	/ISDFPS/FDPMAT_RECTYPE	CHAR	3	0	Record Type Planning
3	STATUS	☐	/ISDFPS/STATUSICON_MAT	TV_IMAGE	CHAR	46	0	Status Icon
4	PREQ_REL	☐	/ISDFPS/PREQ_REL_X	XFLAG	CHAR	1	0	Indicates that PReq Is Released
5	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
6	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
7	ADVCODE	☐	/ISDFPS/ADVCODE	/ISDFPS/ADVCODE	CHAR	2	0	Advice Code	/ISDFPS/ADVCODE1
8	STACODE	☐	/ISDFPS/STACODE	/ISDFPS/STACODE	CHAR	2	0	Status Code	/ISDFPS/CSTACODE
9	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
10	MRP_AREA	☐	BERID	BERID	CHAR	10	0	MRP Area	*
11	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
12	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
13	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
14	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
15	FORCE_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
16	STORAGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
17	FLAG_TEMPLATE	☐	/ISDFPS/FLAG_TEMPLATE	XFLAG	CHAR	1	0	Template Row
18	HU_LOC	☐	/ISDFPS/HU_LOC	LGORT	CHAR	4	0	HU Storage Location	*
19	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
20	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
21	WBS_NO	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
22	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
23	HU_EXID	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
24	HU_ITEM_NUMBER	☐	VEPOS	VEPOS	NUMC	6	0	Handling Unit Item	*
25	PACK_MAT	☐	VHILM	MATNR	CHAR	18	0	Packaging Materials	*
26	QUANT	☐	/ISDFPS/QUINV	MENG13V	QUAN	13	3	Stock Quantity
27	QPLAN	☐	/ISDFPS/QPLAN	MENG13V	QUAN	13	3	Planned Quantity
28	QTRANS	☐	UMLMD	MENG13V	QUAN	13	3	Stock in transfer (from one storage location to another)
29	QUANT_B	☐	/ISDFPS/QUINV	MENG13V	QUAN	13	3	Stock Quantity
30	QPLAN_B	☐	/ISDFPS/QPLAN	MENG13V	QUAN	13	3	Planned Quantity
31	QTRANS_B	☐	UMLMD	MENG13V	QUAN	13	3	Stock in transfer (from one storage location to another)
32	QTY_UNIT	☐	/ISDFPS/DOC_MEINS	MEINS	UNIT	3	0	Unit of Measure	*
33	GROSS_WT	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
34	GROSS_WT_T	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
35	GROSS_WT_B	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
36	UNIT_OF_WT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
37	VOLUME	☐	VOLUM	MENG13	QUAN	13	3	Volume
38	VOLUME_T	☐	VOLUM	MENG13	QUAN	13	3	Volume
39	VOLUME_B	☐	VOLUM	MENG13	QUAN	13	3	Volume
40	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
41	X_PLAN	☐	/ISDFPS/FDPMAT_XPLAN		CHAR	1	0	Planned Indicator
42	X_ORDER	☐	/ISDFPS/FDPMAT_XORDER		CHAR	1	0	Ordered Indicator
43	X_DELIV	☐	/ISDFPS/FDPMAT_XDELIV	XFLAG	CHAR	1	0	Delivered Indicator
44	RELOC_ID	☐	/ISDFPS/RELOC_ID	/ISDFPS/RELOC_ID	CHAR	10	0	Relocation ID	*
45	RELOC_SEQ_ID	☐	/ISDFPS/RELOC_SEQ_ID	/ISDFPS/RELOC_SEQ_ID	CHAR	4	0	Relocation Step ID	*
46	RELSEQ_TYPE	☐	/ISDFPS/RELSEQ_TYPE	/ISDFPS/RELSEQ_TYPE	CHAR	1	0	Relocation Step Type	*
47	COUNTRY_B	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
48	REGION_B	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
49	POST_CODE_B	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
50	CITY_B	☐	AD_CITY1	TEXT40	CHAR	40	0	City
51	EXPIRYDATE	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
52	STATUSKEY	☐	DZUSCH	ZUSCH	CHAR	1	0	Batch status key
53	VENDRBATCH	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
54	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	*
55	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
56	STATXT	☐	/ISDFPS/STATUS_TXT	TEXT30	CHAR	30	0	Description of User Status of Technical Object
57	IDENT	☐	/ISDFPS/DE_LM_DEVICE_ID	/ISDFPS/DO_LM_DEVICE_ID	CHAR	14	0	Tail Number / Identifier
58	COUNTRY2	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
59	REGION2	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
60	POST_CODE2	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
61	CITY2	☐	AD_CITY1	TEXT40	CHAR	40	0	City
62	FORCE2_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
63	PLANT2	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
64	STORAGE_LOC2	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
65	HU_LOC2	☐	/ISDFPS/HU_LOC	LGORT	CHAR	4	0	HU Storage Location	*
66	FLAG_LOAN	☐	/ISDFPS/FLAG_LOAN	XFLAG	CHAR	1	0	Loan
67	RETURN_DATE	☐	/ISDFPS/RETURN_DATE	DATS	DATS	8	0	Return Date for Loan
68	FLAG_LOAN_RET	☐	/ISDFPS/FLAG_LOAN_RETURN	XFLAG	CHAR	1	0	Loan Return
69	FLAG_RETURN	☐	/ISDFPS/FLAG_RETURN	XFLAG	CHAR	1	0	Return Delivery
70	PNAME_MPO	☐	PVS_PNODE	PVS_PNODE	CHAR	40	0	iPPE Node Description
71	PNAME_EPA	☐	PVS_PNODE	PVS_PNODE	CHAR	40	0	iPPE Node Description
72	PNAME_PPA	☐	PVS_PNODE	PVS_PNODE	CHAR	40	0	iPPE Node Description
73	RESERV_NO	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
74	RES_ITEM	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
75	PREQ_NO	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
76	PREQ_ITEM	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
77	PO_NUMBER	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
78	PO_ITEM	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
79	DELIV_NUMB	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
80	DELIV_ITEM	☐	POSNR_VL	POSNR	NUMC	6	0	Delivery Item	*
81	VENDOR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
82	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
83	PUR_GROUP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
84	MRP_CTRLER	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
85	PREQ_NO_CS	☐	/ISDFPS/BANFN_CS	BANFN	CHAR	10	0	Cross-System PReq Number
86	PREQ_ITEM_CS	☐	/ISDFPS/BNFPO_CS	BNFPO	NUMC	5	0	Cross-System PReq Item	*
87	PLANNING_GUID	☐	/ISDFPS/PLANNING_GUID	SYSUUID_C	CHAR	32	0	Planning GUID
88	PO_TYPE	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
89	SP_STCK_NO	☐	LVS_SONUM	LVS_SONUM	CHAR	16	0	Special Stock Number
90	FLAG_MAINTENANCE	☐	/ISDFPS/FLAG_MAINTENANCE	XFLAG	CHAR	1	0	Relevant to Plant Maintenance
91	FLAG_COMPLETED	☐	/ISDFPS/FLAG_PREQ_COMPLETED	XFLAG	CHAR	1	0	Completely Processed
92	FLAG_FORWARDED	☐	/ISDFPS/FLAG_PREQ_FORWARDED	XFLAG	CHAR	1	0	PReq Was Forwarded
93	FLAG_DERIVED	☐	/ISDFPS/FLAG_PREQ_DERIVED	XFLAG	CHAR	1	0	PReq Is Derived (Forwarding)
94	FLAG_SUBITEM	☐	/ISDFPS/FLAG_SUBITEM	XFLAG	CHAR	1	0	Subitem
95	PREQ_CLOSED	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
96	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	*
97	SHIP_COND	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
98	PREQ_NAME	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
99	TOP_HU_EXTERNAL	☐	EXIDV	EXIDV	CHAR	20	0	External Handling Unit Identification
100	PACK_MAT_OBJECT	☐	VPOBJ	VPOBJ	CHAR	2	0	Packing Object
101	ATP_QUAN	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
102	PREQ_REQ_DATE	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
103	HU_LEAD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
104	ACC_ASS_CAT	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
105	MRP_TYPE	☐	DISMM	DISMM	CHAR	2	0	MRP Type	*
106	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	*
107	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
108	EXTMATLGRP	☐	EXTWG	EXTWG	CHAR	18	0	External material group	*
109	FLAG_RES_FWD	☐	/ISDFPS/FLAG_RES_FWD	XFLAG	CHAR	1	0	Forwarded Reservation
110	FLAG_SERNR_PREQ	☐	/ISDFPS/FLAG_SERNR_PREQ	XFLAG	CHAR	1	0	Serial Number PReq
111	FLAG_PROV	☐	/ISDFPS/FLAG_PROV		CHAR	1	0	Provisions
112	NSNID	☐	/ISDFPS/NSNID	/ISDFPS/NSNID	CHAR	9	0	NATO Stock Number
113	RIC	☐	/ISDFPS/RICODE	/ISDFPS/RICODE	CHAR	6	0	Reportable Item Code	*
114	CON_ID	☐	/ISDFPS/CON_ID	/ISDFPS/CON_ID	CHAR	5	0	Contingent Key
115	LOGSYS_SHP	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
116	SHIPMENT1	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
117	SHIPMENT2	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
118	SHIPMENT3	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
119	SHIPMENT4	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
120	SHIPMENT5	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
121	SHIPMENT6	☐	TKNUM	TKNUM	CHAR	10	0	Shipment Number	*
122	TRANS_GRP	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	*
123	LOADINGGRP	☐	LADGR	LADGR	CHAR	4	0	Loading Group	*
124	PRICE_UNIT	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
125	PRICE	☐	STPRS	WERT11V	CURR	11	2	Standard price

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/S_BI_MATPLN	ADVCODE	/ISDFPS/ADVCODE1	ADVCODE
2	/ISDFPS/S_BI_MATPLN	PRIO_REQ	PREQ	PRIO_REQ
3	/ISDFPS/S_BI_MATPLN	PRIO_URG	PURG	PRIO_URG
4	/ISDFPS/S_BI_MATPLN	STACODE	/ISDFPS/CSTACODE	STACODE	KEY

History

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