SAP ABAP View /1CN/ACDSAPSUNIL (Access View for a Condition Table)
Hierarchy
Basic Data
| View Type | D | Database View |
| Database View | /1CN/ACDSAPSUNIL | |
| Short Description | Access View for a Condition Table | |
| Root table | /1CN/CCDSAPSUNIL | GUID/Dis. Chan./Prod. GUID/Sls Org ID/Customer |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /1CN/CCDSAPSUNIL |
/1CN/CCDSAPSUNIL |
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/CCDSAPSUNIL |
CLIENT | MANDT | Client | |||
| 2 | CMP_GUID |
/1CN/CCDSAPSUNIL |
CMP_GUID | CRM_MKTPL_CMP_GUID16 | Project Planning: 16-Character GUID for Multiple Promotions | |||
| 3 | DIS_CHANNEL |
/1CN/CCDSAPSUNIL |
DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | Distribution Channel | |||
| 4 | PRODUCT |
/1CN/CCDSAPSUNIL |
PRODUCT | COMT_PRODUCT_GUID | Internal Unique ID of Product | |||
| 5 | SALES_ORG |
/1CN/CCDSAPSUNIL |
SALES_ORG | CRMT_SALES_ORG | Sales Organization ID | |||
| 6 | SOLD_TO_PARTY |
/1CN/CCDSAPSUNIL |
SOLD_TO_PARTY | CRMT_SOLD_TO_PARTY | Sold-to Party GUID | |||
| 7 | KSCHL |
/1CN/CCDSAPSUNIL |
KSCHL | /SAPCND/COND_TYPE | Condition Type | |||
| 8 | OBJECT_ID |
/1CN/CCDSAPSUNIL |
OBJECT_ID | /SAPCND/OBJECT_ID | Higher-level object number for condition records | |||
| 9 | TIMESTAMP_TO |
/1CN/CCDSAPSUNIL |
TIMESTAMP_TO | /SAPCND/TIMESTAMP_TO | Timestamp for Validity End Date | |||
| 10 | RELEASE_STATUS |
/1CN/CCDSAPSUNIL |
RELEASE_STATUS | /SAPCND/RELEASE_STATUS | Release Status | |||
| 11 | KOPOS |
/1CN/CCDSAPSUNIL |
KOPOS | /SAPCND/SUPP_CONDITION_ID | Condition Supplement ID | |||
| 12 | CREATED_ON |
/1CN/CCDSAPSUNIL |
CREATED_ON | /SAPCND/CREATED_ON | Date on which Condition Record was Created | |||
| 13 | VARNUMH |
/1CN/CCDSAPSUNIL |
VARNUMH | /SAPCND/COND_TABLE_ENTRY_ID | Condition Record ID | |||
| 14 | TIMESTAMP_FROM |
/1CN/CCDSAPSUNIL |
TIMESTAMP_FROM | /SAPCND/TIMESTAMP_FROM | Timestamp for Validity Start Date | |||
| 15 | KSCHL_SUPP |
/1CN/CCDSAPSUNIL |
KSCHL_SUPP | /SAPCND/SUPP_COND_TYPE | Supplementary Condition Type | |||
| 16 | COND_GROUP_ID |
/1CN/CCDSAPSUNIL |
COND_GROUP_ID | /SAPCND/COND_GROUP_ID | ID of Group of Condition Records | |||
| 17 | MAINT_STATUS |
/1CN/CCDSAPSUNIL |
MAINT_STATUS | /SAPCND/MAINT_STATUS | Editing status | |||
| 18 | CREATED_BY |
/1CN/CCDSAPSUNIL |
CREATED_BY | /SAPCND/CREATED_BY | Name of User that Created the Condition Record | |||
| 19 | SUPP_EXIST |
/1CN/CCDSAPSUNIL |
SUPP_EXIST | /SAPCND/SUPP_EXIST | Additional Data Indicator for Condition Record | |||
| 20 | SCALE_DIM |
/1CN/CCDSAPSUNIL |
SCALE_DIM | /SAPCND/DIMENSION_ID | Dimenstion number | |||
| 21 | CAMPAIGN_GUID |
/1CN/CCDSAPSUNIL |
CAMPAIGN_GUID | CGPL_GUID16 | Project Planning: 16-Character GUID for Projects and Activts | |||
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 |
