R_CndnContrBusVolSelCriteria

DDL: R_CNDNCONTRBUSVOLSELCRITERIA Type: view_entity COMPOSITE Package: WCB_CC_PERS
127 Fields 2 Data Sources 4 Associations

Business Volume Selection Criteria

R_CndnContrBusVolSelCriteria is a Composite CDS View that provides data about "Business Volume Selection Criteria" in SAP S/4HANA. It reads from 2 data sources (R_CndnDocBusVolSelCriteria, R_ConditionContract) and exposes 127 fields with key fields ConditionContract, CndnContrBusVolUUID. It has 4 associations to related views. Part of development package WCB_CC_PERS.

Data Sources (2)

SourceAliasJoin Type
R_CndnDocBusVolSelCriteria R_CndnDocBusVolSelCriteria from
R_ConditionContract R_ConditionContract inner

Associations (4)

CardinalityTargetAliasCondition
[1..1] R_ConditionContract _ConditionContract $projection.ConditionContract = _ConditionContract.ConditionContract
[0..1] I_CndnContrBusVolSign _CndnContrBusVolSign $projection.CndnContrBusVolSign = _CndnContrBusVolSign.CndnContrBusVolSign
[0..1] I_Supplier _CndnContrSupplier $projection.CndnContrSupplier = _CndnContrSupplier.Supplier
[0..1] I_Customer _CndnContrCustomer $projection.CndnContrCustomer = _CndnContrCustomer.Customer

Annotations (11)

NameValueLevelField
EndUserText.label Business Volume Selection Criteria view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey CndnContrBusVolUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Analytics.technicalName RCCBUSVOLSELCRI view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (127)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract
KEY CndnContrBusVolUUID R_CndnDocBusVolSelCriteria CndnDocBusinessVolumeUUID
BusVolFieldCombnType R_CndnDocBusVolSelCriteria BusVolFieldCombnType Fld Combination
BusVolFldCombnGroup R_CndnDocBusVolSelCriteria BusVolFldCombnGroup Group
CndnContrBusVolSign R_CndnDocBusVolSelCriteria BusinessVolumeFieldCombnSign Include / Exclude
BusVolSelectionGroup R_CndnDocBusVolSelCriteria BusVolSelectionGroup Selection Group
CndnContrSupplier R_CndnDocBusVolSelCriteria ConditionDocumentSupplier
CndnContrCustomer R_CndnDocBusVolSelCriteria ConditionDocumentCustomer
CndnContrBusVolValidFrom R_CndnDocBusVolSelCriteria CndnDocBusVolValidFromDate Validity Start Time
CndnContrBusVolValidTo R_CndnDocBusVolSelCriteria CndnDocBusVolValidToDate Validity End Time
Supplier R_CndnDocBusVolSelCriteria Supplier Supplier
Customer R_CndnDocBusVolSelCriteria Customer Sold-to Party
CompanyCode R_CndnDocBusVolSelCriteria CompanyCode Receiver Company Code
PurchasingOrganization R_CndnDocBusVolSelCriteria PurchasingOrganization Purchasing Organization
PurchasingGroup R_CndnDocBusVolSelCriteria PurchasingGroup Purchasing Group
SalesOrganization R_CndnDocBusVolSelCriteria SalesOrganization Sales Organization
DistributionChannel R_CndnDocBusVolSelCriteria DistributionChannel RefDistCh-Cust/Mat.
Division R_CndnDocBusVolSelCriteria Division Internal Division ID
SalesOffice R_CndnDocBusVolSelCriteria SalesOffice Sales Office
SalesGroup R_CndnDocBusVolSelCriteria SalesGroup Sales Group
Plant R_CndnDocBusVolSelCriteria Plant Valuation Area
SupplierSubrange R_CndnDocBusVolSelCriteria SupplierSubrange Suppl. Subrange
ProductGroup R_CndnDocBusVolSelCriteria ProductGroup Product Sold Group
Product R_CndnDocBusVolSelCriteria Product Product Sold
ProductType R_CndnDocBusVolSelCriteria ProductType Product Type Group
CustomerHierarchy R_CndnDocBusVolSelCriteria CustomerHierarchy Customer Hierarchy
ProductHierarchy R_CndnDocBusVolSelCriteria ProductHierarchy Prod.hierarchy
ProdUnivHierarchyNode R_CndnDocBusVolSelCriteria ProdUnivHierarchyNode Prod. Hierarchy
SalesSpcfcProductGroup1 R_CndnDocBusVolSelCriteria SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 R_CndnDocBusVolSelCriteria SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 R_CndnDocBusVolSelCriteria SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 R_CndnDocBusVolSelCriteria SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 R_CndnDocBusVolSelCriteria SalesSpcfcProductGroup5 Sales-Specific Product Group 5
SalesOrderReason R_CndnDocBusVolSelCriteria SalesOrderReason Sales Document Reason
Manufacturer R_CndnDocBusVolSelCriteria Manufacturer Manufacturer
RoyaltyRecipient R_CndnDocBusVolSelCriteria RoyaltyRecipient Royalties Recipient
CommissionRecipient R_CndnDocBusVolSelCriteria CommissionRecipient Commission Recipient
WorkerCommissionRecipient R_CndnDocBusVolSelCriteria WorkerCommissionRecipient
ShipToParty R_CndnDocBusVolSelCriteria ShipToParty Ship-To Party (obsolete)
PayerParty R_CndnDocBusVolSelCriteria PayerParty Payer
CndnContrCustomerList R_CndnDocBusVolSelCriteria ConditionDocumentCustomerList Customer List
CndnContrSupplierList R_CndnDocBusVolSelCriteria ConditionDocumentSupplierList Supplier List
CndnContrPlantList R_CndnDocBusVolSelCriteria ConditionDocumentPlantList Plant List
CndnContrBusVolList R_CndnDocBusVolSelCriteria CndnDocBusinessVolumeList Reference CC BV
ServiceDocumentType R_CndnDocBusVolSelCriteria ServiceDocumentType Transaction Type
ServiceDocument R_CndnDocBusVolSelCriteria ServiceDocument Transaction ID
ServiceDocumentItem R_CndnDocBusVolSelCriteria ServiceDocumentItem Service Document
CustomerGroup R_CndnDocBusVolSelCriteria CustomerGroup Customer Group
AdditionalCustomerGroup1 R_CndnDocBusVolSelCriteria AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 R_CndnDocBusVolSelCriteria AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 R_CndnDocBusVolSelCriteria AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 R_CndnDocBusVolSelCriteria AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 R_CndnDocBusVolSelCriteria AdditionalCustomerGroup5 Customer Grp 5
CustomerConditionGroup1 R_CndnDocBusVolSelCriteria CustomerConditionGroup1 Condition grp 1
CustomerConditionGroup2 R_CndnDocBusVolSelCriteria CustomerConditionGroup2 Condition grp 2
CustomerConditionGroup3 R_CndnDocBusVolSelCriteria CustomerConditionGroup3 Condition grp 3
CustomerConditionGroup4 R_CndnDocBusVolSelCriteria CustomerConditionGroup4 Condition grp 4
CustomerConditionGroup5 R_CndnDocBusVolSelCriteria CustomerConditionGroup5 Condition grp 5
Country R_CndnDocBusVolSelCriteria Country Venue: Ctry/Reg
Region R_CndnDocBusVolSelCriteria Region Venue Region
ProductCommissionGroup R_CndnDocBusVolSelCriteria ProductCommissionGroup Commission Grp
PricingReferenceProduct R_CndnDocBusVolSelCriteria PricingReferenceProduct X-distr.-chain PRM
SoldProduct R_CndnDocBusVolSelCriteria SoldProduct Product Sold
SalesDistrict R_CndnDocBusVolSelCriteria SalesDistrict Sales District
ProductPricingGroup R_CndnDocBusVolSelCriteria ProductPricingGroup
SalesVolumeRebateGroup R_CndnDocBusVolSelCriteria SalesVolumeRebateGroup Volume Rebate Group
BizVolSelCndnContrProcVar R_CndnDocBusVolSelCriteria BizVolSelCndnContrProcVar
BizVolSelConditionContract R_CndnDocBusVolSelCriteria BizVolSelConditionContract
WBSElementInternalID R_CndnDocBusVolSelCriteria WBSElementInternalID WBS Internal ID
CndnContrSuplrInvcDlvCostCat R_CndnDocBusVolSelCriteria CndnDocSuplrInvcDlvCostCat Item Category
ProductConditionGroup R_CndnDocBusVolSelCriteria ProductConditionGroup Condition Group
CustomerHierarchyRootNode R_CndnDocBusVolSelCriteria CustomerHierarchyRootNode CH Rt. Nd. ID
CustomerHierarchyNodeID R_CndnDocBusVolSelCriteria CustomerHierarchyNodeID Cust. Hier. Node ID
CustomerHierarchyNodeType R_CndnDocBusVolSelCriteria CustomerHierarchyNodeType Cust. Hier. Nd. Type
GLAccount R_CndnDocBusVolSelCriteria GLAccount General Ledger
CndnContrSemanticCode R_CndnDocBusVolSelCriteria CndnDocSemanticCode Semantic Type
CndnContrSourceBusVolUUID R_CndnDocBusVolSelCriteria CndnDocSrceBusinessVolumeUUID
_ConditionContract _ConditionContract
_BusVolFieldCombnType R_CndnDocBusVolSelCriteria _BusVolFieldCombnType
_CndnContrBusVolSign _CndnContrBusVolSign
_BusVolSelectionGroup R_CndnDocBusVolSelCriteria _BusVolSelectionGroup
_Supplier R_CndnDocBusVolSelCriteria _Supplier
_Customer R_CndnDocBusVolSelCriteria _Customer
_CompanyCode R_CndnDocBusVolSelCriteria _CompanyCode
_PurchasingOrganization R_CndnDocBusVolSelCriteria _PurchasingOrganization
_PurchasingGroup R_CndnDocBusVolSelCriteria _PurchasingGroup
_SalesOrganization R_CndnDocBusVolSelCriteria _SalesOrganization
_DistributionChannel R_CndnDocBusVolSelCriteria _DistributionChannel
_Division R_CndnDocBusVolSelCriteria _Division
_SalesOffice R_CndnDocBusVolSelCriteria _SalesOffice
_SalesGroup R_CndnDocBusVolSelCriteria _SalesGroup
_Plant R_CndnDocBusVolSelCriteria _Plant
_Product R_CndnDocBusVolSelCriteria _Product
_ProductHierarchy R_CndnDocBusVolSelCriteria _ProductHierarchy
_CustomerHierarchy R_CndnDocBusVolSelCriteria _CustomerHierarchy
_SalesSpcfcProductGroup1 R_CndnDocBusVolSelCriteria _SalesSpcfcProductGroup1
_SalesSpcfcProductGroup2 R_CndnDocBusVolSelCriteria _SalesSpcfcProductGroup2
_SalesSpcfcProductGroup3 R_CndnDocBusVolSelCriteria _SalesSpcfcProductGroup3
_SalesSpcfcProductGroup4 R_CndnDocBusVolSelCriteria _SalesSpcfcProductGroup4
_SalesSpcfcProductGroup5 R_CndnDocBusVolSelCriteria _SalesSpcfcProductGroup5
_SalesOrderReason R_CndnDocBusVolSelCriteria _SalesOrderReason
_Manufacturer R_CndnDocBusVolSelCriteria _Manufacturer
_RoyaltyRecipient R_CndnDocBusVolSelCriteria _RoyaltyRecipient
_CommissionRecipient R_CndnDocBusVolSelCriteria _CommissionRecipient
_WorkerCommissionRecipient R_CndnDocBusVolSelCriteria _WorkerCommissionRecipient
_ShipToParty R_CndnDocBusVolSelCriteria _ShipToParty
_PayerParty R_CndnDocBusVolSelCriteria _PayerParty
_CndnContrSupplier _CndnContrSupplier
_CndnContrCustomer _CndnContrCustomer
_ServiceDocumentType R_CndnDocBusVolSelCriteria _ServiceDocumentType
_CustomerGroup R_CndnDocBusVolSelCriteria _CustomerGroup
_AdditionalCustomerGroup1 R_CndnDocBusVolSelCriteria _AdditionalCustomerGroup1
_AdditionalCustomerGroup2 R_CndnDocBusVolSelCriteria _AdditionalCustomerGroup2
_AdditionalCustomerGroup3 R_CndnDocBusVolSelCriteria _AdditionalCustomerGroup3
_AdditionalCustomerGroup4 R_CndnDocBusVolSelCriteria _AdditionalCustomerGroup4
_AdditionalCustomerGroup5 R_CndnDocBusVolSelCriteria _AdditionalCustomerGroup5
_Country R_CndnDocBusVolSelCriteria _Country
_Region R_CndnDocBusVolSelCriteria _Region
_ProductCommissionGroup R_CndnDocBusVolSelCriteria _ProductCommissionGroup
_PricingReferenceProduct R_CndnDocBusVolSelCriteria _PricingReferenceProduct
_SoldProduct R_CndnDocBusVolSelCriteria _SoldProduct
_SalesDistrict R_CndnDocBusVolSelCriteria _SalesDistrict
_ProductPricingGroup R_CndnDocBusVolSelCriteria _ProductPricingGroup
_BizVolSelCndnContrProcVar R_CndnDocBusVolSelCriteria _BizVolSelCndnContrProcVar
_BizVolSelConditionContract R_CndnDocBusVolSelCriteria _BizVolSelConditionContract
_WBSElementBasicData R_CndnDocBusVolSelCriteria _WBSElementBasicData
_CndnContrSuplrInvcDlvCostCat R_CndnDocBusVolSelCriteria _CndnDocSuplrInvcDlvCostCat

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 R_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 R_CndnContrBusVolSelCriteria AS
SELECT
  cast( R_CndnDocBusVolSelCriteria.ConditionDocument as wcb_coco_num preserving type ) AS ConditionContract,
  R_CndnDocBusVolSelCriteria.CndnDocBusinessVolumeUUID AS CndnContrBusVolUUID,
  R_CndnDocBusVolSelCriteria.BusVolFieldCombnType AS BusVolFieldCombnType,
  R_CndnDocBusVolSelCriteria.BusVolFldCombnGroup AS BusVolFldCombnGroup,
  R_CndnDocBusVolSelCriteria.BusinessVolumeFieldCombnSign AS CndnContrBusVolSign,
  R_CndnDocBusVolSelCriteria.BusVolSelectionGroup AS BusVolSelectionGroup,
  R_CndnDocBusVolSelCriteria.ConditionDocumentSupplier AS CndnContrSupplier,
  R_CndnDocBusVolSelCriteria.ConditionDocumentCustomer AS CndnContrCustomer,
  R_CndnDocBusVolSelCriteria.CndnDocBusVolValidFromDate AS CndnContrBusVolValidFrom,
  R_CndnDocBusVolSelCriteria.CndnDocBusVolValidToDate AS CndnContrBusVolValidTo,
  R_CndnDocBusVolSelCriteria.Supplier AS Supplier,
  R_CndnDocBusVolSelCriteria.Customer AS Customer,
  R_CndnDocBusVolSelCriteria.CompanyCode AS CompanyCode,
  R_CndnDocBusVolSelCriteria.PurchasingOrganization AS PurchasingOrganization,
  R_CndnDocBusVolSelCriteria.PurchasingGroup AS PurchasingGroup,
  R_CndnDocBusVolSelCriteria.SalesOrganization AS SalesOrganization,
  R_CndnDocBusVolSelCriteria.DistributionChannel AS DistributionChannel,
  R_CndnDocBusVolSelCriteria.Division AS Division,
  R_CndnDocBusVolSelCriteria.SalesOffice AS SalesOffice,
  R_CndnDocBusVolSelCriteria.SalesGroup AS SalesGroup,
  R_CndnDocBusVolSelCriteria.Plant AS Plant,
  R_CndnDocBusVolSelCriteria.SupplierSubrange AS SupplierSubrange,
  R_CndnDocBusVolSelCriteria.ProductGroup AS ProductGroup,
  R_CndnDocBusVolSelCriteria.Product AS Product,
  R_CndnDocBusVolSelCriteria.ProductType AS ProductType,
  R_CndnDocBusVolSelCriteria.CustomerHierarchy AS CustomerHierarchy,
  R_CndnDocBusVolSelCriteria.ProductHierarchy AS ProductHierarchy,
  R_CndnDocBusVolSelCriteria.ProdUnivHierarchyNode AS ProdUnivHierarchyNode,
  R_CndnDocBusVolSelCriteria.SalesSpcfcProductGroup1 AS SalesSpcfcProductGroup1,
  R_CndnDocBusVolSelCriteria.SalesSpcfcProductGroup2 AS SalesSpcfcProductGroup2,
  R_CndnDocBusVolSelCriteria.SalesSpcfcProductGroup3 AS SalesSpcfcProductGroup3,
  R_CndnDocBusVolSelCriteria.SalesSpcfcProductGroup4 AS SalesSpcfcProductGroup4,
  R_CndnDocBusVolSelCriteria.SalesSpcfcProductGroup5 AS SalesSpcfcProductGroup5,
  R_CndnDocBusVolSelCriteria.SalesOrderReason AS SalesOrderReason,
  R_CndnDocBusVolSelCriteria.Manufacturer AS Manufacturer,
  R_CndnDocBusVolSelCriteria.RoyaltyRecipient AS RoyaltyRecipient,
  R_CndnDocBusVolSelCriteria.CommissionRecipient AS CommissionRecipient,
  R_CndnDocBusVolSelCriteria.WorkerCommissionRecipient AS WorkerCommissionRecipient,
  R_CndnDocBusVolSelCriteria.ShipToParty AS ShipToParty,
  R_CndnDocBusVolSelCriteria.PayerParty AS PayerParty,
  R_CndnDocBusVolSelCriteria.ConditionDocumentCustomerList AS CndnContrCustomerList,
  R_CndnDocBusVolSelCriteria.ConditionDocumentSupplierList AS CndnContrSupplierList,
  R_CndnDocBusVolSelCriteria.ConditionDocumentPlantList AS CndnContrPlantList,
  R_CndnDocBusVolSelCriteria.CndnDocBusinessVolumeList AS CndnContrBusVolList,
  R_CndnDocBusVolSelCriteria.ServiceDocumentType AS ServiceDocumentType,
  R_CndnDocBusVolSelCriteria.ServiceDocument AS ServiceDocument,
  R_CndnDocBusVolSelCriteria.ServiceDocumentItem AS ServiceDocumentItem,
  R_CndnDocBusVolSelCriteria.CustomerGroup AS CustomerGroup,
  R_CndnDocBusVolSelCriteria.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  R_CndnDocBusVolSelCriteria.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  R_CndnDocBusVolSelCriteria.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  R_CndnDocBusVolSelCriteria.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  R_CndnDocBusVolSelCriteria.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  R_CndnDocBusVolSelCriteria.CustomerConditionGroup1 AS CustomerConditionGroup1,
  R_CndnDocBusVolSelCriteria.CustomerConditionGroup2 AS CustomerConditionGroup2,
  R_CndnDocBusVolSelCriteria.CustomerConditionGroup3 AS CustomerConditionGroup3,
  R_CndnDocBusVolSelCriteria.CustomerConditionGroup4 AS CustomerConditionGroup4,
  R_CndnDocBusVolSelCriteria.CustomerConditionGroup5 AS CustomerConditionGroup5,
  R_CndnDocBusVolSelCriteria.Country AS Country,
  R_CndnDocBusVolSelCriteria.Region AS Region,
  R_CndnDocBusVolSelCriteria.ProductCommissionGroup AS ProductCommissionGroup,
  R_CndnDocBusVolSelCriteria.PricingReferenceProduct AS PricingReferenceProduct,
  R_CndnDocBusVolSelCriteria.SoldProduct AS SoldProduct,
  R_CndnDocBusVolSelCriteria.SalesDistrict AS SalesDistrict,
  R_CndnDocBusVolSelCriteria.ProductPricingGroup AS ProductPricingGroup,
  R_CndnDocBusVolSelCriteria.SalesVolumeRebateGroup AS SalesVolumeRebateGroup,
  R_CndnDocBusVolSelCriteria.BizVolSelCndnContrProcVar AS BizVolSelCndnContrProcVar,
  R_CndnDocBusVolSelCriteria.BizVolSelConditionContract AS BizVolSelConditionContract,
  R_CndnDocBusVolSelCriteria.WBSElementInternalID AS WBSElementInternalID,
  R_CndnDocBusVolSelCriteria.CndnDocSuplrInvcDlvCostCat AS CndnContrSuplrInvcDlvCostCat,
  R_CndnDocBusVolSelCriteria.ProductConditionGroup AS ProductConditionGroup,
  R_CndnDocBusVolSelCriteria.CustomerHierarchyRootNode AS CustomerHierarchyRootNode,
  R_CndnDocBusVolSelCriteria.CustomerHierarchyNodeID AS CustomerHierarchyNodeID,
  R_CndnDocBusVolSelCriteria.CustomerHierarchyNodeType AS CustomerHierarchyNodeType,
  R_CndnDocBusVolSelCriteria.GLAccount AS GLAccount,
  R_CndnDocBusVolSelCriteria.CndnDocSemanticCode AS CndnContrSemanticCode,
  R_CndnDocBusVolSelCriteria.CndnDocSrceBusinessVolumeUUID AS CndnContrSourceBusVolUUID,
  R_CndnDocBusVolSelCriteria._BusVolFieldCombnType AS _BusVolFieldCombnType,
  R_CndnDocBusVolSelCriteria._BusVolSelectionGroup AS _BusVolSelectionGroup,
  R_CndnDocBusVolSelCriteria._Supplier AS _Supplier,
  R_CndnDocBusVolSelCriteria._Customer AS _Customer,
  R_CndnDocBusVolSelCriteria._CompanyCode AS _CompanyCode,
  R_CndnDocBusVolSelCriteria._PurchasingOrganization AS _PurchasingOrganization,
  R_CndnDocBusVolSelCriteria._PurchasingGroup AS _PurchasingGroup,
  R_CndnDocBusVolSelCriteria._SalesOrganization AS _SalesOrganization,
  R_CndnDocBusVolSelCriteria._DistributionChannel AS _DistributionChannel,
  R_CndnDocBusVolSelCriteria._Division AS _Division,
  R_CndnDocBusVolSelCriteria._SalesOffice AS _SalesOffice,
  R_CndnDocBusVolSelCriteria._SalesGroup AS _SalesGroup,
  R_CndnDocBusVolSelCriteria._Plant AS _Plant,
  R_CndnDocBusVolSelCriteria._Product AS _Product,
  R_CndnDocBusVolSelCriteria._ProductHierarchy AS _ProductHierarchy,
  R_CndnDocBusVolSelCriteria._CustomerHierarchy AS _CustomerHierarchy,
  R_CndnDocBusVolSelCriteria._SalesSpcfcProductGroup1 AS _SalesSpcfcProductGroup1,
  R_CndnDocBusVolSelCriteria._SalesSpcfcProductGroup2 AS _SalesSpcfcProductGroup2,
  R_CndnDocBusVolSelCriteria._SalesSpcfcProductGroup3 AS _SalesSpcfcProductGroup3,
  R_CndnDocBusVolSelCriteria._SalesSpcfcProductGroup4 AS _SalesSpcfcProductGroup4,
  R_CndnDocBusVolSelCriteria._SalesSpcfcProductGroup5 AS _SalesSpcfcProductGroup5,
  R_CndnDocBusVolSelCriteria._SalesOrderReason AS _SalesOrderReason,
  R_CndnDocBusVolSelCriteria._Manufacturer AS _Manufacturer,
  R_CndnDocBusVolSelCriteria._RoyaltyRecipient AS _RoyaltyRecipient,
  R_CndnDocBusVolSelCriteria._CommissionRecipient AS _CommissionRecipient,
  R_CndnDocBusVolSelCriteria._WorkerCommissionRecipient AS _WorkerCommissionRecipient,
  R_CndnDocBusVolSelCriteria._ShipToParty AS _ShipToParty,
  R_CndnDocBusVolSelCriteria._PayerParty AS _PayerParty,
  R_CndnDocBusVolSelCriteria._ServiceDocumentType AS _ServiceDocumentType,
  R_CndnDocBusVolSelCriteria._CustomerGroup AS _CustomerGroup,
  R_CndnDocBusVolSelCriteria._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  R_CndnDocBusVolSelCriteria._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  R_CndnDocBusVolSelCriteria._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  R_CndnDocBusVolSelCriteria._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  R_CndnDocBusVolSelCriteria._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  R_CndnDocBusVolSelCriteria._Country AS _Country,
  R_CndnDocBusVolSelCriteria._Region AS _Region,
  R_CndnDocBusVolSelCriteria._ProductCommissionGroup AS _ProductCommissionGroup,
  R_CndnDocBusVolSelCriteria._PricingReferenceProduct AS _PricingReferenceProduct,
  R_CndnDocBusVolSelCriteria._SoldProduct AS _SoldProduct,
  R_CndnDocBusVolSelCriteria._SalesDistrict AS _SalesDistrict,
  R_CndnDocBusVolSelCriteria._ProductPricingGroup AS _ProductPricingGroup,
  R_CndnDocBusVolSelCriteria._BizVolSelCndnContrProcVar AS _BizVolSelCndnContrProcVar,
  R_CndnDocBusVolSelCriteria._BizVolSelConditionContract AS _BizVolSelConditionContract,
  R_CndnDocBusVolSelCriteria._WBSElementBasicData AS _WBSElementBasicData,
  R_CndnDocBusVolSelCriteria._CndnDocSuplrInvcDlvCostCat AS _CndnContrSuplrInvcDlvCostCat
FROM R_CndnDocBusVolSelCriteria
INNER JOIN R_ConditionContract ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_ConditionContract AS _ConditionContract ON ConditionContract = _ConditionContract.ConditionContract  -- association [1..1]
LEFT OUTER JOIN I_CndnContrBusVolSign AS _CndnContrBusVolSign ON CndnContrBusVolSign = _CndnContrBusVolSign.CndnContrBusVolSign  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _CndnContrSupplier ON CndnContrSupplier = _CndnContrSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CndnContrCustomer ON CndnContrCustomer = _CndnContrCustomer.Customer  -- association [0..1]
;

Learn More