SAP ABAP View V_CMCDT1_BW (Category Management: Category)
Hierarchy
☛
BI_CONT (Software Component) Business Intelligence Content
⤷ BW-BCT-CPG-CMC (Application Component) Categorie Management Consumer Products
⤷ RS_AA_CM_BW (Package) Analytical Application CM: CDT Extraction
⤷ BW-BCT-CPG-CMC (Application Component) Categorie Management Consumer Products
⤷ RS_AA_CM_BW (Package) Analytical Application CM: CDT Extraction
Basic Data
View Type | D | Database View |
Database View | V_CMCDT1_BW | |
Short Description | Category Management: Category | |
Root table | CMCDT_1 | Category |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | CMCDT_1 | CMCDT_1 |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | CMCDT_1 | MANDT | MANDT | Client | |||
2 | HIER_ID | CMCDT_1 | HIER_ID | CMHIER_CNT | Hierarchy ID | |||
3 | CDT1 | CMCDT_1 | CDT1 | CMCDT1 | Category | |||
4 | ROLE | CMCDT_1 | ROLE | CMCATROLE | Category Role | |||
5 | STRATEGY | CMCDT_1 | STRATEGY | CMCATSTRATEGY | Node Strategy | |||
6 | VKORG | CMCDT_1 | VKORG | VKORG | Sales Organization | |||
7 | VTWEG | CMCDT_1 | VTWEG | VTWEG | Distribution Channel | |||
8 | SHLFSPC | CMCDT_1 | SHLFSPC | CMSHFSPC | CM: Shelf Space | |||
9 | LINSPC | CMCDT_1 | LINSPC | CMLINSPC | CM: Contact Area | |||
10 | SPACEUNIT | CMCDT_1 | SPACEUNIT | CMSPCUNIT | CM: Shelf Space Unit | |||
11 | LINUNIT | CMCDT_1 | LINUNIT | CMLINUNIT | CM: Contact Area Unit | |||
12 | STORES | CMCDT_1 | STORES | CMSTORES | CM: Number of Stores with Articles for Category | |||
13 | CHKDATE | CMCDT_1 | CHKDATE | CMCHKDATE | CM: Key Date for Space Analyses | |||
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 | 20141031 |
SAP Release Created in | 21C |