C_SetlDocItmsCommsnBizVol

DDL: C_SETLDOCITMSCOMMSNBIZVOL Type: view_entity CONSUMPTION Package: WCB_CC_SETTL_BV_SEL
83 Fields 1 Data Sources

Business Volume of External Commissions

C_SetlDocItmsCommsnBizVol is a Consumption CDS View that provides data about "Business Volume of External Commissions" in SAP S/4HANA. It reads from 1 data source (R_SettlmtMgmtDocItmBizVolSuplr) and exposes 83 fields with key fields SettlmtDoc, SettlmtDocItem. Part of development package WCB_CC_SETTL_BV_SEL.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtMgmtDocItmBizVolSuplr R_SettlmtMgmtDocItmBizVolSuplr from

Annotations (9)

NameValueLevelField
EndUserText.label Business Volume of External Commissions view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (83)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtMgmtDoc Document Number
KEY SettlmtDocItem SettlmtMgmtDocItem Item
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
CompanyCode CompanyCode Receiver Company Code
SettlmtCoCodeTaxCountry SettlmtCoCodeTaxCountry Tax Ctry/Reg. CoCode
Supplier Supplier Supplier
Customer Customer Sold-to Party
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangeDate LastChangeDate Time Stamp
SettlmtDocType SettlmtDocType Settlement Document Type
SettlmtDocCat SettlmtDocCat Settlement Document Category
SettlmtProcessType SettlmtProcessType Settlement Process Type
DocumentDate DocumentDate Journal Entry Date
DocumentReferenceID DocumentReferenceID Reference
PostingDate PostingDate Posting Date for GR
SettlmtDocIsCanceled SettlmtMgmtDocIsCancelled Doc. Reversed
CanceledSettlmtDoc CancelledSettlmtMgmtDoc
SupplierSettlmtStatus SupplierSettlmtStatus Settl. Status Supp.
BizVolSelConditionContract BizVolSelConditionContract
CndnContrType CndnContrType Contract Type
BizVolSelCndnContrProcVar BizVolSelCndnContrProcVar
CndnContrProcessCategory CndnContrProcessCategory Process Category
SettlmtDateCat SettlmtDateCat Settlement Date Type
SettlmtDate SettlmtDate Settlement Date
RefSettlmtDate RefSettlmtDate
ActualSettlmtDate ActualSettlmtDate Actual Settl. Date
Currency Currency Valuation Crcy
ExchangeRate ExchangeRate Exchange rate
ExchangeRateDate ExchangeRateDate Translatn Date
PricingDate PricingDate Pricing Date
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
BusinessPlace BusinessPlace Business place
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
BusinessArea BusinessArea Business Area
ControllingArea ControllingArea Controlling Area
WBSElementInternalID WBSElementInternalID WBS Internal ID
OrderID OrderID Order ID
SettlmtDocItemCat SettlmtMgmtDocItemCat
BranchCode BranchCode Branch Code
Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
ProductHierarchy ProductHierarchy Prod.hierarchy
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
ProductCommissionGroup ProductCommissionGroup Commission Grp
ProductPricingGroup ProductPricingGroup
SalesVolumeRebateGroup SalesVolumeRebateGroup Volume Rebate Group
SlsProdHierarchyParentNodeID SlsProdHierarchyParentNodeID
NetAmount NetAmount Stated Amount
Subtotal1Amount Subtotal1Amount Subtotal 1 Amount
Subtotal2Amount Subtotal2Amount Subtotal 2 Amount
Subtotal3Amount Subtotal3Amount Subtotal 3 Amount
Subtotal4Amount Subtotal4Amount Subtotal 4 Amount
Subtotal5Amount Subtotal5Amount Subtotal 5 Amount
Subtotal6Amount Subtotal6Amount Subtotal 6 Amount
RebateBasisAmount RebateBasisAmount Rebate Basis Amount
SettlmtSourceDoc SettlmtSourceDoc Source Doc.
SettlmtSourceDocItem SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat SettlmtSourceDocCat SourceDocCat
SettlmtSourceDocFiscalYear SettlmtSourceDocFiscalYear Fiscal Year of Source Document
SettlmtRefDocType SettlmtRefDocType Settlement Reference Document Type
SettlmtRefDoc SettlmtRefDoc Settlmt. Ref. Doc.
SettlmtRefDocFiscalYear SettlmtRefDocFiscalYear Year of Reference Document
SettlmtRefDocLogicalSyst SettlmtRefDocLogicalSyst SM Ref Log Sys
SettlmtRefDocCompanyCode SettlmtRefDocCompanyCode Ref. Company Code
SettlmtRefDocItem SettlmtRefDocItem SettlmtRefDocItem
SettlmtRefDocCat SettlmtRefDocCat SettlmtRefDocCat
SettlmtMgmtDocCat SettlmtMgmtDocCat
SettlmtSrceDocSpltCategory SettlmtSrceDocSpltCategory
VolumeRebateGroup SalesVolumeRebateGroup Volume Rebate Group
PriceSpecificationProductGroup ProductPricingGroup
CndnContrProcVar BizVolSelCndnContrProcVar
ConditionContract BizVolSelConditionContract

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_SetlDocItmsCommsnBizVol.
-- 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_SetlDocItmsCommsnBizVol AS
SELECT
  SettlmtMgmtDoc AS SettlmtDoc,
  SettlmtMgmtDocItem AS SettlmtDocItem,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  CompanyCode,
  SettlmtCoCodeTaxCountry,
  Supplier,
  Customer,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  SettlmtDocType,
  SettlmtDocCat,
  SettlmtProcessType,
  DocumentDate,
  DocumentReferenceID,
  PostingDate,
  SettlmtMgmtDocIsCancelled AS SettlmtDocIsCanceled,
  CancelledSettlmtMgmtDoc AS CanceledSettlmtDoc,
  SupplierSettlmtStatus,
  BizVolSelConditionContract,
  CndnContrType,
  BizVolSelCndnContrProcVar,
  CndnContrProcessCategory,
  SettlmtDateCat,
  SettlmtDate,
  RefSettlmtDate,
  ActualSettlmtDate,
  Currency,
  ExchangeRate,
  ExchangeRateDate,
  PricingDate,
  ServicesRenderedDate,
  BusinessPlace,
  ProfitCenter,
  CostCenter,
  BusinessArea,
  ControllingArea,
  WBSElementInternalID,
  OrderID,
  SettlmtMgmtDocItemCat AS SettlmtDocItemCat,
  BranchCode,
  Product,
  ProductGroup,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  ProductCommissionGroup,
  ProductPricingGroup,
  SalesVolumeRebateGroup,
  SlsProdHierarchyParentNodeID,
  NetAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  RebateBasisAmount,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  SettlmtRefDocType,
  SettlmtRefDoc,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocCompanyCode,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  SettlmtMgmtDocCat,
  SettlmtSrceDocSpltCategory,
  SalesVolumeRebateGroup AS VolumeRebateGroup,
  ProductPricingGroup AS PriceSpecificationProductGroup,
  BizVolSelCndnContrProcVar AS CndnContrProcVar,
  BizVolSelConditionContract AS ConditionContract
FROM R_SettlmtMgmtDocItmBizVolSuplr
;

Learn More