SAP ABAP Table /ISDFPS/MATSPPLN_INT (Internal Material Planning Table)
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/MATSPPLN_INT | Table Relationship Diagram |
Short Description | Internal Material Planning Table |
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 | Materials Planned for Force Element | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PLANNING_GUID | /ISDFPS/PLANNING_GUID | SYSUUID_C | CHAR | 32 | 0 | Planning GUID | ||
4 | RECTYPE | /ISDFPS/FDPMAT_RECTYPE | /ISDFPS/FDPMAT_RECTYPE | CHAR | 3 | 0 | Record Type Planning | ||
5 | FORCE_REC_ID | /ISDFPS/FORCE_ID | SYSUUID_C | CHAR | 32 | 0 | Internal Key for Force Element | ||
6 | FORCE_REC_CNT | /ISDFPS/FORCE_CNT | NUMC6 | NUMC | 6 | 0 | Internal (Version) Counter | ||
7 | PLANT_REC | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
8 | STORAGE_LOC_REC | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
9 | HU_LOC_REC | /ISDFPS/HU_LOC | LGORT | CHAR | 4 | 0 | HU Storage Location | * | |
10 | FORCE_PROV_ID | /ISDFPS/FORCE_ID | SYSUUID_C | CHAR | 32 | 0 | Internal Key for Force Element | ||
11 | FORCE_PROV_CNT | /ISDFPS/FORCE_CNT | NUMC6 | NUMC | 6 | 0 | Internal (Version) Counter | ||
12 | PLANT_PROV | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
13 | STORAGE_LOC_PROV | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
14 | HU_LOC_PROV | /ISDFPS/HU_LOC | LGORT | CHAR | 4 | 0 | HU Storage Location | * | |
15 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
16 | SERNR | GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
17 | BATCH | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
18 | PSPNR | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | * | |
19 | HU_EXID | EXIDV | EXIDV | CHAR | 20 | 0 | External Handling Unit Identification | ||
20 | VEPOS | VEPOS | VEPOS | NUMC | 6 | 0 | Handling Unit Item | * | |
21 | PACK_MAT | VHILM | MATNR | CHAR | 18 | 0 | Packaging Materials | * | |
22 | QUPLN | /ISDFPS/QUPLN | MENG13V | QUAN | 13 | 3 | Planned Quantity | ||
23 | DELIVERY_DATE | /ISDFPS/DEL_DATE | DATS | 8 | 0 | Delivery Date | |||
24 | RSNUM | RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | * | |
25 | COMNT | /ISDFPS/COMNT | TEXT40 | CHAR | 40 | 0 | Planning Comment | ||
26 | REF_GUID | /ISDFPS/PLANNING_GUID | SYSUUID_C | CHAR | 32 | 0 | Planning GUID | ||
27 | REF_TYPE | /ISDFPS/MATPLN_REFTYPE | /ISDFPS/MATPLN_REF | CHAR | 2 | 0 | Type of Reference Relationship | ||
28 | REF_GUID2 | /ISDFPS/PLANNING_GUID | SYSUUID_C | CHAR | 32 | 0 | Planning GUID | ||
29 | REF_TYPE2 | /ISDFPS/MATPLN_REFTYPE | /ISDFPS/MATPLN_REF | CHAR | 2 | 0 | Type of Reference Relationship | ||
30 | PREQ_NO | BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
31 | PREQ_ITEM | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | * | |
32 | FLAG_LOAN | /ISDFPS/FLAG_LOAN | XFLAG | CHAR | 1 | 0 | Loan | ||
33 | RETURN_DATE | /ISDFPS/RETURN_DATE | DATS | DATS | 8 | 0 | Return Date for Loan | ||
34 | FLAG_LOAN_RET | /ISDFPS/FLAG_LOAN_RETURN | XFLAG | CHAR | 1 | 0 | Loan Return | ||
35 | RECORD_INVISIBLE | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
36 | RELOC_ID | /ISDFPS/RELOC_ID | /ISDFPS/RELOC_ID | CHAR | 10 | 0 | Relocation ID | * | |
37 | RELOC_SEQ_ID | /ISDFPS/RELOC_SEQ_ID | /ISDFPS/RELOC_SEQ_ID | CHAR | 4 | 0 | Relocation Step ID | * | |
38 | .INCLUDE | 0 | 0 | Material Planning Append for Provisions | |||||
39 | PNGUID | PVS_GUID | SYSUUID | RAW | 16 | 0 | Internal Identification for PVS Objects | ||
40 | FORCEM_CNT | /ISDFPS/FORCEM_CNT | NUMC6 | NUMC | 6 | 0 | Internal (Version) Counter | ||
41 | DGUID | /ISDFPS/DGUID | SYSUUID_C | CHAR | 32 | 0 | Identifier of Relationships for Distribution | ||
42 | FLAG_EV | /ISDFPS/REL_FLAG_EV | XFELD | CHAR | 1 | 0 | Relocation: Initial Supply | ||
43 | FORCE_ASGN_ID | /ISDFPS/FORCE_ID | SYSUUID_C | CHAR | 32 | 0 | Internal Key for Force Element | ||
44 | FORCE_ASGN_CNT | /ISDFPS/FORCE_CNT | NUMC6 | NUMC | 6 | 0 | Internal (Version) Counter | ||
45 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
46 | MBDAT | MBDAT | DATUM | DATS | 8 | 0 | Material Staging/Availability Date | ||
47 | DAT_SP | /ISDFPS/DAT_SP | DATUM | DATS | 8 | 0 | Collectn Pt Date | ||
48 | BSART | BSART | BSART | CHAR | 4 | 0 | Order Type (Purchasing) | * | |
49 | LFART | LFART | LFART | CHAR | 4 | 0 | Delivery Type | * | |
50 | ROUTE | ROUTE | ROUTE | CHAR | 6 | 0 | Route | * | |
51 | APPLOBJ_TYPE | PVS_APPLOBJ_TYPE | PVS_APPLOBJ_TYPE | CHAR | 4 | 0 | Application Object Type for iPPE | ||
52 | FBSTA | /ISDFPS/FBSTA | /ISDFPS/FBSTA | CHAR | 1 | 0 | Relocation: Follow-On Document Status | ||
53 | PNAME | PVS_PNODE | PVS_PNODE | CHAR | 40 | 0 | iPPE Node Description | ||
54 | FLAG_PROV | /ISDFPS/FLAG_PROV | CHAR | 1 | 0 | Provisions | |||
55 | LOCATION_S_GUID | /ISDFPS/LOCATION_ID | SYSUUID_C | CHAR | 32 | 0 | ISDFPS: Location ID (GUID) | ||
56 | LOCATION_D_GUID | /ISDFPS/LOCATION_ID | SYSUUID_C | CHAR | 32 | 0 | ISDFPS: Location ID (GUID) | ||
57 | CREATED_ON | ANDAT | DATUM | DATS | 8 | 0 | Date Record Created on | ||
58 | CREATED_BY | ANNAM | USNAM | CHAR | 12 | 0 | User Who Created Record | ||
59 | CHANGED_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
60 | CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
61 | FLAG_HISTORY | /ISDFPS/FLAG_HISTORY | XFELD | CHAR | 1 | 0 | Record Is Historical | ||
62 | FLAG_MAINTENANCE | /ISDFPS/FLAG_MAINTENANCE | XFLAG | CHAR | 1 | 0 | Relevant to Plant Maintenance | ||
63 | VBELN | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
64 | FLAG_COMPLETED | /ISDFPS/FLAG_PREQ_COMPLETED | XFLAG | CHAR | 1 | 0 | Completely Processed | ||
65 | FLAG_FORWARDED | /ISDFPS/FLAG_PREQ_FORWARDED | XFLAG | CHAR | 1 | 0 | PReq Was Forwarded | ||
66 | FLAG_DERIVED | /ISDFPS/FLAG_PREQ_DERIVED | XFLAG | CHAR | 1 | 0 | PReq Is Derived (Forwarding) | ||
67 | VSBED | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | * | |
68 | FLAG_WB | /ISDFPS/FLAG_WORKBENCH | XFLAG | CHAR | 1 | 0 | Planned Record Created in Workbench | ||
69 | FLAG_SUBITEM | /ISDFPS/FLAG_SUBITEM | XFLAG | CHAR | 1 | 0 | Subitem | ||
70 | FLAG_RETURN | /ISDFPS/FLAG_RETURN | XFLAG | CHAR | 1 | 0 | Return Delivery | ||
71 | RSPOS | RSPOS | RSPOS | NUMC | 4 | 0 | Item Number of Reservation / Dependent Requirements | ||
72 | FLAG_RES_FWD | /ISDFPS/FLAG_RES_FWD | XFLAG | CHAR | 1 | 0 | Forwarded Reservation | ||
73 | SERNR_PREQ | /ISDFPS/SERNR_PREQ | GERNR | CHAR | 18 | 0 | Serial Number | ||
74 | FLAG_SERNR_PREQ | /ISDFPS/FLAG_SERNR_PREQ | XFLAG | CHAR | 1 | 0 | Serial Number PReq | ||
75 | RELSEQ_TYPE | /ISDFPS/RELSEQ_TYPE | /ISDFPS/RELSEQ_TYPE | CHAR | 1 | 0 | Relocation Step Type | * | |
76 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
77 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
78 | PREQ_REL | /ISDFPS/PREQ_REL_X | XFLAG | CHAR | 1 | 0 | Indicates that PReq Is Released | ||
79 | HISTORY_FLAG | /ISDFPS/HISTORY_FLAG | XFLAG | CHAR | 1 | 0 | Indicates That Record Is Part of Document History | ||
80 | PREQ_REJ | /ISDFPS/PREQ_REJ | XFLAG | CHAR | 1 | 0 | Indicates that PReq Is Rejected | ||
81 | FLAG_RELEVANT | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
82 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
83 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | * | |
84 | PRIO_REQ | PRIO_REQ | PRIO_REQ | NUMC | 3 | 0 | Requirement Priority | * | |
85 | PRIO_URG | PRIO_URG | PRIO_URG | NUMC | 2 | 0 | Requirement Urgency | * | |
86 | ADVCODE | /ISDFPS/ADVCODE | /ISDFPS/ADVCODE | CHAR | 2 | 0 | Advice Code | * | |
87 | STACODE | /ISDFPS/STACODE | /ISDFPS/STACODE | CHAR | 2 | 0 | Status Code | * | |
88 | DISPO | DISPO | DISPO | CHAR | 3 | 0 | MRP controller | * | |
89 | EBAKZ | EBAKZ | XFELD | CHAR | 1 | 0 | Purchase requisition closed | ||
90 | AFNAM | AFNAM | AFNAM | CHAR | 12 | 0 | Name of requisitioner/requester | ||
91 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
92 | FIXKZ | BAFIX | XFELD | CHAR | 1 | 0 | Purchase requisition is fixed | ||
93 | BANFN_CS | /ISDFPS/BANFN_CS | BANFN | CHAR | 10 | 0 | Cross-System PReq Number | ||
94 | BNFPO_CS | /ISDFPS/BNFPO_CS | BNFPO | NUMC | 5 | 0 | Cross-System PReq Item | * | |
95 | ITEM_CS | /ISDFPS/ITEM_CS | /ISDFPS/ITEM_CS | CHAR | 1 | 0 | Cross-System Item Category | ||
96 | VENUM | VENUM | VENUM | CHAR | 10 | 0 | Internal Handling Unit Number | * | |
97 | BBSRT | BBSRT | BSART | CHAR | 4 | 0 | Purchase Requisition Document Type | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /ISDFPS/MATSPPLN_INT | CLIENT | T000 | MANDT | KEY | 1 | CN |
2 | /ISDFPS/MATSPPLN_INT | MATNR | MARA | MATNR | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 200 |