SAP ABAP View /ISDFPS/V_DFMPOC (Database View for Selection of MCs)
Hierarchy
☛
EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
⤷ IS-DFS-OF-MPO (Application Component) Material Categories
⤷ /ISDFPS/CPPEMPO (Package) Material Planning Object
⤷ IS-DFS-OF-MPO (Application Component) Material Categories
⤷ /ISDFPS/CPPEMPO (Package) Material Planning Object
Basic Data
View Type | D | Database View |
Database View | /ISDFPS/V_DFMPOC | |
Short Description | Database View for Selection of MCs | |
Root table | PNODID | iPPE Node: Identification |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | PNODID | PNODID | ||
2 | CPNTYPE | |||
3 | PNODTX | |||
4 | /ISDFPS/PNMPOC |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | CPNTYPE | MANDT | JL | EQ | 0 | 0 | ||||
2 | PNODID | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | CPNTYPE | PNTYPE | JL | EQ | 0 | 0 | ||||
4 | PNODID | PNTYPE | JR | EQ | AND | 0 | 0 | |||
5 | PNODID | MANDT | JL | EQ | 0 | 0 | ||||
6 | PNODTX | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | PNODID | PNGUID | JL | EQ | 0 | 0 | ||||
8 | PNODTX | PNGUID | JR | EQ | AND | 0 | 0 | |||
9 | PNODID | MANDT | JL | EQ | 0 | 0 | ||||
10 | /ISDFPS/PNMPOC | MANDT | JR | EQ | AND | 0 | 0 | |||
11 | PNODID | PNGUID | JL | EQ | 0 | 0 | ||||
12 | /ISDFPS/PNMPOC | PNGUID | JR | EQ | AND | 0 | 0 | |||
13 | PNODID | APPLOBJ_TYPE | EQ | 'MPO' | AND | 0 | 0 | |||
14 | PNODID | PNTYPE | NE | 'S_DFMPO' | AND | 0 | 0 | |||
15 | PNODID | PNTYPE | NE | 'S_DFMPOV' | AND | 0 | 0 | |||
16 | CPNTYPE | REF_PNTYPE | EQ | 'S_DFMC' | OR | 0 | 0 | |||
17 | CPNTYPE | REF_PNTYPE | EQ | '' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | PNODID | MANDT | MANDT | Client | |||
2 | PNGUID | PNODID | PNGUID | PVS_PNGUID | Internal Number of iPPE Node | |||
3 | PNTXCNT | PNODTX | PNTXCNT | PVS_TXTCOUNT | Counter for Text Tables | |||
4 | SPRAS | PNODTX | SPRAS | SPRAS | Language Key | |||
5 | PNCNT | /ISDFPS/PNMPOC | PNCNT | PVS_COUNT | Internal Counter for iPPE Objects | |||
6 | PNAME | PNODID | PNAME | PVS_PNODE | iPPE Node Description | |||
7 | PNTEXT | PNODTX | PNTEXT | PVS_PNODETX | Short Text for iPPE Node | |||
8 | PNTYPE | PNODID | PNTYPE | PVS_PNODE_TYPE | iPPE Node Type | |||
9 | APPLOBJ_TYPE | PNODID | APPLOBJ_TYPE | PPE_APPLOBJ_TYPE | iPPE Application Object Type | |||
10 | STAT | /ISDFPS/PNMPOC | STAT | /ISDFPS/STATUS | Object Status | |||
11 | PNTEXT_UP | PNODTX | PNTEXT_UP | PVS_PNODETXUP | PVS Node Short Text in Upper Case | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 470 |