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