SAP ABAP Table /ISDFPS/FDPDASLD_INP_0120 (Convert Materials (at Material Level))
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/FDPDASLD_INP_0120 | Table Relationship Diagram |
Short Description | Convert Materials (at Material Level) |
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 | Plan Materials (at Material Level) | |||||
2 | FORCE_ID | /ISDFPS/FORCE_ID | SYSUUID_C | CHAR | 32 | 0 | Internal Key for Force Element | ||
3 | FORCE_OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | * | |
4 | FORCENAME | SHORT_D | TEXT12 | CHAR | 12 | 0 | Object Abbreviation | ||
5 | PLANT | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | * | |
6 | PLANT_TEXT | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
7 | STORAGE_LOC | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
8 | STOR_LOC_T | LGOBE | TEXT16 | CHAR | 16 | 0 | Description of Storage Location | ||
9 | HU_LOC | /ISDFPS/HU_LOC | LGORT | CHAR | 4 | 0 | HU Storage Location | T001L | |
10 | FORCE_PROV_ID | /ISDFPS/FORCE_ID | SYSUUID_C | CHAR | 32 | 0 | Internal Key for Force Element | ||
11 | FORCE_PROV_OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | * | |
12 | FORCE_PROV_NAME | SHORT_D | TEXT12 | CHAR | 12 | 0 | Object Abbreviation | ||
13 | PLANT_PROV | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
14 | PLANT_PROV_TEXT | NAME1 | TEXT30 | CHAR | 30 | 0 | Name | ||
15 | STORAGE_LOC_PROV | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
16 | STOR_LOC_PROV_T | LGOBE | TEXT16 | CHAR | 16 | 0 | Description of Storage Location | ||
17 | HU_LOC_PROV | /ISDFPS/HU_LOC | LGORT | CHAR | 4 | 0 | HU Storage Location | * | |
18 | PNAME | PVS_PNODE | PVS_PNODE | CHAR | 40 | 0 | iPPE Node Description | ||
19 | PNTEXT | PVS_PNODETX | TEXT60 | CHAR | 60 | 0 | Short Text for iPPE Node | ||
20 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
21 | BATCH | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
22 | BATCH_TEXT | KZTXT_BATCH | TEXT40 | CHAR | 40 | 0 | Short text for batch | ||
23 | PSPNR | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | PRPS | |
24 | PSPNR_TEXT | /ISDFPS/TEXT40 | ALLTEXT | CHAR | 40 | 0 | Text | ||
25 | SERNR | GERNR | GERNR | CHAR | 18 | 0 | Serial Number | ||
26 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
27 | PACK_MAT | VHILM | MATNR | CHAR | 18 | 0 | Packaging Materials | * | |
28 | HU_EXID | EXIDV | EXIDV | CHAR | 20 | 0 | External Handling Unit Identification | ||
29 | VEPOS | VEPOS | VEPOS | NUMC | 6 | 0 | Handling Unit Item | * | |
30 | DELIVERY_DATE | /ISDFPS/DEL_DATE | DATS | 8 | 0 | Delivery Date | |||
31 | QUPLN | /ISDFPS/QUPLN | MENG13V | QUAN | 13 | 3 | Planned Quantity | ||
32 | QBLOCK | SPEME | MENG13V | QUAN | 13 | 3 | Blocked stock | ||
33 | QTRANS | UMLMD | MENG13V | QUAN | 13 | 3 | Stock in transfer (from one storage location to another) | ||
34 | QQUAL | INSME | MENG13V | QUAN | 13 | 3 | Stock in Quality Inspection | ||
35 | COMNT | /ISDFPS/COMNT | TEXT40 | CHAR | 40 | 0 | Planning Comment | ||
36 | VALID_FROM | /ISDFPS/BEGDAT | DATS | DATS | 8 | 0 | Valid from | ||
37 | VALID_TO | /ISDFPS/ENDDAT | DATS | DATS | 8 | 0 | Valid to | ||
38 | MATPLN_CNT | /ISDFPS/MATPLN_CNT | NUMC | 8 | 0 | Internal (Version) Counter for Material Plans | |||
39 | PROV_LEVEL | TDEPTH | DEC5 | DEC | 5 | 0 | Technical Depth of Structure | ||
40 | PREQ_NO | BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
41 | PREQ_ITEM | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | * | |
42 | FLAG_LOAN | /ISDFPS/FLAG_LOAN | XFLAG | CHAR | 1 | 0 | Loan | ||
43 | RETURN_DATE | /ISDFPS/DEL_DATE | DATS | 8 | 0 | Delivery Date | |||
44 | PRIO_URG | PRIO_URG | PRIO_URG | NUMC | 2 | 0 | Requirement Urgency | PURG | |
45 | ADVCODE | /ISDFPS/ADVCODE | /ISDFPS/ADVCODE | CHAR | 2 | 0 | Advice Code | /ISDFPS/ADVCODE2 | |
46 | STACODE | /ISDFPS/STACODE | /ISDFPS/STACODE | CHAR | 2 | 0 | Status Code | /ISDFPS/CSTACODE | |
47 | BSART | BSART | BSART | CHAR | 4 | 0 | Order Type (Purchasing) | * | |
48 | FLAG_LOAN_RET | /ISDFPS/FLAG_LOAN_RETURN | XFLAG | CHAR | 1 | 0 | Loan Return | ||
49 | RELOC_ID | /ISDFPS/RELOC_ID | /ISDFPS/RELOC_ID | CHAR | 10 | 0 | Relocation ID | /ISDFPS/REL | |
50 | RELOC_SEQ_ID | /ISDFPS/RELOC_SEQ_ID | /ISDFPS/RELOC_SEQ_ID | CHAR | 4 | 0 | Relocation Step ID | /ISDFPS/RELSEQ | |
51 | FLAG_TEMPLATE | /ISDFPS/FLAG_TEMPLATE | XFLAG | CHAR | 1 | 0 | Template Row | ||
52 | RELSEQ_TYPE | /ISDFPS/RELSEQ_TYPE | /ISDFPS/RELSEQ_TYPE | CHAR | 1 | 0 | Relocation Step Type | * | |
53 | FLAG_MAINTENANCE | /ISDFPS/FLAG_MAINTENANCE | XFLAG | CHAR | 1 | 0 | Relevant to Plant Maintenance | ||
54 | FLAG_COMPLETED | /ISDFPS/FLAG_PREQ_COMPLETED | XFLAG | CHAR | 1 | 0 | Completely Processed | ||
55 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | * | |
56 | DISPO | DISPO | DISPO | CHAR | 3 | 0 | MRP controller | T024D | |
57 | FLAG_DERIVED | /ISDFPS/FLAG_PREQ_DERIVED | XFLAG | CHAR | 1 | 0 | PReq Is Derived (Forwarding) | ||
58 | FLAG_FORWARDED | /ISDFPS/FLAG_PREQ_FORWARDED | XFLAG | CHAR | 1 | 0 | PReq Was Forwarded | ||
59 | EBAKZ | EBAKZ | XFELD | CHAR | 1 | 0 | Purchase requisition closed | ||
60 | OBJID_COM | /ISDFPS/OBJID_COM | HROBJID | NUMC | 8 | 0 | Force Provider | * | |
61 | AFNAM | AFNAM | AFNAM | CHAR | 12 | 0 | Name of requisitioner/requester | ||
62 | FLAG_RETURN | /ISDFPS/FLAG_RETURN | XFLAG | CHAR | 1 | 0 | Return Delivery | ||
63 | SERNR_PREQ | /ISDFPS/SERNR_PREQ | GERNR | CHAR | 18 | 0 | Serial Number | ||
64 | FLAG_SERNR_PREQ | /ISDFPS/FLAG_SERNR_PREQ | XFLAG | CHAR | 1 | 0 | Serial Number PReq | ||
65 | REF_GUID2 | /ISDFPS/PLANNING_GUID | SYSUUID_C | CHAR | 32 | 0 | Planning GUID | ||
66 | REF_TYPE2 | /ISDFPS/MATPLN_REFTYPE | /ISDFPS/MATPLN_REF | CHAR | 2 | 0 | Type of Reference Relationship | ||
67 | LINECOUNT | INT4 | INT4 | INT4 | 10 | 0 | Natural number | ||
68 | PREQ_NO_REF | BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
69 | PREQ_ITEM_REF | BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | * | |
70 | EXTERN | EXTNL | XFELD | CHAR | 1 | 0 | Indicator for External Procurement | ||
71 | QUORD | /ISDFPS/QUORD | MENG13V | QUAN | 13 | 3 | Conversion Quantity | ||
72 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
73 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /ISDFPS/FDPDASLD_INP_0120 | ADVCODE | /ISDFPS/ADVCODE2 | ADVCODE | |||
2 | /ISDFPS/FDPDASLD_INP_0120 | BATCH | MCH1 | CHARG | |||
3 | /ISDFPS/FDPDASLD_INP_0120 | BUKRS | T001 | BUKRS | |||
4 | /ISDFPS/FDPDASLD_INP_0120 | DISPO | T024D | DISPO | |||
5 | /ISDFPS/FDPDASLD_INP_0120 | EKORG | T024E | EKORG | |||
6 | /ISDFPS/FDPDASLD_INP_0120 | HU_LOC | T001L | LGORT | |||
7 | /ISDFPS/FDPDASLD_INP_0120 | PLANT_PROV | T001W | WERKS | |||
8 | /ISDFPS/FDPDASLD_INP_0120 | PRIO_URG | PURG | PRIO_URG | |||
9 | /ISDFPS/FDPDASLD_INP_0120 | PSPNR | PRPS | PSPNR | |||
10 | /ISDFPS/FDPDASLD_INP_0120 | RELOC_ID | /ISDFPS/REL | RELOC_ID | |||
11 | /ISDFPS/FDPDASLD_INP_0120 | RELOC_SEQ_ID | /ISDFPS/RELSEQ | RELOC_SEQ_ID | |||
12 | /ISDFPS/FDPDASLD_INP_0120 | STACODE | /ISDFPS/CSTACODE | STACODE | |||
13 | /ISDFPS/FDPDASLD_INP_0120 | STORAGE_LOC | T001L | LGORT | |||
14 | /ISDFPS/FDPDASLD_INP_0120 | STORAGE_LOC_PROV | T001L | LGORT |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 10A |