C_SettlmtIntcoRoytyBlgDcBizVol

DDL: C_SETTLMTINTCOROYTYBLGDCBIZVOL Type: view_entity CONSUMPTION
90 Fields 1 Data Sources 1 Associations

Bus Vol Royalties Settlement Billing Doc

C_SettlmtIntcoRoytyBlgDcBizVol is a Consumption CDS View that provides data about "Bus Vol Royalties Settlement Billing Doc" in SAP S/4HANA. It reads from 1 data source (R_SettlmtMgmtBillgDocBizVol) and exposes 90 fields with key fields BillingDocument, BillingDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtMgmtBillgDocBizVol R_SettlmtMgmtBillgDocBizVol from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_SetlMgmtCoCodeSettlmtRprstn _SettlmtMgmtSenderCustomer $projection.CompanyCode = _SettlmtMgmtSenderCustomer.CompanyCode

Annotations (8)

NameValueLevelField
EndUserText.label Bus Vol Royalties Settlement Billing Doc 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
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (90)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument SD Document
KEY BillingDocumentItem BillingDocumentItem Item
CompanyCode CompanyCode Receiver Company Code
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesDistrict SalesDistrict Sales District
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
SettlmtMgmtSenderCustomer _SettlmtMgmtSenderCustomer Customer Sold-to Party
Customer Customer Sold-to Party
PayerParty PayerParty Payer
ShipToParty ShipToParty Ship-To Party (obsolete)
ContractAccount ContractAccount Contract Acct
BillingDocumentType BillingDocumentType Billing Type
SDDocumentCategory SDDocumentCategory Document Cat.
BillingDocumentDate BillingDocumentDate Billing Date
Country Country Venue: Ctry/Reg
Region Region Venue Region
BillingDocumentIsCancelled BillingDocumentIsCancelled Canceled
CancelledBillingDocument CancelledBillingDocument Canceld Bill.Dc
TransactionCurrency TransactionCurrency Transaction Currency
AccountingExchangeRate AccountingExchangeRate Exch.Rate Acct.
ExchangeRateDate ExchangeRateDate Translatn Date
ExchangeRateType ExchangeRateType Exch. Rate Type
PricingDate PricingDate Pricing Date
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
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
ReturnItemProcessingType ReturnItemProcessingType Returns
SDDocumentReason SDDocumentReason Order Reason
BillingDocumentItemInPartSgmt BillingDocumentItemInPartSgmt
Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
Plant Plant Valuation Area
ProductHierarchy ProductHierarchy Prod.hierarchy
ProductCommissionGroup ProductCommissionGroup Commission Grp
SalesVolumeRebateGroup SalesVolumeRebateGroup Volume Rebate Group
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
PricingReferenceProduct PricingReferenceProduct X-distr.-chain PRM
ProductPricingGroup ProductPricingGroup
BillingQuantityInBaseUnit BillingQuantityInBaseUnit Bill.Qty in SKU
BaseUnit BaseUnit Unit of Measure
BillingQuantity BillingQuantity Invoiced Qty
BillingQuantityUnit BillingQuantityUnit Sales Unit
NetAmount NetAmount Stated Amount
TaxAmount TaxAmount Tax Amt in Rptg Crcy
GrossAmount GrossAmount Gross value
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
TaxCode TaxCode Tax Code
TaxRateValidityStartDate TaxRateValidityStartDate Tax Rate Validity Start Date
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
VATRegistration VATRegistration VAT Registration No.
VATRegistrationCountry VATRegistrationCountry CtryRgnSlsTxNo.
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
CustomerGroup CustomerGroup Customer Group
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
ProviderContract ProviderContract Contract
ProviderContractItem ProviderContractItem Contract Item
SettlmtRefDocCat SettlmtRefDocCat SettlmtRefDocCat
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocument ServiceDocument Transaction ID
ServiceDocumentItem ServiceDocumentItem Service Document
SettlmtAddlRefDocCat SettlmtAddlRefDocCat SettlmtAddlRefDocCat
SettlmtSrceDocSpltCategory SettlmtSrceDocSpltCategory
PricingDocument PricingDocument Document Condition

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_SettlmtIntcoRoytyBlgDcBizVol.
-- 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_SettlmtIntcoRoytyBlgDcBizVol AS
SELECT
  BillingDocument,
  BillingDocumentItem,
  CompanyCode,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesDistrict,
  SalesGroup,
  SalesOffice,
  _SettlmtMgmtSenderCustomer.Customer AS SettlmtMgmtSenderCustomer,
  Customer,
  PayerParty,
  ShipToParty,
  ContractAccount,
  BillingDocumentType,
  SDDocumentCategory,
  BillingDocumentDate,
  Country,
  Region,
  BillingDocumentIsCancelled,
  CancelledBillingDocument,
  TransactionCurrency,
  AccountingExchangeRate,
  ExchangeRateDate,
  ExchangeRateType,
  PricingDate,
  ServicesRenderedDate,
  ProfitCenter,
  CostCenter,
  BusinessArea,
  ControllingArea,
  WBSElementInternalID,
  OrderID,
  ReturnItemProcessingType,
  SDDocumentReason,
  BillingDocumentItemInPartSgmt,
  Product,
  ProductGroup,
  Plant,
  ProductHierarchy,
  ProductCommissionGroup,
  SalesVolumeRebateGroup,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  PricingReferenceProduct,
  ProductPricingGroup,
  BillingQuantityInBaseUnit,
  BaseUnit,
  BillingQuantity,
  BillingQuantityUnit,
  NetAmount,
  TaxAmount,
  GrossAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  RebateBasisAmount,
  TaxCode,
  TaxRateValidityStartDate,
  TaxJurisdiction,
  VATRegistration,
  VATRegistrationCountry,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CustomerGroup,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  ProviderContract,
  ProviderContractItem,
  SettlmtRefDocCat,
  SalesDocument,
  SalesDocumentItem,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  SettlmtAddlRefDocCat,
  SettlmtSrceDocSpltCategory,
  PricingDocument
FROM R_SettlmtMgmtBillgDocBizVol
LEFT OUTER JOIN R_SetlMgmtCoCodeSettlmtRprstn AS _SettlmtMgmtSenderCustomer ON CompanyCode = _SettlmtMgmtSenderCustomer.CompanyCode  -- association [0..1]
;

Learn More