SAP ABAP Table CNCCRMPRSAP00065 (Sales Organization/Distribution Channel/Division/Hier./Prod.)
Hierarchy
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CNCCRMPRSAP00065 | Table Relationship Diagram |
Short Description | Sales Organization/Distribution Channel/Division/Hier./Prod. |
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 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
7 | HIER_NODE_GUID | BU_NODE_GUID | SYSUUID | RAW | 16 | 0 | GUID of Hierarchy Node | ||
8 | PRODUCT | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
9 | .INCLUDE | 0 | 0 | General Reference for Condition Tables | |||||
10 | KSCHL | /SAPCND/COND_TYPE | /SAPCND/COND_TYPE | CHAR | 4 | 0 | Condition Type | * | |
11 | OBJECT_ID | /SAPCND/OBJECT_ID | SYSUUID | RAW | 16 | 0 | Higher-level object number for condition records | ||
12 | TIMESTAMP_TO | /SAPCND/TIMESTAMP_TO | TIMESTAMP | CHAR | 14 | 0 | Timestamp for Validity End Date | ||
13 | RELEASE_STATUS | /SAPCND/RELEASE_STATUS | /SAPCND/RELEASE_STATUS | CHAR | 1 | 0 | Release Status | ||
14 | TIMESTAMP_FROM | /SAPCND/TIMESTAMP_FROM | TIMESTAMP | CHAR | 14 | 0 | Timestamp for Validity Start Date | ||
15 | KSCHL_SUPP | /SAPCND/SUPP_COND_TYPE | /SAPCND/COND_TYPE | CHAR | 4 | 0 | Supplementary Condition Type | * | |
16 | COND_GROUP_ID | /SAPCND/COND_GROUP_ID | SYSUUID | RAW | 16 | 0 | ID of Group of Condition Records | ||
17 | MAINT_STATUS | /SAPCND/MAINT_STATUS | /SAPCND/MAINT_STATUS | CHAR | 2 | 0 | Editing status | ||
18 | .INCLUDE | 0 | 0 | User Spec. Management Data (created, changed) | |||||
19 | CREATED_BY | /SAPCND/CREATED_BY | XUBNAME | CHAR | 12 | 0 | Name of User that Created the Condition Record | * | |
20 | CREATED_ON | /SAPCND/CREATED_ON | SYDATS | DATS | 8 | 0 | Date on which Condition Record was Created | ||
21 | .INCLUDE | 0 | 0 | General Reference for Additional Information | |||||
22 | KOPOS | /SAPCND/SUPP_CONDITION_ID | /SAPCND/SUPP_CONDITION_ID | NUMC | 3 | 0 | Condition Supplement ID | ||
23 | SUPP_EXIST | /SAPCND/SUPP_EXIST | XFELD | CHAR | 1 | 0 | Additional Data Indicator for Condition Record | ||
24 | SCALE_DIM | /SAPCND/DIMENSION_ID | NUMC2 | NUMC | 2 | 0 | Dimenstion number | ||
25 | KBETR | PRCT_COND_RATE | WERTV8 | CURR | 15 | 2 | Condition Rate | ||
26 | KPEIN | PRCT_COND_PRICING_UNIT | PRC_CONDITION_PRICING_UNIT | DEC | 5 | 0 | Condition Pricing Unit | ||
27 | KMEIN | PRCT_PROD_UOM | MEINS | UNIT | 3 | 0 | Unit of Measure for Product-Specific Quantity | * | |
28 | KONWA | PRCT_COND_CURR | WAERS | CUKY | 5 | 0 | Condition Currency | * | |
29 | KRECH | PRCT_CALCULATION_TYPE | PRC_CALCULATION_TYPE | CHAR | 3 | 0 | Calculation Type for Condition | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CNCCRMPRSAP00065 | VARNUMH | /SAPCND/CONDINDX | VARNUMH |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |