What is C_SetlDocItmsCommsnBizVol in SAP S/4HANA?

C_SetlDocItmsCommsnBizVol is a consumption CDS view in SAP S/4HANA. Business Volume of External Commissions It contains 79 fields.

Which tables does C_SetlDocItmsCommsnBizVol read from?

C_SetlDocItmsCommsnBizVol reads data from: R_SettlmtMgmtDocItmBizVolSuplr.

What VDM layer is C_SetlDocItmsCommsnBizVol?

C_SetlDocItmsCommsnBizVol is classified as a Consumption view optimized for specific business scenarios and reporting.

C_SetlDocItmsCommsnBizVol

DDL: C_SETLDOCITMSCOMMSNBIZVOL Type: view_entity CONSUMPTION

79 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 79 fields with key fields SettlmtDoc, SettlmtDocItem.

Data Sources (1)

Source	Alias	Join Type
R_SettlmtMgmtDocItmBizVolSuplr	R_SettlmtMgmtDocItmBizVolSuplr	from

Annotations (9)

Name	Value	Level
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 (79)

Key	Field	Source Field	Description
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.
	ConditionContract	ConditionContract	Condition Contract
	CndnContrType	CndnContrType	Contract Type
	CndnContrProcVar	CndnContrProcVar	Process Variant
	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
	PriceSpecificationProductGroup	PriceSpecificationProductGroup	Prd.Price Grp
	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

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,
  ConditionContract,
  CndnContrType,
  CndnContrProcVar,
  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,
  PriceSpecificationProductGroup,
  SalesVolumeRebateGroup,
  SlsProdHierarchyParentNodeID,
  NetAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  RebateBasisAmount,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  SettlmtRefDocType,
  SettlmtRefDoc,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocCompanyCode,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  SettlmtMgmtDocCat,
  SettlmtSrceDocSpltCategory
FROM R_SettlmtMgmtDocItmBizVolSuplr
;

Depth:

C_SetlDocItmsCommsnBizVol view_entity

R_SettlmtMgmtDocItmBizVolSuplr view_entity