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