I_ExciseTaxMatlDocItem

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_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: IET_MATLDOCITM

CREATE VIEW I_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._GoodsMovementType.IsReversalMovementType AS IsReversalMovementType,
  _MaterialDocumentItem.GoodsMovementRefDocType AS GoodsMovementRefDocType,
  _MaterialDocumentItem.DebitCreditCode AS DebitCreditCode,
  _MaterialDocumentItem.IsAutomaticallyCreated AS IsAutomaticallyCreated,
  _MaterialDocumentItem.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  _PurgDocPartnerSupplSupplier.Supplier AS SupplyingSupplier,
  case when _PurgDocPartnerSupplSupplier.Supplier is not null then _PurgDocPartnerSupplSupplier.Supplier else _MaterialDocumentItem.Supplier end as Supplier AS SupplierendasSupplier,
  _MaterialDocumentItem.Customer AS Customer,
  ltrim(_MaterialDocumentItem.GoodsRecipientName, '0') AS GoodsRecipientName,
  _MaterialDocumentItem.IssgOrRcvgMaterial AS IssgOrRcvgMaterial,
  _MaterialDocumentItem.IssgOrRcvgBatch AS IssgOrRcvgBatch,
  _PurchaseOrderItem._PurchaseOrder.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,
  case when _MaterialDocumentItem.PurchaseOrder is null or _MaterialDocumentItem.PurchaseOrder = '' then _PurgOrderItemFromDelivItem.ReferenceSDDocument else _MaterialDocumentItem.PurchaseOrder end as PurchaseOrder AS PurchaseOrderendasPurchaseOrder,
  case when _MaterialDocumentItem.PurchaseOrderItem is null or _MaterialDocumentItem.PurchaseOrderItem = '' or _MaterialDocumentItem.PurchaseOrderItem = '00000' then cast(lpad(_PurgOrderItemFromDelivItem.ReferenceSDDocumentItem, 5, '0') as abap.numc(5)) else _MaterialDocumentItem.PurchaseOrderItem end as PurchaseOrderItem AS PurchaseOrderItemendasPurchaseOrderItem,
  case when _MaterialDocumentItem.SalesOrder = _MaterialDocumentItem.DeliveryDocument then _docflow.PrecedingDocument when _MaterialDocumentItem.SalesOrder is null or _MaterialDocumentItem.SalesOrder = '' then _SalesOrderItemFromDelivItem.ReferenceSDDocument else _MaterialDocumentItem.SalesOrder end as SalesOrder AS SalesOrderendasSalesOrder,
  _MaterialDocumentItem.OrderID AS OrderID,
  _MaterialDocumentItem.OrderItem AS OrderItem,
  _MaterialDocumentItem._MfgOrder.ManufacturingOrderCategory AS OrderCategory,
  _MaterialDocumentItem._MfgOrder.ManufacturingOrderType AS OrderType,
  _PurchaseOrderItem._PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrderItem._PurchaseOrder.PurchaseOrderSubtype AS PurchaseOrderSubtype,
  _PurchaseOrderItem.PurchaseOrderCategory AS PurchaseOrderCategory,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  case when _MaterialDocumentItem.SalesOrder is null or _MaterialDocumentItem.SalesOrder = '' then cast(_SalesOrderItemFromDelivItem._ReferenceSDDocument.SalesDocumentType as abap.char(4)) else cast(_MaterialDocumentItem._SalesOrder.SalesOrderType as abap.char(4)) end as SalesOrderType AS char4endasSalesOrderType,
  _MaterialDocumentItem._Supplier.AuthorizationGroup AS SupplierAuthznGrp,
  _MaterialDocumentItem._Customer.AuthorizationGroup AS CustomerAuthznGrp,
  _MaterialDocumentItem._StorageLocation.IsStorLocAuthznCheckActive AS IsStorLocAuthznCheckActive,
  _MaterialDocumentItem._IssuingOrReceivingStorageLoc.IsStorLocAuthznCheckActive AS IsIssgOrRcvgStorLocAuthChkActv
FROM I_MaterialDocumentRecord AS _MaterialDocumentItem
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader AS _MaterialDocumentHeader ON MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentHeader.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesOrderItem ON _MaterialDocumentItem.SalesOrder = _SalesOrderItem.SalesDocument AND _MaterialDocumentItem.SalesOrderItem = _SalesOrderItem.SalesDocumentItem AND ( _SalesOrderItem.SDDocumentCategory = 'C' OR _SalesOrderItem.SDDocumentCategory = 'H' OR _SalesOrderItem.SDDocumentCategory = '' )  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentItem AS _SalesOrderItemFromDelivItem ON DeliveryDocument = _SalesOrderItemFromDelivItem.DeliveryDocument AND DeliveryDocumentItem = _SalesOrderItemFromDelivItem.DeliveryDocumentItem AND ( _SalesOrderItemFromDelivItem.ReferenceSDDocumentCategory = 'C' OR _SalesOrderItemFromDelivItem.ReferenceSDDocumentCategory = 'H' )  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _SalesItemCategory ON SalesDocumentItemCategory = _SalesItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_DeliveryDocumentItem AS _PurgOrderItemFromDelivItem ON DeliveryDocument = _PurgOrderItemFromDelivItem.DeliveryDocument AND DeliveryDocumentItem = _PurgOrderItemFromDelivItem.DeliveryDocumentItem AND _PurgOrderItemFromDelivItem.ReferenceSDDocumentCategory = 'V'  -- association [0..1]
LEFT OUTER JOIN I_ExsTxPurOrderHistory AS _MaterialDocumentItemPO ON _MaterialDocumentItem.PurchaseOrder = _MaterialDocumentItemPO.PurchaseOrder AND _MaterialDocumentItem.PurchaseOrderItem = _MaterialDocumentItemPO.PurchaseOrderItem AND _MaterialDocumentItemPO.PurchasingHistoryDocumentType = '6' AND ( ( _MaterialDocumentItem.DebitCreditCode = 'S' AND _MaterialDocumentItem.IsReversalMovementType = '' AND _MaterialDocumentItemPO.DebitCreditCode = 'H' ) OR( _MaterialDocumentItem.DebitCreditCode = 'H' AND _MaterialDocumentItem.IsReversalMovementType = 'X' AND _MaterialDocumentItemPO.DebitCreditCode = 'H' ) ) AND ( ( _MaterialDocumentItemPO.DebitCreditCode = 'H' AND _MaterialDocumentItemPO.IsReversalMovementType = '' ) OR( _MaterialDocumentItemPO.DebitCreditCode = 'S' AND _MaterialDocumentItemPO.IsReversalMovementType = 'X' ) ) AND _MaterialDocumentItem.PurchaseOrder is not null AND _MaterialDocumentItem.PurchaseOrder != '' AND ( _MaterialDocumentItemPO.StorageLocation != '' AND _MaterialDocumentItemPO.StorageLocation is not null ) AND ( _MaterialDocumentItem.IsAutomaticallyCreated is null OR _MaterialDocumentItem.IsAutomaticallyCreated = '' ) AND ( _MaterialDocumentItem.DeliveryDocument is null OR _MaterialDocumentItem.DeliveryDocument = '' OR( _MaterialDocumentItem.DeliveryDocument = _MaterialDocumentItemPO.DeliveryDocument AND _MaterialDocumentItem.DeliveryDocumentItem = _MaterialDocumentItemPO.DeliveryDocumentItem ) OR( _MaterialDocumentItem.DeliveryDocument != _MaterialDocumentItemPO.DeliveryDocument ) )  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentProcessFlow AS _docflow ON _docflow.SubsequentDocument = _MaterialDocumentItem.DeliveryDocument AND _docflow.SubsequentDocumentItem = _MaterialDocumentItem.DeliveryDocumentItem AND _docflow.SubsequentDocumentCategory = 'J' AND _docflow.PrecedingDocumentCategory = 'C'  -- association [1..1]
;