C_ConditionContractDP

DDL: C_CONDITIONCONTRACTDP Type: view_entity CONSUMPTION
78 Fields 1 Data Sources 3 Associations

Condition Contract

C_ConditionContractDP (Consumption)

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

Condition Contract · Sales

C_ConditionContractDP is a Consumption CDS View that provides data about "Condition Contract" in SAP S/4HANA. It reads from 1 data source (R_ConditionContract) and exposes 78 fields with key field ConditionContract. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-GT-CHB
CapabilitiesData Source for Data Extraction
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
R_ConditionContract R_ConditionContract from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_CndnContrSettlmtCalDP _CndnContrSettlmtCal $projection.ConditionContract = _CndnContrSettlmtCal.ConditionContract
[0..*] C_CndnContrBusVolSelCriteriaDP _CndnContrBusVolSelCriteria $projection.ConditionContract = _CndnContrBusVolSelCriteria.ConditionContract
[1..1] E_ConditionContract _Extension $projection.ConditionContract = _Extension.ConditionContract

Annotations (11)

NameValueLevelField
EndUserText.label Condition Contract view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name ConditionContract view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
Analytics.dataExtraction.enabled true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (78)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract Condition Contract
CndnContrType CndnContrType Condition Contract Type
CndnContrClassfctnType CndnContrClassfctnType Condition Contract Category
CndnContrProcVar CndnContrProcVar Condition Contract Process Variant
DocumentReferenceID DocumentReferenceID Condition Contract: Reference
CndnContrAssgmtRef CndnContrAssgmtRef Condition Contract: Assignment
ExternalDocumentReferenceID ExternalDocumentReferenceID External Document Identifier
CndnContrExternalPartner CndnContrExternalPartner Condition Contract: External Partner
CndnContrActvtnStatus CndnContrActvtnStatus Condition Contract Activation Status
CndnContrValidFrom CndnContrValidFrom Valid From
CndnContrValidTo CndnContrValidTo Valid To
Supplier Supplier Supplier as Partner of a Condition Contract
Customer Customer Customer as Partner of a Condition Contract
PriorSupplier PriorSupplier Prior Supplier
CompanyCode CompanyCode Receiver Company Code
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel Distribution Channel
Division Division Internal Division ID
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
CreatedByUser CreatedByUser Condition Contract Created By
CreationDate CreationDate Date of Condition Contract Creation
CreationTime CreationTime Time of Condition Contract Creation
CreationTimeZone CreationTimeZone Time Zone
CreationUTCDateTime CreationUTCDateTime UTC Time Stamp of Condition Contract Creation
LastChangedByUser LastChangedByUser Condition Contract Last Changed By
LastChangedDate LastChangedDate Date of Last Condition Contract Change
LastChangeTime LastChangeTime Time of Last Condition Contract Change
LastChangeUTCDateTime LastChangeUTCDateTime UTC Time Stamp of Last Condition Contract Change
CndnContrCurrency CndnContrCurrency Currency of Condition Contract
ExchangeRateType ExchangeRateType Exchange Rate Type
ExchangeRate ExchangeRate Exchange Rate (no Conversion)
ExchangeRateDate ExchangeRateDate Conversion Date
PaymentTerms PaymentTerms Terms of Payment Key
CashDiscount1Days CashDiscount1Days Days from Baseline Date for Payment
CashDiscount1Percent CashDiscount1Percent Discount for First Payment in %
CashDiscount2Days CashDiscount2Days Days from Baseline Date for Payment
CashDiscount2Percent CashDiscount2Percent Discount for Second Payment in %
NetPaymentDays NetPaymentDays Net Pmt Terms Period
PaymentMethod PaymentMethod Payment Method
CndnContrSuplrSettlmtCat CndnContrSuplrSettlmtCat Supplier Settlement Category
CndnContrCustSettlmtCat CndnContrCustSettlmtCat Customer Settlement Category
SettlmtProduct SettlmtProduct Settlement Product
FinalSettlmtCalendar FinalSettlmtCalendar Calendar for Final Settlement
PartialSettlmtCalendar PartialSettlmtCalendar Calendar for Partial Settlement
DeltaSettlmtCalendar DeltaSettlmtCalendar Calendar for Delta Settlement
DeltaAccrualSettlmtCalendar DeltaAccrualSettlmtCalendar Calendar for Delta Accruals Settlement
AccrualClearingSettlmtCalendar AccrualClearingSettlmtCalendar Calendar for Accruals Deferral Settlement
CndnContrExtensionCalendar CndnContrExtensionCalendar Calendar for Condition Contract Extension
PrecedingConditionContract PrecedingConditionDocument Predecessor Condition Contract
CndnContrPurposeCat CndnContrPurposeCat Condition Contract Purpose Category
CndnContrSourceDocCat CndnContrSourceDocCat External Reference Document Category
CndnContrSourceDoc CndnContrSourceDoc External Reference
CndnContrSourceDocItem CndnContrSourceDocItem External Reference Item
BusVolTableGroup BusVolTableGroup Business Volume Table Group
AmountFieldGroup AmountFieldGroup Amount Fields Group
CndnContrUnit CndnContrUnit Settlement Unit of Measure
CndnContrWeightUnit CndnContrWeightUnit Settlement Unit of Weight
CndnContrVolumeUnit CndnContrVolumeUnit Settlement Unit of Volume
CndnContrPointsQtyUnit CndnContrPointsQtyUnit Settlement Points Unit
AccrualUpdateIsRequired AccrualUpdateIsRequired Accruals Update Required
CndnContrUUID CndnContrUUID Condition Contract GUID
CndnContrSourceUUID CndnContrSourceUUID External Condition Contract GUID
SettlmtPartTxRegnNmbr SettlmtPartTxRegnNmbr VAT Registration Number
TaxCountry TaxCountry Tax Reporting Country/Region
SettlmtPartTxRegnCntry SettlmtPartTxRegnCntry Partner Tax Country/Region
CndnContrPrcgDetnRlvnceCat CndnContrPrcgDetnRlvnceCat CC Determination Relevance in Pricing (Condition Contract)
CndnContrWorkerCostCenter CndnContrWorkerCostCenter Worker Cost Center
CndnContrWorkerSettlmtCat CndnContrWorkerSettlmtCat Settlement Type Worker
DataController DataController Data Controller
CndnContrSemanticCode CndnContrSemanticCode Semantic Type
CndnContrProcessCategory CndnContrProcessCategory Process Category of a Condition Contract
CndnContrPartnerCat CndnContrPartnerCat Type of Business Partner for Condition Contract
CndnContrSettlmtType CndnContrSettlmtType Conditon Contract Settlement Type
_CndnContrSettlmtCal _CndnContrSettlmtCal
_CndnContrBusVolSelCriteria _CndnContrBusVolSelCriteria

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_ConditionContractDP.
-- 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_ConditionContractDP AS
SELECT
  ConditionContract,
  CndnContrType,
  CndnContrClassfctnType,
  CndnContrProcVar,
  DocumentReferenceID,
  CndnContrAssgmtRef,
  ExternalDocumentReferenceID,
  CndnContrExternalPartner,
  CndnContrActvtnStatus,
  CndnContrValidFrom,
  CndnContrValidTo,
  Supplier,
  Customer,
  PriorSupplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesGroup,
  SalesOffice,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CreationTimeZone,
  CreationUTCDateTime,
  LastChangedByUser,
  LastChangedDate,
  LastChangeTime,
  LastChangeUTCDateTime,
  CndnContrCurrency,
  ExchangeRateType,
  ExchangeRate,
  ExchangeRateDate,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount1Percent,
  CashDiscount2Days,
  CashDiscount2Percent,
  NetPaymentDays,
  PaymentMethod,
  CndnContrSuplrSettlmtCat,
  CndnContrCustSettlmtCat,
  SettlmtProduct,
  FinalSettlmtCalendar,
  PartialSettlmtCalendar,
  DeltaSettlmtCalendar,
  DeltaAccrualSettlmtCalendar,
  AccrualClearingSettlmtCalendar,
  CndnContrExtensionCalendar,
  PrecedingConditionDocument AS PrecedingConditionContract,
  CndnContrPurposeCat,
  CndnContrSourceDocCat,
  CndnContrSourceDoc,
  CndnContrSourceDocItem,
  BusVolTableGroup,
  AmountFieldGroup,
  CndnContrUnit,
  CndnContrWeightUnit,
  CndnContrVolumeUnit,
  CndnContrPointsQtyUnit,
  AccrualUpdateIsRequired,
  CndnContrUUID,
  CndnContrSourceUUID,
  SettlmtPartTxRegnNmbr,
  TaxCountry,
  SettlmtPartTxRegnCntry,
  CndnContrPrcgDetnRlvnceCat,
  CndnContrWorkerCostCenter,
  CndnContrWorkerSettlmtCat,
  DataController,
  CndnContrSemanticCode,
  CndnContrProcessCategory,
  CndnContrPartnerCat,
  CndnContrSettlmtType
FROM R_ConditionContract
LEFT OUTER JOIN C_CndnContrSettlmtCalDP AS _CndnContrSettlmtCal ON ConditionContract = _CndnContrSettlmtCal.ConditionContract  -- association [0..*]
LEFT OUTER JOIN C_CndnContrBusVolSelCriteriaDP AS _CndnContrBusVolSelCriteria ON ConditionContract = _CndnContrBusVolSelCriteria.ConditionContract  -- association [0..*]
LEFT OUTER JOIN E_ConditionContract AS _Extension ON ConditionContract = _Extension.ConditionContract  -- association [1..1]
;

Learn More