SAP ABAP Table /1CN/CCMSAP005 (Sales Organization/Distribution Channel/Product/Point Type)
Hierarchy
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | /1CN/CCMSAP005 |
Table Relationship Diagram 
|
| Short Description | Sales Organization/Distribution Channel/Product/Point Type |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| 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 |  CLIENT |
MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
| 2 | .INCLUDE |
0 | 0 | Key for Condition Tables | |||||
| 3 | VARNUMH |
/SAPCND/COND_TABLE_ENTRY_ID | SYSUUID | RAW | 16 | 0 | Condition Record ID | /SAPCND/CONDINDX | |
| 4 | SALES_ORG |
CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
| 5 | DIS_CHANNEL |
CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
| 6 | PRODUCT |
COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
| 7 | LOY_POINT_TYPE |
CRMT_MKTPL_LOY_POINT_CODE | CRM_MKTPL_LOY_POINT_CODE | CHAR | 10 | 0 | ID of Point Type | ||
| 8 | .INCLUDE |
0 | 0 | General Reference for Condition Tables | |||||
| 9 | KSCHL |
/SAPCND/COND_TYPE | /SAPCND/COND_TYPE | CHAR | 4 | 0 | Condition Type | * | |
| 10 | OBJECT_ID |
/SAPCND/OBJECT_ID | SYSUUID | RAW | 16 | 0 | Higher-level object number for condition records | ||
| 11 | TIMESTAMP_TO |
/SAPCND/TIMESTAMP_TO | TIMESTAMP | CHAR | 14 | 0 | Timestamp for Validity End Date | ||
| 12 | RELEASE_STATUS |
/SAPCND/RELEASE_STATUS | /SAPCND/RELEASE_STATUS | CHAR | 1 | 0 | Release Status | ||
| 13 | TIMESTAMP_FROM |
/SAPCND/TIMESTAMP_FROM | TIMESTAMP | CHAR | 14 | 0 | Timestamp for Validity Start Date | ||
| 14 | KSCHL_SUPP |
/SAPCND/SUPP_COND_TYPE | /SAPCND/COND_TYPE | CHAR | 4 | 0 | Supplementary Condition Type | * | |
| 15 | COND_GROUP_ID |
/SAPCND/COND_GROUP_ID | SYSUUID | RAW | 16 | 0 | ID of Group of Condition Records | ||
| 16 | MAINT_STATUS |
/SAPCND/MAINT_STATUS | /SAPCND/MAINT_STATUS | CHAR | 2 | 0 | Editing status | ||
| 17 | .INCLUDE |
0 | 0 | User Spec. Management Data (created, changed) | |||||
| 18 | CREATED_BY |
/SAPCND/CREATED_BY | XUBNAME | CHAR | 12 | 0 | Name of User that Created the Condition Record | * | |
| 19 | CREATED_ON |
/SAPCND/CREATED_ON | SYDATS | DATS | 8 | 0 | Date on which Condition Record was Created | ||
| 20 | .INCLUDE |
0 | 0 | General Reference for Additional Information | |||||
| 21 | KOPOS |
/SAPCND/SUPP_CONDITION_ID | /SAPCND/SUPP_CONDITION_ID | NUMC | 3 | 0 | Condition Supplement ID | ||
| 22 | SUPP_EXIST |
/SAPCND/SUPP_EXIST | XFELD | CHAR | 1 | 0 | Additional Data Indicator for Condition Record | ||
| 23 | SCALE_DIM |
/SAPCND/DIMENSION_ID | NUMC2 | NUMC | 2 | 0 | Dimenstion number | ||
| 24 | PRODUCT_QUANTITY |
PRCT_COND_PRICING_UNIT | PRC_CONDITION_PRICING_UNIT | DEC | 5 | 0 | Condition Pricing Unit | ||
| 25 | PRODUCT_UOM |
PRCT_PROD_UOM | MEINS | UNIT | 3 | 0 | Unit of Measure for Product-Specific Quantity | * | |
| 26 | POINT_PRICE_AMT |
CRM_LOY_POINT_PRICE | DEC | 10 | 2 | Point Price Amount | |||
| 27 | POINT_MAX_AMT |
CRM_LOY_MAX_POINTS | DEC | 10 | 2 | Maximum Point Value | |||
| 28 | POINT_MIN_AMT |
CRM_LOY_MIN_POINTS | DEC | 10 | 2 | Point Minimum Value | |||
| 29 | POINT_PRICE_UNIT |
CRM_LOY_POINT_UNIT | MEINS | UNIT | 3 | 0 | Point Unit of Measure | * |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /1CN/CCMSAP005 | VARNUMH |  /SAPCND/CONDINDX |
VARNUMH |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in |
