SAP ABAP View /ISDFPS/V_DFMPA (Database View for Selection of PPAs)
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
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
Basic Data
| View Type | D | Database View |
| Database View | /ISDFPS/V_DFMPA | |
| Short Description | Database View for Selection of PPAs | |
| Root table | PNODID | iPPE Node: Identification |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | PNODID |
PNODID | ||
| 2 | CPNTYPE |
|||
| 3 | PNODTX |
|||
| 4 | /ISDFPS/PNMPA |
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/PNMPA |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 11 | PNODID |
PNGUID | JL | EQ | 0 | 0 | ||||
| 12 | /ISDFPS/PNMPA |
PNGUID | JR | EQ | AND | 0 | 0 | |||
| 13 | PNODID |
APPLOBJ_TYPE | EQ | 'MPA' | AND | 0 | 0 | |||
| 14 | PNODID |
PNTYPE | NE | 'S_DFEPA' | AND | 0 | 0 | |||
| 15 | CPNTYPE |
REF_PNTYPE | EQ | 'S_DFMPA' | OR | 0 | 0 | |||
| 16 | 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/PNMPA |
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/PNMPA |
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 |
