A_CndnContrBusVolSelCriteria

DDL: A_CNDNCONTRBUSVOLSELCRITERIA Type: view_entity CONSUMPTION Package: WCB_API_A2A_CC_SRV
76 Fields 1 Data Sources 1 OData Services

Business Volume Selection Criteria

A_CndnContrBusVolSelCriteria is a Consumption CDS View that provides data about "Business Volume Selection Criteria" in SAP S/4HANA. It reads from 1 data source (R_CndnContrBusVolSelCriteriaTP) and exposes 76 fields with key fields ConditionContract, CndnContrBusVolUUID. It is exposed through 1 OData service (API_CONDITION_CONTRACT). Part of development package WCB_API_A2A_CC_SRV.

Data Sources (1)

SourceAliasJoin Type
R_CndnContrBusVolSelCriteriaTP R_CndnContrBusVolSelCriteriaTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Business Volume Selection Criteria view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

OData Services (1)

ServiceBindingVersionContractRelease
API_CONDITION_CONTRACT API_CONDITION_CONTRACT V4 C2 C1

Fields (76)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract ConditionContract Condition Contract
KEY CndnContrBusVolUUID CndnContrBusVolUUID
BusVolFieldCombnType BusVolFieldCombnType
BusVolFldCombnGroup BusVolFldCombnGroup
CndnContrBusVolSign CndnContrBusVolSign
BusVolSelectionGroup BusVolSelectionGroup
CndnContrBusVolValidFrom CndnContrBusVolValidFrom
CndnContrBusVolValidTo CndnContrBusVolValidTo
Supplier Supplier Supplier
Customer Customer Sold-to Party
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
SupplierSubrange SupplierSubrange Suppl. Subrange
ProductGroup ProductGroup Product Sold Group
Product Product Product Sold
ProductType ProductType Product Type Group
CustomerHierarchy CustomerHierarchy
ProductHierarchy ProductHierarchy Prod.hierarchy
ProdUnivHierarchyNode ProdUnivHierarchyNode
SalesSpcfcProductGroup1 SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 SalesSpcfcProductGroup5 Sales-Specific Product Group 5
SalesOrderReason SalesOrderReason
Manufacturer Manufacturer Manufacturer
RoyaltyRecipient RoyaltyRecipient
CommissionRecipient CommissionRecipient
WorkerCommissionRecipient WorkerCommissionRecipient
ShipToParty ShipToParty Ship-To Party (obsolete)
PayerParty PayerParty Payer
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
CustomerGroup CustomerGroup Customer Group
AdditionalCustomerGroup1 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 AdditionalCustomerGroup5 Customer Grp 5
CustomerConditionGroup1 CustomerConditionGroup1 Condition grp 1
CustomerConditionGroup2 CustomerConditionGroup2 Condition grp 2
CustomerConditionGroup3 CustomerConditionGroup3 Condition grp 3
CustomerConditionGroup4 CustomerConditionGroup4 Condition grp 4
CustomerConditionGroup5 CustomerConditionGroup5 Condition grp 5
Country Country Venue: Ctry/Reg
Region Region Venue Region
ProductCommissionGroup ProductCommissionGroup Commission Grp
PricingReferenceProduct PricingReferenceProduct X-distr.-chain PRM
SoldProduct SoldProduct Product Sold
SalesDistrict SalesDistrict Sales District
ProductPricingGroup ProductPricingGroup
SalesVolumeRebateGroup SalesVolumeRebateGroup Volume Rebate Group
BizVolSelCndnContrProcVar BizVolSelCndnContrProcVar
BizVolSelConditionContract BizVolSelConditionContract
CndnContrSuplrInvcDlvCostCat CndnContrSuplrInvcDlvCostCat
ProductConditionGroup ProductConditionGroup
CustomerHierarchyRootNode CustomerHierarchyRootNode
CustomerHierarchyNodeID CustomerHierarchyNodeID
CustomerHierarchyNodeType CustomerHierarchyNodeType
GLAccount GLAccount General Ledger
CndnContrSourceBusVolUUID CndnContrSourceBusVolUUID
_CommissionRecipient _CommissionRecipient
_Customer _Customer
_CustomerHierarchy _CustomerHierarchy
_Manufacturer _Manufacturer
_RoyaltyRecipient _RoyaltyRecipient
_Supplier _Supplier
_WorkerCommissionRecipient _WorkerCommissionRecipient

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 A_CndnContrBusVolSelCriteria.
-- 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 A_CndnContrBusVolSelCriteria AS
SELECT
  ConditionContract,
  CndnContrBusVolUUID,
  BusVolFieldCombnType,
  BusVolFldCombnGroup,
  CndnContrBusVolSign,
  BusVolSelectionGroup,
  CndnContrBusVolValidFrom,
  CndnContrBusVolValidTo,
  Supplier,
  Customer,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  CompanyCode,
  Plant,
  SupplierSubrange,
  ProductGroup,
  Product,
  ProductType,
  CustomerHierarchy,
  ProductHierarchy,
  ProdUnivHierarchyNode,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  SalesOrderReason,
  Manufacturer,
  RoyaltyRecipient,
  CommissionRecipient,
  WorkerCommissionRecipient,
  ShipToParty,
  PayerParty,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  Country,
  Region,
  ProductCommissionGroup,
  PricingReferenceProduct,
  SoldProduct,
  SalesDistrict,
  ProductPricingGroup,
  SalesVolumeRebateGroup,
  BizVolSelCndnContrProcVar,
  BizVolSelConditionContract,
  CndnContrSuplrInvcDlvCostCat,
  ProductConditionGroup,
  CustomerHierarchyRootNode,
  CustomerHierarchyNodeID,
  CustomerHierarchyNodeType,
  GLAccount,
  CndnContrSourceBusVolUUID
FROM R_CndnContrBusVolSelCriteriaTP
;

Learn More