R_ConditionDocumentItem
Condition Document Item
R_ConditionDocumentItem is a Basic CDS View that provides data about "Condition Document Item" in SAP S/4HANA. It reads from 1 data source (wcocoi) and exposes 28 fields with key fields ConditionDocument, ConditionDocumentItemUUID. It has 9 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| wcocoi | wcocoi | from |
Associations (9)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | R_ConditionDocument | _ConditionDocument | $projection.ConditionDocument = _ConditionDocument.ConditionDocument |
| [0..1] | I_CndnDocItmActivationStatus | _CndnDocItmActivationStatus | $projection.CndnDocItmActivationStatus = _CndnDocItmActivationStatus.CndnDocItmActivationStatus |
| [0..1] | I_Customer | _Customer | $projection.Customer = _Customer.Customer |
| [0..1] | I_Supplier | _Supplier | $projection.Supplier = _Supplier.Supplier |
| [0..1] | I_Product | _Product | $projection.Product = _Product.Product |
| [0..1] | R_ConditionDocument | _CndnDocItmRefcdCndnDoc | $projection.CndnDocItmRefcdCndnDoc = _CndnDocItmRefcdCndnDoc.ConditionDocument |
| [0..1] | I_CompanyCode | _CompanyCode | $projection.CompanyCode = _CompanyCode.CompanyCode |
| [0..1] | I_WBSElementBasicData | _WBSElementInternalID | $projection.WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID |
| [0..1] | I_InternalOrder | _SettlmtMgmtOrder | $projection.SettlmtMgmtOrder = _SettlmtMgmtOrder.InternalOrder |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Condition Document Item | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| VDM.viewType | #BASIC | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | false | view |
Fields (28)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ConditionDocument | |||
| KEY | ConditionDocumentItemUUID | item_guid | ||
| ConditionDocumentItem | ||||
| CndnDocItmActivationStatus | ||||
| CndnDocItemValidFromDate | date_from | |||
| CndnDocItemValidToDate | date_to | |||
| Customer | ||||
| Supplier | ||||
| Product | ||||
| CndnDocItmRefcdCndnDoc | ||||
| CompanyCode | ||||
| CostCenter | ||||
| WBSElementInternalID | ||||
| SettlmtMgmtOrder | aufnr | |||
| SettlementDistributionRatio | distribution_ratio | |||
| ConditionDocumentUUID | ||||
| CndnDocItemSourceUUID | ||||
| CndnDocObjNodeTypeAbbr | sont_abbrv_i | |||
| CndnDocSemanticCode | semantic_type_i | |||
| _ConditionDocument | _ConditionDocument | |||
| _CndnDocItmActivationStatus | _CndnDocItmActivationStatus | |||
| _Customer | _Customer | |||
| _Supplier | _Supplier | |||
| _Product | _Product | |||
| _CndnDocItmRefcdCndnDoc | _CndnDocItmRefcdCndnDoc | |||
| _CompanyCode | _CompanyCode | |||
| _WBSElementInternalID | _WBSElementInternalID | |||
| _SettlmtMgmtOrder | _SettlmtMgmtOrder |
@EndUserText.label: 'Condition Document Item'
@AccessControl: {
authorizationCheck: #MANDATORY,
personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
usageType.serviceQuality: #B,
usageType.dataClass: #TRANSACTIONAL,
usageType.sizeCategory: #XXL
}
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #SAP_INTERNAL_API
}
@Metadata: {
ignorePropagatedAnnotations: true,
allowExtensions: false
}
define view entity R_ConditionDocumentItem
as select from wcocoi
association [1..1] to R_ConditionDocument as _ConditionDocument on $projection.ConditionDocument = _ConditionDocument.ConditionDocument
association [0..1] to I_CndnDocItmActivationStatus as _CndnDocItmActivationStatus on $projection.CndnDocItmActivationStatus = _CndnDocItmActivationStatus.CndnDocItmActivationStatus
/* Partners */
association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
association [0..1] to I_Supplier as _Supplier on $projection.Supplier = _Supplier.Supplier
association [0..1] to I_Product as _Product on $projection.Product = _Product.Product
/* Referenced Condition Documents */
association [0..1] to R_ConditionDocument as _CndnDocItmRefcdCndnDoc on $projection.CndnDocItmRefcdCndnDoc = _CndnDocItmRefcdCndnDoc.ConditionDocument
/* Intercompany Cost Distribution related fields */
association [0..1] to I_CompanyCode as _CompanyCode on $projection.CompanyCode = _CompanyCode.CompanyCode
association [0..1] to I_WBSElementBasicData as _WBSElementInternalID on $projection.WBSElementInternalID = _WBSElementInternalID.WBSElementInternalID
association [0..1] to I_InternalOrder as _SettlmtMgmtOrder on $projection.SettlmtMgmtOrder = _SettlmtMgmtOrder.InternalOrder
{
key cast( num as wcb_condition_document preserving type ) as ConditionDocument,
key item_guid as ConditionDocumentItemUUID,
cast( posnr as wcb_condition_document_item preserving type ) as ConditionDocumentItem,
cast( deact as wcb_cndn_doc_itm_act_sts preserving type ) as CndnDocItmActivationStatus, // GFN, DE, association
/* Validity */
@Semantics.businessDate.from: true
date_from as CndnDocItemValidFromDate,
@Semantics.businessDate.to: true
date_to as CndnDocItemValidToDate,
/* Partners */
cast( eligible_cust as kunnr preserving type ) as Customer,
cast( eligible_vendor as lifnr preserving type ) as Supplier,
cast( material as productnumber preserving type ) as Product,
/* Referenced Condition Documents */
cast( list_num as wcb_cndndoc_itm_refcd_cndndoc preserving type ) as CndnDocItmRefcdCndnDoc,
/* Intercompany Cost Distribution related fields */
cast( bukrs as fis_bukrs preserving type ) as CompanyCode,
cast( kostl as fis_kostl preserving type ) as CostCenter,
cast( ps_psp_pnr as wlf_psp_pnr_no_cnext preserving type ) as WBSElementInternalID,
aufnr as SettlmtMgmtOrder,
distribution_ratio as SettlementDistributionRatio,
/* UUIDs */
cast( guid as wcb_cndn_doc_uuid preserving type ) as ConditionDocumentUUID,
cast( ext_guid as wcb_cndn_doc_itm_source_uuid preserving type ) as CndnDocItemSourceUUID,
/* SAP Object Node Type abbreviation and object semantics */
sont_abbrv_i as CndnDocObjNodeTypeAbbr,
semantic_type_i as CndnDocSemanticCode,
/* Associations */
_ConditionDocument,
_CndnDocItmActivationStatus,
_Customer,
_Supplier,
_Product,
_CndnDocItmRefcdCndnDoc,
_CompanyCode,
_WBSElementInternalID,
_SettlmtMgmtOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WCOCOI"
],
"ASSOCIATED":
[
"I_CNDNDOCITMACTIVATIONSTATUS",
"I_COMPANYCODE",
"I_CUSTOMER",
"I_INTERNALORDER",
"I_PRODUCT",
"I_SUPPLIER",
"I_WBSELEMENTBASICDATA",
"R_CONDITIONDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA