SAP ABAP Table /ISDFPS/FDPMAT_STOCKLIST (Transfer Structure for Stock List)
Hierarchy
EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   IS-DFS-OF-FDP (Application Component) Structures Workbench
     /ISDFPS/FDP (Package) Armed Forces and Deployment Planning
Basic Data
Table Category INTTAB    Structure 
Structure /ISDFPS/FDPMAT_STOCKLIST   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 RECTYPE_TEXT /ISDFPS/FDPMAT_RECTEXT QKURZTEXT15 CHAR 15   0   Record Type Text  
4 STATUSICON /ISDFPS/STATUSICON_MAT TV_IMAGE CHAR 46   0   Status Icon  
5 PREQ_REL /ISDFPS/PREQ_REL_X XFLAG CHAR 1   0   Indicates that PReq Is Released  
6 PREQ_REJ /ISDFPS/PREQ_REJ XFLAG CHAR 1   0   Indicates that PReq Is Rejected  
7 PRIO_REQ PRIO_REQ PRIO_REQ NUMC 3   0   Requirement Priority PREQ
8 PRIO_URG PRIO_URG PRIO_URG NUMC 2   0   Requirement Urgency PURG
9 ADVCODE /ISDFPS/ADVCODE /ISDFPS/ADVCODE CHAR 2   0   Advice Code /ISDFPS/ADVCODE1
10 STACODE /ISDFPS/STACODE /ISDFPS/STACODE CHAR 2   0   Status Code /ISDFPS/CSTACODE
11 PLANT WERKS_D WERKS CHAR 4   0   Plant *
12 PLANT_TEXT NAME1 TEXT30 CHAR 30   0   Name  
13 MRP_AREA BERID BERID CHAR 10   0   MRP Area *
14 FORCE_ID /ISDFPS/FORCE_ID SYSUUID_C CHAR 32   0   Internal Key for Force Element  
15 FORCE_CNT /ISDFPS/FORCE_CNT NUMC6 NUMC 6   0   Internal (Version) Counter  
16 FORCE_OBJID HROBJID HROBJID NUMC 8   0   Object ID *
17 FORCE_NAME SHORT_D TEXT12 CHAR 12   0   Object Abbreviation  
18 FORCE_PRIO /ISDFPS/PRIO /ISDFPS/PRIO CHAR 1   0   Organizational Priority (Obsolete) *
19 STORAGE_LOC LGORT_D LGORT CHAR 4   0   Storage location *
20 STOR_LOC_TEXT LGOBE TEXT16 CHAR 16   0   Description of Storage Location  
21 HU_LOC /ISDFPS/HU_LOC LGORT CHAR 4   0   HU Storage Location *
22 MATKL MATKL MATKL CHAR 9   0   Material Group *
23 MATNR MATNR MATNR CHAR 18   0   Material Number *
24 FLAG_TEMPLATE /ISDFPS/FLAG_TEMPLATE XFLAG CHAR 1   0   Template Row  
25 MAKTX MAKTX TEXT40 CHAR 40   0   Material description  
26 BATCH CHARG_D CHARG CHAR 10   0   Batch Number *
27 BATCH_TEXT KZTXT_BATCH TEXT40 CHAR 40   0   Short text for batch  
28 PSPNR PS_POSNR PS_POSNR NUMC 8   0   WBS Element *
29 PSPNR_TEXT /ISDFPS/TEXT40 ALLTEXT CHAR 40   0   Text  
30 SERNR GERNR GERNR CHAR 18   0   Serial Number  
31 HU_EXID EXIDV EXIDV CHAR 20   0   External Handling Unit Identification  
32 QUANT /ISDFPS/QUINV MENG13V QUAN 13   3   Stock Quantity  
33 QBLOCK SPEME MENG13V QUAN 13   3   Blocked stock  
34 QQUAL INSME MENG13V QUAN 13   3   Stock in Quality Inspection  
35 QTRANS UMLMD MENG13V QUAN 13   3   Stock in transfer (from one storage location to another)  
36 QLOCK /ISDFPS/QLOCK MENG13V QUAN 13   3   Stock Not Free Batch  
37 SERNR_PREQ /ISDFPS/SERNR_PREQ GERNR CHAR 18   0   Serial Number  
38 X_PLAN /ISDFPS/FDPMAT_XPLAN   CHAR 1   0   Planned Indicator  
39 X_ORDER /ISDFPS/FDPMAT_XORDER   CHAR 1   0   Ordered Indicator  
40 X_DELIV /ISDFPS/FDPMAT_XDELIV XFLAG CHAR 1   0   Delivered Indicator  
41 RELOC_ID /ISDFPS/RELOC_ID /ISDFPS/RELOC_ID CHAR 10   0   Relocation ID *
42 RELOC_SEQ_ID /ISDFPS/RELOC_SEQ_ID /ISDFPS/RELOC_SEQ_ID CHAR 4   0   Relocation Step ID *
43 PACK_MAT VHILM MATNR CHAR 18   0   Packaging Materials *
44 QAUTH /ISDFPS/FORCEM_QUANT   NUMC 8   0   Number  
45 EXPIRYDATE VFDAT DATUM DATS 8   0   Shelf Life Expiration or Best-Before Date  
46 STATUSKEY DZUSCH ZUSCH CHAR 1   0   Batch status key  
47 VENDRBATCH LICHN LICHN CHAR 15   0   Vendor Batch Number  
48 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number *
49 ESTAT J_ESTAT J_ESTAT CHAR 5   0   User Status *
50 STATXT /ISDFPS/STATUS_TXT TEXT30 CHAR 30   0   Description of User Status of Technical Object  
51 IDENT /ISDFPS/DE_LM_DEVICE_ID /ISDFPS/DO_LM_DEVICE_ID CHAR 14   0   Tail Number / Identifier  
52 FORCE2_ID /ISDFPS/FORCE_ID SYSUUID_C CHAR 32   0   Internal Key for Force Element  
53 FORCE2_OBJID HROBJID HROBJID NUMC 8   0   Object ID *
54 FORCE2_CNT /ISDFPS/FORCE_CNT NUMC6 NUMC 6   0   Internal (Version) Counter  
55 FORCE2_NAME SHORT_D TEXT12 CHAR 12   0   Object Abbreviation  
56 FORCE2_PRIO /ISDFPS/PRIO /ISDFPS/PRIO CHAR 1   0   Organizational Priority (Obsolete) *
57 PLANT2 WERKS_D WERKS CHAR 4   0   Plant *
58 PLANT2_TEXT NAME1 TEXT30 CHAR 30   0   Name  
59 STORAGE_LOC2 LGORT_D LGORT CHAR 4   0   Storage location *
60 STOR_LOC2_TEXT LGOBE TEXT16 CHAR 16   0   Description of Storage Location  
61 HU_LOC2 /ISDFPS/HU_LOC LGORT CHAR 4   0   HU Storage Location *
62 FLAG_LOAN /ISDFPS/FLAG_LOAN XFLAG CHAR 1   0   Loan  
63 RETURN_DATE /ISDFPS/RETURN_DATE DATS DATS 8   0   Return Date for Loan  
64 FLAG_LOAN_RET /ISDFPS/FLAG_LOAN_RETURN XFLAG CHAR 1   0   Loan Return  
65 FLAG_RETURN /ISDFPS/FLAG_RETURN XFLAG CHAR 1   0   Return Delivery  
66 ITEM_CS /ISDFPS/ITEM_CS /ISDFPS/ITEM_CS CHAR 1   0   Cross-System Item Category  
67 PNAME PVS_PNODE PVS_PNODE CHAR 40   0   iPPE Node Description  
68 PNTEXT PVS_PNODETX TEXT60 CHAR 60   0   Short Text for iPPE Node  
69 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements *
70 PREQ_NO BANFN BANFN CHAR 10   0   Purchase requisition number  
71 PREQ_ITEM BNFPO BNFPO NUMC 5   0   Item number of purchase requisition *
72 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
73 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
74 VBELN VBELN_VL VBELN CHAR 10   0   Delivery *
75 POSNR POSNR_VL POSNR NUMC 6   0   Delivery Item *
76 VENDOR ELIFN LIFNR CHAR 10   0   Vendor's account number *
77 EKORG EKORG EKORG CHAR 4   0   Purchasing organization *
78 EKGRP EKGRP EKGRP CHAR 3   0   Purchasing group *
79 DISPO DISPO DISPO CHAR 3   0   MRP controller *
80 BANFN_CS /ISDFPS/BANFN_CS BANFN CHAR 10   0   Cross-System PReq Number  
81 BNFPO_CS /ISDFPS/BNFPO_CS BNFPO NUMC 5   0   Cross-System PReq Item *
82 COMNT /ISDFPS/COMNT TEXT40 CHAR 40   0   Planning Comment  
83 PLANNING_GUID /ISDFPS/PLANNING_GUID SYSUUID_C CHAR 32   0   Planning GUID  
84 REF_GUID /ISDFPS/PLANNING_GUID SYSUUID_C CHAR 32   0   Planning GUID  
85 REF_TYPE /ISDFPS/MATPLN_REFTYPE /ISDFPS/MATPLN_REF CHAR 2   0   Type of Reference Relationship  
86 REF_GUID2 /ISDFPS/PLANNING_GUID SYSUUID_C CHAR 32   0   Planning GUID  
87 REF_TYPE2 /ISDFPS/MATPLN_REFTYPE /ISDFPS/MATPLN_REF CHAR 2   0   Type of Reference Relationship  
88 QMATNR /ISDFPS/QUINV MENG13V QUAN 13   3   Stock Quantity  
89 BSART BSART BSART CHAR 4   0   Order Type (Purchasing) *
90 RECORD_INVISIBLE CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
91 VEPOS VEPOS VEPOS NUMC 6   0   Handling Unit Item *
92 SONUM LVS_SONUM LVS_SONUM CHAR 16   0   Special Stock Number  
93 LINE_GUID /ISDFPS/PLANNING_GUID SYSUUID_C CHAR 32   0   Planning GUID  
94 LOCATION_S_GUID /ISDFPS/LOCATION_ID SYSUUID_C CHAR 32   0   ISDFPS: Location ID (GUID)  
95 LOCATION_D_GUID /ISDFPS/LOCATION_ID SYSUUID_C CHAR 32   0   ISDFPS: Location ID (GUID)  
96 FLAG_TEXT /ISDFPS/FLAG_TEXT XFELD CHAR 1   0   Item Text Available  
97 FLAG_MAINTENANCE /ISDFPS/FLAG_MAINTENANCE XFLAG CHAR 1   0   Relevant to Plant Maintenance  
98 FLAG_COMPLETED /ISDFPS/FLAG_PREQ_COMPLETED XFLAG CHAR 1   0   Completely Processed  
99 FLAG_FORWARDED /ISDFPS/FLAG_PREQ_FORWARDED XFLAG CHAR 1   0   PReq Was Forwarded  
100 FLAG_DERIVED /ISDFPS/FLAG_PREQ_DERIVED XFLAG CHAR 1   0   PReq Is Derived (Forwarding)  
101 FLAG_SUBITEM /ISDFPS/FLAG_SUBITEM XFLAG CHAR 1   0   Subitem  
102 EBAKZ EBAKZ XFELD CHAR 1   0   Purchase requisition closed  
103 ROUTE ROUTE ROUTE CHAR 6   0   Route *
104 VSBED VSBED VSBED CHAR 2   0   Shipping conditions *
105 DELDATE_REF /ISDFPS/DEL_DATE_REF DATS DATS 8   0   Referenced Delivery Date  
106 AFNAM AFNAM AFNAM CHAR 12   0   Name of requisitioner/requester  
107 TOP_HU_EXTERNAL EXIDV EXIDV CHAR 20   0   External Handling Unit Identification  
108 TOP_HU_INTERNAL VENUM VENUM CHAR 10   0   Internal Handling Unit Number *
109 VENUM VENUM VENUM CHAR 10   0   Internal Handling Unit Number *
110 VPOBJ VPOBJ VPOBJ CHAR 2   0   Packing Object  
111 ATP_QUAN MNG06 MENGV13 QUAN 13   3   Committed quantity  
112 PREQ_REQ_DATE BADAT DATUM DATS 8   0   Requisition (request) date  
113 HU_LEAD CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
114 ACC_ASS_CAT KNTTP KNTTP CHAR 1   0   Account assignment category *
115 MRP_TYPE DISMM DISMM CHAR 2   0   MRP Type *
116 MTART MTART MTART CHAR 4   0   Material type *
117 EXTWG EXTWG EXTWG CHAR 18   0   External material group *
118 RSPOS RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
119 FLAG_RES_FWD /ISDFPS/FLAG_RES_FWD XFLAG CHAR 1   0   Forwarded Reservation  
120 DOC_MEINS /ISDFPS/DOC_MEINS MEINS UNIT 3   0   Unit of Measure *
121 STATUSICON_TEC /ISDFPS/STATUSICON_MAT TV_IMAGE CHAR 46   0   Status Icon  
122 FLAG_SERNR_PREQ /ISDFPS/FLAG_SERNR_PREQ XFLAG CHAR 1   0   Serial Number PReq  
123 RELSEQ_TYPE /ISDFPS/RELSEQ_TYPE /ISDFPS/RELSEQ_TYPE CHAR 1   0   Relocation Step Type *
124 NSNID /ISDFPS/NSNID /ISDFPS/NSNID CHAR 9   0   NATO Stock Number  
125 QUANT_POSTING /ISDFPS/POSTING_QUANTITY MENG13V QUAN 13   3   Transfer Posting Quantity  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /ISDFPS/FDPMAT_STOCKLIST ADVCODE /ISDFPS/ADVCODE1 ADVCODE    
2 /ISDFPS/FDPMAT_STOCKLIST PRIO_REQ PREQ PRIO_REQ    
3 /ISDFPS/FDPMAT_STOCKLIST PRIO_URG PURG PRIO_URG    
4 /ISDFPS/FDPMAT_STOCKLIST STACODE /ISDFPS/CSTACODE STACODE KEY    
History
Last changed by/on SAP  20110901 
SAP Release Created in 46C0