What is A_ExciseTaxMatlDocItem in SAP S/4HANA?

A_ExciseTaxMatlDocItem is a composite CDS view in SAP S/4HANA. MatlDocItem for Industry Extensions It contains 57 fields.

Which tables does A_ExciseTaxMatlDocItem read from?

A_ExciseTaxMatlDocItem reads data from: I_ExciseTaxMatlDocItem.

What VDM layer is A_ExciseTaxMatlDocItem?

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

A_ExciseTaxMatlDocItem

DDL: A_EXCISETAXMATLDOCITEM SQL: AET_MATLDOCITM Type: view COMPOSITE Package: ET_MM_INTEGRATION

57 Fields 1 Data Sources 5 Associations 1 OData Services

MatlDocItem for Industry Extensions

A_ExciseTaxMatlDocItem is a Composite CDS View that provides data about "MatlDocItem for Industry Extensions" in SAP S/4HANA. It reads from 1 data source (I_ExciseTaxMatlDocItem) and exposes 57 fields with key fields MaterialDocument, MaterialDocumentYear, MaterialDocumentItem. It has 5 associations to related views. It is exposed through 1 OData service (API_EXCISETAXMATDOCITM_SRV). Part of development package ET_MM_INTEGRATION.

Data Sources (1)

Source	Alias	Join Type
I_ExciseTaxMatlDocItem	_MaterialDocumentItem	from

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	I_MaterialDocumentYear	_MaterialDocumentYear	`$projection.MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear`
[1..1]	A_MaterialDocumentHeader	_MaterialDocumentHeader	`$projection.MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear and $projection.MaterialDocument = _MaterialDocumentHeader.MaterialDocument ----> Extension Associations`
[1..1]	E_MaterialDocumentItem_2	_MaterialDocumentItemExtension	`$projection.MaterialDocument = _MaterialDocumentItemExtension.MaterialDocument and $projection.MaterialDocumentYear = _MaterialDocumentItemExtension.MaterialDocumentYear and $projection.MaterialDocumentItem = _MaterialDocumentItemExtension.MaterialDocumentItem and _MaterialDocumentItemExtension.MaterialDocumentRecordType = 'MDOC'`
[0..1]	E_PurchasingDocumentItem	_PurchaseOrderItemExtension	`$projection.PurchaseOrder = _PurchaseOrderItemExtension.PurchasingDocument and $projection.PurchaseOrderItem = _PurchaseOrderItemExtension.PurchasingDocumentItem`
[0..1]	E_SalesDocumentItemBasic	_SalesDocumentItemExtension	`$projection.SalesOrder = _SalesDocumentItemExtension.SalesDocument and $projection.SalesOrderItem = _SalesDocumentItemExtension.SalesDocumentItem`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	AET_MATLDOCITM	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	MatlDocItem for Industry Extensions	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
Metadata.ignorePropagatedAnnotations	true	view

OData Services (1)

Service	Binding	Version	Contract	Release
API_EXCISETAXMATDOCITM_SRV	API_EXCISETAXMATDOCITM_SRV	V2	C2	NOT_RELEASED

Fields (57)

Key	Field	Source Table	Source Field	Description
KEY	MaterialDocument	I_ExciseTaxMatlDocItem	MaterialDocument	Material Doc.
KEY	MaterialDocumentYear	I_ExciseTaxMatlDocItem	MaterialDocumentYear	Material Document Year
KEY	MaterialDocumentItem	I_ExciseTaxMatlDocItem	MaterialDocumentItem	Material Document Item
	CompanyCode	I_ExciseTaxMatlDocItem	CompanyCode	Receiver Company Code
	Plant	I_ExciseTaxMatlDocItem	Plant	Valuation Area
	StorageLocation	I_ExciseTaxMatlDocItem	StorageLocation	StorageLocation
	CostCenter	I_ExciseTaxMatlDocItem	CostCenter	Cost Center
	PostingDate	I_ExciseTaxMatlDocItem	PostingDate	Posting Date for GR
	DocumentDate	I_ExciseTaxMatlDocItem	DocumentDate	Journal Entry Date
	CreationDate	I_ExciseTaxMatlDocItem	CreationDate	Time Stamp
	CreationTime	I_ExciseTaxMatlDocItem	CreationTime	Time of Change
	Material	I_ExciseTaxMatlDocItem	Material	Vehicle Model
	Batch	I_ExciseTaxMatlDocItem	Batch	Lot No.
	QuantityInEntryUnit	I_ExciseTaxMatlDocItem	QuantityInEntryUnit	Quantity in Unit of Entry
	EntryUnit	I_ExciseTaxMatlDocItem	EntryUnit	Unit of Entry
	QuantityInBaseUnit	I_ExciseTaxMatlDocItem	QuantityInBaseUnit	Quantity
	MaterialBaseUnit	I_ExciseTaxMatlDocItem	MaterialBaseUnit	Valuation Unit
	GoodsMovementType	I_ExciseTaxMatlDocItem	GoodsMovementType	Movement Type
	IsReversalMovementType	I_ExciseTaxMatlDocItem	IsReversalMovementType
	GoodsMovementRefDocType	I_ExciseTaxMatlDocItem	GoodsMovementRefDocType	Reference Doc. Type
	DebitCreditCode	I_ExciseTaxMatlDocItem	DebitCreditCode	Single-Character Flag
	IsAutomaticallyCreated	I_ExciseTaxMatlDocItem	IsAutomaticallyCreated	Is Automatically Created
	GoodsMovementReasonCode	I_ExciseTaxMatlDocItem	GoodsMovementReasonCode	Reason for Mvmt
	Supplier	I_ExciseTaxMatlDocItem	Supplier	Supplier
	SupplyingSupplier	I_ExciseTaxMatlDocItem	SupplyingSupplier	Goods Supplier
	Customer	I_ExciseTaxMatlDocItem	Customer	Sold-to Party
	GoodsRecipientName	I_ExciseTaxMatlDocItem	GoodsRecipientName	Recipient Name
	IssuingOrReceivingPlant	I_ExciseTaxMatlDocItem	IssuingOrReceivingPlant	Transfer Plant
	IssuingOrReceivingStorageLoc	I_ExciseTaxMatlDocItem	IssuingOrReceivingStorageLoc	Receiving SLoc.
	IssgOrRcvgMaterial	I_ExciseTaxMatlDocItem	IssgOrRcvgMaterial	Transfer Material
	IssgOrRcvgBatch	I_ExciseTaxMatlDocItem	IssgOrRcvgBatch	Transfer Batch
	SupplyingPlant	I_ExciseTaxMatlDocItem	SupplyingPlant	Supplying Plant
	OriginalMaterialDocumentItem	I_ExciseTaxMatlDocItem	OriginalMaterialDocumentItem	Orig. line itm
	ReferenceDocument	_MaterialDocumentHeader	ReferenceDocument	Reference Document
	ReversedMaterialDocument	I_ExciseTaxMatlDocItem	ReversedMaterialDocument	Reversed Mat Doc
	ReversedMaterialDocumentItem	I_ExciseTaxMatlDocItem	ReversedMaterialDocumentItem	Reversed Doc Item
	ReversedMaterialDocumentYear	I_ExciseTaxMatlDocItem	ReversedMaterialDocumentYear	Reversed Doc Year
	DeliveryDocument	I_ExciseTaxMatlDocItem	DeliveryDocument	Outbound Delivery
	DeliveryDocumentItem	I_ExciseTaxMatlDocItem	DeliveryDocumentItem	Outb. Delivery Item
	PurchaseOrder	I_ExciseTaxMatlDocItem	PurchaseOrder	Purchasing Document
	PurchaseOrderItem	I_ExciseTaxMatlDocItem	PurchaseOrderItem	Purchasing Document Item
	PurchaseOrderCategory	I_ExciseTaxMatlDocItem	PurchaseOrderCategory	Doc. Category
	PurchaseOrderItemCategory	I_ExciseTaxMatlDocItem	PurchaseOrderItemCategory	Item Category
	PurchaseOrderType	I_ExciseTaxMatlDocItem	PurchaseOrderType	PO Type
	PurchaseOrderSubtype	I_ExciseTaxMatlDocItem	PurchaseOrderSubtype	Control
	SalesOrder	I_ExciseTaxMatlDocItem	SalesOrder	SD Document
	SalesOrderItem	I_ExciseTaxMatlDocItem	SalesOrderItem	Sales Order Item
	SalesOrderType	I_ExciseTaxMatlDocItem	SalesOrderType	Sales Order Type
	SalesDocumentItemCategory	I_ExciseTaxMatlDocItem	SalesDocumentItemCategory	Item Category
	OrderID	I_ExciseTaxMatlDocItem	OrderID	Order ID
	OrderItem	I_ExciseTaxMatlDocItem	OrderItem
	OrderCategory	I_ExciseTaxMatlDocItem	OrderCategory	Order Category
	OrderType	I_ExciseTaxMatlDocItem	OrderType	Order Type
	SupplierAuthznGrp	I_ExciseTaxMatlDocItem	SupplierAuthznGrp	Authorization
	CustomerAuthznGrp	I_ExciseTaxMatlDocItem	CustomerAuthznGrp
	IsStorLocAuthznCheckActive	I_ExciseTaxMatlDocItem	IsStorLocAuthznCheckActive
	IsIssgOrRcvgStorLocAuthChkActv	I_ExciseTaxMatlDocItem	IsIssgOrRcvgStorLocAuthChkActv

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 A_ExciseTaxMatlDocItem.
-- 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: AET_MATLDOCITM

CREATE VIEW A_ExciseTaxMatlDocItem AS
SELECT
  _MaterialDocumentItem.MaterialDocument AS MaterialDocument,
  _MaterialDocumentItem.MaterialDocumentYear AS MaterialDocumentYear,
  _MaterialDocumentItem.MaterialDocumentItem AS MaterialDocumentItem,
  _MaterialDocumentItem.CompanyCode AS CompanyCode,
  _MaterialDocumentItem.Plant AS Plant,
  _MaterialDocumentItem.StorageLocation AS StorageLocation,
  _MaterialDocumentItem.CostCenter AS CostCenter,
  _MaterialDocumentItem.PostingDate AS PostingDate,
  _MaterialDocumentItem.DocumentDate AS DocumentDate,
  _MaterialDocumentItem.CreationDate AS CreationDate,
  _MaterialDocumentItem.CreationTime AS CreationTime,
  _MaterialDocumentItem.Material AS Material,
  _MaterialDocumentItem.Batch AS Batch,
  _MaterialDocumentItem.QuantityInEntryUnit AS QuantityInEntryUnit,
  _MaterialDocumentItem.EntryUnit AS EntryUnit,
  _MaterialDocumentItem.QuantityInBaseUnit AS QuantityInBaseUnit,
  _MaterialDocumentItem.MaterialBaseUnit AS MaterialBaseUnit,
  _MaterialDocumentItem.GoodsMovementType AS GoodsMovementType,
  _MaterialDocumentItem.IsReversalMovementType AS IsReversalMovementType,
  _MaterialDocumentItem.GoodsMovementRefDocType AS GoodsMovementRefDocType,
  _MaterialDocumentItem.DebitCreditCode AS DebitCreditCode,
  _MaterialDocumentItem.IsAutomaticallyCreated AS IsAutomaticallyCreated,
  _MaterialDocumentItem.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  _MaterialDocumentItem.Supplier AS Supplier,
  _MaterialDocumentItem.SupplyingSupplier AS SupplyingSupplier,
  _MaterialDocumentItem.Customer AS Customer,
  _MaterialDocumentItem.GoodsRecipientName AS GoodsRecipientName,
  _MaterialDocumentItem.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  _MaterialDocumentItem.IssuingOrReceivingStorageLoc AS IssuingOrReceivingStorageLoc,
  _MaterialDocumentItem.IssgOrRcvgMaterial AS IssgOrRcvgMaterial,
  _MaterialDocumentItem.IssgOrRcvgBatch AS IssgOrRcvgBatch,
  _MaterialDocumentItem.SupplyingPlant AS SupplyingPlant,
  _MaterialDocumentItem.OriginalMaterialDocumentItem AS OriginalMaterialDocumentItem,
  _MaterialDocumentHeader.ReferenceDocument AS ReferenceDocument,
  _MaterialDocumentItem.ReversedMaterialDocument AS ReversedMaterialDocument,
  _MaterialDocumentItem.ReversedMaterialDocumentItem AS ReversedMaterialDocumentItem,
  _MaterialDocumentItem.ReversedMaterialDocumentYear AS ReversedMaterialDocumentYear,
  _MaterialDocumentItem.DeliveryDocument AS DeliveryDocument,
  _MaterialDocumentItem.DeliveryDocumentItem AS DeliveryDocumentItem,
  _MaterialDocumentItem.PurchaseOrder AS PurchaseOrder,
  _MaterialDocumentItem.PurchaseOrderItem AS PurchaseOrderItem,
  _MaterialDocumentItem.PurchaseOrderCategory AS PurchaseOrderCategory,
  _MaterialDocumentItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  _MaterialDocumentItem.PurchaseOrderType AS PurchaseOrderType,
  _MaterialDocumentItem.PurchaseOrderSubtype AS PurchaseOrderSubtype,
  _MaterialDocumentItem.SalesOrder AS SalesOrder,
  _MaterialDocumentItem.SalesOrderItem AS SalesOrderItem,
  _MaterialDocumentItem.SalesOrderType AS SalesOrderType,
  _MaterialDocumentItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  _MaterialDocumentItem.OrderID AS OrderID,
  _MaterialDocumentItem.OrderItem AS OrderItem,
  _MaterialDocumentItem.OrderCategory AS OrderCategory,
  _MaterialDocumentItem.OrderType AS OrderType,
  _MaterialDocumentItem.SupplierAuthznGrp AS SupplierAuthznGrp,
  _MaterialDocumentItem.CustomerAuthznGrp AS CustomerAuthznGrp,
  _MaterialDocumentItem.IsStorLocAuthznCheckActive AS IsStorLocAuthznCheckActive,
  _MaterialDocumentItem.IsIssgOrRcvgStorLocAuthChkActv AS IsIssgOrRcvgStorLocAuthChkActv
FROM I_ExciseTaxMatlDocItem AS _MaterialDocumentItem
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN A_MaterialDocumentHeader AS _MaterialDocumentHeader ON MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentHeader.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN E_MaterialDocumentItem_2 AS _MaterialDocumentItemExtension ON MaterialDocument = _MaterialDocumentItemExtension.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentItemExtension.MaterialDocumentYear AND MaterialDocumentItem = _MaterialDocumentItemExtension.MaterialDocumentItem AND _MaterialDocumentItemExtension.MaterialDocumentRecordType = 'MDOC'  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurchaseOrderItemExtension ON PurchaseOrder = _PurchaseOrderItemExtension.PurchasingDocument AND PurchaseOrderItem = _PurchaseOrderItemExtension.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _SalesDocumentItemExtension ON SalesOrder = _SalesDocumentItemExtension.SalesDocument AND SalesOrderItem = _SalesDocumentItemExtension.SalesDocumentItem  -- association [0..1]
;

Depth:

A_ExciseTaxMatlDocItem view

I_ExciseTaxMatlDocItem view