I_ExciseDueDocItemBase

DDL: I_EXCISEDUEDOCITEMBASE SQL: ISDEXDUEDOCIBS Type: view COMPOSITE
37 Fields 1 Data Sources

ExciseItem Duelist Base

I_ExciseDueDocItemBase is a Composite CDS View that provides data about "ExciseItem Duelist Base" in SAP S/4HANA. It reads from 1 data source (I_ExciseDueDocBase) and exposes 37 fields.

Data Sources (1)

SourceAliasJoin Type
I_ExciseDueDocBase I_ExciseDueDocBase from

Parameters (1)

NameTypeDefault
P_BillingDocument vbeln

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISDEXDUEDOCIBS view
AbapCatalog.compiler.compareFilter true 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
EndUserText.label ExciseItem Duelist Base view

Fields (37)

KeyFieldSource TableSource FieldDescription
BillingDocument BillingDocument SD Document
BillingDocumentItem BillingDocumentItem Item
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
BillingDocumentCategory BillingDocumentCategory BillingCategory
SoldToParty SoldToParty Sold-to Party
BillingDocumentDate BillingDocumentDate Billing Date
BillingDocumentType BillingDocumentType Billing Type
PricingDocument PricingDocument Document Condition
TransactionCurrency TransactionCurrency Transaction Currency
ExciseDocStatus ExciseDocStatus
ShippingPoint ShippingPoint Shipping Point
Material Material Vehicle Model
MaterialName MaterialName Material Description
Language Language Report Text Language
BaseUnit BaseUnit Unit of Measure
BillingQuantity BillingQuantity Invoiced Qty
BillingQuantityUnit BillingQuantityUnit Sales Unit
PricingDate PricingDate Pricing Date
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
ProfitCenter ProfitCenter Profit Center
ProfitabilitySegment ProfitabilitySegment Profitability Segment
BusinessArea BusinessArea Business Area
CostCenter CostCenter Cost Center
Plant Plant Valuation Area
PlantName PlantName Plant Name
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
CompanyCode CompanyCode Receiver Company Code
Currency Currency Valuation Crcy
SDPricingProcedure SDPricingProcedure Pric. Procedure
ReferenceSDDocument ReferenceSDDocument Reference Doc.
_BillingDocumentCategory _BillingDocumentCategory
_ExciseSeriesGrpDtmn _ExciseSeriesGrpDtmn
_Item _Item
_Partner _Partner

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_ExciseDueDocItemBase.
-- 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: ISDEXDUEDOCIBS
-- Parameters: P_BillingDocument : vbeln

CREATE VIEW I_ExciseDueDocItemBase AS
SELECT
  BillingDocument,
  BillingDocumentItem,
  SalesOrganization,
  DistributionChannel,
  Division,
  BillingDocumentCategory,
  SoldToParty,
  BillingDocumentDate,
  BillingDocumentType,
  PricingDocument,
  TransactionCurrency,
  ExciseDocStatus,
  ShippingPoint,
  Material,
  MaterialName,
  Language,
  BaseUnit,
  BillingQuantity,
  BillingQuantityUnit,
  PricingDate,
  StorageLocation,
  Batch,
  ProfitCenter,
  ProfitabilitySegment,
  BusinessArea,
  CostCenter,
  Plant,
  PlantName,
  TaxCalculationProcedure,
  CompanyCode,
  Currency,
  SDPricingProcedure,
  ReferenceSDDocument
FROM I_ExciseDueDocBase
;

Learn More