SAP ABAP Table CNCCRMPRSAP15001 (SlsOrg/ DistChan/ SalesPartner/ Product)
Hierarchy
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CNCCRMPRSAP15001 | Table Relationship Diagram |
Short Description | SlsOrg/ DistChan/ SalesPartner/ Product |
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 | SOLD_FROM_PARTY | CRMT_SOLD_FROM_PARTY | SYSUUID | RAW | 16 | 0 | Salesperson GUID | ||
7 | PRODUCT | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
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 | KBETR | PRCT_COND_RATE | WERTV8 | CURR | 15 | 2 | Condition Rate | ||
25 | KPEIN | PRCT_COND_PRICING_UNIT | PRC_CONDITION_PRICING_UNIT | DEC | 5 | 0 | Condition Pricing Unit | ||
26 | KMEIN | PRCT_PROD_UOM | MEINS | UNIT | 3 | 0 | Unit of Measure for Product-Specific Quantity | * | |
27 | KONWA | PRCT_COND_CURR | WAERS | CUKY | 5 | 0 | Condition Currency | * | |
28 | 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 | CNCCRMPRSAP15001 | VARNUMH | /SAPCND/CONDINDX | VARNUMH |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in |