What is I_ExciseDueDocBase in SAP S/4HANA?

I_ExciseDueDocBase is a composite CDS view in SAP S/4HANA. Excise Duelist Base It contains 40 fields.

Which tables does I_ExciseDueDocBase read from?

I_ExciseDueDocBase reads data from: I_BillingDocument, I_ExciseRevDoc, P_SdPricingPrcd.

What VDM layer is I_ExciseDueDocBase?

I_ExciseDueDocBase is classified as a Composite view that combines data from multiple basic views.

I_ExciseDueDocBase

DDL: I_EXCISEDUEDOCBASE SQL: ISDEXDUEDOCBS Type: view COMPOSITE

40 Fields 3 Data Sources 5 Associations

Excise Duelist Base

I_ExciseDueDocBase is a Composite CDS View that provides data about "Excise Duelist Base" in SAP S/4HANA. It reads from 3 data sources (I_BillingDocument, I_ExciseRevDoc, P_SdPricingPrcd) and exposes 40 fields with key fields BillingDocument, BillingDocumentItem, SalesOrganization, DistributionChannel, Division. It has 5 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_BillingDocument	I_BillingDocument	from
I_ExciseRevDoc	I_ExciseRevDoc	left_outer
P_SdPricingPrcd	P_SdPricingPrcd	left_outer

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	I_ExciseSeriesGrpDetrmn	_ExciseSeriesGrpDtmn	`( $projection.SalesOrganization = _ExciseSeriesGrpDtmn.SalesOrganization and $projection.DistributionChannel = _ExciseSeriesGrpDtmn.DistributionChannel and $projection.Division = _ExciseSeriesGrpDtmn.Division and $projection.ShippingPoint = _ExciseSeriesGrpDtmn.ShippingPoint )`
[1..1]	I_SDDocumentCompletePartners	_Partner	`$projection.BillingDocument = _Partner.SDDocument and $projection.BillingDocumentItem = _Partner.SDDocumentItem and _Partner.PartnerFunction = 'WE'`
[0..1]	I_DistributionChannel	_DistributionChannel	`$projection.DistributionChannel = _DistributionChannel.DistributionChannel`
[0..1]	I_Division	_Division	`$projection.Division = _Division.Division`
[0..1]	I_SalesOrganization	_SalesOrganization	`$projection.SalesOrganization = _SalesOrganization.SalesOrganization`

Annotations (8)

Name	Value	Level
EndUserText.label	Excise Duelist Base	view
AbapCatalog.sqlViewName	ISDEXDUEDOCBS	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (40)

Key	Field	Source Table	Source Field	Description
KEY	BillingDocument		BillingDocument	SD Document
KEY	BillingDocumentItem	_Item	BillingDocumentItem	Item
KEY	SalesOrganization		SalesOrganization	Sales Organization
KEY	DistributionChannel		DistributionChannel	RefDistCh-Cust/Mat.
KEY	Division		Division	Internal Division ID
KEY	BillingDocumentCategory		BillingDocumentCategory	BillingCategory
KEY	SoldToParty		SoldToParty	Sold-to Party
KEY	BillingDocumentDate		BillingDocumentDate	Billing Date
KEY	BillingDocumentType		BillingDocumentType	Billing Type
KEY	PricingDocument		PricingDocument	Document Condition
KEY	TransactionCurrency		TransactionCurrency	Transaction Currency
KEY	ExciseDocStatus	_ExciseHeader	ExciseDocStatus
KEY	ReferenceSDDocument	_Item	ReferenceSDDocument	Reference Doc.
KEY	DeliveryDocument		DeliveryDocument	Outbound Delivery
KEY	ShippingPoint	_Item	ShippingPoint	Shipping Point
KEY	Material	_Item	Material	Vehicle Model
KEY	MaterialName
KEY	Language
KEY	BaseUnit	_Item	BaseUnit	Unit of Measure
KEY	BillingQuantity	_Item	BillingQuantity	Invoiced Qty
KEY	BillingQuantityUnit	_Item	BillingQuantityUnit	Sales Unit
KEY	PricingDate	_Item	PricingDate	Pricing Date
KEY	StorageLocation	_Item	StorageLocation	StorageLocation
KEY	Batch	_Item	Batch	Lot No.
KEY	BusinessArea	_Item	BusinessArea	Business Area
KEY	ProfitCenter	_Item	ProfitCenter	Profit Center
KEY	ProfitabilitySegment	_Item	ProfitabilitySegment_2	Profit. segment
KEY	CostCenter	_Item	CostCenter	Cost Center
KEY	Plant	_Item	Plant	Valuation Area
KEY	PlantName
KEY	TaxCalculationProcedure	_Country	TaxCalculationProcedure	Tax Procedure
KEY	CompanyCode	I_BillingDocument	CompanyCode	Receiver Company Code
KEY	Currency
	_Item		_Item
	_ExciseSeriesGrpDtmn		_ExciseSeriesGrpDtmn
	_BillingDocumentCategory		_BillingDocumentCategory
	_Partner		_Partner
	_DistributionChannel		_DistributionChannel
	_Division		_Division
	_SalesOrganization		_SalesOrganization

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 I_ExciseDueDocBase.
-- 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.
-- SQL view name: ISDEXDUEDOCBS

CREATE VIEW I_ExciseDueDocBase AS
SELECT
  BillingDocument,
  _Item.BillingDocumentItem AS BillingDocumentItem,
  SalesOrganization,
  DistributionChannel,
  Division,
  BillingDocumentCategory,
  SoldToParty,
  BillingDocumentDate,
  BillingDocumentType,
  PricingDocument,
  TransactionCurrency,
  _ExciseHeader.ExciseDocStatus AS ExciseDocStatus,
  _Item.ReferenceSDDocument AS ReferenceSDDocument,
  DeliveryDocument,
  _Item.ShippingPoint AS ShippingPoint,
  _Item.Material AS Material,
  _Item._Material._Text.MaterialName AS MaterialName,
  _Item._Material._Text.Language AS Language,
  _Item.BaseUnit AS BaseUnit,
  _Item.BillingQuantity AS BillingQuantity,
  _Item.BillingQuantityUnit AS BillingQuantityUnit,
  _Item.PricingDate AS PricingDate,
  _Item.StorageLocation AS StorageLocation,
  _Item.Batch AS Batch,
  _Item.BusinessArea AS BusinessArea,
  _Item.ProfitCenter AS ProfitCenter,
  _Item.ProfitabilitySegment_2 AS ProfitabilitySegment,
  _Item.CostCenter AS CostCenter,
  _Item.Plant AS Plant,
  _Item._Plant.PlantName AS PlantName,
  _Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  I_BillingDocument.CompanyCode AS CompanyCode,
  _CompanyCode._Currency.Currency AS Currency
FROM I_BillingDocument
LEFT OUTER JOIN I_ExciseRevDoc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SdPricingPrcd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ExciseSeriesGrpDetrmn AS _ExciseSeriesGrpDtmn ON ( SalesOrganization = _ExciseSeriesGrpDtmn.SalesOrganization AND DistributionChannel = _ExciseSeriesGrpDtmn.DistributionChannel AND Division = _ExciseSeriesGrpDtmn.Division AND ShippingPoint = _ExciseSeriesGrpDtmn.ShippingPoint )  -- association [1..1]
LEFT OUTER JOIN I_SDDocumentCompletePartners AS _Partner ON BillingDocument = _Partner.SDDocument AND BillingDocumentItem = _Partner.SDDocumentItem AND _Partner.PartnerFunction = 'WE'  -- association [1..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_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
;

Depth:

I_ExciseDueDocBase view