I_EXCISETAXMATLDOCITEM
MatlDocItem for Industry Excise Tax
I_EXCISETAXMATLDOCITEM is a CDS View in S/4HANA. MatlDocItem for Industry Excise Tax. It contains 56 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ExciseTaxMatlDocItem | view | from | COMPOSITE | MatlDocItem for Industry Extensions |
Fields (56)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | MaterialDocument | MaterialDocument | 1 |
| KEY | MaterialDocumentItem | MaterialDocumentItem | 1 |
| KEY | MaterialDocumentYear | MaterialDocumentYear | 1 |
| Batch | Batch | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CostCenter | CostCenter | 1 | |
| CreationDate | CreationDate | 1 | |
| CreationTime | CreationTime | 1 | |
| Customer | Customer | 1 | |
| CustomerAuthznGrp | CustomerAuthznGrp | 1 | |
| DebitCreditCode | DebitCreditCode | 1 | |
| DeliveryDocument | DeliveryDocument | 1 | |
| DeliveryDocumentItem | DeliveryDocumentItem | 1 | |
| DocumentDate | DocumentDate | 1 | |
| EntryUnit | EntryUnit | 1 | |
| GoodsMovementReasonCode | GoodsMovementReasonCode | 1 | |
| GoodsMovementRefDocType | GoodsMovementRefDocType | 1 | |
| GoodsMovementType | GoodsMovementType | 1 | |
| GoodsRecipientName | GoodsRecipientName | 1 | |
| IsAutomaticallyCreated | IsAutomaticallyCreated | 1 | |
| IsIssgOrRcvgStorLocAuthChkActv | IsIssgOrRcvgStorLocAuthChkActv | 1 | |
| IsReversalMovementType | IsReversalMovementType | 1 | |
| IssgOrRcvgBatch | IssgOrRcvgBatch | 1 | |
| IssgOrRcvgMaterial | IssgOrRcvgMaterial | 1 | |
| IsStorLocAuthznCheckActive | IsStorLocAuthznCheckActive | 1 | |
| IssuingOrReceivingPlant | IssuingOrReceivingPlant | 1 | |
| IssuingOrReceivingStorageLoc | IssuingOrReceivingStorageLoc | 1 | |
| Material | Material | 1 | |
| MaterialBaseUnit | MaterialBaseUnit | 1 | |
| OrderCategory | OrderCategory | 1 | |
| OrderID | OrderID | 1 | |
| OrderItem | OrderItem | 1 | |
| OrderType | OrderType | 1 | |
| OriginalMaterialDocumentItem | OriginalMaterialDocumentItem | 1 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| PurchaseOrder | PurchaseOrder | 1 | |
| PurchaseOrderCategory | PurchaseOrderCategory | 1 | |
| PurchaseOrderItem | PurchaseOrderItem | 1 | |
| PurchaseOrderItemCategory | PurchaseOrderItemCategory | 1 | |
| PurchaseOrderSubtype | PurchaseOrderSubtype | 1 | |
| PurchaseOrderType | PurchaseOrderType | 1 | |
| QuantityInBaseUnit | QuantityInBaseUnit | 1 | |
| QuantityInEntryUnit | QuantityInEntryUnit | 1 | |
| ReversedMaterialDocument | ReversedMaterialDocument | 1 | |
| ReversedMaterialDocumentItem | ReversedMaterialDocumentItem | 1 | |
| ReversedMaterialDocumentYear | ReversedMaterialDocumentYear | 1 | |
| SalesDocumentItemCategory | SalesDocumentItemCategory | 1 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| SalesOrderType | SalesOrderType | 1 | |
| StorageLocation | StorageLocation | 1 | |
| Supplier | Supplier | 1 | |
| SupplierAuthznGrp | SupplierAuthznGrp | 1 | |
| SupplyingPlant | SupplyingPlant | 1 | |
| SupplyingSupplier | SupplyingSupplier | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- MatlDocItem for Industry Excise Tax
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EXCISETAXMATLDOCITEM (
MATERIALDOCUMENT,
MATERIALDOCUMENTITEM,
MATERIALDOCUMENTYEAR,
BATCH,
COMPANYCODE,
COSTCENTER,
CREATIONDATE,
CREATIONTIME,
CUSTOMER,
CUSTOMERAUTHZNGRP,
DEBITCREDITCODE,
DELIVERYDOCUMENT,
DELIVERYDOCUMENTITEM,
DOCUMENTDATE,
ENTRYUNIT,
GOODSMOVEMENTREASONCODE,
GOODSMOVEMENTREFDOCTYPE,
GOODSMOVEMENTTYPE,
GOODSRECIPIENTNAME,
ISAUTOMATICALLYCREATED,
ISISSGORRCVGSTORLOCAUTHCHKACTV,
ISREVERSALMOVEMENTTYPE,
ISSGORRCVGBATCH,
ISSGORRCVGMATERIAL,
ISSTORLOCAUTHZNCHECKACTIVE,
ISSUINGORRECEIVINGPLANT,
ISSUINGORRECEIVINGSTORAGELOC,
MATERIAL,
MATERIALBASEUNIT,
ORDERCATEGORY,
ORDERID,
ORDERITEM,
ORDERTYPE,
ORIGINALMATERIALDOCUMENTITEM,
PLANT,
POSTINGDATE,
PURCHASEORDER,
PURCHASEORDERCATEGORY,
PURCHASEORDERITEM,
PURCHASEORDERITEMCATEGORY,
PURCHASEORDERSUBTYPE,
PURCHASEORDERTYPE,
QUANTITYINBASEUNIT,
QUANTITYINENTRYUNIT,
REVERSEDMATERIALDOCUMENT,
REVERSEDMATERIALDOCUMENTITEM,
REVERSEDMATERIALDOCUMENTYEAR,
SALESDOCUMENTITEMCATEGORY,
SALESORDER,
SALESORDERITEM,
SALESORDERTYPE,
STORAGELOCATION,
SUPPLIER,
SUPPLIERAUTHZNGRP,
SUPPLYINGPLANT,
SUPPLYINGSUPPLIER,
PRIMARY KEY (MATERIALDOCUMENT, MATERIALDOCUMENTITEM, MATERIALDOCUMENTYEAR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA