SAP ABAP View /1CN/ACCSAPH4TQU (Access View for a Condition Table)
Hierarchy
Basic Data
View Type | D | Database View |
Database View | /1CN/ACCSAPH4TQU | |
Short Description | Access View for a Condition Table | |
Root table | /1CN/CCCSAPH4TQU | Condition Table |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | /1CN/CCCSAPH4TQU | /1CN/CCCSAPH4TQU |
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 | CLIENT | /1CN/CCCSAPH4TQU | CLIENT | MANDT | Client | |||
2 | CPE_CONDTYPE_PR | /1CN/CCCSAPH4TQU | CPE_CONDTYPE_PR | CPET_CONDTYPE_PR | CPE: Condition Type of Pricing | |||
3 | SALES_ORG | /1CN/CCCSAPH4TQU | SALES_ORG | CRMT_SALES_ORG | Sales Organization ID | |||
4 | DIS_CHANNEL | /1CN/CCCSAPH4TQU | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | Distribution Channel | |||
5 | DIVISION | /1CN/CCCSAPH4TQU | DIVISION | CRMT_DIVISION | Division | |||
6 | CUST_GROUP | /1CN/CCCSAPH4TQU | CUST_GROUP | CRMT_CUST_GROUP | Customer Group | |||
7 | SOLD_TO_PARTY | /1CN/CCCSAPH4TQU | SOLD_TO_PARTY | CRMT_SOLD_TO_PARTY | Sold-to Party GUID | |||
8 | SHIP_TO_PARTY | /1CN/CCCSAPH4TQU | SHIP_TO_PARTY | CRMT_SHIP_TO_PARTY | Ship-to Party GUID | |||
9 | CPE_T_TERMNO | /1CN/CCCSAPH4TQU | CPE_T_TERMNO | CPET_TERMNO | CPE Term - Number in Formula | |||
10 | KSCHL | /1CN/CCCSAPH4TQU | KSCHL | /SAPCND/COND_TYPE | Condition Type | |||
11 | OBJECT_ID | /1CN/CCCSAPH4TQU | OBJECT_ID | /SAPCND/OBJECT_ID | Higher-level object number for condition records | |||
12 | TIMESTAMP_TO | /1CN/CCCSAPH4TQU | TIMESTAMP_TO | /SAPCND/TIMESTAMP_TO | Timestamp for Validity End Date | |||
13 | RELEASE_STATUS | /1CN/CCCSAPH4TQU | RELEASE_STATUS | /SAPCND/RELEASE_STATUS | Release Status | |||
14 | KOPOS | /1CN/CCCSAPH4TQU | KOPOS | /SAPCND/SUPP_CONDITION_ID | Condition Supplement ID | |||
15 | CREATED_ON | /1CN/CCCSAPH4TQU | CREATED_ON | /SAPCND/CREATED_ON | Date on which Condition Record was Created | |||
16 | VARNUMH | /1CN/CCCSAPH4TQU | VARNUMH | /SAPCND/COND_TABLE_ENTRY_ID | Condition Record ID | |||
17 | TIMESTAMP_FROM | /1CN/CCCSAPH4TQU | TIMESTAMP_FROM | /SAPCND/TIMESTAMP_FROM | Timestamp for Validity Start Date | |||
18 | KSCHL_SUPP | /1CN/CCCSAPH4TQU | KSCHL_SUPP | /SAPCND/SUPP_COND_TYPE | Supplementary Condition Type | |||
19 | COND_GROUP_ID | /1CN/CCCSAPH4TQU | COND_GROUP_ID | /SAPCND/COND_GROUP_ID | ID of Group of Condition Records | |||
20 | MAINT_STATUS | /1CN/CCCSAPH4TQU | MAINT_STATUS | /SAPCND/MAINT_STATUS | Editing status | |||
21 | CREATED_BY | /1CN/CCCSAPH4TQU | CREATED_BY | /SAPCND/CREATED_BY | Name of User that Created the Condition Record | |||
22 | SUPP_EXIST | /1CN/CCCSAPH4TQU | SUPP_EXIST | /SAPCND/SUPP_EXIST | Additional Data Indicator for Condition Record | |||
23 | SCALE_DIM | /1CN/CCCSAPH4TQU | SCALE_DIM | /SAPCND/DIMENSION_ID | Dimenstion number | |||
24 | CPE_R_RATETYPE | /1CN/CCCSAPH4TQU | CPE_R_RATETYPE | CPET_RATETYPE | CPE: Rate Type for Formula Assembly | |||
25 | CPE_R_RATE | /1CN/CCCSAPH4TQU | CPE_R_RATE | CPET_FORMRATE | CPE Formula - Rate in Formula Currency | |||
26 | CPE_R_CURRENCY | /1CN/CCCSAPH4TQU | CPE_R_CURRENCY | CPET_FORMCURR | CPE Formula - Currency | |||
27 | CPE_R_PRICEUNIT | /1CN/CCCSAPH4TQU | CPE_R_PRICEUNIT | CPET_FORMPRUN | CPE Formula - Price Unit | |||
28 | CPE_R_UOM | /1CN/CCCSAPH4TQU | CPE_R_UOM | CPET_FORMUOM | CPE Formula - Unit of Measure | |||
29 | CPE_T_QUOTGROUP | /1CN/CCCSAPH4TQU | CPE_T_QUOTGROUP | CPET_QUOTGROUP | Quotation Group | |||
30 | CPE_T_QUOTNAME | /1CN/CCCSAPH4TQU | CPE_T_QUOTNAME | CPET_QUOTNAME | Quotation Name | |||
31 | CPE_T_QUOTSRC | /1CN/CCCSAPH4TQU | CPE_T_QUOTSRC | CPET_QUOTSRC | Quotation Source | |||
32 | CPE_T_QUOTTYPE | /1CN/CCCSAPH4TQU | CPE_T_QUOTTYPE | CPET_QUOTTYPE | Quotation Type | |||
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 | 20130604 |
SAP Release Created in |