What is C_BasicConditionContractDEX in SAP S/4HANA?

C_BasicConditionContractDEX is a consumption CDS view in SAP S/4HANA. Basic Condition Contract Extraction It contains 69 fields.

Which tables does C_BasicConditionContractDEX read from?

C_BasicConditionContractDEX reads data from: R_BasicConditionContractDEX.

What VDM layer is C_BasicConditionContractDEX?

C_BasicConditionContractDEX is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BasicConditionContractDEX

DDL: C_BASICCONDITIONCONTRACTDEX Type: view_entity CONSUMPTION Package: WCB_AIL_VDM_DEX

69 Fields 1 Data Sources

Basic Condition Contract Extraction

C_BasicConditionContractDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Basic Condition Contract · Sales

C_BasicConditionContractDEX is a Consumption CDS View (Fact) that provides data about "Basic Condition Contract Extraction" in SAP S/4HANA. It reads from 1 data source (R_BasicConditionContractDEX) and exposes 69 fields with key field BasicConditionContract. Part of development package WCB_AIL_VDM_DEX.

SAP Help Documentation

Category	Basic 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 basic condition contracts. Providing all relevant information for basic condition contracts, this CDS view allows you to build analytical reports. This CDS view provides the data to answer the following business question: Which basic 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 the authorization to display the following data: Authorization Object: W_COCO Authorization required for Condition Contract Type ( CONTR_TYP ) Authorization Object: W_COCO_ORG Authorization required for the following: Sales Organization ( VKORG ) Distribution Channel ( VTWEG ) Division ( SPART ) Purchasing Organization ( EKORG ) Purchasing Group ( EKGRP ) Authorization Object: F_KNA1_BED Authorization required for the following partner: Customer ( BRGRU ) Authorization Object: F_LFA1_BEK Authorization required for the following partners: Supplier ( BRGRU ) Prior Supplier ( BRGRU )

Structure
Further Important Fields Important fields in this view include the following: Field Name Description BasicConditionContract Basic Condition Contract CndnContrType Condition Contract Type BscConditionContractCurrency Currency of Basic Condition Contract

Data Extraction
Data Extraction Type Full (physical deletions are possible in source tables) Delta (change data capture)

View on SAP Help Portal →

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

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_BasicConditionContractDEX	BasicConditionContract	from

Annotations (12)

Name	Value	Level
EndUserText.label	Basic Condition Contract Extraction	view
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.modelingPattern	#ANALYTICAL_FACT	view
ObjectModel.sapObjectNodeType.name	BasicConditionContract	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 (69)

Key	Field	Source Table	Source Field	Description
KEY	BasicConditionContract	R_BasicConditionContractDEX	BasicConditionContract	Basic Contract of Contract
	CndnContrType	R_BasicConditionContractDEX	CndnContrType	Condition Contract Type
	CndnContrClassfctnType	R_BasicConditionContractDEX	CndnContrClassfctnType	Condition Contract Category
	CndnContrProcVar	R_BasicConditionContractDEX	CndnContrProcVar	Condition Contract Process Variant
	DocumentReferenceID	R_BasicConditionContractDEX	DocumentReferenceID	Condition Contract: Reference
	BscCndnContrAssgmtReference	R_BasicConditionContractDEX	BscCndnContrAssgmtReference	Condition Contract: Assignment
	ExternalDocumentReferenceID	R_BasicConditionContractDEX	ExternalDocumentReferenceID	External Document Identifier
	BscCndnContrExternalPartner	R_BasicConditionContractDEX	BscCndnContrExternalPartner	Condition Contract: External Partner
	BscCndnContrActivationStatus	R_BasicConditionContractDEX	BscCndnContrActivationStatus	Condition Contract Activation Status
	BscCndnContrValidFromDate	R_BasicConditionContractDEX	BscCndnContrValidFromDate	Valid From
	BscCndnContrValidToDate	R_BasicConditionContractDEX	BscCndnContrValidToDate	Valid To
	Supplier	R_BasicConditionContractDEX	Supplier	Supplier as Partner of a Condition Contract
	Customer	R_BasicConditionContractDEX	Customer	Customer as Partner of a Condition Contract
	PriorSupplier	R_BasicConditionContractDEX	PriorSupplier	Prior Supplier
	CompanyCode	R_BasicConditionContractDEX	CompanyCode	Receiver Company Code
	PurchasingOrganization	R_BasicConditionContractDEX	PurchasingOrganization	Purchasing Organization
	PurchasingGroup	R_BasicConditionContractDEX	PurchasingGroup	Purchasing Group
	SalesOrganization	R_BasicConditionContractDEX	SalesOrganization	Sales Organization
	DistributionChannel	R_BasicConditionContractDEX	DistributionChannel	Distribution Channel
	Division	R_BasicConditionContractDEX	Division	Internal Division ID
	SalesGroup	R_BasicConditionContractDEX	SalesGroup	Sales Group
	SalesOffice	R_BasicConditionContractDEX	SalesOffice	Sales Office
	CreatedByUser	R_BasicConditionContractDEX	CreatedByUser	Condition Contract Created By
	CreationDate	R_BasicConditionContractDEX	CreationDate	Date of Condition Contract Creation
	CreationTime	R_BasicConditionContractDEX	CreationTime	Time of Condition Contract Creation
	CreationTimeZone	R_BasicConditionContractDEX	CreationTimeZone	Time Zone
	CreationUTCDateTime	R_BasicConditionContractDEX	CreationUTCDateTime	UTC Time Stamp of Condition Contract Creation
	LastChangedByUser	R_BasicConditionContractDEX	LastChangedByUser	Condition Contract Last Changed By
	LastChangedDate	R_BasicConditionContractDEX	LastChangedDate	Date of Last Condition Contract Change
	LastChangeTime	R_BasicConditionContractDEX	LastChangeTime	Time of Last Condition Contract Change
	LastChangeUTCDateTime	R_BasicConditionContractDEX	LastChangeUTCDateTime	UTC Time Stamp of Last Condition Contract Change
	BscConditionContractCurrency	R_BasicConditionContractDEX	BscConditionContractCurrency	Currency of Basic Condition Contract
	ExchangeRate	R_BasicConditionContractDEX	ExchangeRate	Exchange Rate (no Conversion)
	ExchangeRateType	R_BasicConditionContractDEX	ExchangeRateType	Exchange Rate Type
	ExchangeRateDate	R_BasicConditionContractDEX	ExchangeRateDate	Conversion Date
	PaymentTerms	R_BasicConditionContractDEX	PaymentTerms	Key for Terms of Payment
	CashDiscount1Days	R_BasicConditionContractDEX	CashDiscount1Days	Days from Baseline Date for Payment
	CashDiscount1Percent	R_BasicConditionContractDEX	CashDiscount1Percent	Discount for First Payment in %
	CashDiscount2Days	R_BasicConditionContractDEX	CashDiscount2Days	Days from Baseline Date for Payment
	CashDiscount2Percent	R_BasicConditionContractDEX	CashDiscount2Percent	Discount for Second Payment in %
	NetPaymentDays	R_BasicConditionContractDEX	NetPaymentDays	Net Pmt Terms Period
	PaymentMethod	R_BasicConditionContractDEX	PaymentMethod	Payment Method
	BscCndnContrSuplrSettlmtCat	R_BasicConditionContractDEX	BscCndnContrSuplrSettlmtCat	Supplier Settlement Category
	BscCndnContrCustSettlmtCat	R_BasicConditionContractDEX	BscCndnContrCustSettlmtCat	Customer Settlement Category
	SettlmtProduct	R_BasicConditionContractDEX	SettlmtProduct	Settlement Product
	FinalSettlmtCalendar	R_BasicConditionContractDEX	FinalSettlmtCalendar	Calendar for Final Settlement
	PartialSettlmtCalendar	R_BasicConditionContractDEX	PartialSettlmtCalendar	Calendar for Partial Settlement
	DeltaSettlmtCalendar	R_BasicConditionContractDEX	DeltaSettlmtCalendar	Calendar for Delta Settlement
	DeltaAccrualSettlmtCalendar	R_BasicConditionContractDEX	DeltaAccrualSettlmtCalendar	Calendar for Delta Accruals Settlement
	AccrualClearingSettlmtCalendar	R_BasicConditionContractDEX	AccrualClearingSettlmtCalendar	Calendar for Accruals Deferral Settlement
	CndnContrExtensionCalendar	R_BasicConditionContractDEX	CndnContrExtensionCalendar	Calendar for Condition Contract Extension
	PrecdgBasicConditionContract	R_BasicConditionContractDEX	PrecedingConditionDocument	Predecessor Condition Contract
	BscCndnContrPurposeCategory	R_BasicConditionContractDEX	BscCndnContrPurposeCategory	Condition Contract Purpose Category
	BscCndnContrSrceDocCategory	R_BasicConditionContractDEX	BscCndnContrSrceDocCategory	External Reference Document Category
	BscCndnContrSourceDocument	R_BasicConditionContractDEX	BscCndnContrSourceDocument	External Reference
	BscCndnContrSourceDocumentItem	R_BasicConditionContractDEX	BscCndnContrSourceDocumentItem	External Reference Item
	BusVolTableGroup	R_BasicConditionContractDEX	BusVolTableGroup	Business Volume Table Group
	AmountFieldGroup	R_BasicConditionContractDEX	AmountFieldGroup	Amount Fields Group
	BasicConditionContractUnit	R_BasicConditionContractDEX	BasicConditionContractUnit	Settlement Unit of Measure
	BscCndnContrWeightUnit	R_BasicConditionContractDEX	BscCndnContrWeightUnit	Settlement Unit of Weight
	BscCndnContrVolumeUnit	R_BasicConditionContractDEX	BscCndnContrVolumeUnit	Settlement Unit of Volume
	BscCndnContrPtsQuantityUnit	R_BasicConditionContractDEX	BscCndnContrPtsQuantityUnit	Settlement Points Unit
	AccrualUpdateIsRequired	R_BasicConditionContractDEX	AccrualUpdateIsRequired	Accruals Update Required
	TaxCountry	R_BasicConditionContractDEX	TaxCountry	Tax Reporting Country/Region
	SettlmtPartTxRegnCntry	R_BasicConditionContractDEX	SettlmtPartTxRegnCntry	Partner Tax Country/Region
	SettlmtPartTxRegnNmbr	R_BasicConditionContractDEX	SettlmtPartTxRegnNmbr	VAT Registration Number
	_Customer	R_BasicConditionContractDEX	_Customer
	_PriorSupplier	R_BasicConditionContractDEX	_PriorSupplier
	_Supplier	R_BasicConditionContractDEX	_Supplier

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_BasicConditionContractDEX.
-- 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_BasicConditionContractDEX AS
SELECT
  BasicConditionContract.BasicConditionContract AS BasicConditionContract,
  BasicConditionContract.CndnContrType AS CndnContrType,
  BasicConditionContract.CndnContrClassfctnType AS CndnContrClassfctnType,
  BasicConditionContract.CndnContrProcVar AS CndnContrProcVar,
  BasicConditionContract.DocumentReferenceID AS DocumentReferenceID,
  BasicConditionContract.BscCndnContrAssgmtReference AS BscCndnContrAssgmtReference,
  BasicConditionContract.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
  BasicConditionContract.BscCndnContrExternalPartner AS BscCndnContrExternalPartner,
  BasicConditionContract.BscCndnContrActivationStatus AS BscCndnContrActivationStatus,
  BasicConditionContract.BscCndnContrValidFromDate AS BscCndnContrValidFromDate,
  BasicConditionContract.BscCndnContrValidToDate AS BscCndnContrValidToDate,
  BasicConditionContract.Supplier AS Supplier,
  BasicConditionContract.Customer AS Customer,
  BasicConditionContract.PriorSupplier AS PriorSupplier,
  BasicConditionContract.CompanyCode AS CompanyCode,
  BasicConditionContract.PurchasingOrganization AS PurchasingOrganization,
  BasicConditionContract.PurchasingGroup AS PurchasingGroup,
  BasicConditionContract.SalesOrganization AS SalesOrganization,
  BasicConditionContract.DistributionChannel AS DistributionChannel,
  BasicConditionContract.Division AS Division,
  BasicConditionContract.SalesGroup AS SalesGroup,
  BasicConditionContract.SalesOffice AS SalesOffice,
  BasicConditionContract.CreatedByUser AS CreatedByUser,
  BasicConditionContract.CreationDate AS CreationDate,
  BasicConditionContract.CreationTime AS CreationTime,
  BasicConditionContract.CreationTimeZone AS CreationTimeZone,
  BasicConditionContract.CreationUTCDateTime AS CreationUTCDateTime,
  BasicConditionContract.LastChangedByUser AS LastChangedByUser,
  BasicConditionContract.LastChangedDate AS LastChangedDate,
  BasicConditionContract.LastChangeTime AS LastChangeTime,
  BasicConditionContract.LastChangeUTCDateTime AS LastChangeUTCDateTime,
  BasicConditionContract.BscConditionContractCurrency AS BscConditionContractCurrency,
  BasicConditionContract.ExchangeRate AS ExchangeRate,
  BasicConditionContract.ExchangeRateType AS ExchangeRateType,
  BasicConditionContract.ExchangeRateDate AS ExchangeRateDate,
  BasicConditionContract.PaymentTerms AS PaymentTerms,
  BasicConditionContract.CashDiscount1Days AS CashDiscount1Days,
  BasicConditionContract.CashDiscount1Percent AS CashDiscount1Percent,
  BasicConditionContract.CashDiscount2Days AS CashDiscount2Days,
  BasicConditionContract.CashDiscount2Percent AS CashDiscount2Percent,
  BasicConditionContract.NetPaymentDays AS NetPaymentDays,
  BasicConditionContract.PaymentMethod AS PaymentMethod,
  BasicConditionContract.BscCndnContrSuplrSettlmtCat AS BscCndnContrSuplrSettlmtCat,
  BasicConditionContract.BscCndnContrCustSettlmtCat AS BscCndnContrCustSettlmtCat,
  BasicConditionContract.SettlmtProduct AS SettlmtProduct,
  BasicConditionContract.FinalSettlmtCalendar AS FinalSettlmtCalendar,
  BasicConditionContract.PartialSettlmtCalendar AS PartialSettlmtCalendar,
  BasicConditionContract.DeltaSettlmtCalendar AS DeltaSettlmtCalendar,
  BasicConditionContract.DeltaAccrualSettlmtCalendar AS DeltaAccrualSettlmtCalendar,
  BasicConditionContract.AccrualClearingSettlmtCalendar AS AccrualClearingSettlmtCalendar,
  BasicConditionContract.CndnContrExtensionCalendar AS CndnContrExtensionCalendar,
  BasicConditionContract.PrecedingConditionDocument AS PrecdgBasicConditionContract,
  BasicConditionContract.BscCndnContrPurposeCategory AS BscCndnContrPurposeCategory,
  BasicConditionContract.BscCndnContrSrceDocCategory AS BscCndnContrSrceDocCategory,
  BasicConditionContract.BscCndnContrSourceDocument AS BscCndnContrSourceDocument,
  BasicConditionContract.BscCndnContrSourceDocumentItem AS BscCndnContrSourceDocumentItem,
  BasicConditionContract.BusVolTableGroup AS BusVolTableGroup,
  BasicConditionContract.AmountFieldGroup AS AmountFieldGroup,
  BasicConditionContract.BasicConditionContractUnit AS BasicConditionContractUnit,
  BasicConditionContract.BscCndnContrWeightUnit AS BscCndnContrWeightUnit,
  BasicConditionContract.BscCndnContrVolumeUnit AS BscCndnContrVolumeUnit,
  BasicConditionContract.BscCndnContrPtsQuantityUnit AS BscCndnContrPtsQuantityUnit,
  BasicConditionContract.AccrualUpdateIsRequired AS AccrualUpdateIsRequired,
  BasicConditionContract.TaxCountry AS TaxCountry,
  BasicConditionContract.SettlmtPartTxRegnCntry AS SettlmtPartTxRegnCntry,
  BasicConditionContract.SettlmtPartTxRegnNmbr AS SettlmtPartTxRegnNmbr,
  BasicConditionContract._Customer AS _Customer,
  BasicConditionContract._PriorSupplier AS _PriorSupplier,
  BasicConditionContract._Supplier AS _Supplier
FROM R_BasicConditionContractDEX AS BasicConditionContract
;

Depth:

C_BasicConditionContractDEX view_entity

R_BasicConditionContractDEX view_entity