C_CndnContrBusVolSelCriteriaDP

DDL: C_CNDNCONTRBUSVOLSELCRITERIADP Type: view_entity CONSUMPTION

Business Volume Selection Criteria

C_CndnContrBusVolSelCriteriaDP (Consumption)

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

BusVolSelectionCriteria · Sales

C_CndnContrBusVolSelCriteriaDP is a Consumption CDS View that provides data about "Business Volume Selection Criteria" in SAP S/4HANA. It reads from 1 data source (R_CndnContrBusVolSelCriteria) and exposes 51 fields with key fields ConditionContract, CndnContrBusVolUUID. It has 1 association 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_CndnContrBusVolSelCriteria BusVolSelectionCriteria from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_ConditionContractDP _ConditionContract $projection.ConditionContract = _ConditionContract.ConditionContract

Annotations (12)

NameValueLevelField
EndUserText.label Business Volume Selection Criteria view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.technicalName CBVSCDP view
Analytics.dataExtraction.enabled true view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name BusVolSelectionCriteria view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract Condition Contract
KEY CndnContrBusVolUUID CndnContrBusVolUUID Business Volume Selection UUID
BusVolFieldCombnType BusVolFieldCombnType Field Combination for Business Volume Selection
BusVolFldCombnGroup BusVolFldCombnGroup Field Combination Group for Business Volume Selection in BVB
CndnContrBusVolSign CndnContrBusVolSign Status Including / Excluding
BusVolSelectionGroup BusVolSelectionGroup Selection Group
CndnContrSupplier CndnContrSupplier Supplier for Business Volume Selection
CndnContrCustomer CndnContrCustomer Customer for Business Volume Selection
CndnContrBusVolValidFrom CndnContrBusVolValidFrom Valid from
CndnContrBusVolValidTo CndnContrBusVolValidTo Valid to
Supplier Supplier Account Number of Supplier
Customer Customer Customer Number
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
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
Plant Plant Valuation Area
SupplierSubrange SupplierSubrange Supplier Subrange
ProductGroup ProductGroup Product Sold Group
Product Product Product Number
ProductType ProductType Product Type Group
CustomerHierarchy CustomerHierarchy Customer Hierarchy
ProductHierarchy ProductHierarchy Product Hierarchy
SalesOrderReason SalesOrderReason Sales Document Reason
Manufacturer Manufacturer Number of a Manufacturer
RoyaltyRecipient RoyaltyRecipient Royalties Recipient
CommissionRecipient CommissionRecipient Commission Recipient
ShipToParty ShipToParty Ship-To Party (obsolete)
PayerParty PayerParty Payer
ServiceDocumentType ServiceDocumentType Service Document Type
ServiceDocument ServiceDocument Service Document ID
ServiceDocumentItem ServiceDocumentItem Service Document Item ID
CustomerGroup CustomerGroup Customer Group
Country Country Country/Region Key
Region Region Region (State, Province, County)
ProductCommissionGroup ProductCommissionGroup Commission Group
PricingReferenceProduct PricingReferenceProduct Pricing Reference Material
SalesDistrict SalesDistrict Sales District
ProductPricingGroup ProductPricingGroup Product Price Group
SalesVolumeRebateGroup SalesVolumeRebateGroup Sales Volume Rebate Group
BizVolSelCndnContrProcVar BizVolSelCndnContrProcVar Cndn Contr Process Variant of Business Volume Selection
BizVolSelConditionContract BizVolSelConditionContract Condition Contract of Business Volume Selection
WBSElementInternalID WBSElementInternalID Work Breakdown Structure Element (WBS Element) not converted
CndnContrSuplrInvcDlvCostCat CndnContrSuplrInvcDlvCostCat Item Category of Supplier Invoice
CndnContrSemanticCode CndnContrSemanticCode Semantic Type
CndnContrSourceBusVolUUID CndnContrSourceBusVolUUID Source Business Volume Selection UUID
_ConditionContract _ConditionContract

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_CndnContrBusVolSelCriteriaDP.
-- 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_CndnContrBusVolSelCriteriaDP AS
SELECT
  ConditionContract,
  CndnContrBusVolUUID,
  BusVolFieldCombnType,
  BusVolFldCombnGroup,
  CndnContrBusVolSign,
  BusVolSelectionGroup,
  CndnContrSupplier,
  CndnContrCustomer,
  CndnContrBusVolValidFrom,
  CndnContrBusVolValidTo,
  Supplier,
  Customer,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  Plant,
  SupplierSubrange,
  ProductGroup,
  Product,
  ProductType,
  CustomerHierarchy,
  ProductHierarchy,
  SalesOrderReason,
  Manufacturer,
  RoyaltyRecipient,
  CommissionRecipient,
  ShipToParty,
  PayerParty,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  CustomerGroup,
  Country,
  Region,
  ProductCommissionGroup,
  PricingReferenceProduct,
  SalesDistrict,
  ProductPricingGroup,
  SalesVolumeRebateGroup,
  BizVolSelCndnContrProcVar,
  BizVolSelConditionContract,
  WBSElementInternalID,
  CndnContrSuplrInvcDlvCostCat,
  CndnContrSemanticCode,
  CndnContrSourceBusVolUUID
FROM R_CndnContrBusVolSelCriteria AS BusVolSelectionCriteria
LEFT OUTER JOIN C_ConditionContractDP AS _ConditionContract ON ConditionContract = _ConditionContract.ConditionContract  -- association [1..1]
;