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 |