C_ConditionContractDEX
Condition Contract Extraction
C_ConditionContractDEX (Consumption)
Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.
Condition Contract · Sales
C_ConditionContractDEX is a Consumption CDS View (Fact) that provides data about "Condition Contract Extraction" in SAP S/4HANA. It reads from 1 data source (R_ConditionContractDEX) and exposes 74 fields with key field ConditionContract. Part of development package WCB_AIL_VDM_DEX.
SAP Help Documentation
| Category | Condition Contract |
|---|---|
| Data Category | Fact |
Purpose
This CDS view is used for data extraction to SAP BW/4HANA . It enables the data transfer to SAP BW/4HANA for condition contracts. Providing all relevant information for condition contracts, this CDS view allows you to build analytical reports. This CDS view provides the data to answer the following business question: Which condition contracts are relevant for data extraction to SAP BW/4HANA ? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations Users who want to run data transfer to SAP BW/4HANA using this CDS view must have a role with the following restriction types set to read access: BEGRU_KNA1 (Authorization Group for Customers) BEGRU_LFA1 (Authorization Group for Suppliers) ORG_AREA (Organizational Area) CONTR_TYP (Condition Contract Type) BEGRU_BUPA_GRP (Authorization Group for Business Partners) BUKRS_KOSTL (Company Code/Cost Center) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.
Structure
Important Fields Important fields in this view include the following: Field Name Description ConditionContract Condition Contract CndnContrType Condition Contract Type CndnContrCurrency Currency of Condition Contract
Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture)
This CDS view is used for data extraction to SAP BW/4HANA . It enables the data transfer to SAP BW/4HANA for condition contracts. Providing all relevant information for condition contracts, this CDS view allows you to build analytical reports. This CDS view provides the data to answer the following business question: Which condition contracts are relevant for data extraction to SAP BW/4HANA ? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .
Prerequisites
Authorizations Users who want to run data transfer to SAP BW/4HANA using this CDS view must have a role with the following restriction types set to read access: BEGRU_KNA1 (Authorization Group for Customers) BEGRU_LFA1 (Authorization Group for Suppliers) ORG_AREA (Organizational Area) CONTR_TYP (Condition Contract Type) BEGRU_BUPA_GRP (Authorization Group for Business Partners) BUKRS_KOSTL (Company Code/Cost Center) You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.
Structure
Important Fields Important fields in this view include the following: Field Name Description ConditionContract Condition Contract CndnContrType Condition Contract Type CndnContrCurrency Currency of Condition Contract
Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture)
SAP API Hub
| Category | Consumption |
|---|---|
| State | C1 |
| Line of Business | Sales |
| Application Component | LO-GT-CHB |
| Capabilities | Data Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities |
| Extensible (Key User) | No |
| Extensible (Developer) | No |
| Release State (Key User) | Released |
| Release State (Developer) | Not Released |
| Package | Sales for SAP S/4HANA Cloud Public Edition |
| Description | <p>This CDS view is used for data extraction to SAP BW/4HANA. It enables the data transfer to SAP BW/4HANA for condition contracts. Providing all relevant information for condition contracts, this CDS view allows you to build analytical reports.</p> <p>This CDS view provides the data to answer the following business question:</p> <ul> <li> <p>Which condition contracts are relevant for data extraction to SAP BW/4HANA?</p> </li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p> |
Documentation
- Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
- CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
- Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
- Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
- Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
- Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
- SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
- VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
- View Browser — Search, browse and tag CDS Views
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_ConditionContractDEX | ConditionContractDEX | from |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Condition Contract Extraction | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_FACT | view | |
| ObjectModel.sapObjectNodeType.name | ConditionContract | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| Analytics.dataCategory | #FACT | view | |
| Analytics.dataExtraction.enabled | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| Metadata.allowExtensions | false | view |
Fields (74)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ConditionContract | ConditionContract | Condition Contract | |
| CndnContrType | R_ConditionContractDEX | CndnContrType | Condition Contract Type | |
| CndnContrClassfctnType | R_ConditionContractDEX | CndnContrClassfctnType | Condition Contract Category | |
| CndnContrProcVar | R_ConditionContractDEX | CndnContrProcVar | Condition Contract Process Variant | |
| DocumentReferenceID | R_ConditionContractDEX | DocumentReferenceID | Condition Contract: Reference | |
| CndnContrAssgmtRef | R_ConditionContractDEX | CndnContrAssgmtRef | Condition Contract: Assignment | |
| ExternalDocumentReferenceID | R_ConditionContractDEX | ExternalDocumentReferenceID | External Document Identifier | |
| CndnContrExternalPartner | R_ConditionContractDEX | CndnContrExternalPartner | Condition Contract: External Partner | |
| CndnContrActvtnStatus | R_ConditionContractDEX | CndnContrActvtnStatus | Condition Contract Activation Status | |
| CndnContrValidFrom | R_ConditionContractDEX | CndnContrValidFrom | Valid From | |
| CndnContrValidTo | R_ConditionContractDEX | CndnContrValidTo | Valid To | |
| Supplier | R_ConditionContractDEX | Supplier | Supplier as Partner of a Condition Contract | |
| Customer | R_ConditionContractDEX | Customer | Customer as Partner of a Condition Contract | |
| PriorSupplier | R_ConditionContractDEX | PriorSupplier | Prior Supplier | |
| PersonWorkAgreement | R_ConditionContractDEX | PersonWorkAgreement | Worker as Partner of a Condition Contract | |
| CompanyCode | R_ConditionContractDEX | CompanyCode | Receiver Company Code | |
| PurchasingOrganization | R_ConditionContractDEX | PurchasingOrganization | Purchasing Organization | |
| PurchasingGroup | R_ConditionContractDEX | PurchasingGroup | Purchasing Group | |
| SalesOrganization | R_ConditionContractDEX | SalesOrganization | Sales Organization | |
| DistributionChannel | R_ConditionContractDEX | DistributionChannel | Distribution Channel | |
| Division | R_ConditionContractDEX | Division | Internal Division ID | |
| SalesGroup | R_ConditionContractDEX | SalesGroup | Sales Group | |
| SalesOffice | R_ConditionContractDEX | SalesOffice | Sales Office | |
| CreatedByUser | R_ConditionContractDEX | CreatedByUser | Condition Contract Created By | |
| CreationDate | R_ConditionContractDEX | CreationDate | Date of Condition Contract Creation | |
| CreationTime | R_ConditionContractDEX | CreationTime | Time of Condition Contract Creation | |
| CreationTimeZone | R_ConditionContractDEX | CreationTimeZone | Time Zone | |
| CreationUTCDateTime | R_ConditionContractDEX | CreationUTCDateTime | UTC Time Stamp of Condition Contract Creation | |
| LastChangedByUser | R_ConditionContractDEX | LastChangedByUser | Condition Contract Last Changed By | |
| LastChangedDate | R_ConditionContractDEX | LastChangedDate | Date of Last Condition Contract Change | |
| LastChangeTime | R_ConditionContractDEX | LastChangeTime | Time of Last Condition Contract Change | |
| LastChangeUTCDateTime | R_ConditionContractDEX | LastChangeUTCDateTime | UTC Time Stamp of Last Condition Contract Change | |
| CndnContrCurrency | R_ConditionContractDEX | CndnContrCurrency | Currency of Condition Contract | |
| ExchangeRate | R_ConditionContractDEX | ExchangeRate | Exchange Rate (no Conversion) | |
| ExchangeRateType | R_ConditionContractDEX | ExchangeRateType | Exchange Rate Type | |
| ExchangeRateDate | R_ConditionContractDEX | ExchangeRateDate | Conversion Date | |
| PaymentTerms | R_ConditionContractDEX | PaymentTerms | Key for Terms of Payment | |
| CashDiscount1Days | R_ConditionContractDEX | CashDiscount1Days | Days from Baseline Date for Payment | |
| CashDiscount1Percent | R_ConditionContractDEX | CashDiscount1Percent | Discount for First Payment in % | |
| CashDiscount2Days | R_ConditionContractDEX | CashDiscount2Days | Days from Baseline Date for Payment | |
| CashDiscount2Percent | R_ConditionContractDEX | CashDiscount2Percent | Discount for Second Payment in % | |
| NetPaymentDays | R_ConditionContractDEX | NetPaymentDays | Net Pmt Terms Period | |
| PaymentMethod | R_ConditionContractDEX | PaymentMethod | Payment Method | |
| CndnContrSuplrSettlmtCat | R_ConditionContractDEX | CndnContrSuplrSettlmtCat | Supplier Settlement Category | |
| CndnContrCustSettlmtCat | R_ConditionContractDEX | CndnContrCustSettlmtCat | Customer Settlement Category | |
| SettlmtProduct | R_ConditionContractDEX | SettlmtProduct | Settlement Product | |
| FinalSettlmtCalendar | R_ConditionContractDEX | FinalSettlmtCalendar | Calendar for Final Settlement | |
| PartialSettlmtCalendar | R_ConditionContractDEX | PartialSettlmtCalendar | Calendar for Partial Settlement | |
| DeltaSettlmtCalendar | R_ConditionContractDEX | DeltaSettlmtCalendar | Calendar for Delta Settlement | |
| DeltaAccrualSettlmtCalendar | R_ConditionContractDEX | DeltaAccrualSettlmtCalendar | Calendar for Delta Accruals Settlement | |
| AccrualClearingSettlmtCalendar | R_ConditionContractDEX | AccrualClearingSettlmtCalendar | Calendar for Accruals Deferral Settlement | |
| CndnContrExtensionCalendar | R_ConditionContractDEX | CndnContrExtensionCalendar | Calendar for Condition Contract Extension | |
| PrecedingConditionContract | R_ConditionContractDEX | PrecedingConditionDocument | Predecessor Condition Contract | |
| CndnContrPurposeCat | R_ConditionContractDEX | CndnContrPurposeCat | Condition Contract Purpose Category | |
| CndnContrSourceDocCat | R_ConditionContractDEX | CndnContrSourceDocCat | External Reference Document Category | |
| CndnContrSourceDoc | R_ConditionContractDEX | CndnContrSourceDoc | External Reference | |
| CndnContrSourceDocItem | R_ConditionContractDEX | CndnContrSourceDocItem | External Reference Item | |
| BusVolTableGroup | R_ConditionContractDEX | BusVolTableGroup | Business Volume Table Group | |
| AmountFieldGroup | R_ConditionContractDEX | AmountFieldGroup | Amount Fields Group | |
| CndnContrUnit | R_ConditionContractDEX | CndnContrUnit | Settlement Unit of Measure | |
| CndnContrWeightUnit | R_ConditionContractDEX | CndnContrWeightUnit | Settlement Unit of Weight | |
| CndnContrVolumeUnit | R_ConditionContractDEX | CndnContrVolumeUnit | Settlement Unit of Volume | |
| CndnContrPointsQtyUnit | R_ConditionContractDEX | CndnContrPointsQtyUnit | Settlement Points Unit | |
| AccrualUpdateIsRequired | R_ConditionContractDEX | AccrualUpdateIsRequired | Accruals Update Required | |
| TaxCountry | R_ConditionContractDEX | TaxCountry | Tax Reporting Country/Region | |
| SettlmtPartTxRegnCntry | R_ConditionContractDEX | SettlmtPartTxRegnCntry | Partner Tax Country/Region | |
| SettlmtPartTxRegnNmbr | R_ConditionContractDEX | SettlmtPartTxRegnNmbr | VAT Registration Number | |
| BasicConditionContract | R_ConditionContractDEX | BasicConditionContract | Basic Contract of Contract | |
| CndnContrWorkerCostCenter | R_ConditionContractDEX | CndnContrWorkerCostCenter | Worker Cost Center | |
| CndnContrSemanticCode | R_ConditionContractDEX | CndnContrSemanticCode | Semantic Type | |
| _Customer | R_ConditionContractDEX | _Customer | ||
| _Supplier | R_ConditionContractDEX | _Supplier | ||
| _PriorSupplier | R_ConditionContractDEX | _PriorSupplier | ||
| _PersonWorkAgreement | R_ConditionContractDEX | _PersonWorkAgreement |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view C_ConditionContractDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW C_ConditionContractDEX AS
SELECT
ConditionContract,
ConditionContractDEX.CndnContrType AS CndnContrType,
ConditionContractDEX.CndnContrClassfctnType AS CndnContrClassfctnType,
ConditionContractDEX.CndnContrProcVar AS CndnContrProcVar,
ConditionContractDEX.DocumentReferenceID AS DocumentReferenceID,
ConditionContractDEX.CndnContrAssgmtRef AS CndnContrAssgmtRef,
ConditionContractDEX.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
ConditionContractDEX.CndnContrExternalPartner AS CndnContrExternalPartner,
ConditionContractDEX.CndnContrActvtnStatus AS CndnContrActvtnStatus,
ConditionContractDEX.CndnContrValidFrom AS CndnContrValidFrom,
ConditionContractDEX.CndnContrValidTo AS CndnContrValidTo,
ConditionContractDEX.Supplier AS Supplier,
ConditionContractDEX.Customer AS Customer,
ConditionContractDEX.PriorSupplier AS PriorSupplier,
ConditionContractDEX.PersonWorkAgreement AS PersonWorkAgreement,
ConditionContractDEX.CompanyCode AS CompanyCode,
ConditionContractDEX.PurchasingOrganization AS PurchasingOrganization,
ConditionContractDEX.PurchasingGroup AS PurchasingGroup,
ConditionContractDEX.SalesOrganization AS SalesOrganization,
ConditionContractDEX.DistributionChannel AS DistributionChannel,
ConditionContractDEX.Division AS Division,
ConditionContractDEX.SalesGroup AS SalesGroup,
ConditionContractDEX.SalesOffice AS SalesOffice,
ConditionContractDEX.CreatedByUser AS CreatedByUser,
ConditionContractDEX.CreationDate AS CreationDate,
ConditionContractDEX.CreationTime AS CreationTime,
ConditionContractDEX.CreationTimeZone AS CreationTimeZone,
ConditionContractDEX.CreationUTCDateTime AS CreationUTCDateTime,
ConditionContractDEX.LastChangedByUser AS LastChangedByUser,
ConditionContractDEX.LastChangedDate AS LastChangedDate,
ConditionContractDEX.LastChangeTime AS LastChangeTime,
ConditionContractDEX.LastChangeUTCDateTime AS LastChangeUTCDateTime,
ConditionContractDEX.CndnContrCurrency AS CndnContrCurrency,
ConditionContractDEX.ExchangeRate AS ExchangeRate,
ConditionContractDEX.ExchangeRateType AS ExchangeRateType,
ConditionContractDEX.ExchangeRateDate AS ExchangeRateDate,
ConditionContractDEX.PaymentTerms AS PaymentTerms,
ConditionContractDEX.CashDiscount1Days AS CashDiscount1Days,
ConditionContractDEX.CashDiscount1Percent AS CashDiscount1Percent,
ConditionContractDEX.CashDiscount2Days AS CashDiscount2Days,
ConditionContractDEX.CashDiscount2Percent AS CashDiscount2Percent,
ConditionContractDEX.NetPaymentDays AS NetPaymentDays,
ConditionContractDEX.PaymentMethod AS PaymentMethod,
ConditionContractDEX.CndnContrSuplrSettlmtCat AS CndnContrSuplrSettlmtCat,
ConditionContractDEX.CndnContrCustSettlmtCat AS CndnContrCustSettlmtCat,
ConditionContractDEX.SettlmtProduct AS SettlmtProduct,
ConditionContractDEX.FinalSettlmtCalendar AS FinalSettlmtCalendar,
ConditionContractDEX.PartialSettlmtCalendar AS PartialSettlmtCalendar,
ConditionContractDEX.DeltaSettlmtCalendar AS DeltaSettlmtCalendar,
ConditionContractDEX.DeltaAccrualSettlmtCalendar AS DeltaAccrualSettlmtCalendar,
ConditionContractDEX.AccrualClearingSettlmtCalendar AS AccrualClearingSettlmtCalendar,
ConditionContractDEX.CndnContrExtensionCalendar AS CndnContrExtensionCalendar,
ConditionContractDEX.PrecedingConditionDocument AS PrecedingConditionContract,
ConditionContractDEX.CndnContrPurposeCat AS CndnContrPurposeCat,
ConditionContractDEX.CndnContrSourceDocCat AS CndnContrSourceDocCat,
ConditionContractDEX.CndnContrSourceDoc AS CndnContrSourceDoc,
ConditionContractDEX.CndnContrSourceDocItem AS CndnContrSourceDocItem,
ConditionContractDEX.BusVolTableGroup AS BusVolTableGroup,
ConditionContractDEX.AmountFieldGroup AS AmountFieldGroup,
ConditionContractDEX.CndnContrUnit AS CndnContrUnit,
ConditionContractDEX.CndnContrWeightUnit AS CndnContrWeightUnit,
ConditionContractDEX.CndnContrVolumeUnit AS CndnContrVolumeUnit,
ConditionContractDEX.CndnContrPointsQtyUnit AS CndnContrPointsQtyUnit,
ConditionContractDEX.AccrualUpdateIsRequired AS AccrualUpdateIsRequired,
ConditionContractDEX.TaxCountry AS TaxCountry,
ConditionContractDEX.SettlmtPartTxRegnCntry AS SettlmtPartTxRegnCntry,
ConditionContractDEX.SettlmtPartTxRegnNmbr AS SettlmtPartTxRegnNmbr,
ConditionContractDEX.BasicConditionContract AS BasicConditionContract,
ConditionContractDEX.CndnContrWorkerCostCenter AS CndnContrWorkerCostCenter,
ConditionContractDEX.CndnContrSemanticCode AS CndnContrSemanticCode,
ConditionContractDEX._Customer AS _Customer,
ConditionContractDEX._Supplier AS _Supplier,
ConditionContractDEX._PriorSupplier AS _PriorSupplier,
ConditionContractDEX._PersonWorkAgreement AS _PersonWorkAgreement
FROM R_ConditionContractDEX AS ConditionContractDEX
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA