I_ExciseDueDocHdr

DDL: I_EXCISEDUEDOCHDR SQL: ISDEXDUEDOCHDR Type: view COMPOSITE Package: GLO_LOG_IN
36 Fields 2 Data Sources

Excise Duelist with single line item

I_ExciseDueDocHdr is a Composite CDS View that provides data about "Excise Duelist with single line item" in SAP S/4HANA. It reads from 2 data sources (I_BillingDocFirstItem, I_ExciseDueDocBase) and exposes 36 fields with key field BillingDocument. Part of development package GLO_LOG_IN.

Data Sources (2)

SourceAliasJoin Type
I_BillingDocFirstItem I_BillingDocFirstItem inner
I_ExciseDueDocBase I_ExciseDueDocBase from

Annotations (9)

NameValueLevelField
EndUserText.label Excise Duelist with single line item view
ObjectModel.representativeKey BillingDocument view
AbapCatalog.sqlViewName ISDEXDUEDOCHDR view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_ExciseDueDocBase BillingDocument SD Document
BillingDocumentItem I_ExciseDueDocBase 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 I_ExciseDueDocBase BillingDocumentType Billing Type
PricingDocument PricingDocument Document Condition
TransactionCurrency TransactionCurrency Transaction Currency
ExciseDocStatus ExciseDocStatus
ShippingPoint ShippingPoint Shipping Point
Material Material Vehicle Model
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
SDPricingProcedure SDPricingProcedure Pric. Procedure
Currency Currency Valuation Crcy
DeliveryDocument DeliveryDocument Outbound Delivery
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_ExciseDueDocHdr.
-- 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: ISDEXDUEDOCHDR

CREATE VIEW I_ExciseDueDocHdr AS
SELECT
  I_ExciseDueDocBase.BillingDocument AS BillingDocument,
  I_ExciseDueDocBase.BillingDocumentItem AS BillingDocumentItem,
  SalesOrganization,
  DistributionChannel,
  Division,
  BillingDocumentCategory,
  SoldToParty,
  BillingDocumentDate,
  I_ExciseDueDocBase.BillingDocumentType AS BillingDocumentType,
  PricingDocument,
  TransactionCurrency,
  ExciseDocStatus,
  ShippingPoint,
  Material,
  BaseUnit,
  BillingQuantity,
  BillingQuantityUnit,
  PricingDate,
  StorageLocation,
  Batch,
  ProfitCenter,
  ProfitabilitySegment,
  BusinessArea,
  CostCenter,
  Plant,
  PlantName,
  TaxCalculationProcedure,
  CompanyCode,
  SDPricingProcedure,
  Currency,
  DeliveryDocument,
  ReferenceSDDocument
FROM I_ExciseDueDocBase
INNER JOIN I_BillingDocFirstItem ON /* join condition not captured in parsed metadata */
;

Learn More