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