CPNTYPE
Customizing Table for iPPE Node Type
CPNTYPE is an SAP database table in S/4HANA. Customizing Table for iPPE Node Type. It contains 25 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IppeNodeType | view | from | BASIC | iPPE Node Type |
| I_ProdStrucNodeGnrcObjTypeMap | view | from | BASIC | IPPE node objects to GOS objects mapping |
| I_ProdStrucNodeType | view | from | BASIC | Product Structure Node Type |
| R_PPDSMntrRcptProductionLineVH | view_entity | inner | BASIC | Production Line |
| R_PPDSMntrRqmtProductionLineVH | view_entity | inner | BASIC | Production Line |
Fields (25)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | pntype | PVS_PNODE_TYPE | Node Type | |||
| applobj_type | PPE_APPLOBJ_TYPE | iPPE Applicatn Obj. | ||||
| pvslayer | PVS_LAYER | iPPE Level | ||||
| class_min | PVS_PRCL_MIN | Min. Class Assgmt | ||||
| class_max | PVS_PRCL_MAX | Max. Class Assgmt | ||||
| conf_flg | PVS_CONFFLG | PVS Indicator | ||||
| kons_flg | PVS_KONSFLG | Consistency Check | ||||
| contextenv | PPE_CONTEXT_ENV | Context | ||||
| var_schema | PVS_VARSCHEMA | PVS Var. Scheme | ||||
| acttype | PVS_ACTTYPE_OLD | iPPE Activity Ty. | ||||
| flotype | PVS_FLOTYPE | iPPE FLO Node Type | ||||
| class | PPE_KLASSE | Class | ||||
| klart | PPE_KLASSENART_CUST | Class Type | ||||
| clint | PPE_CLINT | Int Class No. | ||||
| ref_pntype | PVS_REF_PNODE_TYPE | Ref. Node Type | ||||
| hist_mode | PPE_PNODID_HISTFLG | History Maint. | ||||
| hide_flg | PVS_HIDEFLG | Hide Object | ||||
| icon | PPE_ICON | Icon for iPPE Obj. | ||||
| pname_len | PPE_PNAME_LEN | Maximum Length | ||||
| creadat | PVS_ANDAT | Created on | ||||
| creaby | PVS_ANNAM | Created by | ||||
| chngdat | PVS_AEDAT | Changed on | ||||
| chngby | PVS_AENAM | Changed by | ||||
| logsys | LOGSYS | Logical system |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Customizing Table for iPPE Node Type
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CPNTYPE (
MANDT, -- Client [MANDT]
PNTYPE, -- Node Type [PVS_PNODE_TYPE]
APPLOBJ_TYPE, -- iPPE Applicatn Obj. [PPE_APPLOBJ_TYPE]
PVSLAYER, -- iPPE Level [PVS_LAYER]
CLASS_MIN, -- Min. Class Assgmt [PVS_PRCL_MIN]
CLASS_MAX, -- Max. Class Assgmt [PVS_PRCL_MAX]
CONF_FLG, -- PVS Indicator [PVS_CONFFLG]
KONS_FLG, -- Consistency Check [PVS_KONSFLG]
CONTEXTENV, -- Context [PPE_CONTEXT_ENV]
VAR_SCHEMA, -- PVS Var. Scheme [PVS_VARSCHEMA]
ACTTYPE, -- iPPE Activity Ty. [PVS_ACTTYPE_OLD]
FLOTYPE, -- iPPE FLO Node Type [PVS_FLOTYPE]
CLASS, -- Class [PPE_KLASSE]
KLART, -- Class Type [PPE_KLASSENART_CUST]
CLINT, -- Int Class No. [PPE_CLINT]
REF_PNTYPE, -- Ref. Node Type [PVS_REF_PNODE_TYPE]
HIST_MODE, -- History Maint. [PPE_PNODID_HISTFLG]
HIDE_FLG, -- Hide Object [PVS_HIDEFLG]
ICON, -- Icon for iPPE Obj. [PPE_ICON]
PNAME_LEN, -- Maximum Length [PPE_PNAME_LEN]
CREADAT, -- Created on [PVS_ANDAT]
CREABY, -- Created by [PVS_ANNAM]
CHNGDAT, -- Changed on [PVS_AEDAT]
CHNGBY, -- Changed by [PVS_AENAM]
LOGSYS, -- Logical system [LOGSYS]
PRIMARY KEY (MANDT, PNTYPE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA