R_CndnDocBusVolSelCriteria

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_CndnDocBusVolSelCriteria.
-- 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_CndnDocBusVolSelCriteria AS
SELECT
  cast( num as wcb_condition_document preserving type ) AS ConditionDocument,
  cast( guid as wb2_business_volume_uuid preserving type ) AS CndnDocBusinessVolumeUUID,
  fieldcomb AS BusVolFieldCombnType,
  fc_group_bvb AS BusVolFldCombnGroup,
  incl_excl AS BusinessVolumeFieldCombnSign,
  selection_group AS BusVolSelectionGroup,
  cast( x_lifnr as wb2_bvb_lifnr preserving type ) AS ConditionDocumentSupplier,
  cast( x_kunnr as wb2_bvb_kunnr preserving type ) AS ConditionDocumentCustomer,
  valid_from AS CndnDocBusVolValidFromDate,
  valid_to AS CndnDocBusVolValidToDate,
  lifnr AS Supplier,
  kunnr AS Customer,
  bukrs AS CompanyCode,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  vkbur AS SalesOffice,
  vkgrp AS SalesGroup,
  werks AS Plant,
  ltsnr AS SupplierSubrange,
  cast( matkl as productgroup preserving type ) AS ProductGroup,
  cast( matnr as productnumber preserving type ) AS Product,
  cast( mtart as producttype preserving type ) AS ProductType,
  kunhier AS CustomerHierarchy,
  prodh AS ProductHierarchy,
  prod_hier_node AS ProdUnivHierarchyNode,
  cast( mvgr1 as wlf_salesspcfcproductgroup1 preserving type ) AS SalesSpcfcProductGroup1,
  cast( mvgr2 as wlf_salesspcfcproductgroup2 preserving type ) AS SalesSpcfcProductGroup2,
  cast( mvgr3 as wlf_salesspcfcproductgroup3 preserving type ) AS SalesSpcfcProductGroup3,
  cast( mvgr4 as wlf_salesspcfcproductgroup4 preserving type ) AS SalesSpcfcProductGroup4,
  cast( mvgr5 as wlf_salesspcfcproductgroup5 preserving type ) AS SalesSpcfcProductGroup5,
  augru AS SalesOrderReason,
  mfrnr AS Manufacturer,
  lifnr_royalties AS RoyaltyRecipient,
  lifnr_commission AS CommissionRecipient,
  cast( pernr_commission as wb2_worker_commsn_rcpnt preserving type ) AS WorkerCommissionRecipient,
  kunwe AS ShipToParty,
  kunrg AS PayerParty,
  customer_list AS ConditionDocumentCustomerList,
  vendor_list AS ConditionDocumentSupplierList,
  plant_list AS ConditionDocumentPlantList,
  bvb_list AS CndnDocBusinessVolumeList,
  service_doc_type AS ServiceDocumentType,
  service_doc_id AS ServiceDocument,
  service_doc_item_id AS ServiceDocumentItem,
  kdgrp AS CustomerGroup,
  kvgr1 AS AdditionalCustomerGroup1,
  kvgr2 AS AdditionalCustomerGroup2,
  kvgr3 AS AdditionalCustomerGroup3,
  kvgr4 AS AdditionalCustomerGroup4,
  kvgr5 AS AdditionalCustomerGroup5,
  kdkg1 AS CustomerConditionGroup1,
  kdkg2 AS CustomerConditionGroup2,
  kdkg3 AS CustomerConditionGroup3,
  kdkg4 AS CustomerConditionGroup4,
  kdkg5 AS CustomerConditionGroup5,
  land1 AS Country,
  regio AS Region,
  provg AS ProductCommissionGroup,
  pmatn AS PricingReferenceProduct,
  bzirk AS SalesDistrict,
  cast( kondm as productpricinggroup preserving type ) AS ProductPricingGroup,
  bonus AS SalesVolumeRebateGroup,
  cast( contract_process as wcb_biz_vol_sel_cc_proc_var preserving type ) AS BizVolSelCndnContrProcVar,
  cast( contract as wcb_biz_vol_sel_cndn_contr preserving type ) AS BizVolSelConditionContract,
  cast ( ps_psp_pnr as wlf_psp_pnr_no_cnext preserving type ) AS WBSElementInternalID,
  xekbz AS CndnDocSuplrInvcDlvCostCat,
  cast( racct as fis_racct preserving type ) AS GLAccount,
  sont_abbrv_b AS CndnDocObjNodeTypeAbbr,
  semantic_type_b AS CndnDocSemanticCode,
  cast( ext_guid as wb2_srce_business_volume_uuid preserving type ) AS CndnDocSrceBusinessVolumeUUID
FROM wb2_d_busvolbase
LEFT OUTER JOIN R_ConditionDocument AS _ConditionDocument ON ConditionDocument = _ConditionDocument.ConditionDocument  -- association [1..1]
LEFT OUTER JOIN I_BusVolFieldCombnType AS _BusVolFieldCombnType ON BusVolFieldCombnType = _BusVolFieldCombnType.BusVolFieldCombnType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrBusVolSign AS _BusinessVolumeFieldCombnSign ON BusinessVolumeFieldCombnSign = _BusinessVolumeFieldCombnSign.CndnContrBusVolSign  -- association [0..1]
LEFT OUTER JOIN I_BusVolSelectionGroup AS _BusVolSelectionGroup ON BusVolSelectionGroup = _BusVolSelectionGroup.BusVolSelectionGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ConditionDocumentSupplier ON ConditionDocumentSupplier = _ConditionDocumentSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ConditionDocumentCustomer ON ConditionDocumentCustomer = _ConditionDocumentCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CustomerHierarchy ON CustomerHierarchy = _CustomerHierarchy.Customer  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchy AS _ProductHierarchy ON ProductHierarchy = _ProductHierarchy.ProductHierarchy  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup1 AS _SalesSpcfcProductGroup1 ON SalesSpcfcProductGroup1 = _SalesSpcfcProductGroup1.SalesSpcfcProductGroup1  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup2 AS _SalesSpcfcProductGroup2 ON SalesSpcfcProductGroup2 = _SalesSpcfcProductGroup2.SalesSpcfcProductGroup2  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup3 AS _SalesSpcfcProductGroup3 ON SalesSpcfcProductGroup3 = _SalesSpcfcProductGroup3.SalesSpcfcProductGroup3  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup4 AS _SalesSpcfcProductGroup4 ON SalesSpcfcProductGroup4 = _SalesSpcfcProductGroup4.SalesSpcfcProductGroup4  -- association [0..1]
LEFT OUTER JOIN I_SalesSpcfcProductGroup5 AS _SalesSpcfcProductGroup5 ON SalesSpcfcProductGroup5 = _SalesSpcfcProductGroup5.SalesSpcfcProductGroup5  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentReason AS _SalesOrderReason ON SalesOrderReason = _SalesOrderReason.SDDocumentReason  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Manufacturer ON Manufacturer = _Manufacturer.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _RoyaltyRecipient ON RoyaltyRecipient = _RoyaltyRecipient.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _CommissionRecipient ON CommissionRecipient = _CommissionRecipient.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _WorkerCommissionRecipient ON WorkerCommissionRecipient = _WorkerCommissionRecipient.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN R_ConditionDocument AS _ConditionDocumentCustomerList ON ConditionDocumentCustomerList = _ConditionDocumentCustomerList.ConditionDocument  -- association [0..1]
LEFT OUTER JOIN R_ConditionDocument AS _ConditionDocumentSupplierList ON ConditionDocumentSupplierList = _ConditionDocumentSupplierList.ConditionDocument  -- association [0..1]
LEFT OUTER JOIN R_ConditionDocument AS _ConditionDocumentPlantList ON ConditionDocumentPlantList = _ConditionDocumentPlantList.ConditionDocument  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentType AS _ServiceDocumentType ON ServiceDocumentType = _ServiceDocumentType.ServiceDocumentType  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1 ON AdditionalCustomerGroup1 = _AdditionalCustomerGroup1.AdditionalCustomerGroup1  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2 ON AdditionalCustomerGroup2 = _AdditionalCustomerGroup2.AdditionalCustomerGroup2  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3 ON AdditionalCustomerGroup3 = _AdditionalCustomerGroup3.AdditionalCustomerGroup3  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4 ON AdditionalCustomerGroup4 = _AdditionalCustomerGroup4.AdditionalCustomerGroup4  -- association [0..1]
LEFT OUTER JOIN I_AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5 ON AdditionalCustomerGroup5 = _AdditionalCustomerGroup5.AdditionalCustomerGroup5  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Country = _Region.Country AND Region = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_Product AS _PricingReferenceProduct ON PricingReferenceProduct = _PricingReferenceProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDistrict ON SalesDistrict = _SalesDistrict.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_MaterialCommissionGroup AS _ProductCommissionGroup ON ProductCommissionGroup = _ProductCommissionGroup.MaterialCommissionGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductPricingGroup AS _ProductPricingGroup ON ProductPricingGroup = _ProductPricingGroup.ProductPricingGroup  -- association [0..1]
LEFT OUTER JOIN I_CndnContrProcVar AS _BizVolSelCndnContrProcVar ON BizVolSelCndnContrProcVar = _BizVolSelCndnContrProcVar.CndnContrProcVar  -- association [0..1]
LEFT OUTER JOIN R_ConditionContract AS _BizVolSelConditionContract ON BizVolSelConditionContract = _BizVolSelConditionContract.ConditionContract  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CndnDocSuplrInvcDlvCostCat AS _CndnDocSuplrInvcDlvCostCat ON CndnDocSuplrInvcDlvCostCat = _CndnDocSuplrInvcDlvCostCat.CndnDocSuplrInvcDlvCostCat  -- association [0..1]
;